Lonely/Open Threads Listing

Tutorial Created By: isoldehn
Tutorial Permissions: Please do not re-post this tutorial else where, instead link someone to this thread.

- Additionally, you are NOT required to credit me if you use these codes on your board BUT I do wish for you to share this with those that ask about it if they ever do (share the knowledge, be kind).
Tutorial Needs: Overall, the ability to copy and paste.
- FTP/File Access To Web Space

Step One

Create the lonely threads file. Open your FTP client or file manager/file area of your web space. In your MyBB directory (usually located directly in public_html) create a new file called lonelythreads.php and insert the following code.

<?php
// *********************************************************
// * Listing by isoldehn 2019.                             *
// * Free for for general public usage and change!         *
// * Please do not claim as your own nor charge money to   *
// *  install this for others.                             *
// * If any issues contact isoldehn on RPG Initiative.     *
// *********************************************************

define("IN_MYBB", 1);
define('THIS_SCRIPT', 'lonelythreads.php');
$templatelist = "lonelythreads,lonelythreads_entry,lonelythreads_empty";
require "./global.php";
add_breadcrumb("Lonely Threads", "lonelythreads.php");

// *********************************************************
// *********************************************************
// *********************************************************

$query = $db->query("
	SELECT *
	FROM ".TABLE_PREFIX."threads
	WHERE ".TABLE_PREFIX."threads.prefix IN (#)
	AND ".TABLE_PREFIX."threads.replies <= #
	AND ".TABLE_PREFIX."threads.lastpost >= ".TIME_NOW." - (# * 86400)
	ORDER BY lastpost DESC
");

// SPECIFIED PREFIX IDS
// WHERE ".TABLE_PREFIX."threads.prefix IN (#)
// Please insert the pids or pid of the prefix(es) in question. These can be found by navigating to Admin CP --> Configuration --> Thread Prefixes. Click the prefix(es) in question, use the number(s) at the end of url(s).

// SPECIFIED NUMBER OF REPLIES
// AND ".TABLE_PREFIX."threads.replies <= #
// Please insert the least amount of replies needed in order to list the thread. If you do not want a specified amount of replies then remove this AND query.

// SPECIFIED LAST REPLY DATE
// AND ".TABLE_PREFIX."threads.lastpost >= ".TIME_NOW." - (# * 86400)
// Please insert the amount of days from the last post that the thread may be shown. 30 for example will show all threads with a post within the last 30 days.

// *********************************************************
// *********************************************************
// *********************************************************

while($thread=$db->fetch_array($query)) {
    $thread['threadlink'] = get_thread_link($thread['tid']);
	$thread['lastpostlink'] = get_thread_link($thread['tid'], 0, "lastpost");
	$thread['threadprefix'] = $threadprefix = '';
		if($thread['prefix'] != 0)
		{
			$threadprefix = build_prefixes($thread['prefix']);
			if(!empty($threadprefix))
			{
				$thread['threadprefix'] = $threadprefix['displaystyle'].' ';
			}
		}
	$thread['author'] = $thread['uid'];
		if(!$thread['username'])
		{
			if(!$thread['threadusername'])
			{
				$thread['username'] = $thread['profilelink'] = htmlspecialchars_uni($lang->guest);
			}
			else
			{
				$thread['username'] = $thread['profilelink'] = htmlspecialchars_uni($thread['threadusername']);
			}
		}
		else
		{
			$thread['username'] = htmlspecialchars_uni($thread['username']);
			$thread['profilelink'] = build_profile_link($thread['username'], $thread['uid']);
		}
	$lastpostdate = my_date('relative', $thread['lastpost']);
	$thread['lastpostlink'] = get_thread_link($thread['tid'], 0, "lastpost");
	$lastposteruid = $thread['lastposteruid'];
		if(!$lastposteruid && !$thread['lastposter'])
		{
			$lastposter = htmlspecialchars_uni($lang->guest);
		}
		else
		{
			$lastposter = htmlspecialchars_uni($thread['lastposter']);
		}
		$lastpostdate = my_date('relative', $thread['lastpost']);

		// Don't link to guest's profiles (they have no profile).
		if($lastposteruid == 0)
		{
			$lastposterlink = $lastposter;
		}
		else
		{
			$lastposterlink = build_profile_link($lastposter, $lastposteruid);
		}
		
	eval("\$lonelythreads .= \"".$templates->get("lonelythreads_entry")."\";");
}

if (!$lonelythreads)
{
    eval("\$lonelythreads .= \"".$templates->get("lonelythreads_empty")."\";");
}

eval("\$lonelythreads = \"".$templates->get("lonelythreads")."\";");
output_page($lonelythreads);
?>

NOTE(S):

• Be sure you change all traces of # to the correct ids needed.
  • The file contains // notes for you to follow along to. Please find the notes and edit as suggested.

Step Two

Create new templates for our listing. Navigate to Admin CP --> Templates & Style --> Templates --> Global Templates --> Add New Template (for each one).

Template Name: lonelythreads

<html>
<head>
<title>{$mybb->settings['bbname']} - Lonely Threads</title>
{$headerinclude}
</head>
<body>
{$header}
	
	<table width="100%" cellpadding="5px" cellspacing="0" border="0">
		<tr>
			<td colspan="5" class="thead">Lonely Threads</td>
		</tr>
		{$lonelythreads}
	</table>
	
{$footer}
</body>
</html>

Template Name: lonelythreads_entry

<tr>
	<td style="text-align: center; padding: 10px;" class="trow1">
		{$thread['threadprefix']}
	</td>
	<td style="text-align: left;" class="trow1">
		<a href="{$thread['threadlink']}"><strong>{$thread['subject']}</strong></a>
		<br />
		by {$thread['profilelink']}
	</td>
	<td style="text-align: center;" class="trow1">
		<a href="{$thread['tid']}" onclick="MyBB.whoPosted({$thread['tid']}); return false;">{$thread['replies']}</a> replies
	</td>
	<td style="text-align: center;" class="trow1">
		{$thread['views']} views
	</td>
	<td style="text-align: right;" class="trow1">
		{$lastpostdate}
		<br />
		<a href="{$thread['lastpostlink']}">Last Post</a> by {$lastposterlink}
	</td>
</tr>

Template Name: lonelythreads_empty

<tr>
	<td colspan="5" style="text-align: center; padding: 10px;" class="trow1">
		Currently no threads to display.
	</td>
</tr>

Step Three

Confirm your new page is working by navigating to yoursiteurl/lonelythreads.php and if it is working appropriately you should see a listing of your specifications!