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,