Build a [url removed, login to view] style comment system with ajax pagination and submission for [url removed, login to view] (i.e. no page refresh necesary for comment submission and pagination).
Game pages run simple login script from [url removed, login to view] that populates
Please refer to attached Simple Login [url removed, login to view] for more info on the plugin used to handle user sessions.
Suggested comment table structure (may be changed by developer if necessary)
CREATE TABLE IF NOT EXISTS `gamescomments` (
`c_id` int(15) NOT NULL auto_increment,
`c_gamesid` int(10) default NULL,
`c_status` enum('active','waiting','reported') NOT NULL default 'waiting',
`c_reportcounts` int(5) default NULL,
`c_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`c_userid` int(10) default NULL,
PRIMARY KEY (`c_id`),
KEY `c_gamesid` (`c_gamesid`,`c_status`,`c_userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Only registered, logged in users may post comments.
Also required, an administration page to approve or delete comments. Inline deletion of comments should also be available for specified user groups (Admin and Super Moderators).
Comments are default 'waiting' unless posted by trusted users in specified usergroups.
Comments are only displayed if 'active' or to user who posted the comments (this is to prevent double posting by users who think their comments are not received).
Comments reported by users "X" times are flagged as reported and require approval by moderators again for viewing.