The Most Important Querry

[Janebug]

How to fix item Expire ....where and the time to add

 

 

3888 sec = 1 game day, and there are 24 game days in 1 real day..

 

1.08 = 1 sec

64.8 = 1 min

3888 = 1 hour

11664 = 3 hours

34992 = 9 hours

 

So 3888 x 24 = 93312 = 1 real day

So 93312 x 7 = 653184  = 7 real days

So 93312 x 30 = 2799360 = 30 real days

 

enter the value in a_num_4 in t_items

 

 

I found using t_inven00 - 09 / a_used0 in secs works great.

This also working in the warehouse/storage house which is what i needed for the mall

 

updates in db based on Days

 

-- this will fix alot of them ...but use them at your own risk....

UPDATE t_item SET a_num_4 = 653184 WHERE a_flag = 352847104;  -- 7 Days will update all items with this flag;

UPDATE t_item SET a_num_4 = 1306368 WHERE a_flag = 352322816;  -- 14 Days will update all items with this flag;

UPDATE t_item SET a_num_4 = 2799360 WHERE a_flag = 352978176;  -- 30 Days will update all items with this flag;

 

If you find this to be in error please reply ....as always if you use my work presss                   Thank you