admin notify on all topics

[Kiss News]

Hallo!

habe mir diesen Mod eingebaut:

<?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']. "

" . $lastpost . "

" . $message_link ;


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

Ich bekomme nun alle Beiträge samt Inhalt als e-mail geschickt, sieht etwa so aus:

Submitted by :- LadySPACEACE
[quote:dd2a0bacf4] wees niet bang har ,dwerg poedels zijn niet gevaarlijk . :mrgreen: de engeltjes staan aan jou zijde sister . :engel:[/quote:dd2a0bacf4]

:knuddel: :bussi:
http://kissfanshop.ki.funpic.de/phpbb2/ ... hp?p=11415

Problem: würde gerne wissen, in welchem Topic dieser Beitrag steht. die e-mail sollte also so aussehen (der Forumsname steht bereits im Betreff):

Submitted by :- LadySPACEACE
Topic: Topicname
[quote:dd2a0bacf4] wees niet bang har ,dwerg poedels zijn niet gevaarlijk . :mrgreen: de engeltjes staan aan jou zijde sister . :engel:[/quote:dd2a0bacf4]

:knuddel: :bussi:

Könnte mir bitte vielleicht jemand sagen, was ich da ändern muss? Ich nehme an, es ist nur eine Kleinigkeit zu ändern/hinzufügen. :roll:
http://kissfanshop.ki.funpic.de/phpbb2/ ... hp?p=11415

[oxpus]

In etwa so:

Code: Alles auswählen

<?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 topic_id, 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'];
$topic_id = $row['topic_id'];
}

$sql = "SELECT topic_title
FROM " . TOPICS_TABLE . "
WHERE topic_id = $topic_id";
if ( $result = $db->sql_query($sql) )
{
$row = $db->sql_fetchrow($result);
$topic_title = $row['topic_title'];
}

// 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']. "
Topic: " . $topic_title . "

" . $lastpost . "

" . $message_link ;


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

[Kiss News]

Danke für die Info.
Also der Topic steht nun drinnen in der e-mail wie gewollt, allerdings fehlt jetzt der Text des Beitrages.

[oxpus]

Wie wird denn diese Datei aufgerufen?

[Kiss News]

mit includes/functions.php:

#-----[OPEN]------------------------------------------
#

includes/functions_post.php

#
#-----[FIND]------------------------------------------
#

return false;
}

//
// Update post stats and details
//

#
#-----[BEFORE ADD]------------------------------------------
#

// BEGIN MOD : Admin Notify On All Posts
include($phpbb_root_path . 'includes/notify_on_all_posts.' . $phpEx);
// END MOD : Admin Notify On All Posts

[oxpus]

Aha, also so rum.
Nun, da sollte der Text eigentlich mit erscheinen, denn Forum-ID, Topic-ID und Post-ID stehen ja zur Verfügung.
Und wurde der Text vor meiner Änderung angezeigt oder da auch schon nicht?
Hm. Versuchs mal so rum:

Code: Alles auswählen

<?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'];
}

$SQL = "SELECT topic_title
FROM " . TOPICS_TABLE . "
WHERE topic_id = $topic_id";
if ( $result = $db->sql_query($SQL) )
{
$row = $db->sql_fetchrow($result);
$topic_title = $row['topic_title'];
}

// 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']. "
Topic: " . $topic_title . "

" . $lastpost . "

" . $message_link ;


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

[Kiss News]

ja, so funtzt es, Vielen Dank!

Ja, der Text wurde vorher auch in der mail angezeigt.

[oxpus]

Dachte ich mir.
Ich hatte nämlich die Topic-ID aus der Post-Text-Tabelle geholt und da ist die nunmal nicht vorhanden.