<?PHP include("config.php"); if(is_logged_in($user)){ $username = base64_decode($_SESSION['user']); if($username != "Slowman" && $username != "Rappstar" && $username != "Herbert") { header('Location: '.$site_url); exit(); } } else { header('Location: '.$site_url); exit(); } // Query to fetch non-validated races: $results = mysql_query("SELECT * FROM ".$prefix."TriclubsComment WHERE comment_valid = 0 ORDER BY comment_time DESC") OR die(mysql_error()); // check to see if set is empty $none = FALSE; if (mysql_num_rows($results) == 0) { $none = TRUE; } // set the page title $pagetitle = "Admin: Comment Validation"; // set meta tags $meta_keywords = ""; $meta_description = ""; ?> <? include("include_common_head.php"); ?> <? include("include_common_content.php"); ?> <!-- Start outer --> <div id="outer"> <!-- BODY --> <div class="content"> <!-- LEFT COLUMN --> <!-- End left column --> <!-- Content col --> <h1 class="content-title"><strong>Unvalidated Comments</strong></h1> <form method="post" action="comments_validate_X.php" enctype="multipart/form-data"> <div class="indent"> <? if($none == TRUE){ echo "There are no comments waiting to be validated."; } ?> <table border="0" cellspacing="1" cellpadding="1" width="100%"> <? $x = 0; while($arrComments = mysql_fetch_array($results)){ $x++; if($x % 2 == 0){ $bg = '#cecece'; }else{ $bg = '#ececec'; } $arrCommenters = mysql_fetch_array(mysql_query("SELECT user_username FROM ".$prefix."User WHERE user_id = ".$arrComments[user_id_fk]." LIMIT 1")); $arrClubs = mysql_fetch_array(mysql_query("SELECT triclub_name FROM ".$prefix."Triclubs WHERE triclub_id = ".$arrComments[triclub_id_fk]." LIMIT 1")); $commenter_user_username = $arrCommenters[user_username]; $triclub_name = $arrClubs[triclub_name]; ?> <tr bgcolor="<? echo "$bg"; ?>"><td><span class="sub-hdr" style="margin-left: 5px;"><strong><? echo $arrComments[comment_subject]; ?></strong></span><div class="indent">Reviewed by: <? echo "<a href=\"http://forum.slowtwitch.com/gforum.cgi?username=".$commenter_user_username.";\" target=\"_blank\">".$commenter_user_username."</a>"; echo " on ".date("F j, Y g:i A", $arrComments[comment_time]); echo " about <a href=\"".$site_url."/individual.php?triclub_id=".$arrComments[triclub_id_fk]."\">".$triclub_name."</a>";?></div><div class="indent" style="background-color: #eeeef9; border: 1px solid black; margin-top: 2px; margin-right: 5px; margin-bottom: 5px; padding: 5px; "> <? echo stripslashes(stripslashes($arrComments[comment_message])); ?> </div><div class="indent"><input type="checkbox" value="<? echo($arrComments[comment_id]); ?>" name="validate[]"> Validate this comment. <input type="checkbox" value="<? echo($arrComments[comment_id]); ?>" name="delete[]"> Delete this comment.<br /></div></td></tr> <? } ?> </table> <br /> <input type="submit" value="Process Selected Comments"> </div> </form> <!-- End content col --> </div> <!-- End BODY --> </div> <!-- End Outer --> <? include("include_common_footer.php"); ?>