Tips and Tricks HQ Forum

Support Forum for Tips and Tricks HQ Products

Register or log in - lost password?

Search the Forum

Tips and Tricks HQ Forum » WP eMember » WP eMember Tweaks

Adding extra info from SQL to display member details

(6 posts) (2 voices)
  • Started 1 year ago by e49
  • Latest reply from e49
  • Related Topics:
    1. is it possible to add products directly to the mysql database
    2. Membership Number / Reference - Storage and Display
    3. Any conflict with Role Scoper and eMember?
    4. emember short codes not working
    5. eMember kills WPAudio

Tags:

  • database
  • eMember
  • mysql
  • phpMyAdmin
  1. e49
    Member

    Hi all, MAJOR WP & PHP NEWBIE HERE so please be gentle... LOL...
    I like this plugin and am trying to display a lil bit more info for my customers to see on my web site.
    The plan is with the already exsisting set up of the customers login page, after they login as follows...

    (ie
    You are logged in as: username
    Your membership level is: level
    Your Account Status: active
    Your Account Expires: April 25, 2011
    >Logout
    >My Secure RSS
    >Edit Profile
    )

    Then under this I would like to add more fields to display, I already have the SQL fields set up in the database and I enter them manually there (or if so can I set that in wordpress also)... I just need to set up the string on the particular users page so it would show...

    You are logged in as: username
    Your membership level is: level
    Your Account Status: active
    Your Account Expires: April 25, 2011
    Your extra info: HERE
    Your extra info: HERE
    Your extra info: HERE
    Your extra info: HERE etc...
    >Logout
    >My Secure RSS
    >Edit Profile
    )

    The customers does not need to edit this info, it would be left strictly for me to change either in SQL or if it can be edited on the wordpress add/edit members tab.

    Hope I hear back from anyone who can help... Thanks :D

    Posted 1 year ago #
  2. amin007
    Key Master

    Open the "wp_eMember1.php" file and search for the following function:

    function eMember_login_widget()

    The code in that function is what displays those stuff in the login widget. So, retrieve your data from the SQL database for that member and display it there.

    Posted 1 year ago #
  3. e49
    Member

    Does the widget function display the same as what would if I place it on main content of the page... If not where would I need to find it... Cheers... :D

    Posted 1 year ago #
  4. amin007
    Key Master

    It's the same function that displays it on both places.

    Posted 1 year ago #
  5. e49
    Member

    Great I have found it and started testing... Now I will need to replace some other areas to complete the modified function.

    It is now currently showing...

    $output .= '
    ' . EMEMBER_LOGGED_IN_LEVEL;
    $output .= '<label class="eMember_highlight">'.$username.'</label>';

    How do I edit the EMEMBER_LOGGED_IN_LEVEL to display something else for e.g. Membership Number.

    Also how do I call the SQL over from the table to replace the .$username. cos on my SQL it shows that it is user_name

    Is there another file I need to find to edit this function...? Cheers... :D

    Posted 1 year ago #
  6. e49
    Member

    Hey all is good, I've figured it out, kudos to me and yourself for all your help... Cheers...

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.

Tips and Tricks HQ Forum is proudly powered by bbPress

Tips and Tricks HQ  | WP Shopping Cart  | WP Affiliate Software  | WordPress Membership Plugin