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: How to remove the SMF menu on top of the portal by VSD
November 04, 2020, 11:02:52 pm

Re: How to remove the SMF menu on top of the portal by EzPortal
November 04, 2020, 09:29:10 pm

Re: How to remove the SMF menu on top of the portal by VSD
November 04, 2020, 08:17:14 pm

Re: How to remove the SMF menu on top of the portal by EzPortal
November 04, 2020, 07:57:05 pm

How to remove the SMF menu on top of the portal by VSD
November 04, 2020, 07:43:18 pm

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

+- HTML Menu


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

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

+-SMF Gallery

Quick Menu



Members Online

20 Guests, 0 Users
Powered by EzPortal