Help!, MYSQL Load
#1

Hi, i made this code, but always print me: [MYSQL]: ERROR GANGS...
What's my mistake?
PHP код:
forward LoadZones();
public 
LoadZones()
{
    new 
arrCoords[12][64];
    new 
string[256];
    new 
row [512];
    new 
idx;
    while (
idx sizeof(GangInfo))
    {
        
format(stringsizeof(string), "SELECT * FROM `zones` WHERE zID=%d",idx);
        
mysql_query_ex(string);
        
mysql_store_result();
        if(
mysql_num_rows() > 0)
        {
            
mysql_fetch_row(row);
            
split(rowarrCoords'|');
            
mysql_free_result();
            
strmid(GangInfo[idx][zName], arrCoords[1], 0strlen(arrCoords[1]), 255);
            
GangInfo[idx][zMinX] = floatstr(arrCoords[2]);
            
GangInfo[idx][zMinY] = floatstr(arrCoords[3]);
            
GangInfo[idx][zMaxX] = floatstr(arrCoords[4]);
            
GangInfo[idx][zMaxY] = floatstr(arrCoords[5]);
            
GangInfo[idx][zCPX] = floatstr(arrCoords[6]);
            
GangInfo[idx][zCPY] = floatstr(arrCoords[7]);
            
GangInfo[idx][zCPZ] = floatstrl(arrCoords[8]);
            
GangInfo[idx][zTeam] = strval(arrCoords[9]);
            
GangInfo[idx][zMoney] = strval(arrCoords[10]);
            
GangInfo[idx][zEXP] = strval(arrCoords[11]);
        }
        else
        {
            
printf("[MYSQL]: ERROR GANGS (from %s)."SQL_DB);
        }
        
mysql_free_result();
        
idx++;
        
CP[idx] = CreateDynamicCP(GangInfo[idx][zCPX], GangInfo[idx][zCPY], GangInfo[idx][zCPZ], 2, -1, -1, -1100.0);
        
Zone[idx] = GangZoneCreate(GangInfo[idx][zMinX], GangInfo[idx][zMinY], GangInfo[idx][zMaxX], GangInfo[idx][zMaxY]);
    }
    
printf("[MYSQL]: GangZones loaded from MYSQL (from %s)."SQL_DB);
    return 
1;

Reply


Messages In This Thread
Help!, MYSQL Load - by CoR3 - 07.03.2015, 01:33
Re: Help!, MYSQL Load - by X337 - 07.03.2015, 02:37
Re: Help!, MYSQL Load - by CoR3 - 07.03.2015, 04:00

Forum Jump:


Users browsing this thread: 2 Guest(s)