Recent Tutorials
Who is online?
In total there are 6 users online :: 2 Registered, 0 Hidden and 4 Guests

djblah, SLGray

[ View the whole list ]


Most users ever online was 172 on Fri 19 Feb 2016, 05:17

OpenDB

View previous topic View next topic Go down

avatar
Ange Tuteur
Administrator
Title :
Coffee Addict
Gender : Male
Age : 21
Posts : 4675
Points : 9689
Reputation : 2331
Location : Macungie, PA
Language : EN10, FR5
Browser : Browser : Brave Forum Version : Forum Version : Forumactif Edge
Awards :
View all awards
View user profile https://github.com/SethClydesdale https://twitter.com/sethc1995

PostAnge Tuteur on Fri 02 Jan 2015, 08:05

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 : http://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 Smile

View previous topic View next topic Back to top

Create an account or log in to leave a reply

You need to be a member in order to leave a reply.

Create an account

Join our community by creating a new account. It's easy!


Create a new account

Log in

Already have an account? No problem, log in here.


Log in

 
Permissions in this forum:
You cannot reply to topics in this forum