[RELEASE] Antrix web CMS by AXE Ascent 

for the people who is getting the field sig doesnt have a default value...

replacce ur forum database with the one i attached and it should work.


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');
INSERT INTO `b_users` VALUES ('44', 'lawlzz', 'f9c17501946a5e67983f77d7cb692608', '0', '0', '[email protected]', '1', '0', null, 'No', '0', '1', '', '', '', '1', '0', '1213756727', '0', '', '', '0', '0', null, '1', '3', '1213756739', '1', '0', '0', '0', 'No Rank', '0', '0', '0', 'Verdana, Arial, Helvetica, sans-serif', '#cccccc');

just put that in a txt doc and rename forum.sql
 
I just turned the server ON. But in mainpage in status shows that the server is ON 2 days, 9 hours, 58 minutes, 17 seconds. I have 0 players online, but it shows 3 online players. What's wrong?
you didn't configure path to stats.xml in ur server configuration file
 
Emm.. Can you remind me where should i configure that, please?
ascent-world.conf -file change next line to path where your stats.xml is located (C:\xampp\htdocs\stats.xml for me):
Code:
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Status Dumper Config
#
#        These directives set up the status dumper plugin. Filename is an
#        absolute or relative path to the server binary. Interval is the
#        time that the stats will be dumped to xml.
#        Default: stats.xml / 120000 (2 minutes)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

StatDumper FileName = "stats.xml" Interval = "120000"
 
i can log of fine and access the forums...
but when others log on they say it redircts them to the forums and they are not logged on.

matrocity.has.it
acc: test
Pass: test
 
Something is strange. When i log in with my account, and when i press on some one's name. Opens user's profile. I go back to forum. And what do i see? I see that somehow i logged in with that user's name.
WTF?
this is known bug that happening on linux host server
 
i get this error : Could not get user info , when i login . i can see only half of the page and not fully loaded. what's the problem ? check it out :
 
Hi

Is there some one that can help me with my website?

If some one have's problems with his password for login to the website, normaly you must see an page that you signon is failed only by my website is it empty, you don't see any thing.



:smilie_xp
 
Alright first of all i added a new realm to my server, but to do this i had to move my accounts table from the logon db to its own db named accounts so that both realms could connect to that accounts table. But in doing this i can't register on my site because the register page still points to the logon.accounts, i want to change the register config to point to accounts.accounts. I'm thinking i have to add something like this $accountsdb="accounts" to the connect.php, and change the register page to have that also. Another thing with moving the accounts table is that the server status box on the homepage doesnt work, all it says "not able to connect to logon.accounts"; i also want to fix that. I know i'm asking for a lot lol, but any help is appreciated; Thanks ahead of time.
 
Back