[REL] LightCMS 2 [MySQLi, PHP, OOP, Scratch, Phx, Bfly]

Status
Not open for further replies.

iRekan

XboxOneFTW!
Nov 8, 2011
349
47
I get a Unknown column 'points' in 'field list' error when trying to go to the me page D;
 

Codiaczille

New Member
May 26, 2012
4
0
Got an error on the staff page : Fatal error: Call to undefined method LightCore::getSystemString() in D:\xampp\htdocs\staff\core.php on line 14
 

lepos

thinking about you. yes you
Dec 11, 2011
2,025
689
Just to everyone saying 'Its not working'.

I just downloaded it upon request to test it out, configured and it worked perfectly.
The client worked fine, the users showed up in the database?

I just followed everything Jonty said to change since Page #1.
So it works 100%, you just need to know how to set it up ;)
 

Solid

Active Member
May 1, 2012
126
31
Everything is working with this CMS except for the housekeeping. I get this error:

I have went into the /staff/ and changed the access to rank "7" I am ranked 7, I tried logging into housekeeping and I get that error.
What am I supose to do?
 

Solid

Active Member
May 1, 2012
126
31
I get a Unknown column 'points' in 'field list' error when trying to go to the me page D;
You forgot to run this
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>&nbsp;</p>\r\n<p>Groetjes,</p>\r\n<p>Thierry &amp; T09 &amp; 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');
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` char(50) NOT NULL,
  `real_name` char(100) NOT NULL DEFAULT '',
  `password` char(42) NOT NULL,
  `mail` varchar(50) NOT NULL DEFAULT '[email protected]',
  `auth_ticket` varchar(60) NOT NULL,
  `rank` int(1) unsigned NOT NULL DEFAULT '1',
  `credits` int(11) NOT NULL DEFAULT '0',
  `vip_points` int(11) NOT NULL DEFAULT '0',
  `activity_points` int(11) NOT NULL DEFAULT '0',
  `activity_points_lastupdate` double(5,0) NOT NULL DEFAULT '0',
  `look` char(100) 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` char(50) NOT NULL,
  `account_created` char(12) NOT NULL,
  `last_online` varchar(20) NOT NULL,
  `online` enum('0','1') NOT NULL DEFAULT '0',
  `ip_last` char(20) NOT NULL,
  `ip_reg` char(20) NOT NULL,
  `home_room` int(10) unsigned NOT NULL DEFAULT '0',
  `respect` int(11) NOT NULL DEFAULT '0',
  `daily_respect_points` int(1) NOT NULL DEFAULT '3',
  `daily_pet_respect_points` int(1) NOT NULL DEFAULT '3',
  `newbie_status` int(1) NOT NULL DEFAULT '3',
  `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',
  `lastdailycredits` char(18) NOT NULL DEFAULT '',
  `points` int(11) NOT NULL DEFAULT '0',
  `block_trade` enum('1','0') NOT NULL DEFAULT '0',
  `crystals` int(11) NOT NULL DEFAULT '0',
  `currentquestid` int(11) unsigned NOT NULL,
  `currentquestprogress` int(11) NOT NULL,
  `achievement_points` int(11) NOT NULL,
  PRIMARY KEY (`username`),
  UNIQUE KEY `id` (`id`) USING HASH,
  UNIQUE KEY `username` (`username`) USING BTREE,
  KEY `ip_last` (`ip_last`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('2', 'asfadfsdgf', '', '4121aef67f24ada7e7b3f0b57f2fb57cab0b2d8a', '[email protected]', '', '10', '18175', '0', '1200', '99999', 'hd-180-2.sh-290-92.lg-275-92.ch-3030-63.hr-831-61', 'M', 'I am new at Zap, hey!', '14-Aug-2012', '8/14/2012 4:52:53 PM', '1', '127.0.0.1', '127.0.0.1', '1', '0', '3', '3', '3', '0', '0', '0', '0', '08/14', '0', '0', '0', '0', '0', '0');
INSERT INTO `users` VALUES ('3', 'jcat', '', '7bef6b4c97db89b71afd09b53c38df99449c46e9', '[email protected]', 'LIG-49124523469-1017511907-TestHotel-3', '1', '5000', '0', '1000', '0', 'hd-180-2.sh-290-92.lg-275-92.ch-3030-63.hr-831-61', 'M', 'I am new at Zap, hey!', '21-Aug-2012', '', '0', '127.0.0.1', '127.0.0.1', '1', '0', '3', '3', '3', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0');
INSERT INTO `users` VALUES ('1', 'lolcat', '', '5003a0a6ba6846f5aada477da94347e7e4fd2bdc', '[email protected]', '', '10', '29627', '0', '4600', '99999', 'hd-180-2.sh-290-92.lg-275-92.ch-3030-63.hr-831-61', 'M', 'I am new at Zap, hey!', '13-Aug-2012', '8/13/2012 8:15:27 PM', '0', '127.0.0.1', '127.0.0.1', '1', '0', '3', '0', '3', '0', '0', '0', '0', '08/13', '0', '0', '0', '0', '0', '0');
 

DrPepper

I drink myself on a regular basis get over it
Jul 14, 2012
205
28
Table 'spazahotel.server_status' doesn't exist And so I ask wtf is the table :p So I may add it to my database or is there a database in the files somewhere which I missed that I can add to my database so it will work?
 

Leader

1 Timothy 1:15
Aug 24, 2012
1,031
310
Table 'spazahotel.server_status' doesn't exist And so I ask wtf is the table :p So I may add it to my database or is there a database in the files somewhere which I missed that I can add to my database so it will work?
I assume your not using the default butterfly emu database he provided on one of his replies. :p
 

zMagenta

Posting Freak
Jul 15, 2011
1,414
682
This CMS never got anywhere did it? Too many bugs and a half finished release imo.

Off topic: 400 posts!
 
Status
Not open for further replies.

Users who are viewing this thread

Top