Latest topics
» IconSkouliki Graphics
by skouliki Fri 20 Oct 2017, 05:08

» "Edit this page" feature
by skouliki Fri 20 Oct 2017, 01:37

» Dark Mode + Another Question
by Haggis Thu 19 Oct 2017, 10:36

» [GAME] Count to 1000 using even numbers Van-Helsing Edition
by Van-Helsing Tue 17 Oct 2017, 15:07

» [GAME] What are you thinking right now?
by Ace 1 Tue 17 Oct 2017, 08:09

» [GAME] Count to One Million!
by Ace 1 Tue 17 Oct 2017, 08:07

» [GAME] Last Letter Game
by Ace 1 Tue 17 Oct 2017, 08:06

» [GAME] World Snake
by Ace 1 Tue 17 Oct 2017, 08:06

» [GAME] Never have I ever..
by Ace 1 Tue 17 Oct 2017, 08:06

» [GAME] Animal Game
by universecat Mon 16 Oct 2017, 21:43

» [GAME] Post a random picture
by SLGray Mon 16 Oct 2017, 16:28

» Hi everyone!
by skouliki Mon 16 Oct 2017, 02:01

» Hai Guys~
by skouliki Mon 16 Oct 2017, 01:59

» Add a login popup for the toolbar
by Ape Sun 15 Oct 2017, 13:51

» Mobile Usability Test
by Ange Tuteur Sat 14 Oct 2017, 11:20

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

None

[ 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 : 4698
Points : 9540
Reputation : 2337
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