Cant Access your own link!

C

Ceejay

Member
Aug 10, 2010
161
2
Well, this happened to me and my lovely friend swimo fixed it for me :).
heres the scenario If this is your problem this is the fix
You have installed your CMS ALl perfect, but when you go to localhost It comes up dodgey and images out of place, and then you go to ip and it doesnt load.. But others can get on.
Click to expand...

If so heres what to do
1) Find the following folders:
/client.php
/includes/core.php
/includes/data/holograph.php
Click to expand...

First we'l do the client;
Replace your WHOLE Client with this Code:
PHP: 
<?php
/*================================================================+\
|| # PHPRetro - An extendable virtual hotel site and management
|+==================================================================
|| # Copyright (C) 2009 Yifan Lu. All rights reserved.
|| # http://www.yifanlu.com
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved.
|| # http://www.meth0d.org
|| # All images, scripts, and layouts
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved.
|+==================================================================
|| # PHPRetro is provided "as is" and comes without
|| # warrenty of any kind. PHPRetro is free software!
|| # License: GNU Public License 3.0
|| # http://opensource.org/licenses/gpl-license.php
\+================================================================*/

require_once('./includes/core.php');
require_once('./includes/session.php');
$lang->addLocale("client.hotel");

$checkIfFlaggedQuery = mysql_query("SELECT * FROM users WHERE id = '".$user->id."'");
$checkIfFlagged = mysql_fetch_array($checkIfFlaggedQuery);
if($checkIfFlagged['flagged'] == 1){
  header("Location: ".PATH."/flag");
}

if(isset($_SESSION['reauthenticate']) && $_SESSION['reauthenticate'] == "true"){
    $_SESSION['page'] = $_SERVER["REQUEST_URI"];
    header("Location: ".PATH."/account/reauthenticate"); exit;
}else{
    $user = new HoloUser($user->name,$user->password,true);
    $_SESSION['user'] = $user;
}

if(isset($_GET['wide']) && $_GET['wide'] == "false"){
    $wide = false;
    $width = "720";
    $height = "540";
}else{
    $wide = true;
    $width = "960";
    $height = "540";
}

require_once('./templates/client_header.php');

$forwardid = $input->HoloText($_GET['forwardId']);
$roomid = $input->HoloText($_GET['roomId']);
$shortcut = $_GET['shortcut'];
switch($shortcut){
    case "roomomatic": $shortcut = "1"; break;
    default: unset($_GET['shortcut']); break;
}

if ($_SERVER['REMOTE_ADDR'] == "127.0.0.1" || $_SERVER['REMOTE_ADDR'] == "192.168.0.4" || $_SERVER['REMOTE_ADDR'] == "::1")
{
$hotelip = "127.0.0.1";
}
else
{
$hotelip = $settings->find("hotel_ip");
}
?>
<body id="client"<?php if($wide == true){ ?> class="wide"<?php } ?>>

<div id="client-topbar" style="display:none">

  <div class="logo"><img src="<?php echo PATH; ?>/web-gallery/images/popup/popup_topbar_habbologo.gif" alt="" align="middle"/></div>
  <div class="habbocount"><div id="habboCountUpdateTarget">
<?php echo GetOnlineCount()." ".$lang->loc['members.online']; ?>
</div>
    <script language="JavaScript" type="text/javascript">
        setTimeout(function() {
            HabboCounter.init(600);
        }, 20000);
    </script>
</div>
  <div class="logout"><a href="<?php echo PATH; ?>/account/logout?origin=popup" onclick="self.close(); return false;"><?php echo $lang->loc['close.hotel']; ?></a></div>
</div>
<noscript>
  <img src="<?php echo PATH; ?>/clientlog/nojs" border="0" width="1" height="1" alt="" style="position: absolute; top:0; left: 0"/>
</noscript>

<div id="clientembed-container">
<div id="clientembed-loader" class="loader-image" style="display:none">
    <div class="loader-image-inner">
        <b class="loading-text"><?php echo $lang->loc['loading']; ?>...</b>
    </div>
</div>
<div id="clientembed">
<script type="text/javascript" language="javascript">
try {
var _shockwaveDetectionSuccessful = true;
_shockwaveDetectionSuccessful = ShockwaveInstallation.swDetectionCheck();
if (!_shockwaveDetectionSuccessful) {
    log(50);
}
if (_shockwaveDetectionSuccessful) {
  ShockwaveInstallation.removeInstallationCookie();
  HabboClientUtils.cacheCheck();
}
} catch(e) {
    try {
        HabboClientUtils.logClientJavascriptError(e);
    } catch(e2) {}
}

    HabboClientUtils.extWrite("<object classid=\"clsid:166B1BCA-3F9C-11CF-8075-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/director/sw.cab#version=10,0,0,0\" id=\"habbo\" width=\"<?php echo $width; ?>\" height=\"<?php echo $height; ?>\"\>\n<param name=\"src\" value=\"<?php echo $settings->find("client_dcr"); ?>\"\>\n<param name=\"swRemote\" value=\"swSaveEnabled=\'true\' swVolume=\'true\' swRestart=\'false\' swPausePlay=\'false\' swFastForward=\'false\' swTitle=\'<?php echo FULLNAME; ?>\' swContextMenu=\'true\' \"\>\n<param name=\"swStretchStyle\" value=\"stage\"\>\n<param name=\"swstretchVAlign\" value=\"bottom\"\>\n<param name=\"swText\" value=\"\"\>\n<param name=\"bgColor\" value=\"#000000\"\>\n   <param name=\"sw7\" value=\"external.variables.txt=<?php echo $settings->find("client_external_variables"); ?>;external.texts.txt=<?php echo $settings->find("client_external_texts"); ?>\"\>\n   <param name=\"sw6\" value=\"client.connection.failed.url=<?php echo PATH; ?>/client_connection_failed;external.hash=null\"\>\n   <param name=\"sw5\" value=\"client.reload.url=<?php echo PATH; ?>/account/reauthenticate?page=/client;client.fatal.error.url=<?php echo PATH; ?>/client_error\"\>\n   <param name=\"sw4\" value=\"site.url=<?php echo PATH; ?>;url.prefix=<?php echo PATH; ?>\"\>\n   <param name=\"sw9\" value=\"<?php if(isset($_GET['shortcut'])){ ?>shortcut.id=<?php echo $shortcut; ?>;<?php } ?>account_id=<?php echo $user->id; ?>\"\>\n   <param name=\"sw8\" value=\"use.sso.ticket=1;sso.ticket=<?php echo $user->user("ticket_sso"); ?><?php if(isset($_GET['forwardId']) && isset($_GET['roomId'])){ ?>;forward.type=<?php echo $forwardid; ?>;forward.id=<?php echo $roomid; } ?>\"\>\n   <param name=\"sw2\" value=\"connection.info.host=<?php echo $hotelip; ?>;connection.info.port=<?php echo $settings->find("hotel_port"); ?>\"\>\n   <param name=\"sw3\" value=\"connection.mus.host=<?php echo $hotelip; ?>;connection.mus.port=<?php echo $settings->find("hotel_mus"); ?>\"\>\n   <param name=\"sw1\" value=\"client.allow.cross.domain=0;client.notify.cross.domain=1\"\>\n   <param name=\"playerVersion\" value=\"11\"\>\n<embed src=\"<?php echo $settings->find("client_dcr"); ?>\" bgColor=\"#000000\" width=\"<?php echo $width; ?>\" height=\"<?php echo $height; ?>\" swRemote=\"swSaveEnabled=\'true\' swVolume=\'true\' swRestart=\'false\' swPausePlay=\'false\' swFastForward=\'false\' swTitle=\'<?php echo FULLNAME; ?>\' swContextMenu=\'true\'\" swStretchStyle=\"stage\" swstretchVAlign=\"bottom\" swText=\"\" type=\"application/x-director\" pluginspage=\"http://www.macromedia.com/shockwave/download/\" \n    sw7=\"external.variables.txt=<?php echo $settings->find("client_external_variables"); ?>;external.texts.txt=<?php echo $settings->find("client_external_texts"); ?>\"  \n    sw6=\"client.connection.failed.url=<?php echo PATH; ?>/client_connection_failed;external.hash=null\"  \n    sw5=\"client.reload.url=<?php echo PATH; ?>/account/reauthenticate?page=/client;client.fatal.error.url=<?php echo PATH; ?>/client_error\"  \n    sw4=\"site.url=<?php echo PATH; ?>;url.prefix=<?php echo PATH; ?>\"  \n    sw9=\"<?php if(isset($_GET['shortcut'])){ ?>shortcut.id=<?php echo $shortcut; ?>;<?php } ?>account_id=<?php echo $user->id; ?>\"  \n    sw8=\"use.sso.ticket=1;sso.ticket=<?php echo $user->user("ticket_sso"); ?><?php if(isset($_GET['forwardId']) && isset($_GET['roomId'])){ ?>;forward.type=<?php echo $forwardid; ?>;forward.id=<?php echo $roomid; } ?>\"  \n    sw2=\"connection.info.host=<?php echo $hotelip; ?>;connection.info.port=<?php echo $settings->find("hotel_port"); ?>\"  \n    sw3=\"connection.mus.host=<?php echo $hotelip; ?>;connection.mus.port=<?php echo $settings->find("hotel_mus"); ?>\"  \n    sw1=\"client.allow.cross.domain=0;client.notify.cross.domain=1\"  \n    playerVersion=\"11\" \></embed\>\n<noembed\>You need the Shockwave plugin (free and safe to download) to enter <?php echo FULLNAME; ?>. <a href=\"http://www.adobe.com/shockwave/download/\" target=\"_new\"\>Download here</a\></noembed\>\n</object\>");
</script>

<noscript>
<object classid="clsid:166B1BCA-3F9C-11CF-8075-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/director/sw.cab#version=10,0,0,0" id="habbo" width="<?php echo $width; ?>" height="<?php echo $height; ?>">
<param name="src" value="<?php echo $settings->find("client_dcr"); ?>">
<param name="swRemote" value="swSaveEnabled='true' swVolume='true' swRestart='false' swPausePlay='flse' swFastForward='false' swTitle='<?php echo FULLNAME; ?>' swContextMenu='true' ">
<param name="swStretchStyle" value="stage">
<param name="swstretchVAlign" value="bottom">
<param name="swText" value="">
<param name="bgColor" value="#000000">
   <param name="sw7" value="external.variables.txt=<?php echo $settings->find("client_external_variables"); ?>;external.texts.txt=<?php echo $settings->find("client_external_texts"); ?>">
   <param name="sw6" value="client.connection.failed.url=<?php echo PATH; ?>/client_connection_failed;external.hash=null">
   <param name="sw5" value="client.reload.url=<?php echo PATH; ?>/account/reauthenticate?page=/client;client.fatal.error.url=<?php echo PATH; ?>/client_error">
   <param name="sw4" value="site.url=<?php echo PATH; ?>;url.prefix=<?php echo PATH; ?>">
   <param name="sw9" value="<?php if(isset($_GET['shortcut'])){ ?>shortcut.id=<?php echo $shortcut; ?>;<?php } ?>account_id=<?php echo $user->id; ?>">
   <param name="sw8" value="use.sso.ticket=1;sso.ticket=<?php echo $user->user("ticket_sso"); ?><?php if(isset($_GET['forwardId']) && isset($_GET['roomId'])){ ?>;forward.type=<?php echo $forwardid; ?>;forward.id=<?php echo $roomid; } ?>">
   <param name="sw2" value="connection.info.host=<?php echo $hotelip; ?>;connection.info.port=<?php echo $settings->find("hotel_port"); ?>">
   <param name="sw3" value="connection.mus.host=<?php echo $hotelip; ?>;connection.mus.port=<?php echo $settings->find("hotel_mus"); ?>">
   <param name="sw1" value="client.allow.cross.domain=0;client.notify.cross.domain=1">
   <param name="playerVersion" value="11">
<!--[if IE]><?php echo $lang->loc['need.shockwave'] ?> <a href="http://www.adobe.com/shockwave/download/" target="_new"><?php echo $lang->loc['download.here']; ?></a><![endif]-->
<embed src="<?php echo $settings->find("client_dcr"); ?>" bgColor="#000000" width="<?php echo $width; ?>" height="<?php echo $height; ?>" swRemote="swSaveEnabled='true' swVolume='true' swRestart='false' swPausePlay='false' swFastForward='false' swTitle='<?php echo FULLNAME; ?>' swContextMenu='true'" swStretchStyle="stage" swstretchVAlign="bottom" swText="" type="application/x-director" pluginspage="http://www.macromedia.com/shockwave/download/" 
    sw7="external.variables.txt=<?php echo $settings->find("client_external_variables"); ?>;external.texts.txt=<?php echo $settings->find("client_external_texts"); ?>"  
    sw6="client.connection.failed.url=<?php echo PATH; ?>/client_connection_failed;external.hash=null"  
    sw5="client.reload.url=<?php echo PATH; ?>/account/reauthenticate?page=/client;client.fatal.error.url=<?php echo PATH; ?>/client_error"  
    sw4="site.url=<?php echo PATH; ?>;url.prefix=<?php echo PATH; ?>"  
    sw9="<?php if(isset($_GET['shortcut'])){ ?>shortcut.id=<?php echo $shortcut; ?>;<?php } ?>account_id=<?php echo $user->id; ?>"  
    sw8="use.sso.ticket=1;sso.ticket=<?php echo $user->user("ticket_sso"); ?><?php if(isset($_GET['forwardId']) && isset($_GET['roomId'])){ ?>;forward.type=<?php echo $forwardid; ?>;forward.id=<?php echo $roomid; } ?>"  
    sw2="connection.info.host=<?php echo $hotelip; ?>;connection.info.port=<?php echo $settings->find("hotel_port"); ?>"  
    sw3="connection.mus.host=<?php echo $hotelip; ?>;connection.mus.port=<?php echo $settings->find("hotel_mus"); ?>"  
    sw1="client.allow.cross.domain=0;client.notify.cross.domain=1"  
    playerVersion="11" ></embed>
<noembed><?php echo $lang->loc['need.shockwave'] ?> <a href="http://www.adobe.com/shockwave/download/" target="_new"><?php echo $lang->loc['download.here']; ?></a></noembed>
</object>
</noscript>

</div>
<script type="text/javascript">
HabboClientUtils.loaderTimeout = 10 * 1000;
HabboClientUtils.showLoader(["<?php echo $lang->loc['loading']; ?>", "<?php echo $lang->loc['loading']; ?>.", "<?php echo $lang->loc['loading']; ?>..", "<?php echo $lang->loc['loading']; ?>..."]);
</script>
</div>
<?php require_once('./templates/client_footer.php');
Thats the client sorted...

Now, go to core.php (xampp\htdocs\includes)
And replace that with:
PHP: 
<?php
/*================================================================+\
|| # PHPRetro - An extendable virtual hotel site and management
|+==================================================================
|| # Copyright (C) 2009 Yifan Lu. All rights reserved.
|| # http://www.yifanlu.com
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved.
|| # http://www.meth0d.org
|| # All images, scripts, and layouts
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved.
|+==================================================================
|| # PHPRetro is provided "as is" and comes without
|| # warrenty of any kind. PHPRetro is free software!
|| # License: GNU Public License 3.0
|| # http://opensource.org/licenses/gpl-license.php
\+================================================================*/

define("IN_HOLOCMS", TRUE);

if(strpos($_SERVER['SERVER_SOFTWARE'],"Win") == false){ $page['dir'] = str_replace('\\','/',$page['dir']); }
chdir(str_replace($page['dir'], "", getcwd()));

if(@ini_get('date.timezone') == null && function_exists("date_default_timezone_get")){ @date_default_timezone_set("America/Los_Angeles"); }

if(strpos($page['dir'],'habblet') && (empty($_SERVER['HTTP_X_REQUESTED_WITH']) || $_SERVER['HTTP_X_REQUESTED_WITH'] != 'XMLHttpRequest') && $page['no_ajax'] != true){ header('Location: ../'); exit; }

if(!include_once('./includes/config.php')){ if(file_exists('./install/config.php')){ echo "<h1>Please move ./install/config.php to ./includes/config.php to continue.</h1>"; }elseif(file_exists('./install/index.php')){ header('Location: ./install/'); }else{ echo "<h1>Cannot find config.php in includes folder. Cannot find the install folder either. Did you copy all the files?"; } exit; }
define("PREFIX", $conn['main']['prefix']);
require_once('./includes/classes.php');
$db = new $conn['main']['server']($conn['main']);
if($conn['server']['enabled'] == true){ $serverdb = new $conn['server']['server']($conn['server']); }else{ $serverdb = $db; }
$settings = new HoloSettings;
$input = new HoloInput;
$lang = new HoloLocale;

session_start();

if ($_SERVER['REMOTE_ADDR'] == "172.0.0.1" || $_SERVER['REMOTE_ADDR'] == "192.168.0.4" || $_SERVER['REMOTE_ADDR'] == "::1")
{
define("PATH", "http://localhost");
}
else
{
define("PATH", $settings->find("site_path"));
}

define("SHORTNAME", $settings->find("site_shortname"));
                    define("FULLNAME", $settings->find("site_name"));
//define("DEBUG", true); //Uncomment this line to show detailed database error messages.

require('./includes/data/'.$settings->find("hotel_server").'.php');
$core = new core_sql;
require('./includes/functions.php');
require('./includes/version.php');

if($page['housekeeping'] != true){ if(is_object($_SESSION['user'])){ $user = $_SESSION['user']; }else{ $user = new HoloUser(null,null); } }else{ if(is_object($_SESSION['hk_user'])){ $user = $_SESSION['hk_user']; }else{ $user = new HoloUser(null,null); } }

if($user->error == 1 && $page['bypass_user_check'] != true && $_COOKIE['rememberme'] == "true" && $page['housekeeping'] != true){ $_SESSION['page'] = $_SERVER["REQUEST_URI"]; header("Location: ".PATH."/security_check_token"); }

if($settings->find("site_closed") == "1" && $page['id'] != "maintenance" && $page['housekeeping'] != true && $user->user("rank") < 5){
    header("Location: ".PATH."/maintenance"); exit;
}
?>
Now thats taht sorted

Now go to holograph.php ( In includes\data\)

And replace that with
PHP: 
<?php
/*
Name: Holograph
Description: Definition file for Holograph Emulator
Type: Server Definition
Author: Yifan Lu
Version: 1.0
Compatibility: 4.0.5
*/

//You may delete the installer_sql(); class after installing
class installer_sql {
    function alter1(){
        @$GLOBALS['serverdb']->query("ALTER TABLE `groups_details` CHANGE COLUMN `description` `description` text CHARACTER SET utf8 NOT NULL, CHANGE COLUMN `type` `type` tinyint(1) NOT NULL DEFAULT '0', ADD COLUMN `forumtype` tinyint(1) NOT NULL, ADD COLUMN `forumpremission` tinyint(1) NOT NULL, CHANGE COLUMN `views` `views` int(15) NOT NULL, ADD COLUMN `alias` varchar(30) NOT NULL, DROP PRIMARY KEY, ADD PRIMARY KEY (`id`, `alias`);");
        @$GLOBALS['serverdb']->query("ALTER TABLE `users` AUTO_INCREMENT=100");
        @$GLOBALS['serverdb']->query("ALTER TABLE `groups_details` AUTO_INCREMENT=100");
        @$GLOBALS['serverdb']->query("ALTER TABLE `users` ADD COLUMN `hc_before` tinyint(1) NULL DEFAULT '0'");
    }
    function delete1(){
        @$GLOBALS['serverdb']->query("TRUNCATE TABLE users");
    }
    function insert1($username,$password){
        $GLOBALS['serverdb']->query("INSERT INTO users (name,password,rank,email,birth,hbirth,figure,sex,mission,credits) VALUES ('".$username."','".$password."','7','".$email."','1-1-1900','".date('d-m-Y')."','hd-180-1.ch-210-66.lg-270-82.sh-290-80.hr-105-42','M','Hotel Administrator','1000')");
    }
    function insert2($id,$username,$email){
        $GLOBALS['serverdb']->query("INSERT INTO ".PREFIX."users (id,name,ipaddress_last,lastvisit,online,newsletter,email_verified,show_home,email_friendrequest,email_minimail,show_online,email) VALUES ('".$id."','".$username."','".$_SERVER['REMOTE_ADDR']."','".time()."','".time()."','1','1','1','1','1','1','".$email."')");
    }
    function select1(){
        $sql = $GLOBALS['serverdb']->query("SELECT 'passed' AS `test` FROM system LIMIT 1 #Test query to see if a valid Holograph database exists. If you are seeing this, read the red text below.");
        return $sql;
    }
}
class core_sql {
    function select1($id){
        if(is_numeric($id)){ $sql = $GLOBALS['serverdb']->query("SELECT password,name FROM users WHERE id = '".$id."' LIMIT 1"); }else{ $sql = $GLOBALS['serverdb']->query("SELECT password,id FROM users WHERE name = '".$id."' LIMIT 1"); }
        return $sql;
    }
    function select2($id){
        $sql = $GLOBALS['serverdb']->query("SELECT descr,date_expire FROM users_bans WHERE userid = '".$id."' OR ipaddress = '".$_SERVER['REMOTE_ADDR']."' LIMIT 1");
        return $sql;
    }
    function delete1($id){
        $GLOBALS['serverdb']->query("DELETE FROM users_bans WHERE userid = '".$id."' OR ipaddress = '".$_SERVER['REMOTE_ADDR']."' LIMIT 1");
    }
    function select3($id) {
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,password,rank,'null' AS email,birth,figure,sex,mission,credits,tickets,ticket_sso,0 AS pixels,hbirth FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select4($strName){
        if(is_numeric($strName)){
            $sql = $GLOBALS['serverdb']->query("SELECT id FROM users WHERE id = '".$strName."' AND badge_status = '1' LIMIT 1");
        } else {
            $sql = $GLOBALS['serverdb']->query("SELECT id FROM users WHERE name = '".$strName."' AND badge_status = '1' LIMIT 1");
        }
        return $sql;
    }
    function select5($id){
        $sql = $GLOBALS['serverdb']->query("SELECT badgeid,iscurrent FROM users_badges WHERE userid = '".$id."' AND iscurrent = '1' LIMIT 1");
        return $sql;
    }
    function select6($id){
        $sql = $GLOBALS['serverdb']->query("SELECT groupid FROM groups_memberships WHERE userid = '".$id."' AND is_current = '1' LIMIT 1");
        return $sql;
    }
    function select7($id){
        $sql = $GLOBALS['serverdb']->query("SELECT badge FROM groups_details WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select8($id){
        $sql = $GLOBALS['serverdb']->query("SELECT months_left,date_monthstarted FROM users_club WHERE userid = '".$id."' LIMIT 1");
        return $sql;
    }
    function select9($id){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM users_club WHERE userid = '".$id."' LIMIT 1");
        return $sql;
    }
    function update2($id){
        $GLOBALS['serverdb']->query("UPDATE users SET badge_status = '0', hc_before = '1' WHERE id = '".$id."' LIMIT 1");
        $GLOBALS['serverdb']->query("UPDATE users SET rank = '1' WHERE id = '".$id."' AND rank = '2' LIMIT 1");
        $GLOBALS['serverdb']->query("DELETE FROM users_badges WHERE badgeid = 'HC1' OR badgeid = 'HC2' AND userid = '".$id."'");
        $GLOBALS['serverdb']->query("DELETE FROM users_club WHERE userid = '".$id."'");
    }
    function update3($id, $months){
        $GLOBALS['serverdb']->query("UPDATE users SET rank = '2' WHERE rank = '1' AND id = '".$id."' LIMIT 1");
        $GLOBALS['serverdb']->query("UPDATE users_club SET months_left = months_left + ".$months." WHERE userid = '".$id."' LIMIT 1");
    }
    function select11($id){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM users_badges WHERE (badgeid = 'HC1' OR badgeid = 'HC2') AND userid = '".$id."' LIMIT 1");
        return $sql;
    }
    function update4($id){
        $GLOBALS['serverdb']->query("UPDATE users SET badge_status = '0' WHERE id = '".$id."' LIMIT 1");
        $GLOBALS['serverdb']->query("UPDATE users_badges SET iscurrent = '0' WHERE userid = '".$id."'");
        $GLOBALS['serverdb']->query("INSERT INTO users_badges (userid,badgeid,iscurrent) VALUES ('".$id."','HC1','1')");
    }
    function insert1($id, $date){
        $GLOBALS['serverdb']->query("INSERT INTO users_club (userid,date_monthstarted,months_expired,months_left) VALUES ('".$id."','".$date."','0','0')");
    }
    function update5($ticket, $id){
        $GLOBALS['serverdb']->query("UPDATE users SET ticket_sso = '".$ticket."' WHERE id = '".$id."' LIMIT 1");
    }
    function select14(){
        $sql = $GLOBALS['serverdb']->query("SELECT onlinecount FROM system LIMIT 1");
        return $sql;
    }
    function update6($id,$time){
    if ($_SERVER['REMOTE_ADDR'] == "::1")
    {
    $_SERVER['REMOTE_ADDR'] = "127.0.0.1";
    }
        $GLOBALS['serverdb']->query("UPDATE users SET lastvisit = '".$time."', ipaddress_last = '".$_SERVER['REMOTE_ADDR']."' WHERE id = '".$id."' LIMIT 1");
    }
}
class index_sql {
    function select1($username, $password){
        $sql = $GLOBALS['serverdb']->query("SELECT users.id FROM users,".PREFIX."users WHERE ".PREFIX."users.id = users.id AND users.name = '".$username."' AND users.password = '".$password."' LIMIT 1");
        return $sql;
    }
    function select2($id){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM ".PREFIX."users WHERE id = '".$id."' AND email_verified = '1'");
        return $sql;
    }
    function select3($id){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM users_bans WHERE userid = '".$id."'");
        return $sql;
    }
}
class forgot_sql {
    function update1($id, $password){
        $GLOBALS['serverdb']->query("UPDATE users SET password = '".$password."' WHERE id = '".$id."'");
    }
}
class register_sql {
    function select1($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,figure FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select2($name){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM users WHERE name = '".$name."'");
        return $sql;
    }
    function insert1($name,$password,$dob,$figure,$gender,$scredits){
        $date = HoloDate();
        $GLOBALS['serverdb']->query("INSERT INTO users (name,password,birth,figure,sex,rank,hbirth,tickets,credits) VALUES ('".$name."','".$password."','".$dob."','".$figure."','".$gender."','1','".$date['date_normal']."','0','".$scredits."')");
    }
    function update1($id,$credits){
        $GLOBALS['serverdb']->query("UPDATE users SET credits = credits + ".$credits." WHERE id = '".$id."'");
    }
    function insert2($userid,$friendid){
        $GLOBALS['serverdb']->query("INSERT INTO messenger_friendships (userid,friendid) VALUES ('".$userid."','".$friendid."')");
    }
    function select3($name){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name FROM users WHERE name = '".$name."' LIMIT 1");
        return $sql;
    }
}
class welcome_sql {
    function select1($id){
        $sql = $GLOBALS['serverdb']->query("SELECT name,figure FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
}
class me_sql {
    function select1($id){
        $sql = $GLOBALS['serverdb']->query("SELECT hc_before FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select3($id){
        $sql = $GLOBALS['serverdb']->query("SELECT userid_from FROM messenger_friendrequests WHERE userid_to = '".$id."'");
        return $sql;
    }
    function select4($cutoff, $id){
        $sql = $GLOBALS['serverdb']->query("SELECT DISTINCT ".PREFIX."users.name FROM ".PREFIX."users,messenger_friendships WHERE ".PREFIX."users.online > '".$cutoff."' AND (messenger_friendships.userid = '".$id."' OR messenger_friendships.friendid = '".$id."') AND messenger_friendships.userid = ".PREFIX."users.id AND ".PREFIX."users.id != '".$id."'");
        return $sql;
    }
    function select8($name){
        $sql = $GLOBALS['serverdb']->query("SELECT users.name,users.figure,users.id,".PREFIX."users.lastvisit FROM users,".PREFIX."users WHERE users.name LIKE '%".$name."%' AND users.id = ".PREFIX."users.id ORDER BY name ASC");
        return $sql;
    }
    function select9($name, $limit, $offset){
        $sql = $GLOBALS['serverdb']->query("SELECT users.name,users.figure,users.id,".PREFIX."users.lastvisit FROM users,".PREFIX."users WHERE users.name LIKE '%".$name."%' AND users.id = ".PREFIX."users.id ORDER BY name ASC LIMIT ".$limit." OFFSET ".$offset);
        return $sql;
    }
    function select10($id, $id2){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM messenger_friendships WHERE (userid = '".$id."' AND friendid = '".$id2."') OR (userid = '".$id2."' AND friendid = '".$id."')");
        return $sql;
    }
    function select11($id, $id2){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM messenger_friendrequests WHERE (userid_from = '".$id."' AND userid_to = '".$id2."') OR (userid_from = '".$id2."' AND userid_to = '".$id."')");
        return $sql;
    }
    function select12($id){
        $sql = $GLOBALS['serverdb']->query("SELECT MAX(requestid) FROM messenger_friendrequests WHERE userid_to = '".$id."'");
        return $sql;
    }
    function insert1($id, $id2, $requestid){
        $GLOBALS['serverdb']->query("INSERT INTO messenger_friendrequests (userid_from,userid_to,requestid) VALUES ('".$id."','".$id2."','".$requestid."')");
    }
    function select13($roomid){
        $sql = $GLOBALS['serverdb']->query("SELECT rooms.visitors_now,rooms.visitors_max,users.name FROM rooms,users WHERE rooms.id = '".$roomid."' AND rooms.owner = users.name LIMIT 1");
        return $sql;
    }
    function select14($id){
        $sql = $GLOBALS['serverdb']->query("SELECT groups_memberships.groupid,groups_details.name FROM groups_memberships,groups_details WHERE groups_memberships.userid = '".$id."' AND groups_memberships.is_pending = '0' AND groups_memberships.groupid = groups_details.id");
        return $sql;
    }
    function select16(){
        $sql = $GLOBALS['serverdb']->query("SELECT rooms.id,rooms.name,rooms.description,rooms.owner,rooms.visitors_now,rooms.visitors_max,rooms.showname FROM ".PREFIX."recommended,rooms WHERE ".PREFIX."recommended.type = 'room' AND ".PREFIX."recommended.rec_id = rooms.id ORDER BY ".PREFIX."recommended.id ASC");
        return $sql;
    }
    function select17($limit = 0,$offset = 0){
        $sql = "SELECT groups_details.id,groups_details.name,groups_details.badge,COUNT(*) AS count FROM groups_details,groups_memberships WHERE groups_details.id = groups_memberships.groupid AND is_pending = '0' GROUP BY groups_memberships.groupid ORDER BY count DESC";
        if($limit > 0){ $sql = $sql." LIMIT ".$limit; }
        if($offset > 0){ $sql = $sql." OFFSET ".$offset; }
        $sql = $GLOBALS['serverdb']->query($sql);
        return $sql;
    }
    function select18($id){
        $sql = $GLOBALS['serverdb']->query("SELECT groups_details.id,groups_details.name,groups_details.badge FROM groups_details,groups_memberships WHERE groups_details.id = groups_memberships.groupid AND groups_memberships.is_pending = '0' AND groups_memberships.userid = '".$id."' ORDER BY groups_details.id ASC");
        return $sql;
    }
    function update1($id, $motto){
        $GLOBALS['serverdb']->query("UPDATE users SET mission = '".$motto."' WHERE id = '".$id."' LIMIT 1");
    }
    function select5($id){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM messenger_friendships WHERE userid = '".$id."' OR friendid = '".$id."'");
        return $sql;
    }
    function select6($id){
        $sql = $GLOBALS['serverdb']->query("SELECT name,id,figure FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select7($id){
        $sql = $GLOBALS['serverdb']->query("SELECT userid,friendid FROM messenger_friendships WHERE userid = '".$id."' OR friendid = '".$id."'");
        return $sql;
    }
    function select15($sponsered){
        $sql = $GLOBALS['serverdb']->query("SELECT groups_details.id,groups_details.name,groups_details.badge,groups_details.roomid FROM ".PREFIX."recommended,groups_details WHERE ".PREFIX."recommended.type = 'group' AND ".PREFIX."recommended.rec_id = groups_details.id AND ".PREFIX."recommended.sponsered = '".$sponsered."' ORDER BY ".PREFIX."recommended.id ASC");
        return $sql;
    }
    function delete1($id, $id2){
        $GLOBALS['serverdb']->query("DELETE FROM messenger_friendships WHERE userid = '".$id."' AND friendid = '".$id2."' LIMIT 1");
    }
    // To enable events, follow the instructions provided and delete the function below and replace it with the commented function select19
    function select19($category){
        $sql = $GLOBALS['serverdb']->query("SELECT id FROM rooms WHERE id = '0'");
        return $sql;
    }
    /*
    function select19($category){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,description,userid,roomid,category,date FROM events WHERE category = '".$category."'");
        return $sql;
    }
    */
}
class header_footer_sql {
    function select1($mode, $id, $name, $timeout = 0){
        switch($mode){
            case 1:
                if($timeout != null){
                    if($timeout > 0){
                        $online = " AND ((".PREFIX."users.online + ".$timeout.") >= ".time().")";
                    }else{
                        $timeout = (int) str_replace("-","",$timeout);
                        $online = " AND ((".PREFIX."users.online + ".$timeout.") <= ".time().")";
                    }
                }
                $sql = $GLOBALS['serverdb']->query("SELECT users.id,users.name FROM messenger_friendships,users,".PREFIX."users WHERE (messenger_friendships.userid = '".$id."' AND users.id = messenger_friendships.friendid AND users.id = ".PREFIX."users.id) OR (messenger_friendships.friendid = '".$id."' AND users.id = messenger_friendships.userid AND users.id = ".PREFIX."users.id)".$online." ORDER BY users.id ASC");
                break;
            case 2:
                $sql = $GLOBALS['serverdb']->query("SELECT groups_details.id,groups_details.name,groups_memberships.is_current,groups_memberships.member_rank,groups_details.ownerid,groups_details.roomid FROM groups_memberships,groups_details WHERE groups_memberships.userid = '".$id."' AND groups_memberships.is_pending = '0' AND groups_memberships.groupid = groups_details.id ORDER BY groups_memberships.member_rank ASC");
                break;
            case 3:
                $sql = $GLOBALS['serverdb']->query("SELECT id,name FROM rooms WHERE owner  = '".$name."' ORDER BY name ASC");
                break;
            case 4:
                $sql = $GLOBALS['serverdb']->query("SELECT users.id,users.name FROM messenger_friendships,users,".PREFIX."users WHERE (messenger_friendships.userid = '".$id."' AND users.id = messenger_friendships.friendid = ".PREFIX."users.id) OR (messenger_friendships.friendid = '".$id."' AND users.id = messenger_friendships.userid = ".PREFIX."users.id) AND ((".PREFIX."users.online + ".$timeout.") < ".time().") ORDER BY users.id ASC");
                break;
        }
        return $sql;
    }
}
class group_purchase_sql {
    function select1($name){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM groups_details WHERE name = '".$name."' LIMIT 1");
        return $sql;
    }
    function insert1($name, $desc, $id, $date){
        $GLOBALS['serverdb']->query("INSERT INTO groups_details (name,description,ownerid,created,badge,type,forumtype,forumpremission,alias) VALUES ('".$name."','".$desc."','".$id."','".$date."','b0503Xs09114s05013s05015','0','0','0','')");
    }
    function select2($ownerid,$name){
        $sql = $GLOBALS['serverdb']->query("SELECT id FROM groups_details WHERE ownerid = '".$ownerid."' AND name = '".$name."' ORDER BY id DESC LIMIT 1");
        return $sql;
    }
    function insert2($userid, $groupid){
        $GLOBALS['serverdb']->query("INSERT INTO groups_memberships (userid,groupid,member_rank,is_current) VALUES ('".$userid."','".$groupid."','3','0')");
        $GLOBALS['serverdb']->query("UPDATE users SET credits = credits - 10 WHERE id = '".$userid."' LIMIT 1");
    }
}
class xml_sql {
    function select1(){
        $sql = $GLOBALS['serverdb']->query("SELECT users.id,users.name,users.mission,users.figure,users.sex FROM users,".PREFIX."users WHERE users.id = ".PREFIX."users.id ORDER BY ".PREFIX."users.online DESC LIMIT 10");
        return $sql;
    }
}
class profile_sql {
    function update1($figure,$gender,$id){
        $GLOBALS['serverdb']->query("UPDATE users SET figure = '".$figure."', sex = '".$gender."' WHERE id = '".$id."' LIMIT 1");
    }
    function update2($motto,$id){
        $GLOBALS['serverdb']->query("UPDATE users SET mission = '".$motto."' WHERE id = '".$id."' LIMIT 1");
    }
    function update4($password,$id){
        $GLOBALS['serverdb']->query("UPDATE users SET password = '".$password."' WHERE id = '".$id."'");
    }
    function select1($id,$search = "",$limit = "",$offset = "0"){
        if($search == ""){
            $sql = "SELECT messenger_friendships.userid,messenger_friendships.friendid,users.id,users.name,".PREFIX."users.lastvisit FROM messenger_friendships,users,".PREFIX."users WHERE (messenger_friendships.userid = '".$id."' AND (messenger_friendships.friendid = users.id AND users.id = ".PREFIX."users.id)) OR (messenger_friendships.friendid = '".$id."' AND (messenger_friendships.userid = users.id AND users.id = ".PREFIX."users.id))";
        }else{
            $sql = "SELECT messenger_friendships.userid,messenger_friendships.friendid,users.id,users.name,".PREFIX."users.lastvisit FROM messenger_friendships,users,".PREFIX."users WHERE ((messenger_friendships.userid = '".$id."' AND (messenger_friendships.friendid = users.id AND users.id = ".PREFIX."users.id)) OR (messenger_friendships.friendid = '".$id."' AND (messenger_friendships.userid = users.id AND users.id = ".PREFIX."users.id))) AND users.name LIKE '%".$search."%'";
        }
        if($limit != ""){ $sql = $sql." LIMIT ".$limit." OFFSET ".$offset.""; }
        $sql = $GLOBALS['serverdb']->query($sql);
        return $sql;
    }
    function delete1($id,$myid){
        $sql = $GLOBALS['serverdb']->query("DELETE FROM messenger_friendships WHERE (userid = '".$myid."' AND friendid = '".$id."') OR (friendid = '".$myid."' AND userid = '".$id."') LIMIT 1");
    }
}
class community_sql {
    function select1($limit,$offset){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,description,owner,visitors_now,visitors_max,showname FROM rooms WHERE owner IS NOT NULL ORDER BY visitors_now DESC LIMIT ".$limit." OFFSET ".$offset);
        return $sql;
    }
    function select2($limit,$offset){
        $sql = $GLOBALS['serverdb']->query("SELECT rooms.id,rooms.name,rooms.description,rooms.owner,rooms.visitors_now,rooms.visitors_max,rooms.showname,COUNT(room_votes.vote) AS votes FROM rooms,room_votes WHERE rooms.owner IS NOT NULL AND room_votes.roomid = rooms.id GROUP BY rooms.id ORDER BY votes DESC LIMIT ".$limit." OFFSET ".$offset);
        return $sql;
    }
    function select3(){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,hbirth,mission,figure FROM users ORDER BY RAND() LIMIT 18");
        return $sql;
    }
    function select4($name){
        $sql = $GLOBALS['serverdb']->query("SELECT id FROM users WHERE name = '".$name."' LIMIT 1");
        return $sql;
    }
    function select5($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,mission,figure FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select6($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,description,badge FROM groups_details WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
}
class credits_sql {
    function update1($id,$credits){
        $GLOBALS['serverdb']->query("UPDATE users SET credits = '".$credits."' WHERE id = '".$id."' LIMIT 1");
    }
    function insert1($id,$furni){
        $GLOBALS['serverdb']->query("INSERT INTO furniture (tid,ownerid,roomid,x,y,z,h) VALUES ('".$furni."','".$id."','0','0','0','0','0')");
    }
    function select1($month){
        $sql = $GLOBALS['serverdb']->query("SELECT catalogue_items.catalogue_name,".PREFIX."gifts.image FROM catalogue_items,".PREFIX."gifts WHERE ".PREFIX."gifts.furni_id = catalogue_items.tid AND ".PREFIX."gifts.type = 'club' AND ".PREFIX."gifts.month = '".$month."' LIMIT 1");
        return $sql;
    }
    function select2($id){
        $sql = $GLOBALS['serverdb']->query("SELECT months_left FROM users_club WHERE userid = '".$id."' LIMIT 1");
        return $sql;
    }
    function update2($figure,$gender,$id){
        $GLOBALS['serverdb']->query("UPDATE users SET figure = '".$figure."', sex = '".$gender."' WHERE id = '".$id."' LIMIT 1");
    }
    function select3($date){
        $sql = $GLOBALS['serverdb']->query("SELECT catalogue_items.catalogue_name,catalogue_items.catalogue_description,".PREFIX."collectables.image_large,catalogue_items.tid FROM catalogue_items,".PREFIX."collectables WHERE ".PREFIX."collectables.furni_id = catalogue_items.tid AND ".PREFIX."collectables.date = '".$date."' LIMIT 1");
        return $sql;
    }
    function select4($date){
        $sql = $GLOBALS['serverdb']->query("SELECT catalogue_items.catalogue_name,catalogue_items.catalogue_description,".PREFIX."collectables.image_small,".PREFIX."collectables.date FROM catalogue_items,".PREFIX."collectables WHERE ".PREFIX."collectables.furni_id = catalogue_items.tid AND ".PREFIX."collectables.date < '".$date."' ORDER BY ".PREFIX."collectables.date DESC");
        return $sql;
    }
    function select5($voucher){
        $sql = $GLOBALS['serverdb']->query("SELECT type,credits FROM vouchers WHERE voucher = '".$voucher."' LIMIT 1");
        return $sql;
    }
    function delete1($voucher){
        $GLOBALS['serverdb']->query("DELETE FROM vouchers WHERE voucher = '".$voucher."' LIMIT 1");
    }
}
class home_sql {
    function select1($name){
        $sql = $GLOBALS['serverdb']->query("SELECT id FROM users WHERE name = '".$name."' LIMIT 1");
        return $sql;
    }
    function select2($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,rank,hbirth,figure,mission,badge_status FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function update1($id,$credits){
        $GLOBALS['serverdb']->query("UPDATE users SET credits = '".$credits."' WHERE id = '".$id."' LIMIT 1");
    }
    function select3($query,$scope){
        switch($scope){
            case 1: $sql = $GLOBALS['serverdb']->query("SELECT id,name FROM users WHERE name LIKE '%".$query."%' LIMIT 5"); break;
            case 2: $sql = $GLOBALS['serverdb']->query("SELECT id,name FROM rooms WHERE name LIKE '%".$query."%' LIMIT 5"); break;
            case 3: $sql = $GLOBALS['serverdb']->query("SELECT id,name FROM groups_details WHERE name LIKE '%".$query."%' OR alias LIKE '%".$query."%' LIMIT 5"); break;
        }
        return $sql;
    }
    function select4($myid,$friendid){
        $sql = $GLOBALS['serverdb']->query("SELECT userid,friendid FROM messenger_friendships WHERE (userid = '".$myid."' AND friendid = '".$friendid."') OR (userid = '".$friendid."' AND friendid = '".$myid."')");
        return $sql;
    }
    function select5($myid,$friendid){
        $sql = $GLOBALS['serverdb']->query("SELECT userid_from,userid_to FROM messenger_friendrequests WHERE (userid_from = '".$myid."' AND userid_to = '".$friendid."') OR (userid_from = '".$friendid."' AND userid_to = '".$myid."')");
        return $sql;
    }
    function insert1($myid,$friendid){
        $GLOBALS['serverdb']->query("INSERT INTO messenger_friendrequests (userid_from,userid_to) VALUES ('".$myid."','".$friendid."')");
    }
    function select6($id){
        $sql = $GLOBALS['serverdb']->query("SELECT bb_totalpoints,bb_playedgames FROM users WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select7($id){
        $sql = $GLOBALS['serverdb']->query("SELECT badgeid FROM users_badges WHERE userid = '".$id."'");
        return $sql;
    }
    function select8($id,$search="",$limit=0,$offset=0){
        $sql = "SELECT users.id,users.name,users.figure,users.hbirth FROM users,messenger_friendships WHERE (userid = '".$id."' AND messenger_friendships.friendid = users.id) OR (friendid = '".$id."' AND messenger_friendships.userid = users.id)";
        if($search != ""){ $sql = $sql." AND users.name LIKE '%".$search."%'"; }
        if($limit > 0){ $sql = $sql." LIMIT ".$limit; }
        if($offset > 0){ $sql = $sql." OFFSET ".$offset; }
        $sql = $GLOBALS['serverdb']->query($sql);
        return $sql;
    }
    function select9($id){
        $sql = $GLOBALS['serverdb']->query("SELECT badgeid FROM users_badges WHERE userid = '".$id."' AND iscurrent = '1' LIMIT 1");
        return $sql;
    }
    function select10($id){
        $sql = $GLOBALS['serverdb']->query("SELECT groups_details.id,groups_details.badge,groups_details.name,groups_details.description,groups_details.created,groups_details.type,groups_memberships.member_rank,groups_memberships.is_current,groups_details.ownerid FROM groups_memberships,groups_details WHERE groups_memberships.groupid = groups_details.id AND groups_memberships.userid = '".$id."' AND groups_memberships.is_current = '1' LIMIT 1");
        return $sql;
    }
    function select11($id){
        $sql = $GLOBALS['serverdb']->query("SELECT rooms.id,rooms.name,rooms.description,rooms.state FROM rooms,users WHERE users.name = rooms.owner AND users.id = '".$id."'");
        return $sql;
    }
    function select12($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,title FROM soundmachine_songs WHERE userid = '".$id."'");
        return $sql;
    }
    function select13($id){
        $sql = $GLOBALS['serverdb']->query("SELECT data,title,userid FROM soundmachine_songs WHERE id = '".$id."'");
        return $sql;
    }
    function select14($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,badge,name,description,created,type,ownerid,roomid,forumtype,forumpremission,alias FROM groups_details WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function select15($userid,$groupid){
        $sql = $GLOBALS['serverdb']->query("SELECT userid,groupid,member_rank,is_current,is_pending FROM groups_memberships WHERE userid = '".$userid."' AND groupid = '".$groupid."' LIMIT 1");
        return $sql;
    }
    function update2($userid,$groupid,$favorite){
        $GLOBALS['serverdb']->query("UPDATE groups_memberships SET is_current = '0' WHERE userid = '".$userid."' LIMIT 1");
        $GLOBALS['serverdb']->query("UPDATE groups_memberships SET is_current = '".$favorite."' WHERE groupid = '".$groupid."' AND userid = '".$userid."' AND is_pending = '0' LIMIT 1");
    }
    function insert2($userid,$groupid,$pending,$rank){
        $GLOBALS['serverdb']->query("INSERT INTO groups_memberships (userid,groupid,member_rank,is_current,is_pending) VALUES ('".$userid."','".$groupid."','".$rank."','0','".$pending."')");
    }
    function delete1($userid,$groupid){
        $GLOBALS['serverdb']->query("DELETE FROM groups_memberships WHERE userid = '".$userid."' AND groupid = '".$groupid."' LIMIT 1");
    }
    function select16($id,$search="",$limit=0,$offset=0,$pending=0){
        $sql = "SELECT groups_memberships.userid,groups_memberships.member_rank,groups_memberships.is_current,groups_memberships.is_pending,users.name,users.figure,users.hbirth FROM groups_memberships,users WHERE users.id = groups_memberships.userid AND groups_memberships.groupid = '".$id."' AND groups_memberships.is_pending = '".$pending."'";
        if($search != ""){ $sql .= " AND users.name LIKE '%".$search."%'"; }
        $sql .= " ORDER BY groups_memberships.member_rank ASC";
        if($limit > 0){ $sql .= " LIMIT ".$limit; }
        if($offset > 0){ $sql .= " OFFSET ".$offset; }
        $sql = $GLOBALS['serverdb']->query($sql);
        return $sql;
    }
    function select17($id){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,description FROM rooms WHERE id = '".$id."' LIMIT 1");
        return $sql;
    }
    function update3($id,$name,$description,$type,$url,$forumtype,$forumpremissions,$roomid){
        $GLOBALS['serverdb']->query("UPDATE groups_details SET name = '".$name."', description = '".$description."', type = '".$type."', alias = '".$url."', forumtype = '".$forumtype."', forumpremission = '".$forumpremissions."', roomid = '".$roomid."' WHERE id = '".$id."' LIMIT 1");
    }
    function select18($alias){
        $sql = $GLOBALS['serverdb']->query("SELECT id FROM groups_details WHERE alias = '".$alias."' LIMIT 1");
        return $sql;
    }
    function update4($userid,$groupid,$rank,$pending){
        $GLOBALS['serverdb']->query("UPDATE groups_memberships SET member_rank = '".$rank."', is_pending = '".$pending."' WHERE userid = '".$userid."' AND groupid = '".$groupid."' LIMIT 1");
    }
    function update5($id,$badge){
        $GLOBALS['serverdb']->query("UPDATE groups_details SET badge = '".$badge."' WHERE id = '".$id."' LIMIT 1");
    }
    function delete2($groupid){
        $GLOBALS['serverdb']->query("DELETE FROM groups_details WHERE id = '".$groupid."' LIMIT 1");
        $GLOBALS['serverdb']->query("DELETE FROM groups_memberships WHERE groupid = '".$groupid."'");
    }
}
class housekeeping_sql {
    function select1(){
        $sql = $GLOBALS['serverdb']->query("SELECT COUNT(*) FROM furniture UNION SELECT COUNT(*) FROM groups_details UNION SELECT COUNT(*) FROM rooms UNION SELECT COUNT(*) FROM users UNION SELECT COUNT(*) FROM users_bans");
        return $sql;
    }
    function select2(){
        $sql = $GLOBALS['serverdb']->query("SELECT onlinecount FROM system UNION SELECT activerooms FROM system");
        return $sql;
    }
    function select3($rank){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name,rank FROM users WHERE rank >= '".$rank."' ORDER BY rank DESC, name ASC");
        return $sql;
    }
    function select4($limit,$offset,$roomid=null){
        if(!empty($roomid)){ $where = " WHERE roomid = '".$roomid."'"; }
        $sql = $GLOBALS['serverdb']->query("SELECT username,roomid,mtime,message FROM system_chatlog".$where." ORDER BY mtime DESC LIMIT ".$limit." OFFSET ".$offset);
        return $sql;
    }
    function select5(){
        $sql = $GLOBALS['serverdb']->query("SELECT ".PREFIX."collectables.id,".PREFIX."collectables.image_small,".PREFIX."collectables.image_large,".PREFIX."collectables.date,catalogue_items.catalogue_name,".PREFIX."collectables.furni_id FROM ".PREFIX."collectables,catalogue_items WHERE ".PREFIX."collectables.furni_id = catalogue_items.tid ORDER BY ".PREFIX."collectables.date DESC");
        return $sql;
    }
    function select6($query){
        $sql = $GLOBALS['serverdb']->query("SELECT tid,catalogue_name FROM catalogue_items WHERE catalogue_name LIKE '%".$query."%' OR catalogue_description LIKE '%".$query."%' OR name_cct LIKE '%".$query."%' LIMIT 50");
        return $sql;
    }
    function select7($query){
        $sql = $GLOBALS['serverdb']->query("SELECT id,name FROM rooms WHERE name LIKE '%".$query."%' OR description LIKE '%".$query."%' OR owner LIKE '%".$query."%' LIMIT 50");
        return $sql;
    }
    function select8($alias){
        $sql = $GLOBALS['serverdb']->query("SELECT id FROM groups_details WHERE alias = '".$alias."' LIMIT 1");
        return $sql;
    }
    function select9(){
        $sql = $GLOBALS['serverdb']->query("SELECT voucher,type,credits FROM vouchers");
        return $sql;
    }
    function select10($voucher){
        $sql = $GLOBALS['serverdb']->query("SELECT voucher,type,credits FROM vouchers WHERE voucher = '".$voucher."' LIMIT 1");
        return $sql;
    }
    function update1($id,$voucher,$type,$value){
        $sql = $GLOBALS['serverdb']->query("UPDATE vouchers SET voucher = '".$voucher."', type = '".$type."', credits = '".$value."' WHERE voucher = '".$id."' LIMIT 1");
    }
    function insert1($voucher,$type,$value){
        $sql = $GLOBALS['serverdb']->query("INSERT INTO vouchers (voucher,type,credits) VALUES ('".$voucher."','".$type."','".$value."')");
    }
    function delete1($id){
        $sql = $GLOBALS['serverdb']->query("DELETE FROM vouchers WHERE voucher = '".$id."' LIMIT 1");
    }
    function select11($id){
        $sql = $GLOBALS['serverdb']->query("SELECT userid,badgeid,iscurrent FROM users_badges WHERE userid = '".$id."'");
        return $sql;
    }
    function select12($id){
        $sql = $GLOBALS['serverdb']->query("SELECT userid,ipaddress,date_expire,descr FROM users_bans WHERE userid = '".$id."' LIMIT 1");
        return $sql;
    }
    function update2($id,$rank,$motto,$credits,$birth,$email){
        $GLOBALS['serverdb']->query("UPDATE users SET rank = '".$rank."', mission = '".$motto."', credits = '".$credits."', birth = '".$birth."' WHERE id = '".$id."' LIMIT 1");
        $GLOBALS['serverdb']->query("UPDATE ".PREFIX."users SET email = '".$email."' WHERE id = '".$id."' LIMIT 1");
    }
    function insert2($id,$badge){
        $GLOBALS['serverdb']->query("UPDATE users_badges SET iscurrent = '0' WHERE userid = '".$id."'");
        $GLOBALS['serverdb']->query("INSERT INTO users_badges (userid,badgeid,iscurrent) VALUES ('".$id."','".$badge."','1')");
    }
    function delete2($id,$badge){
        $GLOBALS['serverdb']->query("DELETE FROM users_badges WHERE userid = '".$id."' AND badgeid = '".$badge."' LIMIT 1");
    }
    function update3($id,$badge){
        $GLOBALS['serverdb']->query("UPDATE users_badges SET iscurrent = '0' WHERE userid = '".$id."'");
        $GLOBALS['serverdb']->query("UPDATE users_badges SET iscurrent = '1' WHERE userid = '".$id."' AND badgeid = '".$badge."' LIMIT 1");
    }
    function update4($id,$ip,$ban_date,$reason){
        $GLOBALS['serverdb']->query("INSERT INTO users_bans (userid,ipaddress,date_expire,descr) VALUES ('".$id."','".$ip."','".$ban_date."','".$reason."')");
        $GLOBALS['serverdb']->query("UPDATE users SET ticket_sso = '' WHERE id = '".$id."' LIMIT 1");
    }
    function update5($id){
        $GLOBALS['serverdb']->query("UPDATE users SET figure = 'hd-180-1.ch-210-66.lg-270-82.sh-290-80.hr-105-42', sex = 'M' WHERE id = '".$id."' LIMIT 1");
    }
    function update6($id){
        $GLOBALS['serverdb']->query("UPDATE users SET badge_status = '0', hc_before = '1' WHERE id = '".$id."' LIMIT 1");
        $GLOBALS['serverdb']->query("UPDATE users SET rank = '1' WHERE id = '".$id."' AND rank = '2' LIMIT 1");
        $GLOBALS['serverdb']->query("DELETE FROM users_badges WHERE badgeid = 'HC1' OR badgeid = 'HC2' AND userid = '".$id."'");
        $GLOBALS['serverdb']->query("DELETE FROM users_club WHERE userid = '".$id."'");
    }
    function delete3($id,$ip){
        $GLOBALS['serverdb']->query("DELETE FROM users_bans WHERE userid = '".$id."' OR ipaddress = '".$ip."' LIMIT 1");
    }
    function select13(){
        $sql = $GLOBALS['serverdb']->query("SELECT userid,ipaddress,date_expire,descr FROM users_bans");
        return $sql;
    }
}
?>

And You will need to host your dcrs somewhere on a host or something.
Or use prehosted ones
Some RP Dcrs:
You must be registered for see links

You must be registered for see links

You must be registered for see links
Click to expand...

Credits:
Swimo = 99% For Helping me/telling me/doing It on my hotel :p
Me = 1% For releasing this tut.
Click to expand...

If this helped you please press the "thanks" Button
​
 
C

Ceejay

Member
Aug 10, 2010
161
2
Yeh, Well i was very Annoyed when i couldnt find a fix, And its like ;\ No one will help so i thought i'd share with community
 
Kieren

Kieren

The OGz
Aug 4, 2010
2,957
751
It sure is annoying trying to fix something and searching teh internet for the problem and it's not found anywhere till Swimo came along well I can tell you a member on this forum won't have this problem thank's to you. xD
 
Jo$h

Jo$h

Posting Freak
Jul 7, 2010
1,030
79
Great fix! Many people I know have trouble with this, so it was good that you posted it!
 

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top