16.09.2014, 13:37
What function mysql_fetch_row for MySQL R38 ? +R3P
case 3: { mysql_query(Mysql_users, "SELECT * FROM `"NAMU_LENTELE"`" ); mysql_store_result(Mysql_users ); new eile[ 90 ], i = 0; while ( cache_get_row(eile, "|" ) && i < MAX_HOUSES ) { if(GetPlayerMoney(playerid) < HouseData[i][Namokaina]) { SendClientMessage(playerid,COLOR_RED,"Atsipraљome, bet jums nepakanka pinigų nusipirkti љį nąmą."); } else { GivePlayerMoney(playerid, -HouseData[i][Namokaina]); SendClientMessage(playerid, -1,"{0080C0}Nusipirkote namą. Namo valdymas: /namas"); 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]); 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; } } }
mysql_tquery(Mysql_users, "SELECT * FROM `NAMU_LENTELE`", "Load","","");
forward Load();
public Load()
{
for(new i =0; i < MAX_HOUSES; i++)
{
cache_get_row(i,field,HouseData[i][Namokaina]);
///the rest here here
}
}