[coabirder]

Thank you, your reassurance is very helpful.

[coabirder]

First, I won’t pretend to have all the answers and my method might not be the only (or best) solution. T&T has really great support and if I were you I’d look to them for the best solutions after you clearly explain what you’d like to do.

Also, you can set the expiration date for each membership level to whatever you’d like (June 30, Sept 1, … whatever) and you also set the year. It’s very much in your control. That gives you maximum flexibility especially if you want to offer multi-year/month memberships.

[coabirder]

Hi sehowtwo,

Well before the end of the year we define new membership levels that expire on Dec 31, 20xx (where xx is the next year). On or before Dec 31 of the current year, switch your references on your payment page to point to the next year’s membership levels (they have new IDs). We have done that months in advance (giving a period of free membership in the current year) but when you make the changes is your call.

Also, historical data is important to us so we don’t delete the past year’s membership levels for fear of removing it from the database (but there may be a way around that).

I hope that helps. If not let me know.

[coabirder]

Thank you for the detailed explanation. So I did try deactivating the eMember Stats plugin; then deleting just the emember_country_lookup table; then activating the plugin again. The emember_country_lookup table came back 20% larger just to spite me 🙂

I’ll be leaving it alone now. I’ve decided that analytics is more important than a smaller WP database so I’m keeping the plugin installed after all.

Thanks very much for your help.

Steve

[coabirder]

Thank you for your reply. I’m thinking this data from the emember_country_lookup table might not be the “Stats” table you’re thinking of. Below is a sample from the beginning of the table (please excuse the formating) and another from the end. Note that there are >91K entries to this 4.7MiB file!! I have yet to take any action as I’d like to understand exactly what is generating this table before removing it as I’m sure you’d understand.

There is another table called emember_stats_tbl where I do see data related to members.

[Beginning of country_code_lookup table]
Full texts
id
ip_from
ip_to
country_code2
country_code3
country_name

Edit Edit
Copy Copy
Delete Delete
1
33996344
33996351
GB
GBR
UNITED KINGDOM

Edit Edit
Copy Copy
Delete Delete
2
50331648
69956103
US
USA
UNITED STATES

Edit Edit
Copy Copy
Delete Delete
3
69956104
69956111
BM
BMU
BERMUDA

Edit Edit
Copy Copy
Delete Delete
4
69956112
72349055
US
USA
UNITED STATES

————————

[from near the end of the table]

Full texts
id
ip_from
ip_to
country_code2
country_code3
country_name

Edit Edit
Copy Copy
Delete Delete
91701
3716537472
3716537535
AU
AUS
AUSTRALIA

Edit Edit
Copy Copy
Delete Delete
91702
3716537536
3716537567
HK
HKG
HONG KONG

Edit Edit
Copy Copy
Delete Delete
91703
3716537568
3716537599
JP
JPN
JAPAN

Edit Edit
Copy Copy
Delete Delete
91704
3716537600
3716538367
AU
AUS
AUSTRALIA

————————

Also, note that our site is pretty local to CT USA and it certainly puzzles me to see HUGE numbers of entries from other countries hence my question about this table and eMember.

Your support form isn’t very kind with cut/paste or attachments or I’d share more of what I’m seeing in phpMyAdmin.

Thanks for your continued assistance.

Steve

[Author]

Posts