<%@ 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" %> <% Dim Id_Quest = Request.QueryString("Id") Dim Is_Ok = 0 Dim Prize_Quantity Dim Prize_Resource Dim Id_Artefact Response.Write ("

Completa Quest


") sqlConn.Open() sqlComm = New SqlCommand("SELECT Quest.Id_Quest, Quest.Title_Quest, Quest.Description, Quest.Number_Items, Quest.Item_Name, Quest.Prize_Quantity, Quest.Prize_Resource, Item_Quest.Item_Name as Item_Quest_Name, Quest.Prize_Artefact, Count(*) AS Totale_Pezzi FROM Quest LEFT JOIN Item_Quest ON Quest.Id_Quest = Item_Quest.Id_Quest AND Item_Quest.Id_Utente = '"& Id_Utente &"' WHERE Quest.Id_Quest = "& Id_Quest &" GROUP BY Item_Quest.Item_Name, Quest.Id_Quest, Quest.Title_Quest, Quest.Item_Name, Quest.Number_Items, Item_Quest.Item_Name, Quest.Description, Quest.Prize_Quantity, Quest.Prize_Resource, Quest.Prize_Artefact ORDER BY Quest.Id_Quest ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Prize_Quantity = r("Prize_Quantity") Prize_Resource = r("Prize_Resource") 'Response.Write (r("Title_Quest")) If r("Totale_Pezzi") = r("Number_Items") Then Is_Ok = 1 End If Id_Artefact = r("Prize_Artefact") End While r.Close() sqlConn.Close() If Is_Ok = 1 Then If Prize_Resource = "Legna" Then SqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = Ris_Legna + "& Prize_Quantity &" WHERE Proprietary = '"& Proprietary &"' AND Is_Principal = 1 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Else If Prize_Resource = "Pietra" Then SqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Pietra = Ris_Pietra + "& Prize_Quantity &" WHERE Proprietary = '"& Proprietary &"' AND Is_Principal = 1 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Else If Prize_Resource = "Mana" Then SqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Mana = Ris_Mana + "& Prize_Quantity &" WHERE Proprietary = '"& Proprietary &"' AND Is_Principal = 1 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Else If Prize_Resource = "Oro" Then SqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Oro = Ris_Oro + "& Prize_Quantity &" WHERE Proprietary = '"& Proprietary &"' AND Is_Principal = 1 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If Dim Data_End_Quest = Datetime.Now Data_End_Quest = Replace(Data_End_Quest,".",":") Data_End_Quest = Format_Date(Data_End_Quest) SqlConn.Open() sqlComm = New SqlCommand("UPDATE Quest SET Quest_Status = 'Completed', Winner = '"& Proprietary &"', Date_End = '"& Data_End_Quest &"' WHERE Id_Quest = '"& Id_Quest &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() SqlConn.Open() sqlComm = New SqlCommand("UPDATE Artefact SET Id_Utente = "& Id_Utente &" WHERE Id = '"& Id_Artefact &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() SqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Item_Quest WHERE Id_Quest = '"& Id_Quest &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT Quest.Id_Quest, Quest.Title_Quest, Quest.Description, Quest.Number_Items, Quest.Item_Name, Quest.Prize_Quantity, Quest.Prize_Resource, Item_Quest.Item_Name as Item_Quest_Name, Artefact.Artefact_Name, Artefact.Artefact_Desc, Artefact.Artefact_Bonus_Type, Artefact.Artefact_Bonus_Who, Artefact.Artefact_Bonus_How, Count(*) AS Totale_Pezzi FROM Quest LEFT JOIN Item_Quest ON Quest.Id_Quest = Item_Quest.Id_Quest AND Item_Quest.Id_Utente = '"& Id_Utente &"' LEFT JOIN Artefact ON Quest.Prize_Artefact = Artefact.Id GROUP BY Item_Quest.Item_Name, Quest.Id_Quest, Quest.Title_Quest, Quest.Item_Name, Quest.Number_Items, Item_Quest.Item_Name, Quest.Description, Quest.Prize_Quantity, Quest.Prize_Resource, Artefact.Artefact_Name, Artefact.Artefact_Desc, Artefact.Artefact_Bonus_Type, Artefact.Artefact_Bonus_Who, Artefact.Artefact_Bonus_How ORDER BY Quest.Id_Quest ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("Hai completato la quest: ") Response.Write (r("Title_Quest")) Response.Write ("
") Response.Write ("
") Response.Write ("Hai ottenuto:") Response.Write ("
") If (r("Prize_Quantity") <> 0) Then Response.Write ("Premio in Risorse: ") Response.Write (r("Prize_Quantity") &" "& r("Prize_Resource")) Response.Write ("
") Response.Write ("
") End If If (r("Artefact_Name") <> "") Then Response.Write ("Premio Artefatto: ") Response.Write (r("Artefact_Name")) Response.Write ("
") Response.Write ("Bonus Artefatto: + "& r("Artefact_Bonus_How") &" % su "& r("Artefact_Bonus_Type") &" a soldati di "& r("Artefact_Bonus_Who") &"° Livello:") Response.Write ("
") Response.Write ("
") Response.Write ("
") End If End While r.Close() sqlConn.Close() End If %>