<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) PHP Fusion Inc
| https://phpfusion.com/
+--------------------------------------------------------+
| Filename: my_threads.php
| Author: Core Development Team
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once __DIR__.'/../../maincore.php';
if (!defined('FORUM_EXISTS')) {
redirect(BASEDIR."error.php?code=404");
}
if (!iMEMBER) {
redirect(BASEDIR."index.php");
}
require_once THEMES.'templates/header.php';
$inf_settings = get_settings('forum');
$locale = fusion_get_locale();
$userdata = fusion_get_userdata();
add_to_title($locale['global_041']);
$lastvisited = defined('LASTVISITED') ? LASTVISITED : time();
$rows = dbrows(dbquery("SELECT tt.thread_id FROM ".DB_FORUM_THREADS." tt INNER JOIN ".DB_FORUMS." tf ON tt.forum_id = tf.forum_id
".(multilang_table("FO") ? "WHERE ".in_group('tf.forum_language', LANGUAGE)." AND" : "WHERE")." ".groupaccess('tf.forum_access')." AND tt.thread_author = '".$userdata['user_id']."' AND tt.thread_hidden='0'"));
opentable($locale['global_041']);
if ($rows) {
$_GET['rowstart'] = !isset($_GET['rowstart']) || !isnum($_GET['rowstart']) ? 0 : $_GET['rowstart'];
$result = dbquery("SELECT tt.forum_id, tt.thread_id, tt.thread_subject, tt.thread_views, tt.thread_lastuser,
tt.thread_lastpost, tt.thread_postcount, tf.forum_name, tf.forum_access, tu.user_id, tu.user_name,
tu.user_status
FROM ".DB_FORUM_THREADS." tt
INNER JOIN ".DB_FORUMS." tf ON tt.forum_id = tf.forum_id
INNER JOIN ".DB_USERS." tu ON tt.thread_lastuser = tu.user_id
".(multilang_table("FO") ? "WHERE ".in_group('tf.forum_language', LANGUAGE)." AND" : "WHERE")." ".groupaccess('tf.forum_access')." AND tt.thread_author = '".$userdata['user_id']."' AND tt.thread_hidden='0'
ORDER BY tt.thread_lastpost DESC LIMIT ".$_GET['rowstart'].",20");
echo "<div class='table-responsive'><table class='table table-striped'>";
echo "<thead><tr>";
echo "<th></th>";
echo "<th><strong>".$locale["global_044"]."</strong></th>";
echo "<th><strong>".$locale["global_045"]."</strong></th>";
echo "<th><strong>".$locale["global_046"]."</strong></th>";
echo "<th><strong>".$locale["global_047"]."</strong></th>";
echo "</tr></thead>";
echo "<tbody>";
while ($data = dbarray($result)) {
$thread_rowstart = '';
if (!empty($data['thread_postcount']) && !empty($inf_settings['posts_per_page'])) {
if ($data['thread_postcount'] > $inf_settings['posts_per_page']) {
$thread_rowstart = $inf_settings['posts_per_page'] * floor(($data['thread_postcount'] - 1) / $inf_settings['posts_per_page']);
$thread_rowstart = "&rowstart=".$thread_rowstart;
}
}
echo "<tr>\n";
echo "<td>";
if ($data['thread_lastpost'] > $lastvisited) {
echo "<i class='fa fa-folder fa-2x'></i>";
} else {
echo "<i class='fa fa-folder-o fa-2x'></i>";
}
echo "</td>\n";
echo "<td><a href='".FORUM."viewthread.php?thread_id=".$data['thread_id'].$thread_rowstart."' title='".$data['thread_subject']."'>".trimlink($data['thread_subject'], 45)."</a><br />\n".$data['forum_name']."</td>\n";
echo "<td>".$data['thread_views']."</td>\n";
echo "<td>".($data['thread_postcount'] - 1)."</td>\n";
echo "<td>".profile_link($data['thread_lastuser'], $data['user_name'], $data['user_status'])."<br />\n".showdate("forumdate", $data['thread_lastpost'])."</td>\n";
echo "</tr>\n";
}
echo "</tbody>";
echo "</table></div>";
if ($rows > 20) {
echo "<div class='text-center'>".makepagenav($_GET['rowstart'], 20, $rows, 3, INFUSIONS."forum_threads_list_panel/my_threads.php?")."</div>\n";
}
} else {
echo "<div class='well text-center'>".$locale['global_053']."</div>\n";
}
closetable();
require_once THEMES.'templates/footer.php';