Duration on Custom Items?(Answered)

[covert_cat]

I haven't needed to ask for help often, but now I'm stumped. I want to create a custom item that only lasts 24 hours(a lot of items have durations in wow, where they are deleted once they run out of time on that duration) but I haven't found any way to do so.

I've created the item, added it to the DBC files in my server and the client, and created a lua script for it(it teleports the player). Now all that's left is adding a duration, since this item only lasting one day is well.. a plot device.

Any help would be greatly appreciated, and any solution to this problem will have the contributor receiving my undying gratitude. Because I take this stuff that seriously..

[stoneharry]

Change the exisiting duration in the items table of your SQL server for that item.

SELECT * FROM `items` WHERE `entry` = 'TheEntryIdOfYourItem`;

And the 2nd to last column I think it is, you need to change that to the duration. It's in milliseconds so 1000 = 1 second.

60000 = 1 minute
60000 * 60 = 1 hour = 3600000
3600000 * 24 = 1 day = 86400000

So change it from 0 to 86400000 then restart your server and delete your cache file.

[covert_cat]

It was in the sql the entire time.. I swear I looked through my items table twice and didn't find it.. xD sometimes I just amaze myself.

Thanks a ton, if I could give you a cookie right now I would.
AND IT WOULD BE THE BEST DAMN COOKIE YOU EVER HAD.