Checking Pending Activations

This forum is now closed as part of retiring phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

This forum is now closed due to phpBB2.0 being retired.
Post Reply
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Checking Pending Activations

Post by dvdd127 »

I have admin approvals enabled on one of my sites.. and would like to know if there is a MOD that will allow me to view all the pending approvals at the same time in the ACP.

Thanks in advance
/DD
Josh18657
Registered User
Posts: 425
Joined: Wed Nov 30, 2005 9:55 pm
Contact:

Re: Checking Pending Activations

Post by Josh18657 »

here ya go

http://www.jtsenterprises.biz/scripts/a ... proval.zip

hope that's what you were trying to find.

I could also add a button so the user could be activated from that page

Josh
Last edited by Josh18657 on Tue Jul 24, 2007 11:48 am, edited 1 time in total.
I can help you edit your forums at a reasonable price, send a PM if you can't get something figured out here.
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Re: Checking Pending Activations

Post by dvdd127 »

I will look at it tomorrow..
thank you.
/DD
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Re: Checking Pending Activations

Post by dvdd127 »

Josh18657 wrote:here ya go

http://www.jtsenterprises.biz/scripts/a ... proval.zip

hope that's what you were trying to find.

I could also add a button so the user could be activated from that page

Josh
If you could add the button.. it would be good.
Thanks in advance.
/DD
Josh18657
Registered User
Posts: 425
Joined: Wed Nov 30, 2005 9:55 pm
Contact:

Re: Checking Pending Activations

Post by Josh18657 »

download the new version at the same link above
I can help you edit your forums at a reasonable price, send a PM if you can't get something figured out here.
User avatar
RMcGirr83
Former Team Member
Posts: 21693
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Checking Pending Activations

Post by RMcGirr83 »

Ermmm,

Code: Select all

<?php

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
   $filename = basename(__FILE__);
   $module['Users']['Awaiting Approval'] = $filename;

   return;
}

//
// Load default header
//
$phpbb_root_path = './../';
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
if (isset ($_GET['user']))
{
	$user = $_GET['user'];
	$sql = "UPDATE phpbb_users SET user_active=1 WHERE user_id=$user";
	$result = $db->sql_query($sql);
	echo 'User approved<br /><br />';
}

echo '
<table width="99%" cellpadding="4" cellspacing="1" border="0" align="center" class="forumline">
<tr><th class="thHead" colspan="4">AWAITING APPROVAL</th></tr>
<tr><td class="catLeft"><span class="cattitle">User ID</span></td><td class="catLeft"><span class="cattitle">Username</span></td><td class="catLeft"><span class="cattitle">E-mail address</span></td><td class="catLeft"><span class="cattitle">Action</span></td></tr>
';

$sql = "SELECT * FROM phpbb_users WHERE user_active=0";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) )
{
	if ($row['user_id'] != '-1')
	{
		echo ' <tr><td class="row1">'.$row['user_id'].'</td><td class="row1">'.$row['username'].'</td><td class="row1">'.$row['user_email'].'</td><td class="row1"><a href="'.append_sid($_SERVER['PHP_SELF'].'?user='.$row['user_id']).'">Approve</tr>';
	}
}

echo '</table>';
where is the

Code: Select all

?>
to terminate the script?
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
Josh18657
Registered User
Posts: 425
Joined: Wed Nov 30, 2005 9:55 pm
Contact:

Re: Checking Pending Activations

Post by Josh18657 »

RMcGirr83 wrote:Ermmm,

Code: Select all

<?php

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
   $filename = basename(__FILE__);
   $module['Users']['Awaiting Approval'] = $filename;

   return;
}

//
// Load default header
//
$phpbb_root_path = './../';
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
if (isset ($_GET['user']))
{
	$user = $_GET['user'];
	$sql = "UPDATE phpbb_users SET user_active=1 WHERE user_id=$user";
	$result = $db->sql_query($sql);
	echo 'User approved<br /><br />';
}

echo '
<table width="99%" cellpadding="4" cellspacing="1" border="0" align="center" class="forumline">
<tr><th class="thHead" colspan="4">AWAITING APPROVAL</th></tr>
<tr><td class="catLeft"><span class="cattitle">User ID</span></td><td class="catLeft"><span class="cattitle">Username</span></td><td class="catLeft"><span class="cattitle">E-mail address</span></td><td class="catLeft"><span class="cattitle">Action</span></td></tr>
';

$sql = "SELECT * FROM phpbb_users WHERE user_active=0";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) )
{
	if ($row['user_id'] != '-1')
	{
		echo ' <tr><td class="row1">'.$row['user_id'].'</td><td class="row1">'.$row['username'].'</td><td class="row1">'.$row['user_email'].'</td><td class="row1"><a href="'.append_sid($_SERVER['PHP_SELF'].'?user='.$row['user_id']).'">Approve</tr>';
	}
}

echo '</table>';
where is the

Code: Select all

?>
to terminate the script?
fixed
I can help you edit your forums at a reasonable price, send a PM if you can't get something figured out here.
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Re: Checking Pending Activations

Post by dvdd127 »

thank you... this is just what i was looking for.
/DD
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Re: Checking Pending Activations

Post by dvdd127 »

Is it possible that you can add another link that will delete the account when it is clicked??

Thanks in advance
/DD
Josh18657
Registered User
Posts: 425
Joined: Wed Nov 30, 2005 9:55 pm
Contact:

Re: Checking Pending Activations

Post by Josh18657 »

dvdd127 wrote:Is it possible that you can add another link that will delete the account when it is clicked??

Thanks in advance
should be pretty easy, I'll work on it a little later
I can help you edit your forums at a reasonable price, send a PM if you can't get something figured out here.
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Re: Checking Pending Activations

Post by dvdd127 »

Josh18657 wrote:should be pretty easy, I'll work on it a little later
thank you. just let me know when you it is done.
/DD
Josh18657
Registered User
Posts: 425
Joined: Wed Nov 30, 2005 9:55 pm
Contact:

Re: Checking Pending Activations

Post by Josh18657 »

dvdd127 wrote:
Josh18657 wrote:should be pretty easy, I'll work on it a little later
thank you. just let me know when you it is done.
new version uploaded

download from the same location and read install.txt
I can help you edit your forums at a reasonable price, send a PM if you can't get something figured out here.
dvdd127
Registered User
Posts: 402
Joined: Fri Jan 13, 2006 12:35 am
Location: Chicago, IL

Re: Checking Pending Activations

Post by dvdd127 »

excellent work. thank you.
/DD
rajkumarphp
Registered User
Posts: 9
Joined: Wed Feb 20, 2008 3:42 pm

Re: Checking Pending Activations

Post by rajkumarphp »

hi,

this enchancement is gr8, but how to send the mail to inform about the approval

Regards
Raju
Post Reply

Return to “[2.0.x] MOD Requests”