Advertisement
Guest User

Untitled

a guest
Mar 24th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. new szResult[180], Cache: result, name[64], userid, x;
  2. for(new i = 1; i < housess; i++) {
  3. format(query, sizeof(query), "SELECT * FROM `users` WHERE `name`='%s'", HouseInfo[i][hOwner]);
  4. result = mysql_query(SQL, query);
  5. cache_get_field_content(0, "id", szResult); userid = strval(szResult);
  6. cache_get_field_content(0, "name", szResult); format(name, 64, szResult);
  7. cache_delete(result);
  8. format(query, sizeof(query), "UPDATE `users` SET `House`='999' WHERE `ID`='%d'", userid);
  9. mysql_tquery(SQL, query, "", "");
  10. x++;
  11. HouseInfo[i][hOwned] = 0;
  12. HouseInfo[i][hValue] = 125000;
  13. format(query, sizeof(query),"UPDATE `houses` SET `Hel`='0',`Arm`='0',`Lockk`='0',`Owned`='0',`Owner`='The State',`Value`='125000' WHERE `ID`='%d'",BizzInfo[i][bID]);
  14. mysql_tquery(SQL, query, "", "");
  15. UpdateLabel(2, i);
  16. }
  17. if(x != 0) format(string, sizeof(string), "Au fost sterse %d case din baza de date!", x);
  18. else format(string, sizeof(string), "Nu au fost gasite case ce ar putea fi sterse!");
  19. SCM(playerid, COLOR_YELLOW, string);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement