vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Adding a Dropdown to a Sidebar menu PHP Code (https://vborg.vbsupport.ru/showthread.php?t=326141)

scottkoz20 02-22-2018 02:06 PM

Adding a Dropdown to a Sidebar menu PHP Code
 
I had a suggestion come in from a member and I want to try and make it happen.

Currently, I have 3 different side blocks

1 - Member's last 5 started threads (thinking of eliminating)

and 2 for various sections of my forum (using the block default)


what I don't want to is add numerous blocks for each of the main categories, thus I was thinking about using a dropdown (something like this???)

Code:

$form = array('--Select Forum--', 'Baseball', 'Football', 'Hockey');
$selected_key = $_POST['form];
$selected_val = $form[$_POST[form']];

and I want to tie this to the code used for the last 5 member threads started and the base for allowing for the members to see the last 5-8 posts in a given section

Code:

global $vbulletin;
global $db;

        $sqlketnoi = $vbulletin->db->query_read("
        SELECT *
        FROM " . TABLE_PREFIX . "thread
        WHERE postuserid = ".$vbulletin->userinfo['userid']."
        ORDER BY threadid DESC
        LIMIT 5
        ");       
while($thread = $vbulletin->db->fetch_array($sqlketnoi))
{
$threadid = $thread['threadid'];
$title = $thread['title'];
$userid = $thread['postuserid'];
$username = $thread['postusername'];
$replycount = $thread['replycount'];
$dateline = date("m/d/Y",$thread['dateline']);

//forum name
        $sqlketnoi2 = $vbulletin->db->query_read("
        SELECT *
        FROM " . TABLE_PREFIX . "forum
        WHERE forumid = ".$thread['forumid']."
        ");       
        while($forum = $vbulletin->db->fetch_array($sqlketnoi2))
        {
                $forumtitle = $forum['title'];
                $forumid = $forum['forumid'];
                       
        }
        // print everything
                $templater = vB_Template::create('block_mythread');
                $templater->register('threadid', $threadid);
                $templater->register('title', $title);
                $templater->register('userid', $userid);
                $templater->register('username', $username);
                $templater->register('replycount', $replycount);
                $templater->register('dateline', $dateline);
                $templater->register('forumid', $forumid);
                $templater->register('forumtitle', $forumtitle);       
                $content .= $templater->render();               
}
return $content;



Is something like this even possible? I know I'd have to hook the dropdown in somehow, but this is where my lack of programming knowledge hurts me.



EDIT - here is my sidebar at the moment - the first block is the last 5 threads started

https://vborg.vbsupport.ru/external/2018/02/28.png


All times are GMT. The time now is 09:00 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.01012 seconds
  • Memory Usage 1,718KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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