public static void smethod_3(DatabaseClient class6_0, int int_0) { GroupsManager @class = Groups.smethod_2(int_0); if (@class != null) { DataRow Row = class6_0.ReadDataRow("SELECT * FROM groups WHERE Id = " + int_0 + " LIMIT 1"); @class.string_0 = (string)Row["name"]; @class.string_2 = (string)Row["badge"]; @class.uint_0 = (uint)Row["roomid"]; @class.string_1 = (string)Row["desc"]; @class.string_3 = (string)Row["locked"]; @class.list_0.Clear(); DataTable dataTable = class6_0.ReadDataTable("SELECT userid FROM group_memberships WHERE groupid = " + int_0 + ";"); foreach (DataRow dataRow2 in dataTable.Rows) { @class.method_0((int)dataRow2["userid"]); } } }
public void method_0(DatabaseClient class6_0) { Logging.smethod_0("Loading Catalogue.."); this.dictionary_0 = new Dictionary<int, CatalogPage>(); this.list_0 = new List<EcotronReward>(); DataTable dataTable = class6_0.ReadDataTable("SELECT * FROM catalog_pages WHERE order_num >= '0' ORDER BY order_num ASC"); DataTable dataTable2 = class6_0.ReadDataTable("SELECT * FROM ecotron_rewards ORDER BY item_id"); DataTable dataTable4 = class6_0.ReadDataTable("SELECT * FROM catalog_pages WHERE order_num = '-1' ORDER BY caption ASC"); try { this.uint_0 = (uint)class6_0.ReadDataRow("SELECT ID FROM items ORDER BY ID DESC LIMIT 1")[0]; } catch { this.uint_0 = 0u; } this.uint_0 += 1u; Hashtable hashtable = new Hashtable(); DataTable dataTable3 = class6_0.ReadDataTable("SELECT * FROM catalog_items"); if (dataTable3 != null) { foreach (DataRow dataRow in dataTable3.Rows) { if (!(dataRow["item_ids"].ToString() == "") && (int)dataRow["amount"] > 0) { string BadgeID = dataRow["BadgeID"].ToString(); if (string.IsNullOrEmpty(BadgeID) || string.IsNullOrWhiteSpace(BadgeID)) BadgeID = string.Empty; hashtable.Add((uint)dataRow["Id"], new CatalogItem((uint)dataRow["Id"], (string)dataRow["catalog_name"], (string)dataRow["item_ids"], (int)dataRow["cost_credits"], (int)dataRow["cost_pixels"], (int)dataRow["cost_snow"], (int)dataRow["amount"], (int)dataRow["page_id"], GoldTree.smethod_2(dataRow["vip"].ToString()), (uint)dataRow["achievement"], (int)dataRow["song_id"], BadgeID)); } } } if (dataTable != null) { foreach (DataRow dataRow in dataTable.Rows) { bool bool_ = false; bool bool_2 = false; if (dataRow["visible"].ToString() == "1") { bool_ = true; } if (dataRow["enabled"].ToString() == "1") { bool_2 = true; } this.dictionary_0.Add((int)dataRow["Id"], new CatalogPage((int)dataRow["Id"], (int)dataRow["parent_id"], (string)dataRow["caption"], bool_, bool_2, (uint)dataRow["min_rank"], GoldTree.smethod_3(dataRow["club_only"].ToString()), (int)dataRow["icon_color"], (int)dataRow["icon_image"], (string)dataRow["page_layout"], (string)dataRow["page_headline"], (string)dataRow["page_teaser"], (string)dataRow["page_special"], (string)dataRow["page_text1"], (string)dataRow["page_text2"], (string)dataRow["page_text_details"], (string)dataRow["page_text_teaser"], (string)dataRow["page_link_description"], (string)dataRow["page_link_pagename"], ref hashtable)); } } if (dataTable4 != null) { foreach (DataRow dataRow in dataTable4.Rows) { bool bool_ = false; bool bool_2 = false; if (dataRow["visible"].ToString() == "1") { bool_ = true; } if (dataRow["enabled"].ToString() == "1") { bool_2 = true; } this.dictionary_0.Add((int)dataRow["Id"], new CatalogPage((int)dataRow["Id"], (int)dataRow["parent_id"], (string)dataRow["caption"], bool_, bool_2, (uint)dataRow["min_rank"], GoldTree.smethod_3(dataRow["club_only"].ToString()), (int)dataRow["icon_color"], (int)dataRow["icon_image"], (string)dataRow["page_layout"], (string)dataRow["page_headline"], (string)dataRow["page_teaser"], (string)dataRow["page_special"], (string)dataRow["page_text1"], (string)dataRow["page_text2"], (string)dataRow["page_text_details"], (string)dataRow["page_text_teaser"], (string)dataRow["page_link_description"], (string)dataRow["page_link_pagename"], ref hashtable)); } } if (dataTable2 != null) { foreach (DataRow dataRow in dataTable2.Rows) { this.list_0.Add(new EcotronReward((uint)dataRow["Id"], (uint)dataRow["display_id"], (uint)dataRow["item_id"], (uint)dataRow["reward_level"])); } } Logging.WriteLine("completed!"); }
public void method_17(DatabaseClient class6_0) { Logging.smethod_0("Loading your settings.."); DataRow dataRow = class6_0.ReadDataRow("SELECT * FROM server_settings LIMIT 1"); LicenseTools.Int32_4 = (int)dataRow["MaxRoomsPerUser"]; LicenseTools.String_4 = (string)dataRow["motd"]; LicenseTools.Int32_0 = (int)dataRow["timer"]; LicenseTools.Int32_1 = (int)dataRow["credits"]; LicenseTools.Int32_3 = (int)dataRow["pixels"]; LicenseTools.Int32_2 = (int)dataRow["points"]; LicenseTools.int_3 = (int)dataRow["pixels_max"]; LicenseTools.int_5 = (int)dataRow["credits_max"]; LicenseTools.int_4 = (int)dataRow["points_max"]; LicenseTools.int_2 = (int)dataRow["MaxPetsPerRoom"]; LicenseTools.int_0 = (int)dataRow["MaxMarketPlacePrice"]; LicenseTools.int_1 = (int)dataRow["MarketPlaceTax"]; LicenseTools.AntiDDoSEnabled = GoldTree.smethod_3(dataRow["enable_antiddos"].ToString()); LicenseTools.Boolean_3 = GoldTree.smethod_3(dataRow["vipclothesforhcusers"].ToString()); LicenseTools.Boolean_4 = GoldTree.smethod_3(dataRow["enable_chatlogs"].ToString()); LicenseTools.Boolean_5 = GoldTree.smethod_3(dataRow["enable_cmdlogs"].ToString()); LicenseTools.Boolean_6 = GoldTree.smethod_3(dataRow["enable_roomlogs"].ToString()); LicenseTools.String_2 = (string)dataRow["enable_externalchatlinks"]; LicenseTools.Boolean_2 = GoldTree.smethod_3(dataRow["enable_securesessions"].ToString()); LicenseTools.Boolean_1 = GoldTree.smethod_3(dataRow["allow_friendfurnidrops"].ToString()); LicenseTools.Boolean_0 = GoldTree.smethod_3(dataRow["enable_cmd_redeemcredits"].ToString()); LicenseTools.bool_18 = GoldTree.smethod_3(dataRow["unload_crashedrooms"].ToString()); LicenseTools.bool_19 = GoldTree.smethod_3(dataRow["ShowUsersAndRoomsInAbout"].ToString()); LicenseTools.int_14 = (int)dataRow["idlesleep"]; LicenseTools.int_15 = (int)dataRow["idlekick"]; LicenseTools.bool_20 = GoldTree.smethod_3(dataRow["ip_lastforbans"].ToString()); LicenseTools.int_16 = (int)dataRow["StaffPicksCategoryID"]; LicenseTools.vipha_interval = (double)dataRow["vipha_interval"]; LicenseTools.bool_21 = GoldTree.smethod_3(dataRow["enable_cmd_redeempixels"].ToString()); LicenseTools.bool_22 = GoldTree.smethod_3(dataRow["enable_cmd_redeemshells"].ToString()); LicenseTools.viphal_interval = (double)dataRow["viphal_interval"]; LicenseTools.DisableOtherUsersToMovingOtherUsersToDoor = GoldTree.smethod_3(dataRow["DisableOtherUsersToMovingOtherUsersToDoor"].ToString()); Logging.WriteLine("completed!"); }