Alex,
thanks for the response. one thing i know i have come across is that sys_acl_levels_members does not seem to update the database.
considering a promotional sign up if you have that membership level active. when the lets call it 7 day promotional goes away, where is the setting for setting the default membership? we can only presume that its falling onto standard and there is no way for us to control that?
ok so with that, so somewhere, it is written to check the DateExpires on sys_acl_levels_members, and if date is expired, then membershiplevel is set to default on sys_acl_levels, but the database itself does not update. thus creating a problem in one way we have discovered, if you are like me and others where you query directly on mysql or on phpmyadmin, and you query to show all Standard Members which we know as to carry IDLevel =2 according to sys_acl_levels
If user buys new membership level then it is queued to the end of current membership, after current membership is elapsed the new membership is in effect. The exception is 'Standard' membership, then newly bought membership starts immediately.
This scenario makes sure that user don't loose previous membership which most probably was bough.
If you want that newly bought membership starts immediately and previous memberships was deleted from user's profile, try to change the following line:
$bResult &= buyMembership($iClientId, $iItemId, $sOrderId);
to:
$bResult &= buyMembership($iClientId, $iItemId, $sOrderId, true);
in modules/boonex/membership/classes/BxMbpModule.php file
SELECT *
FROM `sys_acl_levels_members`
WHERE `IDLevel` = '2'
LIMIT 0 , 30
would return 0
so this kinda clears up why there is no stats on the admin panel for standard users or promotional users. if they start at promotional and ID = 3, then the controlling factor is no longer that LevelID, but the ExpiryDate
this holds true on a few things, the promotional aspect is giving the greatest problem at the moment, because there are hundreds a day signing up, and they get a promotional membership, but the promotion ends, and they are not prompted to upgrade or anything, just falls over into standard membership access.
so the other problem with this is that if there is a 30 day call it gold membership and a 90 day gold membership, but the member gets near the end of his longest membership and wishes to downgrade, there is no means of downgrading when considering, again though not sure if this process works, but say membership gold 90 lets his gold membership level access expire, the DateExpire now knows from somewhere that is a mystery, to set the membership level to IDLevel = ? to standard,
so the database table sys_acl_levels_members never updates for promotional ---> to standard when promotion expires. and when paid membership expires, the database does not update on this same table, though they are most times, set to default --> standard membership level.
When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support