<?php
include("/home/xboxlive/public_html/links/class.gamercard.php");
require_once(dirname(__FILE__).'/clearbricks/_common.php');
$dbuser = "xboxlive_smf1";
$dbpass = "HHpsfP3Yokn3nn";
$dbhost = "localhost";
$dbname = "xboxlive_smf1";
$table = "leaderboard";

$msconn = mysql_connect($dbhost, $dbuser, $dbpass);
$db1 = mysql_select_db($dbname, $msconn);

$delete = "TRUNCATE TABLE `$table`";
mysql_query($delete);

$leaderboardsql = mysql_query("SELECT `memberName` FROM `smf_members`");
while($Member = mysql_fetch_array($leaderboardsql)){

if (!empty($this->Real_GamerTag)){
$GamerCard = new GamerCard($Member['memberName']);

$gamertag = $GamerCard->GamerTag;
$gamerscore = $GamerCard->GamerScore;
$sql = mysql_query("INSERT INTO leaderboard (gamertag, score) VALUES ('$gamertag', '$gamerscore')");
}else{
}
}
?>