SQL CODE - Cash Online
#1

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
)

#2

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



Forum Jump:


Users browsing this thread: 1 Guest(s)