/// <summary>
/// Gets the user data.
/// </summary>
/// <param name="sessionTicket">The session ticket.</param>
/// <param name="errorCode">The error code.</param>
/// <returns>UserData.</returns>
internal static UserData GetUserData(string sessionTicket, out uint errorCode)
{
errorCode = 1;
DataTable groupsTable;
DataRow dataRow;
DataTable achievementsTable;
DataTable talentsTable;
DataRow statsTable;
DataTable favoritesTable;
DataTable ignoresTable;
DataTable tagsTable;
DataRow subscriptionsRow;
DataTable badgesTable;
DataTable itemsTable;
DataTable effectsTable;
DataTable pollsTable;
DataTable friendsTable;
DataTable friendsRequestsTable;
DataTable relationShipsTable;
DataTable botsTable;
DataTable questsTable;
DataTable petsTable;
DataTable myRoomsTable;
uint userId;
string userName, userLook;
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
// Get User Data
queryReactor.SetQuery("SELECT * FROM users WHERE auth_ticket = @ticket");
// Execute User Data Query
queryReactor.AddParameter("ticket", sessionTicket);
dataRow = queryReactor.GetRow();
if (dataRow == null)
{
return(null);
}
userId = (uint)dataRow["id"];
userName = dataRow["username"].ToString();
userLook = dataRow["look"].ToString();
int regDate = (int)dataRow["account_created"] == 0 ? Yupi.GetUnixTimeStamp() : (int)dataRow["account_created"];
// Check Register Date
if ((int)dataRow["account_created"] == 0)
{
queryReactor.RunFastQuery($"UPDATE users SET account_created = {regDate} WHERE id = {userId}");
}
// Disconnect if user Already Logged-in, Doesn't need check. If user isn't logged, nothing will happen.
if (Yupi.GetGame().GetClientManager().GetClientByUserId(userId) != null)
{
Yupi.GetGame().GetClientManager().GetClientByUserId(userId)?.Disconnect("User connected in other place");
}
// Update User statusses
queryReactor.RunFastQuery($"UPDATE users SET online = 1 WHERE id = {userId};" +
$"REPLACE INTO users_info(user_id, login_timestamp) VALUES('{userId}', '{Yupi.GetUnixTimeStamp()}');" +
$"REPLACE INTO users_stats (id) VALUES ('{userId}');");
// Get User Achievements Data
queryReactor.SetQuery($"SELECT * FROM users_achievements WHERE user_id = {userId}");
achievementsTable = queryReactor.GetTable();
// Get User Talent Data
queryReactor.SetQuery($"SELECT * FROM users_talents WHERE userid = {userId}");
talentsTable = queryReactor.GetTable();
// Get User Favorite Room
queryReactor.SetQuery($"SELECT room_id FROM users_favorites WHERE user_id = {userId}");
favoritesTable = queryReactor.GetTable();
// Get User Ignored Users
queryReactor.SetQuery($"SELECT ignore_id FROM users_ignores WHERE user_id = {userId}");
ignoresTable = queryReactor.GetTable();
// Get User Tags
queryReactor.SetQuery($"SELECT tag FROM users_tags WHERE user_id = {userId}");
tagsTable = queryReactor.GetTable();
// Get User Subscriptions
queryReactor.SetQuery($"SELECT * FROM users_subscriptions WHERE user_id = {userId} AND timestamp_expire > UNIX_TIMESTAMP() ORDER BY subscription_id DESC LIMIT 1");
subscriptionsRow = queryReactor.GetRow();
// Get User Badges
queryReactor.SetQuery($"SELECT * FROM users_badges WHERE user_id = {userId}");
badgesTable = queryReactor.GetTable();
// Get User Inventory Items
queryReactor.SetQuery($"SELECT items_rooms.*, COALESCE(items_groups.group_id, 0) AS group_id FROM items_rooms LEFT OUTER JOIN items_groups ON items_rooms.id = items_groups.id WHERE room_id = 0 AND user_id={userId} LIMIT 8000");
itemsTable = queryReactor.GetTable();
// Get user Effects
queryReactor.SetQuery($"SELECT * FROM users_effects WHERE user_id = {userId}");
effectsTable = queryReactor.GetTable();
// Get User Polls
queryReactor.SetQuery($"SELECT poll_id FROM users_polls WHERE user_id = {userId} GROUP BY poll_id;");
pollsTable = queryReactor.GetTable();
// Get User Friends
queryReactor.SetQuery($"SELECT users.* FROM users JOIN messenger_friendships ON users.id = messenger_friendships.user_one_id WHERE messenger_friendships.user_two_id = {userId} UNION ALL SELECT users.* FROM users JOIN messenger_friendships ON users.id = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = {userId}");
friendsTable = queryReactor.GetTable();
// Get User Stats
queryReactor.SetQuery($"SELECT * FROM users_stats WHERE id = {userId}");
statsTable = queryReactor.GetRow();
// Get User Friends Requests
queryReactor.SetQuery($"SELECT messenger_requests.*,users.* FROM users JOIN messenger_requests ON users.id = messenger_requests.from_id WHERE messenger_requests.to_id = {userId}");
friendsRequestsTable = queryReactor.GetTable();
// Get User Rooms Data
queryReactor.SetQuery($"SELECT * FROM rooms_data WHERE owner = '{userId}' LIMIT 150");
myRoomsTable = queryReactor.GetTable();
// Get User Pets Data
queryReactor.SetQuery($"SELECT * FROM bots_data WHERE user_id = {userId} AND room_id = 0 AND ai_type='pet'");
petsTable = queryReactor.GetTable();
// Get User Quests Data
queryReactor.SetQuery($"SELECT * FROM users_quests_data WHERE user_id = {userId}");
questsTable = queryReactor.GetTable();
// Get User Bots Data
queryReactor.SetQuery($"SELECT * FROM bots_data WHERE user_id = {userId} AND room_id=0 AND ai_type='generic'");
botsTable = queryReactor.GetTable();
// Get User Groups Data
queryReactor.SetQuery($"SELECT * FROM groups_members WHERE user_id = {userId}");
groupsTable = queryReactor.GetTable();
// Get User Relationships Data
queryReactor.SetQuery($"SELECT * FROM users_relationships WHERE user_id = {userId}");
relationShipsTable = queryReactor.GetTable();
}
Dictionary <string, UserAchievement> achievements = new Dictionary <string, UserAchievement>();
foreach (DataRow row in achievementsTable.Rows)
{
string text = (string)row["achievement_group"];
uint level = (uint)row["achievement_level"], progress = (uint)row["user_progress"];
achievements.Add(text, new UserAchievement(text, level, progress));
}
Dictionary <int, UserTalent> talents = new Dictionary <int, UserTalent>();
foreach (DataRow row in talentsTable.Rows)
{
int num2 = (int)row["talent_id"];
int state = (int)row["talent_state"];
talents.Add(num2, new UserTalent(num2, state));
}
List <uint> favorites = favoritesTable.Rows.Cast <DataRow>().Select(row => (uint)row["room_id"]).ToList();
List <uint> ignoreUsers = ignoresTable.Rows.Cast <DataRow>().Select(row => (uint)row["ignore_id"]).ToList();
List <string> tags = tagsTable.Rows.Cast <DataRow>().Select(row => row["tag"].ToString().Replace(" ", "")).ToList();
Dictionary <uint, RoomBot> inventoryBots = botsTable.Rows.Cast <DataRow>().Select(BotManager.GenerateBotFromRow).ToDictionary(roomBot => roomBot.BotId);
List <Badge> badges = badgesTable.Rows.Cast <DataRow>().Select(dataRow8 => new Badge((string)dataRow8["badge_id"], (int)dataRow8["badge_slot"])).ToList();
Subscription subscriptions = null;
if (subscriptionsRow != null)
{
subscriptions = new Subscription((int)subscriptionsRow["subscription_id"],
(int)subscriptionsRow["timestamp_activated"], (int)subscriptionsRow["timestamp_expire"],
(int)subscriptionsRow["timestamp_lastgift"]);
}
List <UserItem> items = (from DataRow row in itemsTable.Rows
let id = Convert.ToUInt32(row["id"])
let itemName = row["item_name"].ToString()
where Yupi.GetGame().GetItemManager().ContainsItemByName(itemName)
let extraData = !DBNull.Value.Equals(row[4]) ? (string)row[4] : string.Empty
let theGroup = Convert.ToUInt32(row["group_id"])
let songCode = (string)row["songcode"]
select new UserItem(id, itemName, extraData, theGroup, songCode)).ToList();
List <AvatarEffect> effects = (from DataRow row in effectsTable.Rows
let effectId = (int)row["effect_id"]
let totalDuration = (int)row["total_duration"]
let activated = Yupi.EnumToBool((string)row["is_activated"])
let activateTimestamp = (double)row["activated_stamp"]
let type = Convert.ToInt16(row["type"])
select new AvatarEffect(effectId, totalDuration, activated, activateTimestamp, type)).ToList();
HashSet <uint> pollSuggested = new HashSet <uint>();
foreach (uint pId in pollsTable.Rows.Cast <DataRow>().Select(row => (uint)row["poll_id"]))
{
pollSuggested.Add(pId);
}
Dictionary <uint, MessengerBuddy> friends = new Dictionary <uint, MessengerBuddy>();
foreach (DataRow row in friendsTable.Rows)
{
uint num4 = (uint)row["id"];
string pUsername = (string)row["username"];
string pLook = (string)row["look"];
string pMotto = (string)row["motto"];
bool pAppearOffline = Yupi.EnumToBool(row["hide_online"].ToString());
bool pHideInroom = Yupi.EnumToBool(row["hide_inroom"].ToString());
if (!Equals(num4, userId) && !friends.ContainsKey(num4))
{
friends.Add(num4, new MessengerBuddy(num4, pUsername, pLook, pMotto, pAppearOffline, pHideInroom));
}
}
Dictionary <uint, MessengerRequest> friendsRequests = new Dictionary <uint, MessengerRequest>();
foreach (DataRow row in friendsRequestsTable.Rows)
{
uint num5 = Convert.ToUInt32(row["from_id"]);
uint num6 = Convert.ToUInt32(row["to_id"]);
string pUsername2 = row["username"].ToString();
string pLook = row["look"].ToString();
if (num5 != userId)
{
if (!friendsRequests.ContainsKey(num5))
{
friendsRequests.Add(num5, new MessengerRequest(userId, num5, pUsername2, pLook));
}
else if (!friendsRequests.ContainsKey(num6))
{
friendsRequests.Add(num6, new MessengerRequest(userId, num6, pUsername2, pLook));
}
}
}
HashSet <RoomData> myRooms = new HashSet <RoomData>();
foreach (DataRow row in myRoomsTable.Rows)
{
myRooms.Add(Yupi.GetGame().GetRoomManager().FetchRoomData((uint)row["id"], row));
}
Dictionary <uint, Pet> pets = new Dictionary <uint, Pet>();
foreach (DataRow row in petsTable.Rows)
{
using (IQueryAdapter queryreactor3 = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryreactor3.SetQuery($"SELECT * FROM pets_data WHERE id = {row["id"]} LIMIT 1");
DataRow row3 = queryreactor3.GetRow();
if (row3 == null)
{
continue;
}
pets.Add((uint)row["id"], CatalogManager.GeneratePetFromRow(row, row3));
}
}
Dictionary <int, int> quests = new Dictionary <int, int>();
foreach (DataRow row in questsTable.Rows)
{
int key = (int)row["quest_id"];
int value3 = (int)row["progress"];
if (quests.ContainsKey(key))
{
quests.Remove(key);
}
quests.Add(key, value3);
}
HashSet <GroupMember> groups = new HashSet <GroupMember>();
foreach (DataRow row in groupsTable.Rows)
{
groups.Add(new GroupMember(userId, userName, userLook, (uint)row["group_id"], Convert.ToInt16(row["rank"]), (int)row["date_join"]));
}
Dictionary <int, Relationship> relationShips = relationShipsTable.Rows.Cast <DataRow>().ToDictionary(row => (int)row[0], row => new Relationship((int)row[0], (int)row[2], Convert.ToInt32(row[3].ToString())));
Habbo user = HabboFactory.GenerateHabbo(dataRow, statsTable, groups);
errorCode = 0;
if (user.Rank >= Yupi.StaffAlertMinRank)
{
friends.Add(0, new MessengerBuddy(0, "Staff Chat", "hr-831-45.fa-1206-91.sh-290-1331.ha-3129-100.hd-180-2.cc-3039-73.ch-3215-92.lg-270-73", string.Empty, false, true));
}
else if (user.Rank >= Convert.ToUInt32(Yupi.GetDbConfig().DbData["ambassador.minrank"]))
{
friends.Add(0, new MessengerBuddy(0, "Ambassador Chat", "hr-831-45.fa-1206-91.sh-290-1331.ha-3129-100.hd-180-2.cc-3039-73.ch-3215-92.lg-270-73", string.Empty, false, true));
}
return(new UserData(userId, achievements, talents, favorites, ignoreUsers, tags, subscriptions, badges,
items, effects, friends, friendsRequests, myRooms, pets, quests, user, inventoryBots, relationShips,
pollSuggested, 0));
}
/// <summary>
/// Loads the inventory.
/// </summary>
internal void LoadInventory()
{
_floorItems.Clear();
_wallItems.Clear();
DataTable table;
using (IQueryAdapter commitableQueryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
commitableQueryReactor.SetQuery(
"SELECT * FROM items_rooms WHERE user_id=@userid AND room_id='0' LIMIT 8000;");
commitableQueryReactor.AddParameter("userid", (int)UserId);
table = commitableQueryReactor.GetTable();
}
foreach (DataRow dataRow in table.Rows)
{
uint id = Convert.ToUInt32(dataRow["id"]);
string itemName = dataRow["item_name"].ToString();
if (!Yupi.GetGame().GetItemManager().ContainsItemByName(itemName))
{
continue;
}
string extraData;
if (!DBNull.Value.Equals(dataRow[4]))
{
extraData = (string)dataRow[4];
}
else
{
extraData = string.Empty;
}
uint group = Convert.ToUInt32(dataRow["group_id"]);
string songCode;
if (!DBNull.Value.Equals(dataRow["songcode"]))
{
songCode = (string)dataRow["songcode"];
}
else
{
songCode = string.Empty;
}
UserItem userItem = new UserItem(id, itemName, extraData, group, songCode);
if (userItem.BaseItem.InteractionType == Interaction.MusicDisc && !SongDisks.Contains(id))
{
SongDisks.Add(id, userItem);
}
if (userItem.IsWallItem)
{
if (!_wallItems.Contains(id))
{
_wallItems.Add(id, userItem);
}
}
else if (!_floorItems.Contains(id))
{
_floorItems.Add(id, userItem);
}
}
//SongDisks.Clear();
_inventoryPets.Clear();
_inventoryBots.Clear();
using (IQueryAdapter commitableQueryReactor2 = Yupi.GetDatabaseManager().GetQueryReactor())
{
commitableQueryReactor2.SetQuery($"SELECT * FROM bots_data WHERE user_id = {UserId} AND room_id = 0");
DataTable table2 = commitableQueryReactor2.GetTable();
if (table2 == null)
{
return;
}
foreach (DataRow botRow in table2.Rows)
{
if ((string)botRow["ai_type"] == "generic")
{
AddBot(BotManager.GenerateBotFromRow(botRow));
}
}
commitableQueryReactor2.SetQuery($"SELECT * FROM pets_data WHERE user_id = {UserId} AND room_id = 0");
DataTable table3 = commitableQueryReactor2.GetTable();
if (table3 == null)
{
return;
}
foreach (DataRow petRow in table3.Rows)
{
if ((string)petRow["ai_type"] == "pet")
{
Pet pet = CatalogManager.GeneratePetFromRow(petRow);
if (_inventoryPets.Contains(pet.PetId))
{
_inventoryPets.Remove(pet.PetId);
}
_inventoryPets.Add(pet.PetId, pet);
}
}
}
}