OpenDB

Hello,

If you've been getting that error page, it's because I have been working on a project. It involves an Open Topic Database ( OpenDB ) that is modifiable by all members. This method is very vulnerable, but regardless it is still useful to a degree, especially with daily backups. Due to the lack of database access, this is a good alternative if you're not familiar with databases like MySQL, or simply can't find a host to set a database up.


The example above shows a simple database table that hold some data of the users. This data can be used later for other means, but as it stands, this database is only an example. The updates are a little clunky at the moment, for modifications members need to be set to moderator of the section to edit the databases. The best thing to do is auto-sub all members, disable auto-sub, then allow them moderation of your OpenDB forum. ( the group )


The first plugin to run of this database is a like system that saves and gets the person who liked that post. It stores the post id, user id, and username. When a post is liked, it makes contact with the database to check if a row already exists for the post. If so, it will add the username and id to the user cell, if not it will create a new row. Lastly when viewing a topic contact is also made with the database to check if any of the posts have a database row.

Posts liked before the installation will only show the like number. The names and post id would need to be logged in the database for the users to show.

Since the database is open, you can take a look at the CP here : https://fmdesign.forumotion.com/t252-database

This is still early, so if you notice any bugs let me know. You can leave any comments below as well.

Thanks