vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Query to get a list of all public/available forums (https://vborg.vbsupport.ru/showthread.php?t=128250)

Erpenator 10-04-2006 10:27 AM
Query to get a list of all public/available forums
 
Hi all,

For a website we try to integrate some parts of the vBulletin forum into the CMS. Like shared login and add links to forum on news items.

We came across a problem with authorisation / forum access. We would like to produce a full list of all public/ available forums, but we are not able to filter the forums which you are not authorized to see based on forum userid. In our CMS we need to implement a list of all forums where you have acess so it can be added to a news item.

In the file includes\function_forumlist.php are several functions which show all sorts of list of forums but are very hard to implement in our main code.

Could someone explain how to filter available forums from the database on which you have access to bassed on the userid of the forum?

Just to make sure everybody understand what I mean: I am looking for a PHP sollution or SQL query which gives me a list of all public/available forums, exactly as a regular forum browser would see, without any additional rights

Erpenator 10-10-2006 06:55 AM
Is there anyone who can help me with this problem?

harmor19 10-10-2006 08:04 AM
I wrote what you want a while ago.

PHP Code:
$count = 0;
$getposts = $db->query_read(" 
    SELECT DISTINCT thread.title AS title, thread.threadid AS threadid, forum.forumid AS forumid
    FROM " . TABLE_PREFIX . "post AS post 
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread 
    ON post.threadid = thread.threadid
    LEFT JOIN " . TABLE_PREFIX . "forum AS forum
    ON thread.forumid = forum.forumid
    ORDER BY postid DESC");     
    while($post = $db->fetch_array($getposts)) 
    { 
          
        $forumperms = fetch_permissions($post['forumid']); 
        if (($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']) OR ($forumperms & $vbulletin->bf_ugp_forumpermissions['canviewthreads'])) 
        { 
            if($count <= 5) 
            { 
                $latestthreads2 .= "<b>Title</b>: <a href='showthread.php?t=$post[threadid]'>".$post['title']."</a><br />"; 
         
            } 
             
        $count++; 
         
        } 
    } 


All times are GMT. The time now is 08:15 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01068 seconds
  • Memory Usage 1,720KB
  • 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
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete