Thread: Control Panel

another prob...

Since a few days I noticed when members membership expires, the message appears 'you are a standard member...'. BUT the "Gold Membership" doesn't disappear...

see attachments.

I replaced the original member.php , inc/profile.inc.php, and inc/members.inc.php with no luck.

raeyo

raeyo...

If you go to the profiles table and look at that memebr's mem_level colum..does it have the gold number or the standart number?

I think i have got it..not sure, please check me out:

if you look at what i sugguested in Database access error - Paypal post checkout payment you will see that i have updated the profiles table to use 0 default value in the mem_level_days and also i have put 0 in all the existing members (so they won't get 1 day for free).

This is from periodic/cmd.php:
---------------------------------------------------------------------
// - Membership check -
echo "\n- Membership check -\n";

$exp_res = db_res( "SELECT ID, mem_level FROM `Profiles` WHERE mem_level_days <= 0", 0 );
$rows = mysql_num_rows( $exp_res );
echo "Expired membership records: $rows\n";

if ( $rows )
{
while( $row = mysql_fetch_array( $exp_res ) )
{
db_res( "UPDATE `Profiles` SET `mem_level` = 1, `mem_level_days` = 1 WHERE ID = {$row[ID]}", 0 );
mem_expiration_letter( $row['ID'], $row['mem_level'] );
}

echo "Change membership status to 'standart': $rows members today\n";
-----------------------------------------------------------------------------
You can see that it is after all the members that have 0 in the mem_level_days or less then that. If it is, it will update the mem_level to 1 which means standart.

What i don't get(or think that it is wrong) it that in the update, that member will get 1 day in the mem_level_days..i think it should be 0.

What do you say guys?

I have tested it and it is not working.
My user had 1 day left and when this day was over, it was still gold member.

Damn...

So nobody has an v4 patch2 'aedating'-site running with payed members using Paypal??

Sad but true...

I just fixed a bunch of stuff with payment levels already in CLEAN (I'm sure there is more)...

But CLEAN will have PayPal working... I'm going to start this next.

Rob

Looking at this PayPal code - it makes me wonder... did they test any of this stuff at all before releasing v4 patch 2?

I know we have asked this question to each other here again and again... but this is just so nasty.

Code:

INSERT INTO `TransactionsMembership` (ID, Sum, State ) VALUES ( 1126552806340, 1.00, '0' );
Error
Database access error

Does anyone know, is Victor over at aeWebWorks a programmer? Or just a businessman?

Smoge

u r abselutly right.
have u seen my solution to this problem?
It works for me..

btw...i have sent u a privat message about clean.

Hi,

Yes - I have seen your solution - and it has been helpful.

But I am not just copying and pasting code (in most cases) with CLEAN.... instead - I want to have an understanding of how things are working myself, so I can support it better later.

Smoge

Originally Posted by Smoge

Does anyone know, is Victor over at aeWebWorks a programmer? Or just a businessman?

Smoge

Hi,

Neither.... I think in all likeliness a member of Russian Mafia or KGB trained in the tactics of "bait n switch"

When it walks like a duck, quacks like a duct, it must be a DUCK..

chris c