Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [SWDevil.Com] Admin Link Search Funcation from Database

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!
Subject Author Views Date
Thread Admin Link Search Funcation from Database VishalT 1534 Aug 2, 2005, 11:00 AM
Post Re: [SWDevil.Com] Admin Link Search Funcation from Database
Andy 1448 Aug 3, 2005, 2:46 AM
Post Re: [SWDevil.Com] Admin Link Search Funcation from Database
afinlr 1442 Aug 3, 2005, 3:53 AM