Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Importing - Hits=0 -> Hits=1

Quote Reply
Importing - Hits=0 -> Hits=1
After I import links from DMOZ all of my imported links are displaying Hits="0". How can I change all of the links in my database to default to Hits =1 instead (after being imported)? What command do I need SQL Monitor to make this modification?

Thanks alot.

mgeyman
Quote Reply
Re: [mgeyman] Importing - Hits=0 -> Hits=1 In reply to
UPDATE lsql_Links SET Hits=1 WHERE Hits < 1;



something along those lines, because you dont won't to reset existing links with hits


http://www.iuni.com/...tware/web/index.html
Links Plugins