|
include("http://gorodok.net:8000/godsapper4ever/menu.inc"); ?>
|
|
|
Таблица чемпионата осени-2007 в номинации ' echo $s_name; ?>'
Запущен новый проект:
ролевая командная online игра Minesweeper - Team.
Он находится по адресу: http://minesweeper.ru/team/.
Присоединяйтесь.
№ |
Имя: |
Результат: |
if ($p>3) echo " Кол. смертей: | "; ?>
$link=mysql_connect("localhost", "sapper4ever", "diesooze");
mysql_select_db("sapper4ever",$link);
if (isset($domoderate)){
$decan = $pid;
mysql_query("DELETE FROM newbie WHERE playerid=$decan");
mysql_query("DELETE FROM lover WHERE playerid=$decan");
mysql_query("DELETE FROM profi WHERE playerid=$decan");
mysql_query("DELETE FROM mnewbie WHERE playerid=$decan");
mysql_query("DELETE FROM mlover WHERE playerid=$decan");
mysql_query("DELETE FROM mprofi WHERE playerid=$decan");
mysql_query("DELETE FROM hnewbie WHERE playerid=$decan");
mysql_query("DELETE FROM hlover WHERE playerid=$decan");
mysql_query("DELETE FROM hprofi WHERE playerid=$decan");
mysql_query("DELETE FROM hmnewbie WHERE playerid=$decan");
mysql_query("DELETE FROM hmlover WHERE playerid=$decan");
mysql_query("DELETE FROM hmprofi WHERE playerid=$decan");
mysql_query("INSERT INTO logs (ip) VALUES ('$pid')");
echo mysql_error();
$request="SELECT playerid, scores FROM newbie ORDER BY scores ASC";
$mresult=mysql_query($request);
$oldresult=-1;
$k=0;
while ($row=mysql_fetch_row($mresult))
{
if ($row[1]!=$oldresult)
{
$oldresult=$row[1];
$k++;
}
$request="UPDATE newbie SET pos=".$k." WHERE playerid=".$row[0];
mysql_query($request);
}
$request="SELECT playerid, scores FROM lover ORDER BY scores ASC";
$mresult=mysql_query($request);
$oldresult=-1;
$k=0;
while ($row=mysql_fetch_row($mresult))
{
if ($row[1]!=$oldresult)
{
$oldresult=$row[1];
$k++;
}
$request="UPDATE lover SET pos=".$k." WHERE playerid=".$row[0];
mysql_query($request);
}
$request="SELECT playerid, scores FROM profi ORDER BY scores ASC";
$mresult=mysql_query($request);
$oldresult=-1;
$k=0;
while ($row=mysql_fetch_row($mresult))
{
if ($row[1]!=$oldresult)
{
$oldresult=$row[1];
$k++;
}
$request="UPDATE profi SET pos=".$k." WHERE playerid=".$row[0];
mysql_query($request);
}
$request="SELECT playerid, scores FROM mnewbie ORDER BY scores ASC";
$mresult=mysql_query($request);
$oldresult=-1;
$k=0;
while ($row=mysql_fetch_row($mresult))
{
if ($row[1]!=$oldresult)
{
$oldresult=$row[1];
$k++;
}
$request="UPDATE mnewbie SET pos=".$k." WHERE playerid=".$row[0];
mysql_query($request);
}
$request="SELECT playerid, scores FROM mlover ORDER BY scores ASC";
$mresult=mysql_query($request);
$oldresult=-1;
$k=0;
while ($row=mysql_fetch_row($mresult))
{
if ($row[1]!=$oldresult)
{
$oldresult=$row[1];
$k++;
}
$request="UPDATE mlover SET pos=".$k." WHERE playerid=".$row[0];
mysql_query($request);
}
$request="SELECT playerid, scores FROM mprofi ORDER BY scores ASC";
$mresult=mysql_query($request);
$oldresult=-1;
$k=0;
while ($row=mysql_fetch_row($mresult))
{
if ($row[1]!=$oldresult)
{
$oldresult=$row[1];
$k++;
}
$request="UPDATE mprofi SET pos=".$k." WHERE playerid=".$row[0];
mysql_query($request);
}
}
if ($p==1) $ttype="newbie";
if ($p==2) $ttype="lover";
if ($p==3) $ttype="profi";
if ($p==4) $ttype="mnewbie";
if ($p==5) $ttype="mlover";
if ($p==6) $ttype="mprofi";
//mysql_query("DELETE FROM mprofi WHERE playerid=1236");
$request="SELECT playerid, scores, death, pos FROM ".$ttype." ORDER BY pos ASC";
$result=mysql_query($request);
$k=0;
$ks=0;
while (($k<29) && ($row=mysql_fetch_row($result)))
{
$request="SELECT howtowrite FROM gamers WHERE id=".$row[0];
$result2=mysql_query($request);
$row2=mysql_fetch_row($result2);
$k=$row[3];
$ks++;
echo " ".$row[3]." | ";
echo "".$row2[0]." | ";
echo "".$row[1]." | ";
if ($p>3) echo "".$row[2]." | ";
if (isset($passw))
if ($passw='giftmoderate')
echo " | ";
echo " ";
}
echo " ";
$request="SELECT playerid, frompos, topos, result, date_format(date,'%e.%m.%Y %H:%i') as date1
FROM h".$ttype."
ORDER BY date DESC";
$result=mysql_query($request);
$k=0;
while (($k<10) && ($row=mysql_fetch_row($result)))
{
$k++;
$ks+=2;
$request="SELECT howtowrite FROM gamers WHERE id=".$row[0];
$result2=mysql_query($request);
$htw=mysql_fetch_row($result2);
echo "".$row[4]." ".$htw[0]."
прислал(а) результат ".$row[3]." и занял(а)
".$row[2]." место";
if ($row[1]>0) echo " (был(а) на ".$row[1]."-м)";
echo "; ";
}
?>
* * *
|
|