[2.0.21] Disable User Posting Privileges

Post by **Extensions Robot** » Wed Jun 07, 2006 7:21 pm

MOD Name: Disable User Posting Privileges
Author: Throckmorton
MOD Description: Disables a user's ability to post, reply to, edit or delete. The user can still log in, send or receive PMs, and access their profile.

MOD Version: 1.0.1

Download File: Disable User Posting Privileges v1.0.1.zip
mods overview page: View
File Size: 3449 Bytes

Support for this MOD needs to be asked within this topic. The phpBB Teams are not responsible or required to give anyone support for this MOD. By installing this MOD, the phpBB Support Team or phpBB MODifications Team may not be able to provide support.

This MOD has only been tested by the phpBB MOD Team with the phpBB version in the topic title. It may not work in any other versions of phpBB.

webmacster87 · Post by **webmacster87** » Thu Jun 08, 2006 2:28 pm

MOD Validated/Released

Notes:
As stated above, allows admins to remove all abilities related to posting on a board for a user on a user-by-user basis.

igorw · Post by **igorw** » Thu Jun 08, 2006 4:16 pm

Very nice mod. Thanks!

NappilyEvahAftah · Post by **NappilyEvahAftah** » Sun Jun 11, 2006 10:45 pm

This MOD is supposedly not installed, but it shows up in the EasyMod install history, but the folder is not in MODS. Why is that?

I still have the "Can user post?" section, in the User Management section. It's set to "no" (although the user can still post???!!), when I click "yes" and try to save, I get the error above.

This stuff is about to drive me totally batty. Any way to get this fixed? If I try to reinstall the MOD, using EasyMod, what will happen? I really would like this MOD, but I don't know what I'm doing, and I thought "EasyMod" was going to be my ticket to pimpin' up my forum, but I don't think so.

RATT · Post by **RATT** » Sun Jun 11, 2006 11:35 pm

You need to run the sql query, i explained how to do this in lamen terms in the other post u made

Code: Select all

ALTER TABLE phpbb_users ADD user_allowpost TINYINT(1) DEFAULT '1' NOT NULL ;

NappilyEvahAftah · Post by **NappilyEvahAftah** » Sun Jun 11, 2006 11:42 pm

I don't have PHPMyAdmin, because I don't know how to install it. So I can't "go to it", cuz it's not installed.

RATT · Post by **RATT** » Sun Jun 11, 2006 11:57 pm

If you have access to your phpadmin(MySQL Database) in your webhosting control panel click on that and go to your database.Use the dropbox to highlight the database you are using,Then at the top of the page you will see the word sql highlighted in red.Click on that and a box will open.Copy and paste that sql query

Code: Select all

This is the sql query
ALTER TABLE phpbb_users ADD user_allowpost TINYINT(1) DEFAULT '1' NOT NULL ;

and then click submit.

NappilyEvahAftah · Post by **NappilyEvahAftah** » Mon Jun 12, 2006 12:20 am

I didn't know PHPMyAdmin was ALREADY installed on my server. See? That's all you had to tell me. Okay, I did what you said, so let's see if it works!

NappilyEvahAftah · Post by **NappilyEvahAftah** » Mon Jun 12, 2006 12:25 am

So, I did it and what was it supposed to do? I still have an option "User can post" and if I check "yes" it get the debug error. So did I run the query on the wrong database?

I got a "sucessful" message, but it still doesn't take care of the error.

RATT · Post by **RATT** » Mon Jun 12, 2006 12:42 am

If you have more than one database then you would need to recheck to make sure you ran the query on the correct database.A successful execute means that the query was indeed ran successfully.If you are sure you ran that query on the correct database then there has to be some error in the coding of the mod.

Going by you error however, it appears to be only the sql error.

NappilyEvahAftah · Post by **NappilyEvahAftah** » Mon Jun 12, 2006 12:51 am

So, do I try to reinstall the MOD, using EasyMOD? Or will it mess up my database? That's what I need to know, cuz the option to allow/disallow the user to post is still there, even though the MOD is technically no longer there.

RATT · Post by **RATT** » Mon Jun 12, 2006 12:54 am

NappilyEvahAftah wrote: So, do I try to reinstall the MOD, using EasyMOD? Or will it mess up my database? That's what I need to know, cuz the option to allow/disallow the user to post is still there, even though the MOD is technically no longer there.

yes, you can comment out the line in the mod that tells easymod to run the sql query or manually remove it.

NappilyEvahAftah · Post by **NappilyEvahAftah** » Mon Jun 12, 2006 12:57 am

RATT wrote: yes, you can comment out the line in the mod that tells easymod to run the sql query or manually remove it.

How do I do that?

RATT · Post by **RATT** » Mon Jun 12, 2006 1:05 am

Open the mod in a text editor or notepad and look for

Code: Select all

#
#-----[ SQL ]----------------
#
ALTER TABLE phpbb_users ADD user_allowpost TINYINT(1) DEFAULT '1' NOT NULL ;
#
#-------

and make it look like this
#-----[ SQL ]----------------
#
#ALTER TABLE phpbb_users ADD user_allowpost TINYINT(1) DEFAULT '1' NOT NULL ;
#
#-------

or just remove this
#
#-----[ SQL ]----------------
#
ALTER TABLE phpbb_users ADD user_allowpost TINYINT(1) DEFAULT '1' NOT NULL ;

NappilyEvahAftah · Post by **NappilyEvahAftah** » Mon Jun 12, 2006 1:17 am

I figured out how to "comment out". I just removed the line in Notepad and saved the file and uploaded it all my MODS. Well, EasyMod doesn't detect it, cuz it's showing that it's already there.

So, I can't "reinstall" it cuz it's there, which I was trying to get rid of it, so I could reinstall, but it's not working. Sigh....

Rating: