\aITEM 1422062799 -786915591:Darkened Jewel of Kurn\/a
Dropped by
Thovalakk (Kurn's Tower: Breaching the Void)

\aITEM -1949254009 1414321847:Jewel Inlaid Fang\/a
Dropped by
Lord Marcus Thex (Evernight Abbey)


Appearance gear:

\aITEM -1427948196 -173744074:Glass Wand of Emptiness\/a
Dropped by
Ferzhul (Palace of Ferzhul)
Mewaye (Palace of Ferzhul)


Owen

okaltenb wrote:

And Check found a bug. If you add a category (say healer items) and then remove that category it resets all ready/want flags. Even ones outside of that category. Owen

I've been playing whack-a-mole with that bug for a few days now. I think you may have just given me something I can repeat to test this with though. Still not sure why it's doing what it's doing but if I can repeat it, I can fix it. Thanks!

Check wrote:

okaltenb wrote: And Check found a bug. If you add a category (say healer items) and then remove that category it resets all ready/want flags. Even ones outside of that category. Owen I've been playing whack-a-mole with that bug for a few days now. I think you may have just given me something I can repeat to test this with though. Still not sure why it's doing what it's doing but if I can repeat it, I can fix it. Thanks!

WOW! Talk about a serious brain cramp! I stared right at that bug and refused to see it for days. lol. Should be fixed now. Being able to repeat it was all it took. Thanks!

Technobable:

Had an update statement that said something like this:

Code::

$sql = "UPDATE ".$prefix."_table1 t1 INNER JOIN ".$prefix."_table2 t2 SET t1.field1='2' WHERE t1.field1='1' and t2.field5 like '".$text."%'";

I looked all over to try and find the problem. Thought maybe the text I was matching on wasn't being returned right or some string concatenation stuff was going wrong, etc. Finally I put in some debug code to spit out the SQL statement to me when it did that command and it spit it out something like this:

Code::

UPDATE db_table1 t1 INNER JOIN db_table2 t2 SET t1.field1='2' WHERE t1.field1='1' and t2.field5 like 'text%'

Finally it jumped out at me. This SHOULD have looked like this:

Code::

UPDATE db_table1 t1 INNER JOIN db_table2 t2 ON t1.pkField = t2.pkField SET t1.field1='2' WHERE t1.field1='1' and t2.field5 like 'text%'

I didn't put in any text on how the two tables should be joined. Duh. Can't remember ever doing THAT before. I must be slipping.

You may notice in the Zone / Need Tracker that I'm at it again. I had an idea last night and whipped something up today. Spells / Combat Arts. It's not wired up to save any of the checkboxes or radio buttons on the page yet but that's next. Gonna help me out with my alts especially once I get everything worked out. The Tiers are set right now just based on the level of the Spell / CA. I intend on setting these to their proper tier once I have it all working so for example, some level 50 spells may be T5 and some T6 depending on the rare they take. I may also end up adding which rare is needed on the line for each Tier once I get the rest of it working. It only shows the spells for a given character that haven't been replaced by other spells yet and there is a separator to show Future Spells / CAs if the character isn't at level cap yet. The Upgrade Priority block is just so you can save which ones you want to upgrade first, second, third, and not at all. Mainly for your own purposes, set it how you'd like (once saving is coded that is).

What I don't have yet is a list for each class showing me what the Grandmaster choices are. I'd like to only display the GM radio button if it's actually a choice. Anyway, time to head home from work.

And yes, I really did enter the spells/combat arts into a database on the webserver. All 3,848 of them. lol

Grrr...I spent over 2 hours doing something like this for one toon last night.

www.adventofvalor.com/w/Cliodne

And now he's automated it when he told me last night he wasn't gonna automate it.

I love you too Check.

Hugs,
Susan

rednomore wrote:

Grrr...I spent over 2 hours doing something like this for one toon last night. www.adventofvalor.com/w/Cliodne And now he's automated it when he told me last night he wasn't gonna automate it. I love you too Check. Hugs, Susan

I said I wasn't going to automate it on the Wiki like I did the last time. That was a major pain. Now that I know how to code on the website though with an actual database, that's a different story.

okaltenb wrote:

\aITEM 1422062799 -786915591:Darkened Jewel of Kurn\/a Dropped by Thovalakk (Kurn's Tower: Breaching the Void) \aITEM -1949254009 1414321847:Jewel Inlaid Fang\/a Dropped by Lord Marcus Thex (Evernight Abbey) Appearance gear: \aITEM -1427948196 -173744074:Glass Wand of Emptiness\/a Dropped by Ferzhul (Palace of Ferzhul) Mewaye (Palace of Ferzhul) Owen

All the items you listed above should now be in the database Owen. Thanks for the list!

For anyone who is interested, this is basically what I need in order to put a new item into the database and the format that I'm using: Classes, Item Name, Zone Name, Links, Reason Text:

Code::

Mage Charm - Jewel Inlaid Fang Evernight Abbey Mage Charm <a href="http://www.lootdb.com/eq2/item/-1949254009">LootDB</a> \aITEM -1949254009 1414321847:Jewel Inlaid Fang\/a

For those that would like to make my life much easier for future items, put a [ then code then ] (no spaces). Then put the five lines for each item like above and end it with [ then /code then ].

For those unfamiliar with how html works, in the list above you see <a href=" then paste in the link from the address bar of lootdb while looking at the item, then ">LootDB</a>. Then just paste the in-game link to the item.

The next to last line where it says "Mage Charm" is something that needs made up that will make sense in the Zone/Item Needs report. Should be the same text even if it shows up under more than one class, that way when you look at the report for a particular zone, if multiple classes want to go in there, you can tell they are after the same item.

Don't worry about it if this sounds too complicated, doesn't take me all that long to look it up and convert it into this info, it'll just save me a bit of time if its in this format.

Thanks for the links!

Fiddled with this a little more. T3 Shard Gear Progress is now included in the new dropdown list in the main menu of the module. It will now also let people see the progress of many of the other items being tracked.

Fiddling again. Things are now split up into categories. The quests and items will only show up when you have their coresponding category selected. This should make it easier to manage once I add more stuff. Also, some of the quests are collapsed and only show a certain level deep. There is an [Expand] link to show the hidden stuff. Also, gear is no longer shown in the Guild Zone Needs report. It was getting so big it was unusable. Now only quests are shown there. The My Zone Needs report still shows the gear like it did so you can use it to keep track of where you want to go. There may be a few other things changed but can't remember right now.

I plan on putting in the Heritage Quests and a few other things when I get the time.

I have the Heritage quests in there now but have only put the info in there for the first 5. Saying you want or are ready for the HQ right now doesn't make it show up in the Guild Zone Needs report (I can change that though once I get the rest of the data in). Saying you are ready for a particular step under the quest does.

Here's the plan. I want to add the steps to each HQ where someone might need a group to continue if they were doing the quest on level. Sure, you may be able to mentor down from 80 and solo Octogorgon in Cove of Decay but it still requires a group on level. So, for example, for Return of the Light, I've got these steps:

Kill the Lightbringer Wisp
Kill Rama'nai
Kill Captain Ogof and Captain Gaer
Kill High Priest of Val'Marr
Kill General Drull

By having these steps listed it allows someone to say that they are ready for one of these steps and it will show up in the Guild Zone Needs report. I'm hoping to get some decent use out of this once the expansion comes out, guild level jumps to 90, and we start working on the status.

So... anybody bored that wants to go through the other 33 for me? Or maybe some of them? If not I'll start on it myself.