Updated Tool - EqItems Item Editor

[GeorgeS]

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 3276 in my program.


GeorgeS

...thanks for helping make this a better tool

[GeorgeS]

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

[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