<%@ Page Language="vb" Debug="true" %> <% @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 There_Is_General = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Generali WHERE Proprietary = '" + Proprietary + "' AND Is_Dead <> 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() There_Is_General = 1 End While r.Close() sqlConn.Close() If There_Is_General = 1 Then %> Pannello Generale


 

Nome Generale

<% sqlConn.Open() sqlComm = New SqlCommand("SELECT Nome FROM Generali WHERE Proprietary = '" + Proprietary + "' AND Is_Dead <> 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Txt_Nome_Generale.Text = r("Nome") %>
<% End While r.Close() sqlConn.Close() %>




 
 

Scheda Generale

<% sqlConn.Open() sqlComm = New SqlCommand("SELECT Scheda FROM Generali WHERE Proprietary = '" + Proprietary + "' AND Is_Dead = 0 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Txt_Scheda_Generale.Text = Replace(r("Scheda"),"
",VbCrLf) %>
<% End While r.Close() sqlConn.Close() %>




 
 

Avatar Generale





<% Dim Pagina Pagina = Request.ServerVariables("PATH_TRANSLATED") Pagina = Mid(Pagina,1,Len(Pagina)-Len(Split(StrReverse(Pagina),"\")(0))-1) Pagina = Mid(Pagina,1,Len(Pagina)-Len(Split(StrReverse(Pagina),"\")(0))) Pagina = Pagina + "\public\Avatar_Generali_" sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Generali WHERE Proprietary = '" + Proprietary + "' AND Is_Dead = 0 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If File.Exists(Pagina & r("Id") & ".jpg") = True Then %>.jpg" width="120" height="120"><% End If End While r.Close() sqlConn.Close() %>
 
 

Dati Generale

<% sqlConn.Open() sqlComm = New SqlCommand("SELECT Livello, Exp FROM Generali WHERE Proprietary = '" + Proprietary + "' AND Is_Dead = 0 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() %>Livello del Generale: <%=r("Livello")%>

Punti Esperienza del Generale: <%=r("Exp")%>

<% End While r.Close() sqlConn.Close() %>
 
<% End If If There_Is_General = 0 Then %>Non hai alcun Generale nel tuo Esercito<% End If %>