<%@ Page Language="vb" Debug="true" ValidateRequest="false" %> <% @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" %> <%@ Import namespace="System.Drawing" %> <% If Request.QueryString("Page") = "Indossa" Then Dim Id_Artefact = 0 Dim Type_Artefact = "" sqlConn.Open() sqlComm = New SqlCommand("SELECT Artefact.Id, Artefact.Artefact_Type FROM Artefact WHERE Id_Utente = '"& Id_Utente &"' AND Id = '"& Request.QueryString("Artefatto") &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Artefact = r("Id") Type_Artefact = Trim(r("Artefact_Type")) End While r.Close() sqlConn.Close() If Id_Artefact <> 0 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Gen_"& Type_Artefact &"_Id = "& Id_Artefact &" WHERE Id = "& Id_Utente &" ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If 'For i = 1 to 100 ' Response.write ("0"& i + 881 &" -
") 'Next Dim There_Is_General = 0 Dim Gen_Neck_Id = 0 Dim Gen_Helm_Id = 0 Dim Gen_Back_Id = 0 Dim Gen_Right_Hand_Id = 0 Dim Gen_Left_Hand_Id = 0 Dim Gen_Gauntlets_Id = 0 Dim Gen_Legs_Id = 0 Dim Gen_Chest_Id = 0 Dim y = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Gen_Nome, Gen_Razza, Gen_Allineamento, Gen_Classe, Gen_Racial_Hate, Gen_Stats, Gen_Talenti, Gen_Lvl, Gen_Lvl_Exp, Gen_Right_Hand_Id, Gen_Left_Hand_Id, Gen_Helm_Id, Gen_Neck_Id, Gen_Chest_Id, Gen_Gauntlets_Id, Gen_Legs_Id, Gen_Back_Id, Artefact.Id, Artefact.Artefact_Name, Artefact.Artefact_Desc, Artefact.Artefact_Bonus_Type, Artefact.Artefact_Bonus_Who, Artefact.Artefact_Bonus_How FROM Utenti LEFT JOIN Artefact ON Artefact.Id_Utente = "& Id_Utente &" AND (Utenti.Gen_Right_Hand_Id = Artefact.Id OR Utenti.Gen_Left_Hand_Id = Artefact.Id OR Utenti.Gen_Helm_Id = Artefact.Id OR Utenti.Gen_Neck_Id = Artefact.Id OR Utenti.Gen_Chest_Id = Artefact.Id OR Utenti.Gen_Gauntlets_Id = Artefact.Id OR Utenti.Gen_Legs_Id = Artefact.Id OR Utenti.Gen_Back_Id = Artefact.Id) WHERE Username = '"& Proprietary &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Gen_Nome") Is System.DbNull.Value Then Response.Redirect ("crea_generale.aspx") End If Gen_Neck_Id = r("Gen_Neck_Id") Gen_Helm_Id = r("Gen_Helm_Id") Gen_Back_Id = r("Gen_Back_Id") Gen_Right_Hand_Id = r("Gen_Right_Hand_Id") Gen_Left_Hand_Id = r("Gen_Left_Hand_Id") Gen_Gauntlets_Id = r("Gen_Gauntlets_Id") Gen_Legs_Id = r("Gen_Legs_Id") Gen_Chest_Id = r("Gen_Chest_Id") Dim Var_Row_Esercito_Human = 113 Dim Var_Row_Esercito_Elf = 131 Dim Var_Row_Esercito_Orc = 149 Dim Var_Row_Esercito_Undead = 167 If Not r("Id") Is System.DbNull.Value AND Not r("Gen_Neck_Id") Is System.DbNull.Value AND Not r("Gen_Helm_Id") Is System.DbNull.Value AND Not r("Gen_Back_Id") Is System.DbNull.Value AND Not r("Gen_Right_Hand_Id") Is System.DbNull.Value AND Not r("Gen_Right_Hand_Id") Is System.DbNull.Value AND Not r("Gen_Left_Hand_Id") Is System.DbNull.Value AND Not r("Gen_Gauntlets_Id") Is System.DbNull.Value AND Not r("Gen_Legs_Id") Is System.DbNull.Value AND Not r("Gen_Chest_Id") Is System.DbNull.Value Then If r("Id") = r("Gen_Neck_Id") OR r("Id") = r("Gen_Helm_Id") OR r("Id") = r("Gen_Back_Id") OR r("Id") = r("Gen_Right_Hand_Id") OR r("Id") = r("Gen_Left_Hand_Id") OR r("Id") = r("Gen_Gauntlets_Id") OR r("Id") = r("Gen_Legs_Id") OR r("Id") = r("Gen_Chest_Id") Then If r("Id") = r("Gen_Neck_Id") Then y = 1 ElseIf r("Id") = r("Gen_Helm_Id") Then y = 2 ElseIf r("Id") = r("Gen_Back_Id") Then y = 3 ElseIf r("Id") = r("Gen_Right_Hand_Id") Then y = 4 ElseIf r("Id") = r("Gen_Left_Hand_Id") Then y = 5 ElseIf r("Id") = r("Gen_Gauntlets_Id") Then y = 6 ElseIf r("Id") = r("Gen_Legs_Id") Then y = 7 ElseIf r("Id") = r("Gen_Chest_Id") Then y = 8 End If Response.Write ("") End If End If If There_Is_General = 0 If Not r("Gen_Nome") Is System.DbNull.Value Then There_Is_General = 1 Response.Write ("



Generale di "& Proprietary &"


") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Dim x = r("Gen_Racial_Hate") Dim i = 0 While x > 0 i = i + 1 x = x - 14 End While Dim Esercito_Row If i = 1 Then Esercito_Row = 41 Else If i = 2 Then Esercito_Row = 59 Else If i = 3 Then Esercito_Row = 77 Else If i = 4 Then Esercito_Row = 95 End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") For i = 1 to 50 If Mid(r("Gen_Talenti"),i,"1") = "1" Then Response.Write ("") Response.Write ("") End If Next Response.Write ("
Nome:"& r("Gen_Nome") &"
Razza:"& r("Gen_Razza") &"
Allineamento:"& r("Gen_Allineamento") &"
Livello:"& r("Gen_Lvl") &" ") If Check_Level(r("Gen_Lvl_Exp")) > r("Gen_Lvl") Then Response.Write ("[Level UP!]") End If Response.Write ("
Punti Esperienza: "& r("Gen_Lvl_Exp") &"
Classe:"& r("Gen_Classe") &"
Odio Razziale:"& Read_File("inc\Lang\Languages.aspx",41 + r("Gen_Racial_Hate") - 1 + (i*4 - 4)) &"


Caratteristiche:

Forza: "& Delete_Zeri((Mid(r("Gen_Stats"),"1","3")),"3") &"
Destrezza: "& Delete_Zeri((Mid(r("Gen_Stats"),"4","3")),"3") &"
Costituzione: "& Delete_Zeri((Mid(r("Gen_Stats"),"7","3")),"3") &"
Intelligenza: "& Delete_Zeri((Mid(r("Gen_Stats"),"10","3")),"3") &"
Saggezza: "& Delete_Zeri((Mid(r("Gen_Stats"),"13","3")),"3") &"
Carisma: "& Delete_Zeri((Mid(r("Gen_Stats"),"16","3")),"3") &"


Talenti:

"& Read_File("inc\Lang\Languages.aspx",920 - 1 + i) &"




") Else Response.Redirect ("crea_generale.aspx") End If End If End While r.Close() sqlConn.Close() Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("
") If Gen_Neck_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") If Gen_Helm_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") If Gen_Back_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("
") If Gen_Right_Hand_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") If Gen_Left_Hand_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("
") If Gen_Gauntlets_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") If Gen_Chest_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("

") If Gen_Legs_Id <> 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("
") %>