vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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)

addamroy 02-07-2013 12:35 AM
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.

LifesGreatestGift 02-07-2013 02:43 AM
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?

addamroy 02-07-2013 02:55 AM
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 :(

LifesGreatestGift 02-07-2013 03:02 AM
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?

addamroy 02-07-2013 03:14 AM
It will show ON the thread they are viewing.

For example - This thread is at position 7

LifesGreatestGift 02-07-2013 03:20 AM
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.

addamroy 02-07-2013 09:15 PM
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

LifesGreatestGift 02-08-2013 01:17 PM
1 Attachment(s)
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.

addamroy 02-09-2013 12:43 PM
Perfect!

LifesGreatestGift 02-09-2013 01:10 PM
forgot to add the p and span to final code :) check now


All times are GMT. The time now is 03:04 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01042 seconds
  • Memory Usage 1,755KB
  • 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
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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