17.09.2014, 14:18
Код:
case 3: { mysql_query(Mysql_users, "SELECT * FROM `"NAMU_LENTELE"`" ); if(cache_num_rows()) { for(new i=0; i<cache_num_rows(); i++) { if(GetPlayerMoney(playerid) < HouseData[i][Namokaina]) { SendClientMessage(playerid,COLOR_RED,"Atsipraљome, bet jums nepakanka pinigų nusipirkti љį nąmą."); //You don't have money to buy this house } else { GivePlayerMoney(playerid, -HouseData[i][Namokaina]); SendClientMessage(playerid, -1,"{0080C0}Nusipirkote namą. Namo valdymas: /namas"); //You bought house. House commands: /house mysql_format(Mysql_users, query, sizeof(query), "UPDATE `"NAMU_LENTELE"` SET Savininkas='%s', Parduodamas='0', Pavadinimas='%s namas' WHERE `ID` = '%i'", PlayerData[playerid][Fullname], PlayerData[playerid][Fullname], HouseData[i][ID]); // Set Owner='%s', Buyable='0', HouseName='%s house' WHERE `HouseID`='%i' mysql_tquery(Mysql_users, query, "", ""); HouseData[i][Parduodamas] = 0; new Vardas[MAX_PLAYER_NAME]; format(HouseData[i][Savininkas], 64, "%s", Vardas); HouseData[i][Savininkas] = Vardas; } } } }
Код:
forward LoadHouseData(playerid); public LoadHouseData(playerid) { AntiDeAMX(); if(cache_num_rows()) { for(new i=0; i<cache_num_rows(); i++) { HouseData[i][ID] = cache_get_field_content_int(i, "ID", Mysql_users); cache_get_field_content(i, "Pavadinimas", HouseData[i][Pavadinimas], Mysql_users, 129); cache_get_field_content(i, "Savininkas", HouseData[i][Savininkas], Mysql_users, 129); HouseData[i][Namokaina] = cache_get_field_content_int(i, "Namokaina", Mysql_users); HouseData[i][Parduodamas] = cache_get_field_content_int(i, "Parduodamas", Mysql_users); HouseData[i][PositionX] = cache_get_field_content_float(i, "PositionX", Mysql_users); HouseData[i][PositionY] = cache_get_field_content_float(i, "PositionY", Mysql_users); HouseData[i][PositionZ] = cache_get_field_content_float(i, "PositionZ", Mysql_users); HouseData[i][Interior] = cache_get_field_content_int(i, "Interior", Mysql_users); new labelstring[500]; switch(HouseData[i][Parduodamas]) { case 0: { format(labelstring,sizeof(labelstring),"Namas Nr. %i\n %s\nNamo savininkas: %s\nNamo valdymas ENTER.", HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas]); //PickupData[HouseData[playerid][ID]][Namas] = CreatePickup(1273, 1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1); PickupData[i][Namas] = CreatePickup(1273, 2, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1); } case 1: { format(labelstring,sizeof(labelstring),"Namas Nr. %i parduodamas\n %s\nNamo savininkas: %s\nNamo kaina: %i\nNamo pirkimas ENTER.", HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas]); //PickupData[HouseData[playerid][ID]][Namas] = CreatePickup(1272, 1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1); PickupData[i][Namas] = CreatePickup(1272, 2, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1); } } Create3DTextLabel(labelstring, -1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ]+0.75, 40.0, 0, 0); Update3DTextLabelText(HouseData[i][ID], -1, labelstring); printf("[%i] - Kuriame nama namo ID: %i Pavadinimas: %s Savininkas %s",i, HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas]); } } return 1; }