Members who have viewed this thread

[The Don]

Dunno if it's meant to be like this but it would be much better if it were in alphabetical order

http://icap.me/i/F0g68L8ep9.png

[Chris]

At the moment I think its done by the members join date. Not sure whether its changeable or not but it doesn't bother me either way.

[David]

I thought it was sorted by the last to view the thread?

[xxMATTGxx]

Isn't set by the settings so no idea how it figures it out.

[Chippiewill]

It stores a list in the order that you can first see them "viewing" the thread, or in other words in the order that they saw the thread. They get loaded from the DB in the same order.

[Martin]

It stores a list in the order that you can first see them "viewing" the thread, or in other words in the order that they saw the thread. They get loaded from the DB in the same order.

oh :P I could have sworn it was in order of member join dates!

I'm always next to chris for some reason and we registered like 3 days apart, and all the lists Ive seen so far seem to go in order from oldest member by join date to newest :O Maybe just coincidence then haha

[Chippiewill]

oh :P I could have sworn it was in order of member join dates!

I'm always next to chris for some reason and we registered like 3 days apart, and all the lists Ive seen so far seem to go in order from oldest member by join date to newest :O Maybe just coincidence then haha

The oldies are more addicted than the newbies.

[Martin]

The oldies are more addicted than the newbies.

Yeah must be haha, happens in like every single thread which is why I thought it was based on join date :P especially because when you hover over the names it tells you what time they viewed the thread doesnt it? and they are certainly not in order :P

[Chippiewill]

Yeah must be haha, happens in like every single thread which is why I thought it was based on join date :P especially because when you hover over the names it tells you what time they viewed the thread doesnt it? and they are certainly not in order :P

The hover time is the most recent view, the list in in order of first view.

[Martin]

The hover time is the most recent view, the list in in order of first view.

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!

[David]

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

[Martin]

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

[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".

[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.


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".

[Chippiewill]

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.

[Grig]

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.

[Grig]

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

[Chippiewill]

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.

[Grig]

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

[Chippiewill]

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.

[Grig]

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.

it must think order by join date must be most efficient then :P.

[Chippiewill]

it must think order by join date must be most efficient then :P.

If it was last running operations on the user table then yeah, but if it was just looking at the IP table then it'll order by most recently active.

[HotelUser]

Apparently this is a vBulletin feature and not a plugin so instead of sketchily editing files I've made a plugin which alphabetizes the list.

I put it together quickly so if it doesn't work for you give me a shout with your theme & browser.