PDA

View Full Version : Houses aren't loading again..


div
04/07/2018, 09:11 AM
Hello, I managed to fix that houses weren't loading, but I had a problem with my PC and lost that..


here's another i made.. pls help


LoadHouses()
{
new rows = cache_get_row_count();

new Houselabel[145], Cache:housecache, query[45];
mysql_format(dbHandle, query, sizeof(query), "SELECT * FROM `houses`");
housecache = mysql_query(dbHandle, query, true);
for(new i = 0; i < rows; i++)
{
cache_set_active(housecache);
for(new z = 0; z < MAX_HOUSES; z++)
{

hInfo[z][HouseEX] = cache_get_field_content_float(i, "HouseEX");
hInfo[z][HouseEY] = cache_get_field_content_float(i, "HouseEY");
hInfo[z][HouseEZ] = cache_get_field_content_float(i, "HouseEZ");
cache_get_field_content(i, "HouseTitle", hInfo[z][HouseTitle]);
hInfo[z][HouseOwned] = cache_get_field_content_int(i, "HouseOwned");
cache_get_field_content(i, "HouseOwner", hInfo[z][HouseOwner]);
hInfo[z][HousePassworded] = cache_get_field_content_int(i, "HousePassworded");
cache_get_field_content(i, "HousePassword", hInfo[z][HousePassword]);
hInfo[z][HousePrice] = cache_get_field_content_int(i, "HousePrice");

if(hInfo[i][HouseOwned] == 0)
{
format(Houselabel, 145, "{FFD700}House Title(%i): {FFFFFF}%s\n{FFD700}House Owner: {FFFFFF}No-one\n {FFD700}House Price: {FFFFFF}$%d", hInfo[z][HouseID], hInfo[z][HouseTitle], hInfo[z][HousePrice]);
hInfo[z][HouseDetails] = CreateDynamic3DTextLabel(Houselabel, 0xFFFFFF, hInfo[z][HouseEX], hInfo[z][HouseEY], hInfo[z][HouseEZ], 15.0, .worldid = 0, .interiorid = 0, .streamdistance = 15.0);
hInfo[z][HouseCP] = CreateDynamicCP(hInfo[z][HouseEX], hInfo[z][HouseEY], hInfo[z][HouseEZ], 1, .worldid = 0, .interiorid = 0, .streamdistance = 15);
}
else if(hInfo[i][HouseOwned] == 1)
{
format(Houselabel, 145, "{FFD700}House Title(%i): {FFFFFF}%s\n{FFD700}House Owner: {FFFFFF}%s\n {FFD700}House Price: {FFFFFF}$%d", hInfo[z][HouseID], hInfo[z][HouseTitle], hInfo[z][HousePrice]);
hInfo[z][HouseDetails] = CreateDynamic3DTextLabel(Houselabel, 0xFFFFFF, hInfo[z][HouseEX], hInfo[z][HouseEY], hInfo[z][HouseEZ], 15.0, .worldid = 0, .interiorid = 0, .streamdistance = 15.0);
hInfo[z][HouseCP] = CreateDynamicCP(hInfo[z][HouseEX], hInfo[z][HouseEY], hInfo[z][HouseEZ], 1, .worldid = 0, .interiorid = 0, .streamdistance = 15);
break;
}
housecache = cache_save();
}
}
}




and MySQL Logs..

[14:34:00] [ERROR] "mysql_tquery" - invalid connection handle (id: 1)
[14:34:00] [WARNING] cache_get_field_content_float - no active cache
[14:34:00] [WARNING] cache_get_field_content_float - no active cache
[14:34:00] [WARNING] cache_get_field_content_float - no active cache
[14:34:00] [WARNING] cache_get_field_content_int - no active cache
[14:34:00] [WARNING] cache_get_field_content_int - no active cache
[14:34:00] [WARNING] cache_get_row_count - no active cache
[14:34:02] [ERROR] cache_get_field_content_int - invalid datatype
[14:34:03] [WARNING] cache_get_field_content_int - no active cache



MySQL R39

div
04/07/2018, 03:23 PM
Noone to help me? :/

kovac
04/07/2018, 04:17 PM
// OnGameModeInit
mysql_tquery(dbHandle, "SELECT * FROM `houses`;", "OnhousesLoad", "");

forward OnhousesLoad();
public OnhousesLoad()
{
new rows = cache_num_rows(), Houselabel[128];
if(rows)
{
for(new i = 0; i < rows; i++)
{
cache_get_value_name_float(i, "HouseEX", hInfo[i][HouseEX]);
cache_get_value_name_float(i, "HouseEY", hInfo[i][HouseEX]);
cache_get_value_name_float(i, "HouseEZ", hInfo[i][HouseEX]);
cache_get_value_name(i, "HouseTitle", hInfo[i][HouseTitle], 50);
cache_get_value_name_int(i, "HouseOwned", hInfo[i][HouseOwned]);
cache_get_value_name(i, "HouseOwner", hInfo[i][HouseOwner], MAX_PLAYER_NAME);
cache_get_value_name_int(i, "HousePassworded", hInfo[i][HousePassworded]);
cache_get_value_name(i, "HousePassword", hInfo[i][HousePassword], 128);
cache_get_value_name_int(i, "HousePrice", hInfo[i][HousePrice]);

if(hInfo[i][HouseOwned] == 0)
{
format(Houselabel, sizeof(Houselabel), "{FFD700}House Title(%i): {FFFFFF}%s\n{FFD700}House Owner: {FFFFFF}No-one\n {FFD700}House Price: {FFFFFF}$%d", hInfo[i][HouseID], hInfo[i][HouseTitle], hInfo[i][HousePrice]);
hInfo[i][HouseDetails] = CreateDynamic3DTextLabel(Houselabel, 0xFFFFFF, hInfo[i][HouseEX], hInfo[i][HouseEY], hInfo[i][HouseEZ], 15.0, 0, 0,15.0);
hInfo[i][HouseCP] = CreateDynamicCP(hInfo[i][HouseEX], hInfo[i][HouseEY], hInfo[i][HouseEZ], 1, 0, 0, 15);
}
else if(hInfo[i][HouseOwned] == 1)
{
format(Houselabel, sizeof(Houselabel), "{FFD700}House Title(%i): {FFFFFF}%s\n{FFD700}House Owner: {FFFFFF}%s\n {FFD700}House Price: {FFFFFF}$%d", hInfo[i][HouseID], hInfo[i][HouseTitle], hInfo[i][HousePrice]);
hInfo[i][HouseDetails] = CreateDynamic3DTextLabel(Houselabel, 0xFFFFFF, hInfo[i][HouseEX], hInfo[i][HouseEY], hInfo[i][HouseEZ], 15.0, 0, 0, 15.0);
hInfo[i][HouseCP] = CreateDynamicCP(hInfo[i][HouseEX], hInfo[i][HouseEY], hInfo[i][HouseEZ], 1, 0, 0, 15);
}
}
printf("Total houses loaded: %d", rows);
}
return 1;
}