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

Re: permissions to shoutbox by EzPortal
December 10, 2018, 11:22:34 pm

Re: permissions to shoutbox by zoltar
December 10, 2018, 02:48:47 pm

Re: permissions to shoutbox by EzPortal
December 09, 2018, 08:23:51 pm

Re: permissions to shoutbox by zoltar
December 09, 2018, 03:21:35 am

Re: permissions to shoutbox by EzPortal
December 08, 2018, 09:20:27 am

permissions to shoutbox by zoltar
December 08, 2018, 03:36:08 am

Re: Mobile Only Blocks by rcolaneri
November 20, 2018, 01:53:00 pm

Re: Mobile Only Blocks by EzPortal
November 20, 2018, 09:22:47 am

+- HTML Menu


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

Author Topic: Linking username to separate table  (Read 9028 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
5274 Views
Last post January 19, 2011, 01:48:42 am
by wandawill
1 Replies
5069 Views
Last post January 14, 2011, 09:01:55 pm
by EzPortal
4 Replies
5957 Views
Last post July 26, 2012, 09:29:10 am
by EzPortal
2 Replies
3701 Views
Last post April 14, 2016, 07:37:40 am
by DenDen66
2 Replies
3560 Views
Last post October 03, 2015, 02:32:42 pm
by Jim88

+-SMF Gallery

Quick Menu








Members Online

14 Guests, 0 Users
Powered by EzPortal