[kamilot73]

Hi! When I use this code

PHP код:

while(mysql_retrieve_row())
    {
                new res[256];
                mysql_fetch_row(res);
                print(res);
                sscanf(res,"p<|>dffffffs[24]dddddddddddffffdd",HouseInfo[idx][hID],
                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]);
                if(HouseInfo[idx][hOwned] == 0)
                {
                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);
                 }
                 else if(HouseInfo[idx][hOwned] == 1)
                 {
                 HouseInfo[idx][hPickup] = CreateDynamicPickup(19133,23,HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez]);
                 HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],32,COLOR_WHITE);
            }
           idx ++;
        } 


When server started loading home loaded via a
For Example: ID 0, ID 2, ID 4.. Why?

THIS log from Debug

PHP код:

[15:13:46] CMySQLHandler::FetchRow() - Return: 227|2091.6|-1184.3|27.0571|2261.31|-1136.45|1050.63|Строительная компания|45000|0|10|0|0|0|0|0|0|0|0|2079.58|-1185.76|23.8164|357.763|0|0
[15:13:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:13:46] >> mysql_fetch_row_format( Connection handle: 1 )
[15:13:46] CMySQLHandler::FetchRow() - Return: 229|2022.88|-1120.27|26.421|225.976|1239.91|1082.14|Строительная компания|70000|0|2|0|0|0|0|0|0|1|0|2013.31|-1120.08|26.2031|177.52|0|0
[15:13:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:13:46] >> mysql_fetch_row_format( Connection handle: 1 ) 


[Siralos]

Instead of this:

pawn Код:

while(mysql_retrieve_row()) 
    { 
                new res[256]; 
                mysql_fetch_row(res);

Do this

pawn Код:

new res[256];
while(mysql_fetch_row(res)) 
    {

[kamilot73]

Quote:

Originally Posted by Siralos Instead of this: pawn Код: while(mysql_retrieve_row())     {                 new res[256];                 mysql_fetch_row(res); Do this pawn Код: new res[256]; while(mysql_fetch_row(res))     {

Wow) i am noob)) Thx you) FIXED))