search

wolffe / phpsqlitecms

phpSQLiteCMS is a simple and lightweight web content management system based on PHP and SQLite.
https://getbutterfly.com/phpsqlitecms/
MIT License
1 stars 0 forks source link

feature request: private posts, also for non-editor registered readers #2

Open jasper-e opened 1 month ago

jasper-e commented 1 month ago

I would highly appreciate one more user role: non-editor registered reader, for the purpose of private posts that are only available to them. Also providing a reusable function that can be used as a content function for the privilege level of the user would be appreciated.

I could volunteer to implement the code and the initial.sql part (due to other duties it is going to be slow), if any changes are required on the delivered sqlite database files I will not be able to make them, as I am restricted to an environment without sqlite driver.

PS: I can only think about moving together as long as other DBs, at least MySQL is supported.

jasper-e commented 4 days ago

I am gatting close to get through my more urgent things, probably in 2-3 weeks I will try to play with the code.

The lightest way to implement the reader-only user for content only for logged-in user seems to me to alter the field type in table ..._userdata to be nullable.