[patch][7945] Implement use of EmoteDelay in quest_template

[NoFantasy]

Feature: Add fields to define delay in quest_template DetailsEmote and OfferRewardEmote

Revision: patch created with revision 7338(Master)

Author: NoFantasy

Info: This will add fields to define a delay-value for DetailsEmoteN and OfferRewardEmoteN -fields in quest_template. It will make emotes play more nice client-side when more than one is used for some emotes.

Example data:

UPDATE quest_template SET
OfferRewardEmote1=1, OfferRewardEmote2=1, OfferRewardEmote3=1,
OfferRewardEmoteDelay2=1000, OfferRewardEmoteDelay3=1000
WHERE entry=8795;

Patch:

http://paste2.org/p/155593

SQL:

ALTER TABLE quest_template
 ADD COLUMN DetailsEmoteDelay1 int(11) unsigned NOT NULL default '0' AFTER DetailsEmote4,
 ADD COLUMN DetailsEmoteDelay2 int(11) unsigned NOT NULL default '0' AFTER DetailsEmoteDelay1,
 ADD COLUMN DetailsEmoteDelay3 int(11) unsigned NOT NULL default '0' AFTER DetailsEmoteDelay2,
 ADD COLUMN DetailsEmoteDelay4 int(11) unsigned NOT NULL default '0' AFTER DetailsEmoteDelay3,
 ADD COLUMN OfferRewardEmoteDelay1 int(11) unsigned NOT NULL default '0' AFTER OfferRewardEmote4,
 ADD COLUMN OfferRewardEmoteDelay2 int(11) unsigned NOT NULL default '0' AFTER OfferRewardEmoteDelay1,
 ADD COLUMN OfferRewardEmoteDelay3 int(11) unsigned NOT NULL default '0' AFTER OfferRewardEmoteDelay2,
 ADD COLUMN OfferRewardEmoteDelay4 int(11) unsigned NOT NULL default '0' AFTER OfferRewardEmoteDelay3;

Edit: and one typo fixed in there (EnbleNext to EnableNext)

[Sephiroth1983]

I guess we will need to set the delay manually, anyway is probably needed, since seeing all emotes at once if clicking the quest dialogs fast looks strange.

How it is on offy?

[hikikomori18]

from my time on offy, it feels like they had emotes manually delayed.

[VladimirMangos]

In [7945]. Thank you for patch and wait