programación

new score

include_once ("_data.php");
$conn = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name,$conn);

if ($pass==$add_pass) {

if ($u_user==1) {

$sql3 = "SELECT name FROM $db_table ORDER BY name";
$result3 = mysql_query($sql3);
while($r = mysql_fetch_object($result3))
{
$tmp = "{$r->name}";
if ($name==$tmp) {
$n_exist=1;

}
}
if ($n_exist==1) {
$sql1 = "UPDATE $db_table SET score='$score' WHERE name=\"$name\"";
$result1 = mysql_query($sql1);
} else {
$sql1 = "INSERT INTO $db_table (name,score) VALUES (\"$name\",\"$score\")";
$result1 = mysql_query($sql1);
}

} else {
$sql1 = "INSERT INTO $db_table (name,score) VALUES (\"$name\",\"$score\")";
$result1 = mysql_query($sql1);
}

$sql2 = "SELECT id FROM $db_table ORDER BY score DESC";
$result2 = mysql_query($sql2);

$num = 1;
while($r = mysql_fetch_object($result2))
{
$result = mysql_db_query($db_name,"SELECT * from $db_table WHERE id='{$r->id}'");
$resultArray = mysql_fetch_array($result);
$did = $resultArray["id"];
$name = $resultArray["name"];
$score = $resultArray["score"];
if ($num>$sec_size) {
$sql3 = "DELETE FROM $db_table WHERE id='$did'";
$result3 = mysql_query($sql3);
}
$num++;
}
}

mysql_close ($conn);
?>



get score


<=$sec_size) { $HTML = " " . $m_font . $num . " " . $m_font . $name . " " . $m_font . $score . " "; echo "$HTML"; } } else { if ($num<=$st_size) { if ($flash) { echo "&name$num=$name&score$num=$score"; } else { $HTML = " " . $m_font . $num . " " . $m_font . $name . " " . $m_font . $score . " "; echo "$HTML"; } $num++; } } } if (!$flash) { if ($sec==1) { $HTM_2 = " " . $t_font . "Top" . $st_size . " "; } else { $HTM_2 = " " . $t_font . "Top" . $sec_size . " "; } echo "$HTM_2"; } mysql_close ($conn); ?>




EQUIPO DE FACEBOOK

Andrea Arias
Josue Brito
Jorge Cucalon