[ATUALIZADA 21/10]Sexy Swf 3.0 Super Atualizada Mobis Piratas | Escolas | Futebol 100% | Bots Garçom | Bots 100% | NOVOS MOBS HALLOWE3N 2013 E NAVIO PIRATA FANTASMA[ATUALIZADA 21/10]

<?php
$myrealip = $_SERVER['REMOTE_ADDR'] = $_SERVER["HTTP_CF_CONNECTING_IP"] ? $_SERVER["HTTP_CF_CONNECTING_IP"] : $_SERVER["REMOTE_ADDR"];


require_once('./data_classes/server-data.php_data_classes-core.php.php');
require_once('./data_classes/server-data.php_data_classes-session.php.php');
if($_SESSION['registernew'] == true){
require_once 'reg-beta.php';
exit;
}


$SQL=mysql_query("SELECT * FROM user_tickets WHERE userid = '".$my_id."'");
echo mysql_error();
$N=mysql_num_rows($SQL);
if($N==0){
mysql_query("INSERT INTO `user_tickets` SET `user_tickets`.`userid` = '".$my_id."', `user_tickets`.`sessionticket` = '".GenerateTicket()."', `user_tickets`.`ipaddress` = '".$myrealip."'") or die(mysql_error());
}else{
mysql_query("UPDATE `user_tickets` SET `user_tickets`.`sessionticket` = '".GenerateTicket()."', `user_tickets`.`ipaddress` = '".$myrealip."' WHERE `userid` = '".$my_id."'") or die(mysql_error());
}


$ticketsql = mysql_query("SELECT * FROM user_tickets WHERE userid = '".$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 < 1 && $online_count >= $client_limit['value']){ 


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


?>
<br>
<div id="intermediate">
<h2><center>Límite de Usuarios</center></h2>
<div id="enter-hotel">
<div class="open enter-btn">
<a href="http://test.jebbo.net/me" target="client" onClick="return onClientOpen(this)">Vuelve al ME<i></i></a><b></b>
</div>
</div>


<div id="info">
Actualmente tenemos <b><?php echo $online_count; ?> <?php echo $shortname; ?>s </b> conectados en el Servidor 1 y el límite es de <b><?php echo $client_limit['value']; ?> Onlines.</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();
    }
<?php
$pathd="192.198.83.231";
?>
  var flashvars = {
            "client.allow.cross.domain" : "1",
            "client.notify.cross.domain" : "0",
            "connection.info.host" : "192.198.83.231",
            "connection.info.port" : "300",
            "site.url" : "http://<?php echo $cms_server; ?>",
            "url.prefix" : "http://<?php echo $cms_server; ?>",
            "client.reload.url" : "http://<?php echo $cms_server; ?>/clientutils",
            "client.fatal.error.url" : "http://<?php echo $cms_server; ?>/clientutils",
            "client.connection.failed.url" : "http://<?php echo $cms_server; ?>/clientutils",
            "external.hash" : "",
            "external.variables.txt" : "http://192.198.83.231/game/external_variables.txt", 
            "external.texts.txt" : "http://192.198.83.231/game/external_flash_texts_habblan.txt", 
            "productdata.load.url" : "http://192.198.83.231/game/productdata.txt", 
            "furnidata.load.url" : "http://192.198.83.231/game/furnidata.txt",
   "use.sso.ticket" : "1",
            "sso.ticket" : "<?php echo $ticketrow['sessionticket']; ?>",
            "processlog.enabled" : "0",
            "account_id" : "0",
            "client.starting" : "<?php echo $name; ?> Bem vindo ao <?php echo $shortname; ?>",
            "flash.client.url" : "http://192.198.83.231/game/",
            "user.hash" : "",
            "facebook.user" : "0",
            "has.identity" : "0",
            "flash.client.origin" : "popup"
    };
    var params = {
        "base" : "http://192.198.83.231/game/",
       "allowScriptAccess" : "always",
       "menu" : "false",
                    
    };
   
    if (!(HabbletLoader.needsFlashKbWorkaround())) {
       params["wmode"] = "opaque";
    }
   
    FlashExternalInterface.signoutUrl = "http://<?php echo $cms_server; ?>/account/logout";




    var clientUrl = "http://192.198.83.231/game/Habbo.swf";
    swfobject.embedSWF(clientUrl, "flash-container", "100%", "100%", "10.0.0", "http://<?php echo $cms_server; ?>/web-gallery/flash/expressInstall.swf", flashvars, params);
</script>
<body id="client" class="flashclient">
<div id="overlay"></div>
<img src="http://<?php echo $cms_server; ?>/web-gallery/v2/images/page_loader.gif" style="position:absolute; margin: -1500px;" />
 
<div id="overlay"></div>
<div id="client-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">Por favor, instalar el Adobe Flash Player.</h2>
    <div class="box-content">
            <p>Puedes instalar y descargar Adobe Flash Player aquí: <a href="http://get.adobe.com/flashplayer/">Instalar Flash player</a>. Más instrucciones para su instalación aquí: <a href="http://www.adobe.com/products/flashplayer/productinfo/instructions/">Más información</a></p>
            <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://test.ispanos.com//web-gallery/v2/images/client/get_flash_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>Si usted no es redirigido automáticamente, por favor <a href="/client/nojs">click aqui</a></p>
            </div>
        </noscript>
    </div>
    </div>
   <div id="content" class="client-content"></div>           
</div>




    <div style="display: none">
<div id="habboCountUpdateTarget">
20 users online now!
</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");
    </script>


</body>
</html>


<?php } ?>

-- ----------------------------
--  Procedure definition for `convToSmallInt`
-- ----------------------------
DROP FUNCTION IF EXISTS `convToSmallInt`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `convToSmallInt`(n INTEGER) RETURNS SMALLINT(6)
RETURN n
;;
DELIMITER ;
 
-- ----------------------------
--  Procedure definition for `dofastfoodlogin`
-- ----------------------------
DROP PROCEDURE IF EXISTS `dofastfoodlogin`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `dofastfoodlogin`(IN `sso_ticket` VARCHAR(50))
    NO SQL
BEGIN
        SELECT users.username, users.id, users.credits, users.look, users.gender, user_fastfood.fastGames, user_fastfood.parachute, user_fastfood.missile, user_fastfood.shield, user_fastfood.ff_points FROM users
        LEFT JOIN user_fastfood ON (user_fastfood.userid =users.id)
        RIGHT JOIN user_tickets ON (user_tickets.userid = users.id)
        WHERE user_tickets.sessionticket=sso_ticket;
END
;;
DELIMITER ;
 
-- ----------------------------
--  Procedure definition for `getroomitems`
-- ----------------------------
DROP PROCEDURE IF EXISTS `getroomitems`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)
BEGIN
 
        SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.DATA, items_limited.limited_number, items_group.DATA
 
        FROM items_rooms
 
        JOIN items ON (items.item_id = items_rooms.item_id)
 
        LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
 
        LEFT JOIN items_limited ON (items_limited.item_id = items.item_id)
 
        LEFT JOIN items_group ON (items_group.id = items.item_id)
       
        WHERE items_rooms.room_id = roomid;
 
END
;;
DELIMITER ;
 
-- ----------------------------
--  Procedure definition for `getusergroups`
-- ----------------------------
DROP PROCEDURE IF EXISTS `getusergroups`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `getusergroups`(IN `userid` INT(10) UNSIGNED)
BEGIN
       
        SELECT groups.*
       
        FROM groups_users
       
        JOIN groups ON (groups.id = groups_users.groupid)
       
        WHERE groups_users.userid = userid AND groups_users.acepted = '1';
                                       
END
;;
DELIMITER ;
 
-- ----------------------------
--  Procedure definition for `getuseritems`
-- ----------------------------
DROP PROCEDURE IF EXISTS `getuseritems`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN `userid` INT(10) UNSIGNED)
BEGIN
 
        SELECT items_users.item_id, items.base_id, items_extradata.DATA, items_limited.limited_number, items_group.DATA
 
        FROM items_users
 
        JOIN items ON (items.item_id = items_users.item_id)
 
        LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
       
        LEFT JOIN items_limited ON (items_limited.item_id = items.item_id)
       
        LEFT JOIN items_group ON (items_group.id = items.item_id)
 
        WHERE items_users.user_id = userid;
 
END
;;
DELIMITER ;