public static User GetUser(int ID)
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", ID);
DataRow UserRow = DatabaseClient.ExecuteScalarRow("SELECT * FROM boombang_users WHERE ID = @ID");
User UserData = new User();
//Converts, video 15:44 16-4-2014
}
}
public void Handler_199_121()
{
int IDSessionChanges = Convert.ToInt32(Message.Parameters[0, 0]);
int BuyItemID = Convert.ToInt32(Message.Parameters[1, 0]);
int itemID = Convert.ToInt32(Message.Parameters[2, 0]);
int something_6 = Convert.ToInt32(Message.Parameters[3, 0]);
int OtherUser = IDSessionChanges - User.ID;
using(DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
Session SessionByFriendID = SessionsManager.GetSession(OtherUser);
DataRow Row = DatabaseClient.ExecuteScalarRow("SELECT * FROM boombang_buyitems WHERE id = " + BuyItemID + " AND itemID = " + itemID);
if(SessionByFriendID !=null)
{
SessionByFriendID.SendMessage(new ServerMessage(new byte[] {199,121}, new object[] { BuyItemID, itemID, (Row["color"].ToString() == "") ? null : Row["color"].ToString(), (Row["rgb_ratio"].ToString() == "") ? null : Row["rgb_Ratio"].ToString());
public static Ban GetBan(int ID)
{
using (DatabaseClient DatabaseClient = DatabaseManager.GetClient())
{
DatabaseClient.SetParameter("@ID", ID);
DataRow UserRow = DatabaseClient.ExecuteScalarRow("SELECT BanType, BanReason, BanExpiration FROM boombang_users WHERE ID = @ID");
if (Convert.ToInt32(UserRow["BanType"]) != 0)
{
Ban Ban = new Ban();
Ban.Reason = Convert.ToString(UserRow["BanReason"]);
Ban.Time = Math.Round(new TimeSpan(Time.ToDateTime(Convert.ToString(UserRow["BanExpiration"])).Ticks = DateTime.Now.Ticks).TotalSeconds);
Ban.Type = Convert.ToInt32(UserRow["BanType"]);
if (Ban.Type == 2)
{
Ban.Time = 0;
return(Ban);
}
else if (Ban.Type == 1)
{
if (Ban.Time <= 0)
{
Ban.Time = 0;
return(null);
}
return(Ban);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
