Posts: 33 Joined: Sun Apr 11 2010, 11:50AM Registered Member #5960
I make a code where player name, score, timp add in database but i don't know here put this code for add the info in database for all server.
<?
$baza = mysql_query("SELECT * FROM jucator WHERE nume = '{$player['name']} AND server = '{$lgsl_server_id}'");
if(mysql_num_rows($baza) > 0 )
{
mysql_query("UPDATE jucator SET nume = '{$player['name']}', score = score + {$player['score']}, timp = timp + {$player['time']} WHERE server = '{$lgsl_server_id}'");
}
else
{
mysql_query("INSERT INTO jucator (server, nume, score, timp) VALUES ('{$lgsl_server_id}', '{$player['name']}', '{$player['score']}', '{$player['time']}')");
}
?>
any idee?
PS: i put this code in lgsl_details but the info has add in database only if i see the info from this server, i want to add info from all server no only one.