Hi,
Can you open up ULTRAGlobals.pm, and find (in the Last_Links_By_Category function, near the bottom of the file):
my $cond2 = GT::SQL::Condition->new('isValidated','=','Yes');
my $sth = $db_obj->select (['Links.*'], $cond, $cond2 ) || die $GT::SQL::error;..add this after:
print $sth->query;
Then save, and refresh your page. What query is it showing?
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Can you open up ULTRAGlobals.pm, and find (in the Last_Links_By_Category function, near the bottom of the file):
Code:
my $cond = GT::SQL::Condition->new('CategoryID', 'IN', $all_ids); my $cond2 = GT::SQL::Condition->new('isValidated','=','Yes');
my $sth = $db_obj->select (['Links.*'], $cond, $cond2 ) || die $GT::SQL::error;
Code:
print $IN->header; print $sth->query;
Then save, and refresh your page. What query is it showing?
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!