26.01.2018, 22:34
2 years later.
I am using @Konstantinos method and it's giving me errors
Code:
I am using @Konstantinos method and it's giving me errors
Код:
[00:14:47] [Error] db_query: invalid database handle 0 [00:14:47] [Error] db_num_rows(): invalid result handle 0 [00:14:47] [Error] db_free_result(): invalid result handle 0
PHP код:
stock LoadWeeds()
{
new DBResult:dbresult;
dbresult = db_query(Database, "SELECT * FROM `plants` ORDER BY `plantid`");
for (new i, j = db_num_rows(dbresult); i != j; i++)
{
PlantInfo[i][plantID] = db_get_field_assoc_int(dbresult, "plantid");
PlantInfo[i][plantX] = db_get_field_assoc_float(dbresult, "plantX");
PlantInfo[i][plantY] = db_get_field_assoc_float(dbresult, "plantY");
PlantInfo[i][plantZ] = db_get_field_assoc_float(dbresult, "plantZ");
PlantInfo[i][plantInt] = db_get_field_assoc_int(dbresult, "plantInt");
PlantInfo[i][plantVW] = db_get_field_assoc_int(dbresult, "plantVW");
PlantInfo[i][plantValue] = db_get_field_assoc_int(dbresult, "plantValue");
PlantInfo[i][plantExist] = true;
PlantInfo[i][plantObject] = CreateDynamicObject(3409, PlantInfo[i][plantX], PlantInfo[i][plantY], PlantInfo[i][plantZ], 0.0, 0.0, 0.0, PlantInfo[i][plantVW], PlantInfo[i][plantInt]);
db_next_row(dbresult);
}
db_free_result(dbresult);
return 1;
}