%@ 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
%>