Updated Tool - EqItems Item Editor

[GeorgeS]

--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

[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

[John Adams]

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.

[John Adams]

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.

[GeorgeS]

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

[John Adams]

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!

[GeorgeS]

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

[Foin]

I love your item editor i was wondering if you could load all the items like mangoos editor did i really like his but it is very dated now

[GeorgeS]

The items table would take several gigs of memory - no way that can be loaded in and it may not run on older PC's. Also the MySQL should respond without lag at all, except for a few rare instances I've observed. There's no way to load in all data without a total rewrite - so sorry, not possible.

GeorgeS

[Xpeld]

I dont know if any 1 posted this as a bug yet , bit it seems when ya bring over clicky items into your toon , in game they dont work.
things with out charges , that shouldnt have charges , say they are out of charges + the ?right side items dont work .
and is there a way to make moveable mini windows for like the bankslots and bag area and such.
and i guess in my version the main window isnt adjustable?
just wondering if there was a way to make it scaleable .
other wise great job ! .

[GeorgeS]

regarding click items -
Actually this is not a bug as far as I can tell because my editor creates the entries correctly. This may be something else. I've never got these to work either.

The window cannot be made sizeable - this is something I designed. Resize your desktop resolution for 1280x1024

The little areas which display bag contents are fixed bitmaps.
All these were designed to be that way - to not be moveable.

Remember to remove an item in inventory right click on it. To add an item you drag drop the description icon (top of page) to the empty slot. This is documented in the help

GeorgeS

[mastajon]

im getting the mysql database connection error, i installed the odbc and fixed the db.ini for my db but it still wont connect. any idea where im going wrong.

[mastajon]

also my db.ini is the following:

host=localhost
user=eq
password=*****
database=peq
everquest_folder=C:\Everquest

[GeorgeS]

Download this tool
http://www.georgestools.eqemulator.n...connection.zip
and see if you can connect.


GeorgeS

[mastajon]

Originally Posted by GeorgeS

Download this tool
http://www.georgestools.eqemulator.n...connection.zip
and see if you can connect.


GeorgeS

i figured it out, i forgot to do one mysql command...... doh!