Secure, Simple CMS with Housekeeping?

[ColourfulConnor]

I've been trying to find a secure, simple cms with housekeeping for ages! I've been download this and that, I was hoping to get a basic revcms with housekeeping because I'd want to edit it up on my own but I can't find one! Anyone got any ideas?

 

[LeChris]

Retaliation series can be modified to support regular hotels.

 

[Xuxu]

You must be registered for see links

 

[ColourfulConnor]

You must be registered for see links

Thank you so much! That's exactly what I wanted, just a template to style up y'know? Anyway Thanks!

Some parts of it aren't working, I can't delete or post news articles, do you know where I could get the sqls for this?

 

[Xuxu]

Thank you so much! That's exactly what I wanted, just a template to style up y'know? Anyway Thanks!

Some parts of it aren't working, I can't delete or post news articles, do you know where I could get the sqls for this?

if u want i can teamviewer you and fix as many problems u have as i can

you don't need an sql but to post an article you need a few columns
published
campaign
campaignimg

add these columns to your cms_news table and to delete an article just delete it in the database

 

[Joe]

If you're using Sledmore's Plus DB it probably doesn't have this.

Spoiler: cms_news.sql

-- ----------------------------
-- 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,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

[ColourfulConnor]

If you're using Sledmore's Plus DB it probably doesn't have this.

Spoiler: cms_news.sql

-- ----------------------------
-- 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,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

oh, that fixed it up, thanks! c:

 

[Xuxu]

plus is missing campaign, campaignimg and published by default so i was correct as well lol but u probably went with JMG's because u dont know how to add a simple column to your database

 

[ColourfulConnor]

plus is missing campaign, campaignimg and published by default so i was correct as well lol but u probably went with JMG's because u dont know how to add a simple column to your database

Yeeah.. I'm pretty new to this, I'm learning though(hopefully),

 

[Joe]

Thread cleaned.

This is a help section, if you're not going to attempt to help then simply do not comment unrelated, off topic spam.