uberCMS/rCMS [PHP,OOP] Fixed Updated [Phoenix]

[Subway]

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:

• Change Password

• 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.

• Took out motto Exploit

• 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.

Fixes via CMS:

• adding trade enabled on me.php

• fixed sign out glitch

• Added Auto Webbuild works 100% (Tested)

• Cleaned some Housekeeping files

• Added a new X-mas-Index

• 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!

ALTER TABLE  `users` ADD  `forumname` VARCHAR( 50 ) NOT NULL AFTER  `expert`
ALTER TABLE  `users` ADD  `expert` VARCHAR( 50 ) NOT NULL AFTER  `vip` 

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:

--
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 but enway Yeah..

A Few IMGs:





















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

[MentaL]

[Squard]

You got my vote :) NICE 9.8/10

[Joopie]

Looks like my admin login...


But looks nice didn't view the source yet

[Subway]

Do you mean Index or Housekeeping? I didn't make any of them, just added them in thought there we're cooler than the previous version

[Livar]

So hawt.

[Joopie]

Do you mean Index or Housekeeping? I didn't make any of them, just added them in thought there we're cooler than the previous version

http://forum.ragezone.com/f353/uberc...egecms-748143/

And, Also can you upload a version without swfs ;/
It's annoying....

[Subway]

This doesn't have swf's init^ just badge directory, for badgeshop.
And dunno iLost made the style for Housekeeping.

[Legendaric]

I like this one!

Uhm, database is not working?

[Subway]

Works fine for me, did you edit it from test to w.e your db is named?

[azaidi]

This looks very very nice! I'll try it out tomorrow for sure :D

10/10. I always wanted a working zCMS.

[Legendaric]

[Subway]

Remove the Ach_code then or use this: uber-phoenx2 (12).sql

and execute codes in thread^ and add this code for badge shop :

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50511
Source Host           : 10.4.28.54:41752
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50511
File Encoding         : 65001

Date: 2011-04-12 23:51:13
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `badge_shop`
-- ----------------------------
DROP TABLE IF EXISTS `badge_shop`;
CREATE TABLE `badge_shop` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `badge_id` varchar(6) NOT NULL,
  `cost` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of badge_shop
-- ----------------------------
INSERT INTO `badge_shop` VALUES ('1', 'BOT', '2');
INSERT INTO `badge_shop` VALUES ('2', 'HS1', '1');
INSERT INTO `badge_shop` VALUES ('3', 'RU3', '2');
INSERT INTO `badge_shop` VALUES ('4', 'MTV02\r', '2');
INSERT INTO `badge_shop` VALUES ('5', 'VA014', '2');
INSERT INTO `badge_shop` VALUES ('6', 'EXE000', '2');
INSERT INTO `badge_shop` VALUES ('7', 'BRA08', '2');
INSERT INTO `badge_shop` VALUES ('8', 'BR131', '2');
INSERT INTO `badge_shop` VALUES ('9', 'BR137', '2');
INSERT INTO `badge_shop` VALUES ('10', 'NOC', '1');
INSERT INTO `badge_shop` VALUES ('11', 'SG4', '2');
INSERT INTO `badge_shop` VALUES ('13', 'FAN', '6');
INSERT INTO `badge_shop` VALUES ('14', 'LLL', '2'); 

And just edit values to yours

[Legendaric]

Thanks <3

[Spheral]

This has helped me fix my CMS. Thankyou.

[Subway]

Great,Thanks!