[Release] Ascent/Antrix Web CMS by AxE

[Mango Jerry]

I have released this edition of CMS for public might be useful for some of you.
Credits: AXE

[i]Rapidshare link (v1.0):
RapidShare: Easy Filehosting

Additional files (psd and other):
Filebeam - Free Fast File Hosting
pass: mystika-wow.com

Account Updater Tool (used for copy/synchronize existing ascent accounts with cms/web account db ):
Filebeam - Free Fast File Hosting

UPDATE FROM v1.0 TO v1.1:
(copy content of .rar archive to htdocs/ folder):
Filebeam - Free Fast File Hosting

example of this site: SoulBound WoW - Official SoulBound WoW private server site - Top WoW private server, Lag-Free, Great Up-Time, Friendly GMs, Less Bugs, Ascent Emulator

Hope you will enjoy it.
This CMS mast be installed where server is running because it is strictly connected to antrix database.

Features:
- creating account for forum/site and server in same time
- gaining points, reputation for voting
- voting system
- spending points gained to buffs ingame script
- earning gold from voting
- automatic character perview in posts (level rank avatar etc)
- selecting different characters for forum purposes
- gaining and updating PVP rank to characters (this is becouse pvp rank system doesn't work with antrix 2.3.x, dunno for new versions)
- char unctucker+reviver, teleporter, ban checker
- online live map, map of STV City and Orgrimmar
- users online script (like SPORA) and front page live user online script (extract directly from stats.xml)
- top 5 pvp script (thiese blocks can easily be removed or added)
- block that shows u friend status ingame
- online shop (spend your voting points for items and mail them to yourself ingame)
- admin panel that controls items in shop, forum, users, news at the front page
- shoutbox
- invite a friend script

Version 1.1
- fixed friend block problem
- removed google ads
- removed my urchin tracker code
- fully compatible with 2.4.x antrix database


Any questions about how to setup or additional technical info ask here, ill try to answer all.

I'm aware that there is still some glitches in the page, there is some minor design errors.

to make server status work, make sure you put in ascent cofig right path to stats.xml
for example: c:\xampp\htdocs\stats.xml


Installation Guide:

1. Install xampp web server and sql (comes with it)
( I will assume you know what to do and how to locate htdocs folder )

2. Open /htdocs/ and extract inside files from .rar file you downloaded
( only ones inside htdocs/ folder )
Download all updates (link are above) and extract all new updated files

3. Install sqljog or navicat sql client/editor or whatever you use

4. Open for example sqljog and create new database (you can name it "forum"), import structure data to that database from sql dump file (htdocs/forum/database.sql)
WANNING: You mast install empty wow database, without accounts or characters, this is because registration is creating forum and server account at the same time.

5. Edit this 3 files:
htdocs/forum/connect.php
htdocs/forum/admin/connect.php
htdocs/forum/admin/var.php
In each one follow instructions that are provided, mostly database username, password, database name ("forum") and logon database.
To ensure this will work make sure you put characer_structure and logon_structure to same database. And world to seperate (can be same).

6. After you carefully configured all right information, next step is creating a administrator account.
Open your adress in the web browser, probably its localhost so its:
http://localhost/forum/register.php
Now register new account.

7. You mast now open sqljog (or whatever), find "forum" database, find "b_users" table and browse it. You will see 1 row (your account), find column "status" and change ur value to "4" (grats ur a admin now).
Values overview:
0 - Normal Players
1 - GM's -- Can edit, delete, and move threads
2 - Supermoderators -- Can do what moderators can do and post stickies and ban people
3 - Admin -- All supermod functions plus access to admin cp
4 - Head admin (you) -- Admin function but you are the only one that can delete, edit other admin accounts.

8. You can now go to http://localhost/home.php and check the cms out, you will notice that blocks look weird, this is because there is no content inside the news block. (go to admin panel to add news).

9. PvP Block
- when no data to display it looks wierd
- shows only the characters that belong to people that are common players (not GM's)
- shows pvp rank, online/offline atm, level, race, class etc

fixed database.sql (import with sqljog or navicat or whatever):



Code:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: forum
Target Host: localhost
Target Database: forum
Date: 6/17/2008 7:40:29 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for b_banemails
-- ----------------------------
CREATE TABLE `b_banemails` (
`emailid` bigint(20) NOT NULL auto_increment,
`email` varchar(255) NOT NULL default '',
PRIMARY KEY (`emailid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_banip
-- ----------------------------
CREATE TABLE `b_banip` (
`ipid` bigint(20) NOT NULL auto_increment,
`ip` varchar(255) NOT NULL default '',
PRIMARY KEY (`ipid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_categories
-- ----------------------------
CREATE TABLE `b_categories` (
`categoryid` bigint(20) NOT NULL auto_increment,
`categoryname` varchar(255) NOT NULL default '',
`catsort` bigint(20) NOT NULL default '0',
PRIMARY KEY (`categoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_comments
-- ----------------------------
CREATE TABLE `b_comments` (
`id` bigint(20) NOT NULL auto_increment,
`poster` varchar(255) collate latin1_general_ci NOT NULL,
`content` text collate latin1_general_ci NOT NULL,
`newsid` int(11) NOT NULL,
`timepost` varchar(100) collate latin1_general_ci NOT NULL,
`datepost` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for b_forums
-- ----------------------------
CREATE TABLE `b_forums` (
`ID` bigint(20) NOT NULL auto_increment,
`parentID` bigint(20) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`description` tinytext NOT NULL,
`numtopics` bigint(20) NOT NULL default '0',
`numposts` bigint(20) NOT NULL default '0',
`lastpost` varchar(255) NOT NULL default '',
`sort` bigint(20) NOT NULL default '0',
`ficon` bigint(20) NOT NULL default '0',
`lastpostuser` varchar(255) NOT NULL default '',
`permission_min` int(11) NOT NULL default '0',
`permission_post` int(11) NOT NULL default '0',
`permission_reply` int(11) NOT NULL default '0',
`lastposttime` bigint(20) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_friends
-- ----------------------------
CREATE TABLE `b_friends` (
`id` bigint(21) NOT NULL auto_increment,
`userid` bigint(21) NOT NULL,
`link1` tinytext collate latin1_general_ci NOT NULL,
`link2` tinytext collate latin1_general_ci NOT NULL,
`link3` tinytext collate latin1_general_ci NOT NULL,
`link4` tinytext collate latin1_general_ci NOT NULL,
`link5` tinytext collate latin1_general_ci NOT NULL,
`ip` tinytext collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for b_games
-- ----------------------------
CREATE TABLE `b_games` (
`id` int(22) NOT NULL auto_increment,
`username` varchar(44) collate latin1_general_ci NOT NULL default 'Guest',
`roulette1` int(12) NOT NULL default '0',
`roulette2` int(12) NOT NULL default '0',
`roulette3` int(12) NOT NULL default '0',
`roulette4` int(12) NOT NULL default '0',
`roulette5` int(12) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for b_news
-- ----------------------------
CREATE TABLE `b_news` (
`id` bigint(20) NOT NULL auto_increment,
`title` varchar(255) collate latin1_general_ci NOT NULL,
`content` longtext collate latin1_general_ci NOT NULL,
`iconid` int(11) NOT NULL,
`timepost` varchar(100) collate latin1_general_ci NOT NULL,
`datepost` varchar(100) collate latin1_general_ci NOT NULL,
`author` varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for b_pms
-- ----------------------------
CREATE TABLE `b_pms` (
`pmID` bigint(20) NOT NULL auto_increment,
`sender` bigint(20) NOT NULL default '0',
`receiver` bigint(20) NOT NULL default '0',
`therealtime` bigint(20) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`message` mediumtext NOT NULL,
`hasread` int(11) NOT NULL default '0',
`vartime` varchar(255) NOT NULL default '',
PRIMARY KEY (`pmID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_posts
-- ----------------------------
CREATE TABLE `b_posts` (
`ID` bigint(21) NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`author` bigint(20) NOT NULL default '0',
`telapsed` bigint(21) NOT NULL default '0',
`timepost` varchar(100) NOT NULL default '',
`numreplies` int(10) NOT NULL default '0',
`post` longtext NOT NULL,
`threadparent` bigint(21) NOT NULL default '0',
`lastpost` varchar(255) NOT NULL default '',
`postforum` bigint(20) NOT NULL default '0',
`views` bigint(20) NOT NULL default '0',
`nosmilies` int(11) NOT NULL default '0',
`value` int(11) NOT NULL default '0',
`ipaddress` varchar(255) NOT NULL default '',
`locked` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_ranks
-- ----------------------------
CREATE TABLE `b_ranks` (
`rankID` bigint(20) NOT NULL auto_increment,
`rankname` varchar(255) NOT NULL default '',
`postsneeded` bigint(20) NOT NULL default '0',
PRIMARY KEY (`rankID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_shop
-- ----------------------------
CREATE TABLE `b_shop` (
`id` int(11) NOT NULL auto_increment,
`sep` varchar(3) collate latin1_general_ci NOT NULL default '0',
`name` text collate latin1_general_ci NOT NULL,
`itemid` varchar(20) collate latin1_general_ci NOT NULL,
`color` tinytext collate latin1_general_ci NOT NULL,
`cat` varchar(20) collate latin1_general_ci NOT NULL default '0',
`sort` varchar(10) collate latin1_general_ci NOT NULL default '0',
`cost` varchar(11) collate latin1_general_ci NOT NULL default '0',
`charges` varchar(11) collate latin1_general_ci NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for b_templates
-- ----------------------------
CREATE TABLE `b_templates` (
`templateid` bigint(20) NOT NULL auto_increment,
`templatepath` varchar(255) NOT NULL default '',
PRIMARY KEY (`templateid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_users
-- ----------------------------
CREATE TABLE `b_users` (
`userID` bigint(21) NOT NULL auto_increment,
`username` varchar(60) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`status` int(20) NOT NULL default '0',
`posts` bigint(20) NOT NULL default '0',
`email` varchar(255) NOT NULL default '',
`validated` int(11) NOT NULL default '0',
`keynode` bigint(21) NOT NULL default '0',
`sig` tinytext,
`banned` varchar(255) NOT NULL default 'No',
`rank` varchar(255) NOT NULL default '0',
`usepm` int(11) NOT NULL default '1',
`AIM` varchar(50) NOT NULL default '',
`ICQ` varchar(50) NOT NULL default '',
`location` varchar(255) NOT NULL default '',
`showprofile` smallint(6) NOT NULL default '1',
`lastposttime` bigint(20) NOT NULL default '0',
`tsgone` bigint(20) NOT NULL default '0',
`oldtime` bigint(20) NOT NULL default '0',
`avatar` varchar(255) NOT NULL default '',
`photo` varchar(255) NOT NULL default '',
`rating` bigint(255) NOT NULL default '0',
`totalvotes` bigint(20) NOT NULL default '0',
`votedfor` longtext,
`rps` int(11) NOT NULL default '1',
`friend` int(11) NOT NULL default '3',
`lasttime` bigint(20) NOT NULL default '0',
`templateclass` bigint(20) NOT NULL default '1',
`charid` bigint(20) default NULL,
`honours` bigint(255) NOT NULL default '0',
`points` bigint(255) NOT NULL default '0',
`ranktitle` varchar(255) NOT NULL default 'No Rank',
`ranknum` int(11) NOT NULL default '0',
`buff` bigint(255) NOT NULL default '0',
`money` bigint(255) NOT NULL default '0',
`pprof1` varchar(150) NOT NULL default 'Verdana, Arial, Helvetica, sans-serif',
`pprof2` varchar(100) NOT NULL default '#cccccc',
PRIMARY KEY (`userID`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for b_vote
-- ----------------------------
CREATE TABLE `b_vote` (
`id` bigint(21) NOT NULL auto_increment,
`userid` bigint(21) NOT NULL,
`siteid` bigint(21) NOT NULL,
`timevoted` bigint(21) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `b_templates` VALUES ('1', 'default');
INSERT INTO `b_users` VALUES ('43', '', '', '0', '0', '', '0', '0', null, 'No', '0', '1', '', '', '', '1', '0', '0', '0', '', '', '0', '0', null, '1', '3', '0', '1', null, '0', '0', 'No Rank', '0', '0', '0', 'Verdana, Arial, Helvetica, sans-serif', '#cccccc');
------------------------------------------------------------------

[ungodlywow]

AMAZING, but can you 2nd party host it, my server is dedicated hosted. But my website is hosted on a hosting account from bluehost, can i still use this all its functions?

[Bioz]

Thanks alot for sharing this, looks awesome! +Rep

[Yiddus]

I dont know why, but my voting panel does not want to work!

Instead of going to vote for xtremetop100

is goes to this link

http://wowlight.aidanwilson.com/vote...ite=1132245823

Which is obviously wrong because it jsut adds XtremeTop100.com - Gaming top 100 list to http://wowlight.aidanwilson.com/vote/?vote=

Also there are soem images that could do with editing for other peoples servers such as the realm name in the "Status" section.

Another thing. I do not know how to get the pvp System to work. It jsut doesn't show anything at all.

On top of that said I give you +rep for the great release. It looks really good, very professional and smooth.