+- 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: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: Cash per IP (/showthread.php?tid=2443)
- MrBuSta - 09-15-2013
Hi all, I want give free cash all weekend, but some people have 10+ account per 1 IP address.
But i dont want give manually in bg_user this cash.
have method to give cash with command only 1 account get cash per ip ?
- Nymphetamine - 09-15-2013
Well for bg_user it could be really easy simply making an SQL execute..but for IP..mm..i dont know,if its possible it will not be that easy
- MrBuSta - 09-15-2013
Well for bg_user it could be really easy simply making an SQL execute..but for IP..mm..i dont know,if its possible it will not be that easy
yes i know command for give all 5k cash, UPDATE bg_user SET cash = 5000; but i saw some ppl have 10+ account on server atm, and i dont want give 5k cash for this ppls all account..
- Paramount - 09-15-2013
yes i know command for give all 5k cash, UPDATE bg_user SET cash = 5000; but i saw some ppl have 10+ account on server atm, and i dont want give 5k cash for this ppls all account..
UPDATE bg_user SET cash = 5000;
Even this code is wrong, if you wanna just add, not replace
You should use something like that:
UPDATE bg_user SET cash = cash + 5000 WHERE user_id = Paramount;
I am not sure, but with ip try to make so:
UPDATE bg_user SET cash = cash + 5000 WHERE ip = 123.45.67.89 LIMIT 1;
- MrBuSta - 09-15-2013
UPDATE bg_user SET cash = 5000;
Even this code is wrong, if you wanna just add, not replace
You should use something like that:
UPDATE bg_user SET cash = cash + 5000 WHERE user_id = Paramount;
I am not sure, but with ip try to make so:
UPDATE bg_user SET cash = cash + 5000 WHERE ip = 123.45.67.89 LIMIT 1;
Thank you,Work Perfect
Close please.
- kixtzz - 09-15-2013
its useful but if the ppl created accounts with different ip?
- Paramount - 09-15-2013
its useful but if the ppl created accounts with different ip?
They should use just one
Closed and moved.