I've almost finished the chat for 3DSU. I want to make AlertBots for when some one gets banned. I know I'd put it in "chat_post", but how would I script it?
that do mysql_insert
if($banned ==''){
echo"";
}
else{
$result = mysql_query("INSERT INTO Chatroom(banned_users)VALUES(".$_POST['banned'].")");
$result = mysql_query("SELECT *FROM Banned");
$row= mysql_fetch_array($result);
echo"A users has being banned";
<?php
if($_SESSION =='Admin') {
mysql_connect("localhost","db_username","password") or die (mysql_error());
echo"";
mysql_select_db("database") or die (mysql_error());
echo"";
$result = mysql_query("SELECT * FROM usertable WHERE username='".$_SESSION['userna,e']."' and Admin='YES'");
$result = mysql_query("UPDATE usertable SET points=points +3 WHERE username='".$_SESSION['username']."'");
$row = mysql_fetch_array($result);
?>
<?php
$Admin = $_SESSION['Admin'];
if($comment =="/ban") {
echo"
$result = mysql_query("INSERT INTO Banlist (id,username,password,ip) VALUES('".$_POST['id']."','".$_POST['username']."','".$_POST['password']."','".$_POST['ip']."'");
$result = mysql_query("SELECT * FROM Banlist");
$row = mysql_fetch_array($result);";
echo"".$_SESSION['user']." has been banned by ".$_SESSION['username']."";
}
else{
echo"";
}
?>
Like that?