cancel($UPDATE_TIMER);

$BARON_UPDATE_INTERVAL = 10000; //Update list every 10 seconds

$nullObj = new SimObject();
function sqlNullCallback()
{
}

function sqlExecute(%sql)
{
    dbi.Execute(%sql, sqlNullCallback, $nullObj);
}

function onTimerElapsed()
{
    echo("Updating" SPC ClientGroup.getCount() SPC "players...");
    sqlExecute("DELETE FROM baron_players");
    sqlExecute("ALTER TABLE baron_players AUTO_INCREMENT = 1");
        for(%id = 0; %id < ClientGroup.getCount(); %id++)
        {
                %client = ClientGroup.getObject(%id);
                %pid = %client.getCharacterId();
                updatePlayer(%pid,%client);
        }
    $UPDATE_TIMER = schedule($BARON_UPDATE_INTERVAL, 0, "onTimerElapsed");
}

$UPDATE_TIMER = schedule(100, 0, "onTimerElapsed");

function updatePlayer(%pid, %obj)
{
        echo("Updating player " @ %pid);
    sqlExecute("INSERT INTO baron_players (CharacterID) VALUES (" @ %pid @ ")");
}