public int AvgPriceForSprite(int SpriteID)
{
int Num = 0;
int Num2 = 0;
if (MarketAverages.ContainsKey(SpriteID) && MarketCounts.ContainsKey(SpriteID))
{
if (MarketCounts[SpriteID] > 0)
{
return(MarketAverages[SpriteID] / MarketCounts[SpriteID]);
}
return(0);
}
using (IQueryAdapter DbClient = ProjectHub.GetDatabaseManager().GetQueryReactor())
{
DbClient.SetQuery("SELECT `avgprice` FROM `" + ProjectHub.DbPrefix + "catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
Num = DbClient.getInteger();
DbClient.SetQuery("SELECT `sold` FROM `" + ProjectHub.DbPrefix + "catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
Num2 = DbClient.getInteger();
}
MarketAverages.Add(SpriteID, Num);
MarketCounts.Add(SpriteID, Num2);
if (Num2 > 0)
{
return(Convert.ToInt32(Math.Ceiling((double)(Num / Num2))));
}
return(0);
}
public int AvgPriceForSprite(int SpriteID)
{
int num = 0;
int num2 = 0;
if (MarketAverages.ContainsKey(SpriteID) && MarketCounts.ContainsKey(SpriteID))
{
if (MarketCounts[SpriteID] > 0)
{
return(MarketAverages[SpriteID] / MarketCounts[SpriteID]);
}
return(0);
}
using (IQueryAdapter dbClient = CloudServer.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `avgprice` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
num = dbClient.getInteger();
dbClient.SetQuery("SELECT `sold` FROM `catalog_marketplace_data` WHERE `sprite` = '" + SpriteID + "' LIMIT 1");
num2 = dbClient.getInteger();
}
MarketAverages.Add(SpriteID, num);
MarketCounts.Add(SpriteID, num2);
if (num2 > 0)
{
return(Convert.ToInt32(Math.Ceiling((double)(num / num2))));
}
return(0);
}
internal GenericBot(int VirtualId, int BotId, AIType Type, bool IsBartender)
{
int num = 7;
using (IQueryAdapter queryreactor = CyberEnvironment.GetDatabaseManager().getQueryReactor())
{
queryreactor.setQuery("SELECT speaking_interval from bots WHERE id = " + BotId);
num = queryreactor.getInteger();
queryreactor.setQuery("SELECT automatic_chat from bots WHERE id = " + BotId);
this.canSpeak = Convert.ToBoolean(queryreactor.getString());
queryreactor.setQuery("SELECT mix_phrases from bots WHERE id = " + BotId);
this.MixPhrases = Convert.ToBoolean(queryreactor.getString());
}
this.SpeechTimer = num * 1000;
this.moveTimer = 0;
this.virtualId = VirtualId;
this.IsBartender = IsBartender;
if (SpeechTimer < 2000)
{
SpeechTimer = 2000;
}
if (canSpeak || MixPhrases)
{
this.chatTimer = new Timer(new TimerCallback(ChatTimerTick), null, SpeechTimer, SpeechTimer);
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int userID = Packet.PopInt();
Boolean IsMe = Packet.PopBoolean();
Habbo targetData = QuasarEnvironment.GetHabboById(userID);
if (targetData == null)
{
Session.SendNotification("Er is een fout opgetreden bij het willen bekijken van deze Habbis profiel.");
return;
}
List <Group> Groups = QuasarEnvironment.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", userID);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, Groups, friendCount));
QuasarEnvironment.GetGame().GetAchievementManager().ProgressAchievement(Session, "ACH_CheckUsersProfile", 1);
}
public void Parse(GameClient Session, ClientPacket Packet)
{
string username = Packet.PopString();
Habbo targetData = NeonEnvironment.GetHabboByUsername(username);
if (targetData == null)
{
Session.SendNotification("Ha ocurrido un error buscando el perfil del usuario.");
return;
}
List <Group> groups = NeonEnvironment.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", targetData.Id);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, groups, friendCount));
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int userID = Packet.PopInt();
Habbo targetData = BiosEmuThiago.GetHabboById(userID);
if (targetData == null)
{
Session.SendNotification("Ocorreu um erro ao encontrar o perfil do usuário.");
return;
}
List <Group> groups = BiosEmuThiago.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", userID);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, groups, friendCount));
}
internal static void Init(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT userpeak FROM server_status");
UserPeak = dbClient.getInteger();
_runFrequency = int.Parse(FirewindEnvironment.GetConfig().GetEntry("backgroundworker.interval", "10000")); // leon is crazy, 300!?! (THIS IS MADNESS!!)
}
private void UpdateOnlineUsers()
{
TimeSpan Uptime = DateTime.Now - RocketEmulador.ServerStarted;
int UsersOnline = Convert.ToInt32(RocketEmulador.GetGame().GetClientManager().Count);
int RoomCount = RocketEmulador.GetGame().GetRoomManager().Count;
Console.Title = "Rocket Emulador - " + UsersOnline + " usuários online - " + RoomCount + " quartos online - " + Uptime.Days + " dia(s) " + Uptime.Hours + " hora(s) ligado";
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `server_status` SET `users_online` = @users, `loaded_rooms` = @loadedRooms LIMIT 1;");
dbClient.AddParameter("users", UsersOnline);
dbClient.AddParameter("loadedRooms", RoomCount);
dbClient.RunQuery();
}
int userPeak;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `userpeak` FROM `server_status` LIMIT 1");
userPeak = dbClient.getInteger();
}
if (UsersOnline > userPeak)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `server_status` SET `userpeak` = @userpeak LIMIT 1;");
dbClient.AddParameter("userpeak", UsersOnline);
dbClient.RunQuery();
}
}
}
internal static Habbo getHabboForName(string UserName)
{
Habbo result;
try
{
using (IQueryAdapter queryreactor = CyberEnvironment.GetDatabaseManager().getQueryReactor())
{
queryreactor.setQuery("SELECT id FROM users WHERE username = @user");
queryreactor.addParameter("user", UserName);
int integer = queryreactor.getInteger();
if (integer > 0)
{
result = CyberEnvironment.getHabboForId(checked ((uint)integer));
return(result);
}
}
result = null;
}
catch
{
result = null;
}
return(result);
}
private void UpdateOnlineUsers()
{
TimeSpan Uptime = DateTime.Now - QuasarEnvironment.ServerStarted;
int UsersOnline = Convert.ToInt32(QuasarEnvironment.GetGame().GetClientManager().Count);
int RoomCount = QuasarEnvironment.GetGame().GetRoomManager().Count;
Console.Title = "Emulator | " + UsersOnline + " Habbis | " + RoomCount + " Kamers | " + Uptime.Days + " Dagen";
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `server_status` SET `users_online` = @users, `loaded_rooms` = @loadedRooms LIMIT 1;");
dbClient.AddParameter("users", UsersOnline);
dbClient.AddParameter("loadedRooms", RoomCount);
dbClient.RunQuery();
}
int userPeak;
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `userpeak` FROM `server_status` LIMIT 1");
userPeak = dbClient.getInteger();
}
if (UsersOnline > userPeak)
{
using (IQueryAdapter dbClient = QuasarEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("UPDATE `server_status` SET `userpeak` = @userpeak LIMIT 1;");
dbClient.AddParameter("userpeak", UsersOnline);
dbClient.RunQuery();
}
}
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int userID = Packet.PopInt();
Boolean IsMe = Packet.PopBoolean();
Habbo targetData = RocketEmulador.GetHabboById(userID);
if (targetData == null)
{
Session.SendNotification("An error occured whilst finding that user's profile.");
return;
}
List <Group> Groups = RocketEmulador.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", userID);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, Groups, friendCount));
}
public bool TryExecute(string[] parameters)
{
int userId = 0;
if (!int.TryParse(parameters[0].ToString(), out userId))
{
return(false);
}
GameClient client = CloudServer.GetGame().GetClientManager().GetClientByUserID(userId);
if (client == null || client.GetHabbo() == null)
{
return(false);
}
using (IQueryAdapter dbClient = CloudServer.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `rank` FROM `users` WHERE `id` = @userId LIMIT 1");
dbClient.AddParameter("userId", userId);
client.GetHabbo().Rank = dbClient.getInteger();
}
client.GetHabbo().GetPermissions().Init(client.GetHabbo());
if (client.GetHabbo().GetPermissions().HasRight("mod_tickets"))
{
client.SendMessage(new ModeratorInitComposer(
CloudServer.GetGame().GetModerationManager().UserMessagePresets,
CloudServer.GetGame().GetModerationManager().RoomMessagePresets,
CloudServer.GetGame().GetModerationManager().GetTickets));
}
return(true);
}
public bool TryExecute(string[] parameters)
{
int userId = 0;
if (!int.TryParse(parameters[0].ToString(), out userId))
{
return(false);
}
GameClient client = CloudServer.GetGame().GetClientManager().GetClientByUserID(userId);
if (client == null || client.GetHabbo() == null)
{
return(false);
}
using (IQueryAdapter dbClient = CloudServer.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `rank_vip` FROM `users` WHERE `id` = @userId LIMIT 1");
dbClient.AddParameter("userId", userId);
client.GetHabbo().VIPRank = dbClient.getInteger();
}
client.GetHabbo().GetPermissions().Init(client.GetHabbo());
return(true);
}
public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
{
int userID = Packet.PopInt();
bool IsMe = Packet.PopBoolean();
Habbo targetData = NeonEnvironment.GetHabboById(userID);
if (targetData == null)
{
Session.SendNotification("Se produjo un error mientras se encontraba el perfil de ese usuario .");
return;
}
List <Group> Groups = NeonEnvironment.GetGame().GetGroupManager().GetGroupsForUser(targetData.Id);
int friendCount = 0;
using (IQueryAdapter dbClient = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT COUNT(0) FROM `messenger_friendships` WHERE (`user_one_id` = @userid OR `user_two_id` = @userid)");
dbClient.AddParameter("userid", userID);
friendCount = dbClient.getInteger();
}
Session.SendMessage(new ProfileInformationComposer(targetData, Session, Groups, friendCount));
}
/// <summary>
/// Obtiene el Id de usuario mediante el nombre de usuario.
/// </summary>
/// <param name="username">Nombre de usuario.</param>
/// <returns></returns>
internal static uint getIdByUsername(string username)
{
if (idByUsername.ContainsKey(username))
{
return(idByUsername[username]);
}
uint userId = 0;
GameClient client = OtanixEnvironment.GetGame().GetClientManager().GetClientByUsername(username);
if (client != null && client.GetHabbo() != null)
{
userId = client.GetHabbo().Id;
}
else
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT id FROM users WHERE username = @usrname");
dbClient.addParameter("usrname", username);
userId = Convert.ToUInt32(dbClient.getInteger());
}
}
if (userId > 0)
{
if (!idByUsername.ContainsKey(username))
{
idByUsername.Add(username, userId);
}
}
return(userId);
}
internal static void Init(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT userpeak FROM server_status");
UserPeak = dbClient.getInteger();
_runFrequency = int.Parse(FirewindEnvironment.GetConfig().GetEntry("backgroundworker.interval", "10000")); // leon is crazy, 300!?! (THIS IS MADNESS!!)
}
internal uint GetBaseIdFromSpriteId(uint SpriteId)
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT item_id FROM items_base WHERE sprite_id = '" + SpriteId + "'");
return(Convert.ToUInt32(dbClient.getInteger()));
}
}
internal uint GetTotalPosts(uint userId)
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT COUNT(*) FROM groups_forums_boards WHERE owner_id = '" + userId + "'");
return(Convert.ToUInt32(dbClient.getInteger()));
}
}
internal uint GetBaseIdFromItemName(string ItemName)
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT item_id FROM items_base WHERE item_name = @iname");
dbClient.addParameter("iname", ItemName);
return(Convert.ToUInt32(dbClient.getInteger()));
}
}
public uint GetModeRank(int mode)
{
using (IQueryAdapter dbClient = Bancho.DatabaseManager.GetQueryReactor())
{
dbClient.SetQuery("SELECT FIND_IN_SET( pp_raw, (SELECT GROUP_CONCAT( pp_raw ORDER BY pp_raw DESC ) FROM users_modes_info WHERE mode_id = @mode )) AS rank FROM users_modes_info WHERE mode_id = @mode AND user_id = @id;");
dbClient.AddParameter("mode", currentMode);
dbClient.AddParameter("id", this.Id);
return((uint)dbClient.getInteger());
}
}
public static int GetAHopper(int CurRoom)
{
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
int RoomId = 0;
dbClient.SetQuery("SELECT room_id FROM items_hopper WHERE room_id <> @room ORDER BY room_id ASC LIMIT 1");
dbClient.AddParameter("room", CurRoom);
RoomId = dbClient.getInteger();
return(RoomId);
}
}
internal static void Init(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT userpeak FROM server_status");
UserPeak = dbClient.getInteger();
mColdTitle = string.Empty;
lowPriorityProcessWatch = new Stopwatch();
consoleTitleWorkerWatch = new Stopwatch();
lowPriorityProcessWatch.Start();
consoleTitleWorkerWatch.Start();
Process();
}
public override void OnUserSay(RoomUser User, string Message)
{
if (User == null || User.GetClient() == null || User.GetClient().GetHabbo() == null)
{
return;
}
if (Gamemap.TileDistance(GetRoomUser().X, GetRoomUser().Y, User.X, User.Y) > 8)
{
return;
}
long nowTime = BiosEmuThiago.CurrentTimeMillis();
long timeBetween = nowTime - User.GetClient().GetHabbo()._lastTimeUsedHelpCommand;
if (timeBetween < 60000 && Message.Length == 5)
{
User.GetClient().SendMessage(RoomNotificationComposer.SendBubble("furni_placement_error", "Aguarde pelo menos 1 minuto para reutilizar o sistema de revisão de raros.", ""));
return;
}
User.GetClient().GetHabbo()._lastTimeUsedHelpCommand = nowTime;
string Rare = Message.Split(' ')[2];
string Username = Message.Split(' ')[4];
GameClient Target = BiosEmuThiago.GetGame().GetClientManager().GetClientByUsername(Message.Split(' ')[4]);
if (Target == null)
{
GetRoomUser().Chat("Opa, esta pessoa não foi encontrada, não se esqueça de soletrar seu nome.", false, 34);
return;
}
int itemstotal = 0;
using (IQueryAdapter query = BiosEmuThiago.GetDatabaseManager().GetQueryReactor())
{
query.SetQuery("SELECT COUNT(*) FROM items i LEFT JOIN furniture f ON(i.base_item = f.id) WHERE f.public_name = @itemsito AND i.user_id = @id AND f.is_rare = '1'");
query.AddParameter("id", Target.GetHabbo().Id);
query.AddParameter("itemsito", Message.Split(' ')[2]);
itemstotal = query.getInteger();
}
if (itemstotal == 0)
{
GetRoomUser().Chat("<font color=\"#DF3A01\"><b>" + Username + "</b> não possui nenhum " + Rare + ", então você não pode apostar com ninguem.</font>", false, 33);
return;
}
GetRoomUser().Chat("<font color=\"#DF3A01\"><b>" + Username + "</b> tem um total de <b>" + itemstotal + "</b> " + Rare + "s.</font>", false, 33);
}
public override void OnUserSay(RoomUser User, string Message)
{
if (User == null || User.GetClient() == null || User.GetClient().GetHabbo() == null)
{
return;
}
if (Gamemap.TileDistance(GetRoomUser().X, GetRoomUser().Y, User.X, User.Y) > 8)
{
return;
}
long nowTime = NeonEnvironment.CurrentTimeMillis();
long timeBetween = nowTime - User.GetClient().GetHabbo()._lastTimeUsedHelpCommand;
if (timeBetween < 60000 && Message.Length == 5)
{
User.GetClient().SendMessage(RoomNotificationComposer.SendBubble("abuse", "Espera al menos 1 minuto para volver a usar el sistema de revisión de rares.", ""));
return;
}
User.GetClient().GetHabbo()._lastTimeUsedHelpCommand = nowTime;
string Rare = Message.Split(' ')[2];
string Username = Message.Split(' ')[4];
GameClient Target = NeonEnvironment.GetGame().GetClientManager().GetClientByUsername(Message.Split(' ')[4]);
if (Target == null)
{
GetRoomUser().Chat("Oops, no se ha encontrado a esta persona, asegúrate de escribir bien su nombre.", false, 34);
return;
}
int itemstotal = 0;
using (IQueryAdapter query = NeonEnvironment.GetDatabaseManager().GetQueryReactor())
{
query.SetQuery("SELECT COUNT(*) FROM items i LEFT JOIN furniture f ON(i.base_item = f.id) WHERE f.item_name = @itemsito AND i.user_id = @id AND f.is_rare = '1'");
query.AddParameter("id", Target.GetHabbo().Id);
query.AddParameter("itemsito", Message.Split(' ')[2]);
itemstotal = query.getInteger();
}
if (itemstotal == 0)
{
GetRoomUser().Chat("<font color=\"#DF3A01\"><b>" + Username + "</b> no tiene ningún " + Rare + ", por lo que no puede apostar ningun@.</font>", false, 33);
return;
}
GetRoomUser().Chat("<font color=\"#DF3A01\"><b>" + Username + "</b> tiene un total de <b>" + itemstotal + "</b> " + Rare + "s.</font>", false, 33);
}
internal static uint GetAHopper(uint CurRoom)
{
uint result;
using (IQueryAdapter queryreactor = CyberEnvironment.GetDatabaseManager().getQueryReactor())
{
queryreactor.setQuery("SELECT room_id FROM items_hopper WHERE room_id <> @room ORDER BY RAND() LIMIT 1");
queryreactor.addParameter("room", CurRoom);
uint num = Convert.ToUInt32(queryreactor.getInteger());
result = num;
}
return(result);
}
public static bool UserIsSubscribed(uint UserId)
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT unix_end FROM user_premiums WHERE user_id = " + UserId);
int PremiumEnds = dbClient.getInteger();
if (PremiumEnds == 0 || SubscriptionEnds(PremiumEnds, UserId))
{
return(false);
}
}
return(true);
}
internal static int GetPetFood(int PetType)
{
if (PET_FOODS[PetType] > 0)
{
return(PET_FOODS[PetType]);
}
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT item_id FROM items_base WHERE item_name = 'petfood" + PetType + "' LIMIT 1");
int itemId = dbClient.getInteger();
PET_FOODS[PetType] = itemId;
return(itemId);
}
}
public MarketPlaceOwnOffersComposer(int UserId)
: base(ServerPacketHeader.MarketPlaceOwnOffersMessageComposer)
{
int i = 0;
DataTable table = null;
using (IQueryAdapter dbClient = RocketEmulador.GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT timestamp, state, offer_id, item_type, sprite_id, total_price, limited_number, limited_stack FROM catalog_marketplace_offers WHERE user_id = '" + UserId + "'");
table = dbClient.getTable();
dbClient.SetQuery("SELECT SUM(asking_price) FROM catalog_marketplace_offers WHERE state = '2' AND user_id = '" + UserId + "'");
i = dbClient.getInteger();
base.WriteInteger(i);
if (table != null)
{
base.WriteInteger(table.Rows.Count);
foreach (DataRow row in table.Rows)
{
int num2 = Convert.ToInt32(Math.Floor((double)(((((double)row["timestamp"]) + 172800.0) - RocketEmulador.GetUnixTimestamp()) / 60.0)));
int num3 = int.Parse(row["state"].ToString());
if ((num2 <= 0) && (num3 != 2))
{
num3 = 3;
num2 = 0;
}
base.WriteInteger(Convert.ToInt32(row["offer_id"]));
base.WriteInteger(num3);
base.WriteInteger(1);
base.WriteInteger(Convert.ToInt32(row["sprite_id"]));
base.WriteInteger(256);
base.WriteString("");
base.WriteInteger(Convert.ToInt32(row["limited_number"]));
base.WriteInteger(Convert.ToInt32(row["limited_stack"]));
base.WriteInteger(Convert.ToInt32(row["total_price"]));
base.WriteInteger(num2);
base.WriteInteger(Convert.ToInt32(row["sprite_id"]));
}
}
else
{
base.WriteInteger(0);
}
}
}
internal string GetItemNameByGiftId(uint GiftId)
{
using (IQueryAdapter dbClient = OtanixEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT base_id FROM user_presents WHERE item_id = " + GiftId + "");
uint BaseId = (uint)dbClient.getInteger();
Item Item = GetItem(BaseId);
if (Item != null)
{
return(Item.Name);
}
return("");
}
}
internal static void AddItemToStatistics(uint BaseId, uint Price, IQueryAdapter dbClient)
{
DateTime dt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
dbClient.setQuery("SELECT price_avg FROM catalog_marketplace_statistics WHERE item_id = '" + BaseId + "' AND date = '" + OtanixEnvironment.DateTimeToUnixTimestamp(dt) + "'");
uint price_avg = Convert.ToUInt32(dbClient.getInteger());
if (price_avg > 0)
{
price_avg = ((price_avg + Price) / 2);
dbClient.runFastQuery("UPDATE catalog_marketplace_statistics SET price_avg = '" + price_avg + "', trade_count = trade_count + 1 WHERE item_id = '" + BaseId + "' AND date = '" + OtanixEnvironment.DateTimeToUnixTimestamp(dt) + "'");
}
else
{
dbClient.runFastQuery("INSERT INTO catalog_marketplace_statistics VALUES (NULL,'" + BaseId + "','" + OtanixEnvironment.DateTimeToUnixTimestamp(dt) + "','" + Price + "','1')");
}
}
internal static Habbo getHabboForName(String UserName)
{
try
{
using (IQueryAdapter dbClient = GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT id FROM users WHERE username = '******'");
int id = dbClient.getInteger();
if (id > 0)
{
return(getHabboForId((uint)id));
}
}
return(null);
}
catch { return(null); }
}
public static Habbo GetHabboByUsername(String UserName)
{
try
{
using (IQueryAdapter dbClient = GetDatabaseManager().GetQueryReactor())
{
dbClient.SetQuery("SELECT `id` FROM `users` WHERE `username` = @user LIMIT 1");
dbClient.AddParameter("user", UserName);
int id = dbClient.getInteger();
if (id > 0)
{
return(GetHabboById(Convert.ToInt32(id)));
}
}
return(null);
}
catch { return(null); }
}
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.item.Id);
this.delay = dbClient.getInteger();
dbClient.setQuery("SELECT triggers_item FROM trigger_in_place WHERE original_trigger = " + this.item.Id);
DataTable dTable = dbClient.getTable();
RoomItem targetItem;
foreach (DataRow dRows in dTable.Rows)
{
targetItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || this.items.Contains(targetItem))
continue;
targetItem.itemTriggerEventHandler += delegateFunction;
this.items.Add(targetItem);
}
}
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.itemID);
this.delay = dbClient.getInteger();
dbClient.setQuery("SELECT rotation_status, movement_status FROM trigger_rotation WHERE item_id = @id");
dbClient.addParameter("id", (int)this.itemID);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.rotation = (RotationState)Convert.ToInt32(dRow[0]);
this.movement = (MovementState)Convert.ToInt32(dRow[1]);
}
else
{
rotation = RotationState.none;
movement = MovementState.none;
}
dbClient.setQuery("SELECT triggers_item FROM trigger_in_place WHERE original_trigger = " + this.itemID);
DataTable dTable = dbClient.getTable();
RoomItem targetItem;
foreach (DataRow dRows in dTable.Rows)
{
targetItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || this.items.Contains(targetItem))
{
continue;
}
this.items.Add(targetItem);
}
}
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.item.Id);
this.cyclesRequired = dbClient.getInteger();
}
internal static void Init(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT userpeak FROM server_status");
LowPriorityWorker.UserPeak = dbClient.getInteger();
}
internal static void Init(IQueryAdapter dbClient)
{
dbClient.setQuery("SELECT userpeak FROM server_status");
UserPeak = dbClient.getInteger();
mColdTitle = string.Empty;
}
