How do I increase the default of 25 posts displayed in each page of a forum?
Nov 16, 2005, 1:40 AM
User (339 posts)
Nov 16, 2005, 1:40 AM
Post #2 of 11
Views: 6749
Depends on what You need - 2 ways:
1. On admin side: Admin Panel > Setup > Defaults > default_mh_post
2. On user side: Edit Profile > Display Profile > Post max hits / page:
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
Nov 16, 2005, 6:40 AM
User (339 posts)
Nov 16, 2005, 6:40 AM
Post #4 of 11
Views: 6735
Try:
UPDATE gforum_User SET user_default_mh_flatpost = 25;
Remember to change gforum_ with your prefix if you changed on install time, and also the desired number of post 25 .. 30 ... etc.
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
UPDATE gforum_User SET user_default_mh_flatpost = 25;
Remember to change gforum_ with your prefix if you changed on install time, and also the desired number of post 25 .. 30 ... etc.
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
Nov 16, 2005, 6:57 AM
Novice (14 posts)
Nov 16, 2005, 6:57 AM
Post #5 of 11
Views: 6739
Uh oh... you are talking fast now. Say I want to change the default display from 25 to 40. Where do I do this? I am not sure the file you are referring to (UPDATE gforum_User SET user_default_mh_flatpost = 25;), plus it sounded like the change needed to be made in more than one file.
Nov 16, 2005, 7:06 AM
User (339 posts)
Nov 16, 2005, 7:06 AM
Post #6 of 11
Views: 6741
gforum_User is the Users table in SQL server, where all the user data is, and user user_default_mh_flatpost = 25 is column and value muste be chagned.
In your case the command should look as:
UPDATE gforum_User SET user_default_mh_flatpost = 40;
This sql query must be executed in mysqlman or in SQL Monitor (both are in your admin panel)
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
In your case the command should look as:
UPDATE gforum_User SET user_default_mh_flatpost = 40;
This sql query must be executed in mysqlman or in SQL Monitor (both are in your admin panel)
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
Nov 16, 2005, 10:49 AM
User (339 posts)
Nov 16, 2005, 10:49 AM
Post #8 of 11
Views: 6738
To make from long story short, if you PM me I can do the changes for you.
As for steps:
1st You must change the default values for your users from admin panel
2nd You must execute the given query to update the number shown posts to all present users (as for the moment they are set to 25)
3rd SQL Query is command that you run on your database server to update the necessary fields.
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
As for steps:
1st You must change the default values for your users from admin panel
2nd You must execute the given query to update the number shown posts to all present users (as for the moment they are set to 25)
3rd SQL Query is command that you run on your database server to update the necessary fields.
Cheers,
Boris
Facebook, Twitter and Google+ Auth for GLinks and GCommunity | reCAPTCHA for GLinks | Free GLinks Plugins
Mar 2, 2007, 8:11 PM
Novice (7 posts)
Mar 2, 2007, 8:11 PM
Post #9 of 11
Views: 6365
I have a similar goal, only mine is to decrease the default number of threads viewed per page to 15.
I changed the default_mh_forum in the Admin Panel to 15 a few days ago. It did not change the default for existing users (which didn't surprise me), but it also didn't change the default for new users who've signed up after the change.
I don't mind manually changing the default for all the existing users on a one-time basis, but it would be nice to not have to do it for every new user that signs up.
Any hints?
I changed the default_mh_forum in the Admin Panel to 15 a few days ago. It did not change the default for existing users (which didn't surprise me), but it also didn't change the default for new users who've signed up after the change.
I don't mind manually changing the default for all the existing users on a one-time basis, but it would be nice to not have to do it for every new user that signs up.

Any hints?
Mar 2, 2007, 10:44 PM
Staff (4101 posts)
Mar 2, 2007, 10:44 PM
Post #10 of 11
Views: 6348
As mentioned previously by eupos, you need to:
1) Change the default_mh_post option (Setup => Defaults). This option is used for guests and users who have an invalid user_default_mh_flatpost value.
2) Change the user_default_mh_flatpost default value. This is what new users will get set as their posts per page. Instead of executing raw SQL queries to change this, I'd recommend using the database editor. However, gforum's default columns are marked as un-editable from the database editor (so things aren't inadvertently broken), so you have to manually enter the url:
http://example.com/path/to/admin/db.cgi?db=User&do=editor_columns&modify=user_default_mh_flatpost
From here, you can change the default from 25 to whatever you want.
3) Although I don't suggest you do this, you can also change the default for your existing users. Just follow the instructions from above.
The same applies to the other columns like default_mh_forum/user_default_mh_forum, etc.
Adrian
1) Change the default_mh_post option (Setup => Defaults). This option is used for guests and users who have an invalid user_default_mh_flatpost value.
2) Change the user_default_mh_flatpost default value. This is what new users will get set as their posts per page. Instead of executing raw SQL queries to change this, I'd recommend using the database editor. However, gforum's default columns are marked as un-editable from the database editor (so things aren't inadvertently broken), so you have to manually enter the url:
http://example.com/path/to/admin/db.cgi?db=User&do=editor_columns&modify=user_default_mh_flatpost
From here, you can change the default from 25 to whatever you want.
3) Although I don't suggest you do this, you can also change the default for your existing users. Just follow the instructions from above.
The same applies to the other columns like default_mh_forum/user_default_mh_forum, etc.
Adrian