Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Admin Link Search Funcation from Database

Quote Reply
Admin Link Search Funcation from Database
Today I was trying to see how many links have been added after July 2nd 2005, and I use 2005-07-02 in the add date field of search and selected the option, greater than, however I was shocked to see only 416 results, whele there should be atleast 2800+ results (not all links are validated though).

Can someone tell me what am I doing wrong? or how can I check for the links in the directory being added between certain time frame.

Thank you for the help again.

Vishal

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] Admin Link Search Funcation from Database In reply to
Hi,

Try something like this;

1) Goto http://www.4webhelp.net/us/timestamp.php
2) Enter the day/month/year and hours/mins/secs as just 00/00/00
Example: http://www.4webhelp.net/...nd=00&timezone=0

3) Once you have the timestamp, i.e 1122940800, then run this MySQLMonitor command;

Code:
SELECT COUNT(*) FROM lsql_Links WHERE TimeStmp >= 1122940800;

NB: The TimeStmp field is the "last modified" flag, so it will match links that were added after that date, but also those that were modified.

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!
Quote Reply
Re: [SWDevil.Com] Admin Link Search Funcation from Database In reply to
I seem to remember that the Add_Date field in the new version is set up differently - so that the Add_Date starts from when the link is validated? Otherwise, what you did seems fine.