[Patch] Item changes after duration expires

[cmaranec]

UPDATE:

Works with revision 9600

Complete rewrite:

* revert any previous patch from this thread!

* added script event for "OnItemDurationExpire" called after item duration expire ( )

* included SD2 patch and some example code

MaNGOS Core Patch: http://paste2.org/p/722770

SD2 SVN Patch: http://paste2.org/p/722771

SD2 Example Code (mysterious egg and disgusting jar): http://paste2.org/p/722773

(For example code you also need to set ScriptName of those items and set them duration!)

[fdb_]

Nice and sweet as hell,

Cheers

[315907111]

Ah, design well, if they can read the MYSQL table, so easy to add remove the items, even simpler!

[Morphau]

Hello thanks, can you post the SQL too for the item please ?

[cmaranec]

Here it is:

UPDATE item_template SET ScriptName='item_mysterious_egg', Duration=604800 WHERE entry=39878;
UPDATE item_template SET ScriptName='item_disgusting_jar', Duration=604800 WHERE entry=44717;

This sets the 7 weeks duration and ScriptNames to these items (Mysterious Egg and Disgusting Jar)

[cmaranec]

I would be very glad, if any green-named developer will say something about that

(Which is the best way and something like that..)

[Patman128]

I wouldn't want to speak for the mangos developers, but AFAIK, they will avoid script/code solutions to problems when they can easily be put in the database, and I have yet to see an example of this that happens on official servers that could not be done easily in a loot template with a handler.

[315907111]

they will avoid script/code solutions to problems when they can easily be put in the database, and I have yet to see an example of this that happens on official servers that could not be done easily in a loot template with a handler.

Agrees with this approach,Impossible to achieve one to add a script, hope the script is more appropriate database management

[315907111]

This post does not sink, and random has not been realized. Looking forward to a better improvement!

[bulek]

kunfu bump interest patch

[VladimirMangos]

Converted to reuse existed code original table base version: https://gist.github.com/1032722 Not tested yet.

[VladimirMangos]

In last form patch add in [11646]. Thank you Sorry for long wait review.

[angeleyes]

I know that this is already an old post, but recently the mysterious egg mysteriously stopped working after a patch on our server.

So I wanted to check out the code mentioned in the paste2 links at the top of page 2 of this topic, but the links don't exist anymore.

Could someone tell me where to find the code and maybe why it all of a sudden stopped working.