[Dusan01]

can this code lag server because he is starting every 1 second in timer?:

pawn Код:

new Result:total3 = sql_query(mysql, "SELECT * FROM `Players` WHERE `Online`='1'");
sql_store_result(total3);
new ttotal3 = sql_num_rows(total3);
sql_free_result(total3);

that code is used to count for online players.

[Sparke]

I don't think so

[Dignity]

Quote:

Originally Posted by Sparke I don't think so

lol

@OP: Why don't you loop through all the current players? Like this:

pawn Код:

GetOnlinePlayers()
{
    new count;

    for(new i; i < MAX_PLAYERS; i ++)
    {
        if(IsPlayerConnected(i))
        {
            count ++;
        }
    }

    return count;
}

[Sparke]

----

[Dusan01]

Quote:

Originally Posted by Mionee lol @OP: Why don't you loop through all the current players? Like this: pawn Код: GetOnlinePlayers() {     new count;     for(new i; i < MAX_PLAYERS; i ++)     {         if(IsPlayerConnected(i))         {             count ++;         }     }     return count; }

I know that, but i just wanna to know can server lag if he every 1 sec check for number of rows via sql plugin

[Dignity]

Depends on your amount of rows/tables. It'll take a lot of them to make your server lag, but there's no point in doing that.

[Dusan01]

Quote:

Originally Posted by Mionee Depends on your amount of rows/tables. It'll take a lot of them to make your server lag, but there's no point in doing that.

Ok, thanks