Page 1 of 6
The mico's database fixes topic
PostPosted: Tue Jun 05, 2007 10:29 am
by mico
Hey guys,
I have read-only access on the sql-db,
I make this topic for make lesser spam on the forums, everithing I'll find / fix will posted here.
PostPosted: Tue Jun 05, 2007 10:32 am
by mico
Just opened the database, finded this little bug in the worldobject tables, there is a NF portal stone with name " New Object ".
here is the sql query :
- Code: Select all
UPDATE worldobject SET Name='Frontiers Portal Stone' WHERE WorldObject_ID = '2575e064-4cff-4c25-9bf6-3c677124409b'
PostPosted: Tue Jun 05, 2007 10:34 am
by ZioRed
May be more useful if you post directly the INSERT/UPDATE SQL statements (possibly using the PK fields on WHERE)...

PostPosted: Tue Jun 05, 2007 12:08 pm
by Etaew
The question is, I bet ZioRed can check this because I'm lazy, does the frontiers portal stone class overwrite name? if so, then it doesn't matter about the db.
PostPosted: Tue Jun 05, 2007 12:46 pm
by ZioRed
The question is, I bet ZioRed can check this because I'm lazy, does the frontiers portal stone class overwrite name? if so, then it doesn't matter about the db.
It seems that no overwrite of the Name is made inside the class FrontiersPortalStone (neither in AddToWorld nor in the GameStaticItem constructor). I think it can be directly changed in the DB (I'll check later if any load methods of the keep system overwrites some names).
PostPosted: Tue Jun 05, 2007 12:58 pm
by mico
New bug finded,
DB : Spell
WTF!? : All Spec bard heals have a grupheal icon.
This is the sql query for fix it :
- Code: Select all
QUERY REMOVED
EDIT : Used normal SingleTarget-Spec-Heals, as the drood/warden heals.
PostPosted: Tue Jun 05, 2007 3:02 pm
by stealth215
are you sure those are the right IDs? would rather have them be as they are now then just change them to something that's wrong and have to change them again
PostPosted: Tue Jun 05, 2007 3:46 pm
by mico
are you sure those are the right IDs? would rather have them be as they are now then just change them to something that's wrong and have to change them again
yes thats icon ID is right, are normals spec heals as drood or warden . ( I remember it from my old bard on lancelot )
PostPosted: Tue Jun 05, 2007 9:20 pm
by mico
Hey,
The reaver got some bugs in their StyleProcs,
As a recent mythic patch all style procs have to be Spirit Damage ( somes are cold atm ) and All ClientEffect of that procs are bugged.
this is the fix :
- Code: Select all
QUERY REMOVED
I had tested All Damages and Effect on Merlin 1 hour ago.
Yeah I changed some ClientEffects without changing the SpellID but np they was already different so no big changing.

PostPosted: Tue Jun 05, 2007 10:11 pm
by Overdriven
These will all be added by tomorrow, very nice work ^_^ (Can't do it now, not till minimal lets me

)
PostPosted: Tue Jun 05, 2007 10:12 pm
by mico
These will all be added by tomorrow, very nice work ^_^ (Can't do it now, not till minimal lets me

)
Thanks

PostPosted: Wed Jun 06, 2007 7:44 am
by ZioRed
For Leviathan proc spell, don't forget to update that of Heretic too. They should be something different, I suppose.
PostPosted: Wed Jun 06, 2007 7:45 am
by mico
For Leviathan proc spell, don't forget to update that of Heretic too. They should be something different, I suppose.
hmm I tested it, heretic use the same style spells of the reaver.
PostPosted: Wed Jun 06, 2007 4:55 pm
by Overdriven
ALL FIXES ABOVE THIS COMMENT HAVE BEEN ADDED.
Just thought you should know

PostPosted: Wed Jun 06, 2007 9:04 pm
by mico
Vampiir :
There was 2 styles with " Grafical " Style Requirement bug ( Thats was imposted at None )
here is the quick fix :
- Code: Select all
QUERY REMOVED