[1.X.X] Housekeeping Release.

Jeffrey · Sep 20, 2013

Guys Add this to your database:

Code:

ALTER TABLE `users` ADD `housekeeping_pin` VARCHAR(4)

Sledmore didnt have the Code, so i made one which will help other people faster.
------------------------
EDIT
You guys will manually have to add pins via User Table so you can actually get in.

@Donkeey

Don't Know if this will count as a doublepost, but
i made a table for the "Values"
If you use Sledmore's Housekeeping and want to use the page Values, Here is the sql which i made

Code:

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `values`
-- ----------------------------
DROP TABLE IF EXISTS `values`;
CREATE TABLE `values` (
  `name` varchar(100) NOT NULL,
  `imgurl` varchar(999) NOT NULL,
  `category` varchar(299) NOT NULL,
  `timestamp` int(255) NOT NULL,
  `start_amount` varchar(200) NOT NULL,
  `sold_amount` varchar(200) NOT NULL,
  `id` int(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SBste01 · Feb 20, 2014

The links in the thread, the "fix-them" ones, including the pastes and sqls have been reoved. I was wondering if you had any chance of keeping a spare seeing as I'm getting errors in different pages in my housekeeping. Thanks!

Jeffrey · Feb 20, 2014

SBste01 said:
The links in the thread, the "fix-them" ones, including the pastes and sqls have been reoved. I was wondering if you had any chance of keeping a spare seeing as I'm getting errors in different pages in my housekeeping. Thanks!

I have them I think.. But it isnt that hard to make the sql's yourself...

Zielony · Feb 20, 2014

Looks nice, 8/10.

SBste01 · Feb 20, 2014

Obodiah said:
I have them I think.. But it isnt that hard to make the sql's yourself...

I made the housekeeping_pin one by itself, but like.... I don't have the other stuff.

Jeffrey · Feb 20, 2014

SBste01 said:
I made the housekeeping_pin one by itself, but like.... I don't have the other stuff.

The Housekeeping Pin was already Provided in My Post

If you want the Codes

Go to App -> Class.users.php and replace Your current final public function loginHK() with this one.

Code:

 final public function loginHK()
        {
                global $template, $_CONFIG, $core;
           
                if (isset($_SERVER['HTTP_CF_CONNECTING_IP'])) { $_SERVER['REMOTE_ADDR'] = $_SERVER['HTTP_CF_CONNECTING_IP']; }
           
                if(isset($_POST['login']))
                {   
                        $template->form->setData();
                        unset($template->form->error);
                   
                        if(isset($template->form->username) && isset($template->form->password) && isset($template->form->pincode))
                        {
                                if($this->nameTaken($template->form->username))
                                {     
                                        if($this->userValidation($template->form->username, $core->hashed($template->form->password)))
                                        {
                                                if($this->pinValidation($template->form->username, $core->hashed($template->form->password), $template->form->pincode))
                                                {                           
                                                        if(($this->getInfo($_SESSION['user']['id'], 'rank')) >= $_CONFIG['housekeeping']['rank'])
                                                        {
                                                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Success Login: Username: ".$template->form->username."')") or die(mysql_error());
                                                                $_SESSION["in_hk"] = true;
                                                                $_SESSION["pincode_set"] = true;
                                                                header("Location:".$_CONFIG['hotel']['url']."/ase/index.php?url=dash");
                                                                exit;
                                                        }
                                                        else
                                                        {
                                                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Incorrect level.')") or die(mysql_error());
                                                                $template->form->error = 'Incorrect access level.';
                                                                return;
                                                        }
                                                }
                                                else
                                                {
                                                        mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Wrong Pincode')") or die(mysql_error());
                                                        $template->form->error = 'Incorrect pincode.';
                                                        return;
                                                }   
                                        }
                                        else
                                        {
                                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Wrong Password')") or die(mysql_error());
                                                $template->form->error = 'Incorrect password.';
                                                return;
                                        }           
                                }
                                else
                                {
                                        mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: No such user')") or die(mysql_error());
                                        $template->form->error = 'User does not exist.';
                                        return;
                                }
                        }
                        else
                        {
                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Missing fields.')") or die(mysql_error());
                                $template->form->error = 'Something was missing..';
                                return;
                        }
   
                        $template->form->unsetData();
                }
        }
        final public function pinValidation($username, $password, $pincode)
        {           
                global $engine;
                if($engine->num_rows("SELECT * FROM users WHERE username = '" . $username . "' AND password = '" . $password . "' AND housekeeping_pin = '" . $pincode . "' LIMIT 1") > 0)
                {
                        return true;
                }   
             
                return false;
        }

Code:

/*
Navicat MySQL Data Transfer

Source Server        : jeffreymathew.in_3306
Source Server Version : 50172
Source Host          : jeffreymathew.in:3306
Source Database      : jeffreym_habbo

Target Server Type    : MYSQL
Target Server Version : 50172
File Encoding        : 65001

Date: 2014-02-20 19:31:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for cms_housekeeping_logs
-- ----------------------------
DROP TABLE IF EXISTS `cms_housekeeping_logs`;
CREATE TABLE `cms_housekeeping_logs` (
  `id` int(100) NOT NULL,
  `userid` int(99) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `extra_data` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of cms_housekeeping_logs
-- ----------------------------

The Sql was made out from my head because i lost the original one :3 None the less this should work.

iExplicit · Feb 22, 2014

For anyone who is looking for the cms_housekeeping_logs SQL

Here it is:

Code:

DROP TABLE IF EXISTS `cms_housekeeping_logs`;
CREATE TABLE `cms_housekeeping_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `ip_address` varchar(125) DEFAULT NULL,
  `page` varchar(50) DEFAULT NULL,
  `time` varchar(75) DEFAULT NULL,
  `extra_data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=latin1;

Jeffrey · Feb 22, 2014

iExplicit said:

For anyone who is looking for the cms_housekeeping_logs SQL

Here it is:

Code:

DROP TABLE IF EXISTS `cms_housekeeping_logs`;
CREATE TABLE `cms_housekeeping_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `ip_address` varchar(125) DEFAULT NULL,
  `page` varchar(50) DEFAULT NULL,
  `time` varchar(75) DEFAULT NULL,
  `extra_data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=latin1;

Thanks i forgot it was cms_housekeping_logs xD The quoted post is the recommended SQL In order to run [1.X.X]

Tando · Mar 5, 2014

Pastebin says the paste has been removed. Can anyone provide what I'll need to set this up?

Jeffrey · Mar 5, 2014

Anthony0812 said:
Pastebin says the paste has been removed. Can anyone provide what I'll need to set this up?

Obodiah said:

The Housekeeping Pin was already Provided in My Post

If you want the Codes

Go to App -> Class.users.php and replace Your current final public function loginHK() with this one.

Code:

 final public function loginHK()
        {
                global $template, $_CONFIG, $core;
          
                if (isset($_SERVER['HTTP_CF_CONNECTING_IP'])) { $_SERVER['REMOTE_ADDR'] = $_SERVER['HTTP_CF_CONNECTING_IP']; }
          
                if(isset($_POST['login']))
                {  
                        $template->form->setData();
                        unset($template->form->error);
                  
                        if(isset($template->form->username) && isset($template->form->password) && isset($template->form->pincode))
                        {
                                if($this->nameTaken($template->form->username))
                                {    
                                        if($this->userValidation($template->form->username, $core->hashed($template->form->password)))
                                        {
                                                if($this->pinValidation($template->form->username, $core->hashed($template->form->password), $template->form->pincode))
                                                {                          
                                                        if(($this->getInfo($_SESSION['user']['id'], 'rank')) >= $_CONFIG['housekeeping']['rank'])
                                                        {
                                                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Success Login: Username: ".$template->form->username."')") or die(mysql_error());
                                                                $_SESSION["in_hk"] = true;
                                                                $_SESSION["pincode_set"] = true;
                                                                header("Location:".$_CONFIG['hotel']['url']."/ase/index.php?url=dash");
                                                                exit;
                                                        }
                                                        else
                                                        {
                                                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Incorrect level.')") or die(mysql_error());
                                                                $template->form->error = 'Incorrect access level.';
                                                                return;
                                                        }
                                                }
                                                else
                                                {
                                                        mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Wrong Pincode')") or die(mysql_error());
                                                        $template->form->error = 'Incorrect pincode.';
                                                        return;
                                                }  
                                        }
                                        else
                                        {
                                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Wrong Password')") or die(mysql_error());
                                                $template->form->error = 'Incorrect password.';
                                                return;
                                        }          
                                }
                                else
                                {
                                        mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: No such user')") or die(mysql_error());
                                        $template->form->error = 'User does not exist.';
                                        return;
                                }
                        }
                        else
                        {
                                mysql_query("INSERT INTO `cms_housekeeping_logs` (userid,ip_address,page,time,extra_data) VALUES ('".$_SESSION['user']['id']."', '".$_SERVER['REMOTE_ADDR']."', 'Housekeeping Login', '".time()."', 'Failed to login: Missing fields.')") or die(mysql_error());
                                $template->form->error = 'Something was missing..';
                                return;
                        }
  
                        $template->form->unsetData();
                }
        }
        final public function pinValidation($username, $password, $pincode)
        {          
                global $engine;
                if($engine->num_rows("SELECT * FROM users WHERE username = '" . $username . "' AND password = '" . $password . "' AND housekeeping_pin = '" . $pincode . "' LIMIT 1") > 0)
                {
                        return true;
                }  
            
                return false;
        }

Code:

/*
Navicat MySQL Data Transfer

Source Server        : jeffreymathew.in_3306
Source Server Version : 50172
Source Host          : jeffreymathew.in:3306
Source Database      : jeffreym_habbo

Target Server Type    : MYSQL
Target Server Version : 50172
File Encoding        : 65001

Date: 2014-02-20 19:31:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for cms_housekeeping_logs
-- ----------------------------
DROP TABLE IF EXISTS `cms_housekeeping_logs`;
CREATE TABLE `cms_housekeeping_logs` (
  `id` int(100) NOT NULL,
  `userid` int(99) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `page` varchar(255) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `extra_data` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of cms_housekeeping_logs
-- ----------------------------

The Sql was made out from my head because i lost the original one :3 None the less this should work.

Tando · Mar 10, 2014

I get the error message: Field 'id' doesn't have a default value
When trying to add bans, give badges etc. Can someone please hlep?

VaginaMuncher · Mar 10, 2014

Anthony0812 said:
I get the error message: Field 'id' doesn't have a default value
When trying to add bans, give badges etc. Can someone please hlep?

Add a value to the table.

Tando · Mar 10, 2014

Brontes said:
Add a value to the table.

in 'bans' or 'users' ?

VaginaMuncher · Mar 11, 2014

Anthony0812 said:
in 'bans' or 'users' ?

In bans & badges etc.
Field 'id' add a value if you get me

Tando · Mar 11, 2014

Brontes said:
In bans & badges etc.
Field 'id' add a value if you get me

Not too sure, may i add you on skype?

Tando · Mar 13, 2014

Still having problems with this lads. Anyone who might be able to help me?

Baevus · Oct 12, 2014

Really old but Field 'big_image' doesn't have a default value in the second part of news.

Jeffrey · Oct 12, 2014

itsEthan_ said:
Really old but Field 'big_image' doesn't have a default value in the second part of news.

What database are you using? Rev63(b) and/or what emulator. I'll give you a fix when i come back from a place

Baevus · Oct 12, 2014

Jeffrey_ said:
What database are you using? Rev63(b) and/or what emulator. I'll give you a fix when i come back from a place

It was mercury r63b but now I'm just using phoenix major edit so dw.

JayC · Nov 30, 2014

@Sledetta this is a old post but still good, Mind updating the functions / SQL?

[1.X.X] Housekeeping Release.

Devbest Indian Tech Support

Member

Devbest Indian Tech Support

Member

Member

Devbest Indian Tech Support

Member

Devbest Indian Tech Support

Norwegian Steam Engine

Devbest Indian Tech Support

Norwegian Steam Engine

Chilling with me bitch Fiona

Norwegian Steam Engine

Chilling with me bitch Fiona

Norwegian Steam Engine

Norwegian Steam Engine

the names ethan

Devbest Indian Tech Support

the names ethan

Well-Known Member

Users who are viewing this thread