Raised This Month: $32 Target: $400
 8% 

Bulletin Board Admin Mod


Post New Thread Reply   
 
Thread Tools Display Modes
Plugin Info:     Modification:   ALL        Category:   Server Management        Approver:   GHW_Chronic (70)
DaSoul
Senior Member
Join Date: Jan 2006
Old 07-28-2006 , 16:52   Bulletin Board Admin Mod
Reply With Quote #1

/*
* by [gOf]-Soul from http://www.gofclan.org
*
* This is a very simple plugin I wrote to easily control my admin access
* based on phpbb user groups. With 7 servers it became very frustrating
* to keep up to date on who had what admin access to which servers. This
* allows us to do clan tag protection and clan recruitment tag protection
* on our servers to make sure only authorized people are wearing those tags.
* By using a clan tag protect plugin and given them the
* appropriate admin flags
* It also allows us to remove people from the clan and they automatically
* have their admin privs removed once they are removed from the admin
* groups on the forums.
*
* **WARNING** **WARNING** **WARNING** **WARNING** **WARNING**
* This plugin will overwrite your existing users.ini
* file. It does this so that if ever your database
* is unable to be reached there will be a cached version
* of your admin setup on the server so that people still
* retain their current admin.
*
* Admins arent granted access immediately through mysql and the forum plugin.
* It takes one map change for new admins to be picked up and for old admins to
* be removed from the system.
*
* I place this plugin above the admin.amxx plugin in the plugins.ini file
* The first time the plugin loads it cannot connect to the database. I assume
* because maybe some of the helper portions for db access has not been loaded
* yet. I have never tested this plugin down below where custom plugins
* normally go.
*
* Requires:
* AmxModX 1.75 and higher
* Mysql DB
*
* Forums Supported:
* PhpBB Forums
*
* Will support more forums is provided with tables and structure I need to hit
*
* To Install:
* Create bbmod.cfg file in your configs directory with the following information

bbmod_sql_host "127.0.0.1"
bbmod_sql_username "root"
bbmod_sql_password ""
bbmod_sql_database "dbname"
bbmod_phpbb_prefix "phpbb_"
bbmod_prefix "bbmod_"
bbmod_advert_show 1
bbmod_advert_frequency 10
bbmod_advert_delay 0.2
bbmod_advert_message 1
bbmod_advert_dontannoy 0
bbmod_advert_format 2

* Enter your values for the sql host, username, password, database and your
* database prefix.
*
* If you leave the default value for the bbmod_prefix then two tables will
* be created in your database

bbmod_version <- Used to keep track from update to update for any
possible database structure updates (automatic)

bbmod_linker <- Used to link your phpbb.user_id with your steamid
may integreate some type of forum stats in the future
if people are interested

* Create "groups.ini" in your configs directory in the following format:
* "phpbb forum group" "access flags being granted" (one line per group)

"Founders" "acdefghijklmnopqrstu"
"Clan Leaders" "acdefghijku"
"Senior Admins" "cdefijku"
"Junior Admins" "cdeiu"
"Clan Members" "it"
"RS All" "b"

*
* amx_setsteamid usage
* amx_setsteamid "your username here" "your password here"
*
* Each person or "clan member" in our case must run the amx_setsteamid
* command. Once they do that a forum link between their steamid and their
* forum user id will be created. Next map change if they deserve any admin
* flags based on their usergroup membership they will automatically be
* given the appropriate flags
*
* Plugin advertisment can be managed by the advert area of the config file
* bbmod_advert_show (1|0) // 1 = on, 0 = off
* bbmod_advert_frequency 10.0 // number of minutes between advertisement popups
* bbmod_advert_delay 2.0 // number of miunutes to wait before showing first
* advertisement
* bbmod_advert_format (1|2) // 1 = client print, 2 = hud message, 2 = default
* bbmod_advert_dontannoy (1|0) // 1 = annoy the heck out of them, 0 = only show advert once
* // if dontannoy is set to 1 then advert frequency is ignored

* 1.1c (08-05-2006)
-Added advert config information to the config file. To give a little more
control as to how the adverts behave. Defaults to non annoying mode.
-Moved the advert to the client_connect to only show it once per map if
the client has not linked their steamid
-Changed the name from Soul's DB Mod to Bulletin Board Admin Mod

* 1.1b (07-27-2006)
-Fixed the amx_setsteamid command so that everyone could run it.
-Updated documentation with the amx_setsteamid needed information

* 1.1a (07-27-2006)
-Code cleanup
-Removing debugging output code
-Added automatic table creation code
-Modified to new SQL version to eliminate studdering for remote sql server
-Added amx_setsteamid command that players run to automatically link their
forum account with their steamid

* 1.0 (12-12-2005)
* -Initial creation


///////////////////////////////////////
// //
// AUTHOR'S ADDITIONAL COMMENTS //
// //
///////////////////////////////////////

Open to all suggestions at this time. Although we don't use stats on our server
I may end up working some type of stats integration up. Would consider something
non-obtrusive in a regular php config. I don't like modifying phpbb config files
so would consider "graphics generation" link to give forum users that would allow
them to show their current stats/ranking information in their signature.

I suggest this might possibly work with hlstats because it takes a long time to copy
amxmodx stats information for 2k people out to the database from inside amxmodx
this is not an option for those of us that use remote mysql databases.

*/
Attached Files
File Type: sma Get Plugin or Get Source (bbmod.sma - 2069 views - 19.7 KB)
File Type: zip bbmod.zip (31.3 KB, 950 views)

Last edited by DaSoul; 08-07-2006 at 07:48.
DaSoul is offline
TiMbErLaNd
Senior Member
Join Date: Jan 2005
Location: Detroit, Michigan
Old 07-28-2006 , 16:57   Re: Soul's DB Mod
Reply With Quote #2

I will give you some feedback on this. This could be exactly what I have been looking for. The idea is at least perfect.
TiMbErLaNd is offline
DaSoul
Senior Member
Join Date: Jan 2006
Old 07-28-2006 , 17:00   Re: Soul's DB Mod
Reply With Quote #3

Quote:
Originally Posted by TiMbErLaNd
I will give you some feedback on this. This could be exactly what I have been looking for. The idea is at least perfect.
Thanks. I have used it for a long period of time. The only hitch I found is that our users.ini files have over 64 or some odd admins in it and the admin.sma file needs to be modified to allow more than 64 admins. But other than that it has been great.

Previously it required the modification of the phpbb_users table but I modified it to use a seperate table and to allow the setting of the steamid from inside the game. I guess I forgot to explain that in the documentation.

The user needs to run the

amx_setsteamid "their username" "their passsword"

from the console. To create that forum link. Once they do this it will pick up the information on the map change and see what groups they are in and then write out the proper users.ini entry for their steamid. I will have to see about adding this information to the plugin instructions. I also updated it so that it used the new sqlx commands. Now that I am using sqlx I may look into real-time checking of the db information to grant admin access. I couldnt use it before simply because of the database being remote would cause nice "pauses" in the game play while the system waited for the query to return.

Last edited by DaSoul; 07-28-2006 at 17:04.
DaSoul is offline
DaSoul
Senior Member
Join Date: Jan 2006
Old 07-28-2006 , 17:22   Re: Soul's DB Mod
Reply With Quote #4

I just found a bug. amx_setsteamid doesnt allow you to use it if you have no amx access. I just need to find out how to enable anyone to do it. I will see about that in a minute.
DaSoul is offline
knekter
Senior Member
Join Date: Mar 2004
Location: PA
Old 07-28-2006 , 18:29   Re: Soul's DB Mod
Reply With Quote #5

This was absolutley an outstanding idea, great work and great code. Neat clean and very effective, +karma.
__________________
More updates for Matrix Mod!
knekter is offline
Send a message via AIM to knekter Send a message via MSN to knekter
DaSoul
Senior Member
Join Date: Jan 2006
Old 07-28-2006 , 18:31   Re: Soul's DB Mod
Reply With Quote #6

Quote:
Originally Posted by knekter
This was absolutley an outstanding idea, great work and great code. Neat clean and very effective, +karma.
It is bugged right now. it does not work correctly.

Nonadmin users cant run amx_setsteamid to link their steamid into the forums.

I am trying to figure out how to do it now.
DaSoul is offline
DaSoul
Senior Member
Join Date: Jan 2006
Old 07-28-2006 , 19:11   Re: Soul's DB Mod
Reply With Quote #7

I found out where the problem was. When I installed it onto my inet hlds I forgot to put the dbmod.cfg on correctly.

But I also fixed it so that anyone could run the amx_setsteamid command.
DaSoul is offline
DaSoul
Senior Member
Join Date: Jan 2006
Old 07-29-2006 , 17:51   Re: Soul's DB Mod
Reply With Quote #8

Things I have finished for next release:
- Plugin Advertisment Control
*Enable or Disable Advertisement
*Advertisment Start Delay
*Advertisment Frequency
*Advertisment Style (hudmessage or client print)
*Advertisment non-nag mode. Only displayed to players that dont have a forum link established. Only display once or annoying them and display the advert on a frequency.

Possible additions? Enhancements?
I don't know. But this is a copy of the text I have in the version of the plugin I have that has yet to be released.

Code:
/*

///////////////////////////////////////
//                                   //
//   AUTHOR'S ADDITIONAL COMMENTS    //
//                                   //
///////////////////////////////////////
  
Open to all suggestions at this time.  Although we don't use stats on our server
I may end up working some type of stats integration up.  Would consider something
non-obtrusive in a regular php config.  I don't like modifying phpbb config files
so would consider "graphics generation" link to give forum users that would allow
them to show their current stats/ranking information in their signature.

I suggest this might possibly work with hlstats because it takes a long time to copy
amxmodx stats information for 2k people out to the database from inside amxmodx
this is not an option for those of us that use remote mysql databases.
  
*/
__________________
DaSoul is offline
GHW_Chronic
SourceMod Donor
Join Date: Sep 2004
Location: Texas
Old 08-02-2006 , 04:52   Re: Soul's DB Mod
Reply With Quote #9

Please add "PHPBB" somewhere into the title. Something like "Soul's PHPBB admin access mod" or whatever.

PS: Hawt.
GHW_Chronic is offline
Send a message via AIM to GHW_Chronic
Old 08-02-2006, 04:57
VEN
This message has been deleted by VEN. Reason: delme
pulpy
Senior Member
Join Date: Oct 2005
Location: Brights Grove, ON
Old 08-02-2006 , 05:45   Re: Soul's DB Mod
Reply With Quote #10

any chance of an IPB integration?
__________________
pulpy is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 20:44.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode