Sir Flaco wrote: Both those directories are gone and I am still not able to enable the Hide Zero Posters
Well, in that case, I really don't know what to say...
freerider381 wrote:My guess would be that you're using MySQL 3.23 - a version of MySQL that this MOD doesn't support.
Its running 4.1.21-standard. Any ideas how to fix it?
Sir Flaco wrote: Hello
I am now trying to install the "Hide Zero Posters - Categories Hierarchy Addition"
It was recommended that I install "Categories hierarchy" first.
Code: Select all
UPDATE phpbb_users AS u,phpbb_posts AS p1 LEFT OUTER JOIN phpbb_posts AS p2 ON p1.poster_id = p2.poster_id AND p2.post_time < p1.post_time INNER JOIN phpbb_posts AS p3 ON p3.post_time = p1.post_time SET u.user_firstpost=p3.post_time WHERE p2.post_time IS NULL AND p1.poster_id = u.user_id;;
FIND FAILED: In file [includes/functions.php] could not find:
WHERE user_id <> " . ANONYMOUS;
MOD script line #157 :: FAQ :: Report
TheXev wrote:FIND FAILED: In file [includes/functions.php] could not find:
WHERE user_id <> " . ANONYMOUS;
MOD script line #157 :: FAQ :: Report
I just tried applying this mod to a freshly installed phpBB installation using 2.0.22 (although its based on an already existing database [that i cleaned before reinstallation with the Clean phpBB SQL Tables 1.0.8 mod]).
I did apply some other mods before hand:
EasyMOD 0.3.0
SQL Backup 1.0.11
Block Open Proxy Registrants 2.2.1
Disable Board Message 1.4.1
Anti-spam ACP 2.0.0a
Log IP Address on Registration 1.0.0
Rebuild Search 2.4.0
http://www.revolve-trans.org/forums/
Code: Select all
$sql = "SELECT COUNT(user_id) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS. $as_sql;
Code: Select all
$as_sql = ($board_config['as_acp_hide_inactive']) ? ' AND user_active = 1' : '';
Code: Select all
{
$meta = '<meta http-equiv="refresh" content="3;url=../../includes/%20.%20append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $forum_id) . '">';
$message = $lang['Deleted'];
}
else
{
$meta = '<meta http-equiv="refresh" content="3;url=../../includes/%20.%20append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $topic_id) . '">';
$message = (($mode == 'poll_delete') ? $lang['Poll_delete'] : $lang['Deleted']) . '<br /><br />' . sprintf($lang['Click_return_topic'], '<a href="../../includes/'%20.%20append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id") . '">', '</a>');
}
$message .= '<br /><br />' . sprintf($lang['Click_return_forum'], '<a href="../../includes/'%20.%20append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id") . '">', '</a>');
Code: Select all
$meta = '<meta http-equiv="refresh" content="3;url=../../includes/%20.%20append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $post_id) . '#' . $post_id . '">';
$message = $lang['Stored'] . '<br /><br />' . sprintf($lang['Click_view_message'], '<a href="../../includes/'%20.%20append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $post_id) . '#' . $post_id . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_forum'], '<a href="../../includes/'%20.%20append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id") . '">', '</a>');
Parse error: syntax error, unexpected T_STRING in /home/*****/public_html/forums/includes/functions.php on line 40
Code: Select all
case 'newestuser':
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . ($board_config['zero_newest'] ? " AND user_firstpost <> 0" : "")
ORDER BY " . ($board_config['zero_newest'] ? 'user_firstpost' : 'user_id') . " DESC
LIMIT 1";
break;
Code: Select all
case 'newestuser':
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . ($board_config['zero_newest'] ? " AND user_firstpost <> 0" : "");
// ORDER BY " . ($board_config['zero_newest'] ? 'user_firstpost' : 'user_id') . " DESC
// LIMIT 1";
break;