[Release] Peace Hotel CMS (BoltCMS v1)

Rain

c
Mar 13, 2015
558
243
Hey,

This was just sitting on my PC, so I decided to release it to everyone, since I had many people requesting it :b

Features;
  • Multiple Languages ( ) - Just make MY.lang.php in the /application/langs/ for the diff languages. I'm unsure what langs exist, but i have a turkish lang if you want it
  • Avatar Editor ( )
  • Working Email Activation (Just setup a mailgun account, the mailgun API is all there).
  • Node.JS Login alerts (Unfortunately i lost the node application, but it would be easy as shit to recode)
  • Homes & Home settings with snog ( , )
  • Login, Trade, and chatlogs ( )
  • Nice stats page ( )
  • Nice shop ( )
And much more, I won't be releasing the PayPal IPN, as it could have some vulnerability that I haven't seen, and i don't trust the community anymore.

Regardless, enjoy the cms, it's fast and secure! If large amounts of people need help/support for this, I'll make a support thread, otherwise juse PM me :)

(Can't remember which tables are used in this CMS, so here's a whole bunch. PM if I missed one.) SQL;
/*
Navicat MariaDB Data Transfer

Source Server : localhost_3306
Source Server Version : 100114
Source Host : localhost:3306
Source Database : peace

Target Server Type : MariaDB
Target Server Version : 100114
File Encoding : 65001

Date: 2016-06-08 22:50:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for cms_clicks
-- ----------------------------
DROP TABLE IF EXISTS `cms_clicks`;
CREATE TABLE `cms_clicks` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`timestamp` varchar(100) NOT NULL,
`ip_addr` varchar(100) NOT NULL,
`where_from` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1705 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for cms_hk_logs
-- ----------------------------
DROP TABLE IF EXISTS `cms_hk_logs`;
CREATE TABLE `cms_hk_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL,
`data` text NOT NULL,
`username` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4538 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_logins
-- ----------------------------
DROP TABLE IF EXISTS `cms_logins`;
CREATE TABLE `cms_logins` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`result` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16518 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `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` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`author` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for cms_profile_snogs
-- ----------------------------
DROP TABLE IF EXISTS `cms_profile_snogs`;
CREATE TABLE `cms_profile_snogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`to_id` int(11) NOT NULL DEFAULT '0',
`from_id` int(11) NOT NULL DEFAULT '0',
`type` varchar(20) NOT NULL DEFAULT 'snog',
`message` varchar(250) NOT NULL DEFAULT '',
`time` varchar(100) NOT NULL DEFAULT '',
`seen` varchar(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=236 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_queries
-- ----------------------------
DROP TABLE IF EXISTS `cms_queries`;
CREATE TABLE `cms_queries` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`data` varchar(500) NOT NULL,
`time` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1478 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for cms_referrals
-- ----------------------------
DROP TABLE IF EXISTS `cms_referrals`;
CREATE TABLE `cms_referrals` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`user` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_settings
-- ----------------------------
DROP TABLE IF EXISTS `cms_settings`;
CREATE TABLE `cms_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_key` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_shop_packs
-- ----------------------------
DROP TABLE IF EXISTS `cms_shop_packs`;
CREATE TABLE `cms_shop_packs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT 'Null',
`description` text NOT NULL,
`img` varchar(355) NOT NULL DEFAULT 'null',
`price` varchar(255) NOT NULL DEFAULT '0',
`currency` varchar(5) NOT NULL DEFAULT 'USD',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_shop_purchases
-- ----------------------------
DROP TABLE IF EXISTS `cms_shop_purchases`;
CREATE TABLE `cms_shop_purchases` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`img` varchar(255) NOT NULL,
`price` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL DEFAULT 'USD',
`date_given` varchar(255) NOT NULL,
`delivered` varchar(1) NOT NULL DEFAULT '0',
`user_id` varchar(11) NOT NULL,
`donation` varchar(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_stats
-- ----------------------------
DROP TABLE IF EXISTS `cms_stats`;
CREATE TABLE `cms_stats` (
`user_peak` int(4) NOT NULL DEFAULT '0',
`rooms_peak` int(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_values
-- ----------------------------
DROP TABLE IF EXISTS `cms_values`;
CREATE TABLE `cms_values` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`thrones` varchar(11) DEFAULT NULL,
`dinos` varchar(11) DEFAULT NULL,
`img` varchar(500) DEFAULT NULL,
`last_edited` varchar(400) DEFAULT NULL,
`last_points` int(11) DEFAULT NULL,
`last_thrones` varchar(11) DEFAULT NULL,
`last_dinos` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cms_votes
-- ----------------------------
DROP TABLE IF EXISTS `cms_votes`;
CREATE TABLE `cms_votes` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`username` varchar(150) NOT NULL,
`timestamp` varchar(150) NOT NULL,
`ip_addr` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=367 DEFAULT CHARSET=utf8;

Download;


Let it be known; THERE IS NO HK FOR THIS.
Just setup BoostCMS/RevCMS on hk.domain.com and be done with it. I might release my HK too :)



 
Last edited:

JynX

Posting Freak
Feb 6, 2016
710
438
Great CMS, my only hate is the footer, but that's very very easily replacable, overall good job.
 

Rain

c
Mar 13, 2015
558
243
Oh. right, thanks.

Is it located in that "cdn" folder?
Be sure that this links to the CDN folder -

I did it like this as I host the css/js/images on and if i wanted to change where the images are hosted, it'd be nice to just change 1 config rather than like 20-30 html pages lol
 

Users who are viewing this thread

Top