Zaps bfly emu, changing to auth_ticket?

[AlterAxe]

Hello, I'm trying to edit Zaps R63A emulator to get the SSO from auth_ticket instead of users_tickets, I believe I've almost successfully done it, but when I go to enter the client I receive this error as a critical exception.

TokenID: 1Invalid Dario bug duing user login: System.NotImplementedException: The method or operation is not implemented.
  at Butterfly.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String AuthTicket, Byte& errorCode) in C:\Users\User1\Downloads\ZAP SOURCE\ZAP SOURCE\Butterfly Emulator\HabboHotel\Users\UserData\UserDataFactory.cs:line 397
  at Butterfly.HabboHotel.GameClients.GameClient.tryLogin(String AuthTicket) in C:\Users\User1\Downloads\ZAP SOURCE\ZAP SOURCE\Butterfly Emulator\HabboHotel\GameClients\GameClient.cs:line 123

I've looked at both of those lines and this is what they show.
UserDataFactory.cs:line397

throw new NotImplementedException();

GameClient.cs:line123

UserData userData = UserDataFactory.GetUserData(AuthTicket, out errorCode);

If you know what I've done wrong/know how to fix it don't hesitate to reply.
Thanks in advance,
AlterAxe

 

[Sledmore]

In the emulator find:

internal static UserData GetUserData(string sessionTicket, string ip, out byte errorCode)

Scroll down to:

if (ButterflyEnvironment.useSSO)
{
dbClient.setQuery("SELECT users.* " +
"FROM users " +
"RIGHT JOIN user_tickets " +
"ON user_tickets.userid = users.id " +
"WHERE user_tickets.sessionticket = @sso " +
"AND ipaddress = @ipaddress ");
}
else
{
dbClient.setQuery("SELECT users.* " +
"FROM users " +
"RIGHT JOIN user_tickets " +
"ON user_tickets.userid = users.id " +
"WHERE user_tickets.sessionticket = @sso ");
}

Replace with:

dbClient.setQuery("SELECT * FROM users WHERE auth_ticket = @sso");

You're welcome.

 

[AlterAxe]

Thanks, but now I get this on entry to client

TokenID: 1Invalid Dario bug duing user login: System.InvalidCastException: Object cannot be cast from DBNull to other types.
  at System.DBNull.System.IConvertible.ToUInt32(IFormatProvider provider)
  at System.Convert.ToUInt32(Object value)
  at Butterfly.HabboHotel.Users.Authenticator.HabboFactory.GenerateHabbo(DataRow dRow, DataRow group, String auth_ticket) in C:\Users\User1\Downloads\ZAP SOURCE\ZAP SOURCE\Butterfly Emulator\HabboHotel\Users\Authenticator\Authenticator.cs:line 28
  at Butterfly.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String sessionTicket, String ip, Byte& errorCode) in C:\Users\User1\Downloads\ZAP SOURCE\ZAP SOURCE\Butterfly Emulator\HabboHotel\Users\UserData\UserDataFactory.cs:line 364
  at Butterfly.HabboHotel.GameClients.GameClient.tryLogin(String AuthTicket) in C:\Users\User1\Downloads\ZAP SOURCE\ZAP SOURCE\Butterfly Emulator\HabboHotel\GameClients\GameClient.cs:line 123

This is what's on UserDataFactory.cs:line364

Habbo user = HabboFactory.GenerateHabbo(dUserInfo, dGroups, sessionTicket);

 

[Sledmore]

That above error log is asking for you to take a look at Authenticator.cs on line 28 (which in the one I downloaded is 'int dailyPetRespectPoints = (int)dRow["daily_pet_respect_points"];'.

What is the data type in your database for 'daily_pet_respect_points'?

 

[AlterAxe]

That's odd, on my line 28 I have "uint questID = Convert.ToUInt32(dRow["currentquestid"]);"

 

[Sledmore]

That's odd, on my line 28 I have "uint questID = Convert.ToUInt32(dRow["currentquestid"]);"

Okay we might both have a different version then, but nonetheless - what is the datatype for 'currentquestid' in your database? (Users table).

 

[AlterAxe]

The datatype for currentquestid is int

 

[Sledmore]

The datatype for currentquestid is int

Give the default value for 'currentquestid' 0 (if not already) and make sure your user and previous users have theirs set at 0.

 

[AlterAxe]

When I try setting the default value as 0 I get data truncated for column 'currentquestid' at row 1 should I set it to allow null?

 

[Sledmore]

When I try setting the default value as 0 I get data truncated for column 'currentquestid' at row 1 should I set it to allow null?

You could try null however, it has to be 0 (as in the emulator it converts that value to uint32) could you give me your users table SQL?

 

[AlterAxe]

I got that all fixed now, setting it to allow null fixed it, thanks. But now I try creating a room and it doesn't let me.

 

[Sledmore]

I got that all fixed now, setting it to allow null fixed it, thanks. But now I try creating a room and it doesn't let me.

Do you have any logs?

 

[Johno]

Do you have any logs?

Disable strict mysql, reboot your emu should work fine.

 

[Sledmore]

Disable strict mysql, reboot your emu should work fine.

That is the quick and easy way out, but it is hell of a lot better to have your database optimized and ready.

 

[Johno]

That is the quick and easy way out, but it is hell of a lot better to have your database optimized and ready.

Its the method advised by Jonty to fix the issue

 

[AlterAxe]

Yep

You must be registered for see links

Error in packet E|:
TokenID: 13System.NullReferenceException: Object reference not set to an instance of an object.
  at Butterfly.HabboHotel.Navigators.PublicItem.get_RoomData() in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Navigators\PublicItem.cs:line 50
  at Butterfly.HabboHotel.Navigators.PublicItem.Serialize(ServerMessage Message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Navigators\PublicItem.cs:line 78
  at Butterfly.HabboHotel.Navigators.Navigator.SerializePublicRooms() in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Navigators\Navigator.cs:line 136
  at Butterfly.Messages.GameClientMessageHandler.GetPubs() in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\Requests\Navigator.cs:line 82
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPubs(GameClientMessageHandler handler) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 307
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 25
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\GameClientMessageHander.cs:line 57
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\GameClients\GameClient.cs:line 70
 
 
Error in packet Fn@B-1H:
TokenID: 14System.ArgumentNullException: Value cannot be null.
Parameter name: source
  at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
  at Butterfly.HabboHotel.Rooms.RoomManager.GetActiveRooms() in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Rooms\RoomManager.cs:line 73
  at Butterfly.HabboHotel.Navigators.Navigator.SerializeNavigator(GameClient session, Int32 mode) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Navigators\Navigator.cs:line 416
  at Butterfly.Messages.GameClientMessageHandler.GetPopularRooms() in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\Requests\Navigator.cs:line 109
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetPopularRooms(GameClientMessageHandler handler) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 317
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 25
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\GameClientMessageHander.cs:line 57
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\GameClients\GameClient.cs:line 70
 
 
Error in packet Fr:
TokenID: 15System.NullReferenceException: Object reference not set to an instance of an object.
  at Butterfly.HabboHotel.Navigators.Navigator.SerializeNavigatorRooms(ServerMessage& reply, List`1 rooms) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Navigators\Navigator.cs:line 442
  at Butterfly.HabboHotel.Navigators.Navigator.SerializeNavigator(GameClient session, Int32 mode) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\Navigators\Navigator.cs:line 392
  at Butterfly.Messages.GameClientMessageHandler.GetOwnRooms() in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\Requests\Navigator.cs:line 129
  at Butterfly.Messages.StaticMessageHandlers.SharedPacketLib.GetOwnRooms(GameClientMessageHandler handler) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\StaticMessageHandlers\SharedPacketLib.cs:line 337
  at Butterfly.Messages.StaticMessageHandlers.StaticClientMessageHandler.HandlePacket(GameClientMessageHandler handler, ClientMessage message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\StaticMessageHandlers\StaticClientMessageHandler.cs:line 25
  at Butterfly.Messages.GameClientMessageHandler.HandleRequest(ClientMessage request) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\Messages\GameClientMessageHander.cs:line 57
  at Butterfly.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientMessage Message) in C:\Users\User1\Downloads\R63A\ZAP SOURCE\Butterfly Emulator\HabboHotel\GameClients\GameClient.cs:line 70

 

[Sledmore]

Its the method advised by Jonty to fix the issue

Nothing against that if it is, but I'm just saying for the OP that his best option is to just optimize his database as he goes on verse the quick way out (optimized is better for the long run).

You must be registered for see links

,

First log: This is finding active rooms, (do you have data in there? if so remove it, from active_rooms), as it has returned null because it cannot find data for the rooms.

Second log: Active rooms again.

Third log: This is serializing rooms again, go from step one to see if this error still occurs.

 

[AlterAxe]

I currently have no data in the rooms table, nor rooms_active.

 

[Sledmore]

I currently have no data in the rooms table, nor rooms_active.

I'm assuming you will need public room items in there (as the emulator calls them).

 

[AlterAxe]

Hmm, when I was using BCStorm I didn't have any public rooms and it worked fine, how would I get the public room items?