mysql error
#5

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

PHP код:
    SetTimer("CountTimeBan"10000true); 
PHP код:
    public CountTimeBan()
{
    new 
query[129], time;
    for (new 
1100 i++)
    {
        
format(querysizeof(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(querysizeof(query), "DELETE FROM time WHERE id = %d ",);
                
mysql_query(query);
            }
            else
            {
                
format(querysizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1i);
                
mysql_query(query);
            }
        }
        
mysql_free_result();
    }
    return 
1;

Reply


Messages In This Thread
mysql error - by jaskiller - 06.01.2012, 11:18
Re: mysql error - by FuTuяe - 06.01.2012, 11:44
Re : mysql error - by jaskiller - 06.01.2012, 11:52
Re: mysql error - by FuTuяe - 06.01.2012, 13:43
Re : mysql error - by jaskiller - 06.01.2012, 17:18
Re : mysql error - by jaskiller - 06.01.2012, 21:50

Forum Jump:


Users browsing this thread: 1 Guest(s)