FM Design
Would you like to react to this message? Create an account in a few clicks or log in to continue.

IMPORTANT

FM Design is in read-only mode, please click here for more information.

Latest topics
» Forumactif Edge - Releases
by Ange Tuteur Tue 03 Sep 2019, 11:49

» GIFActif - Giphy Button for the Editor
by Ange Tuteur Wed 08 May 2019, 17:21

» Forum Closure
by Ange Tuteur Mon 01 Jan 2018, 01:28

» Chit Chat Thread
by Valoish Sun 31 Dec 2017, 19:15

» Font/Text background color.
by Valoish Sun 31 Dec 2017, 19:11

» Forumactif Messenger - Instant Message Application for Forumotion
by Wolfuryo Sun 31 Dec 2017, 18:24

» [GAME] Count to One Million!
by brandon_g Fri 29 Dec 2017, 18:58

» Post Cards
by manikbiradar Wed 20 Dec 2017, 07:50

» [GAME] Countdown from 200,000
by Valoish Wed 13 Dec 2017, 23:22

» GeekPolice Tech Support Forums - GeekPolice.net
by Dr Jay Mon 11 Dec 2017, 19:12

» Asking about some plugin for Forumotion
by Dr Jay Mon 11 Dec 2017, 19:10

» [GAME] What are you thinking right now?
by Van-Helsing Sat 09 Dec 2017, 14:51

» Widget : Similar topics
by ranbac Wed 06 Dec 2017, 18:11

» Change the Background of the Forum and put an image and how to make prefixs?
by Clement Wed 06 Dec 2017, 15:19

» Hello from Western Australia
by SarkZKalie Wed 06 Dec 2017, 05:34

Recent Tutorials
Top posting users this month

Who is online?
In total there are 21 users online :: 0 Registered, 0 Hidden and 21 Guests

None

[ View the whole list ]


Most users ever online was 515 on Tue 14 Sep 2021, 15:24

OpenDB

View previous topic View next topic Go down

Ange Tuteur
Ange Tuteur
Administrator
Gender : Male
Posts : 4741
Points : 12013
Reputation : 2375
Location : Pennsylvania
Language : EN, JA, FR
Browser : Browser : Brave Forum Version : Forum Version : Forumactif Edge
https://sethclydesdale.github.io/ https://twitter.com/sethc1995

PostAnge Tuteur 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.

OpenDB Captur10

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 )

OpenDB Captur11

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 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