+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep2 Guides (https://lckb.dev/forum/forumdisplay.php?fid=165)
+----- Thread: SQL CODE - Cash Online (/showthread.php?tid=3272)
- kixtzz - 01-14-2014
I want to release this SQL code that i made some months ago for my server.
It gives cash for online people in the moment when you execute.
I dont know if its a guide or release :lol:
UPDATE bg_user
SET cash = cash + 10000
WHERE user_id = (
SELECT a_idname
FROM t_users
WHERE a_zone_num != -1
AND a_portal_index = user_code
)
- Wizatek - 01-15-2014
Update bg_user set cash = cash + 1000 where user_code in (select a_portal_index from t_users where a_zone_num != -1)
That should work also