Your looking at it.

This is a modified build of phpWiki. I searched for a wiki that natively supports a shared public / private wiki. Unfortunately none do this off the shelf (mediaWiki does with extensions), but since phpWiki does ACL permissions by default this seemed like a good place to start.

Essentially I've I turned this into a single user wiki (easily extended Im sure), with only two ACL settings for each page, either Public or Private. I'm modified the locked / unlocked functionality to indicate (to me) which pages are publicly accessible, and this also makes it easy to change page permissions.

Once I'm happy with the finial result the changes will be illustrated here.

Another great thing about phpWiki, it generally uses the same tagging as mediaWiki :)

---Database manangement---

One downside of Mediawiki is that the sessions table in the db doesnt get purged, so you need to go in every few months a purge it. - Similar for the accesslog.

A SQL query to return the diskspace used by the db is the following

SELECT TABLE_NAME, table_rows, data_length, index_length, round( (
data_length + index_length
) /1024 /1024 ) , 2
) "Size in MB"
FROM information_schema.TABLES
Favorite Categories