vb.org Archive - Each Announcement shows as an extra thread in Forumdisplay

Page 6 of 6

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Each Announcement shows as an extra thread in Forumdisplay (https://vborg.vbsupport.ru/showthread.php?t=40604)

Oblivion Knight

07-01-2003 07:20 AM

I've always said that this should have been default behaviour..
I didn't know someone had released a mod that actually made it do it..!

Just what I was looking for, thanks Xenon :)

msimplay

08-08-2003 02:09 AM

Yep works great on vb2.3 erm ooh no i hacked my forum to bits and now 2.3.1 is out :(

ANT.menmusic

08-19-2003 04:13 AM

not even 10 minutes for this one and boom - worked like a charm. using 2.2.9
:smoke:in'

-ant

Angelus

10-25-2003 10:50 AM

ich habe diesen prima hack mal versucht in mein 2.2.9 einzubauen aber irgendwie geht das nicht so wie es soll.

ich habe in meiner forumdisplay.php einen ganzanderen code :(

siehe:

PHP Code:


		
			
if ($announcement=$DB_site->query_first("SELECT announcementid,startdate,title,user.username,user.userid,user.usertitle,user.customtitle

                                         FROM announcement

                                         LEFT JOIN user

                                           ON user.userid=announcement.userid

                                         WHERE startdate<=$datenow AND enddate>=$datenow

                                           AND $forumlist

                                         ORDER BY startdate DESC

                                          LIMIT 1")

  and (!isset($pagenumber) or $pagenumber<2)) {

und im board kommt dann ein fehler:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\board\admin\db_mysql.php on line 154

bitte hleft mir ich weis nicht was da schief l?uft?

Xenon

10-26-2003 02:10 PM

einfach diese if condition mit dem teil ersetzen:

PHP Code:


		
			
$announcementbit="";

$announcements=$DB_site->query("SELECT announcementid,startdate,title,user.username,user.userid,user.usertitle,user.customtitle

                                         FROM announcement

                                         LEFT JOIN user

                                           ON user.userid=announcement.userid

                                         WHERE startdate<=$datenow AND enddate>=$datenow

                                           AND $forumlist

                                         ORDER BY startdate DESC");

while($announcement=$DB_site->fetch_array($announcements)) {

wenn du das fetch_array hernimmst, musst du aufpassen, das nur ein DB_site->query und kein query_first verwendet wird

Angelus

10-27-2003 07:11 PM

ich habe deinen code mal eingebaut, es ist immernoch der gleiche fehler :( wie oben beschrieben, und in meiner forumdisplay.php sehe ich auch nur eine ank?ndigung obwohl ich mehrere eingestellt habe.

Xenon

10-28-2003 06:21 PM

hmm, der teil kanns kaum sein, der stimmt nämlich, vielleicht haste woanders nen fehler reingebracht.

btw. auf vb-g in der hacksektion ist der hack auch drinnen, aber auf deutsch.
vielleicht hat da auch jemand das problem mal gehabt und gelöst (nur so als tip)

desiforums

09-01-2006 10:31 PM

is it wrk for vbulletin 3.5.4
because i can't find
Open forumdisplay.php

find:
if ($announcement=$DB_site->query_first("SELECT announcementid,startdate,title,user.username,user. userid,user.usertitle,user.cus tomtitle
FROM announcement
LEFT JOIN user
ON user.userid=announcement.userid
WHERE startdate<=$datenow AND enddate>=$datenow
AND $forumlist
ORDER BY startdate DESC
LIMIT 1")) {

All times are GMT. The time now is 06:18 AM.

Page 6 of 6

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01173 seconds Memory Usage 1,744KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: