Collection Manager Changes

Sandy · **Posted:** Sun Dec 21, 2008 5:31 pm

Logging in to the CM was broken for a day or two, it's fixed now. I broke it as I was reworking the website security for the puzzle database maintenance/moderation code. (BTW, I received a dozen or so e-mails from people informing me of this, but only the last one actually contained an explanation of what was going on [thanks Fractangle!]. The rest of them were useless, and looked like spambot stuff, so I ignored them. Don't bother submitting one of those error forms if you haven't taken the time to fill in a field or two.)

The login system of the collection manager is about to be retired. Collectors will be able to log into to the collection manager using their forum accounts. There are currently 307 collections in the collection manager. Of those, I can match 128 of them reliably to forum accounts using the e-mail addresses in both systems, or 105 of them less reliably using the user names in both systems for a cumulative total of 159, leaving 148 unmatchable and an additional 31 poorly matched.

Anyway, here is the list of the poorly or unmatched collection manager accounts. Please reply here if one of them is yours to help me match the rest up. When the conversion happens, unmatched accounts will be orphaned and possibly deleted.

Code:

Collection Manager Account Name          Account ID
04mucklowd                               2784
a passion for puzzles                    1306
Aaron Mcgiggles                          232
Airsea                                   2742
Alain Zalmanski                          115
Aleksey Baulin                           19
Alex                                     37
Alex                                     2818
Alexander Ooms                           111
Alexis                                   326
Alonso                                   2773
AntonioGallego                           149
Arthur                                   89
ArymeZWretched                           2793
Avi                                      29
bhendry                                  102
Brax13                                   2739
bwabwaz                                  2743
chiperten                                197
Chris Maggs                              36
Christoph Lohe                           42
Christopher Seung-Hoon Yi                148
Cisco                                    48
cliftar                                  2802
Corneliu Zavadovschi                     33
crazyjuggler                             2734
cube2                                    2769
CubeNerd007                              2745
cubix147                                 106
Dan                                      28
daveguy                                  459
David Litwin                             198
DennisL                                  2779
Deryq33                                  179
Dodd                                     63
Donnie Wallace                           100
dooper                                   2762
Ed Cambridge                             24
elevencharlie                            2796
Emile                                    362
emr1028                                  622
Enru                                     1864
Eric?                                    256
Erick Anderson                           46
ericporetsky                             2749
Erik Akkersdijk                          135
Flunk (Matt Fryett)                      73
Foufouille                               249
Fractangle                               2806
Francois Reitter                         165
Frank                                    22
Frank Johnson                            138
gee3092004                               227
generalmaxime                            2808
Geo                                      2815
Geoffroy                                 61
Georges Helm                             66
Grim                                     2748
Gus                                      143
Hanpatsu Akuma                           2805
heidi bernice waberski                   136
ihatefrauwahlgren                        2789
imran06                                  2172
irish                                    161
Jacob Maerzke                            2803
Jeff Goetz                               40
JeffCC                                   43
Jenilia                                  127
Jensen Graham                            231
jjros242                                 1078
Joe Wallace                              153
John Pena                                69
John Redvers Rooney                      32
JohnB                                    54
Justin                                   160
Karthik Puthraya                         2141
Katie                                    381
Kelly Burnell                            57
Kenny                                    2788
Kerstin                                  2821
Kerstin                                  2822
Kerstin                                  2823
Kickflip1993                             2814
KickinFamily                             2732
Kid_With_Teh_moHawk (Clayne Hawley)      79
Kilian                                   84
Kirjava                                  119
Korkow                                   130
L                                        2801
L                                        2794
LeifEricson                              88
leopulga                                 2810
leopulga                                 2811
Lewis                                    2778
Lewwwwis                                 2777
Lin Chung                                30
Liz Burrow                               49
Maarten Vermaak                          59
magic cuber                              2792
mamessing                                108
marcordenis                              1112
Marcus Luna                              2764
Maria                                    110
MaxWiz                                   18
metalopig                                2781
micro500                                 107
Mika                                     2738
Mike                                     2767
mike                                     2766
mlgymrat                                 2800
msturges                                 2741
myoldmac.net                             166
nascarjon                                125
Nick                                     1937
Nickie                                   2746
nicky_uk                                 77
nmpuzzler                                75
OrnoR                                    103
Parksddd                                 23
Pazman                                   74
pdrenski                                 390
Pembo                                    156
Plavs                                    2222
PUZZLEIST                                53
puzzlemanbob                             400
PuzzleManiac                             58
Puzzler                                  98
quadricode                               94
RdsG                                     2758
redbear088                               132
Revolt2Revolt                            2768
Richard                                  38
Roadblock                                2744
Rob Buckalew                             2816
Roman                                    55
RomeoB                                   2787
Roxanne                                  25
rubik_fr                                 172
Rubik-Maze                               2782
RubiksMaster123                          2750
rubixcubedude846                         2772
rxdeath                                  126
rxdeath                                  2740
Ryanrex116                               2799
Sa967St                                  2751
Salam Chehadeh                           97
Scott Bedard                             167
Scott Johnson                            60
Shane                                    52
Sjoerd                                   2804
skosowsky                                2763
snake solver                             170
snake solvers wish list                  173
snowqueen                                894
srednashtaeh                             2756
Stacy Vicknair                           95
Stanislav TVRDIK                         168
stefanbayens                             2759
Stephen Blauer                           35
Swashbuckler                             1656
takuoworld                               2760
TheAtarian1                              1740
Thomas H.                                2774
Thomas Higgins                           2819
TomZ                                     2765
Trevor Sayre                             62
Twisty T                                 2809
Twisty_Jones                             242
twistypuzzleskid123                      2795
ufolong2002                              174
Vertclychalnged9                         236
Victoria                                 114
volker25670                              642
wilelsa23                                137
wolfy                                    144
wwwebb                                   93
xgreenxdayx24x                           2780
yanni                                    2817
yunsub kim                               99

Sandy

Sandy · **Posted:** Sun Dec 21, 2008 5:42 pm

Oh, and I realize that many have created more than one collection manager account because of the "one collection per account limitation". I suppose I'll have to resolve this limitation before converting to the new login system completely.

Sandy

Aleksey · **Posted:** Sun Dec 21, 2008 6:39 pm

Sandy, "Aleksey Baulin" is mine for sure. 8-)

katsmom · **Posted:** Sun Dec 21, 2008 7:29 pm

Roxanne is Katsmom. Or is Katsmom Roxanne :wink:

DLitwin · **Posted:** Sun Dec 21, 2008 9:07 pm

"David Litwin" is me, DLitwin.

Dave

Fractangle · **Joined:** Wed Oct 08, 2008 11:41 am **Location:** Earth

Mine is "Fractangle". Yep, just like my forum username!

Georges · **Posted:** Mon Dec 22, 2008 12:57 am

Georges Helm is me, but the data seem strange.
In your list it says (item count)
Georges Helm 151 148
but in the members collection list it says
Georges Helm 418 419
The cid is 66 both times

Sandy · **Posted:** Mon Dec 22, 2008 1:12 am

Thanks for pointing that out, Georges. I'm just guessing, but it looks like I must have sorted only some of the columns in Excel. I've removed the fields from the above list to avoid confusion (and to save me the time of doing it again!).

Sandy

wwwebb · **Joined:** Sun Jan 11, 2009 11:06 pm

I only had the collection before... After seeing this thread, I signed up for a forum account.

wwwebb is the username in both.

Celia · **Posted:** Sat Jan 17, 2009 1:46 pm

I know someone from that list. She has a collection, but is not a user of the forum.

Another friend of mine would also like to put up her collection but not post in the forum.

Will that not be possible anymore? Or will they have to sign up for the forum in order to only show their collections?

Thanks, Celia

Sandy · **Posted:** Wed Jan 21, 2009 2:03 pm

Excellent question. That might explain the lack of response to this topic. Honestly, I've never considered the possibility that there were non-forum members in the members collections list!

I can see a way of easily shifting my plan to accomodate non-forum collectors, so no worries.

Sandy

Fractangle · **Joined:** Wed Oct 08, 2008 11:41 am **Location:** Earth

Sandy wrote:

Honestly, I've never considered the possibility that there were non-forum members in the members collections list!

That's kind of funny (please don't take this in a bad way) to me, as at one point I had thought that one must have a collection to register an account on the forum!

Also, I want to give you a big thank-you, as I know you've done so much work to keep this site up and running. I know that so often people, including myself, forget how much goes on behind the scenes, and take it for granted, but I think it's important to recognize the effort you put into this. Thank you.

Sandy · **Posted:** Sat Feb 28, 2009 10:03 am

Any others?

I'm almost done merging the CM login with the forum logins, and I'll be compiling the final mapping of CM to forum accounts within the next week. CM accounts not mapped to forum accounts will be converted into new forum accounts which will be linked back to their collection. An e-mail will be sent to the non-mappable CM account people informing them of the change and welcoming them to the forum. This will cause an artificial spike of about 140 members in the forum, and may kick off a wave of new forum participants.

CM accounts that can be mapped to forum accounts will also be e-mailed informing them about the change since the CM login method will change from using the e-mail address to the forum account name.

I'm really looking forward to getting rid of that old "security" system. Insert irony emoticon here.

Sandy

Sandy · **Posted:** Sun Mar 15, 2009 12:49 am

New collection manager installed, along with a host of minor updates to all kinds of other things. CM logins are now the same as your forum logins. Use your forum name and forum password to login to the CM, not your e-mail address and CM password as before. Those CM accounts that could be matched to forum accounts were linked up. Of those left over, any "collection" that had 0 items was deleted. The remaining 89 CM accounts were converted into active forum accounts, and linked to their collections.

If anyone noticed the CM downtime (I uploaded all my changes and busted it!), I blame the recent hardware troubles. I had written a database update script, ran it offline for all my testing, lost it with the hard drive fiasco, and forgot all about it until I started getting errors after uploading all my changes.

If you used the CM before, try logging in to your collection now. Let me know if you find anything that appears broken.

This conversion took a lot of steps. Getting rid of that poor-man's security system was a big step for the site. I'm happy. I'm also tired.

Sandy

Celia · **Posted:** Sun Mar 15, 2009 6:50 am

The CM works well for me. One question though:

When I'm logged in to my collection I'm not also logged in here. Meaning: I went to the CM page, logged in, then went to the forum page from there and wasn't logged in even though I hadn't logged out on the CM page. Is that intentional?

Celia

Georges · **Posted:** Sun Mar 15, 2009 7:15 am

I stay logged in to the forum after having logged in to the CM.

Sandy · **Posted:** Sun Mar 15, 2009 7:47 am

Oh yeah, I forgot to mention that. I wouldn't call it "intentional", it's merely the current behaviour. My intention is to create a fully integrated solution, where logging into one logs you into both. The new code is set up to extend in that direction when I'm ready to do so, but I haven't yet. My primary goal of eliminating the gaping security holes in my old system have been reached, and I feel drawn to moving on to other features for the time being.

Excuse the continued inconvenience of the double login and enjoy the new convenience of the single username/password pair, and I'll enjoy the greater sense of security! There are just a few more known holes in the security, which I hope to be clearing up in the coming weeks.

Sandy

Collection Manager Changes

Who is online