internal static Habbo GenerateHabbo(DataRow dRow, DataRow group) { uint id = Convert.ToUInt32(dRow["id"]); string username = (string)dRow["username"]; string realname = (string)dRow["real_name"]; uint rank = Convert.ToUInt32(dRow["rank"]); string motto = (string)dRow["motto"]; string look = (string)dRow["look"]; string gender = (string)dRow["gender"]; int credits = (int)dRow["credits"]; int activityPoints = (int)dRow["activity_points"]; double activityPointsLastUpdate = Convert.ToDouble(dRow["activity_points_lastupdate"]); bool isMuted = PiciEnvironment.EnumToBool(dRow["is_muted"].ToString()); uint homeRoom = Convert.ToUInt32(dRow["home_room"]); int respect = (Int32)dRow["respect"]; int dailyRespect = (int)dRow["daily_respect_points"]; int dailyPetRespect = (int)dRow["daily_pet_respect_points"]; bool mtantPenalty = (dRow["mutant_penalty"].ToString() != "0"); bool blockFriends = PiciEnvironment.EnumToBool(dRow["block_newfriends"].ToString()); uint questID = Convert.ToUInt32(dRow["currentquestid"]); int questProgress = (int)dRow["currentquestprogress"]; int achiecvementPoints = (int)dRow["achievement_points"]; int crystals = (int)dRow["crystals"]; int newbiestatus = (int)dRow["newbie_status"]; return(new Habbo(id, username, realname, rank, motto, look, gender, credits, activityPoints, activityPointsLastUpdate, isMuted, homeRoom, respect, dailyRespect, dailyPetRespect, mtantPenalty, blockFriends, questID, questProgress, group, achiecvementPoints, crystals, newbiestatus)); }
internal MoodlightData(uint ItemId) { this.ItemId = ItemId; DataRow Row; using (IQueryAdapter dbClient = PiciEnvironment.GetDatabaseManager().getQueryreactor()) { dbClient.setQuery("SELECT enabled,current_preset,preset_one,preset_two,preset_three FROM items_moodlight WHERE item_id = " + ItemId); Row = dbClient.getRow(); } if (Row == null) { throw new NullReferenceException("No moodlightdata found in the database"); } this.Enabled = PiciEnvironment.EnumToBool(Row["enabled"].ToString()); this.CurrentPreset = (int)Row["current_preset"]; this.Presets = new List <MoodlightPreset>(); this.Presets.Add(GeneratePreset((string)Row["preset_one"])); this.Presets.Add(GeneratePreset((string)Row["preset_two"])); this.Presets.Add(GeneratePreset((string)Row["preset_three"])); }
internal void LoadBots(IQueryAdapter dbClient) { Bots = new List <RoomBot>(); dbClient.setQuery("SELECT id, room_id, ai_type, walk_mode, name, motto, look, x, y, z, rotation, min_x, min_y, max_x, max_y FROM bots;"); DataTable Data = dbClient.getTable(); dbClient.setQuery("SELECT id, bot_id, keywords, response_text, mode, serve_id FROM bots_responses;"); DataTable BotResponses = dbClient.getTable(); dbClient.setQuery("SELECT text, shout, bot_id FROM bots_speech;"); DataTable BotSpeech = dbClient.getTable(); List <BotResponse> Responses = new List <BotResponse>(); List <RandomSpeech> Speeches = new List <RandomSpeech>(); foreach (DataRow Row in BotResponses.Rows) { Responses.Add(new BotResponse(Convert.ToUInt32(Row["bot_id"]), (string)Row["keywords"], (string)Row["response_text"], Row["mode"].ToString(), (int)Row["serve_id"])); } foreach (DataRow Row in BotSpeech.Rows) { Speeches.Add(new RandomSpeech((string)Row["text"], PiciEnvironment.EnumToBool(Row["shout"].ToString()), Convert.ToUInt32(Row["bot_id"]))); } if (Data == null) { return; } foreach (DataRow Row in Data.Rows) { string BotAI = (string)Row["ai_type"]; AIType BotAIType; switch (BotAI) { case "generic": BotAIType = AIType.Generic; break; case "guide": BotAIType = AIType.Guide; break; case "pet": BotAIType = AIType.Pet; break; default: BotAIType = AIType.Generic; break; } Bots.Add(new RoomBot(Convert.ToUInt32(Row["id"]), Convert.ToUInt32(Row["room_id"]), BotAIType, (string)Row["walk_mode"], (String)Row["name"], (string)Row["motto"], (String)Row["look"], (int)Row["x"], (int)Row["y"], (int)Row["z"], (int)Row["rotation"], (int)Row["min_x"], (int)Row["min_y"], (int)Row["max_x"], (int)Row["max_y"], ref Speeches, ref Responses)); } }
internal static MoodlightPreset GeneratePreset(string Data) { String[] Bits = Data.Split(','); if (!IsValidColor(Bits[0])) { Bits[0] = "#000000"; } return(new MoodlightPreset(Bits[0], int.Parse(Bits[1]), PiciEnvironment.EnumToBool(Bits[2]))); }
internal void Initialize(IQueryAdapter dbClient) { //dbClient.setQuery("SELECT id,caption FROM navigator_pubcats WHERE enabled = 2"); //wtf? //DataTable dPubCats = dbClient.getTable(); dbClient.setQuery("SELECT id,caption,min_rank FROM navigator_flatcats WHERE enabled = 2"); DataTable dPrivCats = dbClient.getTable(); dbClient.setQuery("SELECT * FROM navigator_publics ORDER BY ordernum ASC"); DataTable dPubItems = dbClient.getTable(); //if (dPubCats != null) //{ // foreach (DataRow Row in dPubCats.Rows) // { // PublicCategories.Add((int)Row["id"], (string)Row["caption"]); // } //} if (dPrivCats != null) { foreach (DataRow Row in dPrivCats.Rows) { PrivateCategories.Add((int)Row["id"], new FlatCat((int)Row["id"], (string)Row["caption"], (int)Row["min_rank"])); } } if (dPubItems != null) { foreach (DataRow Row in dPubItems.Rows) { PublicItems.Add((int)Row["id"], new PublicItem((int)Row["id"], int.Parse(Row["bannertype"].ToString()), (string)Row["caption"], (string)Row["image"], ((Row["image_type"].ToString().ToLower() == "internal") ? PublicImageType.INTERNAL : PublicImageType.EXTERNAL), Convert.ToUInt32(Row["room_id"]), (int)Row["category_parent_id"], PiciEnvironment.EnumToBool(Row["category"].ToString()), PiciEnvironment.EnumToBool(Row["recommended"].ToString()))); } } //if (dPubRecommended != null) //{ // foreach (DataRow Row in dPubRecommended.Rows) // { // PublicRecommended.Add((int)Row["id"], new PublicItem((int)Row["id"], int.Parse(Row["bannertype"].ToString()), (string)Row["caption"], // (string)Row["image"], ((Row["image_type"].ToString().ToLower() == "internal") ? PublicImageType.INTERNAL : PublicImageType.EXTERNAL), // (uint)Row["room_id"], (int)Row["category_parent_id"], false)); // } //} }
internal static UserData GetUserData(string sessionTicket, string ip, out byte errorCode) { DataRow dUserInfo; DataTable dAchievements; DataTable dFavouriteRooms; DataTable dIgnores; DataTable dTags; DataTable dSubscriptions; DataTable dBadges; DataTable dInventory; DataTable dEffects; DataTable dFriends; DataTable dRequests; DataTable dRooms; DataTable dPets; DataTable dQuests; //DataTable dSongs; DataRow dGroups = null; UInt32 userID; using (IQueryAdapter dbClient = PiciEnvironment.GetDatabaseManager().getQueryreactor()) { if (PiciEnvironment.useSSO) { dbClient.setQuery("SELECT * FROM users WHERE auth_ticket = @sso " + "AND ip_last = @ipaddress "); } else { dbClient.setQuery("SELECT * FROM users WHERE auth_ticket = @sso " + "AND ip_last = @ipaddress "); } dbClient.addParameter("sso", sessionTicket); dbClient.addParameter("ipaddress", ip); dUserInfo = dbClient.getRow(); if (dUserInfo == null) { errorCode = 1; return(null); //Logging.LogException("No user found. Debug data: [" + sessionTicket + "], [" + ip + "]"); //thRow new UserDataNotFoundException(string.Format("No user found with ip {0} and sso {1}. Use SSO: {2} ", ip, sessionTicket, PiciEnvironment.useSSO.ToString())); } userID = Convert.ToUInt32(dUserInfo["id"]); if (PiciEnvironment.GetGame().GetClientManager().GetClientByUserID(userID) != null) { errorCode = 2; return(null); } string creditsTimestamp = (string)dUserInfo["lastdailycredits"]; string todayTimestamp = DateTime.Today.ToString("MM/dd"); if (creditsTimestamp != todayTimestamp) { dbClient.runFastQuery("UPDATE users SET credits = credits + 3000, daily_respect_points = 3, lastdailycredits = '" + todayTimestamp + "' WHERE id = " + userID); dUserInfo["credits"] = (int)dUserInfo["credits"] + 3000; } dbClient.setQuery("SELECT * FROM user_achievement WHERE userid = " + userID); dAchievements = dbClient.getTable(); dbClient.setQuery("SELECT room_id FROM user_favorites WHERE user_id = " + userID); dFavouriteRooms = dbClient.getTable(); dbClient.setQuery("SELECT ignore_id FROM user_ignores WHERE user_id = " + userID); dIgnores = dbClient.getTable(); dbClient.setQuery("SELECT tag FROM user_tags WHERE user_id = " + userID); dTags = dbClient.getTable(); dbClient.setQuery("SELECT * FROM user_subscriptions WHERE user_id = " + userID); dSubscriptions = dbClient.getTable(); dbClient.setQuery("SELECT * FROM user_badges WHERE user_id = " + userID); dBadges = dbClient.getTable(); if (dbClient.dbType == Pici.Storage.Database.DatabaseType.MySQL) { dbClient.setQuery("CALL getuseritems(" + userID + ")"); } else { dbClient.setQuery("EXECUTE getuseritems " + userID + ""); } dInventory = dbClient.getTable(); dbClient.setQuery("SELECT * FROM user_effects WHERE user_id = " + userID); dEffects = dbClient.getTable(); dbClient.setQuery("SELECT users.id,users.username,users.motto,users.look,users.last_online " + "FROM users " + "JOIN messenger_friendships " + "ON users.id = messenger_friendships.sender " + "WHERE messenger_friendships.receiver = " + userID + " " + "UNION ALL " + "SELECT users.id,users.username,users.motto,users.look,users.last_online " + "FROM users " + "JOIN messenger_friendships " + "ON users.id = messenger_friendships.receiver " + "WHERE messenger_friendships.sender = " + userID); dFriends = dbClient.getTable(); dbClient.setQuery("SELECT messenger_requests.sender,messenger_requests.receiver,users.username " + "FROM users " + "JOIN messenger_requests " + "ON users.id = messenger_requests.sender " + "WHERE messenger_requests.receiver = " + userID); dRequests = dbClient.getTable(); dbClient.setQuery("SELECT rooms.*, room_active.active_users FROM rooms LEFT JOIN room_active ON (room_active.roomid = rooms.id) WHERE owner = @name"); dbClient.addParameter("name", (string)dUserInfo["username"]); dRooms = dbClient.getTable(); dbClient.setQuery("SELECT * FROM user_pets WHERE user_id = " + userID + " AND room_id = 0"); dPets = dbClient.getTable(); dbClient.setQuery("SELECT * FROM user_quests WHERE user_id = " + userID + ""); dQuests = dbClient.getTable(); if (PiciEnvironment.groupsEnabled) { dbClient.setQuery("SELECT groups_memberships.*, groups_details.* FROM groups_memberships " + "LEFT JOIN groups_details " + "ON groups_memberships.groupid = groups_details.id " + "WHERE groups_memberships.userid = " + userID + " AND groups_memberships.is_current = '1'"); dGroups = dbClient.getRow(); } //dbClient.setQuery("SELECT item_id, song_id FROM user_items_songs WHERE user_id = " + userID); //dSongs = dbClient.getTable(); /* dbClient.setQuery("UPDATE users SET ip_last = @ip WHERE id = " + userID + " LIMIT 1; " + * "UPDATE user_info SET login_timestamp = '" + PiciEnvironment.GetUnixTimestamp() + "' WHERE user_id = " + userID + " LIMIT 1; " + * "REPLACE INTO user_online VALUES (" + userID + "); " + * "DELETE FROM user_tickets WHERE userid = " + userID + ";");*/ dbClient.setQuery("UPDATE users SET ip_last = @ip WHERE id = " + userID + "; " + "UPDATE user_info SET login_timestamp = '" + PiciEnvironment.GetUnixTimestamp() + "' WHERE user_id = " + userID + " ; " + ""); dbClient.addParameter("ip", ip); dbClient.runQuery(); if (dbClient.dbType == Pici.Storage.Database.DatabaseType.MySQL) { dbClient.runFastQuery("REPLACE INTO user_online VALUES (" + userID + ")"); } else { dbClient.runFastQuery("IF NOT EXISTS (SELECT userid FROM user_online WHERE userid = " + userID + ") " + "INSERT INTO user_online VALUES (" + userID + ")"); } } Dictionary <string, UserAchievement> achievements = new Dictionary <string, UserAchievement>(); string achievementGroup; int achievementLevel; int achievementProgress; foreach (DataRow dRow in dAchievements.Rows) { achievementGroup = (string)dRow["group"]; achievementLevel = (int)dRow["level"]; achievementProgress = (int)dRow["progress"]; UserAchievement achievement = new UserAchievement(achievementGroup, achievementLevel, achievementProgress); achievements.Add(achievementGroup, achievement); } List <uint> favouritedRooms = new List <uint>(); uint favoritedRoomID; foreach (DataRow dRow in dFavouriteRooms.Rows) { favoritedRoomID = Convert.ToUInt32(dRow["room_id"]); favouritedRooms.Add(favoritedRoomID); } List <uint> ignores = new List <uint>(); uint ignoredUserID; foreach (DataRow dRow in dIgnores.Rows) { ignoredUserID = Convert.ToUInt32(dRow["ignore_id"]); ignores.Add(ignoredUserID); } List <string> tags = new List <string>(); string tag; foreach (DataRow dRow in dTags.Rows) { tag = (string)dRow["tag"]; tags.Add(tag); } Dictionary <string, Subscription> subscriptions = new Dictionary <string, Subscription>(); string subscriptionID; int expireTimestamp; foreach (DataRow dRow in dSubscriptions.Rows) { subscriptionID = (string)dRow["subscription_id"]; expireTimestamp = (int)dRow["timestamp_expire"]; subscriptions.Add(subscriptionID, new Subscription(subscriptionID, expireTimestamp)); } List <Badge> badges = new List <Badge>(); string badgeID; int slotID; foreach (DataRow dRow in dBadges.Rows) { badgeID = (string)dRow["badge_id"]; slotID = (int)dRow["badge_slot"]; badges.Add(new Badge(badgeID, slotID)); } List <UserItem> inventory = new List <UserItem>(); uint itemID; uint baseItem; string extraData; foreach (DataRow dRow in dInventory.Rows) { itemID = Convert.ToUInt32(dRow[0]); baseItem = Convert.ToUInt32(dRow[1]); if (!DBNull.Value.Equals(dRow[2])) { extraData = (string)dRow[2]; } else { extraData = string.Empty; } inventory.Add(new UserItem(itemID, baseItem, extraData)); } List <AvatarEffect> effects = new List <AvatarEffect>(); int effectID; int duration; bool isActivated; double activatedTimeStamp; foreach (DataRow dRow in dEffects.Rows) { effectID = (int)dRow["effect_id"]; duration = (int)dRow["total_duration"]; isActivated = PiciEnvironment.EnumToBool((string)dRow["is_activated"]); activatedTimeStamp = (double)dRow["activated_stamp"]; effects.Add(new AvatarEffect(effectID, duration, isActivated, activatedTimeStamp)); } Dictionary <uint, MessengerBuddy> friends = new Dictionary <uint, MessengerBuddy>(); string username = (string)dUserInfo["username"]; UInt32 friendID; string friendName; string friendLook; string friendMotto; string friendLastOnline; foreach (DataRow dRow in dFriends.Rows) { friendID = Convert.ToUInt32(dRow["id"]); friendName = (string)dRow["username"]; friendLook = (string)dRow["look"]; friendMotto = (string)dRow["motto"]; friendLastOnline = (string)dRow["last_online"]; if (friendID == userID) { continue; } if (!friends.ContainsKey(friendID)) { friends.Add(friendID, new MessengerBuddy(friendID, friendName, friendLook, friendMotto, friendLastOnline)); } } Dictionary <uint, MessengerRequest> requests = new Dictionary <uint, MessengerRequest>(); uint receiverID; uint senderID; string requestUsername; foreach (DataRow dRow in dRequests.Rows) { receiverID = Convert.ToUInt32(dRow["sender"]); senderID = Convert.ToUInt32(dRow["receiver"]); requestUsername = (string)dRow["username"]; if (receiverID != userID) { if (!requests.ContainsKey(receiverID)) { requests.Add(receiverID, new MessengerRequest(userID, receiverID, requestUsername)); } } else { if (!requests.ContainsKey(senderID)) { requests.Add(senderID, new MessengerRequest(userID, senderID, requestUsername)); } } } List <RoomData> rooms = new List <RoomData>(); uint roomID; foreach (DataRow dRow in dRooms.Rows) { roomID = Convert.ToUInt32(dRow["id"]); rooms.Add(PiciEnvironment.GetGame().GetRoomManager().FetchRoomData(roomID, dRow)); } Dictionary <uint, Pet> pets = new Dictionary <uint, Pet>(); Pet pet; foreach (DataRow dRow in dPets.Rows) { pet = Catalog.GeneratePetFromRow(dRow); pets.Add(pet.PetId, pet); } Dictionary <uint, int> quests = new Dictionary <uint, int>(); uint questId; int progress; foreach (DataRow dRow in dQuests.Rows) { questId = Convert.ToUInt32(dRow["quest_id"]); progress = (int)dRow["progress"]; quests.Add(questId, progress); } Hashtable songs = new Hashtable(); //uint songItemID; //uint songID; //foreach (DataRow dRow in dSongs.Rows) //{ // songItemID = (uint)dRow[0]; // songID = (uint)dRow[1]; // SongItem song = new SongItem(songItemID, songID); // songs.Add(songItemID, song); //} Habbo user = HabboFactory.GenerateHabbo(dUserInfo, dGroups); dUserInfo = null; dAchievements = null; dFavouriteRooms = null; dIgnores = null; dTags = null; dSubscriptions = null; dBadges = null; dInventory = null; dEffects = null; dFriends = null; dRequests = null; dRooms = null; dPets = null; errorCode = 0; return(new UserData(userID, achievements, favouritedRooms, ignores, tags, subscriptions, badges, inventory, effects, friends, requests, rooms, pets, quests, songs, user)); }
internal void DeadFill(DataRow Row) { this.Id = Convert.ToUInt32(Row["id"]); this.Name = (string)Row["caption"]; this.Description = (string)Row["description"]; this.Type = (string)Row["roomtype"]; this.Owner = (string)Row["owner"]; switch (Row["state"].ToString().ToLower()) { case "open": this.State = 0; break; case "password": this.State = 2; break; case "locked": default: this.State = 1; break; } this.Category = (int)Row["category"]; if (!string.IsNullOrEmpty(Row["active_users"].ToString())) { this.UsersNow = (int)Row["active_users"]; } else { this.UsersNow = 0; } this.UsersMax = (int)Row["users_max"]; this.ModelName = (string)Row["model_name"]; this.CCTs = (string)Row["public_ccts"]; this.Score = (int)Row["score"]; this.Tags = new List <string>(); this.AllowPets = PiciEnvironment.EnumToBool(Row["allow_pets"].ToString()); this.AllowPetsEating = PiciEnvironment.EnumToBool(Row["allow_pets_eat"].ToString()); this.AllowWalkthrough = PiciEnvironment.EnumToBool(Row["allow_walkthrough"].ToString()); this.AllowRightsOverride = PiciEnvironment.EnumToBool(Row["allow_rightsoverride"].ToString()); this.Hidewall = PiciEnvironment.EnumToBool(Row["allow_hidewall"].ToString()); this.Password = (string)Row["password"]; this.Wallpaper = (string)Row["wallpaper"]; this.Floor = (string)Row["floor"]; this.Landscape = (string)Row["landscape"]; this.Landscape = (string)Row["landscape"]; this.FloorThickness = (int)Row["floorthickness"]; //this.Event = null; Dictionary <int, int> IconItems = new Dictionary <int, int>(); if (!string.IsNullOrEmpty(Row["icon_items"].ToString())) { foreach (string Bit in Row["icon_items"].ToString().Split('|')) { if (string.IsNullOrEmpty(Bit)) { continue; } string[] tBit = Bit.Replace('.', ',').Split(','); int a = 0; int b = 0; if (tBit.Length > 1) { int.TryParse(tBit[1], out b); } else { int.TryParse(tBit[0], out a); } try { if (!IconItems.ContainsKey(a)) { IconItems.Add(a, b); } } catch (Exception e) { Logging.LogException("Exception: " + e.ToString() + "[" + Bit + "]"); } } } this.myIcon = new RoomIcon((int)Row["icon_bg"], (int)Row["icon_fg"], IconItems); foreach (string Tag in Row["tags"].ToString().Split(',')) { this.Tags.Add(Tag); } }
internal bool RequestBuddy(string UserQuery) { uint userID; bool hasFQDisabled; GameClient client = PiciEnvironment.GetGame().GetClientManager().GetClientByUsername(UserQuery); if (client == null) { DataRow Row = null; using (IQueryAdapter dbClient = PiciEnvironment.GetDatabaseManager().getQueryreactor()) { dbClient.setQuery("SELECT id,block_newfriends FROM users WHERE username = @query"); dbClient.addParameter("query", UserQuery.ToLower()); Row = dbClient.getRow(); } if (Row == null) { return(false); } userID = Convert.ToUInt32(Row["id"]); hasFQDisabled = PiciEnvironment.EnumToBool(Row["block_newfriends"].ToString()); } else { userID = client.GetHabbo().Id; hasFQDisabled = client.GetHabbo().HasFriendRequestsDisabled; } if (hasFQDisabled) { GetClient().GetMessageHandler().GetResponse().Init(260); GetClient().GetMessageHandler().GetResponse().AppendInt32(39); GetClient().GetMessageHandler().GetResponse().AppendInt32(3); GetClient().GetMessageHandler().SendResponse(); return(true); } uint ToId = userID; if (RequestExists(ToId)) { return(true); } using (IQueryAdapter dbClient = PiciEnvironment.GetDatabaseManager().getQueryreactor()) { if (dbClient.dbType == DatabaseType.MSSQL) { dbClient.runFastQuery("DELETE FROM messenger_requests WHERE sender = " + userID + " AND receiver = " + ToId); dbClient.runFastQuery("INSERT INTO messenger_requests (sender,receiver) VALUES (" + this.UserId + "," + ToId + ")"); } else { dbClient.runFastQuery("REPLACE INTO messenger_requests (sender,receiver) VALUES (" + this.UserId + "," + ToId + ")"); } } GameClient ToUser = PiciEnvironment.GetGame().GetClientManager().GetClientByUserID(ToId); if (ToUser == null || ToUser.GetHabbo() == null) { return(true); } MessengerRequest Request = new MessengerRequest(ToId, UserId, PiciEnvironment.GetGame().GetClientManager().GetNameById(UserId)); ToUser.GetHabbo().GetMessenger().OnNewRequest(UserId); ServerMessage NewFriendNotif = new ServerMessage(132); Request.Serialize(NewFriendNotif); ToUser.SendMessage(NewFriendNotif); requests.Add(ToId, Request); return(true); }
//internal RoleManager() //{ //Roles = new Dictionary<uint,Role>(); //Rights = new Dictionary<string, uint>(); //SubRights = new Dictionary<string, string>(); //} //internal void LoadRoles(DatabaseClient dbClient) //{ // ClearRoles(); // DataTable Data = dbClient.getTable("SELECT * FROM ranks ORDER BY id ASC;"); // if (Data != null) // { // foreach (DataRow Row in Data.Rows) // { // Roles.Add((uint)pur["id"], new Role((uint)pur["id"], (string)pur["name"])); // } // } //} internal void LoadRights(IQueryAdapter dbClient) { ClearRights(); /* DataTable table = class1_0.method_3("SELECT * FROM ranks ORDER BY id ASC;"); * if (table != null) * { * foreach (DataRow row in table.Rows) * { * this.dictionary_2.Add((uint) pur["id"], pur["badgeid"].ToString()); * } * }*/ List <string> list; dbClient.setQuery("SELECT * FROM ranks ORDER BY id ASC;"); DataTable Ranks = dbClient.getTable(); if (Ranks != null) { foreach (DataRow RankRow in Ranks.Rows) { this.Ranks.Add((uint)RankRow["id"], RankRow["badgeid"].ToString()); } } dbClient.setQuery("SELECT * FROM permissions_users ORDER BY userid ASC;"); DataTable PermissionsUsers = dbClient.getTable(); foreach (DataRow pur in PermissionsUsers.Rows) { list = new List <string>(); if (PiciEnvironment.EnumToBool(pur["cmd_update_settings"].ToString())) { list.Add("cmd_update_settings"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_bans"].ToString())) { list.Add("cmd_update_bans"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_bots"].ToString())) { list.Add("cmd_update_bots"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_catalogue"].ToString())) { list.Add("cmd_update_catalogue"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_navigator"].ToString())) { list.Add("cmd_update_navigator"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_items"].ToString())) { list.Add("cmd_update_items"); } if (PiciEnvironment.EnumToBool(pur["cmd_award"].ToString())) { list.Add("cmd_award"); } if (PiciEnvironment.EnumToBool(pur["cmd_coords"].ToString())) { list.Add("cmd_coords"); } if (PiciEnvironment.EnumToBool(pur["cmd_override"].ToString())) { list.Add("cmd_override"); } if (PiciEnvironment.EnumToBool(pur["cmd_coins"].ToString())) { list.Add("cmd_coins"); } if (PiciEnvironment.EnumToBool(pur["cmd_pixels"].ToString())) { list.Add("cmd_pixels"); } if (PiciEnvironment.EnumToBool(pur["cmd_ha"].ToString())) { list.Add("cmd_ha"); } if (PiciEnvironment.EnumToBool(pur["cmd_hal"].ToString())) { list.Add("cmd_hal"); } if (PiciEnvironment.EnumToBool(pur["cmd_freeze"].ToString())) { list.Add("cmd_freeze"); } if (PiciEnvironment.EnumToBool(pur["cmd_enable"].ToString())) { list.Add("cmd_enable"); } if (PiciEnvironment.EnumToBool(pur["cmd_roommute"].ToString())) { list.Add("cmd_roommute"); } if (PiciEnvironment.EnumToBool(pur["cmd_setspeed"].ToString())) { list.Add("cmd_setspeed"); } if (PiciEnvironment.EnumToBool(pur["cmd_masscredits"].ToString())) { list.Add("cmd_masscredits"); } if (PiciEnvironment.EnumToBool(pur["cmd_globalcredits"].ToString())) { list.Add("cmd_globalcredits"); } if (PiciEnvironment.EnumToBool(pur["cmd_masspixels"].ToString())) { list.Add("cmd_masspixels"); } if (PiciEnvironment.EnumToBool(pur["cmd_globalpixels"].ToString())) { list.Add("cmd_globalpixels"); } if (PiciEnvironment.EnumToBool(pur["cmd_roombadge"].ToString())) { list.Add("cmd_roombadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_massbadge"].ToString())) { list.Add("cmd_massbadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_userinfo"].ToString())) { list.Add("cmd_userinfo"); } if (PiciEnvironment.EnumToBool(pur["cmd_shutdown"].ToString())) { list.Add("cmd_shutdown"); } if (PiciEnvironment.EnumToBool(pur["cmd_givebadge"].ToString())) { list.Add("cmd_givebadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_removebadge"].ToString())) { list.Add("cmd_removebadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_summon"].ToString())) { list.Add("cmd_summon"); } if (PiciEnvironment.EnumToBool(pur["cmd_invisible"].ToString())) { list.Add("cmd_invisible"); } if (PiciEnvironment.EnumToBool(pur["cmd_ban"].ToString())) { list.Add("cmd_ban"); } if (PiciEnvironment.EnumToBool(pur["cmd_superban"].ToString())) { list.Add("cmd_superban"); } if (PiciEnvironment.EnumToBool(pur["cmd_roomkick"].ToString())) { list.Add("cmd_roomkick"); } if (PiciEnvironment.EnumToBool(pur["cmd_roomalert"].ToString())) { list.Add("cmd_roomalert"); } if (PiciEnvironment.EnumToBool(pur["cmd_mute"].ToString())) { list.Add("cmd_mute"); } if (PiciEnvironment.EnumToBool(pur["cmd_unmute"].ToString())) { list.Add("cmd_unmute"); } if (PiciEnvironment.EnumToBool(pur["cmd_alert"].ToString())) { list.Add("cmd_alert"); } if (PiciEnvironment.EnumToBool(pur["cmd_motd"].ToString())) { list.Add("cmd_motd"); } if (PiciEnvironment.EnumToBool(pur["cmd_kick"].ToString())) { list.Add("cmd_kick"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_filter"].ToString())) { list.Add("cmd_update_filter"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_permissions"].ToString())) { list.Add("cmd_update_permissions"); } if (PiciEnvironment.EnumToBool(pur["cmd_sa"].ToString())) { list.Add("cmd_sa"); } if (PiciEnvironment.EnumToBool(pur["receive_sa"].ToString())) { list.Add("receive_sa"); } if (PiciEnvironment.EnumToBool(pur["cmd_ipban"].ToString())) { list.Add("cmd_ipban"); } if (PiciEnvironment.EnumToBool(pur["cmd_spull"].ToString())) { list.Add("cmd_spull"); } if (PiciEnvironment.EnumToBool(pur["cmd_disconnect"].ToString())) { list.Add("cmd_disconnect"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_achievements"].ToString())) { list.Add("cmd_update_achievements"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_texts"].ToString())) { list.Add("cmd_update_texts"); } if (PiciEnvironment.EnumToBool(pur["cmd_teleport"].ToString())) { list.Add("cmd_teleport"); } if (PiciEnvironment.EnumToBool(pur["cmd_points"].ToString())) { list.Add("cmd_points"); } if (PiciEnvironment.EnumToBool(pur["cmd_masspoints"].ToString())) { list.Add("cmd_masspoints"); } if (PiciEnvironment.EnumToBool(pur["cmd_globalpoints"].ToString())) { list.Add("cmd_globalpoints"); } if (PiciEnvironment.EnumToBool(pur["acc_anyroomrights"].ToString())) { list.Add("acc_anyroomrights"); } if (PiciEnvironment.EnumToBool(pur["acc_anyroomowner"].ToString())) { list.Add("acc_anyroomowner"); } if (PiciEnvironment.EnumToBool(pur["acc_supporttool"].ToString())) { list.Add("acc_supporttool"); } if (PiciEnvironment.EnumToBool(pur["acc_chatlogs"].ToString())) { list.Add("acc_chatlogs"); } if (PiciEnvironment.EnumToBool(pur["acc_enter_fullrooms"].ToString())) { list.Add("acc_enter_fullrooms"); } if (PiciEnvironment.EnumToBool(pur["acc_enter_anyroom"].ToString())) { list.Add("acc_enter_anyroom"); } if (PiciEnvironment.EnumToBool(pur["acc_restrictedrooms"].ToString())) { list.Add("acc_restrictedrooms"); } if (PiciEnvironment.EnumToBool(pur["acc_unkickable"].ToString())) { list.Add("acc_unkickable"); } if (PiciEnvironment.EnumToBool(pur["acc_unbannable"].ToString())) { list.Add("acc_unbannable"); } if (PiciEnvironment.EnumToBool(pur["ignore_friendsettings"].ToString())) { list.Add("ignore_friendsettings"); } this.PermissionsUsersD.Add((uint)pur["userid"], list); } dbClient.setQuery("SELECT * FROM permissions_ranks ORDER BY rank ASC;"); DataTable PermissionsRanks = dbClient.getTable(); if (PermissionsRanks != null) { foreach (DataRow pur1 in PermissionsRanks.Rows) { this.PermissionsUsersR.Add((uint)pur1["rank"], (int)pur1["floodtime"]); } foreach (DataRow pur in PermissionsRanks.Rows) { list = new List <string>(); if (PiciEnvironment.EnumToBool(pur["cmd_update_settings"].ToString())) { list.Add("cmd_update_settings"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_bans"].ToString())) { list.Add("cmd_update_bans"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_bots"].ToString())) { list.Add("cmd_update_bots"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_catalogue"].ToString())) { list.Add("cmd_update_catalogue"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_navigator"].ToString())) { list.Add("cmd_update_navigator"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_items"].ToString())) { list.Add("cmd_update_items"); } if (PiciEnvironment.EnumToBool(pur["cmd_award"].ToString())) { list.Add("cmd_award"); } if (PiciEnvironment.EnumToBool(pur["cmd_coords"].ToString())) { list.Add("cmd_coords"); } if (PiciEnvironment.EnumToBool(pur["cmd_override"].ToString())) { list.Add("cmd_override"); } if (PiciEnvironment.EnumToBool(pur["cmd_coins"].ToString())) { list.Add("cmd_coins"); } if (PiciEnvironment.EnumToBool(pur["cmd_pixels"].ToString())) { list.Add("cmd_pixels"); } if (PiciEnvironment.EnumToBool(pur["cmd_ha"].ToString())) { list.Add("cmd_ha"); } if (PiciEnvironment.EnumToBool(pur["cmd_hal"].ToString())) { list.Add("cmd_hal"); } if (PiciEnvironment.EnumToBool(pur["cmd_freeze"].ToString())) { list.Add("cmd_freeze"); } if (PiciEnvironment.EnumToBool(pur["cmd_enable"].ToString())) { list.Add("cmd_enable"); } if (PiciEnvironment.EnumToBool(pur["cmd_roommute"].ToString())) { list.Add("cmd_roommute"); } if (PiciEnvironment.EnumToBool(pur["cmd_setspeed"].ToString())) { list.Add("cmd_setspeed"); } if (PiciEnvironment.EnumToBool(pur["cmd_masscredits"].ToString())) { list.Add("cmd_masscredits"); } if (PiciEnvironment.EnumToBool(pur["cmd_globalcredits"].ToString())) { list.Add("cmd_globalcredits"); } if (PiciEnvironment.EnumToBool(pur["cmd_masspixels"].ToString())) { list.Add("cmd_masspixels"); } if (PiciEnvironment.EnumToBool(pur["cmd_globalpixels"].ToString())) { list.Add("cmd_globalpixels"); } if (PiciEnvironment.EnumToBool(pur["cmd_roombadge"].ToString())) { list.Add("cmd_roombadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_massbadge"].ToString())) { list.Add("cmd_massbadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_userinfo"].ToString())) { list.Add("cmd_userinfo"); } if (PiciEnvironment.EnumToBool(pur["cmd_shutdown"].ToString())) { list.Add("cmd_shutdown"); } if (PiciEnvironment.EnumToBool(pur["cmd_givebadge"].ToString())) { list.Add("cmd_givebadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_removebadge"].ToString())) { list.Add("cmd_removebadge"); } if (PiciEnvironment.EnumToBool(pur["cmd_summon"].ToString())) { list.Add("cmd_summon"); } if (PiciEnvironment.EnumToBool(pur["cmd_invisible"].ToString())) { list.Add("cmd_invisible"); } if (PiciEnvironment.EnumToBool(pur["cmd_ban"].ToString())) { list.Add("cmd_ban"); } if (PiciEnvironment.EnumToBool(pur["cmd_superban"].ToString())) { list.Add("cmd_superban"); } if (PiciEnvironment.EnumToBool(pur["cmd_roomkick"].ToString())) { list.Add("cmd_roomkick"); } if (PiciEnvironment.EnumToBool(pur["cmd_roomalert"].ToString())) { list.Add("cmd_roomalert"); } if (PiciEnvironment.EnumToBool(pur["cmd_mute"].ToString())) { list.Add("cmd_mute"); } if (PiciEnvironment.EnumToBool(pur["cmd_unmute"].ToString())) { list.Add("cmd_unmute"); } if (PiciEnvironment.EnumToBool(pur["cmd_alert"].ToString())) { list.Add("cmd_alert"); } if (PiciEnvironment.EnumToBool(pur["cmd_motd"].ToString())) { list.Add("cmd_motd"); } if (PiciEnvironment.EnumToBool(pur["cmd_kick"].ToString())) { list.Add("cmd_kick"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_filter"].ToString())) { list.Add("cmd_update_filter"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_permissions"].ToString())) { list.Add("cmd_update_permissions"); } if (PiciEnvironment.EnumToBool(pur["cmd_sa"].ToString())) { list.Add("cmd_sa"); } if (PiciEnvironment.EnumToBool(pur["receive_sa"].ToString())) { list.Add("receive_sa"); } if (PiciEnvironment.EnumToBool(pur["cmd_ipban"].ToString())) { list.Add("cmd_ipban"); } if (PiciEnvironment.EnumToBool(pur["cmd_spull"].ToString())) { list.Add("cmd_spull"); } if (PiciEnvironment.EnumToBool(pur["cmd_disconnect"].ToString())) { list.Add("cmd_disconnect"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_achievements"].ToString())) { list.Add("cmd_update_achievements"); } if (PiciEnvironment.EnumToBool(pur["cmd_update_texts"].ToString())) { list.Add("cmd_update_texts"); } if (PiciEnvironment.EnumToBool(pur["cmd_teleport"].ToString())) { list.Add("cmd_teleport"); } if (PiciEnvironment.EnumToBool(pur["cmd_points"].ToString())) { list.Add("cmd_points"); } if (PiciEnvironment.EnumToBool(pur["cmd_masspoints"].ToString())) { list.Add("cmd_masspoints"); } if (PiciEnvironment.EnumToBool(pur["cmd_globalpoints"].ToString())) { list.Add("cmd_globalpoints"); } if (PiciEnvironment.EnumToBool(pur["acc_anyroomrights"].ToString())) { list.Add("acc_anyroomrights"); } if (PiciEnvironment.EnumToBool(pur["acc_anyroomowner"].ToString())) { list.Add("acc_anyroomowner"); } if (PiciEnvironment.EnumToBool(pur["acc_supporttool"].ToString())) { list.Add("acc_supporttool"); } if (PiciEnvironment.EnumToBool(pur["acc_chatlogs"].ToString())) { list.Add("acc_chatlogs"); } if (PiciEnvironment.EnumToBool(pur["acc_enter_fullrooms"].ToString())) { list.Add("acc_enter_fullrooms"); } if (PiciEnvironment.EnumToBool(pur["acc_enter_anyroom"].ToString())) { list.Add("acc_enter_anyroom"); } if (PiciEnvironment.EnumToBool(pur["acc_restrictedrooms"].ToString())) { list.Add("acc_restrictedrooms"); } if (PiciEnvironment.EnumToBool(pur["acc_unkickable"].ToString())) { list.Add("acc_unkickable"); } if (PiciEnvironment.EnumToBool(pur["acc_unbannable"].ToString())) { list.Add("acc_unbannable"); } if (PiciEnvironment.EnumToBool(pur["ignore_friendsettings"].ToString())) { list.Add("ignore_friendsettings"); } this.PermissionsRanksD.Add((uint)pur["rank"], list); } dbClient.setQuery("SELECT * FROM permissions_vip;"); DataTable table = dbClient.getTable(); if (table != null) { Class19.Boolean_8 = false; Class19.Boolean_10 = false; Class19.Boolean_11 = false; Class19.Boolean_12 = false; Class19.Boolean_13 = false; Class19.Boolean_9 = false; foreach (DataRow row in table.Rows) { if (PiciEnvironment.EnumToBool(row["cmdPush"].ToString())) { Class19.Boolean_8 = true; } if (PiciEnvironment.EnumToBool(row["cmdPull"].ToString())) { Class19.Boolean_10 = true; } if (PiciEnvironment.EnumToBool(row["cmdFlagme"].ToString())) { Class19.Boolean_11 = true; } if (PiciEnvironment.EnumToBool(row["cmdMimic"].ToString())) { Class19.Boolean_12 = true; } if (PiciEnvironment.EnumToBool(row["cmdMoonwalk"].ToString())) { Class19.Boolean_13 = true; } if (PiciEnvironment.EnumToBool(row["cmdFollow"].ToString())) { Class19.Boolean_9 = true; } } } } /* dbClient.setQuery("SELECT fuse, rank FROM fuserights;"); * DataTable Data = dbClient.getTable(); * * dbClient.setQuery("SELECT fuse, sub FROM fuserights_subs;"); * DataTable SubData = dbClient.getTable(); * * if (Data != null) * { * foreach (DataRow Row in Data.Rows) * { * Rights.Add((string)pur["fuse"], Convert.ToUInt32(pur["rank"])); * } * } * * if (SubData != null) * { * foreach (DataRow Row in SubData.Rows) * { * SubRights.Add((string)pur["fuse"], (string)pur["sub"]); * } * }*/ }