%@ 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" %>
<%
Response.Write ("
Pannello 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, Artefact.Artefact_Name, Artefact.Artefact_Desc, Artefact.Artefact_Bonus_Type, Artefact.Artefact_Bonus_Who, Artefact.Artefact_Bonus_How, Count(*) AS Totale_Pezzi, Data_Termine 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 WHERE Quest_Status = 'Incompleted' 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, Data_Termine ORDER BY Quest.Id_Quest ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Dim Var_Row_Esercito_Human = 113
Dim Var_Row_Esercito_Elf = 131
Dim Var_Row_Esercito_Orc = 149
Dim Var_Row_Esercito_Undead = 167
Response.Write (r("Title_Quest"))
Response.Write ("
")
Response.Write ("
")
Response.Write ("Descrizione Quest:
")
Response.Write (Replace(r("Description"),VbCrLf,"
"))
Response.Write ("
")
Response.Write ("
")
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 ("
")
Response.Write ("Descrizione Artefatto:
")
Response.Write (Replace(r("Artefact_Desc"),VbCrLf,"
"))
Response.Write ("
")
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 ("- "& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito_Human - 73 + r("Artefact_Bonus_Who") ) &" ")
Response.Write ("
")
Response.Write ("- "& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito_Elf - 73 + r("Artefact_Bonus_Who") ) &" ")
Response.Write ("
")
Response.Write ("- "& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito_Orc - 73 + r("Artefact_Bonus_Who") ) &" ")
Response.Write ("
")
Response.Write ("- "& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito_Undead - 73 + r("Artefact_Bonus_Who") ) &" ")
Response.Write ("
")
Response.Write ("
")
End If
Response.Write ("Oggetti Trovati:")
Response.Write ("
")
Response.Write (r("Item_Name") & ": ")
If r("Item_Quest_Name") Is System.DbNull.Value Then
Response.Write ("[0/"& r("Number_Items") &"]")
Else
Response.Write ("["& r("Totale_Pezzi") &"/"& r("Number_Items") &"]")
End If
Response.Write ("
Data Termine Quest: "& r("Data_Termine") &"
")
If r("Data_Termine") < Datetime.Now AND r("Totale_Pezzi") <> r("Number_Items") Then
Response.Write ("
Attenzione: Usando il pulsante Termina Quest, colui che attualmente ha più frammenti degli altri automaticamente li radunerà tutti vincendo la Quest. L'unico modo per essere certi che sia tu è che tu abbia il 50% + 1 dei frammenti :) ")
Response.Write ("
Termina Quest")
End If
If r("Totale_Pezzi") = r("Number_Items") Then
Response.Write ("
Completa Quest")
End If
Response.Write ("
-------------------------------------------------------------