Quote:

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

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


GeorgeS

can't copy items
 

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

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

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

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

Ok I went through the code and found a potential source of error from where the program writes date fields in the items table. For whatever reason MS VB crashes there. I added some code to prevent this and now it works fine. I'll upload the fixed items editor wed.


Regarding the loot editor issues - I was not aware of those. PM me with details so I can trace the error. In fact any errors should be reported.

GeorgeS

I don't know if you have update Item Editor downlaod on your site after fixes, cuase i just re-donwloaded and stil have same errors.

I have PM you a complite error report.
thanks =)

Great!
 

Thanks a lot man I've been using this editor because its the only way I can see images of items while I

Chaos, It's not wednesday :-D

Everyone who experiences this error is running MySQL ver 5.x ?
I'm on 4.x, so I will have to go from there. I've posted the "fix" already, and it's wed. already :)
Let me know if the itemeditor works now for you.


GeorgeS

updated editor works nicely
big thanks =)

if you also be so kind to fix same error in NPC and Spawn editors you will be my personal Tunare =)

I will even name mob after you in my custom world =)

Re- NPC & LOOT EDITOR

Ok, finally made changes to the code so that different npc_types table schemas do not mess things up.

So copying NPC's works or at least it should.

Issues with loot's have not been fixed yet, but I'm working on that now.
If you have problems with creating or modifying loot drops, please show me the field names in the following tables -

`lootdrop_entries`
`loottable`
`loottable_entries`

You can DL the newest version now

GeorgeS

i just checked it
Copy NPc indeed works

when trying to save loot tables produces mySQl eror (liek before) and crashes

Tables in mySQl you asked for:

`lootdrop_entries`
lootdrop_id
item_id
item_charges
equip_item (this btw do not work in game - even mobs who have their items set to equip DO NOT actualy wield them, or items are invisable, cuase NPC do perform proper animation for axes, spears etc, but wihout actual weapon visible)
chance



`loottable`
id
name
mincash
maxcash
avgcoin (whats this one do? all mobs i look at have this at 0)


`loottable_entries`
loottable_id
lootdrop_id
multiplier
probability

there is also Lootdrop table which has:
id
name (this seem to be the name of lootdrop set, like Decayign Sceleton Common etc)




One more thing, while you at it, a list of minor problems - in almost all the editors there is a problem I have:

-some of them DO NOT have a windows taskbar icon
-some of them cannot be minimazed
-some of them fall out of screen (this is specialy BIG problem with NPC editor as even if i set my resulution to the screen that is BIGGER than program window i still cannot see all the coulmns at same time cuase the program window ends soemwhere at 1280 pixels and any extra space on screen is blank. It would be nice to have a scroll bar on both horisontal and vertical =)

Item editor has a cool feature that its imposible to shot down - it does not have Taskbar icon AT ALL - the only way for me to exit it is go to task bar and do shut down operatin =)
It also suffers from falling out of screen problem (thought just by a little bit about 100 pixels)

Spawn Editor and merchant Editor- this two have an interesting feature of staying in memory and running invisible after you exit them =)

Ok thanks, I recoded the loot section and posted the update on my site. I hope it works for you now.

- the editor is resized to 1250x768 and should fit on 1280x1024 screens. I'm dropping support for 1024x768 since sizing issues make it hard to fix.
-The minimise buttons will appear next, and the memory loss will be fixed.


I'll work on the spawn editor next..

For that again, I'll need the fields you have for :
spawngroup
spawnentry
spawn2




Thanks
GeorgeS

the Loot tables now working- great job =)

(thought NPC still refuse to wield their weapons even when set to equip =(


tables your asked for

spawngroup:
id
name
spawn_limit


spawnentry:
spawngroupID
npcID
chance


spawn2:
ID
spawngroupID
zone
x
y
z
heading
respawntime
variance
pathgrid
timeleft
_condition
cond_value

Re-coded the save routine for spawneditor as well. That should work as well.

Item editor runs at 1280x1024 - because there's so much on the page, it had to be large to fit. There's no taskicon for some unknown reason to me. I use windows API DLL's to do the overlays. I'll look into a minimize button

So I hope the programs will work for you. I did a spawning tutorial on my site that uses both in game spawning techniques and my spawneditor in tandem.

GeorgeS

spawn editor seem to work fine, it saves data and does not crash.

The problem that it remains as running process after you exit it remain however.

Oh yeah just noticed that Quest Editor also does not have a task bar icon (working fine otherwise)

Ok, spawneditor should no longer be a TSR (terminate and stay) :)

Does anyone have any ideas or needs for a new tool ?

GeorgeS

i am always willing to load good programmer with work =)

would you consider making it a separate small char editor which will handle class, race, and whats more important deity, stats, AAs, skills etc



or on tradeskill editor:

mayby add a search so it don't load entire db every time
-put both recipe list and component detail onto same page

can't realy think about anything else right now - it seems that prety much everyhting is howered short of things that evil client has hard coded

Just curious, how does one activate the item effects. I am using the newest EQitems and everything works great so far, except.

Item Charges : 0 (Activation unknown)
Worn Effect : Also is down

Looked over these posts and the forums sorry if I missed it.

Thanks again,

another idea for you George, add material and color tint editing for your item editor =)

would be a great help at design time

I never messed with color/materials - how does it work?

If it's simple enough, I'll add it in


..regarding item charges et.al, I am not sure myself even how to get those to work either...

GeorgeS

the material part should be rather simple
the material simply goes from 1 to 16 and indicates difffirent apperances
this is so easy anyone could do this via advance options - just a number into material field.

the numbers are:

0=No Graphic
1=Leather
2=Chain Mail
3=Plate
4=Monk Armor
10=Robe1
11=Robe2
12=Robe3
13=Robe4
14=Robe5
15=Robe6
16=Robe7

(you can view this textures in game by setting mob to one of the player races and asigning it #texture 1 to 16)

so basicly just add extra to tem editing window where i could click select one of the types. idealy would be if it could also show in game apperance, but that you will prabaobly need to get few screenshots from in game.


Color part is esentialy a long digit number - what i am proposing is adding a color window (like in game you had for paiting your armor) where user could select combos of RBG and your program converts this to a single number as used by item DB (for exmaple look up numbers for Bronze BP and Fine Steel one for comparacen)

unfortunately i have no idea how RBG combo converts into that single number =)
in a worst case scenario just allow to pick like 10-15 basic colors - numbers for these can be tracked by examinign items which are well known in game for havign special tint (bronze - orange, Ivy - green, mihrtil- light blue etc)

For the color decimal number,
I think the RGB is in hex that you have to convert to a decimal number like $ff ff ff

where red is 00-ff green 00-ff blue 00-ff which gives you 0-255 for red 0-255 for green 0-255 for blue

so all red would be "ff 00 00" converts to decimal value 16711680

all blue would be "00 00 ff" equals decimal value 255

oh here is a good tool - in npc editor include an option to find and show all unused npc IDs from range X to Y

also add a search by npc ID, cuase when NPC do not belong to a spawn table, and you do not remember its name- there is no way to find it.

and mayby even find and list all npcs who do not belong to any zone spawn tables

Added by Request -
NPC Editor Tool ver - 6.7.07.01
-Searches by npc_id are now possible.
- You can now find a range of unused npc_id's under Tools/ Find available npc_id's from Range.

GeorgeS

Color tool is being looked at

great work GeogreS , thanks =)

what do you think about taking on a Spell Editor?
I know there are atleast 2 spell editors around (one from Windcatcher, and one from some german person, I belive) but I bet you can do better =)

the german spell editor is far easier to work with that the one by Windcatcher (or atleast that what it seems to me), its far more polished in terms of GUI and lots of special fields are explained (and it got very powerful search!!), but it does have a tendency to crush a lot (usualy after copying/adding a spell)

help
 

how do i check my original host (numbers) from my original mysql account?

I just downloaded your item editor and found your other programs on your page. Just wanted to say THANK YOU from a newbie to the eqemu server admin.

Any idea why, after installing the eqitems AND ODBC drivers, I would get an error as follows:
I get your splash screen, but then after hitting "Let's Start" it produces the above error.

My db.ini is as follows:
Thanks ahead of time.

Cheers,

jonogo

In Resources/ folder, run register_ocx.bat
This goes for all the tools - they use .dll's and .ocx and need to be registered.

A new version is coming soon that will enable one to equip Raid BOTS

GeorgeS

Most Excellent! thanks a ton Geroge, and I look forward to future updates!!!

-jonogo

Working well, except:

1. When you hit the cancel button on the save profile dialog it does not cancel but actually saves the profile you use as an examples (I think its mage_default).

2. Minor issue - Mage_mid profile - I used this on a bot and one of the items in the profile shows up as a tent or a lean-to? It's funny, but probably should be fixed. Might be DB specific though, I am using PEQ.

Other then that seems to work great. Much faster to equip an army of bots using this.

I changed the cancel button function so a cancel no longer saves.

Your database may differ slightly - this is expected. Items may not show as the correct items in a custom items table. Mine are based on AX.

Thanks for trying it out.

GeorgeS

item editor
 

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

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

clickys
 

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

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

I cant get any of these tools to work for me. I enter the correct information in the db.ini and have installed the drivers. I still get the error message: Run-time error '339'; "Component 'a.ocx' or one of its dependencies not correctly registered: a file is missing or invalid"

RTM... you need to register that file, which is in his README instructions on hwo to do that.