vb.org Archive - Forum Display Enhancements - All Topic - Master Forums - Shows threads from multiple forums in one forum

Page 4 of 6

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

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Forum Display Enhancements - All Topic - Master Forums - Shows threads from multiple forums in one forum (https://vborg.vbsupport.ru/showthread.php?t=245839)

Wakey

11-13-2011 02:02 PM

When I click a thread on the master forum the breadcrumb is showing as

Forum > Slave Forum > Slave Thread

Should it be like this or should it be

Forum > Master Forum > Slave Thread

When visiting a Slave Thread from the Master forum I would really like the breadcrumb to show its on the master forum rather than slave forum. If its not designed to allow this then does anyone have any idea of what I would need to change to sort this (or if it's supposed to be working like I want what am I dong wrong)

Alan_SP

11-18-2011 12:29 AM

Correct is: Forum > Slave Forum > Slave Thread

Because thread is in slave forum, not master. Master forum is just place where you can see all threads from selected forums, but not where they really are.

BirdOPrey5

11-19-2011 06:09 PM

Quote:

Originally Posted by playSocial (Post 2267537)

That's how it works, you're not doing anything wrong. The "Master" forum is more of a virtual forum, most threads usually do not really belong in it.

Wakey

11-24-2011 12:24 AM

Quote:

Originally Posted by BirdOPrey5 (Post 2269664)

That's how it works, you're not doing anything wrong. The "Master" forum is more of a virtual forum, most threads usually do not really belong in it.

Let's say I wanted it to show the other way if a user has clicked the link from the master forum, anyone any idea how I would do this?

BirdOPrey5

11-25-2011 06:54 PM

No.

swatirajawat

12-01-2011 08:52 AM

hi
i want to add widget for user where they can subscribe for newsletter, only 2 fields for email and name so that they can get newsletters on subscribing here.
i have searched for newsletter and i got 2 mods community newsletter and newsletter manager but i did not get any widget mod for what i need how can i make it.
help me please.
.thank you.

BirdOPrey5

12-02-2011 06:29 PM

That doesn't seem to have anything to do with this mod. Please make a thread in an appropriate forum.

taffy056

12-03-2011 03:54 PM

The file forumdisplay.php is different to the one you are showing in 4.1.8 , when I take out the "$hook_query_where" as advised, it throws a database error, is there a fix for that ? thanks

qpurser

12-03-2011 03:59 PM

I was hoping to get this great mod working in my 4.1.5 but ran into an issue.
I followed the instructions from the readme.txt.
Below is the error I got and also how my forumdisplay.php looks.
What could be wrong?
Thanks for any help

PHP Code:


		
			
Database error:

Database error in vBulletin 4.1.5:



Invalid SQL:



    SELECT COUNT(*) AS threads

    

    FROM thread AS thread

    

    /*

    WHERE thread.forumid = 198

        AND sticky = 0

        

         AND visible IN (0,1,2);



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*

    WHERE thread.forumid = 198

        AND sticky = 0

        

         AND visible IN (0,1,2)' at line 9

Error Number  : 1064

Request Date  : Saturday, December 3rd 2011 @ 10:53:10 AM

Error Date    : Saturday, December 3rd 2011 @ 10:53:10 AM

and my forumdisplay.php:

PHP Code:


		
			
&#65279;$hook_query_fields = $hook_query_joins = $hook_query_where = '';

    ($hook = vBulletinHook::fetch_hook('forumdisplay_query_threadscount')) ? eval($hook) : false;



    # Include visible IN (0,1,2) in order to hit upon the 4 column index

    $threadscount = $db->query_first_slave("

    SELECT COUNT(*) AS threads

    $hook_query_fields

    FROM " . TABLE_PREFIX . "thread AS thread

    $tachyjoin

    $hook_query_joins

    WHERE thread.forumid = $foruminfo[forumid]

        AND sticky = 0

        $prefix_filter

        $visiblethreads

        $globalignore

        $limitothers

        $datecut

        

    ");

    $totalthreads = $threadscount['threads'];

    

    $threadscount = $db->query_first_slave("

    SELECT COUNT(*) AS newthread

    FROM " . TABLE_PREFIX . "thread AS thread

    $tachyjoin

    $hook_query_joins

    WHERE thread.forumid = $foruminfo[forumid]

        AND thread.lastpost > $lastread

        AND open <> 10

        AND sticky = 0

        $prefix_filter

        $visiblethreads

        $globalignore

        $limitothers

        $datecut

        $hook_query_where

    ");

    $newthreads = $threadscount['newthread'];

BirdOPrey5

12-05-2011 10:16 AM

If your forumdisplay.php looks different try it without making any file edits.

qpurser

12-05-2011 11:41 AM

Quote:

Originally Posted by BirdOPrey5 (Post 2274838)

If your forumdisplay.php looks different try it without making any file edits.

Thank you so much for the help.
I followed your suggestion and didn't edit the forumdisplay file.
Works great now

BirdOPrey5

12-05-2011 02:27 PM

Great. Please mark as installed. :up:

taffy056

12-05-2011 11:52 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2274838)

If your forumdisplay.php looks different try it without making any file edits.

yeah thanks that works, can I ask without sounding stupid, why have the file edit if it works without it ?

BirdOPrey5

12-06-2011 07:43 PM

Quote:

Originally Posted by taffy056 (Post 2275026)

yeah thanks that works, can I ask without sounding stupid, why have the file edit if it works without it ?

Different versions of 4.x have different versions of forumdisplay.php. In VB 3.8 they had the old version that didn't need the file edit. Then they changed to a "new" version that needed a file edit. Then they changed back for 1 release to the old version. Then they changed again to "new" version and there were several releases that needed the edit- I thought they were done making changes. Apparently not, as of 4.1.7 or so they are back to the old version again.

Diana Notacat

03-17-2012 04:43 PM

I seem to have a problem in 4.1.11

Where I DO edit forumdisplay.php I have the same problem as this post.

But when I DON'T edit I get this error:

Code:

Invalid SQL:



                                SELECT attachment.attachmentid, attachment.dateline

                                FROM attachment AS attachment

                                

                                WHERE attachment.contentid = 

                                        

                                LIMIT 1;



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 6

Error Number  : 1064

Help is very much appreciate! :D

BirdOPrey5

03-17-2012 08:59 PM

You definitely do not need a file edit on 4.1.11

I am running it fine on 4.1.11.

That error isn't even with a query used by this mod- I suggest restoring your forumdisplay.php file from a backup or the original vBulletin download zip, because it should work with the default file.

Diana Notacat

03-18-2012 12:45 PM

Thank you for the quick response!

I tested it on on a default test forum, and you are correct. So I had to go through all my modifications to find out which one it was clashing with.

Apparently it can't work if you have the Chiplove.9xpro - Thread Thumbnails 2.2.9 mod installed.

I'll see if I can find a way to work around it.

BirdOPrey5

03-18-2012 01:29 PM

Thanks for the updated. I actually just tried that mod on my test forum (which is still 4.1.10) to see if I could troubleshoot, but I can't recreate the database error. I tried making sure there were attachments in threads and tried the various options for the 9xpro mod, but just can't get the database error to appear.

From your original error I see the line is from a query in the 9xpro mod:

Code:

WHERE attachment.contentid = ".$thread['firstpostid']."

So for some reason $thread['firstpostid'] is empty...

$thread is getting passed into the function but I wonder if a possible fix would be to simply make $thread global in the function instead. I had hope to test this but without getting the error I can't really confirm.

cagbaazee

03-21-2012 08:30 PM

Hi, i am just new to this mod.. You mean that i can get other threads from other forums site and it automatically post here, or it is manual. What about username and password from other forums to be access and post the thread here in my master forum. Do reply asap. Thanks

BirdOPrey5

03-21-2012 11:06 PM

Hi...
No, not from other domains...

From multiple forums on your OWN forum....

Like here- you could get "vBulletin.org Site Feedback" and "Community Lounge" and "Community Reviews" to all show in the "vBulletin Pre-Sales" forum if you wanted.

Sorry for the confusion.

cagbaazee

03-22-2012 02:53 AM

Hi.. No problem.. But yr Image say that we can get it from other forums. Anyway, if u hv these type of mod which can import threads from other forums, that would be very wonderful.

BirdOPrey5

03-22-2012 11:32 AM

Yeah it's because "forum" can refer to both an entire site- or specific forums on the site.

This mod, vBNetwork, allows you to share forums with other sites: https://vborg.vbsupport.ru/showthread.php?t=245942

I've seen sites use it, it needs a little work but it's a great start. Of course it needs the other forum admin's to install it too- importing data from another forum without permission wouldn't be ethical.

shuangddr

04-23-2012 03:30 PM

hi,how to make other forum title clickable?

BirdOPrey5

04-24-2012 11:55 AM

I haven't tested this but edit the plugin "All Topic in Threadbit."

Find the code:

Code:

{vb:raw thread.forumtitle}

There are 2 instances of it.

Replace BOTH with this:

Code:

<a href="forumdisplay.php?f={vb:raw thread.forumid}">{vb:raw thread.forumtitle}</a>

ProFifaLeagues

06-10-2012 10:30 PM

Bop Would this work for 4.2??
If So are the Edits still needed as well sir?

Jennifer2010

06-10-2012 10:41 PM

Quote:

Originally Posted by ProFifaLeagues (Post 2338573)

Bop Would this work for 4.2??
If So are the Edits still needed as well sir?

I upgraded to 4.2 and it's working fine for me

BirdOPrey5

06-11-2012 10:37 AM

It will work on 4.2.0 with NO FILE EDITS! :up:

ProFifaLeagues

06-11-2012 10:57 AM

Quote:

Originally Posted by BirdOPrey5 (Post 2338680)

It will work on 4.2.0 with NO FILE EDITS! :up:

Worked A1 thanks Joe,Very handy to have this one mate.

Akyeame Kwame

06-17-2012 11:13 AM

Hello, I'm getting this error. I originally tried the file edits then came to the end page and saw that file edits. Both ways gave me the same DB error. Any idea what may be causing it?

I'm using my open forum ID 855 like this

855|*
I'd like all the forums to display.

Code:

Database error in vBulletin 4.1.11:



Invalid SQL:



        SELECT COUNT(*) AS threads,

        (

                SELECT COUNT(*) AS newthread

                FROM thread AS thread

                WHERE forumid = 855

                AND lastpost > 1339934749

                AND open <> 10

                AND sticky = 0

                

                 AND visible IN (0,1,2)

                

                

                

                */ WHERE forumid > 0 AND  (sticky = 0 OR sticky = 1)    AND visible IN (0,1,2)   

        ) AS newthread

        

        FROM thread AS thread

        

        /*

        WHERE forumid = 855

        AND sticky = 0

        

         AND visible IN (0,1,2)

        

        

        

        */ WHERE forumid > 0 AND  (sticky = 0 OR sticky = 1)    AND visible IN (0,1,2);



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/ WHERE forumid > 0 AND  (sticky = 0 OR sticky = 1)    AND visible IN (0,1,2)  ' at line 14

Error Number  : 1064

Request Date  : Sunday, June 17th 2012 @ 08:09:49 AM

Error Date    : Sunday, June 17th 2012 @ 08:09:50 AM

Script        : http://www.**********.com/forums/forumdisplay.php?f=855

Referrer      : http://www.************.com/forums/forum.php

Classname     : vB_Database

MySQL Version : 5.1.61

BirdOPrey5

06-17-2012 01:27 PM

4.1.11 shouldn't need any file edits. Restore your original forumdisplay.php file.

Datenpapst

06-17-2012 04:41 PM

Is it possible to add forums from other servers/other boards?

BirdOPrey5

06-18-2012 12:47 PM

No not with this mod.

Check out this one for sharing boards across different forums (domains): https://vborg.vbsupport.ru/showthread.php?t=245942

BrettJC

08-05-2012 01:06 AM

Is it possible to color threads based on there original forumid, so if I have 3 forums and 1 master forum can I have all treads from forum 1 show blue and all threads from forum 2 show red etc

thenoob2012

08-05-2012 08:42 AM

Just installed your mod and it is exactly what I was looking for. I only have one question and it is how do I get it to update thread count. No matter how many threads are posted in master forum it only says there is one and the one it is referring to is the one I actually made in the master forum.

Is there anyway to fix this. I am running the newest VB forum. Thanks is advance.

BirdOPrey5

08-05-2012 01:49 PM

Quote:

Originally Posted by BrettJC (Post 2354552)

Is it possible to color threads based on there original forumid, so if I have 3 forums and 1 master forum can I have all treads from forum 1 show blue and all threads from forum 2 show red etc

Possible but not something I have coded. If you are interested in trying yourself you'd start in the plugin called All Topic in Threadbit and add a custom edit for when the thread[forumid] matches the forum[forumid].

Quote:

Originally Posted by thenoob2012 (Post 2354601)

Again possible but complicates the mod much more by needing changes to even more queries and it is simply not something I have attempted at this point.

If you read through this thread it was discussed before, a long time ago- I forget if anyone posted a solution or not.

This mod is probably due for an overhaul... I will look into a fresh rebuild of this mod and see which features I can add. No promises of how soon though.

BrettJC

08-06-2012 04:51 AM

Thanks Joe, I will see what I can do, i will post here if i get it working.

thenoob2012

08-06-2012 08:31 PM

Thanks for getting back with me.

vbresults

10-22-2012 08:32 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2354679)

This mod is probably due for an overhaul... I will look into a fresh rebuild of this mod and see which features I can add. No promises of how soon though.

Quote:

Originally Posted by LancerForHireLLC (Post 2258542)

hook: forumdisplay_start

PHP Code:


		
			
if (in_array($foruminfo['forumid'], $masterForums)) {
    // *Tell* the forum it will contain threads! >=)
    $foruminfo['cancontainthreads'] = true;
}

hook: forumdisplay_query_threadscount

PHP Code:


		
			

if (in_array($foruminfo['forumid'], $masterForums)) {
    $childForums = implode(', ', $foruminfo['childlist']);

    // Add an OR IN(children) condition and the default thread count query ones.
    $hook_query_where .= "OR forumid IN($childForums)
        AND sticky = 0
        $prefix_filter
        $visiblethreads
        $globalignore
        $limitothers
        $datecut";
}

hook: forumdisplay_query_threadid

PHP Code:


		
			
if (in_array($foruminfo['forumid'], $masterForums)) {
    $childForums = implode(', ', $foruminfo['childlist']);

    // Same deal for the thread id query.
    $hook_query_where .= "OR forumid IN($childForums)
        AND sticky = 0
        $prefix_filter
        $visiblethreads
        $globalignore
        $limitothers
        $datecut";
}

;-)

Harpo

11-12-2012 11:04 AM

Hi I'm interested in this mod. I have not installed it yet...I was wondering How to do this.

I want to make the Master forum Thread listing as my "Index" So my members can browse the listings of threads collected.

Maybe have the Master Forum Thread listing located in my NAV menu. of course members can choose "forum" too from the NAV. to see the normal view.... If I'm making any sense. :P

Would this be possible with this mod?

Harpo

11-12-2012 10:50 PM

Hi again, Just installed it and followed the instructions. I made my master forum and set it up in my ACP. now when I try to enter the master forum I get the following Database error.

Database error in vBulletin 4.2.0:

Quote:

Invalid SQL:

SELECT COUNT(*) AS threads

FROM thread AS thread

/*
WHERE thread.forumid = 35
AND sticky = 0

AND visible IN (0,1,2);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*
WHERE thread.forumid = 35
AND sticky = 0

AND visible IN (0,1,2)' at line 9

My masterforum ID is 35. Any idea what went wrong?

All times are GMT. The time now is 05:48 PM.

Page 4 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.01651 seconds Memory Usage 1,875KB 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 (5)bbcode_code_printable (5)bbcode_php_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: