MySql loading
#1

PHP код:
funktsioon LoadProperty()
{
    new
        
result[128], idxsql[256];
    for(new 
1<= kokkuMajui++)
    {
        
format(sqlsizeof(sql), "SELECT * FROM `majad` WHERE `id` = '%d'"i);
        
mysql_query(sql);
        
mysql_store_result();
        if(
mysql_fetch_row_format(sql,"|"))
        {
            
mysql_fetch_field_row(result,"Owned"); KasutajaMajaInfo[i][hOwned] = strval(result);
            
mysql_fetch_field_row(result,"Owner"); KasutajaMajaInfo[i][hOwner] = strval(result);
            
mysql_fetch_field_row(result,"Description"); strmid(KasutajaMajaInfo[i][hDescription], result0strlen(result), 255);//
            
mysql_fetch_field_row(result,"Value"); KasutajaMajaInfo[i][hValue] = strval(result);
            
mysql_fetch_field_row(result,"Level"); KasutajaMajaInfo[i][hLevel] = strval(result);
            
mysql_fetch_field_row(result,"Locked"); KasutajaMajaInfo[i][hLocked] = strval(result);
            
mysql_fetch_field_row(result,"LeaseDate"); KasutajaMajaInfo[i][hLeaseDate] = strval(result);
            
mysql_fetch_field_row(result,"EntranceX"); KasutajaMajaInfo[i][hEntranceX] = floatstr(result);
            
mysql_fetch_field_row(result,"EntranceY"); KasutajaMajaInfo[i][hEntranceY] = floatstr(result);
            
mysql_fetch_field_row(result,"EntranceZ"); KasutajaMajaInfo[i][hEntranceZ] = floatstr(result);
            
mysql_fetch_field_row(result,"InteriorX"); KasutajaMajaInfo[i][hInteriorX] = floatstr(result);
            
mysql_fetch_field_row(result,"InteriorY"); KasutajaMajaInfo[i][hInteriorY] = floatstr(result);
            
mysql_fetch_field_row(result,"InteriorZ"); KasutajaMajaInfo[i][hInteriorZ] = floatstr(result);
            
mysql_fetch_field_row(result,"InteriorId"); KasutajaMajaInfo[i][hInterior] = strval(result);
            
mysql_fetch_field_row(result,"HealthUpgrade"); KasutajaMajaInfo[i][hHealthUpgrade] = strval(result);
            
mysql_fetch_field_row(result,"ArmourUpgrade"); KasutajaMajaInfo[i][hKappUpgrade] = strval(result);
            
mysql_fetch_field_row(result,"RentAble"); KasutajaMajaInfo[i][hRentable] = strval(result);
            
mysql_fetch_field_row(result,"Rent"); KasutajaMajaInfo[i][hRent] = strval(result);
            
mysql_fetch_field_row(result,"Bank"); KasutajaMajaInfo[i][hBank] = strval(result);
            
mysql_fetch_field_row(result,"Narko"); KasutajaMajaInfo[i][hProds] = strval(result);
            
mysql_fetch_field_row(result,"Mats1"); KasutajaMajaInfo[i][hMats][0] = strval(result);
            
mysql_fetch_field_row(result,"Mats2"); KasutajaMajaInfo[i][hMats][1] = strval(result);
            
mysql_fetch_field_row(result,"Mats3"); KasutajaMajaInfo[i][hMats][2] = strval(result);
            
mysql_fetch_field_row(result,"Address"); strmid(KasutajaMajaInfo[i][hAddress], result0strlen(result), 64);
            
idx++;
        }
        
mysql_free_result();
    }
    
printf("[MySQL] Loaded %d houses."idx);

Help me to make it load faster
Reply


Messages In This Thread
MySql loading - by Porgand - 08.05.2014, 11:49
Re: MySql loading - by MichealScript - 08.05.2014, 11:51
Re: MySql loading - by Konstantinos - 08.05.2014, 11:52
Re: MySql loading - by iZN - 08.05.2014, 11:52
Re: MySql loading - by Porgand - 08.05.2014, 11:58

Forum Jump:


Users browsing this thread: 2 Guest(s)