Recent Topics

1 Nov 24, 2008 12:03    

My b2evolution Version: 2.x

In my system, I have more than 20 skins installed. But when I get to the admin area, general settings, installed skins, I only get 20 skins list with the data thaw how many times I`ve used a skin in my different blogs.

And I don´t find any way to see the rest of the list.

Anyone knows how to corret it?

2 Nov 25, 2008 18:24

This is a known bug, try cracking open inc/skins/views/_skin_list.view.php and changing the following line :

$Results = & new Results( 'SELECT T_skins__skin.*, COUNT(blog_ID) AS nb_blogs
													 	 FROM T_skins__skin LEFT JOIN T_blogs ON skin_ID = blog_skin_ID
													 	GROUP BY skin_ID', '', '', 999 );

¥

3 Nov 25, 2008 20:24

Done!!

Thank you so much!!!!!! :D

4 Nov 25, 2008 20:29

Tblue's gonna be gutted when he hears that it worked :D

¥

5 Nov 25, 2008 22:40

¥åßßå wrote:

Tblue's gonna be gutted when he hears that it worked :D

Heh, I suppose it will work until he has more than 999 skins :P (yeah, we all know this will never happen...).
Would you be so kind and test the following line?

$Results = & new Results( 'SELECT T_skins__skin.*, COUNT(blog_ID) AS nb_blogs
													 	 FROM T_skins__skin LEFT JOIN T_blogs ON skin_ID = blog_skin_ID
													 	GROUP BY skin_ID',
							'', '', NULL, 'SELECT COUNT( * ) FROM T_skins__skin' );


This should also work... At least it seems to work on my local installation. :)

6 Nov 26, 2008 09:29

Tblue wrote:

¥åßßå wrote:

Tblue's gonna be gutted when he hears that it worked :D

Heh, I suppose it will work until he has more than 999 skins :P (yeah, we all know this will never happen...).
Would you be so kind and test the following line?

$Results = & new Results( 'SELECT T_skins__skin.*, COUNT(blog_ID) AS nb_blogs
													 	 FROM T_skins__skin LEFT JOIN T_blogs ON skin_ID = blog_skin_ID
													 	GROUP BY skin_ID',
							'', '', NULL, 'SELECT COUNT( * ) FROM T_skins__skin' );


This should also work... At least it seems to work on my local installation. :)

I changed the code and it also works. The only difference is that with this second piece of code the skin list appears splitted in different pages, grouped in 20.

And with the first code, only 999 skins appear ( ;) ) in an unique list.

7 Nov 26, 2008 15:54

I changed the code and it also works. The only difference is that with this second piece of code the skin list appears splitted in different pages, grouped in 20.

Yeah, that's how it is supposed to be. Thanks for testing! ;)
BTW: You can change the default value of 20 results per page in your user profile.

Tblue

8 Jan 14, 2009 07:32

Tblue wrote:

In your dreams you'll be able to say my name

So ... uh ... how does one say "Tblue"? Must one say "Tea Blue", or can we be informal and say "teh blue"? Or is it one of those words with a silent letter like the P in psychological help resulting in your name being pronounced the way the color would be pronounced ('green')? Or are we expected to be creative and realize that "Tblue" is simply a unique way to spell "table" and that your sister "Chair" always picked on you for being eternally flat?

Oh and "OT" eh?


Form is loading...