Unreal Tournament 99 and 2k4 Gaming Site

mattman · 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.

Only registered users can see links on this board!
Get registered or login to the forums!

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

Only registered users can see links on this board!
Get registered or login to the forums!

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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

mattman · New Member Joined: Apr 18, 2006 Posts: 5

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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

mattman · New Member Joined: Apr 18, 2006 Posts: 5

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 ;

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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` ;

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4853

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.

mattman · New Member Joined: Apr 18, 2006 Posts: 5

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

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

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

mattman · New Member Joined: Apr 18, 2006 Posts: 5

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!

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4821

Thats great news matt.