Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2010, 03:37 AM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

Can you send me a list of column names in your spells_new table?
Reply With Quote
  #2  
Old 07-14-2010, 01:47 AM
AudioGarden21
Sarnak
 
Join Date: Aug 2004
Posts: 80
Default

Certainly Null. And thanks for helping.

Going from left to right I have:

id
name
player_1
teleport_zone
you_cast
other_casts
cast_on_you
cast_on_other
spell_fades
range
aoerange
pushback
pushup
cast_time
recovery_time
recast_time
buffdurationformula
buffduration
AEDuration
mana
effect_base_value1
effect_base_value2
effect_base_value3
effect_base_value4
effect_base_value5
effect_base_value6
effect_base_value7
effect_base_value8
effect_base_value9
effect_base_value10
effect_base_value11
effect_base_value12
effect_limit_value1
effect_limit_value2
effect_limit_value3
effect_limit_value4
effect_limit_value5
effect_limit_value6
effect_limit_value7
effect_limit_value8
effect_limit_value9
effect_limit_value10
effect_limit_value11
effect_limit_value12
max1
max2
max3
max4
max5
max6
max7
max8
max9
max10
max11
max12
icon
memicon
components1
components2
components3
components4
component_counts1
component_counts2
component_counts3
component_counts4
NoexpendReagent1
NoexpendReagent2
NoexpendReagent3
NoexpendReagent4
formula1
formula2
formula3
formula4
formula5
formula6
formula7
formula8
formula9
formula10
formula11
formula12
LightType
goodEffect
Activated
resisttype
effectid1
effectid2
effectid3
effectid4
effectid5
effectid6
effectid7
effectid8
effectid9
effectid10
effectid11
effectid12
targettype
basediff
skill
zonetype
EnvironmentType
TimeOfDay
classes1
classes2
classes3
classes4
classes5
classes6
classes7
classes8
classes9
classes10
classes11
classes12
classes13
classes14
classes15
classes16
CastingAnim
TargetAnim
TravelType
SpellAffectIndex
field124
field125
deities1
deities2
deities3
deities4
deities5
deities6
deities7
deities8
deities9
deities10
deities11
deities12
deities13
deities14
deities15
deities16
field142
field143
new_icon
spellanim
uninterruptable
ResistDiff
dot_stacking_exempt
deleteable <--- noticed the typo on the database, should be deletable)
RecourseLink
field151
field152
field153
short_buff_box
descnum
typedescnum
effectdescnum
field158
field159
field160
field161
bonushate
field163
field164
field165
EndurCost
EndurTimerIndex
field168
field169
field170
field171
field172
HateAdded
EndurUpkeep
field175
numhits
pvpresistbase
pvpresistcalc
pvpresistcap
spell_category
field181
field182
field183
field184
can_mgb
nodispell
npc_category
npc_usefulness
field189
field190
field191
field192
nimbuseffect
field194
field195
field196
field197
field198
field199
field200
field201
field202
field203
field204
field205
field206
spellgroup
field208
field209
field210
field211
allowrest
field213
field214

That should do it. I hope it helps rectify the problem. And I hope I didn't make too many grammatical errors. =P

Let me know if you need anything else from me.

Cheers!
Reply With Quote
  #3  
Old 07-14-2010, 05:25 PM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

I think I see the problem, ill put up a new build after work tonight.
Reply With Quote
  #4  
Old 07-15-2010, 04:35 AM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default v1.1.9

Here is a new version that has updated table queries. I might make these queries pulled from a file in the future so I can avoid having to put up a new build every time a field name gets changed.

I am leaving up the previous version also (link is on the first post) for people who don't need/want to update their db version for whatever reason.

Null Spell Editor v1.1.9

Null Spell Editor v1.1.9 (no videos)

Enjoy!
Reply With Quote
  #5  
Old 07-15-2010, 06:42 AM
GaG
Fire Beetle
 
Join Date: Jan 2005
Posts: 13
Default

still does not work for me on newest db Rev it just wipes the table and stops
Reply With Quote
  #6  
Old 07-15-2010, 08:51 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Thanks for the update, Null! I will give it a shot this weekend

I am sure it was due to my change to identify the nimbus effect field out of the list of unknowns. I wish we knew more fields, but those higher ones are hard to figure out.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #7  
Old 07-15-2010, 10:55 AM
AudioGarden21
Sarnak
 
Join Date: Aug 2004
Posts: 80
Default

Thanks Null! It that fixed that issue!

However... (always that however in lurking somewhere, isn't there? =/ )

After testing the update a bit on two different PCs, I've discovered a few things I thought I should bring to your attention.

1. Creating a new spell via "copy" command and writing changes to the database works with both Firefox and IE on both PCs. But if you alter a spell, for instance just the name of the new spell AFTER you write the new spell to the database it will not change anything. This applies to all spells currently in the database already.

It appears that anything that already exists in the database is not being overridden when writing changes to the database. I think of all functions available with your editor, that one would be essential as it saves a lot of time having to export to Spell IO to make changes to any spells that already exist.

I'm not sure if this is an actual function of this feature, to re-write changes over existing spell entries, or not. But logic tells me that's the way you designed it to function. It just isn't, unfortunately.

2. This one is quite minor because there's an easy work around, but the bottom of the login portion (the reset and submit buttons specifically) of the editor is cut off on my 19 inch CRT monitor running 10x7 resolution. Changing my resolution to 16x12 certainly fixes that issue, but of course text is so small you practically have to face-plant the monitor to read entries in the database.

I don't have a problem on my laptop because it naturally runs a higher resolution than my desktop does, and that's the PC I use for my server. Like I said a minor issue.

Might I suggest a fix to widen the login screen horizontally, so it doesn't extend so much vertically? I think that would certainly fix any and all issues regarding different user resolution settings, and we all know that everyone has their preferences that vary as much as the people themselves.

Thanks again Null, you're the man!
Reply With Quote
  #8  
Old 07-15-2010, 03:05 PM
Null
Sarnak
 
Join Date: Mar 2010
Posts: 38
Default

Quote:
Originally Posted by GaG View Post
still does not work for me on newest db Rev it just wipes the table and stops
When you get to the login screen, does the version in the uper right hand corner of the login window say 'v1.1.9'?

Can you double check that the fields in your database are the same as the fields listed by AudioGarden21?

If they are, can you check that the user that are you using to log into mysql has proper permissions to insert/update?
Reply With Quote
  #9  
Old 07-15-2010, 05:06 PM
GaG
Fire Beetle
 
Join Date: Jan 2005
Posts: 13
Default

The version is v1.19, and im using Root to login the spell fields Look the same but i might of missed one so exported them from my db and Pasted em here,
btw thanks for the Super fast responce and all your hard word on this Fine Tool

`id`
`name`
`player_1`
`teleport_zone`
`you_cast`
`other_casts`
`cast_on_you`
`cast_on_other`
`spell_fades`
`range`
`aoerange`
`pushback`
`pushup`
`cast_time`
`recovery_time`
`recast_time`
`buffdurationformula`
`buffduration`
`AEDuration`
`mana`
`effect_base_value1`
`effect_base_value2`
`effect_base_value3`
`effect_base_value4`
`effect_base_value5`
`effect_base_value6`
`effect_base_value7`
`effect_base_value8`
`effect_base_value9`
`effect_base_value10`
`effect_base_value11`
`effect_base_value12`
`effect_limit_value1`
`effect_limit_value2`
`effect_limit_value3`
`effect_limit_value4`
`effect_limit_value5`
`effect_limit_value6`
`effect_limit_value7`
`effect_limit_value8`
`effect_limit_value9`
`effect_limit_value10`
`effect_limit_value11`
`effect_limit_value12`
`max1`
`max2`
`max3`
`max4`
`max5`
`max6`
`max7`
`max8`
`max9`
`max10`
`max11`
`max12`
`icon`
`memicon`
`components1`
`components2`
`components3`
`components4`
`component_counts1`
`component_counts2`
`component_counts3`
`component_counts4`
`NoexpendReagent1`
`NoexpendReagent2`
`NoexpendReagent3`
`NoexpendReagent4`
`formula1`
`formula2`
`formula3`
`formula4`
`formula5`
`formula6`
`formula7`
`formula8`
`formula9`
`formula10`
`formula11`
`formula12`
`LightType`
`goodEffect`
`Activated`
`resisttype`
`effectid1`
`effectid2`
`effectid3`
`effectid4`
`effectid5`
`effectid6`
`effectid7`
`effectid8`
`effectid9`
`effectid10`
`effectid11`
`effectid12`
`targettype`
`basediff`
`skill`
`zonetype`
`EnvironmentType`
`TimeOfDay`
`classes1`
`classes2`
`classes3`
`classes4`
`classes5`
`classes6`
`classes7`
`classes8`
`classes9`
`classes10`
`classes11`
`classes12`
`classes13`
`classes14`
`classes15`
`classes16`
`CastingAnim`
`TargetAnim`
`TravelType`
`SpellAffectIndex`
`field124`
`field125`
`deities1`
`deities2`
`deities3`
`deities4`
`deities5`
`deities6`
`deities7`
`deities8`
`deities9`
`deities10`
`deities11`
`deities12`
`deities13`
`deities14`
`deities15`
`deities16`
`field142`
`field143`
`new_icon`
`spellanim`
`uninterruptable`
`ResistDiff`
`dot_stacking_exempt`
`deleteable`
`RecourseLink`
`field151`
`field152`
`field153`
`short_buff_box`
`descnum`
`typedescnum`
`effectdescnum`
`field158`
`field159`
`field160`
`field161`
`bonushate`
`field163`
`field164`
`field165`
`EndurCost`
`EndurTimerIndex`
`field168`
`field169`
`field170`
`field171`
`field172`
`HateAdded`
`EndurUpkeep`
`field175` ,
`numhits`
`pvpresistbase`
`pvpresistcalc`
`pvpresistcap`
`spell_category`
`field181`
`field182`
`field183`
`field184`
`can_mgb`
`nodispell`
`npc_category`
`npc_usefulness`
`field189`
`field190`
`field191`
`field192`
`nimbuseffect`
`field194`
`field195`
`field196`
`field197`
`field198`
`field199`
`field200`
`field201`
`field202`
`field203`
`field204`
`field205`
`field206`
`spellgroup`
`field208`
`field209`
`field210`
`field211`
`allowrest`
`field213`
`field214`
Reply With Quote
  #10  
Old 07-27-2010, 08:41 PM
Bellos
Hill Giant
 
Join Date: Jul 2007
Posts: 111
Default

Hey i can connect and everything but it seems like the changes are being saved to my spell file. I mean it looks like it in the editor, but when i try to add a spell to an item like a clicky. It doesnt show up in my spell list.

Im using georges item editor. Also im on titanium.
Reply With Quote
Reply

Thread Tools
Display Modes

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 10:06 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3