PlaySro Full Website [PHP]

[interpol]

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

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

query gives errors

[eXpL0ST]

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

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

Please help not work :S

[stefan185]

any one can re upload please ?