15.04.2016, 23:16
I have a huge problem, something is being messed up while loading from mysql base,
look at th elog:
http://imgur.com/a/4uUE2
Pictures:
This is loading:
IDs are not AI, and idk if they should be, please help
look at th elog:
http://imgur.com/a/4uUE2
Quote:
[01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('12') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') [01:14:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('43') |
This is loading:
pawn Code:
case THREAD_UCITAJSTANOVE:
{
if(szRows)
{
new temp[64];
for(new i = 0; i <= szRows; i++)
{
cache_get_field_content(i, "ID", temp);
SInfo[i][sID] = strval(temp);
cache_get_field_content(i, "ImaVlasnika", temp);
SInfo[i][ImaVlasnika] = strval(temp);
cache_get_field_content(i, "Vlasnik", temp);
format(SInfo[i][Vlasnik], 50, "%s", temp);
cache_get_field_content(i, "Adresa", temp);
format(SInfo[i][Adresa], 32, "%s", temp);
cache_get_field_content(i, "UlazX", temp);
SInfo[i][UlazX] = floatstr(temp);
cache_get_field_content(i, "UlazY", temp);
SInfo[i][UlazY] = floatstr(temp);
cache_get_field_content(i, "UlazZ", temp);
SInfo[i][UlazZ] = floatstr(temp);
cache_get_field_content(i, "UlazA", temp);
SInfo[i][UlazA] = floatstr(temp);
cache_get_field_content(i, "IzlazX", temp);
SInfo[i][IzlazX] = floatstr(temp);
cache_get_field_content(i, "IzlazY", temp);
SInfo[i][IzlazY] = floatstr(temp);
cache_get_field_content(i, "IzlazZ", temp);
SInfo[i][IzlazZ] = floatstr(temp);
cache_get_field_content(i, "IzlazA", temp);
SInfo[i][IzlazA] = floatstr(temp);
cache_get_field_content(i, "Zakljucano", temp);
SInfo[i][Zakljucano] = strval(temp);
cache_get_field_content(i, "Cena", temp);
SInfo[i][Cena] = strval(temp);
cache_get_field_content(i, "VW", temp);
SInfo[i][VW] = strval(temp);
cache_get_field_content(i, "Interior", temp);
SInfo[i][Interior] = strval(temp);
cache_get_field_content(i, "sLevel", temp);
SInfo[i][Level] = strval(temp);
new str[269];
if(SInfo[i][ImaVlasnika] == 0)
{
format(str, sizeof(str), "{F3FF02}Stan na prodaju\n{FFFFFF}Cena: {F3FF02}$%d\n{FFFFFF}Level: {F3FF02}%d\n{FFFFFF}Adresa: {F3FF02}%s", SInfo[i][Cena], SInfo[i][Level], SInfo[i][Adresa]);
StanLabel[i] = CreateDynamic3DTextLabel(str, 0x00FF00AA, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ], 10, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
StanPickup[i] = CreateDynamicPickup(1273, 1, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ]);
}
else if(SInfo[i][ImaVlasnika] == 1)
{
format(str, sizeof(str), "{FFFFFF}Vlasnik Stana: {F3FF02}%s\n{FFFFFF}Level: {F3FF02}%d\n{FFFFFF}Adresa: {F3FF02}%s", SInfo[i][Vlasnik], SInfo[i][Level], SInfo[i][Adresa]);
StanLabel[i] = CreateDynamic3DTextLabel(str, 0x00FF00AA, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ], 10, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
StanPickup[i] = CreateDynamicPickup(1273, 1, SInfo[i][UlazX], SInfo[i][UlazY], SInfo[i][UlazZ]);
}
}
printf("Elite Team - Server je ucitao %d stanova", szRows);
SpawnedStanova = szRows;
}
}