Markos: Duplicate names in registration list

Skanky Burns · June 25, 2002, 08:43

There have been a number of threads on this topic, but this bug still remains.

I'm assuming the code does SQL queries to get the list of people who have registered 'today'. Why not add the key-word distinct so it only grabs 1 of each registered person.

Code:

sql = "SELECT DISTINCT * FROM ..."

Not being able to see the code, I'm not sure what you have done, but this seems to be an easy solution to the (admittedly small) but annoying problem.

Hueij · June 25, 2002, 19:20

You mean something like this?

BTW, I noticed that Provost H had two birthdays yesterday

Hydey · June 26, 2002, 07:06

yes thats what he means

Skanky Burns · June 26, 2002, 10:49

Indeed. Although the two Provost H's were different. One was his temporary DL when he was first banned, the other is his actual login. One had a space in it too (which I didn't notice until I clicked on them)

Skanky Burns · June 26, 2002, 22:19

*Ahem*

War4ever · June 29, 2002, 17:21

dl dld dl dl ....there everywere

alva · July 3, 2002, 03:05

Today's Registrations: 8
G.S. boy, G.S. boy, G.S. boy, merc9, merc9, merc9, seau1, Dereth

War4ever · July 3, 2002, 13:34

must be an error in the database

Straybow · July 8, 2002, 18:51

Some really are dls, people hit the button more than once, or change the default password and come back in a couple hours and can't remember it… been going on for ages. Look up Sir David and see how many times he registered

Hope he isn't around to defend himself.

Skanky Burns · July 8, 2002, 21:49

Yep, you are right. They all have unique id numbers.