Gossamer Forum
(Advanced Search)
for
Home : Products : Others : Gossamer Community :

Displaying user profile data in dbman SQL

Aug 31, 2009, 11:11 PM
Dempsey
Novice (44 posts)
Aug 31, 2009, 11:11 PM
Post #1 of 2
Views: 1026
Shortcut
Quote Reply
Displaying user profile data in dbman SQL
I would like to display data from the community profile, in my dbman sql 2.0. I have it working properly with Community, but can't figure this out. I found this code on the forums, but it just returns an error when I put it in one of my dbman sql templates:

<%Plugins::Auth_Community::get_profile%> - imports the user profile data as template tags, then:
<%prof_city%> - displays city data from the user's profile
<%comm_username%> - displays username from the user's profile

Is this the right code to make this work? Any help would be greatly appreciated. Thanks
Sep 1, 2009, 12:22 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Sep 1, 2009, 12:22 AM
Post #2 of 2
Views: 1011
Shortcut
Quote Reply
Re: [Dempsey] Displaying user profile data in dbman SQL In reply to
Hi,

Mmm.. I've never had anyt luck with the built in function for "loading" the profile. I don't use DBMan, but something like this should work:

get_gcomm_profile
Code:
sub {

my $user = $_[0];

my $cfg = DBMan::Plugins->get_plugin_user_cfg('Auth_Community');

my $NEWDB = new GT::SQL (
def_path => "$cfg->{community_private}/defs",
cache => 0,
debug => 0,
subclass => 1
);


require GT::SQL::Condition;
my $db = $NEWDB->table('comm_users');

return $db->select( { comm_username => $user } )->fetchrow_hashref;

}
...then call with:

<%get_gcomm_profile($USERNAME)%> - where $USERNAME is the one you wanna load.

The bit in red may need changing - cos I don't actually know where the equivelant of Links::Plugins is stored =))

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates