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

Re: [mick31] Duplicate_Check

Quote Reply
Re: [mick31] Duplicate_Check In reply to
How about replacing;

Code:
my $url = $IN->param('URL');
my $cond = GT::SQL::Condition->new('URL','LIKE',"$url%");
$chk_dup = $db_con->count ( $cond );

...with;

Code:
my $url = $IN->param('URL');
my $url2 = $url;
$url2 =~ s/www\.//i;
my $url3 = $url;
$url3 =~ s,(/|\\)$,,i;

my $cond1 = GT::SQL::Condition->new('URL','LIKE',"$url%");
my $chk_dup1 = $db_con->count ( $cond1 );

my $cond2 = GT::SQL::Condition->new('URL','LIKE',"$url2%");
my $chk_dup2 = $db_con->count ( $cond2 );

my $cond2 = GT::SQL::Condition->new('URL','LIKE',"$url3%");
my $chk_dup3 = $db_con->count ( $cond3 );

$chk_dup1 ? $chk_dup = $chk_dup1 : '';
$chk_dup2 ? $chk_dup = $chk_dup2 : '';
$chk_dup3 ? $chk_dup = $chk_dup3 : '';

Untested, but it should work.

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!
Subject Author Views Date
Thread Duplicate_Check mick31 7270 Oct 1, 2003, 2:27 PM
Thread Re: [mick31] Duplicate_Check
Andy 7264 Oct 2, 2003, 2:04 AM
Thread Re: [Andy] Duplicate_Check
mick31 7227 Oct 2, 2003, 3:06 AM
Thread Re: [mick31] Duplicate_Check
Andy 7163 Oct 2, 2003, 3:07 AM
Thread Re: [Andy] Duplicate_Check
aus_dave 7174 Oct 4, 2003, 5:51 AM
Post Re: [aus_dave] Duplicate_Check
Andy 7156 Oct 6, 2003, 12:55 AM
Thread Re: [Andy] Duplicate_Check
mick31 7103 Dec 16, 2003, 9:24 AM
Thread Re: [mick31] Duplicate_Check
Andy 7140 Dec 16, 2003, 9:28 AM
Thread Re: [Andy] Duplicate_Check
mick31 7120 Dec 16, 2003, 9:37 AM
Thread Re: [mick31] Duplicate_Check
Andy 7106 Dec 16, 2003, 9:50 AM
Thread Re: [Andy] Duplicate_Check
Coombes.. 7101 Dec 16, 2003, 10:08 AM
Thread Re: [Coombes..] Duplicate_Check
Andy 7148 Dec 16, 2003, 10:16 AM
Post Re: [Andy] Duplicate_Check
Coombes.. 7070 Dec 16, 2003, 10:25 AM
Post Re: [Andy] Duplicate_Check
mick31 7090 Dec 16, 2003, 11:25 AM
Thread Re: [Andy] Duplicate_Check
mick31 7100 Dec 16, 2003, 12:33 PM
Thread Re: [mick31] Duplicate_Check
Andy 7080 Dec 17, 2003, 1:29 AM
Thread Re: [Andy] Duplicate_Check
mick31 7077 Dec 17, 2003, 3:17 AM
Thread Re: [mick31] Duplicate_Check
Andy 7098 Dec 17, 2003, 3:23 AM
Thread Re: [Andy] Duplicate_Check
mick31 7045 Dec 17, 2003, 3:30 AM
Post Re: [mick31] Duplicate_Check
Andy 7031 Dec 17, 2003, 3:34 AM