<%@ Language=JScript %> <% //get game details var rs = Server.CreateObject("adodb.recordset"); var sql = "select *, (select username from [user] where user1id = user.id) as user1name, "; sql += "(select username from [user] where user2id = user.id) as user2name from "; sql += "((((((game inner join gamenegotiation on game.id = gamenegotiation.gameid) "; sql += "inner join gamestatus on game.gamestatusid = gamestatus.id) "; sql += "inner join gameversion on game.gameversionid = gameversion.id) "; sql += "inner join gametype1 on game.gametype1id = gametype1.id) "; sql += "inner join gametype2 on game.gametype2id = gametype2.id) "; sql += "inner join maptype on game.maptypeid = maptype.id) "; sql += "where game.id = " + Request.QueryString("gameid"); sql += " and gamenegotiation.id in "; sql += "(select top 1 id from gamenegotiation where gameid = game.id order by [timestamp] desc)"; rs.Open(sql, conn); var description = String(rs("description")); if (description == "null") description = ""; var content = ""; content += "

" + rs("user1name") + " vs. " + rs("user2name") + "

\n"; //date content += "\n"; if (String(rs("gamestatus.id")) == 3) content += String(rs("completetime")); else content += String(rs("createtime")); content += "
\n"; //status content += "Status: " + String(rs("gamestatus.name")); //result content += "\n"; content += "\n"; var formaction = ""; if (String(rs("gamestatus.id")) == "1") formaction = "exe/challenge_user_exe.asp?gameid=" + Request.QueryString("gameid"); else formaction = "exe/report_game_exe.asp?gameid=" + Request.QueryString("gameid"); content += "\n"; content += "\n"; content += "\n"; if (String(rs("gamestatus.id")) == "3") { content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; } content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; if (String(rs("gamestatus.id")) == "3") { content += " \n"; content += " \n"; content += " \n"; content += " \n"; } content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; if (String(rs("rated")) == "1") selected = "checked"; else selected = ""; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += " \n"; content += "
\n"; content += " Players:"; content += " \n"; content += rs("user1name"); content += "  "; content += rs("user2name"); content += "
\n"; content += " City count:"; content += " \n"; content += " - \n"; content += "
\n"; content += " Map dimensions (width x height):"; content += " \n"; content += " x \n"; content += "
\n"; content += " Map type:"; content += " \n"; //get all maps var rs2 = Server.CreateObject("adodb.recordset"); var sql = "SELECT id, name FROM maptype"; rs2.Open(sql, connStr); content += "\n"; content += "
\n"; content += " Duration (no. of turns):"; content += " \n"; content += " \n"; content += "
\n"; content += " Game version:"; content += " \n"; //get all users var sql = "SELECT id, name FROM gameversion"; rs2.Open(sql, connStr); content += "\n"; content += "
\n"; content += " Game type:"; content += " \n"; //get all users var sql = "SELECT id, name FROM gametype1"; rs2.Open(sql, connStr); content += " "; //get all users var sql = "SELECT id, name FROM gametype2"; rs2.Open(sql, connStr); content += "\n"; content += "
\n"; content += " Rated game:"; content += " \n"; content += " \n"; content += "
\n"; content += " Other comments:"; content += " \n"; content += " \n"; content += "
\n"; content += "   "; if (String(rs("messageid")) != "3") content += "\n"; content += "
\n"; var title = "Change game details"; pageTemplate(content, title); %>