Ended Official BYC Contest - Guess When We'll Reach 400,000 Members!

[Kgbao]

Wait a minute...
Isn't 10:00 p.m. closer to midnight than 5:00 a.m. is?

Lol was wondering if kinda like the price is right rule applies if your bid is over it doesn’t count lol

 

[Kiki]

Lol was wondering if kinda like the price is right rule applies if your bid is over it doesn’t count lol

Well well well...guess what we will have to be more specific about in the rules for next time?


I should be making a list.

 

[Nifty-Chicken]

He wrote this:

Banned aren't counted either.

THANKS!!!

I'll need to adjust the query!

This is valid and not-banned registrations per hour for the first half of April

SELECT count(*) AS total, HOUR(FROM_UNIXTIME(`register_date`)) AS hour
FROM xf_user
WHERE  `user_state` = 'valid' 
AND  `is_banned` = 0
AND DATE(from_unixtime(register_date)) BETWEEN '2020-04-01' AND '2020-04-15'
GROUP BY HOUR(FROM_UNIXTIME(`register_date`))

Registrations	Hour
168	0
160	1
131	2
140	3
93	4
82	5
39	6
44	7
34	8
41	9
52	10
77	11
83	12
155	13
159	14
169	15
169	16
168	17
162	18
163	19
179	20
159	21
167	22
148	23
TOTAL: 2942

 

[hysop]

115 to go someone will be a winner tomorrow but it won’t be me

That’s right it’s gonna be me!! Mwahaha

Actually with my type of luck I’ll miss it by an hour that @CindyinSD took.

 

[casportpony]

THANKS!!!

I'll need to adjust the query!

This is valid and not-banned registrations per hour for the first half of April

SELECT count(*) AS total, HOUR(FROM_UNIXTIME(`register_date`)) AS hour
FROM xf_user
WHERE  `user_state` = 'valid'
AND  `is_banned` = 0
AND DATE(from_unixtime(register_date)) BETWEEN '2020-04-01' AND '2020-04-15'
GROUP BY HOUR(FROM_UNIXTIME(`register_date`))

Registrations	Hour
168	0
160	1
131	2
140	3
93	4
82	5
39	6
44	7
34	8
41	9
52	10
77	11
83	12
155	13
159	14
169	15
169	16
168	17
162	18
163	19
179	20
159	21
167	22
148	23
TOTAL: 2942

What was April last year?

 

[hysop]

Wait a minute...
Isn't 10:00 p.m. closer to midnight than 5:00 a.m. is?

Lol was wondering if kinda like the price is right rule applies if your bid is over it doesn’t count lol

I actually read the rules and it says closest BEFORE or AFTER so get outta here with your price is right rules haha

 

[casportpony]

I actually read the rules and it says closest BEFORE or AFTER so get outta here with your price is right rules haha

 

[CarpCharacin]

THANKS!!!

I'll need to adjust the query!

This is valid and not-banned registrations per hour for the first half of April

SELECT count(*) AS total, HOUR(FROM_UNIXTIME(`register_date`)) AS hour
FROM xf_user
WHERE  `user_state` = 'valid'
AND  `is_banned` = 0
AND DATE(from_unixtime(register_date)) BETWEEN '2020-04-01' AND '2020-04-15'
GROUP BY HOUR(FROM_UNIXTIME(`register_date`))

Registrations	Hour
168	0
160	1
131	2
140	3
93	4
82	5
39	6
44	7
34	8
41	9
52	10
77	11
83	12
155	13
159	14
169	15
169	16
168	17
162	18
163	19
179	20
159	21
167	22
148	23
TOTAL: 2942

Yeah, restricting it to users in a valid state should ensure that it only includes users whom are also counted in the statistics.

 

[Kgbao]

I actually read the rules and it says closest BEFORE or AFTER so get outta here with your price is right rules haha

Hey I was trying to help you and dogandcat lol

 

[Nifty-Chicken]

What was April last year?

A LOT less... like at least 1/2