#25 Notification about new topic

[Anonymous]

It would be great to have a possibility to recive
notification about new topics in board. This might be
helpfull for moderators.

For users this may be turned on/off by administrator.

[Nobody/Anonymous]

Logged In: NO

I added this (untidy) code in the post.php 1.5.2 in function
post2 at the end of the loop "if (newtopic)...

$request = mysql_query("
SELECT b.ID_BOARD as bid, b.name as bname,
c.ID_CAT as cid, c.memberGroups, c.name as cname,
b.isAnnouncement
FROM {$db_prefix}boards as b, {$db_prefix}
categories as c
WHERE (b.ID_BOARD = $board
AND b.ID_CAT=c.ID_CAT)") or
database_error(__FILE__, __LINE__);

if \(mysql\_num\_rows\($request\) == 0\)
    fatal\_error\($txt\['yse232'\]\);

$bcinfo = mysql\_fetch\_array\($request\);
$curcat = $bcinfo\['cid'\];
$cat = $bcinfo\['cname'\];
$currentboard = $bcinfo\['bid'\];
$boardname = $bcinfo\['bname'\];

// BOARD ID END

//Now loop through all the members
$subject = New
message: ' . $cat . ' - ' . $boardname;
$body = 'A New Message
has been posted to the ' . $cat . ' - ' . $boardname . 'Board.
';
$body .= "
@ https://your.website.com/YaBB/index.php?board=" .
$board . ";action=display;threadid=" . $threadid . ";start=new";
$body .= '
==================== Message
====================
';
$body .= $mailmessage;
$body .= '
==================== Message
====================
';
$body .= 'Regards,
';
$body .= "The Management.
";
$body .= "
";
$body .= "Note: This email
comes from a post-only account.
";
$members = mysql_query("
SELECT
realName,emailAddress
FROM {$db_prefix}members
WHERE ID_MEMBER != '1'
AND
emailAddress != ''
AND
ID_MEMBER != $ID_MEMBER
") or
database_error(__FILE__, __LINE__);

        while \($rowmember =

mysql_fetch_array($members))
{
$bodystart = "Notification
for " . $rowmember['realName'] . "
";

$mailfrom=$webmaster\_email;
        $mailbody = $bodystart .

$body;
// sendmail($rowmember
['emailAddress'],$subject,$mailbody,$mailfrom);
}
}
}