Hi!
Prompt please sql command for gifts to all players GC / GD or items.
Thank you!
Printable View
Hi!
Prompt please sql command for gifts to all players GC / GD or items.
Thank you!
GC: UPDATE UsersData SET GamePoints = (GamePoints + 1000)
GD: UPDATE UsersData SET GameDollars = (GameDollars + 1000)
Change "1000" for your value.
How to gifts Item to all players?
Use this for unique player:
Where 1000000 = player CustomerID, 500 is a quantity, 101304 is a ItemID.Code:insert into UsersInventory (CustomerID, CharID, BackpackSlot, ItemID, LeasedUntil, Quantity)
values (1000000, 0, -1, 101304, '2020-1-1', 500)
Idk how to make it for all players...
Just use * instead of the CustomerID. :<