Problem loading MySQL datas
#2

not sure but try this --
pawn Код:
public LoadPockets()
{
    new fields[61][40], row[150], row2[150];
    new r;//added this
    new Pockets_Count;
    new query[128];
    format(query, sizeof(query), "SELECT COUNT(*) FROM server_pockets");
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_row(row2);
    Pockets_Count = strval(row2);
    if(!mysql_num_rows()) { mysql_free_result(); return; }
    for(new i=1; i <= Pockets_Count; i++)
    {
    format(query, sizeof(query), "SELECT * FROM server_pockets WHERE id = %d", i);
    mysql_query(query);
    mysql_store_result();
        r = mysql_num_rows();//added this
        if(!r)continue; //added this
    mysql_fetch_row(row);
    split(row, fields, '|');
        PocketInfos[i][ID] = strval(fields[0]);
        PocketInfos[i][OBJECTID] = strval(fields[1]);
        PocketInfos[i][CHARACTER] = strval(fields[2]);
        TotalPockets++;
    mysql_free_result();
    }
    mysql_free_result();
}
Reply


Messages In This Thread
Problem loading MySQL datas - by FosterK - 29.07.2014, 13:15
Re: Problem loading MySQL datas - by BroZeus - 29.07.2014, 13:57
Re : Problem loading MySQL datas - by FosterK - 29.07.2014, 14:15
Re: Problem loading MySQL datas - by Blademaster680 - 29.07.2014, 20:42

Forum Jump:


Users browsing this thread: 1 Guest(s)