Hi,
Before doing any of this, PLEASE BACKUP YOUR DATABASE! You could try this plugin:
http://www.gossamer-threads.com/...nks_P304684/#p304684 To get a list of the records to delete, try doing this:
1) Add a new global:
get_old_unvalidated
Code:
sub {
my $back;
my $sth = $DB->table('Links')->select( ['ID'], { isValidated => "No" } );
while (my $id = $sth->fetchrow) {
$back .= "$id,";
}
$back =~ s/,$//;
return $back;
}
..then make a new template called
get_ids.html , and place the following content in it:
Code:
<%get_old_unvalidated%>
Then, run from your browser with:
page.cgi?p=get_ids
This should then give you a list of all the linkID's you wanna delete (the unvalidated ones) .. just pass this (long) list of ID's to the plugin I mentioned earlier, and it should get rid of them all for you :)
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
