473,396 Members | 1,743 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Blocking out new membership?

nomad
664 Expert 512MB
Hello everyone:

I have a forum in which we have 100 members and we wish to block out any new memberships. I was thinking of write a query that would block out any new memberships and I need a little help doing this.

this is what i have
the table is phpbb_users
the field name is user_id note this use id is made automatically

Should this be a sql or a php.
Would also need to change this if there is a new member that we approve.

thanks
nomad
Mar 26 '08 #1
16 1590
Markus
6,050 Expert 4TB
Cant you just remove the code that inserts new users into the database?
Mar 26 '08 #2
nomad
664 Expert 512MB
Cant you just remove the code that inserts new users into the database?
Never thought of that, but it might effect the db.
There is a premade hack that I can use. I just thought my ideal would be better.

nomad
Mar 26 '08 #3
Markus
6,050 Expert 4TB
Never thought of that, but it might effect the db.
There is a premade hack that I can use. I just thought my ideal would be better.

nomad
I don't understand how it would affect the DB - all you need to do is remove what the end-user would use to sign up, and that is the PHP code used for the sign up.

Good luck!

Regards.
Mar 26 '08 #4
TheServant
1,168 Expert 1GB
Are the forums your design and code? If they are some sort of package like phpbb or something, you could just require email and admin confirmation and then just ignore/reject those who apply for memebership. No hacks ;)
Mar 26 '08 #5
nomad
664 Expert 512MB
Are the forums your design and code? If they are some sort of package like phpbb or something, you could just require email and admin confirmation and then just ignore/reject those who apply for memebership. No hacks ;)
Hello TheServant:
Yes the site is phpbb. Really can not ignore them and I do have the admin confirmation. The reason I want the block is because of all the porn sites. When a user signs up their membership name is shown along with a website if they chose to add one.
I'm going to try to make a query to block the id number to only 101. or use a hack.

nomad
Mar 27 '08 #6
TheServant
1,168 Expert 1GB
Hello TheServant:
Yes the site is phpbb. Really can not ignore them and I do have the admin confirmation. The reason I want the block is because of all the porn sites. When a user signs up their membership name is shown along with a website if they chose to add one.
I'm going to try to make a query to block the id number to only 101. or use a hack.

nomad
Fair enough. Can you not filter them or something? I just feel that if you're limiting your member number at 100, the forums won't be all that active? What about if some one leaves? Will they give thir account to someone? Or will you prune inactive members often?
Mar 27 '08 #7
Markus
6,050 Expert 4TB
Fair enough. Can you not filter them or something? I just feel that if you're limiting your member number at 100, the forums won't be all that active? What about if some one leaves? Will they give thir account to someone? Or will you prune inactive members often?
To prevent spam, surely you could implement a mathmatical question for the user to answer, or have them confirm an email address OR EVEN use those awful captcha's!

Regards.
Mar 27 '08 #8
Uhh, I have one suggestion.

Why don't you just remove the sign-up link? Then put it back when you need it. To me that seems to be the easiest way to take care of it if you don't want anyone new signing up.
Mar 27 '08 #9
ronverdonk
4,258 Expert 4TB
Uhh, I have one suggestion.

Why don't you just remove the sign-up link? Then put it back when you need it. To me that seems to be the easiest way to take care of it if you don't want anyone new signing up.
That has already been suggested
Cant you just remove the code that inserts new users into the database?

I don't understand how it would affect the DB - all you need to do is remove what the end-user would use to sign up, and that is the PHP code used for the sign up.
Ronald
Mar 27 '08 #10
arggg
91
There are plugins for phpbb that require an image code on registration. This will prevent spambots from creating accounts with spam site links in them. Or you can add names of sites to the bad words list which will block them out.
Mar 27 '08 #11
nomad
664 Expert 512MB
There are plugins for phpbb that require an image code on registration. This will prevent spambots from creating accounts with spam site links in them. Or you can add names of sites to the bad words list which will block them out.
OK I going to use this ideal.

here is the code that I found on this page line 18 contains the path to the Registration. (should have usercp_register )
How do I omit that section. Can I use Comments (//) to omit it.

[PHP]
// Start of program proper
//
if ( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
$mode = ( isset($HTTP_GET_VARS['mode']) ) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
$mode = htmlspecialchars($mode);
if ( $mode == 'viewprofile' )
{
include($phpbb_root_path . 'includes/usercp_viewprofile.'.$phpEx);
exit;
}
else if ( $mode == 'editprofile' || $mode == 'register' )
{
if ( !$userdata['session_logged_in'] && $mode == 'editprofile' )
{
redirect(append_sid("login.$phpEx?redirect=profile .$phpEx&mode=editprofile", true));
}
include($phpbb_root_path . 'includes/usercp_register.'.$phpEx);
exit;
}
else if ( $mode == 'confirm' )
{
// Visual Confirmation
if ( $userdata['session_logged_in'] )
{
exit;
}
include($phpbb_root_path . 'includes/usercp_confirm.'.$phpEx);
exit;
}
else if ( $mode == 'sendpassword' )
{
include($phpbb_root_path . 'includes/usercp_sendpasswd.'.$phpEx);
exit;
}
else if ( $mode == 'activate' )
{
include($phpbb_root_path . 'includes/usercp_activate.'.$phpEx);
exit;
}
else if ( $mode == 'email' )
{
include($phpbb_root_path . 'includes/usercp_email.'.$phpEx);
exit;
}
}
redirect(append_sid("index.$phpEx", true));
?>
[/PHP]

thanks, sorry for being a pain in the butt, but I don't want to mess up the team forum site and get picked on...
nomad
PS I think there is another page the use the usercp_register
Mar 28 '08 #12
TheServant
1,168 Expert 1GB
Yes, you can, or /* and */ if you want to do multiple lines. The problem is, something will require that included file, so if ity can't find it, it will chuck out an error. Find out what calls that file, or variables in that file and see if you can track it so you don't get errors. Alternatively, just comment it out, see what happens, and deal with errors as you get them.
Mar 30 '08 #13
arggg
91
Yes, you can, or /* and */ if you want to do multiple lines. The problem is, something will require that included file, so if ity can't find it, it will chuck out an error. Find out what calls that file, or variables in that file and see if you can track it so you don't get errors. Alternatively, just comment it out, see what happens, and deal with errors as you get them.
I would comment out the actual
Expand|Select|Wrap|Line Numbers
  1. include('path/to/include');
in the files that are calling the registration page tha way any files such as the profile edit or anything that does call it like Servant said will not get an error.
Apr 1 '08 #14
nomad
664 Expert 512MB
I would comment out the actual
Expand|Select|Wrap|Line Numbers
  1. include('path/to/include');
in the files that are calling the registration page tha way any files such as the profile edit or anything that does call it like Servant said will not get an error.
thanks everyone for help

nomad
Apr 2 '08 #15
Markus
6,050 Expert 4TB
No probs!

Good luck dude!
Apr 2 '08 #16
TheServant
1,168 Expert 1GB
thanks everyone for help

nomad
How did you do it? If you don't mind me asking ;)
Apr 2 '08 #17

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Paul Keegstra | last post by:
Hi, I am currently working on an asp.net 2.0 web site that is a replacement of a classic asp web site. The current web site uses a Commerce Server 2002 database for storing user information. ...
4
by: Pony Tsui | last post by:
I was install the starter kits CLUB, and created a CLUB WEB SITE, this application use the MemberInfo table in club.mdf to store the membership'data, but i can not find out where to define or...
2
by: Balaji | last post by:
Hi All, Can I use more than one membership provider for a given website? I understand only one of them could be default one. If yes, then how to programmatically access the other membership...
3
by: ryan.mclean | last post by:
Hello everyone, I am wondering, can the membership provider be changed at runtime? Perhaps the connectionStringName? I would like to use a different database based on the server the site is...
4
by: =?Utf-8?B?Q2hyaXMgQ2Fw?= | last post by:
I have been having some trouble with implementing a custom Membership Provider. We have a custom data store and business logic that pulls user information. I need some level of functionality...
4
by: =?Utf-8?B?U2FsYW1FbGlhcw==?= | last post by:
Hi, I am trying to play with the Survey manager application provided gracefully by Microsoft at "http://msdn.microsoft.com/vstudio/express/sql/samples/" VB team(so many thanks), compiled the win...
3
by: Glenn | last post by:
My current classic-ASP site has users, projects, roles and the 2.0 membership looks like a perfect fit, but I'm having trouble finding examples of how to have users that belong to different...
1
by: =?Utf-8?B?ZVByaW50?= | last post by:
Asp.Net v2.0 I have created a web application and I am using it from a single website and database. The web application has different ‘portals’ – each independent and I am using the...
1
by: =?Utf-8?B?ZVByaW50?= | last post by:
Asp.Net v2.0 I have created a web application and I am using it from a single website and database. The web application has different ‘portals’ – each independent and I am using the...
8
by: Nick | last post by:
Hi there, Membership.GetNumberOfUsersOnline() works great the first time, then jumps up to the number of users registered in the system. I have tried enumerating through each user individually...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.