The mico's database fixes topic

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

[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'

[ZioRed]

May be more useful if you post directly the INSERT/UPDATE SQL statements (possibly using the PK fields on WHERE)...

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

[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).

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

[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

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

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

[Overdriven]

These will all be added by tomorrow, very nice work ^_^ (Can't do it now, not till minimal lets me )

[mico]

These will all be added by tomorrow, very nice work ^_^ (Can't do it now, not till minimal lets me )

Thanks

[ZioRed]

For Leviathan proc spell, don't forget to update that of Heretic too. They should be something different, I suppose.

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

[Overdriven]

ALL FIXES ABOVE THIS COMMENT HAVE BEEN ADDED.


Just thought you should know

[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