| |
Dr.j
Registered: Feb 2003
Posts: 277 |
double users at Groups
as i am searching users at groups for my 8bitlegends webpage
for dedications and honor the 8bit heroes i have noticed a lot of double (and even triple) entry at groups with the same handle. i can give you examples for that so we need to delete all the Leftovers , maybe need to execute sql to remove/delete all the double entries |
|
| |
Conjuror
Registered: Aug 2004
Posts: 168 |
Could be people leaving and rejoining at a later time. |
| |
TheRyk
Registered: Mar 2009
Posts: 2241 |
It's a known phenomenon also known as the Rambones syndrome. Happens if people switch forward and back between old and new handles. Causes sth like a fissure in the time-space-continuum leading to these double or triple entries. So in a way sceners traveling through time become their own grandfathers. |
| |
Dr.j
Registered: Feb 2003
Posts: 277 |
i was referring the same handle maybe with a change of a letter could be caused as someone else didn't notice the
present handle and added a new one of himself but actually
it was already in the groups (often with the right handle for the first record) so there are double entries . im available for msg if you want examples for this fault |
| |
Moloch
Registered: Jan 2002
Posts: 2928 |
Why not post examples here in this thread? |
| |
Count Zero
Registered: Jan 2003
Posts: 1932 |
Along with the examples you may as well come up with some SQL magic finding these "with a change of a letter" entries? I mean - LIKE %smthg%- is not finding such. |
| |
TheRyk
Registered: Mar 2009
Posts: 2241 |
I could only think of these kinds of examples:
The Supply Team
Various sceners with same handles due to entering/leaving/re-entering groups.
But preventing such would mean new database fields/complicating things. |
| |
iAN CooG
Registered: May 2002
Posts: 3193 |
In the case of tst members, while it is accurate, I find excessive to state they left for a couple of days or one month then reentering. If it was for many months or some years I could understand it, but come on *sigh* |
| |
Dr.j
Registered: Feb 2003
Posts: 277 |
f.ex: Zorlak of Genesis Project (i will do a list later
and tell you more members there are definitely much more ) i aware he did leave and enter the group later, but should it require double entries?
i don't think so. if it make it complicated so this is
another issue |
| |
Moloch
Registered: Jan 2002
Posts: 2928 |
@Dr. J - That is the only way to handle someone leaving a group and returning later in the database. |
| |
Dr.j
Registered: Feb 2003
Posts: 277 |
@Moloch: Okey got you. thanks for referring |
| |
chatGPZ
Registered: Dec 2001
Posts: 11384 |
the problem here arent the double entries, the problem is that the presentation layer should get fixed so all ranges are displayed for one person.
not that it will ever happen :) |
| |
Dr.j
Registered: Feb 2003
Posts: 277 |
@Groepaz: this is what i meant in the first place , every click on a person will present his handle and time sequences even if its the same group (join - leave and rejoin) |
| |
TheRyk
Registered: Mar 2009
Posts: 2241 |
Doc: Timeline function already does it, click on scener handle and look for "Timeline" on top right
http://csdb.dk/timeline/?handle_id=849 |
| |
bepp
Registered: Jun 2010
Posts: 265 |
Quote: It's a known phenomenon also known as the Rambones syndrome. Happens if people switch forward and back between old and new handles. Causes sth like a fissure in the time-space-continuum leading to these double or triple entries. So in a way sceners traveling through time become their own grandfathers.
*Laughing out loud* =) |
