Illumina CMS [PHP, OOP, Phoenix/Butterfly, Updated]

Bradshly · Mar 27, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

there was no user found with your session ticket Then it says that, I'm using bcstorm could that be why?

I'v changed public $server_type = "Butterfly"; // Phoenix or Butterflyto public $server_type = "phoenix"; // Phoenix or Butterfly

Both do the same

Jonteh · Mar 27, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Bradshly said:
there was no user found with your session ticket Then it says that, I'm using bcstorm could that be why?

I'v changed public $server_type = "Butterfly"; // Phoenix or Butterflyto public $server_type = "phoenix"; // Phoenix or Butterfly

Both do the same

Replace client.php with this:

You must be registered to see links

Bradshly · Mar 27, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

It still says no session ticket?

Jonteh · Mar 27, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Bradshly said:
lease update your Flash Player to the latest version.

You can install and download Adobe Flash Player here:
You must be registered to see links
. More instructions for installation can be found here:
You must be registered to see links

You must be registered to see links

gives me that ?

That usually means your Habbo.swf doesn't exist or your variables are incorrectly set up.

Bradshly · Mar 27, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

I fixed that bit then it still says session ticket i'll try the client again re-do it.

one more error, Once i register i can't login afterwards?

Still same still says Session ticket

Bradshly · Mar 27, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Okay i know the reason, Registration don't work well, Doesn't save users

Jonteh · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Bradshly said:
Okay i know the reason, Registration don't work well, Doesn't save users

Try disabling strict mode on your SQL server and making sure you have run the "ALTER user" table queries from the first post.

Bradshly · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

I'v run the queries, How do i disable strict mode? I think once i fix this it'll fix the session ticket, it obviously wouldnt find ticket because there was no user

Jax · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Bradshly said:
I'v run the queries, How do i disable strict mode? I think once i fix this it'll fix the session ticket, it obviously wouldnt find ticket because there was no user

Code:

 SET @@global.sql_mode= '';

This will turn strict mode off in your database.

Bradshly · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

No still not this is weird :S After register goes back to the index i can't login and user isn't made.

Jonteh · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

iJak said:
Code:

SET @@global.sql_mode= '';

This will turn strict mode off in your database.

Or go into my.ini and remove STRICT_TRANS_TABLES from the SQL mode.

Bradshly · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

thanks for your help but still don't work, it's weird, anyone have a working bcstorm database can try new db, i only use bcstorm because r63b

Jonteh · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Update - VotingAPI is going down a lot recently so here is some code to patch:

Add this function to /engine/lightcms.php:

Code:

		public function isVotingOnline() {
			return @fsockopen("142.4.4.131", 80, $errno, $errstr, 1) ? true : false;
		}

Then in client.php and index.php change

Code:

if(!isset($_GET["novote"]) && $light->thehabbos_enabled) {

to

Code:

if(!isset($_GET["novote"]) && $light->thehabbos_enabled && $light->isVotingOnline()) {

Bradshly said:
thanks for your help but still don't work, it's weird, anyone have a working bcstorm database can try new db, i only use bcstorm because r63b

This is my users table:

Code:

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.6.10 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             7.0.0.4359
-- --------------------------------------------------------


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping structure for table zapdb.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `real_name` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(50) NOT NULL,
  `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@zaphotel.net',
  `auth_ticket` text NOT NULL,
  `rank` int(11) unsigned NOT NULL DEFAULT '1',
  `credits` int(11) NOT NULL DEFAULT '25000',
  `vip_points` int(11) NOT NULL DEFAULT '0',
  `activity_points` int(11) NOT NULL DEFAULT '0',
  `activity_points_lastupdate` double NOT NULL DEFAULT '0',
  `look` varchar(500) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `motto` varchar(50) NOT NULL DEFAULT 'Zap Newbie',
  `about` varchar(65) DEFAULT '',
  `account_created` varchar(50) NOT NULL DEFAULT 'NULL',
  `last_online` varchar(50) NOT NULL DEFAULT 'Never',
  `online` enum('0','1') NOT NULL DEFAULT '0',
  `ip_last` varchar(120) NOT NULL,
  `ip_reg` varchar(120) NOT NULL,
  `home_room` int(10) unsigned NOT NULL DEFAULT '0',
  `respect` int(11) NOT NULL DEFAULT '0',
  `daily_respect_points` int(11) NOT NULL DEFAULT '5',
  `daily_pet_respect_points` int(11) NOT NULL DEFAULT '5',
  `newbie_status` int(11) NOT NULL DEFAULT '0',
  `is_muted` enum('0','1') NOT NULL DEFAULT '0',
  `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
  `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
  `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
  `hide_online` enum('0','1') NOT NULL DEFAULT '0',
  `hide_video` enum('0','1') NOT NULL DEFAULT '1',
  `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
  `vip` enum('0','1') NOT NULL DEFAULT '0',
  `mail_verified` varchar(6) NOT NULL DEFAULT 'true',
  `expert` varchar(1) NOT NULL,
  `points` int(3) NOT NULL DEFAULT '1',
  `temp` int(1) NOT NULL DEFAULT '0',
  `forumname` varchar(30) NOT NULL DEFAULT 'NewUser',
  `mod_leader` varchar(2) NOT NULL DEFAULT '0',
  `adm_leader` varchar(2) NOT NULL DEFAULT '0',
  `founder` varchar(1) NOT NULL DEFAULT '0',
  `c_h` int(1) NOT NULL DEFAULT '0',
  `volume` int(3) NOT NULL DEFAULT '100',
  `logged_today` varchar(30) DEFAULT '0',
  `has_voted` varchar(30) NOT NULL DEFAULT '0',
  `newcrypto` varchar(30) NOT NULL DEFAULT '0',
  `lastdailycredits` char(18) NOT NULL DEFAULT '0',
  `currentquestid` int(11) NOT NULL DEFAULT '0',
  `currentquestprogress` int(11) NOT NULL DEFAULT '0',
  `achievement_points` int(11) NOT NULL DEFAULT '0',
  `last_offline` varchar(50) DEFAULT '0',
  `crystals` int(11) NOT NULL DEFAULT '0',
  `block_trade` varchar(30) NOT NULL DEFAULT '0',
  `trial_admin` enum('0','1') NOT NULL DEFAULT '0',
  `playermod` enum('0','1') NOT NULL DEFAULT '0',
  `legend` enum('0','1') NOT NULL DEFAULT '0',
  `quests` varchar(200) DEFAULT '',
  `queststates` varchar(200) DEFAULT '',
  `canchangename` enum('0','1') DEFAULT '0',
  `FavoriteGroup` int(11) DEFAULT '0',
  `one_password` varchar(500) DEFAULT '',
  `datosreg` varchar(500) DEFAULT '',
  `country` varchar(500) DEFAULT '',
  `facebook_id` varchar(255) DEFAULT '',
  `marketing` varchar(1) DEFAULT '',
  `showhome` varchar(10) DEFAULT '',
  `main` varchar(10) DEFAULT '',
  `registered` varchar(10) DEFAULT '',
  `lastonline` varchar(10) DEFAULT '',
  `passed_quiz` enum('0','1') DEFAULT '1',
  `points_online` int(11) DEFAULT '0',
  `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
  `acc_pornbanned` enum('0','1') NOT NULL DEFAULT '0',
  `position` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- Data exporting was unselected.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Zayy · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Jonteh said:
Update - VotingAPI is going down a lot recently so here is some code to patch:

Add this function to /engine/lightcms.php:

Code:

public function isVotingOnline() { return @fsockopen("142.4.4.131", 80, $errno, $errstr, 1) ? true : false; }

Then in client.php and index.php change

Code:

if(!isset($_GET["novote"]) && $light->thehabbos_enabled) {

to

Code:

if(!isset($_GET["novote"]) && $light->thehabbos_enabled && $light->isVotingOnline()) {

How is this any better compared to the one I posted two pages back? As you even said, they lag quite a bit so all you’re going to achieve is loss of votes, don’t you think it should be at least 5 seconds of timeout?

Technical edit:
If I was to launch a slowloris attack against 142.4.4.131 and put the timeout on 350 (200 is the timeout needed to bring the site to a stand-still) I could just semi-ddos it to affect you’re incoming votes and help other hotels rise above you, one second is too low.

tomsandz · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Any fix for the "friends online" on the user profile anyone?

Zayy · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

tomsandz said:
Any fix for the "friends online" on the user profile anyone?

What's wrong with it?

Bradshly · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Jonteh said:

Update - VotingAPI is going down a lot recently so here is some code to patch:

Code:

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.6.10 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             7.0.0.4359
-- --------------------------------------------------------


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping structure for table zapdb.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `real_name` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(50) NOT NULL,
  `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@zaphotel.net',
  `auth_ticket` text NOT NULL,
  `rank` int(11) unsigned NOT NULL DEFAULT '1',
  `credits` int(11) NOT NULL DEFAULT '25000',
  `vip_points` int(11) NOT NULL DEFAULT '0',
  `activity_points` int(11) NOT NULL DEFAULT '0',
  `activity_points_lastupdate` double NOT NULL DEFAULT '0',
  `look` varchar(500) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `motto` varchar(50) NOT NULL DEFAULT 'Zap Newbie',
  `about` varchar(65) DEFAULT '',
  `account_created` varchar(50) NOT NULL DEFAULT 'NULL',
  `last_online` varchar(50) NOT NULL DEFAULT 'Never',
  `online` enum('0','1') NOT NULL DEFAULT '0',
  `ip_last` varchar(120) NOT NULL,
  `ip_reg` varchar(120) NOT NULL,
  `home_room` int(10) unsigned NOT NULL DEFAULT '0',
  `respect` int(11) NOT NULL DEFAULT '0',
  `daily_respect_points` int(11) NOT NULL DEFAULT '5',
  `daily_pet_respect_points` int(11) NOT NULL DEFAULT '5',
  `newbie_status` int(11) NOT NULL DEFAULT '0',
  `is_muted` enum('0','1') NOT NULL DEFAULT '0',
  `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
  `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
  `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
  `hide_online` enum('0','1') NOT NULL DEFAULT '0',
  `hide_video` enum('0','1') NOT NULL DEFAULT '1',
  `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
  `vip` enum('0','1') NOT NULL DEFAULT '0',
  `mail_verified` varchar(6) NOT NULL DEFAULT 'true',
  `expert` varchar(1) NOT NULL,
  `points` int(3) NOT NULL DEFAULT '1',
  `temp` int(1) NOT NULL DEFAULT '0',
  `forumname` varchar(30) NOT NULL DEFAULT 'NewUser',
  `mod_leader` varchar(2) NOT NULL DEFAULT '0',
  `adm_leader` varchar(2) NOT NULL DEFAULT '0',
  `founder` varchar(1) NOT NULL DEFAULT '0',
  `c_h` int(1) NOT NULL DEFAULT '0',
  `volume` int(3) NOT NULL DEFAULT '100',
  `logged_today` varchar(30) DEFAULT '0',
  `has_voted` varchar(30) NOT NULL DEFAULT '0',
  `newcrypto` varchar(30) NOT NULL DEFAULT '0',
  `lastdailycredits` char(18) NOT NULL DEFAULT '0',
  `currentquestid` int(11) NOT NULL DEFAULT '0',
  `currentquestprogress` int(11) NOT NULL DEFAULT '0',
  `achievement_points` int(11) NOT NULL DEFAULT '0',
  `last_offline` varchar(50) DEFAULT '0',
  `crystals` int(11) NOT NULL DEFAULT '0',
  `block_trade` varchar(30) NOT NULL DEFAULT '0',
  `trial_admin` enum('0','1') NOT NULL DEFAULT '0',
  `playermod` enum('0','1') NOT NULL DEFAULT '0',
  `legend` enum('0','1') NOT NULL DEFAULT '0',
  `quests` varchar(200) DEFAULT '',
  `queststates` varchar(200) DEFAULT '',
  `canchangename` enum('0','1') DEFAULT '0',
  `FavoriteGroup` int(11) DEFAULT '0',
  `one_password` varchar(500) DEFAULT '',
  `datosreg` varchar(500) DEFAULT '',
  `country` varchar(500) DEFAULT '',
  `facebook_id` varchar(255) DEFAULT '',
  `marketing` varchar(1) DEFAULT '',
  `showhome` varchar(10) DEFAULT '',
  `main` varchar(10) DEFAULT '',
  `registered` varchar(10) DEFAULT '',
  `lastonline` varchar(10) DEFAULT '',
  `passed_quiz` enum('0','1') DEFAULT '1',
  `points_online` int(11) DEFAULT '0',
  `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
  `acc_pornbanned` enum('0','1') NOT NULL DEFAULT '0',
  `position` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- Data exporting was unselected.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

This kind of helped, user saved but didn save password? lol sorry about this

Jonteh · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

tomsandz said:
Any fix for the "friends online" on the user profile anyone?

I provided a userprofile.php edit in one of the last few pages, check for it and it will fix your issue.

Bradshly · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

this is how it shows now

Jonteh · Mar 28, 2013

Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Bradshly said:
this is how it shows now

Have you tried to modify your register.php page at all? If so, you might want to use the original.

Illumina CMS [PHP, OOP, Phoenix/Butterfly, Updated]

Brad

:joy:

Brad

:joy:

Brad

Brad

:joy:

Brad

C# Programmer

Brad

:joy:

Brad

:joy:

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Brad

:joy:

Brad

Attachments

:joy:

Attachments