In Reply To:
1) will this be in an updated install? I want to know if I need to patch in teh event of a reinstallation or upgrade.
I just updated the 2.2.1 installer and posted an Official Bug Fix.
In Reply To:
2) can I get some rudimentary help with SQL that I can use to spread out my database of links? Basically, I want to put a fake "last verified" date in, based on the link ID so that I can get back to a 30 day spread.
What I had in mind was to separate the whole database by link ID (divide my links by 30) and then insert dates (spread over the last 30 days) in the last verified column.
Assuming you are using MySQL, the following query should do what you want:
Code:
UPDATE lsqldev_Links SET Date_Checked = FROM_UNIXTIME(UNIX_TIMESTAMP() - (ID % 30) * 24 * 60 * 60);
Using that query, you'll end up with Date_Checked being set to today for 30, 60, 90, ..., yesterday for 1, 31, 61, ..., 2 days ago for 2, 32, 62, ..., and so on up to 29 days ago for 29, 59, 89, ...
You could change this a little to give each link a random date and time over the past 30 days by changing '(ID % 30)' to 'RAND() * 30'.
Jason Rhinelander
Gossamer Threads jason@gossamer-threads.com