Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [blacknight] How Can I Reset Link ID?

Quote Reply
Re: [blacknight] How Can I Reset Link ID? In reply to
Mmm... that not very simple then :/

What you need to do - is firstly - move all the linkID's "down" in the list.

For example, if the valid listing, before the big gap of spam is ID 12345, then the next one would need to be 12346.

..and thats where the problem comes in :(

The best way to do it really - is to have a script, which would go through and re-make the ID number - and based on the last "good" link you have (i.e before the big gap), it would then update the glinks_Links/glinks_CatLinks table - with these new LinkIDs. This could be a dangerous process though, and its always a good idea to backup your DB, before you do anything like that =)

However, thats not as simple as it sounds Frown

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 Can I Reset Link ID? blacknight 3236 Jul 20, 2008, 6:24 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 3195 Jul 20, 2008, 6:32 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 3151 Jul 20, 2008, 6:33 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 3145 Jul 20, 2008, 6:37 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 3141 Jul 20, 2008, 6:38 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 3151 Jul 20, 2008, 6:39 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 3149 Jul 20, 2008, 6:40 AM
Post Re: [blacknight] How Can I Reset Link ID?
Wychwood 3114 Jul 22, 2008, 2:40 AM