%@ Page Language="vb" Debug="true" %> <% @Import NameSpace="System.Data" %> <% @Import NameSpace="System.Data.SQLClient" %> <% @Import NameSpace="System.Diagnostics.Debug" %> <% @Import Namespace="System.Web.Mail" %> <% @Import Namespace="System.Text.RegularExpressions" %> <% @Import NameSpace="System.Data.OleDb" %> <%@ Import namespace="System.IO" %> <%@ Import namespace="System.Net" %> <% Application.Lock %> <% Dim Id_Arrenditi = DeCripta(Request.QueryString("id")) Dim VR = DeCripta(Request.QueryString("VR")) If VR <> "confirm" Then Dim There_Is_Mission = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Type_Mission FROM Missioni WHERE ID = '"& Id_Arrenditi &"' AND Type_Mission = 'Assedio' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() There_Is_Mission = 1 End While r.Close() sqlConn.Close() If There_Is_Mission = 1 Then Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",730) &"")
End If
If There_Is_Mission = 0 Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",729) &"")
End If
End If
If VR = "confirm" Then
Dim There_Is_Mission = 0
Var_Mex_Attacco = "
"& Read_File("inc\Lang\Languages.aspx",600) &"
"
Dim Var_Mex_Attacco_2 = ""
Dim Var_Id_Utente_Ass
Dim Var_Id_Utente_Atk
Dim Var_Coord_Ass
Dim Nome_Paese_Atk
Dim Cont = 0
Dim Id_Arrive
Dim Id_Started
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Id_Arrive, Id_Started, Dimensione, Reame, Paese, Pianeti.Nome, Utenti.Race as Race_Ass, Utenti_Atk.Race as Race_Atk, Utenti_Atk.Id as Id_Utente, Utenti.ID, Type_Soldato, QUantity_Soldato, Time_Started, Time_Arrive, Army_Of, E_Sold_1, E_Sold_2, E_Sold_3, E_Sold_4, E_Sold_5, E_Sold_6, E_Sold_7, E_Sold_8, E_Sold_9, E_Sold_10, E_Sold_11, E_Sold_12, E_Sold_13, E_Sold_14 FROM Missioni JOIN Soldati_In_Missione ON Missioni.Id = Soldati_In_Missione.Id_Missione JOIN Esercito ON Missioni.Id_Arrive = Esercito.Id_Paese JOIN Pianeti ON Pianeti.Id = Missioni.Id_Arrive JOIN Utenti ON Utenti.Username = Pianeti.Proprietary JOIN Utenti as Utenti_Atk ON Utenti_Atk.Username = Missioni.Army_Of WHERE Missioni.ID = '"& Id_Arrenditi &"' AND Missioni.Ritirata <> 'Y' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
There_Is_Mission = 1
Var_Coord_Ass = ""& r("Dimensione") &"."& r("Reame") &"."& r("Paese") &""
Nome_Paese_Atk = r("Nome")
Id_Arrive = r("Id_Arrive")
Id_Started = r("Id_Started")
Var_Army_Of = r("Army_Of")
Var_Time_Started = r("Time_Started")
Var_Time_Arrive = r("Time_Arrive")
Var_Type_Mission = "Attacco"
Dim Var_Row_Esercito_Ass
Dim Var_Row_Esercito_Atk
If Trim(r("Race_Ass")) = "Human" Then
Var_Row_Esercito_Ass = 40
Else If Trim(r("Race_Ass")) = "Elf" Then
Var_Row_Esercito_Ass = 58
Else If Trim(r("Race_Ass")) = "Orc" Then
Var_Row_Esercito_Ass = 76
Else If Trim(r("Race_Ass")) = "Undead" Then
Var_Row_Esercito_Ass = 94
End If
If Trim(r("Race_Atk")) = "Human" Then
Var_Row_Esercito_Atk = 40
Else If Trim(r("Race_Atk")) = "Elf" Then
Var_Row_Esercito_Atk = 58
Else If Trim(r("Race_Atk")) = "Orc" Then
Var_Row_Esercito_Atk = 76
Else If Trim(r("Race_Atk")) = "Undead" Then
Var_Row_Esercito_Atk = 94
End If
Dim y
For y = 1 to 14
If r("Type_Soldato") = "E_Sold_"& y AND r("Quantity_Soldato") > 0 Then
Var_Mex_Attacco = Var_Mex_Attacco + ""& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito_Atk + y) &": "& Int(r("Quantity_Soldato")) &"
"
End If
Next
If Cont = 0 Then
For y = 1 to 14
If r("E_Sold_"& y) > 0 Then
Var_Mex_Attacco_2 = Var_Mex_Attacco_2 + ""& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito_Ass + y) &": "& Int(r("E_Sold_"& y)) &"
"
End If
Next
End If
Var_Id_Utente_Ass = r("Id")
Var_Id_Utente_Atk = r("Id_Utente")
Cont = Cont + 1
End While
r.Close()
sqlConn.Close()
If Var_Army_Of <> Proprietary Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",731) &"")
Response.End
Else If There_Is_Mission = 0 Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",732) &"")
Response.End
Else
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",733) &"")
End If
Var_Mex_Attacco = Var_Mex_Attacco + "
----------------------
"& Read_File("inc\Lang\Languages.aspx",601) &"
" + Var_Mex_Attacco_2
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",734) &" "& Nome_Paese_Atk &" ["& Var_Coord_Ass &"].
"& Read_File("inc\Lang\Languages.aspx",735) &"
" + Var_Mex_Attacco
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente_Atk
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Assedio"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
'MESSAGGIO ALL'ASSEDIATO
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",736) &"
" + Var_Mex_Attacco
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente_Ass
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Assedio"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Var_Time_Started = Replace(Var_Time_Started,".",":")
Var_Time_Started = Format_Date(Var_Time_Started)
m_sql = "INSERT INTO Missioni (Type_Mission, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Time_Started, Time_Arrive, Id_Started, Id_Arrive, Morti_Atk, Morti_Ass, Army_Of, Ritirata) VALUES (@Type_Mission, @Ris_Legna, @Ris_Pietra, @Ris_Mana, @Ris_Oro, @Time_Started, @Time_Arrive, @Id_Started, @Id_Arrive, @Morti_Atk, @Morti_Ass, @Army_Of, @Ritirata)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Type_Mission", sqldbtype.varchar).Value = "Rinforzi"
m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Ris_Mana", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = Data_Adesso
m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = Data_Adesso_Added
m_cmd.Parameters.Add("@Id_Started", sqldbtype.int).Value = Id_Arrive
m_cmd.Parameters.Add("@Id_Arrive", sqldbtype.int).Value = Id_Started
m_cmd.Parameters.Add("@Morti_Atk", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Morti_Ass", sqldbtype.int).Value = "0"
m_cmd.Parameters.Add("@Army_Of", sqldbtype.varchar).Value = Var_Army_Of
m_cmd.Parameters.Add("@Ritirata", sqldbtype.varchar).Value = "Y"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Dim Id_Last_Mission_Created
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Type_Mission = 'Rinforzi' AND Id_Arrive = '"& Id_Started &"' AND Id_Arrive = '"& Id_Started &"' ORDER BY ID", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Last_Mission_Created = r("Id")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Soldati_In_Missione SET Id_Missione = '"& Id_Last_Mission_Created &"' WHERE Id_Missione = '"& Id_Arrenditi &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '"& Id_Arrenditi &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
%>