<%@ Language=JScript %> <% var content = ""; //get lastest news var rs = Server.CreateObject("adodb.recordset"); var sql = "SELECT top 1 * FROM news order by [time] desc"; rs.Open(sql, connStr); content += "\n"; if (!(rs.EOF || rs.BOF)) { content += "\n"; content += "\n"; content += "\n"; } rs.Close; content += "
\n"; content += "News"; content += "
(" + dateToScreen(String(rs("time"))) + ")
" + prepScreen(String(rs("title"))) + ""; content += "\n
" + prepScreen(String(rs("text"))).substr(0, 80); content += "
Read more...
\n"; content += "
\n"; content += "
Are you:
\n"; content += "- In love with Empire Deluxe, but need to find someone to play against?
\n"; content += "- Fond of competition and want to be compared to other players?
\n"; content += "- Tired of beating the computer opponents, and want to find someone at your own level?
\n"; content += "- Looking for live games, but can't find an opponent, when you've got the time?
\n"; content += "...then you've come to the right place.

\n"; content += "The Empire Deluxe Ladder is a website dedicated to providing players of this "; content += "classic game a place to find opponents and measure yourselves against each other.
\n"; content += "You can challenge other players, report the result of games you've finished, "; content += "keep informed about the rating of all players and check out everyones personal game history to find your ideal opponent.
"; content += "
\n"; content += "Since this website is created and maintained by an Empire Deluxe fan for other "; content += "Empire Deluxe fans, I would very much appreciate ANY ideas, comments or critique "; content += "that comes into your mind.
\n"; content += "
\n"; content += "Good luck on the war waging,
\n"; content += "
\n"; content += "David Givoni
\n"; content += "(Tell me what you think...)

\n"; content += "
"; content += ""; content += "
"; content += "LATEST GAMES" content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; content += ""; var rs = Server.CreateObject("adodb.recordset"); var sql = "select top 10 *, (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 gamenegotiation.id in "; sql += "(select top 1 id from gamenegotiation where gameid = game.id order by [timestamp] desc)"; sql += " and gamestatus.id = 3 "; sql += " order by [timestamp] desc"; rs.Open(sql, conn); 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 += "
ResultTypeMap sizeCity countDate
"; winnerid = String(rs("winnerid")); content += "" + String(rs("user1name")) + ""; if (String(rs("user2id")) == winnerid) content += " lost to "; else if (String(rs("user1id")) == winnerid) content += " won against "; else content += " tied with "; 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 = "The Empire Deluxe Ladder"; pageTemplate(content, title); %>