This website is working but u need something to edit in your apache and by creating a mysql database name to sro.
Here is the tables in sro database
Code:
CREATE TABLE `coins` (
`id` int(11) NOT NULL,
`pc` int(11) NOT NULL default '0',
`vp` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`type` tinyint(4) NOT NULL,
`body` varchar(2048) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `news` VALUES (1, 'RageZone', 'Posted By PX2000', 1, 'Hello world!');
CREATE TABLE `online` (
`Server` varchar(100) NOT NULL,
`Online` int(11) NOT NULL,
PRIMARY KEY (`Server`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `online` VALUES ('ServerName', 0);
CREATE TABLE `ref_hits` (
`id` int(11) NOT NULL,
`clicks` int(11) NOT NULL default '0',
`registers` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ref_ip` (
`ip` varchar(15) NOT NULL,
`target` int(11) NOT NULL,
UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `vote` (
`id` int(11) NOT NULL,
`t1` int(11) NOT NULL,
`t2` int(11) NOT NULL,
`t3` int(11) NOT NULL,
`t4` int(11) NOT NULL,
`t5` int(11) NOT NULL,
`t6` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `vote2` (
`ip` varchar(15) NOT NULL,
`t1` int(11) NOT NULL default '0',
`t2` int(11) NOT NULL default '0',
`t3` int(11) NOT NULL default '0',
`t4` int(11) NOT NULL default '0',
`t5` int(11) NOT NULL default '0',
`t6` int(11) NOT NULL default '0',
PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Sample