Advertisement
Dirsovisk

Limpar Casas, Devolver Itens e Reembolsar Jogadores

May 3rd, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.59 KB | None | 0 0
  1. -- TENTATIVA DO MODO NOOB :D
  2.  
  3. -- 1- dar "/closeserver" e depois ir fazendo  "/owner ADM Lucas", dentro do jogo, em todas as casas, enviando os itens dos players pro depot da cidade.
  4.  
  5. -- Depois disso:
  6.  
  7. -- 2- Reembolsar grana dos players q compraram casa:
  8.  
  9. UPDATE players
  10. SET players.balance = players.balance + houses.price
  11. FROM houses
  12. JOIN players ON players.id = houses.owner
  13.  
  14. -- ZERAR DADOS DAS HOUSES:
  15.  
  16. UPDATE houses
  17. SET houses.owner = 0, paid = 0, lastwarning = 0
  18. WHERE houses.owner > 0
  19.  
  20. -- LIMPAR LISTA DE INVITADOS DE CADA HOUSE:
  21. UPDATE house_lists
  22. SET house_lists.list = ''
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement