<%@ Language=JScript %> <% var gametypeid = String(Request.QueryString("gametypeid")); var content = ""; //get the username var rs = Server.CreateObject("adodb.recordset"); var sql = "select *, (select username from [user] where user.id = user1id) as user1name, (select username from [user] where user.id = user2id) as user2name from (((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 gametype2 on game.gametype2id = gametype2.id "; sql += " WHERE gametype1id = " + gametypeid; sql += " and gamenegotiation.id in "; sql += "(select top 1 id from gamenegotiation where gameid = game.id order by [timestamp] desc)"; sql += " order by [timestamp] desc"; rs.Open(sql, connStr); //get the tournament name var rsT = Server.CreateObject("adodb.recordset"); sql = "SELECT * FROM gametype1 WHERE id = " + gametypeid; rsT.Open(sql, connStr); content += "

" + rsT("name") + " games

"; rsT.Close(); content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; if (!(rs.EOF || rs.BOF)) { var bgcolor = ""; while (!(rs.EOF || rs.BOF)) { if (bgcolor == "#FFF1B5") bgcolor = "#FFF9DB"; else bgcolor = "#FFF1B5"; content += ""; //result content += ""; /*if (messageid == "1" || messageid == "2" || messageid == "4" || messageid == "5") { if (muserid != userid) { if (Session("userid") == userid) content += " - awaiting your accept"; else content += " - awaiting this players accept"; } else content += " - awaiting opponents accept"; }*/ //game type content += ""; //map size content += ""; //city count content += ""; //date content += ""; //action content += ""; content += ""; rs.Movenext; } } content += "

Result	Type	Map size	City count	Date
"; winnerid = String(rs("winnerid")); content += "" + String(rs("user1name")) + ""; if (winnerid != "null") { if (String(rs("user2id")) == winnerid) content += " lost to "; else if (String(rs("user1id")) == winnerid) content += " won against "; else content += " tied with "; } else content += " is playing "; content += "" + String(rs("user2name")) + ""; if (String(rs("rated")) == "1") content += " (rated)"; else content += " (not rated)"; content += "	"; content += String(rs("gametype2.name")); content += "	"; content += String(rs("mapwidth")) + "x" + String(rs("mapheight")); content += "	"; content += String(rs("user1citycount")) + "-" + String(rs("user2citycount")); content += "	"; if (String(rs("gamestatus.id")) == 3) content += dateToScreen(String(rs("completetime"))); else content += dateToScreen(String(rs("createtime"))); content += "	"; content += "details"; content += "

"; var title = "Tournament games"; pageTemplate(content, title); %>