Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- new szResult[180], Cache: result, name[64], userid, x;
- for(new i = 1; i < housess; i++) {
- format(query, sizeof(query), "SELECT * FROM `users` WHERE `name`='%s'", HouseInfo[i][hOwner]);
- result = mysql_query(SQL, query);
- cache_get_field_content(0, "id", szResult); userid = strval(szResult);
- cache_get_field_content(0, "name", szResult); format(name, 64, szResult);
- cache_delete(result);
- format(query, sizeof(query), "UPDATE `users` SET `House`='999' WHERE `ID`='%d'", userid);
- mysql_tquery(SQL, query, "", "");
- x++;
- HouseInfo[i][hOwned] = 0;
- HouseInfo[i][hValue] = 125000;
- 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]);
- mysql_tquery(SQL, query, "", "");
- UpdateLabel(2, i);
- }
- if(x != 0) format(string, sizeof(string), "Au fost sterse %d case din baza de date!", x);
- else format(string, sizeof(string), "Nu au fost gasite case ce ar putea fi sterse!");
- SCM(playerid, COLOR_YELLOW, string);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement