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

New built in translations for six langauges! by EzPortal
March 26, 2024, 11:15:32 pm

Smiley missing in shoutbox 2.1.4 by hustreamload
July 26, 2023, 08:14:02 am

Re: Theme Select Box question? by Shades
March 15, 2023, 06:49:49 pm

Re: Theme Select Box question? by Shades
March 09, 2023, 02:09:24 pm

Re: Theme Select Box question? by Shades
March 09, 2023, 01:55:53 pm

Re: Theme Select Box question? by EzPortal
March 09, 2023, 01:47:42 pm

Re: Theme Select Box question? by Shades
March 09, 2023, 01:34:07 pm

Re: Theme Select Box question? by EzPortal
March 09, 2023, 12:20:17 pm

+- HTML Menu


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

Recent Topics ezBlock

New built in translations for six langauges! by EzPortal
March 26, 2024, 11:15:32 pm

Smiley missing in shoutbox 2.1.4 by hustreamload
July 26, 2023, 08:14:02 am

Theme Select Box question? by Shades
March 15, 2023, 06:49:49 pm

Where is the facebook button color? by EzPortal
February 28, 2023, 06:45:09 pm

Display on Mobile - SMF 2.1.3 and EZ 5.5.2 by BugginIn
December 29, 2022, 04:07:13 pm

Blocks Help by Riggs1973
November 20, 2022, 12:59:30 pm

Surface ol lite theme release Free! by Steffen K.
November 18, 2022, 03:57:24 am

Undefined index: href by EzPortal
October 04, 2022, 08:49:59 pm

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

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

+-SMF Gallery

Quick Menu


Powered by EzPortal