Updated Tool - EqItems Item Editor

[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

[John Adams]

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!

[John Adams]

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?

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

[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

[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