Alerts

~~Robbie..~~ · 20-12-2005, 05:32 PM

There is no SQL needed with it.

PHP Code:


<head>

<script language="javascript" type="text/javascript"> alert(' 

<? echo(file_get_contents("alert.txt"); ?>

'); </script>

is the code.

~~Dan Williamson~~ · 20-12-2005, 05:33 PM

Have you created alert.txt and CHMOD'd it?

- Dan

~~Robbie..~~ · 20-12-2005, 05:37 PM

Yes.

http://www.habbolido.co.uk/staffarea/alert/alert.php

http://www.habbolido.co.uk/staffarea/alert/alert.txt (Chmod 666)

~~Dan Williamson~~ · 20-12-2005, 05:38 PM

Not sure then.

- Dan

Luckyrare · 20-12-2005, 05:59 PM

PHP Code:


<?
echo "<script language='javascript' type='text/javascript'> alert('";
include "alert.txt";
echo "'); </script>";
 ?>

That should work.

~~Robbie..~~ · 20-12-2005, 07:43 PM

w00t it worked thanks

Now, this will probably be simple, but I need a simple php script or whatever that will write a new message to the alert.txt file by typing it in a text box or something.

Rob

Luckyrare · 20-12-2005, 08:40 PM

I won't do the HTML because its to easy, but heres the php

PHP Code:


<?

if ($_SERVER['REQUEST_METHOD'] != 'GET'){

$alert= $_POST['alert'];

$file = fopen("alert.txt", "w+");

fputs($file, $alert);

fclose($file);

echo "'$alert' has been broadcasted!";

?>

Create a form with a text box called alert

Hope this helped

Luckyrare · 20-12-2005, 08:53 PM

Originally Posted by Tomdarkness2

*sigh*
Change the Username password and database name. Also you might want to chage the bit about Message from ....
Run this SQL:

Code:

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 :

PHP Code:


<?
$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:

PHP Code:


<?
$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?

Tomm · 20-12-2005, 08:55 PM

Originally Posted by Luckyrare

Or you could do it that way *sigh*

Its better because it dosent keep showing the alert to the vister everytime the alert.php refreshes lol

~~Robbie..~~ · 20-12-2005, 09:39 PM

Thanks.

But it aint working.

http://www.wackyhabbo.co.uk/hab-tastic/alerts/alert.php is just blank and shows no alert

and http://www.wackyhabbo.co.uk/hab-tast...rts/script.php becomes blank when you have typed a message.

Any suggestions anyone?

Thread: Alerts

Thread Tools

Posting Permissions