[HELP] Release63-201406121205-769959

[Pastie]

Hey there.
Well again I tried to update the packet ids to the release: Release63-201406121205-769959 but again I failed.
The Packets and the Habbo.swf release was found here on this forum (http://forum.ragezone.com/f353/relea...03/index2.html) but it doesn't seems like its working for me...

All the outgoing and incoming were updated as well as external_variables.txt and Habbo.swf.

This is all the crazy errors I get while entering the client:




Hotel loads to 91 - 100% before it redirects to the /me page.
The MySQL errors is the following:

Error in query: 
SELECT * from moderation_templates where category = '1'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'cleangraphic.moderation_templates' doesn't exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Database_Manager.Database.Session_Details.QueryAdapter.getTable() in c:\Users\Administrator\Desktop\Graphic 1.2 - Copy (2)\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 144


Error in query: 
SELECT * from moderation_templates where category = '2'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'cleangraphic.moderation_templates' doesn't exist
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Database_Manager.Database.Session_Details.QueryAdapter.getTable() in c:\Users\Administrator\Desktop\Graphic 1.2 - Copy (2)\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 144

Don't think they have so much to say because I got the same errors on another swf version. But anyway, as you can see it throws an external_varaibles error. That one is the error I need help with!
My externals are the following: http://pastebin.com/detMYVEU


Here is a GIF showing what is happening:
Client:


Thank you!
- Invitee

[MentaL]

[Glee]

Well Obviously

you're missing this....

If you read your error

SELECT * from moderation_templates where category = '1'
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'cleangraphic.moderation_templates' doesn't exist

So here is a fix...

CREATE TABLE IF NOT EXISTS `moderation_templates` (
  `Name` varchar(100) DEFAULT NULL,
  `Banmessage` varchar(100) DEFAULT NULL,
  `Banhours` int(30) DEFAULT NULL,
  `AvatarBan` int(30) DEFAULT NULL,
  `Mute` int(30) DEFAULT NULL,
  `TradeLock` int(30) DEFAULT NULL,
  `Warningmessage` varchar(30) DEFAULT NULL,
  `category` int(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `moderation_templates`
--

INSERT INTO `moderation_templates` (`Name`, `Banmessage`, `Banhours`, `AvatarBan`, `Mute`, `TradeLock`, `Warningmessage`, `category`) VALUES
('1 day ban', 'You got banned', 24, 0, 0, 0, 'You got banned', 1);

Next Time Read The Errors

Also When you update you also need to update the Structures to it also not just the Packet IDs.

[Pastie]

@Glee
Any chance you can give me the structure for it if you got it?

Thanks,
Invitee.

[ProducerMark]

When you update to another release build you have to update a lot of structures, not just one or two, so be sure to put a lot of time in it if you're sure to update.

[Glee]

structures are hard to update.... their's like 40+ Structures to update (I'm guessing random #)

[Pastie]

Aha.. So how do I get those structures? You know that? (Never updated emulator before)...

Thanks,
Invitee.

[streamhotel]

Yeah, this is for the automatic alert but it's not coded in that emulator (tut: http://forum.ragezone.com/f353/autom...oators-994473/).

[Pastie]

Now its going all crazy here! Throws nearly every packet connection as a error:




Someone know how to fix this????

Thanks,
Invitee.

[ProducerMark]

Now its going all crazy here! Throws nearly every packet connection as a error:




Someone know how to fix this????

Thanks,
Invitee.

What did you do?

[Pastie]

@ProducerMark
Just got a fresh Plus R2 emulator, updated the packets.

[Glee]

you need to update the packet ID

[Pastie]

I have done that

[ProducerMark]

According to the image, a lot of headers have not been specified, or nothing happens with them (no handlers)

[Pastie]

I only updated the packets I found here on the forum... Gonna have a look on keko if they got any release with the packet IDs :)

Thanks,
Invitee.