for(new b; b < 2;b++) {
chickfree[b] = CreateDynamicPickup(1318,23,chickinfree[b][0],chickinfree[b][1],chickinfree[b][2]);
CreateDynamic3DTextLabel("Íàçâàíèå: {ffffff}Ïèööåðèÿ\n{03c03c}Âëàäåëåö: {ffffff}Ïðàâèòåëüñòâî\n{03c03c}Òèï: {ffffff}Çàêóñî÷íàÿ",0x03c03cFF, chickinfree[b][0],chickinfree[b][1],chickinfree[b][2]+0.904,15.0);
CreateDynamicMapIcon(chickinfree[b][0],chickinfree[b][1],chickinfree[b][2],29,COLOR_WHITE);
}
for(new h; h < 2;h++) {
new str[128];
fermarazd[h] = CreateDynamicPickup(1275,23,ferma[h][0],ferma[h][1],ferma[h][2],-1,-1,-1,100.0);
fermainfo[h] = CreateDynamicPickup(1239,23,ferma[h][3],ferma[h][4],ferma[h][5],-1,-1,-1,100.0);
CreateDynamicMapIcon(ferma[h][3],ferma[h][4],ferma[h][5],56,COLOR_WHITE);
format(str,sizeof(str),"{ffcc00}Ôåðìà ID: {ffffff}%d\n{ffcc00}Ñòîèìîñòü: {ffffff}500000\n{ffcc00}Èíôîðìàöèÿ: {ffffff}/finfo",h);
CreateDynamic3DTextLabel(str,COLOR_ORANGE, ferma[h][3],ferma[h][4],ferma[h][5]+1,10.0);
}
print("1");
//code here
print("2");
//code here
//etc...
|
Debug your code like the following
pawn Код:
|
for(new b; b < 2;b++) {
chickfree[b] = CreateDynamicPickup(1318,23,chickinfree[b][0],chickinfree[b][1],chickinfree[b][2]);
CreateDynamic3DTextLabel("Название: {ffffff}Пиццерия\n{03c03c}Владелец: {ffffff}Правительство\n{03c03c}Тип: {ffffff}Закусочная",0x03c03cFF, chickinfree[b][0],chickinfree[b][1],chickinfree[b][2]+0.904,15.0);
CreateDynamicMapIcon(chickinfree[b][0],chickinfree[b][1],chickinfree[b][2],29,COLOR_WHITE);
}
for(new h; h < 2;h++) {
new str[128];
fermarazd[h] = CreateDynamicPickup(1275,23,ferma[h][0],ferma[h][1],ferma[h][2],-1,-1,-1,100.0);
fermainfo[h] = CreateDynamicPickup(1239,23,ferma[h][3],ferma[h][4],ferma[h][5],-1,-1,-1,100.0);
CreateDynamicMapIcon(ferma[h][3],ferma[h][4],ferma[h][5],56,COLOR_WHITE);
format(str,sizeof(str),"{ffcc00}Ферма ID: {ffffff}%d\n{ffcc00}Стоимость: {ffffff}500000\n{ffcc00}Информация: {ffffff}/finfo",h);
CreateDynamic3DTextLabel(str,COLOR_ORANGE, ferma[h][3],ferma[h][4],ferma[h][5]+1,10.0);
}
stock LoadProperty()
{
print("LoadProp funct started[DEBUG]");
new HOUSE;
new q[128];
new res[256];
new idx;
while(idx < 665)
{
format(q,sizeof(q),"SELECT * FROM DOM_server WHERE ID_h = %d",idx);
mysql_query(q);
mysql_store_result();
new ss;
if(mysql_fetch_row(res))
{
sscanf(res,"p<|>dffffffs[24]dddddddddddffffdd",
ss,
HouseInfo[idx][hEntrancex],
HouseInfo[idx][hEntrancey],
HouseInfo[idx][hEntrancez],
HouseInfo[idx][hExitx],
HouseInfo[idx][hExity],
HouseInfo[idx][hExitz],
HouseInfo[idx][hOwner],
HouseInfo[idx][hValue],
HouseInfo[idx][hHel],
HouseInfo[idx][hInt],
HouseInfo[idx][hLock] ,
HouseInfo[idx][hOwned] ,
HouseInfo[idx][hTakings] ,
HouseInfo[idx][hVec],
HouseInfo[idx][hVcol1],
HouseInfo[idx][hVcol2] ,
HouseInfo[idx][hKlass],
HouseInfo[idx][hVehSost] ,
HouseInfo[idx][hCarx],
HouseInfo[idx][hCary],
HouseInfo[idx][hCarz],
HouseInfo[idx][hCarc],
HouseInfo[idx][hNarko],
HouseInfo[idx][hMoney]);
HOUSE++;
HouseInfo[idx][hPickup] = CreateDynamicPickup(1273,23,HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez]);
HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],31,COLOR_WHITE);
mysql_free_result();
}
}
print("Property LOAD");
return true;
}
return true;
|
Make sure you didn't return 1 anywhere before this code.
EDIT: Remove this: pawn Код:
|
stock LoadProperty()
{
print("LoadProp funct started[DEBUG]");
new idx, ss, res[256];
mysql_query("SELECT * FROM DOM_server");
mysql_store_result();
while(mysql_retrieve_row())
{
sscanf(res,"p<|>dffffffs[24]dddddddddddffffdd",
ss,
HouseInfo[idx][hEntrancex],
HouseInfo[idx][hEntrancey],
HouseInfo[idx][hEntrancez],
HouseInfo[idx][hExitx],
HouseInfo[idx][hExity],
HouseInfo[idx][hExitz],
HouseInfo[idx][hOwner],
HouseInfo[idx][hValue],
HouseInfo[idx][hHel],
HouseInfo[idx][hInt],
HouseInfo[idx][hLock] ,
HouseInfo[idx][hOwned] ,
HouseInfo[idx][hTakings] ,
HouseInfo[idx][hVec],
HouseInfo[idx][hVcol1],
HouseInfo[idx][hVcol2] ,
HouseInfo[idx][hKlass],
HouseInfo[idx][hVehSost] ,
HouseInfo[idx][hCarx],
HouseInfo[idx][hCary],
HouseInfo[idx][hCarz],
HouseInfo[idx][hCarc],
HouseInfo[idx][hNarko],
HouseInfo[idx][hMoney]);
idx++;
HouseInfo[idx][hPickup] = CreateDynamicPickup(1273,23,HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez]);
HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],31,COLOR_WHITE);
}
mysql_free_result();
print("Property LOAD");
return 1;
}
|
This may not be your issue, but please don't use a loop with mysql_query, fetch all the data at once with one query and then you won't need a loop. The function you have at the moment won't work anyway because you do not increase idx.
pawn Код:
|
idx++