Herro, this is a re-release; Edit of
(
http://forum.ragezone.com/f353/zcms-...secure-781429/). In my words a more safer release and edit.
All-ready known and added Features included:
- Set friend requests on/off
- Redeem gold bars by the hundreds on the site rather than manually on the client
- Fully functioning housekeeping
- Exploit secured , as far as Jonty knew.
Those we're some of the features, to name a few.
What Iv'e Fixed in this edit, is;
Let's start off with exploit's.
- Filtered the avatar name exploit FROM REGISTER.PHP
- Filtered password detail for Housekeeping login page.
- Remove unwanted pages etc.
- Removed Tag exploit with some help from Nominal
Fixes via the Database:
I managed to
- Fixed & Optimized & Updated database, fixed and added lost columns that were needed & missing due to Jonty's mistakes.
That's all the database really needed. :lol:
Fixes via CMS:
- adding trade enabled on me.php
- Added Auto Webbuild works 100% (Tested)
- Cleaned some Housekeeping files
- CODED BADGESHOP TO WORK W/CREDITS & NOT POINTS! AS THEY WE'RE SET TO..
- Added new ZapASE Housekeeping Style :/:
That's all I basically did to stabilize this edit a bit more, nothing much. P.S;
if you find anything missing or exploitable i'll try and fix it to the best of my knowledge
Ok let's get started.
After you setup your retro make sure, to run these very
important codes!
PHP Code:
ALTER TABLE `users` ADD `forumname` VARCHAR( 50 ) NOT NULL AFTER `expert`
ALTER TABLE `users` ADD `expert` VARCHAR( 50 ) NOT NULL AFTER `vip`
PHP Code:
TRUNCATE TABLE `site_cron`
The codes basically fix register error most of you have been getting and Truncates site_cron table for cms to actually work 100%.
Next add this code:
PHP Code:
--
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Table structure for table `site_config`
--
CREATE TABLE IF NOT EXISTS `site_config` (
`maintenance` enum('0','1') NOT NULL DEFAULT '0',
`web_build` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `site_cron`
--
CREATE TABLE IF NOT EXISTS `site_cron` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`prio` int(11) NOT NULL DEFAULT '5',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`scriptfile` varchar(50) NOT NULL,
`last_exec` int(11) NOT NULL,
`exec_every` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `site_hotcampaigns`
--
CREATE TABLE IF NOT EXISTS `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',
`IMG_url` text NOT NULL,
`caption` text NOT NULL,
`descr` text NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `site_minimail`
--
CREATE TABLE IF NOT EXISTS `site_minimail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sender_id` int(10) unsigned NOT NULL,
`receiver_id` int(10) unsigned NOT NULL,
`folder` enum('inbox','sent','trash') NOT NULL DEFAULT 'inbox',
`is_read` enum('0','1') NOT NULL DEFAULT '0',
`subject` varchar(120) NOT NULL,
`date` varchar(120) NOT NULL,
`isodate` varchar(120) NOT NULL,
`timestamp` int(11) NOT NULL,
`body` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7075 ;
-- --------------------------------------------------------
--
-- Table structure for table `site_navi`
--
CREATE TABLE IF NOT EXISTS `site_navi` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`order_id` int(11) NOT NULL,
`caption` text NOT NULL,
`class` text NOT NULL,
`url` text NOT NULL,
`visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
-- --------------------------------------------------------
--
-- Table structure for table `site_news`
--
CREATE TABLE IF NOT EXISTS `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_IMG` text NOT NULL,
`body` text NOT NULL,
`snippet` text NOT NULL,
`datestr` varchar(50) NOT NULL,
`timestamp` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
-- --------------------------------------------------------
--
-- Table structure for table `site_news_categories`
--
CREATE TABLE IF NOT EXISTS `site_news_categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`caption` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `site_news_comments`
--
CREATE TABLE IF NOT EXISTS `site_news_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`article` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`comment` varchar(500) NOT NULL,
`posted_on` varchar(150) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1525 ;
If any code is not working just download database
HERE and everything should work 100%
For badgeshop, just edit badge prices and badge code's in Database, Iv'e coded it 2 work with Credits and not points as I don't understand how Points work :blushing: :lol: but enway Yeah..
A Few IMGs:
http://img.sharefast.net/1324394842755943402132.jpg
http://img.sharefast.net/1324394900637908763921.png
http://img.sharefast.net/1324394920370761452436.png
http://img.sharefast.net/1324394980124442787507.png
http://img.sharefast.net/1324394978105560483897.png
http://img.sharefast.net/1324395031286327265835.png
http://img.sharefast.net/1324395033999328821585.png
http://img.sharefast.net/1324395092431350926659.png
http://img.sharefast.net/1324395223446243471562.png
http://img.sharefast.net/1324398454916381991995.png
Well that's it for now, I maybe updating this, not sure yet but if you need any help with anything consisting to this cms feel free to ask below. (READ the README.txt)
DOWNLOAD
Le' Credits!
Meth0d: 50%
Jonty: 40%
Subway: 10%
Anything custom or w/e you will have to add yourself, just a edit of it nothing much :thumbup:
