Ashley100
Умник
PHP:
(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `hID` = '0'' at line 1
PHP:
public LoadHouses()
{
new time = GetTickCount();
new string[128],klass[2];
new rows,fields;
cache_get_data(rows,fields,mysql_connect_id);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_field_content(rows, "hOwner",hInfo[idx][hOwner],mysql_connect_id,24);
hInfo[idx][hID] = cache_get_field_content_int(1, "hID", mysql_connect_id);
hInfo[idx][hOwned] = cache_get_field_content_int(1, "hOwned", mysql_connect_id);
hInfo[idx][hPS][0] = cache_get_field_content_float(1, "hPSX", mysql_connect_id);
hInfo[idx][hPS][1] = cache_get_field_content_float(1, "hPSY", mysql_connect_id);
hInfo[idx][hPS][2] = cache_get_field_content_float(1, "hPSZ", mysql_connect_id);
hInfo[idx][hPI][0] = cache_get_field_content_float(1, "hPSX", mysql_connect_id);
hInfo[idx][hPI][1] = cache_get_field_content_float(1, "hPSY", mysql_connect_id);
hInfo[idx][hPI][2] = cache_get_field_content_float(1, "hPSZ", mysql_connect_id);
hInfo[idx][hClass] = cache_get_field_content_int(1, "hClass", mysql_connect_id);
hInfo[idx][hPrice] = cache_get_field_content_int(1, "hPrice", mysql_connect_id);
hInfo[idx][hInt] = cache_get_field_content_int(1, "hInt", mysql_connect_id);
hInfo[idx][hVw] = cache_get_field_content_int(1, "hVw", mysql_connect_id);
hInfo[idx][hIcon] = cache_get_field_content_int(1, "hIcon", mysql_connect_id);
hInfo[idx][hPick] = cache_get_field_content_int(1, "hPick", mysql_connect_id);
TOTALHOUSES++;
}
}
return true;
}
