[TUT] How to make an R63 Hotel using novaCMS

Status
Not open for further replies.

helpmeimanewb

New Member
Aug 2, 2012
14
1
i cant get my emulator to wrk becauase if i go to the bottom it still says Butterfly Emultor but when i try butterfly the sql file is missing some tables and my Hotel wont open so:/ the Emulator runs but then the client stays white so it wont work..

EDIT: Plus staff Page Wont work and no Housekeeping:/
 

keiller

Mr Tutorial Man
Jun 9, 2012
492
108
i cant get my emulator to wrk becauase if i go to the bottom it still says Butterfly Emultor but when i try butterfly the sql file is missing some tables and my Hotel wont open so:/ the Emulator runs but then the client stays white so it wont work..

EDIT: Plus staff Page Wont work and no Housekeeping:/

For the third time, I've already explained this.. Yes, there is no housekeeping, but there is a staff page..
 

mommotexx

New Member
Jan 6, 2012
18
0
and i get this error on the page: Warning: Illegal string offset 'name' in C:\xampp\htdocs\application\libraries\page.class.php on line 14

Notice: Undefined index: image_position in C:\xampp\htdocs\application\handlers\me.php on line 37
 

TinyBuilder

Bike ✔
Mar 19, 2012
717
66
Is there any way i could change the default motto that every user gets ?

And why do I get this error : Unknown column 'staff_page' in 'where clause'
And how to fix that ?

And btw , nice CMS THANKS :D
 
Sep 15, 2012
70
2
Is there housekeeping in NovaCMS ? If yes , where ? If no , what housekeeping should I use ?
And why do I get this error : Unknown column 'staff_page' in 'where clause'
And how to fix that ?


Run this SQL:

Code:
-- --------------------------------------------------------
-- Host:                        127.0.0.1
-- Server version:              5.5.16 - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL version:            7.0.0.4053
-- Date/time:                    2012-07-15 09:53:02
-- --------------------------------------------------------
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
 
-- Dumping structure for table phx381.ranks
CREATE TABLE IF NOT EXISTS `ranks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `badgeid` varchar(5) DEFAULT NULL,
  `colour` varchar(50) DEFAULT 'blue',
  `staff_page` enum('1','0') DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
 
-- Dumping data for table phx381.ranks: 9 rows
/*!40000 ALTER TABLE `ranks` DISABLE KEYS */;
INSERT INTO `ranks` (`id`, `name`, `badgeid`, `colour`, `staff_page`) VALUES
    (1, 'User', NULL, NULL, NULL),
    (2, 'VIP', 'VIP', NULL, NULL),
    (3, 'Silver Hobba', 'NWB', NULL, NULL),
    (4, 'Gold Hobba', 'HBA', NULL, NULL),
    (5, 'Trial Moderator', 'HBA', 'green', '1'),
    (6, 'Moderator', 'ADM', 'orange', '1'),
    (7, 'Administrator', 'ADM', 'blue', '1'),
    (8, 'Manager', 'NHM', 'blue2', '1'),
    (9, 'Overlord', 'NHF', 'black', '1');
/*!40000 ALTER TABLE `ranks` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 
-- Dumping structure for table phx381.cms_news
CREATE TABLE IF NOT EXISTS `cms_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `shortstory` text COLLATE latin1_general_ci,
  `longstory` text COLLATE latin1_general_ci,
  `published` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT 'Unspecified',
  `author` int(255) NOT NULL DEFAULT '1',
  `image_position` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '0px 0px',
  `image` varchar(500) COLLATE latin1_general_ci DEFAULT 'public/images/hotelview_banzai.png',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
 
-- Dumping data for table phx381.cms_news: 3 rows
/*!40000 ALTER TABLE `cms_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_news` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

There is no housekeeping, but you really need to stop spamming.
 
Sep 15, 2012
70
2
other hotels look like normal :

You must be registered for see images attach



But why my hotel is alone zoomed in like this :

You must be registered for see images attach



Please help me , i will make you technician in my hotel ( ) if you help me solve all the problems

PM me.
 

TinyBuilder

Bike ✔
Mar 19, 2012
717
66
we can't use butterfly since butterdb don't suit for NovaCMS
But it would be nice if its compatible with Butterdb

Run this SQL:

Code:
-- --------------------------------------------------------
-- Host:                        127.0.0.1
-- Server version:              5.5.16 - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL version:            7.0.0.4053
-- Date/time:                    2012-07-15 09:53:02
-- --------------------------------------------------------
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
 
-- Dumping structure for table phx381.ranks
CREATE TABLE IF NOT EXISTS `ranks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `badgeid` varchar(5) DEFAULT NULL,
  `colour` varchar(50) DEFAULT 'blue',
  `staff_page` enum('1','0') DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
 
-- Dumping data for table phx381.ranks: 9 rows
/*!40000 ALTER TABLE `ranks` DISABLE KEYS */;
INSERT INTO `ranks` (`id`, `name`, `badgeid`, `colour`, `staff_page`) VALUES
    (1, 'User', NULL, NULL, NULL),
    (2, 'VIP', 'VIP', NULL, NULL),
    (3, 'Silver Hobba', 'NWB', NULL, NULL),
    (4, 'Gold Hobba', 'HBA', NULL, NULL),
    (5, 'Trial Moderator', 'HBA', 'green', '1'),
    (6, 'Moderator', 'ADM', 'orange', '1'),
    (7, 'Administrator', 'ADM', 'blue', '1'),
    (8, 'Manager', 'NHM', 'blue2', '1'),
    (9, 'Overlord', 'NHF', 'black', '1');
/*!40000 ALTER TABLE `ranks` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 
-- Dumping structure for table phx381.cms_news
CREATE TABLE IF NOT EXISTS `cms_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  `shortstory` text COLLATE latin1_general_ci,
  `longstory` text COLLATE latin1_general_ci,
  `published` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT 'Unspecified',
  `author` int(255) NOT NULL DEFAULT '1',
  `image_position` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '0px 0px',
  `image` varchar(500) COLLATE latin1_general_ci DEFAULT 'public/images/hotelview_banzai.png',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
 
-- Dumping data for table phx381.cms_news: 3 rows
/*!40000 ALTER TABLE `cms_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_news` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

There is no housekeeping, but you really need to stop spamming.


If i run that SQL , i get this error :

#1054 - Unknown column 'colour' in 'field list'

Please help !
 

DevJarnoBest

New Member
Sep 24, 2012
1
0
Qodex -Delete this
sterven ( "<h1> brb </ h1>." );
Or (?)
Die ( "<h1> brb </ h1>.'' ) ;

Look that...
Greetz.

Sorry for my bad english iam comming from holland!
 

Jezus

The one and only..
Aug 14, 2012
122
49
Please help Warning: Illegal string offset 'name' in C:\xampp1\htdocs\application\libraries\page.class.php on line 14

Strict Standards: Non-static method Staff::getRanks() should not be called statically in C:\xampp1\htdocs\staff.php on line 52
Unknown column 'staff_page' in 'where clause'

I get that warning when i open up my staff page.
 

jappe

Member
Sep 16, 2011
65
3
Please help Warning: Illegal string offset 'name' in C:\xampp1\htdocs\application\libraries\page.class.php on line 14

Strict Standards: Non-static method Staff::getRanks() should not be called statically in C:\xampp1\htdocs\staff.php on line 52
Unknown column 'staff_page' in 'where clause'

I get that warning when i open up my staff page.

Go to the handlers folder and edit staff.php in there. Instead of the public function getRanks() at the top you will type in: public static function getRanks()

Hope i helped you!
 

Jezus

The one and only..
Aug 14, 2012
122
49
Go to the handlers folder and edit staff.php in there. Instead of the public function getRanks() at the top you will type in: public static function getRanks()

Hope i helped you!
Unknown column 'staff_page' in 'where clause'


Thats what it comes up with.
 

xxzacthemag

New Member
Sep 25, 2012
12
0
I get this
Warning: mysql_connect() [ ]: Host 'ppp005054153081.access.hol.gr' is not allowed to connect to this MySQL server in C:\Documents and Settings\XxZachWxX\My Documents\Xampp\xampp\htdocs\global.php on line 15
Could not connect to server, error: Host 'ppp005054153081.access.hol.gr' is not allowed to connect to this MySQL server
 

jappe

Member
Sep 16, 2011
65
3
I get this
Warning: mysql_connect() [ ]: Host 'ppp005054153081.access.hol.gr' is not allowed to connect to this MySQL server in C:\Documents and Settings\XxZachWxX\My Documents\Xampp\xampp\htdocs\global.php on line 15
Could not connect to server, error: Host 'ppp005054153081.access.hol.gr' is not allowed to connect to this MySQL server

Don't know, it's not the new code it's something with your host :(
 

Chief

New Member
Oct 20, 2012
9
0
Ybp6R.png

Help?
 

Stee

Oh hot damn. This is my jam.
Jun 28, 2011
285
158
Is there something up with all the links in this CMS? i've uploaded it to my server and it just refuses to work...
Have a look for yourself.
 
Status
Not open for further replies.

Users who are viewing this thread

Top