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

Re: [rage] how to delete links between id 2000 and id 3000

Quote Reply
Re: [rage] how to delete links between id 2000 and id 3000 In reply to
Hi,

First of all BACKUP VIUA MySQLMan! I won't be held responsible if this doesn't do what you want Tongue

Run (obviously replacing glinks_ with whatever you have):

DELETE FROM glinks_Links WHERE ID > 2000 AND ID < 3000

..and then:

DELETE FROM glinks_CatLinks WHERE LinkID > 2000 AND LinkID < 3000

...Then, you need to run Build > Repair Tables , to fix your category counts.

Hope that helps.

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 how to delete links between id 2000 and id 3000 rage 4223 Jul 9, 2007, 2:48 PM
Post Re: [rage] how to delete links between id 2000 and id 3000
blacknight 4086 Jul 10, 2007, 2:25 AM
Thread Re: [rage] how to delete links between id 2000 and id 3000
Andy 4093 Jul 10, 2007, 2:36 AM
Thread Re: [Andy] how to delete links between id 2000 and id 3000
brewt 4096 Jul 10, 2007, 1:07 PM
Post Re: [brewt] how to delete links between id 2000 and id 3000
Andy 4078 Jul 11, 2007, 2:47 AM
Thread Re: [brewt] how to delete links between id 2000 and id 3000
rage 4049 Jul 13, 2007, 9:48 AM
Post Re: [rage] how to delete links between id 2000 and id 3000
brewt 4083 Jul 13, 2007, 2:47 PM