help PhoenixPHP to r63B client

[Holoday2014]

Hi RZ


I have an problem with my emulator config on PhoenixPHP
swift and bcstorm works great but i will trylion emulator run on my hotel
but sso tickets is user_tickets in the emulator

and how change i this

<?php$rand1 = rand(100000, 999999);
$rand2 = rand(10000, 99999);
$rand3 = rand(10000, 99999);
$rand4 = rand(10000, 99999);
$rand5 = rand(10000, 99999);
$rand6 = rand(1, 9);
$ticket = "ST-".$rand1."-".$rand2.$rand3."-".$rand4.$rand5."-otaku-".$rand6;
$username = $_SESSION['username'];
if(@$_GET['ticket'] && @$_GET['username'] && $users->UserPermission('hk_ext_login', $_SESSION['username']))
{
    $username = $_GET['username'];
    $ticket = $_GET['ticket'];
}
$query = mysql_query("UPDATE users SET auth_ticket = '$ticket' WHERE username = '$username'");
$query = mysql_query("UPDATE users SET ip_last = '".$_SERVER['REMOTE_ADDR']."' WHERE username = '$username'");
?>

the ticket system is

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

[MentaL]

[Superfun]

You are updating auth_ticket in the php part (users table), while you in the c# code make a query on table user_tickets

[Gaby]

Change:

<?php$rand1 = rand(100000, 999999);$rand2 = rand(10000, 99999);$rand3 = rand(10000, 99999);$rand4 = rand(10000, 99999);$rand5 = rand(10000, 99999);$rand6 = rand(1, 9);$ticket = "ST-".$rand1."-".$rand2.$rand3."-".$rand4.$rand5."-otaku-".$rand6;$username = $_SESSION['username'];if(@$_GET['ticket'] && @$_GET['username'] && $users->UserPermission('hk_ext_login', $_SESSION['username'])){ $username = $_GET['username']; $ticket = $_GET['ticket'];}$query = mysql_query("UPDATE users SET auth_ticket = '$ticket' WHERE username = '$username'");$query = mysql_query("UPDATE users SET ip_last = '".$_SERVER['REMOTE_ADDR']."' WHERE username = '$username'"); ?>

To:

<?php$rand1 = rand(100000, 999999);$rand2 = rand(10000, 99999);$rand3 = rand(10000, 99999);$rand4 = rand(10000, 99999);$rand5 = rand(10000, 99999);$rand6 = rand(1, 9);$ticket = "ST-".$rand1."-".$rand2.$rand3."-".$rand4.$rand5."-otaku-".$rand6;$username = $_SESSION['username'];if(@$_GET['ticket'] && @$_GET['username'] && $users->UserPermission('hk_ext_login', $_SESSION['username'])){ $username = $_GET['username']; $ticket = $_GET['ticket'];}$query = mysql_query("UPDATE users SET user_tickets = '$ticket' WHERE username = '$username'");$query = mysql_query("UPDATE users SET ip_last = '".$_SERVER['REMOTE_ADDR']."' WHERE username = '$username'"); ?>

[azaidi]

Change:

To:

No, just no

You should use those queries:
DELETE FROM user_tickets WHERE userid = @user_id
INSERT INTO user_tickets (userid, sessionticket, ipaddress) VALUES (@user_id, @sso, @ip)

Replace the @s with the php variables afcourse