amijanina

use this:

$encrypted_pass = SwpmUtils::encrypt_password($plain_password);

Hi Tony,
we are passing sql to dbDelta which does some extra stuff to check if table exists. https://codex.www.ads-software.com/Creating_Tables_with_Plugins.

Thanks for suggestion on unique key.

in fact that will give you membership level id. but if you want membership level alias then do this:

$auth = BAuth::get_instance();
        $alias = '';
        if ($auth->is_logged_in()) {
            $alias = $auth->get('alias');
        }

you can try calling

BMemberUtils::get_logged_in_members_level();

Hi,
Thanks for reporting. We will release an update.

hi VitViz,
the way you are trying to do it, will complicate whole process.

instead open classes/class.bAccessControl.php and replace line 26 with this code:

if (!$protected->is_protected($id)){
   $this->lastError = BUtils:_("This content is protected");
   return false;
}

you can try using this: https://simple-membership-plugin.com/configure-login-redirection-members/

you never know which one is bigger. because its nasa, you cannot support your claim in public i think ?? and i don’t see NASA in the list of 10 world’s largest databases (https://pandidba.blogspot.com/2014/01/top-10-largest-databases-in-world.html) but the company i work for is there. Again that’s a system spanning multiple data centers across the globe. mind you, we are talking about wordpress. if your system is of such scale, you are not doing to install wordpress and be happy with that.

and when mentioned “index fragmentation”, you are just proving my 3rd point (in my first reply). that’s DBA responsibility

i “happily disregard”ed because its not an issue. people who reported issues, we fixed them. But we don’t like to spend too much time discussing no-issue.

So unless you have found some “real” issues in our software, we will not be replying to this thread.

Thanks.

it doesn’t matter whether you are software engineer for 35 years or 10000 years. its just how database works. i am working for one of the word’s largest e-tailers, have experience working with not thousand rather millions of user data where physically deleted record is a fact of life. so i am quite aware of the extent of performance impact. Yes we have listened to your concern and can happily disregard because it a non-issue.

Please NOTE that word press user ID and simple membership user ID — there ARE NOT same. this is how simple membership plugin works. yes .. we have intentionally maintained this separation.

thanks

freesoftwarewiz,
thanks for your feedback.
1) relational database systems doesn’t really depend on the pattern of data stored. they are smart enough process data efficiently no matter distributed or not distributed data is. they achieve this efficiency with the help of some other tools or techniques. on a bold margin, these are:
1. indexing:
indexing is the magic that helps db to find data quickly.

firstly, you need to look for which columns are being used more in “WHERE” clause. you need to define index on that column. most common indexing are B-Tree and HASH index (vendor like oracle, microsoft, SAP Sybase offer some other proprietary indexes. we are not concerned about this since wordpress works mostly with mysql and (rarely) postgres ). these can be clustered or non clustered based on the physical organization of data. if you are doing more exact matching query then use hash index. but if you are doing more range query then use B-TREE index. it doesn’t really care if there is so called “hole” or not. there are many many different database tuning tools out there. that can help find out potential column needing index.

2. complex query:
complex queries sometimes can cause slowness since they may require a lot of I/O operation. But we in simple membership don’t use complex queries.

3. Index fragmentation:
index fragmentation prevent from obtaining full benefit of indexing. you can use index defragmenter to get rid of that.

4. use of temporary tables:
temporary tables are sometimes slower if it uses swap space (thereby causing disk I/O)

there are many many db tuning techniques that can be applied but these are responsibility of a Database Admin.

NOTE about WordPress user ID:
simplemembership plugin doesn’t care about wordpress user ID. it just uses user name to sync with wp core database.

about PAID account issue:
thanks for reporting, we will investigate this.

thanks,

the reason this is not built into the main plugin is that, we wanted main plugin to be glue to various features. main plugin should contain only things that everyone need.

you should see “After Login Redirection Page” field in “Edit membership level” page once you install this plugin. it doesn’t need any other visual change to work.

please read this https://simple-membership-plugin.com/adding-membership-access-levels-site/

please read thishttps://simple-membership-plugin.com/adding-membership-access-levels-site/

i don’t this issue in my setup and at this point, i cannot say anything without taking a look into your site. if you are willing to have us take a look into the issue. please post in the forum here