Updated Tool - EqItems Item Editor

**GeorgeS** · #1 11-01-2006, 03:01 PM

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 · #2 11-02-2006, 07:00 AM

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 · #3 11-02-2006, 12:03 PM

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** · #4 11-02-2006, 02:11 PM

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 · #5 11-03-2006, 12:16 AM

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** · #6 11-03-2006, 03:03 AM

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

John Adams · #7 11-03-2006, 07:33 AM

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:

Code:

/* open the page $url */
$rslink = @fopen($url,"rb");

/* load into a buffer */
while(!feof($rslink)) {
  $this->rsBuffer .= @fread($rslink,1024);
}

/* parse the buffer using regex, or however you do now */
function ParseBuffer()

Foin · #8 08-06-2007, 09:03 AM

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** · #9 08-06-2007, 01:44 PM

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 · #10 08-07-2007, 01:00 AM

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** · #11 08-08-2007, 02:18 AM

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 · #12 10-02-2009, 12:31 AM

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.