Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Paul] Editors Online: Table Join Prob

Quote Reply
Re: [Paul] Editors Online: Table Join Prob In reply to
Thanks both guys!

I have this working, as messy as it is: (though it is nice to see better ways to do it, thanks Paul, I will tinker with your suggestion.)

Sorry about the woeful formatting, makes it hard to read, but it is fine inside my plug-inCrazy

Quote:


for (@sess) {
$sess = do("$path/$_");
$user = $sess->{username};
@editor_catid = $DB->table('Editors')->select(['CategoryID'],{Username => $user})->fetchall_list;
my $file = $path . "/" . $_;
my $modtime = localtime( (stat($file))[9] );
print "<b>$user</b> : ";
if ($editor_catid[0] > 0) {
print qq~<font size="2" color="#FF9900"><b><i>Editor</i></b></font>&nbsp;&nbsp;&nbsp;<small>($modtime)</small><br>~;
}
else {
print qq~<i>User</i>&nbsp;&nbsp;&nbsp;<small>($modtime)</small><br>~;
}
foreach $catid (@editor_catid) {
if ($catid > 0) {
my $cat = $DB->table('Category')->select( ['Full_Name'], { ID => $catid } )->fetchrow_array;
print qq~<font size="2" color="#333333">&nbsp;Category: $cat</font><br>~;
}
}


http://www.iuni.com/...tware/web/index.html
Links Plugins
Subject Author Views Date
Thread Editors Online: Table Join Prob Ian 3568 May 17, 2002, 11:26 AM
Thread Re: [sooke] Editors Online: Table Join Prob
Ian 3353 May 17, 2002, 1:09 PM
Post Re: [Ian] Editors Online: Table Join Prob
pugdog 3319 May 27, 2002, 3:42 AM
Thread Re: [Ian] Editors Online: Table Join Prob
Paul 3296 May 27, 2002, 4:29 AM
Thread Re: [Paul] Editors Online: Table Join Prob
Ian 3301 May 27, 2002, 8:28 AM
Thread Re: [Ian] Editors Online: Table Join Prob
silky 3280 Jun 2, 2002, 7:46 PM
Post Re: [chaos] Editors Online: Table Join Prob
Ian 3289 Jun 2, 2002, 7:53 PM