public void UpdateCoconuts(int SendedAmount = 0, int ReceivedAmount = 0)
{
this.ReceivedCoconuts += ReceivedAmount;
this.SendedCoconuts += SendedAmount;
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", this.ID);
DatabaseClient.SetParameter("@SendedAmount", SendedAmount);
DatabaseClient.SetParameter("@ReceivedAmount", ReceivedAmount);
DatabaseClient.ExecuteScalar("UPDATE boombang_users SET SendedCoconuts = SendedCoconuts+@SendedAmount, ReceivedCoconuts = ReceivedCoconuts+@ReceivedAmount WHERE ID = @ID");
}
if (SessionsManager.Online(ID))
{
if (this.SpaceInstance != null)
{
if (this.SpaceInstance is AreaInstance)
{
AreaInstance Area = (AreaInstance)this.SpaceInstance;
Area.SendToAll(new ServerMessage(new byte[] { 146 }, new object[] { this.ID, 5, this.SendedCoconuts, this.ReceivedCoconuts }));
}
if (this.SpaceInstance is SalaInstance)
{
SalaInstance Sala = (SalaInstance)this.SpaceInstance;
Sala.SendToAll(new ServerMessage(new byte[] { 146 }, new object[] { this.ID, 5, this.SendedCoconuts, this.ReceivedCoconuts }));
}
}
}
}
public static bool Register(string UserName, string Password, int Avatar, string Colors, int Age, string EMail, string IP)
{
if (CheckUserName(UserName) && CheckEMail(EMail))
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
try
{
DatabaseClient.SetParameter("@UserName", UserName);
DatabaseClient.SetParameter("@Password", Convert.ToBase64String(SHA1.Create().ComputeHash(Utils.Encoding.StringToByteArray(Password))));
DatabaseClient.SetParameter("@Avatar", Avatar);
DatabaseClient.SetParameter("@Colors", Colors);
DatabaseClient.SetParameter("@Age", Age);
DatabaseClient.SetParameter("@EMail", EMail);
DatabaseClient.SetParameter("@IP", IP);
DatabaseClient.SetParameter("@Time", Time.ToString(DateTime.Now));
DatabaseClient.ExecuteScalar("INSERT INTO boombang_users (UserName, Passwoed, EMail, Age, RegisterIP, LastIP, Avatar, Colors, Register, LastLogin) VALUES (@UserName, @Password, @EMail, @Age, @IP, @IP, @Avatar, @Colors, @Time, @Time)");
return(true);
}
catch
{
return(false);
}
}
}
}
static void Main(string[] args)
{
try
{
AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException);
Console.Title = Constants.ConsoleTitle;
Console.CursorVisible = false;
Console.SetWindowSize(Constants.ConsoleWidowsWidth, Constants.ConsoleWindowHeight);
DateTime Timer1 = DateTime.Now;
Output.WriteHeader();
ConfigurationManager.Initialize();
DatabaseManager.Initialize();
SpacesManager.Initialize();
CatalogManager.Initialize();
ChestManager.Initialize();
SessionsManager.Initialize();
SocketManager.Initialize();
Input.Initialize();
using (DatabaseClient client = DatabaseManager.GetClient())
{
client.ExecuteScalar("UPDATE boombang_statics SET Clients=0 WHERE ID = 1");
}
Output.WriteLine("Server started seddefully (" + new TimeSpan(DateTime.Now.Ticks + Timer1.Ticks).TotalSeconds + " seconds)! Press the enter key to execute a command.");
}
catch (Exception ex)
{
Output.WriteLine("Can't initialize the server. Exception: " + ex.ToString(), OutputLevel.CriticalError);
Console.ReadKey();
}
}
public static bool UserExists(string UserName)
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@UserName", UserName);
int result = Convert.ToInt32(DatabaseClient.ExecuteScalar("SELECT COUNT(*) FROM boombang_users WHERE UserName = @UserName"));
return((result > 0) ? true : false);
}
}
public void UpdateMessageBox(string MessageBox)
{
this.MessageBox = MessageBox;
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", this.ID);
DatabaseClient.SetParameter("@MessageBox", MessageBox);
DatabaseClient.ExecuteScalar("UPDATE boombang_users SET Message = @MessageBox WHERE ID = @ID LIMIT 1");
}
}
public static bool Register(string UserName, string Password)
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@UserName", UserName);
DatabaseClient.SetParameter("@Password", Convert.ToBase64String(SHA1.Create().ComputeHash(Utils.Encoding.StringToByteArray(Password))));
int Result = Convert.ToInt32(DatabaseClient.ExecuteScalar("SELECT COUNT(*) FROM boombang_users WHERE UserName = @UserName AND Password = @Password LIMIT 1"));
return((Result > 0) ? true : false);
}
}
public static void EndSession(long ID)
{
if (CheckConnection(Client))
{
Sessions.Remove(ID);
using (DatabaseClient client = DatabaseManager.GetClient())
{
client.ExecuteScalar("UPDATE boombang_statistics SET Clients=Clients-1 WHERE ID = 1");
}
}
}
public void UpdateSecurityData(int Avatar = 3, string Colors = "FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF")
{
this.Avatar = Avatar;
this.Colors = Colors;
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", this.ID);
DatabaseClient.SetParameter("@Avatar", this.Avatar);
DatabaseClient.SetParameter("@Colors", this.Colors);
DatabaseClient.ExecuteScalar("UPDATE boombang_users SET Avatar = @Avatar, Colors = @Colors WHERE ID = @ID LIMIT 1");
}
}
public void UpdateSecurityData(string IP)
{
this.ActualIP = IP;
this.LastLogin = DateTime.Now;
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", this.ID);
DatabaseClient.SetParameter("@IP", this.ActualIP);
DatabaseClient.SetParameter("@LastLogin", Utils.Time.ToString(this.LastLogin));
DatabaseClient.ExecuteScalar("UPDATE boombang_users SET LastIP = @IP, LastLogin = @LastLogin WHERE ID = @ID LIMIT 1");
}
}
public void RemoveGoldCoins(int Coins)
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", this.ID);
DatabaseClient.SetParameter("@Coins", Coins);
DatabaseClient.ExecuteScalar("UPDATE boombang_users SET GoldCoins = GoldCoins-@Coins WHERE ID = @ID LIMIT 1");
}
this.GoldCoins -= Coins;
if (SessionsManager.Online(ID))
{
SessionsManager.GetSession(ID).SendMessage(new ServerMessage(new byte[] { 161 }, new object[] { Coins }));
}
}
public void Banº(DateTime Expiration, bool Permanent = false, string Reason = "Incumplir las Normas.")
{
if (!this.MOD)
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.ExecuteScalar("UPDATE boombang_users SET BanType = '" + ((Permanent) ? 0 : 1) + "', BanReason ? '" + Reason + "', BanExpiration = '" + Utils.Time.ToString(Expiration) + "' WHERE ID = '" + ID);
}
if (SessionsManager.Online(this.ID))
{
Session Session = SessionsManager.GetSession(this.ID);
Session.SendMessage(new ServerMessage(new byte[] { 185 }, new object[] { new TimeSpan(Expiration.Ticks - DateTime.Now.Ticks).TotalSeconds, Reason }));
Session.End();
}
}
}
public static void AssSession(long ID)
{
if (CheckConnection(Client))
{
Sessions.Add(SessionID, new Session(SessionID, Client));
SessionID++;
using (DatabaseClient client = DatabaseManager.GetClient())
{
client.ExecuteScalar("UPDATE boombang_statistics SET Clients=Clients+1 WHERE ID = 1");
}
}
else
{
Client.Close();
}
}
