Members who have viewed this thread

Quote:

---

Originally Posted by Bolt660

ah :P

I still dont get why in every thread for me, the order is in join date rather than who viewed it first etc LOL I havent found a thread yet where im not next to chris!

---

must be stalking you

Quote:

---

Originally Posted by David

must be stalking you

---

well I don't mind ;)



Yeah I guess its strange how older members tend to view threads first, I guess it is just coincidence haha xD tis a clever little system tho

I've just had a read through the way the code is written, genuinely facinating. It appears that there's no specific order other than what mysql sees fit, it loads as table full of "who read what thread when" (Sorted by first thread reading), an ip address table (sorted by latest forum activity) and the users table which is sorted by the userid which is the same as the join date. Not sure what's why it's inconsistent, I guess it's just easier for whatever stuff mysql had to lookup for my particular usergroup etc. beforehand. As it happens the list randomly changed sort order for me about 10 minutes ago from "first reading" to "latest activity".

I also took a look at the source and rather than finding it genuinely fascinating I found it genuinely mortifying. Firstly due to the fact I just opened a over 2500 line file and then having to look at some shambolic mess that would be a extreme pain to have to work with. No idea how a largish software company can produce such unmanageable code.

Quote:

---

Originally Posted by Chippiewill

I've just had a read through the way the code is written, genuinely facinating. It appears that there's no specific order other than what mysql sees fit, it loads as table full of "who read what thread when" (Sorted by first thread reading), an ip address table (sorted by latest forum activity) and the users table which is sorted by the userid which is the same as the join date. Not sure what's why it's inconsistent, I guess it's just easier for whatever stuff mysql had to lookup for my particular usergroup etc. beforehand. As it happens the list randomly changed sort order for me about 10 minutes ago from "first reading" to "latest activity".

---

Quote:

---

Originally Posted by Tomm

I also took a look at the source and rather than finding it genuinely fascinating I found it genuinely mortifying. Firstly due to the fact I just opened a over 2500 line file and then having to look at some shambolic mess that would be a extreme pain to have to work with. No idea how a largish software company can produce such unmanageable code.

---

Well yes, the code really should have been split up, the quality of the code is terrible. But the behavior was what I found interesting.

It does seem to be done by join date. I've had a look at various threads, stalked some people and saw the trend. Haven't see a single pattern to break it either. Although the code may not indicate it, it is done by that. So no @Bolt660; it isn't a fluke or destiny that you and Chris are positioned together :P.

Besides, I haven't viewed this thread first and I'm still the first on the list of this thread because I am oldest by join date.

edit: just found a thread that breaks the trend, so I guess it goes my diff. things.

Actually, that was just temporary, haven't found a thread that broke the trend.

Quote:

---

Originally Posted by Grig

Actually, that was just temporary, haven't found a thread that broke the trend.

---

As I said, it can change from person to person, thread to thread, time period to time period for any variety of stupid reasons. All because vbulletin staff were to lazy to add an ORDER BY clause into the mysql query.

Quote:

---

Originally Posted by Chippiewill

As I said, it can change from person to person, thread to thread, time period to time period for any variety of stupid reasons. All because vbulletin staff were to lazy to add an ORDER BY clause into the mysql query.

---

First it goes by order or who viewed it, then it seems to be join date. It's very interesting, go to a few older threads and look at the users and you see this trend. It's weird considering they put no specific order by clause :P

Quote:

---

Originally Posted by Grig

First it goes by order or who viewed it, then it seems to be join date. It's very interesting, go to a few older threads and look at the users and you see this trend. It's weird considering they put no specific order by clause :P

---

If you don't use an ORDER BY clause it uses the default table order, but because it's using MYSQL JOIN's to join different table's together it sort of just "picks one" depending on what's most efficient.