Determine thread position in the threadlist

[LifesGreatestGift]

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

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

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.