/// <summary>
/// Completes the user talent.
/// </summary>
/// <param name="Session">The session.</param>
/// <param name="Talent">The talent.</param>
internal void CompleteUserTalent(GameClient Session, Talent Talent)
{
if (Session == null || Session.GetHabbo() == null || Session.GetHabbo().CurrentTalentLevel < Talent.Level || Session.GetHabbo().Talents.ContainsKey(Talent.Id))
return;
if (!LevelIsCompleted(Session, Talent.Type, Talent.Level))
return;
if (!string.IsNullOrEmpty(Talent.Prize) && Talent.PrizeBaseItem > 0u)
{
Item item = AzureEmulator.GetGame().GetItemManager().GetItem(Talent.PrizeBaseItem);
AzureEmulator.GetGame().GetCatalog().DeliverItems(Session, item, 1, "", 0, 0, "");
}
var value = new UserTalent(Talent.Id, 1);
Session.GetHabbo().Talents.Add(Talent.Id, value);
using (IQueryAdapter queryReactor = AzureEmulator.GetDatabaseManager().GetQueryReactor())
{
queryReactor.RunFastQuery(string.Concat("REPLACE INTO users_talents VALUES (", Session.GetHabbo().Id, ", ", Talent.Id, ", ", 1, ");"));
}
var serverMessage = new ServerMessage(LibraryParser.OutgoingRequest("TalentLevelUpMessageComposer"));
serverMessage.AppendString(Talent.Type);
serverMessage.AppendInteger(Talent.Level);
serverMessage.AppendInteger(0);
if (Talent.Type == "citizenship" && Talent.Level == 4)
{
serverMessage.AppendInteger(2);
serverMessage.AppendString("HABBO_CLUB_VIP_7_DAYS");
serverMessage.AppendInteger(7);
serverMessage.AppendString(Talent.Prize);
serverMessage.AppendInteger(0);
}
else
{
serverMessage.AppendInteger(1);
serverMessage.AppendString(Talent.Prize);
serverMessage.AppendInteger(0);
}
Session.SendMessage(serverMessage);
if (Talent.Type == "citizenship")
{
if (Talent.Level == 3)
AzureEmulator.GetGame().GetAchievementManager().ProgressUserAchievement(Session, "ACH_Citizenship", 1);
else if (Talent.Level == 4)
{
Session.GetHabbo().GetSubscriptionManager().AddSubscription(7);
using (IQueryAdapter queryReactor = AzureEmulator.GetDatabaseManager().GetQueryReactor())
{
queryReactor.RunFastQuery(string.Concat(new object[]
{
"UPDATE users SET talent_status = 'helper' WHERE id = ",
Session.GetHabbo().Id,
";"
}));
}
}
}
}
/// <summary>
/// Gets the user data.
/// </summary>
/// <param name="sessionTicket">The session ticket.</param>
/// <param name="ip">The ip.</param>
/// <param name="errorCode">The error code.</param>
/// <returns>UserData.</returns>
/// <exception cref="UserDataNotFoundException"></exception>
internal static UserData GetUserData(string sessionTicket, out uint errorCode)
{
uint userid = 0, miniMailCount = 0;
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 myRoomsTable;
DataTable petsTable;
DataTable questsTable;
DataTable botsTable;
DataTable relationShipsTable;
try
{
using (var queryReactor = AzureEmulator.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery("SELECT * FROM users WHERE auth_ticket = @ticket");
queryReactor.AddParameter("ticket", sessionTicket);
dataRow = queryReactor.GetRow();
if (dataRow == null)
return null;
errorCode = 0;
userid = Convert.ToUInt32(dataRow["id"]);
queryReactor.RunFastQuery(string.Format("UPDATE users SET online = '1' WHERE id = '{0}'", userid));
if (AzureEmulator.GetGame().GetClientManager().GetClientByUserId(userid) != null)
AzureEmulator.GetGame().GetClientManager().GetClientByUserId(userid).Disconnect("User connected in other place");
queryReactor.SetQuery(string.Format("SELECT `group`, `level`, progress FROM users_achievements WHERE userid = {0}", Convert.ToUInt32(userid)));
achievementsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT talent_id, talent_state FROM users_talents WHERE userid = {0}", Convert.ToUInt32(userid)));
talentsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT COUNT(*) FROM users_stats WHERE id = {0}", Convert.ToUInt32(userid)));
if (int.Parse(queryReactor.GetString()) == 0)
queryReactor.RunFastQuery(string.Format("INSERT INTO users_stats (id) VALUES ({0})", Convert.ToUInt32(userid)));
queryReactor.SetQuery(string.Format("SELECT room_id FROM users_favorites WHERE user_id = {0}", Convert.ToUInt32(userid)));
favoritesTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT ignore_id FROM users_ignores WHERE user_id = {0}", Convert.ToUInt32(userid)));
ignoresTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT tag FROM users_tags WHERE user_id = {0}", Convert.ToUInt32(userid)));
tagsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT subscription_id, timestamp_activated, timestamp_expire, timestamp_lastgift FROM users_subscriptions WHERE user_id = {0} AND timestamp_expire > UNIX_TIMESTAMP() ORDER BY subscription_id DESC LIMIT 1", Convert.ToUInt32(userid)));
subscriptionsRow = queryReactor.GetRow();
queryReactor.SetQuery(string.Format("SELECT * FROM users_badges WHERE user_id = {0}", Convert.ToUInt32(userid)));
badgesTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("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={0} LIMIT 8000", Convert.ToUInt32(userid)));
itemsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT * FROM users_effects WHERE user_id = {0}", Convert.ToUInt32(userid)));
effectsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT poll_id FROM users_polls WHERE user_id = {0} GROUP BY poll_id;", Convert.ToUInt32(userid)));
pollsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT users.id,users.username,users.motto,users.look,users.last_online,users.hide_inroom,users.hide_online FROM users JOIN messenger_friendships ON users.id = messenger_friendships.user_one_id WHERE messenger_friendships.user_two_id = {0} UNION ALL SELECT users.id,users.username,users.motto,users.look,users.last_online,users.hide_inroom,users.hide_online FROM users JOIN messenger_friendships ON users.id = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = {0}", Convert.ToUInt32(userid)));
friendsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT * FROM users_stats WHERE id = {0}", Convert.ToUInt32(userid)));
statsTable = queryReactor.GetRow();
queryReactor.SetQuery(string.Format("SELECT messenger_requests.from_id,messenger_requests.to_id,users.Username FROM users JOIN messenger_requests ON users.id = messenger_requests.from_id WHERE messenger_requests.to_id = {0}", Convert.ToUInt32(userid)));
friendsRequestsTable = queryReactor.GetTable();
queryReactor.SetQuery("SELECT * FROM rooms_data WHERE owner = @name LIMIT 150");
queryReactor.AddParameter("name", dataRow["username"]);
myRoomsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT * FROM bots WHERE user_id = {0} AND room_id = 0 AND ai_type='pet'", Convert.ToUInt32(userid)));
petsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT quest_id, progress FROM users_quests_data WHERE user_id = {0}", Convert.ToUInt32(userid)));
questsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT * FROM bots WHERE user_id = {0} AND room_id=0 AND ai_type='generic'", Convert.ToUInt32(userid)));
botsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT group_id,rank,date_join FROM groups_members WHERE user_id = {0}", Convert.ToUInt32(userid)));
groupsTable = queryReactor.GetTable();
queryReactor.SetQuery(string.Format("UPDATE users_info SET login_timestamp = '{1}' WHERE user_id = {0}", Convert.ToUInt32(userid), AzureEmulator.GetUnixTimeStamp()));
queryReactor.RunQuery();
queryReactor.SetQuery(string.Format("SELECT * FROM users_relationships WHERE user_id = {0}", Convert.ToUInt32(userid)));
relationShipsTable = queryReactor.GetTable();
//queryReactor.SetQuery(string.Format("SELECT Count( IsReaded ) FROM xdrcms_minimail WHERE InBin = 0 AND IsReaded = 0 AND SenderId != {0} AND OwnerId = {0}", Convert.ToUInt32(userid)));
//miniMailCount = (uint)queryReactor.GetInteger();
queryReactor.RunFastQuery(string.Format("UPDATE users SET online='1' WHERE id = {0} LIMIT 1", Convert.ToUInt32(userid)));
}
var achievements = new Dictionary<string, UserAchievement>();
foreach (DataRow row in achievementsTable.Rows)
{
var text = (string)row["group"];
var level = (int)row["level"];
var progress = (int)row["progress"];
var value = new UserAchievement(text, level, progress);
achievements.Add(text, value);
}
var talents = new Dictionary<int, UserTalent>();
foreach (DataRow row in talentsTable.Rows)
{
var num2 = (int)row["talent_id"];
var state = (int)row["talent_state"];
var value2 = new UserTalent(num2, state);
talents.Add(num2, value2);
}
var favorites = (from DataRow row in favoritesTable.Rows select (uint)row["room_id"]).ToList();
var ignoreUsers = (from DataRow row in ignoresTable.Rows select (uint)row["ignore_id"]).ToList();
var tags = (from DataRow row in tagsTable.Rows select row["tag"].ToString().Replace(" ", "")).ToList();
var inventoryBots =
(from DataRow row2 in botsTable.Rows select BotManager.GenerateBotFromRow(row2)).ToDictionary(
roomBot => roomBot.BotId);
var badges =
(from DataRow dataRow8 in badgesTable.Rows
select 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"]);
var items = new List<UserItem>();
foreach (DataRow row in itemsTable.Rows)
{
var id = Convert.ToUInt32(row[0]);
var itemId = Convert.ToUInt32(row[3]);
if (!AzureEmulator.GetGame().GetItemManager().ContainsItem(itemId))
continue;
var extraData = !DBNull.Value.Equals(row[4]) ? (string)row[4] : string.Empty;
var group = Convert.ToInt32(row["group_id"]);
var songCode = (string)row["songcode"];
items.Add(new UserItem(id, itemId, extraData, group, songCode));
}
var effects = (from DataRow row in effectsTable.Rows
let effectId = (int)row["effect_id"]
let totalDuration = (int)row["total_duration"]
let activated = AzureEmulator.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();
var pollSuggested = new HashSet<uint>();
foreach (uint pId in from DataRow row in pollsTable.Rows select (uint)row["poll_id"])
pollSuggested.Add(pId);
var friends = new Dictionary<uint, MessengerBuddy>();
var limit = (friendsTable.Rows.Count - 700);
if (limit > 0)
using (var queryreactor2 = AzureEmulator.GetDatabaseManager().GetQueryReactor())
{
queryreactor2.RunFastQuery(string.Concat("DELETE FROM messenger_friendships WHERE user_one_id=", userid, " OR user_two_id=", userid, " LIMIT ", limit));
queryreactor2.SetQuery(string.Concat("SELECT users.id,users.username,users.motto,users.look,users.last_online,users.hide_inroom,users.hide_online FROM users JOIN messenger_friendships ON users.id = messenger_friendships.user_one_id WHERE messenger_friendships.user_two_id = ", userid, " UNION ALL SELECT users.id,users.username,users.motto,users.look,users.last_online,users.hide_inroom,users.hide_online FROM users JOIN messenger_friendships ON users.id = messenger_friendships.user_two_id WHERE messenger_friendships.user_one_id = ", userid));
friendsTable = queryreactor2.GetTable();
}
foreach (DataRow row in friendsTable.Rows)
{
var num4 = Convert.ToUInt32(row["id"]);
var pUsername = (string)row["username"];
var pLook = (string)row["look"];
var pMotto = (string)row["motto"];
var pLastOnline = Convert.ToInt32(row["last_online"]);
var pAppearOffline = AzureEmulator.EnumToBool(row["hide_online"].ToString());
var pHideInroom = AzureEmulator.EnumToBool(row["hide_inroom"].ToString());
if (num4 != userid && !friends.ContainsKey(num4))
friends.Add(num4,
new MessengerBuddy(num4, pUsername, pLook, pMotto, pLastOnline, pAppearOffline, pHideInroom));
}
var friendsRequests = new Dictionary<uint, MessengerRequest>();
foreach (DataRow row in friendsRequestsTable.Rows)
{
var num5 = Convert.ToUInt32(row["from_id"]);
var 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));
}
var myRooms = new HashSet<RoomData>();
foreach (DataRow row in myRoomsTable.Rows)
{
var roomId = Convert.ToUInt32(row["id"]);
myRooms.Add(AzureEmulator.GetGame().GetRoomManager().FetchRoomData(roomId, row));
}
var pets = new Dictionary<uint, Pet>();
foreach (DataRow row in petsTable.Rows)
using (var queryreactor3 = AzureEmulator.GetDatabaseManager().GetQueryReactor())
{
queryreactor3.SetQuery(string.Format("SELECT * FROM pets_data WHERE id={0} LIMIT 1", row[0]));
var row3 = queryreactor3.GetRow();
if (row3 == null)
continue;
var pet = Catalog.GeneratePetFromRow(row, row3);
pets.Add(pet.PetId, pet);
}
var quests = new Dictionary<uint, int>();
foreach (DataRow row in questsTable.Rows)
{
var key = Convert.ToUInt32(row["quest_id"]);
var value3 = (int)row["progress"];
if (quests.ContainsKey(key))
quests.Remove(key);
quests.Add(key, value3);
}
var groups = new List<GroupUser>();
foreach (DataRow row in groupsTable.Rows)
groups.Add(new GroupUser(userid, (int)row["group_id"], (int)row["rank"], (int)row["date_join"]));
var relationShips = relationShipsTable.Rows.Cast<DataRow>()
.ToDictionary(row => (int)row[0],
row => new Relationship((int)row[0], (int)row[2], Convert.ToInt32(row[3].ToString())));
var user = HabboFactory.GenerateHabbo(dataRow, statsTable, groups);
//dataRow = null;
//achievementsTable = null;
//favoritesTable = null;
//ignoresTable = null;
//tagsTable = null;
//subscriptionsRow = null;
//badgesTable = null;
//itemsTable = null;
//effectsTable = null;
//friendsTable = null;
//friendsRequestsTable = null;
//myRoomsTable = null;
//petsTable = null;
//botsTable = null;
//relationShipsTable = null;
//pollsTable = null;
errorCode = 0;
if (user.HasFuse("staff_chat"))
{
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, 0, false, true));
}
return new UserData(userid, achievements, talents, favorites, ignoreUsers, tags, subscriptions, badges,
items, effects, friends, friendsRequests, myRooms, pets, quests, user, inventoryBots, relationShips,
pollSuggested, miniMailCount);
}
catch (Exception e)
{
errorCode = 1;
Writer.Writer.LogException(e.ToString());
return null;
}
}