Butterfly emulator SSO

Results 1 to 4 of 4
  1. #1
    Member TCHC83 is offline
    MemberRank
    Feb 2011 Join Date
    84Posts

    Butterfly emulator SSO

    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.

    Screenshot by Lightshot - Client
    Screenshot by Lightshot - Emulator

    MySQL error log:
    PHP Code:
    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 


  2. #2
    Check http://arcturus.pw The General is offline
    DeveloperRank
    Aug 2011 Join Date
    7,613Posts

    Re: Butterfly emulator SSO

    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;

  3. #3
    Member TCHC83 is offline
    MemberRank
    Feb 2011 Join Date
    84Posts

    Re: Butterfly emulator SSO

    Thanks for the sql.

  4. #4
    Grand Master KyleeIsProzZ is offline
    Grand MasterRank
    Oct 2012 Join Date
    C:Location
    548Posts

    Re: Butterfly emulator SSO

    Haha I don't need this I made Butterstorm = R63B Emulator work for phoenix changeing it from user_tickets too auth_ticket in users table!..... :)



Advertisement