EzPortal - Portal Software for Forums

EzPortal - Made to Fit Your SMF Forum - Glad You Found Us!
+- +-

UserBox

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Recent Posts

Minor Update for SMF 2.1.x by EzPortal
October 18, 2020, 09:33:09 am

Re: EzPortal unable to be seen by user with primary custom usergroup by EzPortal
October 12, 2020, 07:55:08 am

EzPortal unable to be seen by user with primary custom usergroup by radi27
October 11, 2020, 04:46:32 pm

Show Likes mod by NickT
July 10, 2020, 12:09:44 pm

Re: ezPortal inbuilt module downloaders not working. by EzPortal
March 26, 2020, 08:19:48 am

Re: ezPortal inbuilt module downloaders not working. by Valdivia
March 26, 2020, 08:16:33 am

Re: ezPortal inbuilt module downloaders not working. by EzPortal
February 12, 2020, 10:01:42 pm

Re: ezPortal inbuilt module downloaders not working. by usalabs
February 12, 2020, 05:59:54 pm

+- HTML Menu


Sample HTML Block Usage - You May Custom Code it, as needed!

Author Topic: Linking username to separate table  (Read 9852 times)

0 Members and 1 Guest are viewing this topic.

Offline KarmicStigmata

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
Linking username to separate table
« on: May 29, 2012, 02:44:38 pm »
I run a gaming site and I am trying to streamline data without having to input additional information.  So my question is:  How would I take data from the SMF profile and link it to another table?

Here is a better breakdown:
The EZBlock calls for:
Profile Field:  Call Sign (unique to my site)  at mySQL database smf_

The Call Sign field would then link to a separate database games_ where it would associate to the Call Sign listed there... So i.e.

Call Sign:  EZPortal at SMF_ would link to Call Sign: EZPortal at games_

I don't want them to have to log in, I want it to be part of the session.  That way when they are going through that portion of the site, they can see their profile information for that game.  If you can provide me with the linking code to continue the session in the block I'd appreciate it.

Whom ever decides to help me will be credited on my site.

Offline KarmicStigmata

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
Re: Linking username to separate table
« Reply #1 on: June 27, 2012, 10:27:23 am »
Well that took a while but I figured it out on my own! 

global $user_info, $memberContext;

Code: [Select]
loadMemberData($user_info['id']);
loadMemberContext($user_info['id'], true);
$custom_profiled_filed = $memberContext[$user_info['id']];

// Define fields
$Callsign   = $custom_profiled_filed['options'];

^^ That was all I needed, and then I was able to link it to the database, and fyi it does work with EZBlocks :)  Even though I just sat down for a day and tried to figure it out myself >_<

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
5612 Views
Last post January 19, 2011, 01:48:42 am
by wandawill
1 Replies
5846 Views
Last post January 14, 2011, 09:01:55 pm
by EzPortal
4 Replies
6416 Views
Last post July 26, 2012, 09:29:10 am
by EzPortal
2 Replies
4468 Views
Last post April 14, 2016, 07:37:40 am
by DenDen66
2 Replies
4015 Views
Last post October 03, 2015, 02:32:42 pm
by Jim88

+-SMF Gallery

Quick Menu



Members Online

19 Guests, 0 Users
Powered by EzPortal