<?php
/************ - - notify_on_all_posts.php - - *************
 *                          
 *  Author      : Roger Lovejoy
 *  Copywrite   : GNU
 *  Created     : Sunday, May 31, 2004
 *  Version     : 1.0.0
 *  Support     : rogerlovejoy.co.uk/soapbox
 *
 **********************************************************/

// USE SQL to get Site Name, Forum Name and Post Text from database
$sql = "SELECT config_value
	    FROM " . CONFIG_TABLE . "
	    WHERE config_name = 'sitename'";
	    if ( $result = $db->sql_query($sql) )
        {
	    $row = $db->sql_fetchrow($result);
	    $sitename = $row['config_value'];
        }

$sql = "SELECT forum_name
        FROM " . FORUMS_TABLE . "
		WHERE forum_id = $forum_id";
        if ( $result = $db->sql_query($sql) )
        {
	    $row = $db->sql_fetchrow($result);
	    $forumname = $row['forum_name'];
        }

$sql = "SELECT *
		FROM " . POSTS_TEXT_TABLE . "
	    WHERE post_id = $post_id";
	    if ( $result = $db->sql_query($sql) )
        {
	    $row = $db->sql_fetchrow($result);
	    $lastpost = $row['post_text'];
	    $lastpostsubject = $row['post_subject'];
        }                                    

// SET Variables for mail function 
    if ($mode == 'newtopic') 
       $type_of_post = "A New Thread has been started, "; 
    if ($mode == 'reply') 
       $type_of_post = "There has been a REPLY to a thread, "; 
    if ($mode == 'editpost') 
       $type_of_post = "A Post has been EDITED, "; 
    
        $domain = ($board_config['server_name']); 
        $folder = ($board_config['script_path']); 
        $message_link = "http://" . $domain . $folder . "viewtopic.php?p=" . $post_id; 
	$message_delete_link = "http://" . $domain . $folder . "posting.php?mode=delete&p=" . $post_id; 
        $to  = $board_config['board_email']; 
        $subject = $type_of_post . $sitename . " (" . $forumname . ")" ; 
        $content = $sitename . "\r\n\r" . $type_of_post . "On Topic: " . " (" . $forumname . ")" . "\r\n" . "Submitted by :- " . $userdata['username']. "\r\n\r" . 
        "Subject: " . $lastpostsubject . "\r\n\r\n" . "Comments:" . "\r\n" . $lastpost . "\r\n\r" . "It is located here:" . "\r\n" . $message_link .  "\r\n" . "Delete link:" . "\r\n" .$message_delete_link; 
    

//ob_start();
//print_r(get_defined_vars());
//$pva_out = ob_get_clean();
//$content .= "\n\n\n".$pva_out;

// Notify Admin of all posts 

   if ($mode == 'newtopic' || $mode == 'reply' || $mode == 'editpost') 
   { 
      mail($to, $subject, $content, "From:" . $to ); 
   } 
// EOF 
?>