Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Butterfly emulator SSO

Initiate Mage
Joined
Feb 27, 2011
Messages
42
Reaction score
5
I almost have Jonteh's Butterfly release working. The problem i'm encountering now is the sso.

When I enter the client I receive a notice stating that my session ticket can not be found.

- Client
- Emulator

MySQL error log:
PHP:
Error in query: 
SELECT users.* FROM users RIGHT JOIN user_tickets ON user_tickets.userid = users.id WHERE user_tickets.sessionticket = @sso
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'uber2.user_tickets' 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Database_Manager.Database.Session_Details.QueryAdapter.getRow() in C:\Users\Oracle\Desktop\Butterfly\Database Manager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 103
 
Joined
Aug 10, 2011
Messages
7,400
Reaction score
3,295
You read the error? It says ubercms2.user_tickets does not exists.

Code:
CREATE TABLE IF NOT EXISTS `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
Upvote 0
Back
Top