One comment Per Game

[Danny]

Noticed the game commenting system can be quite spammy, so i put this in place so you can only comment once on each game.

open play.php in the pages dir.
Find:

Code: [Select]

$commenter = $usrdata['userid'];
$gameid = $ID;
$comment = clean($_POST['comment']);
$date = time();
if($autoapprovecomments == 1){
$approved = 1;
}else{
$approved = 0;
}
$db->query(sprintf('INSERT INTO dd_comments SET
gameid=\'%u\',
commenter=\'%u\',
comment=\'%s\',
date=\'%u\',
approved=\'%u\'
', $ID, $commenter, $comment, $date, $approved));
if($autoapprovecomments == 1){
$msgcom = 'Comment Posted.';
}else{
$msgcom = 'Comment Posted, Awaiting admin approval.';
}
echo '<div class=\'msg\'>'.$msgcom.'</div><br />';
}
Replace with:

Code: [Select]

if(!isset($userid)){
echo 'Please login first.';
exit;
}
if($_SESSION['ALREADYCOMMENTED'] != $ID){
$commenter = $usrdata['userid'];
$gameid = $ID;
$comment = clean($_POST['comment']);
$date = time();
if($autoapprovecomments == 1){
$approved = 1;
}else{
$approved = 0;
}
$db->query(sprintf('INSERT INTO dd_comments SET
gameid=\'%u\',
commenter=\'%u\',
comment=\'%s\',
date=\'%u\',
approved=\'%u\'
', $ID, $commenter, $comment, $date, $approved));
if($autoapprovecomments == 1){
$msgcom = 'Comment Posted.';
}else{
$msgcom = 'Comment Posted, Awaiting admin approval.';
}
echo '<div class=\'msg\'>'.$msgcom.'</div><br />';
$_SESSION['ALREADYCOMMENTED'] = $ID;
}
}
Now, you have to be loggedin, and only allow one comment per game.

[maverick]

syntax error on line 168

[Danny]

Sorry about that. Fixed the code.