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


-------------------------------------------------------------





") End While r.Close() sqlConn.Close() %>