Teve algum problema com o Azure 2.0? Veja este tutorial!
Fix N° 1: Lista de amigos duplicando;
(Pule este passo caso use o 2.0.200)
Solução por: animaxus
Abra a source do seu emulador, e vá até o projeto:
Azure.Emulator > Messages > Handlers > Messenger.cs
Remova esta linha: Session.GetHabbo().InitMessenger();
Depois vá até o projeto:
Azure.Emulator > Messages > Handlers > Others.cs
Na linha 302, depois de: "SendResponse();"
Adicione:
Session.GetHabbo().InitMessenger();
Dê debug em seu projeto!
Fix N° 2: Fix para os grupos!
Solução por: Sir Jamal
Execute este comando sql em sua database.
Fix N° 3: Fix para os supers wireds (o de dar emblema etc)
Solução por: DJGOMEZV
Execute este código SQL em sua database:
ALTER TABLE `permissions_ranks` ADD `fuse_use_superwired` enum('0','1') NOT NULL DEFAULT '1';
ALTER TABLE `permissions_ranks` ADD `fuse_any_rooms_rights` enum('0','1') NOT NULL DEFAULT '1';
Procure no projeto:
"Azure.Emulator/HabboHotel/Roles" por: "RoleManager.cs", abra ele e substitua todo o código dentro por esse:
#region
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using Azure.Configuration;
using Azure.Database.Manager.Database.Session_Details.Interfaces;
#endregion
namespace Azure.HabboHotel.Roles
{
/// <summary>
/// Class RoleManager.
/// </summary>
internal class RoleManager
{
public Dictionary<string, int> CommandsList = new Dictionary<string, int>();
public Dictionary<string, int> PetCommandsList = new Dictionary<string, int>();
public Dictionary<uint, string> RankBadge = new Dictionary<uint, string>();
private Dictionary<uint, int> RankFlood = new Dictionary<uint, int>();
private Dictionary<uint, List<string>> RankPermissions = new Dictionary<uint, List<string>>();
private Dictionary<uint, List<string>> UserPermissions = new Dictionary<uint, List<string>>();
public void ClearPermissions()
{
this.RankBadge.Clear();
this.UserPermissions.Clear();
this.RankPermissions.Clear();
this.RankFlood.Clear();
}
public bool ContainsRank(uint Rank)
{
return this.RankPermissions.ContainsKey(Rank);
}
public bool ContainsUser(uint UserID)
{
return this.UserPermissions.ContainsKey(UserID);
}
public int FloodTime(uint RankId)
{
return this.RankFlood[RankId];
}
public List<string> GetRightsForHabbo(uint UserID, uint Rank)
{
List<string> list = new List<string>();
if (this.ContainsUser(UserID))
{
return this.UserPermissions[UserID];
}
return this.RankPermissions[Rank];
}
public void LoadRights(IQueryAdapter dbClient)
{
this.ClearPermissions();
dbClient.SetQuery("SELECT * FROM ranks ORDER BY id DESC;");
DataTable table = dbClient.GetTable();
if (table != null)
{
foreach (DataRow row in table.Rows)
{
this.RankBadge.Add((uint)row["id"], row["badgeid"].ToString());
}
}
dbClient.SetQuery("SELECT * FROM permissions_ranks ORDER BY rank DESC;");
table = dbClient.GetTable();
if (table != null)
{
foreach (DataRow row3 in table.Rows)
{
}
foreach (DataRow row in table.Rows)
{
this.RankFlood.Add((uint)row["rank"], (int)row["floodtime"]);
List<string> list = new List<string>();
if (AzureEmulator.EnumToBool(row["support_tool"].ToString()))
{
list.Add("support_tool");
}
if (AzureEmulator.EnumToBool(row["ambassadeur"].ToString()))
{
list.Add("ambassadeur");
}
if (AzureEmulator.EnumToBool(row["moderator"].ToString()))
{
list.Add("moderator");
}
if (AzureEmulator.EnumToBool(row["manager"].ToString()))
{
list.Add("manager");
}
if (AzureEmulator.EnumToBool(row["admin"].ToString()))
{
list.Add("admin");
}
if (AzureEmulator.EnumToBool(row["staff_chat"].ToString()))
{
list.Add("staff_chat");
}
if (AzureEmulator.EnumToBool(row["user_is_staff"].ToString())
Fix N° 4: Arrumando o comando :hal
Solução por: Jacob Lucado
Vá até: RoleManager.cs e adicione:
if (AzureEmulator.EnumToBool(row["owner"].ToString()))
{
list.Add("owner");
}
Exemplo:
Agora vá até: HotelAlertLink.cs
E edite "owner" por "manager" como no exemplo abaixo:
Fix N° 5: Para este erro:
Solução por: Jacob Lucado
Solução por: Jacob Lucado
System.ArgumentException: Column 'look' does not belong to table . at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at Azure.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String sessionTicket, UInt32& errorCode) in C:\Users\Jacob Lucado\Desktop\Luc\Azure\Azure.Emulator\HabboHotel\Users\UserDataManagement\UserDataFactory.cs:line 246
Substitua na source do seu emulador o projeto "UserDataFactory.cs" por este:
#region
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using Azure.HabboHotel.Achievements;
using Azure.HabboHotel.Catalogs;
using Azure.HabboHotel.Groups.Structs;
using Azure.HabboHotel.Items;
using Azure.HabboHotel.Pets;
using Azure.HabboHotel.RoomBots;
using Azure.HabboHotel.Rooms;
using Azure.HabboHotel.Users.Authenticator;
using Azure.HabboHotel.Users.Badges;
using Azure.HabboHotel.Users.Inventory;
using Azure.HabboHotel.Users.Messenger;
using Azure.HabboHotel.Users.Relationships;
using Azure.HabboHotel.Users.Subscriptions;
#endregion
namespace Azure.HabboHotel.Users.UserDataManagement
{
/// <summary>
/// Class UserDataFactory.
/// </summary>
internal class UserDataFactory
{
/// <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 pUsername = row["username"].ToString();
if (num5 != userid)
if (!friendsRequests.ContainsKey(num5))
friendsRequests.Add(num5, new MessengerRequest(userid, num5, pUsername2, pUsername));
else if (!friendsRequests.ContainsKey(num6))
friendsRequests.Add(num6, new MessengerRequest(userid, num6, pUsername2, pUsername));
}
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;
}
}
/// <summary>
/// Gets the user data.
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <returns>UserData.</returns>
internal static UserData GetUserData(int userId)
{
DataRow dataRow;
uint num;
DataRow row;
DataTable table;
using (var queryReactor = AzureEmulator.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery(string.Format("SELECT * FROM users WHERE id = '{0}'", userId));
dataRow = queryReactor.GetRow();
AzureEmulator.GetGame().GetClientManager().LogClonesOut(Convert.ToUInt32(userId));
if (dataRow == null)
return null;
num = Convert.ToUInt32(dataRow["id"]);
if (AzureEmulator.GetGame().GetClientManager().GetClientByUserId(num) != null)
return null;
queryReactor.SetQuery(string.Format("SELECT group_id,rank,date_join FROM groups_members WHERE user_id={0}", userId));
queryReactor.GetTable();
queryReactor.SetQuery(string.Format("SELECT * FROM users_stats WHERE id={0} LIMIT 1", num));
row = queryReactor.GetRow();
if (row == null)
{
}
queryReactor.SetQuery("SELECT * FROM users_relationships WHERE user_id=@id");
queryReactor.AddParameter("id", num);
table = queryReactor.GetTable();
}
var achievements = new Dictionary<string, UserAchievement>();
var talents = new Dictionary<int, UserTalent>();
var favouritedRooms = new List<uint>();
var ignores = new List<uint>();
var tags = new List<string>();
var badges = new List<Badge>();
var inventory = new List<UserItem>();
var effects = new List<AvatarEffect>();
var friends = new Dictionary<uint, MessengerBuddy>();
var requests = new Dictionary<uint, MessengerRequest>();
var rooms = new HashSet<RoomData>();
var pets = new Dictionary<uint, Pet>();
var quests = new Dictionary<uint, int>();
var bots = new Dictionary<uint, RoomBot>();
var group = new List<GroupUser>();
var pollData = new HashSet<uint>();
var dictionary = table.Rows.Cast<DataRow>()
.ToDictionary(dataRow2 => (int)dataRow2[0],
dataRow2 =>
new Relationship((int)dataRow2[0], (int)dataRow2[2], Convert.ToInt32(dataRow2[3].ToString())));
var user = HabboFactory.GenerateHabbo(dataRow, row, group);
dataRow = null;
return new UserData(num, achievements, talents, favouritedRooms, ignores, tags, null, badges, inventory,
effects, friends, requests, rooms, pets, quests, user, bots, dictionary, pollData, 0);
}
}
}
ESTE NÃO É UM TÓPICO DE SUPORTE! PEÇA AJUDA AQUI.
