Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-05-2004, 04:33 AM
Logikos Logikos is offline
 
Join Date: Jan 2003
Posts: 2,924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Just a little help with something

Hey, i'm in the middle of finishing a hack of mine. In the hack it uses the /admincp/forums.php file. To turn this hack on/off of a per forum baisis. Look here so you get a better understanding.

PHP Code:
        print_yes_no_row($vbphrase['turn_marlboro_on_off'], 'forum[marlboro]'$forum['marlboro']); 
Now in some files im using this:
PHP Code:
if ($foruminfo['marlboro']=='1')
{
                
Code here
}
else
{
                
Code Here

Basicly If custom hack is turned on for that forum show this, if not show this instead.

Now my problem is, i have to call the forum IDs that the custom hack is turned on. Heres the query im using now.

PHP Code:
        $mar $DB_site->query("
                SELECT
                thread.threadid as threadid,thread.title as title,thread.forumid as forumid,thread.postusername as postusername,thread.dateline as dateline
                FROM thread AS thread
                WHERE postuserid= 
$userinfo[userid] AND forumid IN(X,Y,Z)
                ORDER BY dateline DESC
        "
); 
Notice the X,Y,Z. I would have to put the forum IDs there, i know i could make this a vbulletin setting and use $vboptions['forum_ids'] in place of the forumid IN(X,Y,Z), but i would rather not have the user turn it on in the forum, and then add the forumid in a box in the vbulletin options area.

Does anyone know what i could use for that query to grab the turned on forums id?

Something like this?
PHP Code:
        $mar $DB_site->query("
                SELECT
                thread.threadid as threadid,thread.title as title,thread.forumid as forumid,thread.postusername as postusername,thread.dateline as dateline
                FROM thread AS thread
                WHERE postuserid= 
$userinfo[userid] AND forumid IN(($foruminfo['marlboro'])
                ORDER BY dateline DESC
        "
); 
Doubt i'm even close. Thanks in advance!
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:29 AM.


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.06574 seconds
  • Memory Usage 2,461KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (5)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete