news stories on main page showing more that configured too.

Regular Joined: Aug 04, 2006 Posts: 64

Hello All,

I though in the older versions of phpnuke there was a way to set how many news stories showed on the main page.

When i goto Preferences and setup these

Number of Items in Top Page: 5
Stories Number in Home: 5

It shows more than 5 news stories. It this normal ? Is there a fix for this?

Lonk [ Only registered users can see links on this board! Get registered or login! ]

Posted: Tue Jul 17, 2007 1:19 pm

Users can set their own preferences on how many stories they want to see in Your Account / Your Home. The setting you are talking applies to non-members or people not logged in.

Posted: Tue Jul 17, 2007 5:06 pm

ok wow i have never noticed that before. Thanks for the info. Is there a way to make the default for all users 5 ?

Posted: Tue Jul 17, 2007 5:42 pm

I don't know of an admin function to do that, but you could run an SQL query in phpMyAdmin to set everyone's setting to 5.

UPDATE nuke_users SET storynum = 5 WHERE 1

I just made that up, so try at your own risk. Smile

Posted: Tue Jul 17, 2007 11:57 pm

well i used

UPDATE nuke_users SET storynum = 5 WHERE 10

and it worked great. many thanks Gremmie

I also went in and set Table: nuke_users, storynum to default of 5 i am hoping this will set it to 5 when i have a new user register on the website.

Lonk

Posted: Wed Jul 18, 2007 7:14 am

Cool! Just so you know, the WHERE 10 is equivalent to WHERE 1, and in fact I probably should have left the WHERE clause off altogether. They are both equivalent to this (this updates all rows):

UPDATE nuke_users SET storynum = 5

If you really only wanted to change just the 10's to 5's then you could have written

UPDATE nuke_users SET storynum = 5 WHERE storynum = 10

Setting the default to 5 may work, but the SQL that INSERT's a new user may provide a value (and if it does hopefully it is providing the value from admin/preferences).