Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [gravitydex] Mass Deletion of Add Link Requests

Quote Reply
Re: [gravitydex] Mass Deletion of Add Link Requests In reply to
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
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 Mass Deletion of Add Link Requests gravitydex 3949 Sep 2, 2010, 10:18 AM
Thread Re: [gravitydex] Mass Deletion of Add Link Requests
Andy 3846 Sep 2, 2010, 10:25 AM
Thread Re: [Andy] Mass Deletion of Add Link Requests
blacknight 3836 Sep 3, 2010, 2:58 AM
Post Re: [blacknight] Mass Deletion of Add Link Requests
Andy 3823 Sep 3, 2010, 2:59 AM