Thread: Show membership level on admin profile summary page

To show membership level on admin profile summary page, make the following changes:

Insert this into your database

Code:

INSERT INTO `GlParams` ( `Name` , `VALUE` , `kateg` , `desc` , `Type` , `check` , `err_text` )
VALUES (
'show_membership', '', '888', 'Show membership level info on admin profile summary screen', 'checkbox', '', ''
);

If you get an error when adding this, you don't have the "clean" GlParamsKteg.
Are you running at least CLEAN v0.04?
If not, you can add the GlParamsKteg in phpMyadmin.


In /admin/profiles.php

Find this, around line #19:

Code:

$ADMIN = $logged[admin];

Add this under:

Code:

$show_membership =  getParam('show_membership');

Find around line #171:

Code:

$result = db_res( "SELECT ID, Picture, Sex, ProfileType, LastLoggedIn, NickName, RealName, MerchantPrice, Status FROM Profiles $aff_part_f WHERE 1 $email_part $aff_part_w $prof_part $sex_part $extra_addon_part ORDER BY $sortor $sorttype LIMIT $real_first_p, $p_per_page" );

Change to:

Code:

$result = db_res( "SELECT ID, Picture, Sex, ProfileType, LastLoggedIn, NickName, RealName, MerchantPrice, Status, mem_level, mem_level_days FROM Profiles $aff_part_f WHERE 1 $email_part $aff_part_w $prof_part $sex_part $extra_addon_part ORDER BY $sortor $sorttype LIMIT $real_first_p, $p_per_page" );

Find around line #253:

Code:

<td align=right>&nbsp;<?
		echo sprintf( "%.2f", total_price( $p_arr[MerchantPrice] ) );
?>&nbsp;</td>

Change to:

Code:

<td align=right>&nbsp;<?
if ( $show_membership == "on" )
{
$memlevelinfo = db_arr( "SELECT * from mem_levels WHERE ID = $p_arr[mem_level]" );
$level_name = $memlevelinfo[name];
echo $level_name;
}
else
{
echo sprintf( "%.2f", total_price( $p_arr[MerchantPrice] ) );
}
?>&nbsp;</td>

Find Around line #228:

Code:

<td align=center>Price,&nbsp;<?=$doll;?></td>

Replace with:

Code:

<?
if ( $show_membership == "on" )
{
echo "<td align=center>Level</td>";
}
else
{
echo "<td align=center>Price,&nbsp;<?=$doll;?></td>";
}
?>

More needs to be done - to perhaps add the number of original days,
and days remaining, in the membership display here.

This code is not optimized - it was done quickly to fix the problem... I'm sure it can be cleaned up.

Smoge

Hi, does anybody know if it works with dolphin 5.2 ???
Looks like a great feature !

Hi,

I tied this but I get following DB Error!?

Error in /admin/profiles.php: Unknown column 'mem_level' in 'field list'
Query: 'SELECT ID, Picture, Sex, ProfileType, LastLoggedIn, NickName, RealName, MerchantPrice, Status, mem_level, mem_level_days FROM Profiles WHERE 1 ORDER BY ID ASC LIMIT 0, 30'



kruemelg

RU looking for something like this?
see attached.

TGIF......

Todd


Taking no action is an action.

Thats it ! And you do have some more information in this feature !
Pleas tell us more.

Here it is.

This is the same code that is used in your members..member.php that tells them membership status.
I just took this code from there and put it in my profiles.php as a temp fix
to display this information and dediced since no one but me sees this and it works why redue it.....LOL....

Add this code to your admin/profiles.php

<td width="300"align = left><? echo GetMembershipStatus($p_arr['ID']); ?></td>

You will have to edit your profiles.php and of course create a title table for this new field.

I would give you the exact place to put this code but our admin panel is highly modded and it would not work for your site.
I have included my profiles.php just in case you would like to upload it to your test site and see what it looks like.

I posted this mod, to use the term loosely, here somewhere but cannot find it right now...

Peace.

Todd