phpBB.de

<?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 post_text
FROM " . POSTS_TEXT_TABLE . "
WHERE post_id = $post_id";
if ( $result = $db->sql_query($sql) )
{
$row = $db->sql_fetchrow($result);
$lastpost = $row['post_text'];
}

// SET Variables for mail function
$domain = ($board_config['server_name']);
$folder = ($board_config['script_path']);
$message_link = "http://" . $domain . $folder . "viewtopic.php?p=" . $post_id;
$to = $board_config['board_email'];
$subject = $mode . " on " . $sitename . " (" . $forumname . ")" ;
$content = "Submitted by :- " . $userdata['username']. "\r\n\r" . $lastpost . "\r\n\r" . $message_link ;


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