<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../Connections/cardshop.asp" -->
<% 

gamename=Trim(Request.QueryString("gamename"))
if gamename ="" then
Response.Write("系統錯誤，請重試!")
response.End()
end if

  %><%

if(gamename <> "") then Command1__a1 = gamename

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_cardshop_STRING
Command1.CommandText = "DELETE FROM game  WHERE gamename ='" + Replace(Command1__a1, "'", "''") + "'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_cardshop_STRING
Command1.CommandText = "DELETE FROM gamecardtype  WHERE gamename ='" + Replace(Command1__a1, "'", "''") + "'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_cardshop_STRING
Command1.CommandText = "DELETE FROM gamedistrict  WHERE gamename ='" + Replace(Command1__a1, "'", "''") + "'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_cardshop_STRING
Command1.CommandText = "DELETE FROM gamefilltype  WHERE gamename ='" + Replace(Command1__a1, "'", "''") + "'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_cardshop_STRING
Command1.CommandText = "DELETE FROM gameserver  WHERE gamename ='" + Replace(Command1__a1, "'", "''") + "'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<% 
response.Redirect("modifygame.asp")
 %>