vb.org Archive - Determine thread position in the threadlist

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

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Determine thread position in the threadlist (https://vborg.vbsupport.ru/showthread.php?t=294844)

Determine thread position in the threadlist

I have some ideas running around in my head but can't put my finger on how to make it happen.

Anyway what I want to accomplish somehow is...

possibly a conditional or a variable of some sort to determine a threads position in the threadlist. A conditional that I could use in SHOWTHREAD template.

For example,

In the showthread template I could add a line of code somewhere that says "Your thread is at X position in this forum" Where X would be the threads position in the thread list for that forum section.

Or I could use a conditional somehow, if X >= 20 then display a message that says "your thread is no longer on the first page.

Either way I'm just curious if there's any way to get the position of a thread, and have that be usable in the showthread template.

How would you determine which thread of the user's to check for? Would you just want it to check their "latest" thread?

--------------- Added [DATE]1360208626[/DATE] at [TIME]1360208626[/TIME] ---------------

Will it be every forum, or just one?

I was thinking in just one forum for now, and yes that message would only show if it's their own thread.

I know how to show the message in certain forums, in the right spot and only for the thread owner, but can't for the life of me figure out a way to determine the thread's position so I can use that info too :(

Will it be for the user's most recent thread? or all threads like "your threads are in position 8 and 14" or "your thread is in position 4" for just their most recent?

It will show ON the thread they are viewing.

For example - This thread is at position 7

This also depends on your forum sort order. what would that be?

--------------- Added [DATE]1360212358[/DATE] at [TIME]1360212358[/TIME] ---------------

This should help you A LOT. I am not sure if it needs to go into showthread_start or showthread_complete but the code is sound. may need a bit of tweaking. Hope it helps.

Code:

$current_thread = $threadinfo['threadid'];

$current_thread_forum = $threadinfo['forumid'];

$thread_owner = $threadinfo['postuserid'];

$current_user = $bbuserinfo['userid'];

$forum_id = 2;



if ($current_thread_forum == $forum_id) {

  if ($thread_owner == $current_user) {

    $query = $vbulletin->db->query_first('set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,threadid,postuserid,title FROM thread WHERE forumid = ' . $forum_id . ' AND postuserid = ' . $current_user . ' ORDER BY dateline DESC LIMIT 1;');

    $position = $query['row_number'];

    $display = "This thread is at position: " . $position;

    vB_Template::preRegister('SHOWTHREAD',array('display' => $display));

  }

}

Then you should be able to use {vb:raw display} in the SHOWTHREAD template.

Thanks for the help I appreciate it!

Unfortunately that didn't work using either showthread_complete or showthread_start :(

PS - My threads are sorted by start time

It does work, run this query inside phpmyadmin or whatever you use.

Code:

set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,threadid,postuserid,title FROM thread WHERE forumid = # AND postuserid = ## ORDER BY dateline DESC LIMIT 1;

# = forumid is the forum you want to use the mod in
## = userid , just make it one to run test on admin first user

will return row of thread with its placement. if you remove "LIMIT 1" it will show more threads.

--------------- Added [DATE]1360336817[/DATE] at [TIME]1360336817[/TIME] ---------------

ill revise the code in a bit. i forgot something.

--------------- Added [DATE]1360346941[/DATE] at [TIME]1360346941[/TIME] ---------------

Here is the final working and tested code. It will show the position of the thread based on start date, not last reply. With new threads being position 1. (if you would like it the other way around change "DESC" to "ASC" in the $query)

PHP Code:


		
			
$current_thread = $thread['threadid'];
$current_thread_forum = $thread['forumid'];
$thread_owner = $thread['postuserid'];
$current_user = $vbulletin->userinfo['userid'];
$forum_id = 2;

if ($current_thread_forum == $forum_id) {
  if ($thread_owner == $current_user) {
    $vbulletin->db->query_write('set @row_num = 0;');
    $query = $vbulletin->db->query_read_slave(
        'SELECT (SELECT @row_num := @row_num + 1) 
        AS row_number,threadid,postuserid
        FROM ' . TABLE_PREFIX . 'thread
        WHERE forumid = ' . $forum_id . ' 
        ORDER BY dateline DESC'
        );

    while($query2 = $vbulletin->db->fetch_array($query)) {
        if ($query2['threadid'] == $current_thread && $query2['postuserid'] == $current_user) {
                $position = $query2['row_number'];
                $display = "<p id='pos-text-main'><span>This thread is at position:</span> <span id='pos-num'>" . $position . "</span></p>";
        }
    }

    vB_Template::preRegister('SHOWTHREAD',array('display' => $display));
  }
}

add that code to a new plugin with hook showthread_complete

Then add the following where you want it inside of SHOWTHREAD.
{vb:raw display}

I have added some span id's so you can style it how you'd like.

Be sure to change $forum_id to the forum you'd like this running in.

--------------- Added [DATE]1360347115[/DATE] at [TIME]1360347115[/TIME] ---------------

Here is a sample CSS to add to additional.css

Code:

p#pos-text-main {

        background: rgb(255, 202, 202);

        border: 1px solid rgb(184, 0, 0);

        margin: 10px 0;

        padding: 10px;

}

span#pos-num {

        font-weight: bold;

}

It will only show for the thread author. Example attached.

forgot to add the p and span to final code :) check now

LifesGreatestGift, is there anyway I could use a vb:if conditional inside showthread with that new position variable? I just want to wrap it around something. vb:if condition="$position >= x" or something like that.

Theres no need, it will only display when the condition of the plugin is met. So just put it where you want and style it in the plugin.

Well I have another mod that shows a button somewhere else in the SHOWTHREAD template, and I want to essentially show one button there if the position is higher than a certain number, and another button if its lower than that number. Was hoping to accomplish that with a simple conditional, if it's possible anyway. No big need it's more of an extra.

will only the thread starter see it or everyone? if everyone, the query will need to be ran for everyone.

--------------- Added [DATE]1360715675[/DATE] at [TIME]1360715675[/TIME] ---------------

right now, the query is just ran for the thread author.

I see what you mean. Yes it does still have to work for the thread owner, but there is a vbif conditional for that right, thread postuserid == bbuserinfo userid or something like that? So I could wrap that conditional around it so the query is still only run for the thread owner, then a conditional inside that for $position (assuming I can even use that as a conditional as a result of using the code you gave me)

--------------- Added [DATE]1360715918[/DATE] at [TIME]1360715918[/TIME] ---------------

Maybe i just don't know what I'm talking about lol :/

I need to know, if everyone will be able to see the new button based on the condition you want to make, or just the thread author.

just the thread author

--------------- Added [DATE]1360724846[/DATE] at [TIME]1360724846[/TIME] ---------------

Right next to the new thread button is where I have it now. (it just doesn't change according to position) The only reason I mention that at all is because I was thinking of the 2 different hook locations you talked about, showthread_complete and showthread_start idk if that location makes a difference.

does this work?

Code:

<vb:if condition="$position == 2">DO THIS</vb:if>

only way you would be able to tell, is if you are the author of the second thread (or whatever number you put in the conditional). Test it out. If it doesnt work, in the code I gave you

FIND

Code:

vB_Template::preRegister('SHOWTHREAD',array('display' => $display));

REPLACE WITH

Code:

    vB_Template::preRegister('SHOWTHREAD',array('display' => $display));

    vB_Template::preRegister('SHOWTHREAD',array('position' => $position));

Then see if the conditional works.

I think it's stupid that I have to like someone else's post before I can like yours, LOL

That worked perfect, I had to add the second preregister line to make it work. Awesomeness. Thank you so much for the help, seriously appreciate it.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (19)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01438 seconds Memory Usage 1,788KB 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 (6)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (19)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
Messages: