[MYSQL] Loading teleports stucking the server
#6

PHP код:
stock ReloadTeleports()
{
    
mysql_tquery(sql"SELECT * FROM `Teleports`""ReloadTPS");
    return 
1;
}
forward ReloadTPS();
public 
ReloadTPS()
{
        new 
rows,fields;
        
cache_get_data(rows,fields);
        if(
rows)
        {
            for(new 
0;rows;i++)
            {
                new 
String[64], query[128], Cache:resultgetintgetstr[32], Float:getfloat;
                
getint cache_get_field_content_int(i"ID"); TPDB[i][ID] = getint;
                
cache_get_field_content(i"Description"getstr); format(TPDB[i][Description], 32getstr);
                
getfloat cache_get_field_content_float(i"X1"); TPDB[i][X1] = getfloat;
                
getfloat cache_get_field_content_float(i"Y1"); TPDB[i][Y1] = getfloat;
                
getfloat cache_get_field_content_float(i"Z1"); TPDB[i][Z1] = getfloat;
                
getfloat cache_get_field_content_float(i"A1"); TPDB[i][A1] = getfloat;
                
getint cache_get_field_content_int(i"Interior1"); TPDB[i][Interior1] = getint;
                
getint cache_get_field_content_int(i"VirtualWorld1"); TPDB[i][VirtualWorld1] = getint;
                
getfloat cache_get_field_content_float(i"X2"); TPDB[i][X2] = getfloat;
                
getfloat cache_get_field_content_float(i"Y2"); TPDB[i][Y2] = getfloat;
                
getfloat cache_get_field_content_float(i"Z2"); TPDB[i][Z2] = getfloat;
                
getfloat cache_get_field_content_float(i"A2"); TPDB[i][A2] = getfloat;
                
getint cache_get_field_content_int(i"Interior2"); TPDB[i][Interior2] = getint;
                
getint cache_get_field_content_int(i"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);
            }
        }
        return 
1;

Why looping through 200 tps while you just have to loop through just the created tps? Makes sense huh?
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: 2 Guest(s)