Updated Tool - EqItems Item Editor
 

Finished this mamoth work today, and it runs stably.

What is this program?
EQITEMS does several things -

-Search for items in the database by search criteria
-Edit any item by a variety of parameters
-Create new items by modifying pre-existing items as templates
-Load any character on your server to view and edit equipped (worn only) items.

Well try it out, let me know if it crashes and what the circumstances were.

download link - http://wizardportal.dyndns.org/eqemu...ml/eqitems.zip
old help file link - http://wizardportal.dyndns.org/eqemu...p/Eqitems.html

links to main site
http://wizardportal.dyndns.org/eqemu/eq.html


GeorgeS

Some databases do not include DBversion info in field varname in Table variables. Download new version - that should fix any errors during start-up.

Everquest Item Editor and Character Inventory Editor 9.506 , Latest 9/5/06
-Fixed startup error due to some databases missing DBversion in field varname


GeorgeS

Link isn't working to download, server down maybe?

Yes, windows rebooted the machine after an update.
Thanks for letting me know

GeorgeS

Thank you sir. Much appreciate that you made this tool.

Hrmm, I can't get it workin for the life of me. I run register_ocx. I edit the db.ini setting to:
host=192.168.1.101
user=moydock
password=*********
database=eq
everquest_folder=null

and i get that same message every time i try to launch, "MYSQL connection FAILED! Did you edit db.ini?", any idea? I also tried launching it on the server using localhost as the host.

Did you set up an ODBC connection?

Make sure you installed my MYODBC drivers first - that's usually the main issue.


Also, since you're using a 192.168.x.x ip address, refer to my help at the middle/bottom of the page for this.

http://wizardportal.dyndns.org/eqemu/eq.html


Do any of my others utlities work for you?


GeorgeS

Ahh okay, i just had to install the drivers. Thanks a bunch. Just started playing with it and wow man, amazing job. Quite the upgrade from the last item editor i was using!

Excellent work!

There is only one problem I have found so far. One Hand Slashing weapons do not show up on my lists. Has anyone else seen this problem or is it just me?

Thank you

Thanks for the bug report!
<bonks himself on the head>
1HS weapons now show - forgot they are itemtype=0...

Updated ver. is online. Also source is now being made available too...

GeorgeS

Fixed the initial issues I was having.. however - noticed that there's no way to view and edit items in inventories (unless I'm missing something). Overall - very impressed!

Sorry about back to back posts - but couldn't edit my original post.. what I was referring to is that I am unable to change/edit anything in my inventory slots or the bags in those slots. The main thing I'm interested in is changing around stat food and/or copying editing said items.

Currently it does not edit inventory slots. What I am looking at is adding this functionality, however I am decoding/decrypting the inventory info now, and depending on how sucessful I am, I will implement this feature.

GeorgeS

Not working to me while trying to connect to a remote database. Im sure I have access to it as well.

please read about connecting to a remote DB on my site - all's explained there.

http://66.159.225.58/eqemu/eq.html

Also - you did install myODBC drivers?

GeorgeS

http://img189.imageshack.us/img189/8632/339cb7.png

Got that after the splash screen.

in the resources folder run register_ocx.bat - that will fix dll registrations

GeorgeS

Work log as of Oct 14th

Managed to figure out personal inventory and bank and bag slots. This means you will eventually be able to equip and manage characters better. i.e be able to place stuff in bags...

This is pretty challenging because I have to code a inventory manager that interfaces with the db. It's pretty daunting.

Current version displays personal inventory, bank and bag slots, but it's only read only.

I'll let ya all know when this next update is ready...

GeorgeS

Ok, all is well and the new version is done. It was pretty hard to get this one working, but it's available for DL.

This version sports -

Personal, Bank and Bags are fully editable (read/write/delete).
You can fully equip a character from bank and personal items now.
You can add bags and fill them with items.
Augmented item stats are preserved whether they are on the character, or in a bag etc...
Searches are saved to disk
Misc tab now pulls out all items from db sorted by name. Then you use a filter to refine the list.
Want to find all regen+1 items for a necro? - Simple with this editor...
Looking for a +350hp +350mana cloak for a Cleric? - one query and your'e done.
Want a +500hp helm? - you can make this item easily

Because of the endless possibilities this program has, you can do quite a lot, (the help is online and updated frequently)


Remember, use my backup program to back up your _character and inventory tables in case something get's borked.

GeorgeS

Hey thanks George, this Item Editor is the nicest I have seen. Check your PM's btw. Keep up the good work.

Question about a problem I am running into. ( Probably me being a noob ) I added click effects to two items on my server. One was Summon Bandages. Other is summon Arrows. In game they say Effect: Summon: Arrows ( Unknown Activation)

What did I do wrong? :)

Edit: Clicktype field needed to be changed manually. Fixed the items :)

Hey GeorgeS,

Is there any way I can con you into makeing Shroud race available on the list?
Currently your editor doesnt show them, although if you pull up an item in it that is shroud only: It lists the race as ID# 32768 (1 above All, i believe)

It might sound like a wierd request, but I have a few items I was wanting to see if I could make All player races + shroud. (I can only assume the race # I'd need is 65535: the All (32767) + Shroud (32768), but I don't really know much about that part of the dBase yet.)

As far as I can tell, all non-player races are considered as being under the Shroud field (at least the 3 or 4 i tested). So, if this is possible, it might be a good way to add non-standard races into a server for anyone who is interested.

I just looked into the database, and the race field byte 'was'
15 bits long, so I will use bit 16 as the shroud race after froglok (bit15)
This will make it so the 65535=inlcude all races

Expect to have this included in the next release..

In the meantime, manually edit the race byte to 65535 (or 32768) in my program.


GeorgeS

...thanks for helping make this a better tool

Finished this request - Shroud is now a race (makes it 16bits) now.
ALL races=65535
You can run this script to make global changes to add the shroud race to existing items previously that were 32767


update items SET race=65535 WHERE race=0 OR race=32767;




Also fixed a few minor issues, DL this version 10.19.0

I'm also considering adding the ability to load any Magelo Characters.

GeorgeS

Added Loading of any Magelo Characters. This was a big job trying to create a javascript parser, but it works well and I already loaded in many characters.

It will load the magelo character's worn items and any bank items incl. bags and items within them.


GeorgeS

omg you are a life saver, George. I was just starting a parser script to do that same thing. started out parsing the txt file it dumps, and thought how much better it would be to just parse the profile by ID.

Thank you!

I ran to try this soon as I had a moment. Got the tool installed, registered the OCX, myODBC 3.5 installed, and connect fine. I think the tool is working like normal. So I got to import the Magelo, and it pulls what looks like some different skinned EQRankings site (not brown, but lite blues). Thought they changed something, but the actual site looks the same.

Anyway, I get to my profile, pop it up, and try to import the character, and nothing happens. Says it did it ok, but no char data. Am I doing something wrong?

--Make sure you load in a character first. Then run the magelo parser

edit - just checked without loading a character and it parses ok and load the items fine.

Make sure you browse to
http://eq.testmagelo.com/do_ranking.jspa?classeId=11

or in my program connect to the server by clicking on 'Bowse Magelo Profiles (www)' either way it must be the new magelo format.

Any other Magelo server (old format) will not work. Only the new format will work. Use URL I showed above. The old one has different javascript and the tags will not be found by the parser

GeorgeS



GeorgeS

The parser is pretty complicated as it has to handle bags and items within them. I spent a good part of a week figuring the links out. Magelo also is close to the eqemu db format for bags and bank inventory, but the bag contents 'slot id's' are not the same as eqemu. That was a hard one to figure out.


Actually, I loaded in some pretty cool characters I found on magelo, and made a pretty naked necro very uber.

Just FYI, the function I wrote that parses out magelo id's is

Function find_itemnumber(i As Integer, itemnum As Long)

iitem$ = "items[" & i & "] = new Item("
srch_len = Len(iitem$)
srch_end$ = ",'"

first_find = InStr(1, magelo.Text, iitem$, vbTextCompare)
If (first_find) Then
last_find = InStr(first_find, magelo.Text, srch_end$, vbTextCompare)
itemnum = Mid(magelo.Text, first_find + srch_len, last_find - (first_find + srch_len))
Else
itemnum = 0
End If

GeorgeS

Ahhhh, I did not load a character first, George. My bad. I will try again tonight, see what I get. Thanks! Here I was going to use it to import my own 5 accounts worth of toons - but you made me realize, I can be ANYONE on Magelo muhahahaha!!

Ok, not that exciting, but very cool nonetheless.

Hrm. I am not successful using this tool.

I am loading a character first, then browsing to the testmagelo site, then popping up the magelo profile window (the small popup), clicking Decode, and nada... I do not see anything showing up in the slot boxes on the main EQItems page. Should I?

Here's the profile I am testing with, on a character with the same name in the character_ database already: http://eq.testmagelo.com/profile/1239138


Also, a suggestion: Can you make your windows non-modal, or allow minimize? makes it nearly impossible to see around them. :)

Ah I see what your doing wrong,

When the new explorer window pops up (showing your character and his stuff), you must right click to the right of the character name "Raahvin" and select "View Source" - Copy the java source and paste this into the little black window (text box) above the button "Decode and Load". So you see, this text box now has the java script source which my program uses for decoding...

Also, see the help with the program (in main window screen) - "View Online Help" button.

Anyway, I loaded your character in fine - so let me know how it goes.

GeorgeS

Ahh!! Yes, there it's working fine. I am very sorry for not reading the help. I normally am not this helpless. :) It works like a champ. I was actually wondering how you managed to hook to the popup window and parse it. But now I see, you do not. Very nice. Works like a champ!

Earlier on I managed to link to the magelo site by sending the page to a string variable. But for some weird reason, vb6 does not work with this type of site - perhaps because of the javascript. Thus manual copying and pasting was necessary.

GeorgeS

i am not that familiar with VC6, but does it support an fopen(url) kind of process, that you can then read that data into a buffer and parse it? You could then tell the user to simply enter their MageloID and behind the scenes grab the page, parse, and stuff. I do this with PHP, but hadn't tried with any other scripting language.

Here's fragments of a typical web page parser I use for PHP, for example:

error
 

hmm. Perhaps im not doing it right but... I get this error. I have the drivers installed and edited the db.ini as you said. Just reinstalled the server today using Cavedudes database and such.

Run-time error '76':
Path not Found

maybe im still a little noobish as this or somethin. Any suggestions?

Make you you run register_ocx.bat in /resources/ folder.

Also make sure you update the server to be at least 0.7.0.840 complient, as I do not remember if it works with plain vanilla 0.7.0
Lastly, I just uploaded a new version which drops a control that was unused previously. May not make a difference though.


GeorgeS

ALso, paths seem to need an ending slash c:\path\ in some of the tools.

Shadowvax, when extracting the file (with winzip i'm assuming) make sure to enable "use folder names"

I had the same problem as you.