Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mustyoshi]

I'm rewriting the database of my forums to make them cleaner and more efficient hopefully.

And I was wondering how I should handle user permissions for viewing boards. Any suggestions would be greatly appreciated.
EDIT:
What I have so far.

[Ķįŋg_Ţŗęļįcoŋ]

You have a forum?

[mustyoshi]

You have a forum?

I have like half a forum.
You can't private message yet, and there's no moderation.

[Ķįŋg_Ţŗęļįcoŋ]

You have a forum?

I have like half a forum.
You can't private message yet, and there's no moderation.

can you message me the link?

[Core]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

[mustyoshi]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

That's what I figured people would suggest.

[Core]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

That's what I figured people would suggest.

It's probably the simplest you can get. That's what I'm currently using in my own forum, and it seems to be working fine. But, you need to make sure that they still can't access it via the URL.

[Void_Knight]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

Have a table storing "groups" with permission bits as booleans, then store the group ID or whatever in the user so the database can just fetch the appropriate permission group and get the permissions the user is allowed from their permission group.

That's how The Tavern has quite a lot of groups of users that can do different things.

[Void_Knight]

Here's an example I made in excel with highlighted rows to help you see it.


If the ID of a group is too vague and hard to figure out if you're editing it via database - you can always do it by Name.

[Core]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

Have a table storing "groups" with permission bits as booleans, then store the group ID or whatever in the user so the database can just fetch the appropriate permission group and get the permissions the user is allowed from their permission group.

That's how The Tavern has quite a lot of groups of users that can do different things.

I've never used booleans before, mainly because they confuse me.

But, yeah, you could also use that.

[Void_Knight]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

Have a table storing "groups" with permission bits as booleans, then store the group ID or whatever in the user so the database can just fetch the appropriate permission group and get the permissions the user is allowed from their permission group.

That's how The Tavern has quite a lot of groups of users that can do different things.

I've never used booleans before, mainly because they confuse me.

But, yeah, you could also use that.

Seriously?

Booleans are either 0 (false) or 1 (true). Pretty straightforward and not hard at all if you ask me.

[Core]

I'd just have a row where you store the topics, and have it like "permissions." 1 = everyone can see, 2 = moderators can see, 3 = admins can see, etc.

Have a table storing "groups" with permission bits as booleans, then store the group ID or whatever in the user so the database can just fetch the appropriate permission group and get the permissions the user is allowed from their permission group.

That's how The Tavern has quite a lot of groups of users that can do different things.

I've never used booleans before, mainly because they confuse me.

But, yeah, you could also use that.

Seriously?

Booleans are either 0 (false) or 1 (true). Pretty straightforward and not hard at all if you ask me.

Alright, yes, I know how they are used or whatever, I just don't know how to set them up.

[mustyoshi]

Here's an example I made in excel with highlighted rows to help you see it.


If the ID of a group is too vague and hard to figure out if you're editing it via database - you can always do it by Name.

Hmm, interesting, right now I only have 6 permission levels; can't view, to full moderation privileges. I have them as a single int, where each user group, which I'm planning on having some sort of user created group deal, where they can make their own subforums and stuff. So custom user rules will be needed for those special boards.
Idk, it's a mess right now :c

[Void_Knight]

Here's an example I made in excel with highlighted rows to help you see it.


If the ID of a group is too vague and hard to figure out if you're editing it via database - you can always do it by Name.

Hmm, interesting, right now I only have 6 permission levels; can't view, to full moderation privileges. I have them as a single int, where each user group, which I'm planning on having some sort of user created group deal, where they can make their own subforums and stuff. So custom user rules will be needed for those special boards.
Idk, it's a mess right now :c

The reason I've made it like the example above is it's easier to assign permissions to groups and add new groups without editing code at all, plus it's easier to check if a user is higher in permissions rank than a certain user so you can have it so admins can't ban you or do anything to your account, moderators can't ban or do anything to admins' accounts. Works nicely.

Then, simply put I do the following to only allow a person to do something if they're able to lets say "Moderate"

if ($LocalUser->Permissions["Moderate"]) echo $LocalUser->Username.", you're a moderator. c:";


If user is higher than the other user in rank, echo "You're higher!"


$user1 = &$LocalUser; // reference pointer, ftw.
$user2 = new UserAccount(8); // User #8 

if ($user1->Permissions["Rank"] > $user2->Permissions["Rank"]) echo "You're higher!";

[Theblindman45]

Here's an example I made in excel with highlighted rows to help you see it.


If the ID of a group is too vague and hard to figure out if you're editing it via database - you can always do it by Name.

Hmm, interesting, right now I only have 6 permission levels; can't view, to full moderation privileges. I have them as a single int, where each user group, which I'm planning on having some sort of user created group deal, where they can make their own subforums and stuff. So custom user rules will be needed for those special boards.
Idk, it's a mess right now :c

Can I be a mod on there?