[FosterK]

Hello everyone,

I would like to load data via MySQL.
When the ID is in the order (0, 1, 2, etc) the script works fine, but when I delete the entries (0,2,6,7) script bug

Here is my script:

Код:

public LoadPockets()
{
    new fields[61][40], row[150], row2[150];
    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();
	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();
}

I'm stuck on this problem from two days.
Thank you in advance to whoever can help me

[BroZeus]

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();
}

[FosterK]

Thank you so infact it works until it gets to the time that id has been removed, so what should be done is to "jump" the deleted id (2 => 4).
Resolved, thx !

[Blademaster680]

If you want to reorder the ID's in your database. you can delete the ID column and then recreate it again and it will automatically put everyone in order again. so if there are ID 1, 2, 3, 4. And I delete ID 2. It will end up 1, 3, 4. But if you delete and recreate the column ID. it will now be: 1, 2, 3.