Unreal Tournament 99 and 2k4 Gaming Site

New Member Joined: Apr 18, 2006 Posts: 5

This is a site I set up less than a year ago for Unreal Tournament. It's been doing great.

http://www.dfbutclan.com

I have been thinking about changing this site to Raven Nuke after recently getting hacked but i'm waiting for the next release..

I have recently switched one of my other sites over to the most current raven nuke to test how hard it will be to convert from 7.6 to Ravens 7.6 so far most of the bugs are worked out http://turdinc.kicks-ass.net/phpNuke/html/index.php just a few odd things like polls and admin messages not working correctly.

Anyway if your into Unreal Tournament 99 or 2K4 stop by and play a few games with us.. We play sniper style. We also have a BF2 server if your into that.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Thanks for the info. Can you be more specific about the things not working correctly?

Posted: Tue Apr 18, 2006 6:16 pm

Well for the polls everything seems ok but when you vote it doesn't get counted. I imported my old polls but I don't think thats why this is happening.

And when I add a new admin message I just get a blank page or if I try to edit the default admin message that comes with raven nuke the changes don't save. I have to edit it from phpmyadmin for it to work.

Posted: Tue Apr 18, 2006 6:22 pm

Sounds like a problem with the poll results and messages tables. Can you post the structures here?

Posted: Tue Apr 18, 2006 9:23 pm

Ok here ya go.. I didn't see anything that said poll results so I'm posting the structure for all 4 poll tables that I have and the one nuke_message table.

--
-- Table structure for table `nuke_message`
--

CREATE TABLE `nuke_message` (
`mid` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`content` text NOT NULL,
`date` varchar(14) NOT NULL default '',
`expire` int(7) NOT NULL default '0',
`active` int(1) NOT NULL default '1',
`view` int(1) NOT NULL default '1',
`mlanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Table structure for table `nuke_poll_check`
--

CREATE TABLE `nuke_poll_check` (
`ip` varchar(20) NOT NULL default '',
`time` varchar(14) NOT NULL default '',
`pollID` int(10) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `nuke_poll_data`
--

CREATE TABLE `nuke_poll_data` (
`pollID` int(11) NOT NULL default '0',
`optionText` char(50) NOT NULL default '',
`optionCount` int(11) NOT NULL default '0',
`voteID` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `nuke_poll_desc`
--

CREATE TABLE `nuke_poll_desc` (
`pollID` int(11) NOT NULL auto_increment,
`pollTitle` varchar(100) NOT NULL default '',
`timeStamp` int(11) NOT NULL default '0',
`voters` mediumint(9) NOT NULL default '0',
`planguage` varchar(30) NOT NULL default '',
`artid` int(10) NOT NULL default '0',
PRIMARY KEY (`pollID`),
KEY `pollID` (`pollID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Table structure for table `nuke_pollcomments`
--

CREATE TABLE `nuke_pollcomments` (
`tid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`pollID` int(11) NOT NULL default '0',
`date` datetime default NULL,
`name` varchar(60) NOT NULL default '',
`email` varchar(60) default NULL,
`url` varchar(60) default NULL,
`host_name` varchar(60) default NULL,
`subject` varchar(60) NOT NULL default '',
`comment` text NOT NULL,
`score` tinyint(4) NOT NULL default '0',
`reason` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`tid`),
KEY `tid` (`tid`),
KEY `pid` (`pid`),
KEY `pollID` (`pollID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

Posted: Tue Apr 18, 2006 10:17 pm

Try this for the messages: In your SQL client (e.g. phpMyAdmin), run this SQL statement:

Code:

ALTER TABLE `nuke_message` ADD `groups` TEXT NOT NULL AFTER `view` ;

Posted: Tue Apr 18, 2006 10:22 pm

Can't see any structural issues with the poll tables, except that the charsets are UTF...not sure why, but that might have an impact.

Posted: Wed Apr 19, 2006 5:50 am

Yep, that worked for nuke_messages!! Thanks alot for all your help!!

Posted: Wed Apr 19, 2006 12:01 pm

Cool!
Been a while since I gave UT 2004 a hammering but now I have a shiny new graphics card............
Thanks for the reminder!

Posted: Tue Apr 25, 2006 1:13 pm

Updated my Unreal Tournament site the other day to Raven's latest! It went without a hitch!! Thank You Raven and all involved! Keep up the great work. Already busted 2 hacker attempts!

Posted: Tue Apr 25, 2006 10:31 pm

Thats great news matt.