+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 2 Releases (https://lckb.dev/forum/forumdisplay.php?fid=186)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=143)
+----- Thread: The Most Important Querry (/showthread.php?tid=1652)
- luoo - 03-01-2013
Post sql querys is ok, but for sql querys credits is .......
- Janebug - 03-02-2013
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 - 03-02-2013
Wrong.
a_num_4 = 24 -> 1 Day
a_num_4 = 168 -> 7 Days
a_num_4 = 720 -> 30 Days
- Janebug - 03-03-2013
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 - 03-03-2013
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 - 03-03-2013
All numbers in the database are in real seconds
- luoo - 03-03-2013
But a_num4 for cover etc. is in hours.
- extreme - 06-01-2013
This is a really useful post.
Why anyone dont put it in pinned?