phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Fein....Henne hat geschrieben:Also bei mir läuft die MOD in einem 2.0.6 problemlos.
Kannst du eine ungefähre Zeitangabe machen....?Henne hat geschrieben:Installation, naja, für mich war es nicht schwer.
wenn Henne sagt das geht, dann geht dasgibts da den was aktuell funktionierendes fuer 2.0.6?
Ist schwer genug! Aber hier die Lösung, um die Anzahl der neuen Posts incl. der Userberechtigungen zu errechnen:Dr. Love hat geschrieben:...Analog geht das auch für die Zahl in Klammern. Da fehlt nur noch die Subtraktion der Posts, die der User nicht lesen kann...
Code: Alles auswählen
//
// End session management
//Code: Alles auswählen
if( $userdata['session_logged_in'] )
{
$sql = "SELECT * FROM ". FORUMS_TABLE;
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}
$forum_data = array();
while( $row = $db->sql_fetchrow($result) )
{
$forum_data[] = $row;
}
$is_auth_ary = array();
$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);
for ($i = 0; $i < count($forum_data); $i++)
{
if (($is_auth_ary[$forum_data[$i]['forum_id']]['auth_read']) or ($is_auth_ary[$forum_data[$i]['forum_id']]['auth_view']))
{
if ($auth_forum_id == '')
{
$auth_forum_id = $forum_data[$i]['forum_id'];
}
else
{
$auth_forum_id .= ',' . $forum_data[$i]['forum_id'];
}
}
}
$p=0;
$jetzt_vor_einem_monat = time() - 2592000;
$sql = "SELECT count(p.post_id)
FROM " . POSTS_TABLE . " AS p LEFT OUTER JOIN " . TOPIC_READ_TABLE . " AS r
ON ( p.topic_id = r.topic_id AND r.user_id = " . $userdata['user_id'] . ")
WHERE ( (r.user_id = " . $userdata['user_id'] . " OR r.user_id IS NULL)
AND p.post_time > " . $jetzt_vor_einem_monat . "
AND (p.post_time > r.visit_time OR p.post_edit_time > r.visit_time OR r.topic_id IS NULL) )
AND p.forum_id IN (" . $auth_forum_id . ")
ORDER BY p.topic_id DESC, p.post_id DESC";
if ( $result = $db->sql_query($sql) )
{
$p = $db->sql_fetchrow($result);
}
$countposts = ( $p[0] == 1 ) ? $lang['Post'] : $lang['Posts'];
$lang['Search_new'] = ( $p[0] == 0 ) ? $lang['Search_new'] : $lang['New_for_user'] . " " . $p[0] . " " . $countposts;
}Code: Alles auswählen
if ( $tracking_topics[$check_topic_id] < $check_post_time )Code: Alles auswählen
if ( $tracking_topics[$check_topic_id] <= $check_post_time )Code: Alles auswählen
$new_topic_data = array();
if ( $userdata['session_logged_in'] )
{
$user_lastvisit = $userdata['user_lastvisit'];
$sql = "SELECT t.forum_id, t.topic_id, p.post_time
FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
WHERE p.post_id = t.topic_last_post_id
AND p.post_time > $user_lastvisit
AND t.topic_moved_id = 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
}
while( $topic_data = $db->sql_fetchrow($result) )
{
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
}
}Code: Alles auswählen
$new_topic_data = array();
if ( $userdata['session_logged_in'] )
{
$jetzt_vor_einem_monat = time() - 2592000;
$sql = "SELECT p.forum_id, p.topic_id, p.post_time
FROM " . POSTS_TABLE . " AS p LEFT OUTER JOIN " . TOPIC_READ_TABLE . " AS r
ON ( p.topic_id = r.topic_id AND r.user_id = " . $userdata['user_id'] . ")
WHERE ( (r.user_id = " . $userdata['user_id'] . " OR r.user_id IS NULL)
AND p.post_time > " . $jetzt_vor_einem_monat . "
AND (p.post_time > r.visit_time OR p.post_edit_time > r.visit_time OR r.topic_id IS NULL) )";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
}
while( $topic_data = $db->sql_fetchrow($result) )
{
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
}
}Code: Alles auswählen
//
// Obtain a list of topic ids which contain
// posts made since user last visited
//
if ( $userdata['session_logged_in'] )
{
$sql = "SELECT t.forum_id, t.topic_id, p.post_time, p.post_edit_time
FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
WHERE p.post_id = t.topic_last_post_id
AND p.post_time > " . $userdata['user_lastvisit'] . "
AND t.topic_moved_id = 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
}
$new_topic_data = array();
while( $topic_data = $db->sql_fetchrow($result) )
{
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
}
}Code: Alles auswählen
$new_topic_data = array();
if ( $userdata['session_logged_in'] )
{
$jetzt_vor_einem_monat = time() - 2592000;
$sql = "SELECT p.forum_id, p.topic_id, p.post_time
FROM " . POSTS_TABLE . " AS p LEFT OUTER JOIN " . TOPIC_READ_TABLE . " AS r
ON ( p.topic_id = r.topic_id AND r.user_id = " . $userdata['user_id'] . ")
WHERE ( (r.user_id = " . $userdata['user_id'] . " OR r.user_id IS NULL)
AND p.post_time > " . $jetzt_vor_einem_monat . "
AND (p.post_time > r.visit_time OR p.post_edit_time > r.visit_time OR r.topic_id IS NULL) )";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
}
while( $topic_data = $db->sql_fetchrow($result) )
{
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
}
}