[REL] LightCMS 2 [MySQLi, PHP, OOP, Scratch, Phx, Bfly]
- Thread starter Jonty
- Start date
- Status
firsthacks
New Member
- Sep 17, 2012
- 20
- 0
still think your UberCMS 2.0.1 is alot better.
Ghost
Legacy, it's all anyone leaves behind.
- Jun 8, 2012
- 1,640
- 503
For BFly Users do not run this query For R96C the emu won't start!
If you use XAMPP you need Visual C++ heres URL:
You must be registered for see links
xNielsBeatZ
Member
- Oct 24, 2012
- 51
- 7
I love it, thanks!
10/10.
10/10.
mastermind
New Member
- May 27, 2012
- 20
- 2
I have no idea how to convert this from MySQLi to Plain old MySQL as I don't have a MySQLi engine to run it on 
I only use XAMPP or web hosting with links to a VPS
I only use XAMPP or web hosting with links to a VPS
DaLightz
See ya'll in the afterlife.
- May 19, 2012
- 1,136
- 262
MySQLi is only an improve on MySQL. You can use it with xamp, because it has nothing to do with the server. It's the version of php your using. Make sure you have the most recent version of xampp also.I have no idea how to convert this from MySQLi to Plain old MySQL as I don't have a MySQLi engine to run it on
mastermind
New Member
- May 27, 2012
- 20
- 2
I have both the latest versions but how do I make an SQLi DB? Or is it done else where? i'm not entirely sure as I mainly use MySQL
DaLightz
See ya'll in the afterlife.
- May 19, 2012
- 1,136
- 262
You don't have to edit Nything. Just download, and use.
mastermind
New Member
- May 27, 2012
- 20
- 2
Oh right lol theres me trying to change all the SQL Queries to SQL from SQLi lol
mastermind
New Member
- May 27, 2012
- 20
- 2
Okay, so it's all set up on my VPS but, I'm having issues accessing the staff page here's the error: Fatal error: Call to undefined method LightCore::getSystemString() in C:\xampp\htdocs\staff\core.php on line 14
iRekan
XboxOneFTW!
- Nov 8, 2011
- 349
- 47
Just use another CMS. Jonty wont support you, nobody probaly will...
lepos
thinking about you. yes you
- Dec 11, 2011
- 2,024
- 687
I got the users table to work, it was easy? Everyone was saying when they ran it the users never appeared in the database... So do as I say.
Basically I was already using the phoenix database, from the query that Jonty provided I removed everything to do with the users table.
So I ran this (Keep reading after the query, there is more):
After doing the above you'll get a "points" error, delete your users table, download this one and execute it into the database.
Download:
Now if you register on your hotel and check the users database, your user should appear!
Everything else works for me, but this CMS is crap, sorry to inform you all.
Basically I was already using the phoenix database, from the query that Jonty provided I removed everything to do with the users table.
So I ran this (Keep reading after the query, there is more):
Code:
/*
Navicat MySQL Data Transfer
Source Server : local
Source Server Version : 50165
Source Host : localhost:3306
Source Database : bfly
Target Server Type : MYSQL
Target Server Version : 50165
File Encoding : 65001
Date: 2012-08-22 06:32:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `site_hotcampaigns`
-- ----------------------------
DROP TABLE IF EXISTS `site_hotcampaigns`;
CREATE TABLE `site_hotcampaigns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT '1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`image_url` text NOT NULL,
`caption` text NOT NULL,
`descr` text NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of site_hotcampaigns
-- ----------------------------
INSERT INTO `site_hotcampaigns` VALUES ('1', '1', '1', 'http://i.imgur.com/Au8Dr.gif', 'Yo, i\'m a hot campaign! Sizzling!', 'Hahaha! ***** loves men.', '');
-- ----------------------------
-- Table structure for `site_news`
-- ----------------------------
DROP TABLE IF EXISTS `site_news`;
CREATE TABLE `site_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
`title` text NOT NULL,
`category_id` int(10) unsigned NOT NULL DEFAULT '1',
`topstory_image` text NOT NULL,
`body` text NOT NULL,
`snippet` text NOT NULL,
`datestr` varchar(50) NOT NULL,
`timestamp` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `datestr` (`datestr`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of site_news
-- ----------------------------
INSERT INTO `site_news` VALUES ('9', 'nieuwe-site', 'Nieuwe Site', '12', 'c_images/Top_Story_Images/BeachBunny2.gif', '<p>Hey Nablo\'s,</p>\r\n<p>Ja! We hebben eindelijk een nieuw site uiterlijk, deze gemaakt door T09! Het enige wat niet zo leuk is voor jullie is dat alle accounts zijn verwijdert. Dit omdat we een geheel nieuwe database hebben gekregen. Dit is wel beter voor ons, omdat we nu minder laggen etc.</p>\r\n<p>Nablo is nu in top conditie, nog wat laatste aanpassingen en we zijn helemaal klaar! Het enige wat we van jullie vragen is om zoveel mogelijk reclame te maken op andere hotels.</p>\r\n<p>TIPS:</p>\r\n<p>- Maak reclame op drukke hotels</p>\r\n<p>- Maak reclame op MSN</p>\r\n<p>- Maak reclame op Twitter/Facebook/Hyves</p>\r\n<p>- Maak niet een half uur reclame dat is te kort!</p>\r\n<p>Bij de 25 Start ik de Sollicitatie\'s !</p>\r\n<p> </p>\r\n<p>Groetjes,</p>\r\n<p>Thierry & T09 & Relic - Hotel Beheer</p>', '<p>Wa is ie mooi!</p>', '28-Jun-2012', '1340992623');
INSERT INTO `site_news` VALUES ('10', 'test', 'test', '12', 'c_images/Top_Story_Images/28152_topstory_infobus.gif', 'test', 'testr', '29-Jun-2012', '1340985763');
INSERT INTO `site_news` VALUES ('11', 'test', 'test', '12', 'c_images/Top_Story_Images/28152_topstory_infobus.gif', 'test', 'test', '29-Jun-2012', '1340985769');
INSERT INTO `site_news` VALUES ('12', 'test', 'test', '12', 'c_images/Top_Story_Images/28152_topstory_infobus.gif', 'test', 'test', '29-Jun-2012', '1340985782');
INSERT INTO `site_news` VALUES ('13', 'test', 'test', '12', 'c_images/Top_Story_Images/28152_topstory_infobus.gif', 'test', 'testt', '29-Jun-2012', '1340985789');
-- ----------------------------
-- Table structure for `site_news_categories`
-- ----------------------------
DROP TABLE IF EXISTS `site_news_categories`;
CREATE TABLE `site_news_categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`caption` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of site_news_categories
-- ----------------------------
INSERT INTO `site_news_categories` VALUES ('12', 'Uncategorized');
INSERT INTO `site_news_categories` VALUES ('1', 'Habbo');
INSERT INTO `site_news_categories` VALUES ('2', 'Technical');
INSERT INTO `site_news_categories` VALUES ('3', 'Updates');
INSERT INTO `site_news_categories` VALUES ('4', 'Competitions');
INSERT INTO `site_news_categories` VALUES ('5', 'Polls');
INSERT INTO `site_news_categories` VALUES ('6', 'Sponsored');
INSERT INTO `site_news_categories` VALUES ('7', 'Credits');
INSERT INTO `site_news_categories` VALUES ('8', 'Habbo Club');
INSERT INTO `site_news_categories` VALUES ('9', 'VIP');
INSERT INTO `site_news_categories` VALUES ('10', 'Furni');
INSERT INTO `site_news_categories` VALUES ('11', 'Support');
INSERT INTO `site_news_categories` VALUES ('13', 'Habbo.VG Way');After doing the above you'll get a "points" error, delete your users table, download this one and execute it into the database.
Download:
You must be registered for see links
Now if you register on your hotel and check the users database, your user should appear!
Everything else works for me, but this CMS is crap, sorry to inform you all.
Leader
github.com/habbo-hotel
- Aug 24, 2012
- 1,030
- 307
CMS is actually pretty nice to build upon. Most cms's with loads of features Ex: Ubercms or Haddocms have loads of exploits and are very flow and yield good performance. This cms has had no errors for me besides the housekeeping which practically needs to be self coded. (Lepos's version is hard, Simples get Butterfly and original database and run queries on first page, BOOM!
iRekan
XboxOneFTW!
- Nov 8, 2011
- 349
- 47
- Status
