*sigh*
Change the Username password and database name. Also you might want to chage the bit about Message from ....
Run this SQL:
CREATE TABLE `alert` (
`ID` INT( 4 ) NOT NULL AUTO_INCREMENT ,
`message` TEXT NOT NULL ,
`active` CHAR( 1 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) TYPE = MYISAM ;
Alert.php :
<?
$dbName = "yourdatabasename";
$dbUser = "dbusername";
$dbPass = "dbpass";
// Connect
mysql_connect ("localhost", "$dbUser", "$dbPass");
mysql_select_db ("$dbName");
// Get Alert
$alertQuery = mysql_query("SELECT * FROM alert WHERE active='Y'");
if(mysql_num_rows($alertQuery) =="1"){
$alertData = mysql_fetch_array($alertQuery);
if($_COOKIE[$alertData[ID]] !="Y"){
$y = "Y";
setcookie($alertData[ID], $y);
Echo"
<script language='javascript'>alert('$alertData[message]');</script>";
}
}
Echo"<META HTTP-EQUIV='refresh' content='60;URL=alert.php'>";
Echo"$_COOKIE[$alertDataID]"
?>
Smack this file in a secure directory or add some nifty PHP codeing to it your self:
<?
$dbName = "dbname";
$dbUser = "user";
$dbPass = "pass";
// Connect
mysql_connect ("localhost", "$dbUser", "$dbPass");
mysql_select_db ("$dbName");
switch($_GET['act']){
default:
// Alert Data
$alertQuery = mysql_query("SELECT * FROM alert WHERE active='Y'");
$alertData = mysql_fetch_array($alertQuery);
if($alertData[message] !=""){
$Var ="<u>Current Active Alert</u>: $alertData[message] [<a href='alert.php?act=deactivate'>Deactivate</a>]";
}
Echo"<center><b>Alert Script Control Panel</b></center>
<u>NOTE:</u> You can only have one alert at one time. Once you want people to
stop being alerted, you will have to deactive it below. Creating a new alert
will delete the old one.<br>
$Var
<hr width='100%' height='1' color='#000000' shade='no'>
<form method='post' action='alert.php?act=create'>
Message:<br>
<textarea name='message' cols='30' rows='6'>Keep the message short</textarea><br>
<input type='submit' value='Create'>
</form>";
break;
case"create":
$message = "From your sites name DJ: ". $_POST['message'];
if(empty($message)){
Echo"<b>Error:</b> Please fill out the message.";
exit;
}
mysql_query("UPDATE alert SET active ='N'");
mysql_query("INSERT INTO alert (message,active) VALUES ('$message','Y')");
Echo"<b>Alert Added Sucessfully</b><br>
All other alerts have been deactivated. All users will recieve this alert
once, until you deactivate it.";
break;
case"deactivate":
mysql_query("UPDATE alert SET active ='N'");
Echo"<b>Alerts Deactivated</b><br>
All previous alerts have been deactivated.";
break;
}
?>
Or you could do it that way *sigh*
Will that also only send the alert once?