[HELP] LightCMS MySQLi Error

K

Katalyst

New Member
May 10, 2014
22
0
I get this error when trying to access my retro :

V46eo5I.png

I've also ran this query in my database :

/*

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', '
You must be registered for see links
', 'Yo, i\'m a hot campaign! Sizzling!', 'Hahaha! Cobe 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');
Click to expand...
 
Sort by date Sort by votes
K

Katalyst

New Member
May 10, 2014
22
0
JerryCool said:
Check-out the file the error is in.
Click to expand...
I have, this is the code :

<?php

class LightCore {
public function getServerStat($var) {
global $db, $core;
$this->query = "SELECT `" . $var . "` FROM `server_status`";
if($this->result = $db->query($this->query)) {
while($this->data = $this->result->fetch_row()) {
$this->return = $this->data[0];
return $this->return;
}
}
else {
$db->databaseError($db->error);
}
}
}
?>
Click to expand...
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top