Updated Tool - EqItems Item Editor

[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

[John Adams]

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:

/* 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()

[ShadowVax]

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?

[GeorgeS]

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

[Rhodan]

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

[chestbuster]

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

I had the same problem as you.

[GeorgeS]

Originally Posted by chestbuster

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

Originally Posted by chestbuster

I had the same problem as you.

Correct, this can happen depending on your unZIPper program settings.


GeorgeS

[skeletalwarrior]

Im unable to copy items it seems to crash the program.

This happens after i click the edit item button then click copy... the program stops responding.
Then when i re-open the program and search for the item the copy is there but clicking it gives me:

Run-time error '-2147467259' (80004005)
Data provider or other service returned an E_FAIL status

I am using the PEQ database and EQEmu-0.7.0-992

my db.ini is

host=localhost
user=root
password=********
database=peq
everquest_folder=C:\Program Files\Sony\EverQuest

[ChaosSlayer]

i have same problem
I can edit item, but when i am tryign to COPY, it will create a new item (and save into DB) but when I try to access it - the whoel thing crashes.

(BTW i have identical problem in all other editors - loot editor, npc editor, spawn editor - i can edit existing values but cannot create new things.)

Only Spell Editor allows me to actualy make new items wihout crashing (it does gives weird error message in german some times due to unknown reasons)

Another thing- in item editor lots of important things not reflect at all, such as:

-Deity choices for item
-Skill choices for weapons (like 1hb)
-No bane dmg/magic dmg
-No item prices
and few others
you can still do expert edit on all the value but its a bit uncomfortable =)

[GeorgeS]

Thanks for the report. Im in Maui right now, so I may have time to look at this after happy hour

Also, what MySQL version you all running?

GeorgeS

[ChaosSlayer]

I have installed mysql-essential-5.0.37-win32.msi
and my emulator is whatever the latest version is curently up for download. (7 i belive)

my errors are identical in all the editors (which i presume made by you) it has soemthing to do with improper call send to sql DB when trying to create a new item

as i said it mostly edits fine, with exeption of Loot Tables editor and Spawn Tables editor- when trying to edit those they crash and delete whatever values i was trying to edit

Editing NPC stats (wihout touching loot or copy) - works fine. Same goes for item editor