<%@ 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" %> <% If Request.Form("Quantity_3") <> "" Then Only_Num(Request.Form("Quantity_3")) Dim Errore = 0 Dim Errore_Only_Num = 0 If Only_Num(Request.Form("Quantity_3")) <> 0 OR Only_Num(Request.Form("Quantity_4")) <> 0 OR Only_Num(Request.Form("Quantity_5")) <> 0 OR Only_Num(Request.Form("Quantity_6")) <> 0 Then Errore_Only_Num = 1 Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",684) &"
" End If If (Request.Form("Quantity_3")) = "" OR (Request.Form("Quantity_4")) = "" OR (Request.Form("Quantity_5")) = "" OR (Request.Form("Quantity_6")) = "" Then Errore_Only_Num = 1 Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",778) &"
" End If If Errore_Only_Num = 0 Then sqlConn.Open() sqlComm = New SqlCommand("SELECT C_Costr_2, C_Costr_3, C_Costr_4, C_Costr_5, C_Costr_6, P_Cittadini FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Pianeti.Id = '"& Id_Paese &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Cittadini_Tassabili = Int(r("P_Cittadini")) If CInt(Request.Form("Quantity_3")) + CInt(Request.Form("Quantity_4")) + CInt(Request.Form("Quantity_5")) + CInt(Request.Form("Quantity_6")) > Var_Cittadini_Tassabili Then Errore = 1 End If If CInt(Request.Form("Quantity_3")) > r("C_Costr_3") * 50 Errore = 3 End If If CInt(Request.Form("Quantity_4")) > r("C_Costr_4") * 50 Errore = 4 End If If CInt(Request.Form("Quantity_5")) > r("C_Costr_5") * 50 Errore = 5 End If If CInt(Request.Form("Quantity_6")) > r("C_Costr_6") * 50 Errore = 6 End If If CInt(Request.Form("Quantity_3")) < 0 OR CInt(Request.Form("Quantity_4")) < 0 OR CInt(Request.Form("Quantity_5")) < 0 OR CInt(Request.Form("Quantity_6")) < 0 Then Errore = 8 End If End While r.Close() sqlConn.Close() If Errore = 1 Then Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",685) &"" End If If Errore = 3 Then Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",686) &"" End If If Errore = 4 Then Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",687) &"" End If If Errore = 5 Then Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",688) &"" End If If Errore = 6 Then Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",689) &"" End If If Errore = 8 Then Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",690) &"" End If Messaggio_Errore.Text = Messaggio_Errore.Text + "
" If Errore = 0 Then Messaggio_Errore.Text = "" sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET P_Costr_3 = "& CInt(Request.Form("Quantity_3")) &", P_Costr_4 = "& CInt(Request.Form("Quantity_4")) &", P_Costr_5 = "& CInt(Request.Form("Quantity_5")) &", P_Costr_6 = "& CInt(Request.Form("Quantity_6")) &" WHERE Pianeti.Id = '"& Id_Paese &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If End If Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write ("
") Dim Cittadini = 0 Dim Fattorie = 0 Dim Troppi_Cittadini = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT R_Ric_4, C_Costr_1, C_Costr_2, C_Costr_3, C_Costr_4, C_Costr_5, C_Costr_6, P_Costr_3, P_Costr_4, P_Costr_5, P_Costr_6, P_Cittadini FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese WHERE Pianeti.Id = '"& Id_Paese &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Cittadini_Tassabili = Split(r("P_Cittadini"),",")(0) Dim Risorsa_1 Dim Risorsa_2 Dim Risorsa_3 Dim Risorsa_4 If User_Race = "Human" Then Risorsa_1 = 0.007 Risorsa_2 = 0.004 Risorsa_3 = 0.003 Risorsa_4 = 0.008 Else If User_Race = "Elf" Then Risorsa_1 = 0.008 Risorsa_2 = 0.003 Risorsa_3 = 0.004 Risorsa_4 = 0.007 Else If User_Race = "Orc" Then Risorsa_1 = 0.007 Risorsa_2 = 0.008 Risorsa_3 = 0.003 Risorsa_4 = 0.004 Else If User_Race = "Undead" Then Risorsa_1 = 0.007 Risorsa_2 = 0.003 Risorsa_3 = 0.008 Risorsa_4 = 0.004 End If If User_Race = "Human" OR User_Race = "Orc" Then Ris_Legna = (Risorsa_1 * (r("P_Costr_3")/50))*6 Ris_Pietra = (Risorsa_2 * (r("P_Costr_4")/50))*6 Ris_Mana = (Risorsa_3 * (r("P_Costr_5")/50))*6 + (Risorsa_3 * (r("P_Costr_5")/50))*6 * (r("R_Ric_4")/20) Ris_Oro = (Risorsa_4 * (r("P_Costr_6")/50))*6 End If If User_Race = "Elf" OR User_Race = "Undead" Then Ris_Legna = (Risorsa_1 * (r("P_Costr_3")/50))*6 Ris_Pietra = (Risorsa_2 * (r("P_Costr_4")/50))*6 + (Risorsa_2 * (r("P_Costr_4")/50))*6 * (r("R_Ric_4")/20) Ris_Mana = (Risorsa_3 * (r("P_Costr_5")/50))*6 Ris_Oro = (Risorsa_4 * (r("P_Costr_6")/50))*6 End If Cittadini = r("P_Cittadini") Fattorie = r("C_Costr_2") If Cittadini > Fattorie*20 Then Troppi_Cittadini = 1 Cittadini = Fattorie*20 End If Var_Cittadini_Liberi = Split(r("P_Cittadini"),",")(0) - Cint(r("P_Costr_3")) - Cint(r("P_Costr_4")) - Cint(r("P_Costr_5")) - Cint(r("P_Costr_6")) Var_Cittadini_Tassabili = Split(r("P_Cittadini"),",")(0) Dim Citt_Arrivo = 0 Dim Citt_Arrivo_1 = CStr(Cint(r("C_Costr_1")*100)-(Split(Cittadini,",")(0))) Dim Citt_Arrivo_2 = CStr(Cint(r("C_Costr_2")*20)-(Split(Cittadini,",")(0))) If Int(Citt_Arrivo_1) > Int(Citt_Arrivo_2) Then Citt_Arrivo = Citt_Arrivo_2 Else Citt_Arrivo = Citt_Arrivo_1 End If Messaggio.Text = "" Messaggio.Text = Messaggio.Text + "

"& Read_File("inc\Lang\Languages.aspx",790) &" " + CStr(Cint(r("C_Costr_1")*100)) Messaggio.Text = Messaggio.Text + "
"& Read_File("inc\Lang\Languages.aspx",691) &" " + CStr(Cint(r("C_Costr_2")*20)) Messaggio.Text = Messaggio.Text + "
"& Read_File("inc\Lang\Languages.aspx",692) &" "& Int(r("P_Cittadini")) Messaggio.Text = Messaggio.Text + "
"& Read_File("inc\Lang\Languages.aspx",693) &" " + CStr(Cint(Var_Cittadini_Liberi)) Messaggio.Text = Messaggio.Text + "
"& Read_File("inc\Lang\Languages.aspx",694) &" "& Citt_Arrivo Messaggio.Text = Messaggio.Text + "
" %>


Gestione Cittadini


<% Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",772) &""& Read_File("inc\Lang\Languages.aspx",695) &""& Read_File("inc\Lang\Languages.aspx",696) &"

"& Read_File("inc\Lang\Languages.aspx",697) &" ["& r("C_Costr_3") &"]"& (Cint((Ris_Legna)*3600)) &"
"& Read_File("inc\Lang\Languages.aspx",698) &" ["& r("C_Costr_4") &"]"& (Cint((Ris_Pietra)*3600)) &"
"& Read_File("inc\Lang\Languages.aspx",699) &" ["& r("C_Costr_5") &"]"& (Cint((Ris_Mana)*3600)) &"
"& Read_File("inc\Lang\Languages.aspx",700) &" ["& r("C_Costr_6") &"]"& ((Cint((Ris_Oro)*3600))) &"
") Response.Write ("


") End While r.Close() sqlConn.Close() If Troppi_Cittadini = 1 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET P_Cittadini = "& Cittadini &" WHERE Pianeti.Id = '"& Id_Paese &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() End If %>