[jaskiller]

hi I want know where is the error in the delete zone :

PHP код:

if(time == 0)
            {
                format(query, sizeof(query), "DELETE FROM time WHERE id = %d ",i );
                mysql_query(query);
                continue;
            }
            format(query, sizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1, i);
            mysql_query(query); 


PHP код:

public CountTimeBan()
{
    new query[129], time;
    for (new i = 1; i < 100 ; i++)
    {
        format(query, sizeof(query), "SELECT time FROM banlist WHERE id = %d",i);
        mysql_query(query);
        mysql_store_result();
        time = mysql_fetch_int();
        if (mysql_num_rows() !=0)
        {
            if(time == 0)
            {
                format(query, sizeof(query), "DELETE FROM time WHERE id = %d ",i );
                mysql_query(query);
                continue;
            }
            format(query, sizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1, i);
            mysql_query(query);
        }
        else
        {
            mysql_free_result();
            continue;
        }
    }
    return 1;
} 


[FuTuяe]

remove continue;

continue is used like this:

if(!isPlayerConnected(playerid)) continue;
Meaning it skips that playerid and goes to the next one.

[jaskiller]

wich continues I must del??

[FuTuяe]

Every continue; in your post.

[jaskiller]

there is new count But the row dosen't be deleted // sorry for bad english

PHP код:

    SetTimer("CountTimeBan", 10000, true); 


PHP код:

    public CountTimeBan()
{
    new query[129], time;
    for (new i = 1; i < 100 ; i++)
    {
        format(query, sizeof(query), "SELECT time FROM banlist WHERE id = %d",i);
        mysql_query(query);
        mysql_store_result();
        time = mysql_fetch_int();
        if (mysql_num_rows() !=0)
        {
            if(time == 0)
            {
                format(query, sizeof(query), "DELETE FROM time WHERE id = %d ",i );
                mysql_query(query);
            }
            else
            {
                format(query, sizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1, i);
                mysql_query(query);
            }
        }
        mysql_free_result();
    }
    return 1;
} 


[jaskiller]

its ok thx