The Most Important Querry

[luoo]

Post sql querys is ok, but for sql querys credits is .......

[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 

[luoo]

Wrong.

a_num_4 = 24 -> 1 Day

a_num_4 = 168 -> 7 Days

a_num_4 = 720 -> 30 Days

[Janebug]

i did alot of looking for this luoo, and what i found was the 

 

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

 

so ill try your way see whats give but thank you.....

[luoo]

Look the id 2458,2459,2460 Merchant Ticket 1,7,30 Days or 1419 Platin Refining +1 1 Day.

 

a_used0 is in seconds i think.

[Wizatek]

All numbers in the database are in real seconds

[luoo]

But a_num4 for cover etc. is in hours.

[extreme]

This is a really useful post.

Why anyone dont put it in pinned?