public static void InitItems() { Furnis = new List<FurniTure>(); RegisteredFurnis = new Dictionary<int, FurniTure>(); MySQL Query = new MySQL(Init.ServerMySQL); Query.Query("SELECT * FROM furniture"); foreach (DataRow Row in Query.Fetch_Array()) { FurniTure I = new FurniTure(); I.Id = Convert.ToInt32(Row["id"]); I.Type = Row["type"].ToString(); I.SpriteId = Convert.ToInt32(Row["sprite_id"]); I.Width = Convert.ToInt32(Row["width"]); I.Length = Convert.ToInt32(Row["length"]); I.Name = Row["name"].ToString(); I.Type = Convert.ToString(Row["type"]); I.FurniInteractor = Convert.ToString(Row["furni_type"]); I.CanGift = Decoders.ConvertEnumToBool(Row["can_gift"].ToString()); I.CanRecycle = Decoders.ConvertEnumToBool(Row["can_recycle"].ToString()); I.CanTrade = Decoders.ConvertEnumToBool(Row["can_trade"].ToString()); I.CanStack = Decoders.ConvertEnumToBool(Row["can_stack"].ToString()); I.CanSell = Decoders.ConvertEnumToBool(Row["can_sell"].ToString()); I.CanWalk = Decoders.ConvertEnumToBool(Row["can_walk"].ToString()); I.CanSit = Decoders.ConvertEnumToBool(Row["can_sit"].ToString()); I.Height = Convert.ToDouble(Row["height"]); Furnis.Add(I); RegisteredFurnis.Add(I.Id, I); } }
internal void MyRooms() { #region Navigator - ME ServerMessage MyRooms = new ServerMessage(Headers.MyRoomsInit); MySQL MyRoomsSQL = new MySQL(Init.ServerMySQL); MyRoomsSQL.Query("SELECT * FROM rooms WHERE ownerid = '" + (int)User.HabboUser.UserRow["Id"] + "'"); MyRooms.AppendInt32(5); MyRooms.AppendString(""); MyRooms.AppendInt32(MyRoomsSQL.Num_Rows()); // Numero de salas foreach (DataRow Data in MyRoomsSQL.Fetch_Array()) { List<string> TagList; TagList = new List<string>(); if (Data["tags"].ToString().Contains(";")) { string[] Separe = Data["tags"].ToString().Split(';'); foreach (string s in Separe) { TagList.Add(s); } } MyRooms.AppendInt32((int)Data["id"]); MyRooms.AppendBoolean(false); // events MyRooms.AppendString((string)Data["name"]); MyRooms.AppendInt32((int)Data["ownerid"]); MyRooms.AppendString((string)User.HabboUser.UserRow["username"]); MyRooms.AppendInt32(0); MyRooms.AppendInt32((int)Data["usersnow"]); MyRooms.AppendInt32((int)Data["maxusers"]); MyRooms.AppendString((string)Data["description"]); MyRooms.AppendInt32(0); MyRooms.AppendInt32((Convert.ToInt32(Data["category"]) == 3) ? 0 : 2); MyRooms.AppendInt32((int)Data["score"]); MyRooms.AppendInt32(Convert.ToInt32(Data["category"])); MyRooms.AppendString(""); MyRooms.AppendInt32(0); MyRooms.AppendInt32(0); MyRooms.AppendInt32(TagList.Count); foreach (string D in TagList) MyRooms.AppendString(D); MyRooms.AppendInt32(0); MyRooms.AppendInt32(0); MyRooms.AppendInt32(0); // booleans MyRooms.AppendBoolean(true); MyRooms.AppendBoolean(true); } MyRooms.AppendBoolean(false); User.sendPacket(MyRooms); #endregion }
public static void InitCatalogPages() { try { Categories = new List<Catalog>(); Pages = new List<Catalog>(); Page = new Dictionary<int, Catalog>(); MySQL MySql = new MySQL(Init.ServerMySQL); MySql.Query("SELECT * FROM catalog_pages ORDER BY order_num ASC"); foreach (DataRow Row in MySql.Fetch_Array()) { Catalog C = new Catalog(); C.Id = Convert.ToInt32(Row["id"]); C.CategoryId = Convert.ToInt32(Row["categoryid"]); C.Name = Convert.ToString(Row["name"]); C.OpenPage = Decoders.ConvertEnumToBool(Row["page_open"]); C.EnabledPage = Decoders.ConvertEnumToBool(Row["page_enabled"].ToString()); C.ClubPage = Decoders.ConvertEnumToBool(Row["club_page"].ToString()); C.MinRank = Convert.ToInt32(Row["min_rank"]); C.IconColor = Convert.ToInt32(Row["icon_color"]); C.IconImage = Convert.ToInt32(Row["icon_image"]); C.Extra = Row["page_extra"].ToString(); C.HeadLine = Convert.ToString(Row["page_headline"]); C.PageTeaser = Convert.ToString(Row["page_teaser"]); C.Text = Convert.ToString(Row["page_text"]); C.AnotherText = Convert.ToString(Row["page_othertext"]); C.TextDetails = Convert.ToString(Row["page_text_details"]); C.TextSpecial = Convert.ToString(Row["page_special"]); C.TextTeaser = Convert.ToString(Row["page_text_teaser"]); C.PageQuest = int.Parse(Row["questid"].ToString()); if (C.CategoryId > -1) Pages.Add(C); else Categories.Add(C); Page.Add(C.Id, C); } Out.WritePlain("[Zazlak] > Catalog loaded!", ConsoleColor.Green); } catch (Exception Error) { Out.WritePlain("[Zazlak] > " + Error.Message, ConsoleColor.DarkRed); Console.ReadKey(); Environment.Exit(0); } }
public static void InitCatalogItems() { CatalogItems = new List<Items>(); CatalogItemsForId = new Dictionary<int, Items>(); MySQL RowItems = new MySQL(Init.ServerMySQL); RowItems.Query("SELECT * FROM catalog_items ORDER BY id ASC"); foreach (DataRow Row in RowItems.Fetch_Array()) { Items I = new Items(); I.Id = Convert.ToInt32(Row["id"]); I.PageId = Convert.ToInt32(Row["pageid"]); I.Name = Convert.ToString(Row["name"]); I.Cost_Credits = Convert.ToInt32(Row["cost_credits"]); I.Cost_Pixels = Convert.ToInt32(Row["cost_pixels"]); I.Cost_AnythingQuestPoint = Convert.ToInt32(Row["cost_quest"]); if (Convert.ToInt32(Row["cost_quest"]) > 0) { I.FinalPixels_orQuest = Convert.ToInt32(Row["cost_quest"]); } else { I.FinalPixels_orQuest = Convert.ToInt32(Row["cost_pixels"]); } I.Amount = Convert.ToInt32(Row["amount"]); I.extraAm = Convert.ToString(Row["extraamounts"]); I.ExtraAmounts = new Dictionary<int, int>(); if (I.extraAm.Contains(";")) { string[] separe = I.extraAm.Split(';'); foreach (string s in separe) { if (s == "") continue; string[] s2 = s.Split(','); if (I.ExtraAmounts.ContainsKey(int.Parse(s2[0]))) continue; I.ExtraAmounts.Add(int.Parse(s2[0]), int.Parse(s2[1])); } } I.FurniId = Convert.ToString(Row["furni_id"]); I.ItemIds = new List<int>(); if (I.FurniId.Contains(";")) { string[] separe = I.FurniId.Split(';'); foreach (string s in separe) { if (I.ItemIds.Contains(int.Parse(s))) continue; if (s == "") continue; I.ItemIds.Add(int.Parse(s)); } } else I.ItemIds.Add(int.Parse(I.FurniId)); I.IsClub = int.Parse(Row["is_club"].ToString()); I.ExtraInformation = Convert.ToString(Row["extrainformation"]); CatalogItems.Add(I); CatalogItemsForId.Add(I.Id, I); } Out.WritePlain("[Zazlak] > Catalog Items loaded!", ConsoleColor.Green); }
internal void sendPacket() { #region Packet ServerMessage SendCredits = new ServerMessage(Headers.SendCredits); SendCredits.AppendString(Convert.ToInt32(UserRow["credits"]) + ".0"); this.User.sendPacket(SendCredits); ServerMessage SendUser = new ServerMessage(Headers.SendUserData); SendUser.AppendInt32(Convert.ToInt32(UserRow["id"])); SendUser.AppendString(Convert.ToString(UserRow["username"])); SendUser.AppendString("hr-155-32.hd-185-2.ch-3030-62.lg-275-62.sh-290-62,s-0.g-1.d-3.h-3.a-0"); SendUser.AppendString(Convert.ToString(UserRow["gender"]).ToLower()); SendUser.AppendString(Convert.ToString(UserRow["motto"])); SendUser.AppendString("habbowall"); SendUser.AppendInt32(0); SendUser.AppendBoolean(false); SendUser.AppendInt32(0); // Friends SendUser.AppendInt32(3); SendUser.AppendInt32(3); SendUser.AppendBoolean(true); SendUser.AppendString("02-05-2012 08:05:10"); this.User.sendPacket(SendUser); ServerMessage Friends = new ServerMessage(Headers.FriendsBarInit); Friends.AppendInt32(100); // amount friends normal Friends.AppendInt32(100); // amount max friends normal Friends.AppendInt32(200); // amount max friends HC? Friends.AppendInt32(300); // amount max friends VIP? Friends.AppendInt32(0); // amount categorie MySQL FriendSQL = new MySQL(Init.ServerMySQL); FriendSQL.Query("SELECT user_two_id FROM users_friends WHERE user_one_id = '"+UserRow["id"]+"'"); Friends.AppendInt32(FriendSQL.Num_Rows()); // amount friends foreach (DataRow TheRow in FriendSQL.Fetch_Array()) { MySQL TheFriend = new MySQL(Init.ServerMySQL); TheFriend.Query("SELECT * FROM users_characters WHERE id = '"+TheRow["user_two_id"]+"'"); this.Row = TheFriend.Fetch_Assoc(); if (Row["connected"].ToString() == "1") { Connected = true; } else { Connected = false; } Friends.AppendInt32(Row["id"]); // id Friends.AppendString(Row["username"]); // name Friends.AppendInt32(1); // ? Friends.AppendBoolean(Connected); // isonline Friends.AppendBoolean(false); // isinroom Friends.AppendString(Row["figure"]); // figure Friends.AppendInt32(0); // ? Friends.AppendString(Row["motto"]); // motto Friends.AppendString("Mikkel"); // facebook name Friends.AppendString(Row["createdon"]); Friends.AppendBoolean(false); } Friends.AppendInt32(100); // ? Friends.AppendInt32(0); // ? this.User.sendPacket(Friends); ServerMessage Club = new ServerMessage(Headers.VipInit); Club.AppendString("club_habbo"); Club.AppendInt32(10); // Dias Club.AppendInt32(0); Club.AppendInt32(0); Club.AppendInt32(1); Club.AppendBoolean(false); Club.AppendBoolean(true); Club.AppendInt32(0); Club.AppendInt32(0); Club.AppendInt32(0); this.User.sendPacket(Club); ServerMessage SendPacket = new ServerMessage(2994); SendPacket.AppendString("Hola"); SendPacket.AppendBoolean(false); SendPacket.AppendBoolean(false); this.User.sendPacket(SendPacket); ServerMessage SendPixels = new ServerMessage(Headers.SendPixels); SendPixels.AppendInt32(1); SendPixels.AppendInt32(0); SendPixels.AppendInt32(UserRow["pixels"]); this.User.sendPacket(SendPixels); #endregion }