[REL/DEV] UberCMS 2 [PHP, MySQL, OOP]

I fixed everything about it now, I'm getting a error on my EMU..

Code:

---

connection dropped [MYIP] exception logged

---

Then in the exception file, I get this

Code:

---

System.ArgumentException: Column 'hide_inroom' does not belong to table .
  at System.Data.DataRow.GetDataColumn(String columnName)
  at System.Data.DataRow.get_Item(String columnName)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.xdb64faa4eab54656(DataRow x6b73aa01aa019d3a, String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.Users.Authenticator.x33bd309dad9062ca.x84b098ea6605bc34(String x96d4b0dc3ed8f2a3, xca0375af76c32b7d x9546072177ed2413, xf174b6b774db7993 x603a302c6dc49397, xf174b6b774db7993 x153ed47707b469cb)
  at Phoenix.HabboHotel.GameClients.xca0375af76c32b7d.x65786cb9e5cd1242(String x96d4b0dc3ed8f2a3)

---

Can someone make a swift response and, give me a fix?

Add hide_inroom to `users` table @LHazze

Thanks, fixed it. Had to add a couple more. but in the end its online!

i do not now if im posting in right place but, i getting a error which goes like this
Title: Table 'lol3.external_texts' doesn't exist

@ Everyone, This CMS works, 100%, client works, and all! XAMPP and IIS works, so I don't see why everyone is getting problems.

@Feedback i agree it works for me :D

So what we need to do to set this up is to edit system_config and ubercms_config. Also I've imported both Phoenix and UberCMS databases already. Is this all?

Registering seems to work, but with errors:

Code:

---

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 20 in C:\wamp\www\includes\class.core.php on line 191
Call Stack
#        Time        Memory        Function        Location
1        0.0005        737864        {main}( )        ..\me.php:0
2        0.0013        901736        require_once( 'C:\wamp\www\global.php' )        ..\me.php:22
3        0.0198        1721160        uberCore::GetMaintenanceStatus( )        ..\global.php:157
4        0.0200        1722944        mysql_result ( )        ..\class.core.php:191

---

It's located to the top of the page, even if I try to go to another page within the CMS. On WampServer, does it got to do with error reporting?

Confused Muffmuncher.

I like

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 16 in C:\xampp\htdocs\includes\class.core.php on line 191
Title: Table 'uberdb.bans' doesn't exist
Text: Table 'uberdb.bans' doesn't exist

Wtf? :blink:

Can't Add the `newcrypto` column to the `users` table, enum('1','0') not null default 1;

It shows me a error -_-

EDIT: When I run the `newcrypto` column to the `users` table, with the other columns, it run it correctly, but doesn't show the coulmn in the table? :S

EDIT2: Title: Could not execute cron job 'credits.php': could not locate script file.
Text: Could not execute cron job 'credits.php': could not locate script file. ...

EDIT3: Nvm.. Fixed. But I don't like the cms :tongue: sorry..

any SWF's Support ? :)

Quote:

---

Originally Posted by omaralali12

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 16 in C:\xampp\htdocs\includes\class.core.php on line 191
Title: Table 'uberdb.bans' doesn't exist
Text: Table 'uberdb.bans' doesn't exist

Wtf? :blink:

Can't Add the `newcrypto` column to the `users` table, enum('1','0') not null default 1;

It shows me a error -_-

EDIT: When I run the `newcrypto` column to the `users` table, with the other columns, it run it correctly, but doesn't show the coulmn in the table? :S

---

Add the bans table!

is it phoenix compatible?

Just configured this with Nginx, runs like a charm, totally going to be using this when my hotel goes live :-)

Best CMS release so far Jonteh.

Going to install NGINX & PHP & MySQL on my Windows PC to see how it turns out :)

Thanks for this Johnteh, I think I found the missing Javascript files *sigh*

BTW I am stock in thehabbos.rog


Then i cant go back in my index.php ?? HOW TO SOLVE IT ? :(

@Johnteh:

My hotels passwords are encrypted in MD5, this is hello123 on MD5:

Code:

---

f30aa7a662c728b7407c54ae6bfd27d1

---

I'm not sure how to convert all my passwords to whatever yours is in, is this possible, this is the example of hello123 in your CMS:

Code:

---

291c2e7500ae8169bdb5c7d7a9de315358d55042

---

Quote:

---

Originally Posted by JoshuaLuke

Going to install NGINX & PHP & MySQL on my Windows PC to see how it turns out :)

Thanks for this Johnteh, I think I found the missing Javascript files *sigh*

---

It's extremely easy to configure, there are tons of tutorials out there to get you started.
If you need any help take a look at this one: nginx + PHP on Windows in 5 minutes | This page intentionally left ugly

Quote:

---

Originally Posted by iHarrison

It's extremely easy to configure, there are tons of tutorials out there to get you started.
If you need any help take a look at this one: nginx + PHP on Windows in 5 minutes | This page intentionally left ugly

---

I got a 404 ERROR NOT FOUND page when I followed that turorial. I can't seem to get the homes working though ._.

Quote:

---

Originally Posted by JoshuaLuke

I got a 404 ERROR NOT FOUND page when I followed that turorial. I can't seem to get the homes working though ._.

---

I just posted a tutorial which should help: http://forum.ragezone.com/f335/setup...-nginx-844974/

Quote:

---

Originally Posted by </Kidrambodubstep\>

is it phoenix compatible?

---

yes and butterfly compatible too

Jonteh I found a few things that have caused me trouble.

A. You use ". www ." on some of the pages, rather than %www%, which actually works, and this applies to other things.
B. Avatar imagery doesn't work unless you edit it.
C. I'm getting the flash player error upon entering client. Anyone know a fix for this; been so long since I had it!

This looks good jonteh.

Quote:

---

Originally Posted by FullmetalPride

Jonteh I found a few things that have caused me trouble.

A. You use ". www ." on some of the pages, rather than %www%, which actually works, and this applies to other things.
B. Avatar imagery doesn't work unless you edit it.
C. I'm getting the flash player error upon entering client. Anyone know a fix for this; been so long since I had it!

---

Try this Fullmetal:

Quote:

---

Originally Posted by Jonteh

newclient.php

PHP Code:

---

<?php
    /*
               |
        .   .|---.,---.,---.
        |   ||   ||---'|         UberCMS 2.0
        `---'`---'`---'`
            UberCMS
            Coded originally by Meth0d (2010-2011)
            Continued by Jonty (2011-now)
            
            Build 2.0.0 SS, Public
    */


    require_once "global.php";


if (!LOGGED_IN)
{
    header("Location: " . WWW. "/");
    exit;
}


if(!isset($_SESSION["has_voted"]) || $_SESSION["has_voted"] == false) {
        if ($voting['thehabbos_enabled'] == true) {
            $hasVoted = true;
        } 
        else {
            $hasVoted = false;
        }
}
else {
        $hasVoted = true;
}


if($hasVoted == false) {
    $_SESSION["has_voted"] = true;
    header("Location: http://votingapi.com/vote.php?username=" . $voting['thehabbos_username'] . "&api=" . $voting['thehabbos_returnurl']);
}


if($site['enable_pincodes'] == true && $users->GetUserVar(USER_ID, 'rank') >= $site['pincode_minrank']) {
    if(!isset($_SESSION["staff_PassAuth"])) {
        header ("Location: " . WWW . "/client_denied");
    }
}


// **************************************************************************************************************
// **************************************************************************************************************
$users->CheckSSO(USER_ID);


$checkExists = dbquery("SELECT userid FROM user_tickets WHERE userid = '" . USER_ID . "'");
$userTicket = $users->GetUserVar(USER_ID, 'auth_ticket');


if($server['butterfly_sso'] == true) {
    if(mysql_num_rows($checkExists)) {
        dbquery("UPDATE user_tickets SET sessionticket = '" . $userTicket . "', ipaddress = '" . $_SERVER["REMOTE_ADDR"] . "' WHERE userid = '" . USER_ID . "'");
    }
    else {
        dbquery("INSERT INTO user_tickets (userid,sessionticket,ipaddress) VALUES ('" . USER_ID . "', '" . $userTicket . "', '" . $_SERVER["REMOTE_ADDR"] . "')");
    }
}
else if($server['phoenix_secure_sessions'] == true) {
    dbquery("UPDATE `users` SET `auth_ticket` = '" . $users->GetUserVar(USER_ID, "auth_ticket") . "' WHERE id = '" . USER_ID . "'");
}




$forwardType = 0;
$forwardId = 0;


// Due to an issue with most servers, tags have been disabled in the CMS by default.


if (mysql_num_rows(dbquery("SELECT * FROM user_tags WHERE user_id = '" . USER_ID . "' LIMIT 1"))) {
    dbquery("DELETE FROM user_tags WHERE user_id = '" . USER_ID . "'");
}


if ($users->getUserVar(USER_ID, 'newbie_status') == "2") {    
    // Run POST-REGISTRATION checks
    dbquery("UPDATE `users` SET
                `motto` = '" . $server['default_motto'] . "',
                `credits` = '" . $server['default_credits'] . "',
                `activity_points` = '" . $server['default_pixels'] . "',
                `look` = '" . $server['default_look'] . "',
                `home_room` = '" . $server['default_room'] . "',
                `rank` = '" . $server['default_rank'] . "',
                `newbie_status` = '3'
                WHERE `id` = '" . USER_ID . "'");
}




dbquery("UPDATE users SET ip_last = '".$_SERVER['REMOTE_ADDR']."' WHERE username = '".USER_NAME."'");


$tpl->Init();


$client = new Template('page-client');
$client->SetParam('page_title', ' ');
$client->SetParam('sso_ticket', $users->GetUserVar(USER_ID, 'auth_ticket', false));
$client->SetParam('flash_base', 'http://images.habbo.com/swf/r64/');
$client->SetParam('flash_client_url', 'http://images.habbo.com/dcr/r51_none_b4ea29afdff17a13afb841a9811ebf55/');
$client->SetParam('hotel_status', $core->GetUsersOnline() . ' users online now!');
$client->SetParam('forwardType', $forwardType);
$client->SetParam('forwardId', $forwardId);




$tpl->AddGeneric('head-init');
$tpl->AddIncludeSet('default');
$tpl->AddIncludeFile(new IncludeFile('text/css', 'http://%cdn%/%hotel%/%web_build%/web-gallery/styles/habboclient.css', 'stylesheet'));
$tpl->AddIncludeFile(new IncludeFile('text/css', 'http://%cdn%/%hotel%/%web_build%/web-gallery/styles/habboflashclient.css', 'stylesheet'));
$tpl->AddIncludeFile(new IncludeFile('text/javascript', 'http://%cdn%/%hotel%/%web_build%/web-gallery/styles/habboflashclient.js'));
$tpl->WriteIncludeFiles();
$tpl->AddGeneric('head-bottom');




if (isset($_GET['forceTicket']) && $users->HasFuse(USER_ID, 'fuse_admin'))
{
    $client->SetParam('sso_ticket', $_GET['forceTicket']);
}


$tpl->AddTemplate($client);


$tpl->Output();


?>

---

page-client.tpl - this is my personal zap one so the values in the configuration won't set to this

PHP Code:

---

<noscript>    <meta http-equiv="refresh" content="0;url=/client/nojs" /></noscript>
<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" : "1",            "connection.info.host" : "127.0.0.1",                "connection.info.port" : "30000",            "site.url" : "http://zaphotel.net",             "url.prefix" : "http://zaphotel.net",             "client.reload.url" : "http://zaphotel.net/login_popup",             "client.fatal.error.url" : "http://zaphotel.net/flash_client_error",             "client.connection.failed.url" : "http://zaphotel.net/client",             "external.variables.txt" : "http://zaphotel.net/lolcats/bflyswfs/external_variables.txt",             "external.texts.txt" : "http://zaphotel.net/externals.php?id=external_flash_texts",             "productdata.load.url" : "http://zaphotel.net/lolcats/bflyswfs/productdata.txt",             "furnidata.load.url" : "http://zaphotel.net/lolcats/bflyswfs/furnidata.txt",             "use.sso.ticket" : "1",             "sso.ticket" : "%sso_ticket%",             "processlog.enabled" : "1",            "account_id" : "19927505",             "client.starting" : "Please wait! Zap is Loading.",            "flash.client.url" : "http://zaphotel.net/client.php",            "user.hash" : "199275052dbf5f89adb0a643bf16b0ea1cd646db",             "flash.client.origin" : "popup"                                                                                                                                                                                    };
    var params = {        "base" : "http://zaphotel.net/lolcats/bflyswfs/",        "allowScriptAccess" : "always",        "menu" : "false"                    };        if (!(HabbletLoader.needsFlashKbWorkaround())) {        params["wmode"] = "opaque";    }            var clientUrl = "http://zaphotel.net/lolcats/bflyswfs/Working.swf";     swfobject.embedSWF(clientUrl, "flash-container", "100%", "100%", "10.0.0", "http://%cdn%/%hotel%/%web_build%/web-gallery/flash/expressInstall.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="Check into the worldís largest virtual hotel for FREE! Meet and make friends, play games, chat with others, create your avatar, design rooms and moreÖ" /><meta name="keywords" content="habbo hotel, virtual, world, social network, free, community, avatar, chat, online, teen, roleplaying, join, social, groups, forums, safe, play, games, online, friends, teens, rares, rare furni, collecting, create, collect, connect, furni, furniture, pets, room design, sharing, expression, badges, hangout, music, celebrity, celebrity visits, celebrities, mmo, mmorpg, massively multiplayer" />


<!--[if IE 8]><link rel="stylesheet" href="http://%cdn%/%hotel%/%web_build%/web-gallery/v2/styles/ie8.css" type="text/css" /><![endif]--><!--[if lt IE 8]><link rel="stylesheet" href="http://%cdn%/%hotel%/%web_build%/web-gallery/v2/styles/ie.css" type="text/css" /><![endif]--><!--[if lt IE 7]><link rel="stylesheet" href="http://%cdn%/%hotel%/%web_build%/web-gallery/v2/styles/ie6.css" type="text/css" /><script src="http://%cdn%/%hotel%/%web_build%/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-BUILD36 - 16.11.2010 11:51 - com" /></head>
<body id="client" class="flashclient"><div id="overlay"></div><img src="http://%cdn%/%hotel%/%web_build%/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">Please update your Flash Player to the latest version.</h2>    <div class="box-content">            <p>You can install and download Adobe Flash Player here: <a onclick="_gaq.push(['_trackEvent', 'Outgoing', 'get.adobe.com', '/flashplayer/']);" rel="nofollow" href="http://get.adobe.com/flashplayer/">Install flash player</a>. More instructions for installation can be found here: <a onclick="_gaq.push(['_trackEvent', 'Outgoing', 'www.adobe.com', '/products/flashplayer/productinfo/instructions/']);" rel="nofollow" href="http://www.adobe.com/products/flashplayer/productinfo/instructions/">More information</a></p>            <p><a onclick="_gaq.push(['_trackEvent', 'Outgoing', 'www.adobe.com', '/go/getflashplayer']);" rel="nofollow" href="http://www.adobe.com/go/getflashplayer"><img src="http://%cdn%/%hotel%/%web_build%/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>If you are not automatically redirected, please <a href="/client/nojs">click here</a></p>            </div>        </noscript>    </div>    </div>    <div id="content" class="client-content"></div>            </div>    <div style="display: none">
<div id="habboCountUpdateTarget">%hotel_status%</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 && typeof window.opener.location.href != "undefined") {            window.opener.location.replace(window.opener.location.href);        }        $(document.body).addClassName("js");           HabboClient.startPingListener();    </script>
<script type="text/javascript">    HabboView.run();</script>
<script type="text/javascript">
  var _gaq = _gaq || [];  _gaq.push(['_setAccount', 'UA-15697942-2']);  _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>
</body> </html> 


---

---

I used this and everything was fine after ^^

how to fix this problem ?

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 17 in C:\xampp\htdocs\includes\class.core.php on line 191

Thanks Jonty, keep it up :}