Naked Science Forum

General Discussion & Feedback => Guest Book => Topic started by: DoctorBeaver on 27/02/2009 12:46:51

Title: Who joined when statistics
Post by: DoctorBeaver on 27/02/2009 12:46:51
Can we have a table of members ranked by when they joined? I know we can see when an individual member joined by checking their profile, but that has to be done on a 1-by-1 basis. I'd like it tabulated so I can see who's been here for how long.

It's a simple enough SQL query (I know the SMF database structure) so it shouldn't be difficult to incorporate.

Pretty please?
Title: Who joined when statistics
Post by: BenV on 27/02/2009 16:19:11
I suggested this to Dave, who sighed and looked at his enormous list of things to do and asked "why?"
Title: Who joined when statistics
Post by: dentstudent on 27/02/2009 16:34:08
Also, a thread start date would be good too. It would be useful to see this in the thread list in the column next to "Started by".

Also "pretty please", but this time with knobs on.  [:X]
Title: Who joined when statistics
Post by: dentstudent on 27/02/2009 16:36:33
And if Dave has such a huge list and there are people such as the Beaver who are capable, why not out-source some of it? I'm sure that there would be people willing to give their time on a voluntary basis.

Well, reasonably sure anyway.
Title: Who joined when statistics
Post by: DoctorBeaver on 27/02/2009 17:10:17
Stuart - I've got too much on my plate already (as you can imagine, I'm pressed for time) otherwise I'd be only too pleased to help out.
Title: Who joined when statistics
Post by: dentstudent on 27/02/2009 17:19:16
Eth - I well understand. I wanted to show your abilities as an example....Sorry for any confusion!
Title: Who joined when statistics
Post by: DoctorBeaver on 27/02/2009 17:56:29
Why, thank you, dear boy  [:)]
Title: Who joined when statistics
Post by: Chemistry4me on 27/02/2009 23:44:02
You mean like this!  [:)]

 [ Invalid Attachment ]
Title: Who joined when statistics
Post by: Karen W. on 27/02/2009 23:48:49
That is kinda cool..
Title: Who joined when statistics
Post by: Chemistry4me on 27/02/2009 23:49:50
This is even cooler!


 [ Invalid Attachment ]
Title: Who joined when statistics
Post by: Chemistry4me on 27/02/2009 23:52:00
DOH! Half got cut out!
Title: Who joined when statistics
Post by: Chemistry4me on 27/02/2009 23:59:27
This should be better:

 [ Invalid Attachment ]
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 00:01:14
You wanna know where to geddit DoctorBeaver?
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 00:18:44
Also, a thread start date would be good too. It would be useful to see this in the thread list in the column next to "Started by".

Also "pretty please", but this time with knobs on.  [:X]
Now that would be good!
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 00:32:18
This should be better:

 [ Invalid Attachment ]









That is good for those wanting to see these~!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 04:54:09
You wanna know where to geddit DoctorBeaver?
Well do you or don't you!?!
Title: Who joined when statistics
Post by: DoctorBeaver on 28/02/2009 09:35:38
C4M - how did you get that?
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 09:37:47
Some looked like such old statistics!
I can't even find it!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 09:39:53
C4M - how did you get that?
Nice eh? Pretty handy huh? All 273 pages of them [:)]
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 09:41:49
????
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 09:43:06
No actually, make that 279 pages [:)]
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 09:48:10
Looks like Karen W. is on to it [;)]
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 09:50:49
Have you worked it out Karen W.?
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 09:52:17
NO.. But I am looking.. found places I did not know about? LOL
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 09:54:02
Really? I would have thought you knew this forum inside out! [:)]
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 09:58:34
No I am stumped!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:02:45
Never fear, I am sure you will find it very soon. [:)]
The forum is only so large [:)]
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 10:04:12
dude..help!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:05:40
Come on girl don't give up! You were on the right track before [:)]
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:11:47
Btw, you won't find it in the help page [;)]
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 10:17:10
smart aleck!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:19:09
Perhaps you should get some sleep and try again later? [:)]
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 10:31:10
no thanks....not tired.. but I'll pass on the wild goose chase!
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 10:38:27
This is even cooler!


 [ Invalid Attachment ]

My mmbs lst s dffnt!
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 10:41:05
my members list is different!!!

What are you doing..? I cant post anything but gobilty goop!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:46:27
You can't post anything but gobilty goop? HUH? [???]
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:47:02
This is even cooler!


 [ Invalid Attachment ]

My mmbs lst s dffnt!
How different?
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 10:47:49
my kybads nt tyng all th ltts!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:48:45
no thanks....not tired.. but I'll pass on the wild goose chase!
It's not a wild goose chase! It is the search for knowledge! [:D]

------
I am sure someone very soon will figure it out!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 10:50:37
my kybads nt tyng all th ltts!
What? Your keyboard is not working?
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 11:07:03
yes! Thank you! Seems like it is working some now though!
Dang thing has me crawling on the floor under my desk... needed to call for help outta there! Dang!LOL
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 11:10:48
Now back to the wild goose chase search for knowledge! [;)]
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 11:14:00
Search for knowledge... eh.. half afraid to search again for fear I did something to the keyboard....
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 11:15:26
Yes indeed. neilep should have this for his puzzle of the week!
Title: Who joined when statistics
Post by: Karen W. on 28/02/2009 11:18:25
Yes he should.. I am stumped.. Neily needs a new one! Its a good thread!
Title: Who joined when statistics
Post by: Chemistry4me on 28/02/2009 23:27:18
You ready to keep on searching? [:)]
Title: Who joined when statistics
Post by: Chemistry4me on 01/03/2009 05:03:42
Perhaps I should just give it to you? [:)]
Title: Who joined when statistics
Post by: Karen W. on 01/03/2009 07:23:43
I just switched from phone to computer..How are you tonight?
Title: Who joined when statistics
Post by: Chemistry4me on 01/03/2009 07:34:25
You talking to me?

If so: I'm good [:)]
Title: Who joined when statistics
Post by: Karen W. on 01/03/2009 07:36:45
Certainly! Good!
Title: Who joined when statistics
Post by: Chemistry4me on 14/03/2009 10:41:29
Have you figured it out yet Karen W.? [:)]
Title: Who joined when statistics
Post by: Karen W. on 14/03/2009 11:11:59
Have you figured it out yet Karen W.? [:)]

Lol...lol...smart aleck! Lol..... why did I not know that....eh?
Title: Who joined when statistics
Post by: Chemistry4me on 14/03/2009 11:13:19
So you've finally solved the mystery of the 'who joined when statistics'? [:)]
Title: Who joined when statistics
Post by: Karen W. on 14/03/2009 11:52:53
No you solved it..I followed you in....Lol!
Title: Who joined when statistics
Post by: Chemistry4me on 14/03/2009 12:07:09
Well I was certainly surprised that I was probably one of the few who knew about it! [:o]

Even DoctorBeaver and you didn't know about it! [^]
Title: Who joined when statistics
Post by: Karen W. on 14/03/2009 12:17:00
I have been to members list many many times but It did not occur to me at all..Lol.. I don't go there a lot but from time to time .
Title: Who joined when statistics
Post by: Chemistry4me on 14/03/2009 12:18:46
But now your search for knowledge is complete. [;)]
Title: Who joined when statistics
Post by: Karen W. on 14/03/2009 12:23:10
My search for knowledge never will cease!
Title: Who joined when statistics
Post by: Chemistry4me on 14/03/2009 12:23:25
Good Night. [:)]
I'm spent. [xx(]
Title: Who joined when statistics
Post by: Karen W. on 14/03/2009 12:31:06
Good Night. [:)]
I'm spent. [xx(]

night C4M..get some sleep!
Title: Who joined when statistics
Post by: DrN on 14/03/2009 13:12:54
I've been to these stats pages many times, but now for some reason I can't seem to find it today! Any clues? I seem to remember it being quite simple, so why isn't my brain working?
Title: Who joined when statistics
Post by: neilep on 14/03/2009 13:13:43
*smug Mode*

i've known about those lists (and the ability to re-arrange them ) for years !

*end of smug mode*





*humble mode*

Hope that's ok ?   [:-[]
Title: Who joined when statistics
Post by: neilep on 14/03/2009 13:15:03
the smileys don't work


 [:)] [;)] [:D] [;D] [>:(] [:(] [:o] [8D] [???] [::)] [:P] [:-[] [:-X] [:-\] [:X] [:-'(] [:I] [8] [:o)] [xx(] [V] [|)] [B)] [8)] [?] [O8)] [:0]
Title: Who joined when statistics
Post by: neilep on 14/03/2009 13:15:31
Oh, yes they do...but the 'Embarrassed' one does not !!..grrrrrrrrrr !!
Title: Who joined when statistics
Post by: neilep on 14/03/2009 13:20:06
I've been to these stats pages many times, but now for some reason I can't seem to find it today! Any clues? I seem to remember it being quite simple, so why isn't my brain working?



here ya go :


 [ Invalid Attachment ]

Title: Who joined when statistics
Post by: neilep on 14/03/2009 13:22:05
Don't forget to click on FORUM first then scroll down to ' MORE STATS '
Title: Who joined when statistics
Post by: DrN on 14/03/2009 13:22:16
I just came back to say I found it, to see you've been so kind as to tell everyone anyway! I managed to find them the very first time I logged on to this site, wasn't so hard, I hate it when my brain freezes adn I can't seem to do the simplest of things.
Title: Who joined when statistics
Post by: neilep on 14/03/2009 13:38:47
I hate it when my brain freezes Adan I can't seem to do the simplest of things.

Be pleased that ewe're not the opposite like me !  [;)] In perpetual brain freeze with occasional glimpses of function !
Title: Who joined when statistics
Post by: Karen W. on 14/03/2009 14:28:32
You fuction brilliantly!!!!
Title: Who joined when statistics
Post by: Chemistry4me on 14/03/2009 23:28:25
the smileys don't work


 [:)] [;)] [:D] [;D] [>:(] [:(] [:o] [8D] [???] [::)] [:P] [:-[] [:-X] [:-\] [:X] [:-'(] [:I] [8] [:o)] [xx(] [V] [|)] [B)] [8)] [?] [O8)] [:0]
Yes, hence the thread: http://www.thenakedscientists.com/forum/index.php?topic=19343.0
Title: Who joined when statistics
Post by: Karen W. on 15/03/2009 00:26:20
 [:)] [;)] [:D] [;D] [>:(] [:(] [:o] [8D] [???] [::)] [:P] [:-[] [:-X] [:-\] [:X] [:0] [O8)] [?] [8)] [B)] [|)] [V] [:(!] [^] [xx(] [:o)] [8] [:I] [:-'(]
Title: Who joined when statistics
Post by: Chemistry4me on 15/03/2009 06:59:00
You can't have two brackets. [] it should have been made as [:-(]
Title: Who joined when statistics
Post by: Karen W. on 15/03/2009 14:51:51
It was working off and on...but now..I can't get it to work at all.

Are you thiking it would work if Dave changed one bracket to a parenthisies ( ?
Title: Who joined when statistics
Post by: Chemistry4me on 16/03/2009 05:12:40
Probably.
Title: Who joined when statistics
Post by: Raghavendra on 25/03/2009 08:48:09
cool
Title: Who joined when statistics
Post by: Yomi on 05/04/2009 12:49:19
stats dont really work out
Title: Who joined when statistics
Post by: Chemistry4me on 05/04/2009 12:55:46
What do you mean? Of course they work. [:)]
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 08:24:19
Only to show popularity right?
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 08:26:35
No, if they wanted to do that, they would have the Karma back.
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 08:33:02
Uuhh
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 08:35:37
Forgotten about the Karma already? Or were you not joined when we had that?
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 08:39:22
ya, i joined late?
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 08:42:25
these is my first youtube video.. but not nice, rubbish ?
Title: Who joined when statistics
Post by: Karen W. on 06/04/2009 11:01:28
It was a good start .. The writing was good except it went to fast to read it....
Can you slow down the moving writing long enough for someone to read it before it disappears?
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:35:58
oh ok i will do it?
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 11:38:37
Yeah, the writing went too fast, I had to watch it twice.
Also, you should use captal letters where they belong, not 'i think' but 'I think'. I think that this will make it a bit more professional (in my humble opinion). [:)]
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:39:46
ok.... I will improve my grammer
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 11:41:26
Btw... I really liked the Matrix part of it. [:D]
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:42:42
 [:D] night i saw the film that's why? [::)]
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 11:44:09
That's great, keep up the good work.
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:45:51
indirectly you are killing me.
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 11:50:03
Just watch me go!

(https://www.thenakedscientists.com/forum/proxy.php?request=http%3A%2F%2Fwww.staynehoff.net%2Fmatrix_ii_iii.jpg&hash=bd72f5c64b42d555c55aa56f58cdabc5)
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:53:06
i din't got you, what did you say?
Title: Who joined when statistics
Post by: Karen W. on 06/04/2009 11:53:46
Yeah, the writing went too fast, I had to watch it twice.
Also, you should use captal letters where they belong, not 'i think' but 'I think'. I think that this will make it a bit more professional (in my humble opinion). [:)]
I think C4M is right!

I was trying to read fast and did not notice that stuff.. Good Job C4M.. I used the bar to watch it slower.. by holding the play bar back to read it better.
Title: Who joined when statistics
Post by: Karen W. on 06/04/2009 11:54:29
Btw... I really liked the Matrix part of it. [:D]

Yep me too! The light show was cool!
Title: Who joined when statistics
Post by: Karen W. on 06/04/2009 11:55:39
indirectly you are killing me.

What?
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:56:38
nothing i was just joking with him?
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 11:57:59
What exactly are these vidoes going to be about Sachin? How will they be formatted? I know you said they will be about organic chemistry but how/where/who are you going to get your information from?
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 11:58:39
nothing i was just joking with him?
Hey! What did I just tell you about the '?'? [:)]
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 11:59:48
ya that was correct, i agree with you
sorry
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 12:01:48
So what about my other post?


What exactly are these vidoes going to be about Sachin? How will they be formatted? I know you said they will be about organic chemistry but how/where/who are you going to get your information from?

Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 12:04:40
Hardwork
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 12:05:03
I should know the difference b/w Hard work and work hard
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 12:07:21
You should send me a copy of it when you're done aye?
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 12:08:11
Ok
Title: Who joined when statistics
Post by: Chemistry4me on 06/04/2009 12:12:05
Really? How long will it be?
Title: Who joined when statistics
Post by: Raghavendra on 06/04/2009 12:13:56
I don't know