Jump to content

[8462] creature_ai_texts field emote datatype


Athor
 Share

Recommended Posts

What bug does the patch fix? What features does the fix add?

Set creature_ai_texts.emote datatype to smallint allow play emote with id>255

Currently field emote datatype tinyint(3) only allow playemote with emoteID up to 255

If try to input emoteID>255 like 430 for example , field value will be automatically set to max allowed value 255 . Then you will have a db error report at server start like

2009-08-27 11:33:40 CreatureEventAI:  Entry-XXXX in table `creature_ai_texts` has Emote 255 but emote does not exist.

For which repository revision was the patch created?

Done on 8413

Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread.

none found

Who has been writing this fix? Please include either forum user names or email addresses.

me

fix

ALTER TABLE `creature_ai_texts`
CHANGE `emote` `emote` smallint (5) unsigned NOT NULL default '0';

Link to comment
Share on other sites

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use