Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration
You are here: Home

coabirder

  • Profile
  • Topics Started
  • Replies Created
  • Engagements
  • Favorites

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • November 20, 2022 at 7:10 pm in reply to: WP eStore and WP Express Checkout #84746
    coabirder
    Spectator

    Thank you, your reassurance is very helpful.

    July 19, 2022 at 10:24 am in reply to: Convert calendar year membership to 1yr durational (from whenever they join) #84491
    coabirder
    Spectator

    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.

    July 19, 2022 at 9:47 am in reply to: Convert calendar year membership to 1yr durational (from whenever they join) #84489
    coabirder
    Spectator

    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.

    November 5, 2021 at 12:09 pm in reply to: MySQL table size 4.7MiB – emember_country_lookup #83887
    coabirder
    Spectator

    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

    November 4, 2021 at 3:22 pm in reply to: MySQL table size 4.7MiB – emember_country_lookup #83881
    coabirder
    Spectator

    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
Viewing 5 posts - 1 through 5 (of 5 total)

Forum Related

  • Forum Home
  • Forum Search
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • WP PDF Stamper Documentation
  • WP Photo Seller Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial
  • WP Photo Seller Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2023 | Tips and Tricks HQ