phpBB.de

Verfasst: **13.06.2007 23:06**

oxpus hat geschrieben:Ja, der typische Fehler:
Die Zeilen
Code: Alles auswählen
$topic_rowset = array();
$total_announcements = 0;
müssen VOR den Zeilen
Code: Alles auswählen
//
// All GLOBAL announcement data, this keeps GLOBAL announcements
// on each viewforum page ...
//
stehen, damit der MOD korrekt funktioniert.
Ansonsten würden die globalen Ankündigungen zwar abgerufen, aber dann wieder "gelöscht"

Naja dafür kann ich aber nichts steht so in der anleitung drin wie ich es dirn habe.

EDIT und wie soll ich das reinschreiben da dies ja in einer while schleife steht

edit2: ok habe es gefunden

Verfasst: **13.06.2007 23:18**

OK habe es jetzt von

//
// All GLOBAL announcement data, this keeps GLOBAL announcements
// on each viewforum page ...
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
WHERE t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_GLOBAL_ANNOUNCE . "
ORDER BY t.topic_last_post_id DESC ";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain topic information", "", __LINE__, __FILE__, $sql);
}

$topic_rowset = array();
$total_announcements = 0;
while( $row = $db->sql_fetchrow($result) )
{
$topic_rowset[] = $row;
$total_announcements++;
}

$db->sql_freeresult($result);
// End add - Global announcement MOD

nach so geändert

//
$topic_rowset = array();
$total_announcements = 0;

// All GLOBAL announcement data, this keeps GLOBAL announcements
// on each viewforum page ...
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
WHERE t.topic_poster = u.user_id
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u2.user_id
AND t.topic_type = " . POST_GLOBAL_ANNOUNCE . "
ORDER BY t.topic_last_post_id DESC ";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't obtain topic information", "", __LINE__, __FILE__, $sql);
}

while( $row = $db->sql_fetchrow($result) )
{
$topic_rowset[] = $row;
$total_announcements++;
}

$db->sql_freeresult($result);
// End add - Global announcement MOD

funktioniert aber immer nocht nicht!

Verfasst: **15.06.2007 21:03**

So habe den Fehler gefunden und man muss nicht die Zeilen

Code: Alles auswählen

$topic_rowset = array(); 
$total_announcements = 0;

über das hier schreiben

Code: Alles auswählen

// 
// All GLOBAL announcement data, this keeps GLOBAL announcements 
// on each viewforum page ... 
//

sondern die Zeilen

Code: Alles auswählen

$topic_rowset = array(); 
$total_announcements = 0;

in dem folgenden Block entfernen oder // davor schreiben, damit diese nicht zweimal vorkommen.

Code: Alles auswählen

//
// All announcement data, this keeps announcements
// on each viewforum page ...
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username
	FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2
	WHERE t.forum_id = $forum_id
		AND t.topic_poster = u.user_id
		AND p.post_id = t.topic_last_post_id
		AND p.poster_id = u2.user_id
		AND t.topic_type = " . POST_ANNOUNCE . "
	ORDER BY t.topic_last_post_id DESC ";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
}

$topic_rowset = array(); 
$total_announcements = 0;
while( $row = $db->sql_fetchrow($result) )
{
	$topic_rowset[] = $row;
	$total_announcements++;
}

$db->sql_freeresult($result);

MFG
Angel

phpBB.de

Global announcement Mod 1.2.9em