<%
if (isLoggedIn())
{
Response.Write("Send a challenge \n");
Response.Write("Report game \n");
if (action)
var style = "style =\"{color: #FF0000; font-weight: bold}\"";
else
var style = "";
Response.Write("My player data \n");
}
if (Session("admin") || Session("coadmin"))
{
Response.Write(" Add news \n");
if (Session("admin"))
Response.Write("SQL query \n");
Response.Write(" \n");
}
%>
Links
<%
//get users registered
var sql = "SELECT count(*) as usercount FROM [user]";
var rs = Server.Createobject("adodb.recordset");
rs.Open(sql, conn);
var usercount = String(rs("usercount"));
rs.Close();
sql = "SELECT count(*) AS gamesplayed FROM game WHERE gamestatusid = 3";
var rs = Server.Createobject("adodb.recordset");
rs.Open(sql, conn);
var gamescount = String(rs("gamesplayed"));
rs.Close();
sql = "SELECT count(*) AS gamesinprogress FROM game WHERE gamestatusid = 2";
var rs = Server.Createobject("adodb.recordset");
rs.Open(sql, conn);
var gamesinprogress = String(rs("gamesinprogress"));
rs.Close();
/*sql = "SELECT count(*) AS gameschallenged FROM game WHERE gamestatusid = 1";
var rs = Server.Createobject("adodb.recordset");
rs.Open(sql, conn);
var gameschallenged = String(rs("gameschallenged"));
rs.Close();
*/
%>
<%
sql = "SELECT TOP 10 username, rating, id ";
sql += ", (select top 1 completetime from game where gamestatusid = 3 AND rated = 1 AND user1rating IS NOT NULL ";
sql += "AND (user1id = user.id OR user2id = user.id) ";
sql += "order by completetime desc) as completetime ";
sql += " FROM [user] ";
sql += " where (select count(game.id) from game inner join gamenegotiation on ";
sql += "gamenegotiation.gameid = game.id where (user1id = user.id or user2id = user.id)";
sql += " and messageid = 6 and rated = 1) > 0";
sql += " ORDER BY rating desc, username asc";
var rs = Server.Createobject("adodb.recordset");
rs.Open(sql, conn);
%>
LADDER TOP 10
<%
i = 1;
var dlimit = new Date();
dlimit = dlimit.setMonth(dlimit.getMonth() - 3);
while (!(rs.EOF || rs.BOF))
{
%>
