Top Stats

Modifications for phpBB3.
Try the Mods here and share Your own Mods
Forum rules
You dont have to use ModX or make your mod AutoMod compatible. A simple textfile is fine
But if you post Mods here You also have to give support

SQL ERROR [ mysqli ]

Post by RMcGirr83 »

Stoker wrote:Why is that Rich?
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';
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';

Code: Select all

and forum_type = 1
should be

Code: Select all

AND forum_type = ' . FORUM_POST . '
for example

The tabbing is also off within this file

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))
{
which is more of a readability thing than anything else and indent is your friend!! :)

Problem in IE8

Post by Stoker »

Did you do the css edit and after that refresh the theme?
And also refresh browser?

Do you have the same problem here?

Problem in IE8

Post by Makis »

Yes I did
No the problem exists only in my site and ONLY with IE8
Thanks

Edit: V TopStats 1.0.6

SQL ERROR [ mysqli ]

Post by Solidjeuh »

Yes! everythingg works now with 1.0.6!
Thank you so much!
:D

SQL ERROR [ mysqli ]

Post by martin123456 »

confirmed it works :D

Problem in IE8

Post by RMcGirr83 »

CTRL + F5 your browser to refresh the cache of it which will reload the css.

Problem in IE8

Post by Makis »

All done, I say all work like a charm tested in 7 known browsers + IE9,
but with IE8 with which I see this very site and others sites nice
mine looks like in the photo above

.....and keep scrolling :?

Problem in IE8

Post by doktornotor »

Well, then purge the browser cache and restart the browser.

SQL ERROR [ mysqli ]

Post by Stoker »

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';
I dont understand what you mean. Can you give me a copy and paste example?

RMcGirr83 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';
Thanks, I understand this part :)

RMcGirr83 wrote:

Code: Select all

and forum_type = 1
should be

Code: Select all

AND forum_type = ' . FORUM_POST . '
Wouldnt that result in categories being displayed?


RMcGirr83 wrote:The tabbing is also off within this file

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))
{
which is more of a readability thing than anything else and indent is your friend!! :)
I will try look harder. But I cant find any problems with the tabbing.

Collapsible Categories / Top Stats

Post by Solidjeuh »

Here I am again ... haha
I tried to add that Collapsible Categories into the top stats .. but I failed .. lol
How did you get that to work in here please?

And also in that mchat ..?

This is the one I'm using:
Collapsible-Categories.zip
You do not have the required permissions to view the files attached to this post.