MySQL Häuser Problem

Guten Abend liebe Community,

ich habe mich jetzt mal an MySQL probiert und wollte meine Häuser speichern und Laden lassen. Ich nutze G-Stylez Plugin.
Bei OnGameModeInit steht folgendes:

Zitat

print("Lade Häuser..");
LoadProperty();
print("Lade Geschäfte..");
LoadBizz();
print("Lade sGeschäfte..");
LoadSBizz();

Der Server lädt beim Starten die Häuser, allerdings wird danach nichts mehr geladen(Bizzes).
Hier ist noch der Code zum Laden der Häuser:

Zitat

public LoadProperty()
{
new query[265];
new idx;
while (idx < sizeof(HouseInfo))
{
format(query,sizeof(query),"SELECT `hcreated` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hCreated] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hentrancex` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hEntrancex] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hentrancey` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hEntrancey] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hentrancez` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hEntrancez] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hexitx` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hExitx] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hexity` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hExity] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hexitz` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hExitz] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hHealthx` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hHealthx] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hHealthy` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hHealthy] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hHealthz` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hHealthz] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hArmourx` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hArmourx] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hArmoury` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hArmoury] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hArmourz` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hArmourz] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `howner` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hOwner] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hdiscription` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hDiscription] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hValue` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hValue] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hhel` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hHel] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `harm` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hArm] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hint` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hInt] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hlock` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hLock] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `howned` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hOwned] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hrooms` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hRooms] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hrent` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hRent] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hrentabil` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hRentabil] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hdate` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hDate] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hlevel` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hLevel] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT `hmuell` FROM `houses` WHERE `hID`='%i'",idx+1);
mysql_query(query);
mysql_store_result();
HouseInfo[idx+1][hMuell] = mysql_fetch_int();
mysql_free_result();
idx++;
print(query);
}
return 1;
}

Alles anzeigen

Wo hab ich denn einen Fehler das es nach den Häuser laden aufhört weiteres zu laden?

#Text
#² Hinzugefügt