| Author |
 Topic Search  Topic Options
|
WebWiz-Bruce 
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 16 April 2006 at 3:24pm |
|
Looking at it again you could get away with using the ID number, but as you want the order to be from the first posted date to the last posted date, by using the ID number there is some room for problems if for whatever reason the dates of the posts don't exactly match the ID order.
|
 |
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2006 at 5:39pm |
|
do you mean becose the thread is ordered by date and the "last posted" works of ordering by ID?
i intend to change the thread ordering by ID too - so there should be no problems
am just curious as to why threads are ordered by date rather than id
since (as i stated) problems arise from ordering by date.
as far as am aware the higher the ID, the later it was posted, so i assume its impossible to acctually change the ordering of IDs when posting (eg you cant get a lower ID than any post before you)
but with ordering by date, if the server time messes up, you can get your post before the others in the thread (if it went back in time) or if it goes forward, newer posts will go before the older posts once the server time is corrected (i had this problem so i changed it on my V7)
i personally am not aware of any benefits for ordering by Date, but am assure you have a reason
(again, am not trying to be annoying, just trying to find out why you use Date, if theres a reason i'll keep it otherwise if its just something you've done id rather change it to ID)
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2006 at 5:50pm |
|
The only reason is that the part in question gets the stats for the topic, which means that it needs to get the details of the first post posted and the last post posted in the topic.
The ID field should be OK, as in theory the newer posts should have a new ID number. The only time it would mess up is if some how the latest post in a topic doesn't have the highest ID number, if a post has been edited or moved from another topic.
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2006 at 3:23pm |
|
urr - i just found out that delete_post.asp doesnt use the function
could you tell me ALL the pages that use the "order by date" ?
so far i got:
functions_common.asp
delete_post.asp
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 April 2006 at 9:10am |
|
Sorry I can't remember without going through each and every individual file.
|
|
