User Account Site – Is this possible on WP?

  • WordPressIsAwesome

    (@wordpressisawesome)


    10 years, 11 months ago

    Hi,

    I’m looking to make a site with the following features (which I’m finding very challenging on WordPress):

    – It is a site that tracks “reward points” for users. The reward points are all calculated and updated by me through the backend… I’m thinking about storing them in a separate database table (post types didn’t seem to make sense as there will be so many records, down to the per day/user level).
    – Users should be able to sign up for their own accounts, and input/maintain a few custom attributes like PayPal information, etc.
    – Users should then be able to log in and track all “reward points” that are tied to their user.

    Is there a best approach for this? BuddyPress and User Access Manager don’t really seem to fit this Use Case. Is the right approach to create custom MySQL tables for “Reward Points” and tie them to WordPress Users via the Username? Seems a little clunky and unstable…

    Or alternatively do you think something more robust like Drupal or MVC framework is better for something like this?

    Thanks for your time. New to WordPress so really appreciate your help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter WordPressIsAwesome

    (@wordpressisawesome)

    10 years, 11 months ago

    To clarify – I’m considering an approach like this: http://www.makeuseof.com/tag/working-custom-database-tables-wordpress/.

    Is there a better way? And would it really be worth it to twist WordPress to this degree, or just switch to another platform for this particular project.

    Thanks again!

    Pioneer Web Design

    (@swansonphotos)

    10 years, 11 months ago

    Or alternatively do you think something more robust like Drupal or MVC framework is better for something like this?

    No.

    Just hack one of the many post ratings plugins with an is_admin conditional…that is only you can rate…

    Thread Starter WordPressIsAwesome

    (@wordpressisawesome)

    10 years, 11 months ago

    Do you mind elaborating a bit? I’m a little confused, unless I’m misunderstanding completely. Are you talking about repurposing ratings? But I’m not really after post attributes (I don’t think).

    I would like to store “Reward Points” in a completely separate table (or custom post type), and tag them to specific Users. So that when a specific User logs in, he can only see Reward Points that he has earned (and no one else’s).

    My open questions were:
    – Should Reward Points be a separate table that I build queries for OR should they be custom post type? I was leaning towards custom table due to volume but am unsure if this is the correct decision.
    – How can each Reward Point record in the Database be tied to a User? If I use a separate table, should I just make an additional column that stores the WordPress User (could be clunky and searching could affect performance)? If custom post type, custom field that holds WordPress User (seems equally clunky)? Or do I throw away “WordPress Users” and create my own User table?

    My background is custom building php sites from scratch, which is why I’m struggling with direction within WP a bit.

    Thanks much for your help!!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘User Account Site – Is this possible on WP?’ is closed to new replies.