Not an SQL question, but it seems related to the thread. This is strange... I'm going to have to do some looking around Links and find the localtime calculations. The glitches I've notice are:
1) All the categories on the home page have the 1-2 days new image (using three levels of new graphics), but not all of them really have new links contained within.
2) All search results come back with the 1-2 days new image.
3) In admin, add a link places "1-Jan-1910" as the date.
4) Last night's cron build (4 am server time) did not build an index page for the "new" directory, and as you can see (unless I fix it first):
www.run-down.com/New/ there is a page for seemingly every day of new links going back to April '99, which would be right around when I installed the script.
Time to start digging...
Dan
edit: Further info, nph-build.cgi is flagging every link as new (explains #2), building the homepage (explains #1), and dying after the new build because it can't find the "new" index page. That's why none of the category pages show "new" -- they haven't been updated.
nph-build.cgi uses
time(); throughout, but I don't see any mention of localtime in it. Seems to only show up in db_utils.pl and links.cfg, and nothing looks out of place that I can see...
edit2: As noted in
http://www.gossamer-threads.com/...m12/HTML/001802.html the problem was not script-related. Sorry.
[This message has been edited by Dan Kaplan (edited January 01, 2000).]
[This message has been edited by Dan Kaplan (edited January 01, 2000).]