<%@ Language="Jscript" %> <% sql = "insert into gamenegotiation (userid, messageid, [timestamp], gameid) values ("; sql += Session("userId") + ", "; sql += "7, "; sql += "'" + getDate() + "', "; sql += Request.QueryString("gameid"); sql += ")"; conn.Execute(sql); var touserid = ""; var toaddress = ""; var toname = ""; var rs = Server.Createobject("adodb.recordset"); var sql = "select * from game where id = " + Request.QueryString("gameid"); rs.open(sql, conn); var user1id = String(rs("user1id")); var user2id = String(rs("user2id")); rs.Close; //send email to user 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 = ""; title = "Challenge declined!"; body = "Hi " + toname + "\n\n"; body += "We are sorry to inform you, that your opponent has declined your challenge.\n"; body += "But we're sure you'll have luck finding another player to challenge at the Empire Deluxe Ladder.\n"; body += "\nThe Empire Deluxe Ladder\n"; body += "www.givoni.com/empire/"; sendEmail(toaddress, title, body); Response.Redirect("../player_data.asp"); %>