[MYSQL] Loading teleports stucking the server
#1

PHP код:
stock ReloadTeleports()
{
    new 
String[64], query[128], Cache:resultgetintgetstr[32], Float:getfloat;
    for(new 
0MAX_TELEPORTSi++)
    {
        
mysql_format(sqlquerysizeof query"SELECT * FROM `Teleports` WHERE `ID` = %d"i);
        
result mysql_query(sqlquery);
        if(
cache_num_rows())
        {
        
getint cache_get_field_content_int(0"ID"); TPDB[i][ID] = getint;
        
cache_get_field_content(0"Description"getstr); format(TPDB[i][Description], 32getstr);
        
getfloat cache_get_field_content_float(0"X1"); TPDB[i][X1] = getfloat;
        
getfloat cache_get_field_content_float(0"Y1"); TPDB[i][Y1] = getfloat;
        
getfloat cache_get_field_content_float(0"Z1"); TPDB[i][Z1] = getfloat;
        
getfloat cache_get_field_content_float(0"A1"); TPDB[i][A1] = getfloat;
        
getint cache_get_field_content_int(0"Interior1"); TPDB[i][Interior1] = getint;
        
getint cache_get_field_content_int(0"VirtualWorld1"); TPDB[i][VirtualWorld1] = getint;
        
getfloat cache_get_field_content_float(0"X2"); TPDB[i][X2] = getfloat;
        
getfloat cache_get_field_content_float(0"Y2"); TPDB[i][Y2] = getfloat;
        
getfloat cache_get_field_content_float(0"Z2"); TPDB[i][Z2] = getfloat;
        
getfloat cache_get_field_content_float(0"A2"); TPDB[i][A2] = getfloat;
        
getint cache_get_field_content_int(0"Interior2"); TPDB[i][Interior2] = getint;
        
getint cache_get_field_content_int(0"VirtualWorld2"); TPDB[i][VirtualWorld2] = getint;
        
        
format(String,sizeof(String),"[Teleport: %d]\n%s"iTPDB[i][Description]);
        
TPEnter[i] = CreateDynamic3DTextLabel(String0xFFFFFFFFTPDB[i][X1], TPDB[i][Y1], TPDB[i][Z1], 20INVALID_PLAYER_IDINVALID_VEHICLE_ID1TPDB[i][VirtualWorld1], TPDB[i][Interior1], -150.0);
        
TPExit[i] = CreateDynamic3DTextLabel(String0xFFFFFFFFTPDB[i][X2], TPDB[i][Y2], TPDB[i][Z2], 20INVALID_PLAYER_IDINVALID_VEHICLE_ID1TPDB[i][VirtualWorld2], TPDB[i][Interior2], -150.0);
        }
        
cache_delete(result);
    }

there is any way to make it work faster?
Reply


Messages In This Thread
[MYSQL] Loading teleports stucking the server - by Lirbo - 29.05.2017, 23:06
Re: [MYSQL] Loading teleports stucking the server - by StrikerZ - 30.05.2017, 07:55
Re: [MYSQL] Loading teleports stucking the server - by Lirbo - 30.05.2017, 09:38
Re: [MYSQL] Loading teleports stucking the server - by StrikerZ - 30.05.2017, 09:39
Re: [MYSQL] Loading teleports stucking the server - by Lirbo - 30.05.2017, 11:59
Re: [MYSQL] Loading teleports stucking the server - by StrikerZ - 30.05.2017, 12:11
Re: [MYSQL] Loading teleports stucking the server - by ShihabSoft - 31.05.2017, 00:25

Forum Jump:


Users browsing this thread: 1 Guest(s)