<%@ Language="Jscript" %>
<%
if (Request.Form("submit") == "Send changes to opponent")
{
var messagetypeid = 2;
var user1id = String(Request.Form("user1"));
var user2id = String(Request.Form("user2"));
var rs = Server.CreateObject("adodb.recordset");
var sql = "select * from game where id = " + Request.QueryString("gameid");
rs.open(sql, conn, 0, 3);
rs.Movefirst();
}
else
{
var user1id = Session("userId");
var user2id = Number(Request.Form("opponent"));
var messagetypeid = 1;
var rs = Server.CreateObject("adodb.recordset");
var sql = "select * from game";
rs.open(sql, conn, 0, 3);
rs.AddNew();
}
var mapwidth = String(Request.Form("width"));
var mapheight = String(Request.Form("height"));
var maptypeid = String(Request.Form("maptype"));
var gameversionid = String(Request.Form("gameversion"));
var gametype1id = String(Request.Form("gametype1"));
var gametype2id = String(Request.Form("gametype2"));
var description = String(Request.Form("description"));
var rated = String(Request.Form("rated"));
if (rated == "on")
rated = 1;
else
rated = 0;
rs("createtime") = getDate();
rs("user1id") = Number(user1id);
rs("user2id") = user2id;
rs("mapwidth") = mapwidth;
rs("mapheight") = mapheight;
rs("maptypeid") = maptypeid;
rs("gameversionid") = gameversionid;
rs("gametype1id") = gametype1id;
rs("gametype2id") = gametype2id;
if (description.length > 0)
rs("description") = description;
rs("gamestatusid") = 1;
rs("rated") = rated;
rs.Update();
var newid = String(rs("id"));
sql = "insert into gamenegotiation (userid, messageid, [timestamp], gameid) values (";
sql += Session("userId") + ", ";
sql += messagetypeid + ", ";
sql += "'" + getDate() + "', ";
sql += newid;
sql += ")";
conn.Execute(sql);
rs.Close;
//get the email adress
var touserid = "";
var toaddress = "";
var toname = "";
if (Session("userid") == user1id)
touserid = user2id;
else
touserid = user1id;
sql = "select email, username from [user] where id = " + touserid;
rs.Open(sql);
toaddress = String(rs("email"));
toname = String(rs("username"));
var title = "";
var body = "";
if (Request.Form("submit") == "Send changes to opponent")
{
title = "Counter-challenge!";
body = "Hi " + toname + "\n\n";
body += "You opponent has reviewed your challenge and made some some changes.\n";
body += "Please go to the Empire Deluxe Ladder to check them out.\n";
body += "\nThe Empire Deluxe Ladder\n";
body += "www.givoni.com/empire/";
sendEmail(toaddress, title, body);
}
else
{
title = "Game challenge!";
body = "Hi " + toname + "\n\n";
body += "You have received a challenge to play a game of Empire Deluxe.\n";
body += "Please go to the Empire Deluxe Ladder to accept or decline it.\n";
body += "\nThe Empire Deluxe Ladder\n";
body += "www.givoni.com/empire/";
sendEmail(toaddress, title, body);
}
Response.Redirect("../player_data.asp");
%>