Adding Items?

15 posts / 0 new
Last post
Linathor
Linathor's picture
Offline
Joined: 04/30/2009
Points: 365
Adding Items?
Newmoon
Newmoon's picture
Offline
Joined: 03/19/2008
Points: 1709
Hmmm

. . .good catch. Looks like the Items database page is definitely bugged out. I was looking at it a few days ago, so must be a recent weird thing. I'm looking into this today, and will post with update. Meanwhile, your quests/ stuff have been approved and added to db Lin. :)

Newmoon
Newmoon's picture
Offline
Joined: 03/19/2008
Points: 1709
Okay

Okay, Items Page fixed. :)

Linathor
Linathor's picture
Offline
Joined: 04/30/2009
Points: 365
Yay!

Well done, the page comes up immediately! Are we using MySQL for this site? (sorry, techy geek, just curious)... I was wondering if the DB was deadlocked or something. :)

Either way, thank you for getting to that ASAP! :)

Lin

Linathor
Linathor's picture
Offline
Joined: 04/30/2009
Points: 365
Two suggestions for Adding Items

Hi Newmoon, I have two other suggestions for adding items:

1. Sort the [Item Slot] list to be alphabetical (it appears to be sort of grouped in some manner, like order on the screen or something similar);

2. After submitting an item, have a link at the confirmation page to add another item (instead of clicking Items > Add an Item).

Do-able? :)

Lin

Newmoon
Newmoon's picture
Offline
Joined: 03/19/2008
Points: 1709
Good ideas

Are we using MySQL for this site? (sorry, techy geek, just curious)... I was wondering if the DB was deadlocked or something. Smiling

Yes, we're using MySQL. :) Have not had any real problems with it. However, we're also on shared hosting, so site accessibility and performance can sometimes be sub-par. Ah, the trials of the poor. ;)

1. Sort the [Item Slot] list to be alphabetical (it appears to be sort of grouped in some manner, like order on the screen or something similar);

2. After submitting an item, have a link at the confirmation page to add another item (instead of clicking Items > Add an Item).

That would be much more convenient, (add another item) and I'll have to see if it can be managed. Might be possible.

I'm unsure about alphabetizing, as I think I grouped them by similarity for convenience, but I'll consider you might be right. I'll ask everyone to be nice and add an item or two, test it out, and see what works best for all.

Urich
Urich's picture
Offline
Joined: 04/08/2008
Points: 1226
Two things

Heya, I just realized that the "required level" sections only accepts values 1-50. It won't accept anything higher level than 50. Looks like we missed that when upgrading the site for Moria.

Also, there isn't a section for the "duration" of right-click effects.

Other wise, it is looking good.

Newmoon
Newmoon's picture
Offline
Joined: 03/19/2008
Points: 1709
QA

Good catch. Gotta love the Quality Assurance on this site. ;)

Urich
Urich's picture
Offline
Joined: 04/08/2008
Points: 1226
One more thing. . .

I also realized while uploading the Shield-bearer's set, that armour can have proc effects too, but there isn't a section for proc effects on armour.

Also, the proc effect needs a duration section as well.

Linathor
Linathor's picture
Offline
Joined: 04/30/2009
Points: 365
And....

Can we have a built in auto-atlas with coordinate mapping and automatic nearest-point-of-interest calculator? Then maybe some automatically populating fields based on a Tolkien-lookup of item and place names? ;)

ok, I'll shut up now.

Lin
Crier of the Whispering Add-ons.

Velvyn
Velvyn's picture
Offline
Joined: 05/04/2008
Points: 485
The alphebaticalized thingimajig....

Yah, I uploaded some items, (the Minstrel Radience set,) and I found the item list to work just fine, actually. Didn't even realized it wasn't totally alphabetized. XD

Urich
Urich's picture
Offline
Joined: 04/08/2008
Points: 1226
Two more things. . .

Newmoon wrote:
I'm unsure about alphabetizing, as I think I grouped them by similarity for convenience, but I'll consider you might be right. I'll ask everyone to be nice and add an item or two, test it out, and see what works best for all.

Frankly, I'm quite used to the set-up we have at the moment. It works for me, as I tend to to think in terms of "what does this item type do?" rather than "What is the first letter of this item type?" but that's just me. It may overall work better alphabetized.

Also, I'm not sure exactly how it works, but I think that in some cases selecting the item type AND the slot is somewhat redundant. For example, if you choose item type "Ring" of course it is goes into the "Finger" slot. Rings never go anywhere else. This setup is still good for the armour types; "Armour: heavy" could go into many different slots like chest, head, and hands. I'm not sure if it is possible to make the slot section dependent on only the Armour types, but if you could, that might be a good idea.

That my two cents for the moment.

Newmoon
Newmoon's picture
Offline
Joined: 03/19/2008
Points: 1709
Finally

Linathor wrote:
2. After submitting an item, have a link at the confirmation page to add another item (instead of clicking Items > Add an Item).
Do-able? :)

Finally got this one. :)

Anyone who adds a Quest, Item, or Tip to the LOTROinfo database can cut out the tedious reloading from the top. There are now several options at the bottom of the submission form that read, "Save" "Preview" and the newly added "Save and Create Another" button that will save the information on the form and immediately reload the same type of form again, for easy submitting of several quests, items, or tips.

I knew I'd come through on this one. ;) :P

Fillmon
Fillmon's picture
Offline
Joined: 02/26/2011
Points: 87
Adding New Items

I noticed the Item list was quite small, so I'm going to be adding alot of new items to it. However, it will take quite some time.

Newmoon
Newmoon's picture
Offline
Joined: 03/19/2008
Points: 1709
Thank you

Fillmon wrote:
I noticed the Item list was quite small, so I'm going to be adding alot of new items to it. However, it will take quite some time.

Thank you for your contribution and time. :) Your recent item adds should be listed now.

Error | LOTRO info

Error

Error message

  • Warning: Cannot modify header information - headers already sent by (output started at /home/content/o/m/n/omnigonlotro/html/includes/bootstrap.inc:1191) in drupal_send_headers() (line 1039 of /home/content/o/m/n/omnigonlotro/html/includes/bootstrap.inc).
  • PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lotroinfo.video_files' doesn't exist: SELECT f.*, vf.vid, vf.nid, vf.dimensions, vf.status as video_status FROM {video_files} vf LEFT JOIN {file_managed} f ON vf.fid = f.fid WHERE vf.status = :vstatus AND f.status = :fstatus ORDER BY f.timestamp LIMIT 0, 5; Array ( [:vstatus] => 1 [:fstatus] => 1 ) in video_ffmpeg->load_job_queue() (line 490 of /home/content/o/m/n/omnigonlotro/html/sites/all/modules/video/transcoders/video_ffmpeg.inc).
The website encountered an unexpected error. Please try again later.