| T O P I C R E V I E W |
| Andy Humm |
Posted - 08 June 2008 : 03:35:55
Behind the scenes Leatherlips and I have been observing a few little areas of the forum that need tweaking for 100% accuracy. If you have incorporated the searchlog.asp mod and have it working, did you notice the General Statistics statement "55 searches have been performed since 08 June 2008 at 06:21:37." The date that has been extracted from the database, is in fact the last date of a recorded search and not the first date. The page code has a dim FirstSearchDate which currently pulls the last date. To rectify the problem:
Searchlog.asp line 75
find:
strsql = "SELECT SLS_DATE FROM " & strTablePrefix & "SEARCHLOG_SEARCHES ORDER BY SLS_DATE DESC"
replace with:
strsql = "SELECT SLS_DATE FROM " & strTablePrefix & "SEARCHLOG_SEARCHES ORDER BY SLS_ID ASC"
Now the statement will pull the first stored search date.
Happy editting.. Oops 'editing', thats better!
Andy
< |
| 2 L A T E S T R E P L I E S (Newest First) |
| Andy Humm |
Posted - 08 June 2008 : 09:54:59
If you read Leatherlips and my posts, generally that is what they are about, finding the spots
example with Post History here< |
| philsbbs |
Posted - 08 June 2008 : 06:42:32
Thanks for that, any more good spots ?< |
|
|
