09.05.2012, 10:49
Попытался сделать вот так, но все равно не выходит:
PHP Code:
LoadMySQLHouses ( )
{
mysql_query("SELECT * FROM `ExclusiveHouses` ORDER BY `ExclusiveHouses`.`hID` ASC");
mysql_store_result();
for(new i; i < TOTAL_HOUSES; i++) strmid( HouseInfo[ i ][ hOwner ], "None", 0, strlen("None"), 24);
if(mysql_num_rows() > 0)
{
for(new h = 1; h <= mysql_num_rows(); h++)
{
//mysql_fetch_row(Query);
mysql_get_field("EnterX", Query);
HouseInfo[ h ][ EnterX ] = floatstr(Query);
mysql_get_field("EnterY", Query);
HouseInfo[ h ][ EnterY ] = floatstr(Query);
mysql_get_field("EnterZ", Query);
HouseInfo[ h ][ EnterZ ] = floatstr(Query);
mysql_get_field("ExitX", Query);
HouseInfo[ h ][ ExitX ] = floatstr(Query);
mysql_get_field("ExitY", Query);
HouseInfo[ h ][ ExitY ] = floatstr(Query);
mysql_get_field("ExitZ", Query);
HouseInfo[ h ][ ExitZ ] = floatstr(Query);
mysql_get_field("hOwner", Query);
strmid(HouseInfo[ h ][ hOwner ], Query, 0, strlen(Query), 255);
mysql_get_field("hPrice", Query);
HouseInfo[ h ][ hPrice ] = strval(Query);
mysql_get_field("hInt", Query);
HouseInfo[ h ][ hInt ] = strval(Query);
mysql_get_field("hVW", Query);
HouseInfo[h][hVW] = strval(Query);
mysql_get_field("hLock", Query);
HouseInfo[h][hLock] = strval(Query);
//sscanf(Query, "p<|>iffffffs[24]iiii",HouseInfo[ h ][ hID ],HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ],HouseInfo[ h ][ ExitX ],HouseInfo[ h ][ ExitY ],HouseInfo[ h ][ ExitZ ],HouseInfo[ h ][ hOwner ],HouseInfo[ h ][ hPrice ],HouseInfo[ h ][ hInt ],HouseInfo[ h ][ hVW ],HouseInfo[ h ][ hLock ] );
if(!strcmp( HouseInfo[ h ][ hOwner ], "None", true ) )
{
HouseInfo[ h ][ hPickup ] = CreatePickup(1273, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );
format(strin,sizeof(strin),"Номер дома: %i.\nДом выставлен на продажу!\nЦена: %i.", h, HouseInfo[ h ][ hPrice ]);
}
else
{
HouseInfo[ h ][ hPickup ] = CreatePickup(1318, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );
format(strin,sizeof(strin),"Номер дома: %i.\nВладелец дома: %s.", h, HouseInfo[ h ][ hOwner ]);
}
CreatePickup(19134, 1, HouseInfo[ h ][ ExitX ], HouseInfo[ h ][ ExitY ], HouseInfo[ h ][ ExitZ ], HouseInfo [ h ] [ hVW ] );
HouseInfo[ h ][ hLabel ] = Create3DTextLabel(strin, 0xC4DAADFF, HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ], 15.0,0,1);
++ TOTAL_HOUSES;
}
}
mysql_free_result(), printf("[ Система домов ]: Загружено %i домов.", TOTAL_HOUSES);
}