<?php
// config
$host = 'localhost';
$user = 'css_user';
$database = 'css_db';
$password = 'css_pw';
$table = 'Player';

// script, don't touch
$con = mysql_connect($host,$user,$password) or die('Invalid credentials');
mysql_select_db($database);

$cssrpg = new SQLite3('cssrpg.db');
$res = $cssrpg->query('SELECT * FROM players');
while($p = $res->fetchArray()) {
        $name = mysql_real_escape_string($p[1]);
        $steamid = $p[2];
        $level = $p[3];
        $exp = $p[4];
        $credits = $p[5];
        $lastseen = mktime();
        if($steamid != 'STEAM_ID_PENDING' && $steamid != 'BOT') {
                $q = "INSERT INTO Player (`name`,`steamid`,`level`,`xp`,`credits`,`lastconnected`)
                        VALUES ('$name','$steamid','$level','$exp','$credits','$lastseen')";
                mysql_query($q);
        }
}
?>