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: SMF-ezportal_column_5.cache): failed to open stream: No such file or directory by EzPortal
June 04, 2022, 11:40:13 am

SMF-ezportal_column_5.cache): failed to open stream: No such file or directory by Shades
June 04, 2022, 11:29:37 am

Re: Arcade block error: failed to open stream: No such file or directory by Shades
May 20, 2022, 02:47:13 pm

Re: ezPortal 5.5 by EzPortal
May 20, 2022, 09:59:30 am

Re: ezPortal 5.5 by tigez
May 20, 2022, 08:46:15 am

Re: Undefined index: href by Shades
May 16, 2022, 02:58:21 pm

Re: Image/Attachment display issue by Shades
May 16, 2022, 02:28:35 pm

Re: Undefined index: href by Shades
May 16, 2022, 02:27:16 pm

+- HTML Menu


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

Recent Topics ezBlock

SMF-ezportal_column_5.cache): failed to open stream: No such file or directory by EzPortal
June 04, 2022, 11:40:13 am

Arcade block error: failed to open stream: No such file or directory by Shades
May 20, 2022, 02:47:13 pm

ezPortal 5.5 by EzPortal
May 20, 2022, 09:59:30 am

Undefined index: href by Shades
May 16, 2022, 02:58:21 pm

Image/Attachment display issue by Shades
May 16, 2022, 02:28:35 pm

Can't delete custom actions by Shades
April 13, 2022, 12:53:28 pm

Newest Member ezblock by Shades
March 23, 2022, 12:48:32 pm

Random Download Block by Shades
March 22, 2022, 10:37:47 am

BBC Pages by EzPortal
March 21, 2022, 10:36:41 pm

Recent Topics Blocks are different from left side to right side by Shades
March 21, 2022, 02:42:38 pm

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

+-SMF Gallery

Quick Menu


Powered by EzPortal