Chatter - Manage the Chatter

(Page 4 of 5 )

Now for a simple script to manage your chatterblock entries. This script will display all entries and give you the option of deleting any that you don't think are appropriate.

<? include("accesscontrol.php"); ?>
<table width=100% border=1>
<tr>
<td><b>Name</b></td>
<td><b>Message</b></td>
<td><B>Date Entered</b></td>
<td><b>IP Address</b></td>
<td>&nbsp;</td>
</tr>
<?php
include('chatter.php');
if($del){
mysql_query("DELETE FROM chatterblock WHERE id='$del'");
}
if($banip){
mysql_query("INSERT INTO blocked_ips SET ip='$banip'");
}
if($abanip){
mysql_query("DELETE FROM blocked_ips WHERE ip='$abanip'");
}
if($bann){
mysql_query("INSERT INTO blocked_nicks SET name='$bann'");
}
if($abann){
mysql_query("DELETE FROM blocked_nicks WHERE name='$abann'");
}
$q = "select * from chatterblock order by id desc ";
$result = mysql_query($q);
while ($row = mysql_fetch_array($result)){
$id = $row["id"];
$name=$row["name"];
$url = $row["url"];
$msg = $row["msg"];
$entered = $row["entered"];
$ip = $row["ip"];
echo "<tr>";
echo "<td><b><a href=\"$url\" target=\"new\">$name</a></b></td>";
echo "<td> $msg</td>";
echo "<td>$entered</td>";
echo "<td>$ip</td>";
echo "<td><a href='cbadmin.php?del=$id'>delete</a> |";
$blockedip = "select * from blocked_ips WHERE ip='".$ip."'";
$ipcheck = mysql_query($blockedip);
if( mysql_num_rows($ipcheck) > 0){
echo "<a href='cbadmin.php?abanip=$ip'>unban ip</a> |";
}else{
echo "<a href='cbadmin.php?banip=$ip'>ban ip</a> |";
}
$bname = "select * from blocked_nicks WHERE name='".$name."'";
$ncheck = mysql_query($bname);
if( mysql_num_rows($ncheck) > 0){
echo "<a href='cbadmin.php?abann=$name'>unban name</a></td>";
}else{
echo "<a href='cbadmin.php?bann=$name'>ban name</a></td>";
}
echo "</tr>";
}
?>

Save this file as cbadmin.php

Next: Secure it >>
 

More PHP Articles
More By Roger Stringer

Comments On: Chatter

· Once again, after criticising the "Building a Quick and Easy Tag Board" article, I...    · I was to trying the scripts but when others user posting into it ..iframe shout box...   >>> Post your comment now!