Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Increase Link Count ID

Quote Reply
Increase Link Count ID
Ok an odd request this, but how would you go about artificially increasing the link count ID. At the moment I have about 170 links but what if I wanted to start the id number at 1000 onwards?

--------------------------------
Privacy Software
Quote Reply
Re: [BLOOD] Increase Link Count ID In reply to
You could do it with something like this (in MYSQLMonitor);

UPDATE lsql_Links SET ID = ID + 1000
UPDATE lsql_CatLinks SET LinkID = LinkID + 1000

Not guaranteed to work.. so be sure to make a backup before doing anything Wink

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!
Quote Reply
Re: [Andy] Increase Link Count ID In reply to
There are other tables that depend on the LinkID to track data. Reviews, ratings, etc. All those need the LinkID field updated as well.


PUGDOG´┐Ż Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [BLOOD] Increase Link Count ID In reply to
Just do it in the template. E.g "10<%grand_total%>"

cdkrg

Able2Know :: Ajooja Directory