Skip to content

Instantly share code, notes, and snippets.

Created April 27, 2012 23:46
Show Gist options
  • Save anonymous/8972a8343c6fd2b878b1 to your computer and use it in GitHub Desktop.
Save anonymous/8972a8343c6fd2b878b1 to your computer and use it in GitHub Desktop.
$valid = true;
$max_post_per_day = 5;
$max_reply_per_day = 5;
//THE REGULAR COMMENTS STRUCTURE THAT IS SHOWING THE ERROR MESSAGE PROPERLY
$query = "SELECT COUNT(*) FROM `cysticBlogComments`
WHERE `userID` = $auth->id
AND `date` = CURDATE()";
$result = mysql_query($query, $connection);
$post_count = mysql_result($result, 0);
$error_msgs_max_comment[] = "Whoops! You have reached the maximum amount of comments allowed for the day.";
if($post_count >= $max_post_per_day)
{
$valid = false;
}
else
{
$query = "INSERT INTO `cysticBlogComments`
( `blogID`,
`userID`,
`commentBody`,
`status`,
`date`,
`time`
) VALUES (
'" . $blogID ."',
'" . $auth->id ."',
'" . mysql_real_escape_string($_POST['BlogComment']) ."',
'active',
'" . date("Y-m-d") . "',
'" . date("G:i:s") . "')";
mysql_query($query, $connection);
}
<?php if(isset($_POST['commentBlogSubmit']) && $post_count >= $max_post_per_day ) {
foreach($error_msgs_max_comment as $msg) { ?>
<div id="error_x">
<?php echo $msg; ?>
</div>
<?php }
}?>
//THE REPLY COMMENT STRUCTURE THAT IS LIMITING BUY NOT DISPLAYING ERROR AND HAS JQUERY WITH IT
$query = "SELECT COUNT(*) FROM `CysticBlogComments_replies`
WHERE `FromUserID` = $auth->id
AND `date` = CURDATE()";
$result = mysql_query($query, $connection);
$post_count = mysql_result($result, 0);
$error_msgs_max_reply[] = "Whoops! You have reached the maximum amount of replies allowed for the day.";
if($post_count >= $max_reply_per_day)
{
$valid = false;
echo $error_msgs_max_reply;
}
else
{
$query = "INSERT INTO `CysticBlogComments_replies`
( `BlogCommentID`,
`FromUserID`,
`comment`,
`status`,
`date`,
`time`
) VALUES (
'" . mysql_real_escape_string($_POST['comment']) ."',
'" . $auth->id ."',
'" . mysql_real_escape_string($_POST['reply'])."',
'active',
'" . date("Y-m-d") . "',
'" . date("G:i:s") . "')";
mysql_query($query, $connection);
}
<?php if(isset($_POST['sub_comment_reply']) && $post_count >= $max_reply_per_day ) {
foreach($error_msgs_max_reply as $msg) { ?>
<div id="error_x">
<?php echo $msg; ?>
</div>
<?php }
}?>
//THE JS FOR THE REPLIES
<script type="text/javascript">
$(document).ready( function() {
$.localScroll({ offset:{top:-40,left:0} });
$("a.reply_link").click( function() {
$("#"+$(this).attr('name')).fadeIn('slow');
});
$(".respond_nevermind a").click( function(event) {
event.preventDefault();
var reply_box = document.getElementById($(this).attr('href'));
$(reply_box).css('display','none');
var reply_textarea = document.getElementById($(this).attr('href')+"_textarea");
$(reply_textarea).val('');
});
});
</script>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment