%@ 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" %>
<%
Dim Page = Request.QueryString ("Page")
If Page = "assolda" Then
Dim Soldato = Request.QueryString ("Soldato")
Response.Write ("
")
If Soldato = 1 Then
Response.Write ("Vuoi davvero assoldare:
")
Response.Write ("Classe: Guerriero
")
Response.Write ("Sesso: Maschio
")
Response.Write ("Ti costerà 10000 Monete d'Oro
")
Response.Write ("CONFERMA")
End If
If Soldato = 2 Then
Response.Write ("Vuoi davvero assoldare:
")
Response.Write ("Classe: Guerriero
")
Response.Write ("Sesso: Femmina
")
Response.Write ("Ti costerà 10000 Monete d'Oro
")
Response.Write ("CONFERMA")
End If
If Soldato = 3 Then
Response.Write ("Vuoi davvero assoldare:
")
Response.Write ("Classe: Arciere
")
Response.Write ("Sesso: Maschio
")
Response.Write ("Ti costerà 10000 Monete d'Oro
")
Response.Write ("CONFERMA")
End If
If Soldato = 4 Then
Response.Write ("Vuoi davvero assoldare:
")
Response.Write ("Classe: Arciere
")
Response.Write ("Sesso: Femmina
")
Response.Write ("Ti costerà 10000 Monete d'Oro
")
Response.Write ("CONFERMA")
End If
If Soldato = 5 Then
Response.Write ("Vuoi davvero assoldare:
")
Response.Write ("Classe: Mago
")
Response.Write ("Sesso: Maschio
")
Response.Write ("Ti costerà 10000 Monete d'Oro
")
Response.Write ("CONFERMA")
End If
If Soldato = 6 Then
Response.Write ("Vuoi davvero assoldare:
")
Response.Write ("Classe: Mago
")
Response.Write ("Sesso: Femmina
")
Response.Write ("Ti costerà 10000 Monete d'Oro
")
Response.Write ("CONFERMA")
End If
End If
If Page = "assolda_confirm" Then
Response.Write ("
")
If Money_This_User < 10000 Then
Response.Write ("Non hai abbastanza denaro!!!
")
End If
If Total_Soldier > 9 Then
Response.Write ("Hai raggiunto il numero massimo di Soldati!!!
")
End If
Dim Soldato = Request.QueryString ("Soldato")
If Not Money_This_User < 10000 AND Total_Soldier < 10 AND Soldato < 7 Then
Dim Classe
Dim Sex
Dim C_Str
Dim C_Dex
Dim C_Int
If Soldato = 1 Then
Response.Write ("Hai assoldato:
")
Response.Write ("Classe: Guerriero
")
Response.Write ("Sesso: Maschio
")
Classe = "Warrior"
Sex = "m"
C_Str = 2
C_Dex = 1
C_Int = 1
End If
If Soldato = 2 Then
Response.Write ("Hai assoldato:
")
Response.Write ("Classe: Guerriero
")
Response.Write ("Sesso: Femmina
")
Classe = "Warrior"
Sex = "f"
C_Str = 2
C_Dex = 1
C_Int = 1
End If
If Soldato = 3 Then
Response.Write ("Hai assoldato:
")
Response.Write ("Classe: Arciere
")
Response.Write ("Sesso: Maschio
")
Classe = "Archer"
Sex = "m"
C_Str = 1
C_Dex = 2
C_Int = 1
End If
If Soldato = 4 Then
Response.Write ("Hai assoldato:
")
Response.Write ("Classe: Arciere
")
Response.Write ("Sesso: Femmina
")
Classe = "Archer"
Sex = "f"
C_Str = 1
C_Dex = 2
C_Int = 1
End If
If Soldato = 5 Then
Response.Write ("Hai assoldato:
")
Response.Write ("Classe: Mago
")
Response.Write ("Sesso: Maschio
")
Classe = "Mage"
Sex = "m"
C_Str = 1
C_Dex = 1
C_Int = 2
End If
If Soldato = 6 Then
Response.Write ("Hai assoldato:
")
Response.Write ("Classe: Mago
")
Response.Write ("Sesso: Femmina
")
Classe = "Mage"
Sex = "f"
C_Str = 1
C_Dex = 1
C_Int = 2
End If
Dim m_conn
Dim m_cmd
dim m_sql as String = "INSERT INTO Soldiers (Id_Utente, Name, Sex, Class, Exp, Level, Level_Points, PF_Max, PF_Now, S_STR, S_DEX, S_INT, Right_Arm, Left_Arm, Armor, Magic_Item, Position, Data_Last_Move, Data_Last_Atk, Last_Attacked) VALUES (@Id_Utente, @Name, @Sex, @Class, @Exp, @Level, @Level_Points, @PF_Max, @PF_Now, @S_STR, @S_DEX, @S_INT, @Right_Arm, @Left_Arm, @Armor, @Magic_Item, @Position, @Data_Last_Move, @Data_Last_Atk, @Last_Attacked)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User
m_cmd.Parameters.Add("@Name", sqldbtype.varchar).Value = "Nuovo_Soldato"
m_cmd.Parameters.Add("@Sex", sqldbtype.char).Value = Sex
m_cmd.Parameters.Add("@Class", sqldbtype.varchar).Value = Classe
m_cmd.Parameters.Add("@Exp", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Level", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@PF_Max", sqldbtype.int).Value = 50
m_cmd.Parameters.Add("@PF_Now", sqldbtype.int).Value = 50
m_cmd.Parameters.Add("@S_STR", sqldbtype.int).Value = C_Str
m_cmd.Parameters.Add("@S_DEX", sqldbtype.int).Value = C_Dex
m_cmd.Parameters.Add("@S_INT", sqldbtype.int).Value = C_Int
m_cmd.Parameters.Add("@Right_Arm", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Left_Arm", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Armor", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Magic_Item", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Level_Points", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Position", sqldbtype.char).Value = "A"
m_cmd.Parameters.Add("@Data_Last_Move", sqldbtype.datetime).Value = "10/10/2002 0.00.01"
m_cmd.Parameters.Add("@Data_Last_Atk", sqldbtype.datetime).Value = "10/10/2002 0.00.01"
m_cmd.Parameters.Add("@Last_Attacked", sqldbtype.datetime).Value = "10/10/2002 0.00.01"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Money = Money - 10000 WHERE Id = '"& Id_This_User &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
End If
If Page = "" Then
%>
|
Nome: X
Sesso: Maschio
Classe: Guerriero
Livello: 1
Str: 2
Dex: 1
Int: 1
|
ASSOLDA |
----------------------------------------------- |
|
Nome: X
Sesso: Femmina
Classe: Guerriero
Livello: 1
Str: 2
Dex: 1
Int: 1
|
ASSOLDA |
----------------------------------------------- |
|
Nome: X
Sesso: Maschio
Classe: Arciere
Livello: 1
Str: 1
Dex: 2
Int: 1
|
ASSOLDA |
----------------------------------------------- |
|
Nome: X
Sesso: Femmina
Classe: Arciere
Livello: 1
Str: 1
Dex: 2
Int: 1
|
ASSOLDA |
----------------------------------------------- |
|
Nome: X
Sesso: Maschio
Classe: Mago
Livello: 1
Str: 1
Dex: 1
Int: 2
|
ASSOLDA |
----------------------------------------------- |
|
Nome: X
Sesso: Femmina
Classe: Mago
Livello: 1
Str: 1
Dex: 1
Int: 2
|
ASSOLDA |
<%
End If
%>