Help?!

<?php

require_once('./data_classes/server-data.php_data_classes-core.php.php');
require_once('./data_classes/server-data.php_data_classes-session.php.php');

mysql_query("UPDATE users SET auth_ticket = '', auth_ticket = '".GenerateTicket()."', ip_last = '', ip_last = '".$remote_ip."' WHERE id = '".$my_id."'") or die(mysql_error());

$ticketsql = mysql_query("SELECT * FROM users WHERE id = '".$my_id."'") or die(mysql_error());
$ticketrow = mysql_fetch_assoc($ticketsql);

$client_port = mysql_fetch_assoc($client_port = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_port'"));
$client_mus = mysql_fetch_assoc($client_mus = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_mus'"));
$client_ip = mysql_fetch_assoc($client_ip = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_ip'"));
$client_variables = mysql_fetch_assoc($client_variables = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_variables'"));
$client_variables_night = mysql_fetch_assoc($client_variables_night = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_variables_night'"));
$client_texts = mysql_fetch_assoc($client_texts = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_texts'"));
$client_swf_path = mysql_fetch_assoc($client_swf_path = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_swf_path'"));
$client_habbo_swf = mysql_fetch_assoc($client_habbo_swf = mysql_query("SELECT * FROM cms_settings WHERE variable = 'client_habbo_swf'"));
$client_limit = mysql_fetch_assoc($client_limit = mysql_query("SELECT * FROM cms_settings WHERE variable = 'cms_clientlimit'"));

if($user_rank > 4 && $_SESSION['acp'] == 0){

echo"<script>alert(\"Bitte log dich ins Housekeeping ein, damit du ins Hotel einchecken kannst.\");</script>
<meta http-equiv=\"refresh\" content=\"0;url=".$adminpath."/index/p/login&do=secretcode\">";

} elseif($user_rank < 2 && $online_count >= $client_limit['value']){

require_once('./templates/login_subheader.php');
require_once('./templates/login_header.php');

?>
<br>
<div id="intermediate">
<h2><center>Clientlimit</center></h2>
<div id="enter-hotel">
<div class="open enter-btn">
<a href="<?php echo $path; ?>/me" target="me" onclick="return onClientOpen(this)">Einchecken<i></i></a><b></b>
</div>
</div>

<div id="info">
Zurzeit sind <b><?php echo $online_count; ?></b> Online!<br>Clientlimit: <b><?php echo $client_limit['value']; ?></b><br><br>Sobald <b><?php echo $online_count + 1 - $client_limit['value']; ?></b> Mitglieder Offline gegangen sind, kannst du Einchecken!
</div>

<div id="enter-mypage">
<a href="<?php echo $path; ?>/client" class="new-button green-button" style="left: -250px;"><b>Aktualsieren &raquo;</b><i></i></a>
<a href="<?php echo $path; ?>" class="new-button red-button" style="left: -250px;"><b>&laquo; Zurück</b><i></i></a>
</div>
<?php require_once('./templates/login_footer.php'); }else{ require_once('./templates/client_subheader.php'); ?>
<script type="text/javascript">
FlashExternalInterface.loginLogEnabled = true;

FlashExternalInterface.logLoginStep("web.view.start");

if (top == self) {
FlashHabboClient.cacheCheck();
}
var flashvars = {
"client.allow.cross.domain" : "1",
"client.notify.cross.domain" : "0",
"connection.info.host" : "habix-hotel.zapto.org",
"connection.info.port" : "30000",
"site.url" : "<?php echo $path; ?>",
"url.prefix" : "<?php echo $path; ?>",
"client.reload.url" : "http://habix-hotel.zapto.org/client",
"client.fatal.error.url" : "<?php echo $path; ?>/clientutils",
"client.connection.failed.url" : "<?php echo $path; ?>/clientutils",
"external.variables.txt" : "http://habix-hotel.zapto.org/r63/external_variables.txt",
"external.texts.txt" : "http://habix-hotel.zapto.org/r63/external_flash_texts.txt",
"productdata.load.url" : "http://habix-hotel.zapto.org/r63/productdata.txt",
"furnidata.load.url" : "http://habix-hotel.zapto.org/r63/furnidata.txt",
"use.sso.ticket" : "1",
"sso.ticket" : "<?php echo $ticketrow['auth_ticket']; ?>",
"processlog.enabled" : "1",
"account_id" : "1",
"client.starting" : "Bitte warten! <?php echo $shortname; ?> wird geladen.",
"flash.client.url" : "http://habix-hotel.zapto.org/r63/",
"user.hash" : "31385693ae558a03d28fc720be6b41cb1ccfec02",
"has.identity" : "1",
"flash.client.origin" : "popup"

};
var params = {
"base" : "http://habix-hotel.zapto.org/r63/",
"allowScriptAccess" : "always",
"menu" : "false",
"bgcolor" : "#000",
"wmode" : "transparent"
};

if (!(HabbletLoader.needsFlashKbWorkaround())) {
params["wmode"] = "opaque";
}

FlashExternalInterface.signoutUrl = "<?php echo $path; ?>/account/logout?token=<?php echo sha1($myrow['password']); ?>";

var clientUrl = "http://habix-hotel.zapto.org/r63/Habbo.swf";

swfobject.embedSWF(clientUrl, "flash-container", "100%", "100%", "10.0.0", "http://habix-hotel.zapto.org/web-gallery/fl…ressInstall.swf", flashvars, params);

window.onbeforeunload = unloading;
function unloading() {
var clientObject;
if (navigator.appName.indexOf("Microsoft") != -1) {
clientObject = window["flash-container"];
} else {
clientObject = document["flash-container"];
}
try {
clientObject.unloading();
} catch (e) {}
}
</script>

<meta name="description" content="Habbo Hotel - Freunde treffen, Spaß haben und berühmt werden." />
<meta name="keywords" content="Habbo Hotel , virtuell, Welt, social network, gratis, community, avatar, chat, online, teen, Rollenspiel, anmelden, sozial, Gruppen, Foren, sicher, spielen, games, online, Freunde, teens, rares, rare Möbel, sammeln, erstellen, sammeln, treffen, Möbel, furni, Haustiere, Raum erstellen, teilen, Ausdruck, Badges, Treffpunkt, Musik, Stars, Starchats, VIPs, mmo, mmorpg, massiv multiplayer" />

<!--[if IE 8]>
<link rel="stylesheet" href="<?php echo $path; ?>/web-gallery/static/styles/ie8.css" type="text/css" />
<![endif]-->
<!--[if lt IE 8]>
<link rel="stylesheet" href="<?php echo $path; ?>/web-gallery/static/styles/ie.css" type="text/css" />
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" href="<?php echo $path; ?>/web-gallery/static/styles/ie6.css" type="text/css" />
<script src="<?php echo $path; ?>/web-gallery/static/js/pngfix.js" type="text/javascript"></script>

<script type="text/javascript">

try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
</script>

<style type="text/css">
body { behavior: url(/js/csshover.htc); }
</style>
<![endif]-->

<meta name="build" content="63-BUILD406 - 09.05.2011 23:04 - de" />
<body id="client" class="flashclient">
<script type="text/javascript">
jjLoader.init('client', 6, '<?php echo $path; ?>/web-gallery/v2/images/habbo.png', 'http://habbo.hs.llnwd.net/c_images/hotel…_xmas10_000.png');
</script>
<div id="overlay"></div>
<img src="<?php echo $path; ?>/web-gallery/v2/images/page_loader.gif" style="position:absolute; margin: -1500px;" />
t-ui" >
<div id="flash-wrapper">
<div id="flash-container">
<div id="content" style="width: 400px; margin: 20px auto 0 auto; display: none">
<div class="cbb clearfix">
<h2 class="title">Bitte besorg dir die neueste Adobe Flash Player Version.</h2>

<div class="box-content">
<p>Hier kannst Du den Adobe Flashplayer herunterladen und installieren: <a href="http://get.adobe.com/flashplayer/">Install flash player</a>. Mehr Informationen und Anweisungen zur Installation sind hier zu finden: <a href="http://www.adobe.com/products/flash…o/instructions/">Mehr Informationen</a></p>
<p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://images.habbo.com/habboweb/63_1d…lash_player.gif" alt="Get Adobe Flash player" /></a></p>
</div>
</div>
</div>
<script type="text/javascript">
$('content').show();
</script>

<noscript>
<div style="width: 400px; margin: 20px auto 0 auto; text-align: center">
<p>If you are not automatically redirected, please <a href="/client">click here</a></p>
</div>
</noscript>
</div>
</div>
<div id="content" class="client-content"></div>
</div>
<div style="display: none">
<div id="habboCountUpdateTarget">
1,323 Mitglieder online
</div>
<script language="JavaScript" type="text/javascript">
setTimeout(function() {
HabboCounter.init(600);
}, 20000);
</script>

</div>
<script type="text/javascript">
RightClick.init("flash-wrapper", "flash-container");
if (window.opener && window.opener != window && window.opener.location.href == "/") {
window.opener.location.replace("/me");
}
$(document.body).addClassName("js");
HabboClient.startPingListener();
</script>
<div id="fb-root"></div>
<script type="text/javascript">
(function() {
var e = document.createElement('script');
e.async = true;
e.src = 'https://connect.facebook.net/de_DE/all.js';
document.getElementById('fb-root').appendChild(e);
}());
</script>

<iframe name="logframe" src="/bc/logframe?" width="0" height="0" frameborder="0" scrolling="no" marginwidth="0" marginheight="0" style="position: absolute; top:0; left:0"></iframe>

<iframe name="conversion-tracking" src="/conversion_tracking_frame" width="0" height="0" frameborder="0" scrolling="no" marginwidth="0" marginheight="0" style="position: absolute; top:0; left:0"></iframe>

<script type="text/javascript">
var _gaq = _gaq [];
_gaq.push(['_setAccount', 'UA-448325-18']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
<script type="text/javascript">
HabboView.run();
</script>

</body>
</html>
<?php } ?>