<%@ Language=JScript %> <% var userid = String(Request.QueryString("userid")); if (userid == "undefined") userid = Session("userid"); var gametype = String(Request.QueryString("gametype")); var content = ""; //get the username var rsUser = Server.CreateObject("adodb.recordset"); var sql = "SELECT * FROM (([user] left join country on user.countryid = country.id) "; sql += "left join timezone on timezone.id = user.timezoneid) "; sql += "WHERE user.id = " + userid; rsUser.Open(sql, connStr); var name = String(rsUser("user.name")); if (name == "null") name = ""; var icq = String(rsUser("icq")); if (icq == "null") icq = ""; var description = prepScreen(String(rsUser("description"))); if (description == "null") description = ""; var country = prepScreen(String(rsUser("country.name"))); if (country == "null") country = ""; var timezone = prepScreen(String(rsUser("timezone"))); if (timezone == "null") timezone = ""; content += ""; content += ""; content += ""; content += ""; content += "

"; if (gametype == "tournament") content += "

Tournament games record

"; else content += "

Games record

"; content += "Username: " + rsUser("username") + " (rating: " + rsUser("rating") + ") "; if (Session("userid") != rsUser("user.id") && isLoggedIn()) content += ""; content += "
"; if (String(rsUser("gameinterest")) == "1") content += "- looking for new games
"; else content += "- NOT looking for new games at the moment
"; content += "

"; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; var rs = Server.CreateObject("adodb.recordset"); var sql = "select * 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 (user1id = " + userid sql += " or user2id = " + userid + ") "; if (gametype == "tournament") sql += " AND (gametype1id = 2 OR gametype1id = 3) " 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"; //Response.write(sql); rs.Open(sql, conn); if (!(rs.EOF || rs.BOF)) { var bgcolor = ""; while (!(rs.EOF || rs.BOF)) { var opponentid = String(rs("user1id")); if (opponentid == userid) opponentid = String(rs("user2id")); if (bgcolor == "#FFF1B5") bgcolor = "#FFF9DB"; else bgcolor = "#FFF1B5"; content += ""; //result content += ""; //opponent content += ""; //status content += ""; //game type content += ""; //map size content += ""; //city count content += ""; //date content += ""; //action content += ""; content += ""; rs.Movenext; } } else { content += ""; content += ""; content += ""; } content += "

My result	Opponent	Status	Type	Map size	City count	Date
"; content += ""; winnerid = String(rs("winnerid")); if (String(rs("gamestatus.id")) == 3) { if (opponentid == winnerid) content += "I lost"; else if (userid == winnerid) content += "I won"; else content += "A draw"; } else { content += " -"; } if (String(rs("rated")) == "1") content += " (rated)"; else content += " (not rated)"; content += ""; content += "	"; var rs2 = Server.CreateObject("adodb.recordset"); sql = "select username, id from [user] where id = " + opponentid; rs2.Open(sql, conn); content += "" + String(rs2("username")) + ""; content += "	"; content += String(rs("gamestatus.name")); var messageid = String(rs("messageid")); var muserid = String(rs("userid")); 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"; } if (messageid == "7") { content += " - declined by "; if (muserid == userid) { content += String(rsUser("username")); } else { content += String(rs2("username")); } } rs2.Close; 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 += "
"; content += "No games registered yet."; content += "

"; content += "

"; var title = "Player data"; pageTemplate(content, title); %>