Page 1 of 1

Checking Pending Activations

Posted: Mon Jul 23, 2007 1:02 am
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

Re: Checking Pending Activations

Posted: Mon Jul 23, 2007 3:06 am
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

Re: Checking Pending Activations

Posted: Mon Jul 23, 2007 3:11 am
by dvdd127
I will look at it tomorrow..
thank you.

Re: Checking Pending Activations

Posted: Tue Jul 24, 2007 9:26 am
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.

Re: Checking Pending Activations

Posted: Tue Jul 24, 2007 11:49 am
by Josh18657
download the new version at the same link above

Re: Checking Pending Activations

Posted: Tue Jul 24, 2007 5:10 pm
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?

Re: Checking Pending Activations

Posted: Tue Jul 24, 2007 7:46 pm
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

Re: Checking Pending Activations

Posted: Wed Jul 25, 2007 6:48 pm
by dvdd127
thank you... this is just what i was looking for.

Re: Checking Pending Activations

Posted: Sun Jul 29, 2007 4:34 pm
by dvdd127
Is it possible that you can add another link that will delete the account when it is clicked??

Thanks in advance

Re: Checking Pending Activations

Posted: Sun Jul 29, 2007 6:19 pm
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

Re: Checking Pending Activations

Posted: Sun Jul 29, 2007 6:21 pm
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.

Re: Checking Pending Activations

Posted: Sun Jul 29, 2007 7:33 pm
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

Re: Checking Pending Activations

Posted: Sun Jul 29, 2007 7:51 pm
by dvdd127
excellent work. thank you.

Re: Checking Pending Activations

Posted: Mon Apr 28, 2008 6:45 am
by rajkumarphp
hi,

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

Regards
Raju