SQL ERROR [ mysqli ]
Posted: 17 Nov 2011, 21:43
I dont understand what you mean. Can you give me a copy and paste example?RMcGirr83 wrote:For starters using quote for coloring purposes
WHERE ' . $db->sql_in_set('t.forum_id', $flist) . ' AND topic_moved_id = 0 AND topic_approved
ORDER BY topic_last_post_time DESC';
Thanks, I understand this partRMcGirr83 wrote:you are missing the table delineation (aka t) and topic_approved should have a value....eg
Code: Select all
WHERE ' . $db->sql_in_set('t.forum_id', $flist) . ' AND t.topic_moved_id = 0 AND t.topic_approved = 1 ORDER BY t.topic_last_post_time DESC';
Wouldnt that result in categories being displayed?RMcGirr83 wrote:should beCode: Select all
and forum_type = 1
Code: Select all
AND forum_type = ' . FORUM_POST . '
I will try look harder. But I cant find any problems with the tabbing.RMcGirr83 wrote:The tabbing is also off within this file
which is more of a readability thing than anything else and indent is your friend!!Code: Select all
if (!defined('INCLUDES_FUNCTIONS_TOP_STATS_PHP')) { define('INCLUDES_FUNCTIONS_TOP_STATS_PHP', true); $flist = $auth->acl_getf('f_read', true); $flist = array_unique(array_keys($flist)); // Recent Active Topics if (!empty($config['tsrat_enable']) && sizeof($flist)) {