[For 1.8] Recent Threads On Index [Updated 02-12-19]

[dragonexpert]

This plugin adds the most recent threads to your index page.

Compatibility: 1.8.1 or higher
Latest Version: 17.0
Languages: English, German
Features:
- Uses the forum permission system
- Ajax refreshing every 30 seconds
- Ajax refreshes disabled after 15 minutes.
- Options for displaying avatars
- Options to exclude certain forums from having threads show
- Easily adjust how many threads you want to show
- Thread title links to the newest post you haven't read
- Username styles are maintained
- Reply count is clickable to bring up the list of who posted
- Variables for relative time, date, and standard time of last post
- Thread titles can be shortened along with an option of breaking at the word or character level.
- Option to select which groups can't use this.
- Option to show formatted thread prefixes.
- Setting to allow Thread Fields from XThreads
- Option to show formatted usernames
- Option to show thread creation date.
- Ability to use on additional pages.
- New file structure makes it easier to maintain for your programmers.

Installation:
1) Upload the zip file to your forum root and extract it. The file and folder directory is maintained.
2) Install and Activate in the Admin CP
3) Go to your index template and verify {$recentthread_headerinclude} and {$recentthreadtable} are on the template once each.
4) Customize settings to your liking.

Upgrading:
1) Upload recentthread.php to your inc/plugins folder.
2) Click the link that says Run Upgrade Script in the plugin's description.


XThreads Fields

You have two options if you choose to enable it.  You can either use the raw data from the database or formatted data.  You will place this code in the recentthread_thread template.

Raw: {$threadfields_raw[$tid]['fieldname']}
Formatted: {$threadfields_formatted[$tid]['fieldname']}

Download: http://community.mybb.com/mods.php?action=view&pid=191

Github

https://github.com/dragonexpert/recentthreads

For additional documentation, the read me file is your friend.

[ThePanda]

Unable to deactivate this plugin. Please help.

MyBB has experienced an internal SQL error and cannot continue.

How to remove this plugin manually? Are there any settings in the database?



Edit:

I deleted the templates but the plugin still showed up in the plugin list. So I tried to add the templates manually and it shows an error when I try to add the recentthread_thread template.

<tr>
    <td class="trow1"><a href="{$threadlink}">{$thread[\'subject\']}</a><br />{$thread[\'author\']}</td>
    <td class="trow1">{$thread[\'posts\']}</td>
    <td class="trow1">{$thread[\'views\']}</td>
    <td class="trow1">{$lastposttime}<br />
    <a href="{$lastpostlink}">Last Post:</a> {$lastposterlink}</td>
    </tr>

A potential security issue was found in the template. Please review your changes or contact the MyBB Group for support.

[.m.]

^ remove backslashes (i.e. \) from that recentthread_thread template codes

[ThePanda]

Thanks.

[deejayhan]

What ?
/inc/plugins/recentthread.php 77 errorHandler->error
/inc/class_plugins.php 139 recentthread_list_threads
/index.php 387 pluginSystem->run_hooks

[.m.]

^ when did you get those errors ? on activation or on the index page after adding the variable in index template
if the error is still on your forum, can we have forum url to see complete errors

[dragonexpert]

Unable to deactivate this plugin. Please help.

MyBB has experienced an internal SQL error and cannot continue.

How to remove this plugin manually? Are there any settings in the database?



Edit:

I deleted the templates but the plugin still showed up in the plugin list. So I tried to add the templates manually and it shows an error when I try to add the recentthread_thread template.

<tr>
    <td class="trow1"><a href="{$threadlink}">{$thread[\'subject\']}</a><br />{$thread[\'author\']}</td>
    <td class="trow1">{$thread[\'posts\']}</td>
    <td class="trow1">{$thread[\'views\']}</td>
    <td class="trow1">{$lastposttime}<br />
    <a href="{$lastpostlink}">Last Post:</a> {$lastposterlink}</td>
    </tr>

A potential security issue was found in the template. Please review your changes or contact the MyBB Group for support.

It would've helped a lot more if you posted what the SQL query was so I could figure it out faster. To fix the error change this line:

    $db->delete_query("templates", "name IN('recentthread','recentthread_thread')");

to this:

    $db->delete_query("templates", "title IN('recentthread','recentthread_thread')");

The mod site will be updated momentarily.

[Eldenroot]

3 problems:
- no date is shown
- no post count shown
- poster name should be smaller

[dragonexpert]

The date is not shown because realistically a forum should be getting daily posts. Note that I did make a variable called {$lastpostdate} available if you want it.

I forget it doesn't use the key posts for postcount. I'm used to my custom software where I called it posts. {$thread['posts']} should be changed to {$thread['replies']} in the recentthreads_thread template.

If you want the poster name to be smaller wrap a span tag around and give it the class smalltext. That is a template edit.

[ThePanda]

It would've helped a lot more if you posted what the SQL query was so I could figure it out faster.  To fix the error change this line:

Sorry, there was no sql query in the error box. If it had any sql query I would have posted it.