<%@ 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" %> <% Dim Data Dim Errore_Movimento = 0 Dim Position = "" Dim Page = Request.QueryString("Page") If Page = "Move" Then Dim Pos_To_Go = Request.QueryString("Position") sqlConn.Open() sqlComm = New SqlCommand("SELECT Position, Data_Last_Move FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Utenti.Username = '"& Username &"' AND Soldiers.Id = '"& Id_This_Soldier &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Position = Trim(r("Position")) If (Position = "A" AND Pos_To_Go = "C") OR (Position = "A" AND Pos_To_Go = "B") Then Errore_Movimento = 1 End If If (Position = "B" AND Pos_To_Go = "A") OR (Position = "B" AND Pos_To_Go = "D") Then Errore_Movimento = 1 End If If (Position = "C" AND Pos_To_Go = "E") OR (Position = "C" AND Pos_To_Go = "A") Then Errore_Movimento = 1 End If If (Position = "D" AND Pos_To_Go = "B") OR (Position = "D" AND Pos_To_Go = "G") Then Errore_Movimento = 1 End If If (Position = "E" AND Pos_To_Go = "C") OR (Position = "E" AND Pos_To_Go = "F") Then Errore_Movimento = 1 End If If (Position = "F" AND Pos_To_Go = "E") OR (Position = "F" AND Pos_To_Go = "D") OR (Position = "F" AND Pos_To_Go = "G") Then Errore_Movimento = 1 End If If (Position = "G" AND Pos_To_Go = "F") OR (Position = "G" AND Pos_To_Go = "D") Then Errore_Movimento = 1 End If Data = Format_Date(r("Data_Last_Move")) Data = CDate(Data) If Datetime.now < Data.AddDays(1) Errore_Movimento = 0 End If End While r.Close() sqlConn.Close() Data = Format_Date_2(DateTime.Now) If Errore_Movimento = 1 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Position = '"& Pos_To_Go &"', Data_Last_Move = '"& Data &"' WHERE Id = '"& Id_This_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If %>

Scheda Soldato
") Response.Write ("

<% sqlConn.Open() sqlComm = New SqlCommand("SELECT Position, Name, Sex, Class, Data_Last_Move, Data_Last_Atk, Soldiers.Level, Pf_Now, PF_Max, Exp, Level_Points, Items.Id as Id_Item_1, Items2.Id as Id_Item_2, Items3.Id as Id_Item_3, Items4.Id as Id_Item_4, Items.Level as Item_Level, Items2.Level as Item_Level2, Items3.Level as Item_Level3, Items4.Level as Item_Level4, S_STR, S_DEX, S_INT, Soldiers.Id as Id_Soldier, Items.Item_Name as Items1, Items2.Item_Name as Items2, Items3.Item_Name as Items3, Items4.Item_Name as Items4, Items.Valore as Valore_Items1, Items2.Valore as Valore_Items2, Items3.Valore as Valore_Items3, Items4.Valore as Valore_Items4 FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente LEFT JOIN Items ON Soldiers.Right_Arm = Items.Id LEFT JOIN Items as Items2 ON Soldiers.Left_Arm = Items2.Id LEFT JOIN Items as Items3 ON Soldiers.Armor = Items3.Id LEFT JOIN Items as Items4 ON Soldiers.Magic_Item = Items4.Id WHERE Utenti.Username = '"& Username &"' AND Soldiers.Id = '"& Id_This_Soldier &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Position = r("Position") Response.Write ("") Response.Write ("") Dim Right_Hand = r("Items1") Dim Left_Hand = r("Items2") Dim Armor = r("Items3") Dim Magic_Item = r("Items4") Dim Valore_Items1 = r("Valore_Items1") Dim Valore_Items2 = r("Valore_Items2") Dim Valore_Items3 = r("Valore_Items3") Dim Valore_Items4 = r("Valore_Items4") If Right_Hand Is System.DbNull.Value Then Right_Hand = "Vuoto" Valore_Items1 = 0 End If If Left_Hand Is System.DbNull.Value Then Left_Hand = "Vuoto" Valore_Items2 = 0 End If If Armor Is System.DbNull.Value Then Armor = "Vuoto" Valore_Items3 = 0 End If If Magic_Item Is System.DbNull.Value Then Magic_Item = "Vuoto" Valore_Items4 = 0 End If Response.Write ("

") Response.Write ("Nome: "& r("Name") &"") If r("Sex") = "m" Then Response.Write ("
Sesso: Maschio") End If If r("Sex") = "f" Then Response.Write ("
Sesso: Femmina") End If Response.Write ("
Classe: "& r("Class") &"") Response.Write ("
Livello: "& r("Level") &"") Response.Write ("
PF: "& r("PF_Now") &"/"& r("Pf_Max") &"") Response.Write ("
Exp: "& r("Exp") &"/"& r("Level")*100 &"") Response.Write ("
") Response.Write ("
Str: "& r("S_STR") &" + "& Valore_Items1 &" = "& r("S_STR") + Valore_Items1 &"") Response.Write ("
Ar: "& r("S_DEX") &" + "& Valore_Items2 &" + "& Valore_Items3 &" = "& r("S_DEX") + Valore_Items2 + Valore_Items3 &"") Response.Write ("
Int: "& r("S_INT") &" + "& Valore_Items4 &" = "& r("S_INT") + Valore_Items4 &"") Response.Write ("
") If Right_Hand <> "Vuoto" Then Response.Write ("") End If Response.Write ("
Mano Destra: "& Right_Hand &"

") If Right_Hand <> "Vuoto" Then Response.Write ("
") End If If Left_Hand <> "Vuoto" Then Response.Write ("") End If Response.Write ("Mano Sinistra: "& Left_Hand &"
") If Left_Hand <> "Vuoto" Then Response.Write ("
") End If If Armor <> "Vuoto" Then Response.Write ("") End If Response.Write ("Armatura: "& Armor &"
") If Armor <> "Vuoto" Then Response.Write ("
") End If If Magic_Item <> "Vuoto" Then Response.Write ("") End If Response.Write ("Oggetto Magico: "& Magic_Item &"") If Magic_Item <> "Vuoto" Then Response.Write ("") End If If r("Level_Points") > 0 Then Response.Write ("

Hai "& r("Level_Points") &" Level Points da distribuire.") End If Response.Write ("
") If Datetime.Now < CDate(Format_Date(r("Data_Last_Move"))).AddDays(1) Then Response.Write ("

Data Ultimo Movimento:
"& CDate(Format_Date(r("Data_Last_Move")))&"") Else Response.Write ("

Questo soldato puņ effettuare un movimento sulla Mappa.") End If If Datetime.Now < CDate(Format_Date(r("Data_Last_Atk"))).AddDays(1) Then Response.Write ("

Data Ultimo Attacco:
"& CDate(Format_Date(r("Data_Last_Atk"))) &"") Else Response.Write ("

Questo soldato puņ effettuare un attacco.") End If If r("PF_Now") < 1 Then Response.Write ("

"& r("Name") &" č morto. Clicca qui per farlo tornare in vita.") End If Response.Write ("

") If Right_Hand = "Vuoto" Then Response.Write ("") End If If Right_Hand <> "Vuoto" Then Response.Write ("") End If Response.Write ("") If Left_Hand = "Vuoto" Then Response.Write ("") End If If Left_Hand <> "Vuoto" Then Response.Write ("") End If Response.Write ("
") Response.Write ("
") If Armor = "Vuoto" Then Response.Write ("") End If If Armor <> "Vuoto" Then Response.Write ("") End If Response.Write ("") If Magic_Item = "Vuoto" Then Response.Write ("") End If If Magic_Item <> "Vuoto" Then Response.Write ("") End If Response.Write ("
") End While r.Close() sqlConn.Close() If Errore_Movimento = 1 Then Response.Write ("

Ti sei correttamente spostato.
") End If If Errore_Movimento = 0 AND Page = "Move" Then Response.Write ("

Non č ancora passato un giorno dal tuo ultimo movimento.
") End If If Trim(Position) = "A" Then Response.Write ("

Ti trovi nel Villaggio.

") End If If Trim(Position) = "B" Then Response.Write ("

Ti trovi alla Miniera.

") End If If Trim(Position) = "C" Then Response.Write ("

Ti trovi nella Foresta Nebbiosa.

") End If If Trim(Position) = "D" Then Response.Write ("

Ti trovi al Castello dei Leoni.

") End If If Trim(Position) = "E" Then Response.Write ("

Ti trovi al Monte Nero.

") End If If Trim(Position) = "F" Then Response.Write ("

Ti trovi al Portale.

") End If If Trim(Position) = "G" Then Response.Write ("

Ti trovi al Castello dei Falchi.

") End If Response.Write ("

") Response.Write ("") If Trim(Position) = "F" Or Trim(Position) = "D" Then Response.Write ("") End If If Trim(Position) = "E" Or Trim(Position) = "D" Or Trim(Position) = "G" Then Response.Write ("") End If If Trim(Position) = "A" Or Trim(Position) = "D" Then Response.Write ("") End If If Trim(Position) = "B" Or Trim(Position) = "G" Then Response.Write ("") End If If Trim(Position) = "C" Or Trim(Position) = "F" Then Response.Write ("") End If If Trim(Position) = "E" Or Trim(Position) = "A" Then Response.Write ("") End If If Trim(Position) = "C" Or Trim(Position) = "B" Then Response.Write ("") End If Response.Write ("
") %>