[Release] Ascent Simple Cms V2

[sercankd]

Simple ascent Cms by Secorx (sercankd)

there is playertools (unstuck,lostpass,changepass,account upgrade/downgrade) , and News system,honor ranking, server status ,register page and admin panel inside
you can add your own pages and links in admin panel


for add item to top menu in header.tpl
put something like this
<li><a href="index.php?a=reg" accesskey="s"><em>S</em>ignup</a></li>

In V2
There is small server stats like stats.xml
Admin login password in different mysql table (no more 'az' flag for login)
Account Upgrade / Downgrade menu in player tools
code cleanup
you can edit title in config

Admin panel is yourwebsite/admin
Default Login is
Username: Admin
Password: Admin
you can change password in admin panel

Installation,
Run database.sql in ASCENT ACCOUNT DATABASE or it wont work with other dbs, you can this edit for yourself
setup config.php

Download link For V2
RapidShare: 1-Click Webhosting

Screenshots

[kanqaz]

nice. (space filler)

[sercankd]

fixed small admin login bug download and run sql again

[chronic7]

This is really nice looking I am going to download it and see how it is.
+rep given!

[chronic7]

Ok everything is working but I can't get into the admin panel. I am pretty sure I downloaded the most recent one when I ran the SQL query it wouldn't execute the post, news, or admin querys.

INSERT INTO `rp_news` VALUES (1, 'Installer', '2007-06-22 18:45:06', '<p>This post is just to make sure you have everything runing , you can either delete this post or edit it!</p>', 'Welcome!', 0, '');
INSERT INTO `rp_posts` VALUES (1, 'Installer', '2007-06-22 18:43:04', 'Put all the info to download the client for your server. You can also add patches and other stuff you desire.', 'Downloads', 1, '0');
INSERT INTO `rp_admin` VALUES (1, '21232f297a57a5a743894a0e4a801fc3', 1);

These querys do not work.

[sercankd]

try this query

CREATE TABLE `rp_links` (
`link_id` bigint(20) NOT NULL auto_increment,
`link_name` varchar(255) collate latin1_general_ci NOT NULL default '',
`link_target` varchar(25) collate latin1_general_ci NOT NULL default '',
`link_description` varchar(255) collate latin1_general_ci NOT NULL default '',
`link_visible` enum('Y','N') collate latin1_general_ci NOT NULL default 'Y',
PRIMARY KEY (`link_id`),
KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM;
CREATE TABLE `rp_news` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`post_author` bigint(20) NOT NULL default '0',
`post_date` datetime NOT NULL default '0000-00-00 00:00:00',
`post_content` longtext collate latin1_general_ci NOT NULL,
`post_title` text collate latin1_general_ci NOT NULL,
`post_class` int(4) NOT NULL default '0',
`comment_status` enum('open','closed') collate latin1_general_ci NOT NULL default 'open',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
CREATE TABLE `rp_posts` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`post_author` varchar(250) collate latin1_general_ci NOT NULL,
`post_date` datetime NOT NULL default '0000-00-00 00:00:00',
`post_content` longtext collate latin1_general_ci NOT NULL,
`post_title` varchar(255) character set utf8 collate utf8_spanish_ci NOT NULL,
`post_class` int(4) NOT NULL default '0',
`comment_status` enum('0','1') collate latin1_general_ci NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
CREATE TABLE `rp_admin` (
`id` int(32) NOT NULL auto_increment,
`username` varchar(64) NOT NULL,
`password` varchar(32) NOT NULL,
`admin` int(2) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO `rp_news` VALUES (1, 'Installer', '2007-06-22 18:45:06', '<p>This post is just to make sure you have everything runing , you can either delete this post or edit it!</p>', 'Welcome!', 0, '');
INSERT INTO `rp_posts` VALUES (1, 'Installer', '2007-06-22 18:43:04', 'Put all the info to download the client for your server. You can also add patches and other stuff you desire.', 'Downloads', 1, '0');
INSERT INTO `rp_admin` VALUES (1, 'Admin', '21232f297a57a5a743894a0e4a801fc3', 1);

[chronic7]

That is the exact same one.
Same errors.

[Err] 1366 - Incorrect integer value: 'Installer' for column 'post_author' at row 1
[Msg] Finished - Unsuccessfully

[chronic7]

and the unstuck feature doesn't seem to be working.