Miscellaneous ⇒ Chit-Chat :: Archives ⇒ How can I reset the number of news articles for all? :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexChit-Chat

Archived ⇒ How can I reset the number of news articles for all?


I have edited my settings to display 10 articles on the main page. I would like to reset it for all members as well over writing their prefernces as I am trying to shorten the length of my home page. Can anybody tell me some kind of a query that I can run to do the trick for me?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


UPDATE cms_users SET storynum=10;

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial


Thanks Maze. Just one more doubt that I have. Can I set a number like 6 or 7 which is given in the default choices?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


sure you can

UPDATE cms_users SET storynum=2;

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial

All times are UTC