jozwikjp
Expert
Friendly Neighbour
Member Likes (0)
hello,
The installation instruction to not mention if you need to create global tables for this plugin.
I don't see a blog id reference there so I am assuming it need global tables entries.
Is that correct?
Thanks
Joe
Looking at
CREATE TABLE 'wp_1_membership_levels' (
'id' bigint(20) NOT NULL auto_increment,
'level_title' varchar(250) default NULL,
'level_slug' varchar(250) default NULL,
'level_active' int(11) default '0',
'level_count' bigint(20) default '0',
PRIMARY KEY ('id')
);
CREATE TABLE 'wp_1_membership_relationships' (
'rel_id' bigint(20) NOT NULL auto_increment,
'user_id' bigint(20) default '0',
'sub_id' bigint(20) default '0',
'level_id' bigint(20) default '0',
'startdate' datetime default NULL,
PRIMARY KEY ('rel_id')
);
CREATE TABLE 'wp_1_membership_rules' (
'level_id' bigint(20) NOT NULL default '0',
'rule_ive' varchar(20) NOT NULL default '',
'rule_area' varchar(20) NOT NULL default '',
'rule_value' text,
'rule_order' int(11) default '0',
PRIMARY KEY ('level_id','rule_ive','rule_area'),
KEY 'rule_area' ('rule_area'),
KEY 'rule_ive' ('rule_ive')
);
CREATE TABLE 'wp_1_subscriptions' (
'id' bigint(20) NOT NULL auto_increment,
'sub_name' varchar(200) default NULL,
'sub_active' int(11) default '0',
'sub_public' int(11) default '0',
'sub_count' bigint(20) default '0',
PRIMARY KEY ('id')
);
CREATE TABLE 'wp_1_membership_relationships' (
'rel_id' bigint(20) NOT NULL auto_increment,
'user_id' bigint(20) default '0',
'sub_id' bigint(20) default '0',
'level_id' bigint(20) default '0',
'startdate' datetime default NULL,
PRIMARY KEY ('rel_id'),
KEY 'user_id' ('user_id'),
KEY 'sub_id' ('sub_id'),
KEY 'level_id' ('level_id')
);

Responses (8)
Member (joined April 2009) Likes (0)
Hiya,
Do you want this plugin activated network wide or made available individually on your sub-sites?
Thanks.
Member (joined August 2010) Likes (0)
Individual on sub-sites.
Developer (joined June 2008) Likes (0)
It can use global or blog level tables depending on the configuration you want. You can change the setting in the includes/membershipconfig.php file by editing the line:
// Use a global table system - experimentaldefine( 'MEMBERSHIP_GLOBAL_TABLES', false);
Also, can you check you have the latest version of the plugin - as those table names don't look correct.
Member (joined August 2010) Likes (0)
Hi Barry,
I downloaded it yesterday.. That sql was just from a .sql file I found in a sub folder..
I will download it again.
Thank you.
Joe
Developer (joined June 2008) Likes (0)
@jozwikjp - ok, ignore that file - looks like it was missed in the update.
The table names will be in the format wp_1_m_membership_levels for blog level tables, or wp_m_membership_levels for global level tables.
Member (joined August 2010) Likes (0)
Hi Barry,
Hate to drudge up old thread.. But I have been playing with this plugin for awhile.
I have not been able to get it to work as a premium plugin for the supporter program.
Ideally I wants sites on our network to be able to run there own membership sites.
Is that possible with this plugin out of box?
I have read where you can have multiple users running the same membership site.
But I want completely seperate membership sites.
Like the market press plugin.
Any good thread that you can remember where someone set this up effectively?
Thanks Barry,
Member (joined August 2010) Likes (0)
Nevermind on this. :-)
MEMBERSHIP_MASTER_ADMIN issue.
it works as I was hoping :-)
Developer (joined June 2008) Likes (0)
@jozwikjp - not be much help at the moment, but i've rejigged this part of the plugin because it was a bit clunky - the update will detect who is activating it and set them as the membership admin.
Become a member