Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #46  
Old 05-21-2007, 05:42 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #47  
Old 05-22-2007, 03:14 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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 =)
Reply With Quote
  #48  
Old 05-22-2007, 08:46 AM
skeletalwarrior
Fire Beetle
 
Join Date: May 2007
Posts: 2
Default Great!

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

Last edited by skeletalwarrior; 05-22-2007 at 04:48 PM..
Reply With Quote
  #49  
Old 05-22-2007, 12:24 PM
Amra's Avatar
Amra
Hill Giant
 
Join Date: May 2006
Posts: 117
Default

Quote:
I'll upload the fixed items editor wed.
Chaos, It's not wednesday
Reply With Quote
  #50  
Old 05-23-2007, 12:47 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #51  
Old 05-23-2007, 04:19 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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 =)
Reply With Quote
  #52  
Old 05-25-2007, 03:24 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #53  
Old 05-25-2007, 05:34 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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 =)
Reply With Quote
  #54  
Old 05-26-2007, 06:33 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//

Last edited by GeorgeS; 05-26-2007 at 03:04 PM..
Reply With Quote
  #55  
Old 05-26-2007, 09:38 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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
Reply With Quote
  #56  
Old 05-26-2007, 11:38 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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


__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #57  
Old 05-27-2007, 10:16 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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)
Reply With Quote
  #58  
Old 05-28-2007, 04:44 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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

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

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #59  
Old 05-28-2007, 05:05 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

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
Reply With Quote
  #60  
Old 05-29-2007, 04:42 AM
Vulok
Fire Beetle
 
Join Date: Mar 2005
Posts: 24
Question

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,
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:29 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3