Teams: Join a Team!

[mdettweiler]

Originally Posted by Lumiukko

Please add me to the PrimeSearchTeam.

--
Lumiukko

Welcome to NPLB! I've added you to PrimeSearchTeam in the database; the change should take effect in about 15 minutes when the next hourly stats run completes.

[Rick Reynolds]

Please add me to the team Aggie The Pew

Thanks much - Rick

[mdettweiler]

Originally Posted by Rick Reynolds

Please add me to the team Aggie The Pew

Thanks much - Rick

Done. Welcome to NPLB!

[mdettweiler]

Added Neo to team Aggie The Pew per a PM request at the PrimeGrid forum.

[Rick Reynolds]

Would you mind making Neo the owner of team Aggie The Pew?

Thanks Rick

[mdettweiler]

Originally Posted by Rick Reynolds

Would you mind making Neo the owner of team Aggie The Pew?

Thanks Rick

No problem--done.

[Oddball]

Could you add me to ROLP? I'm on a different team for TPS, but I'm defecting to ROLP during the NPLB rallies.

[mdettweiler]

Originally Posted by Oddball

Could you add me to ROLP? I'm on a different team for TPS, but I'm defecting to ROLP during the NPLB rallies.

Sure--we could always use a few extra cores in the rallies. Welcome to the team!

[Ian Smith]

Hi can you please put me in team Aggie The Pew

Many Thanks

[mdettweiler]

Originally Posted by Ian Smith

Hi can you please put me in team Aggie The Pew

Many Thanks

Welcome to NPLB! Before I can add you to a team, though, you'll need to submit at least one result to one of our servers to get your name registered in the system. Once you've done that, I can set the team field in the database.

[mdettweiler]

Per a PM discussion with Ralf Recker, he is changing teams from PrimeSearchTeam to "Sicituradastra.". (Yes, the period is part of the team name. ) More specifically:

-All tests submitted prior to 14:00 CDT today (2011-04-04) for "Ralf_Recker" will be moved to "PST_Ralf_Recker".
-All tests submitted after 14:00 CDT today for "Ralf_Recker" will remain there, and that username will be associated with Sicituradastra.

For those of you not familiar with our team-change policy, this procedure is needed to ensure that points earned on a particular team stay with that team (since the database requires a username to be associated with one and only one team at a given time). A fuller explanation of this is given in the first post of this thread.

@Dave: I'm going to try doing the database changes for this myself; I've got a pretty good idea of what needs to be done from when we did this before with Lennart. Just so you know, the procedure I'll use is to run the following command:

update results set username = "PST_Ralf_Recker" where (username = "Ralf_Recker" and date < "2011-04-04 14:00:00");

and then use the web interface to set PST_Ralf_Recker's team to PrimeSearchTeam and Ralf_Recker's to Sicituradastra.

Edit: first step (moving results to PST_Ralf_Recker) is done. This was pretty easy since I did it just a few minutes after the 14:00 DB rollover, so all of Ralf_Recker's results matched the date < "2011-04-04 14:00:00" condition. Now I just need to wait for the next hourly refresh for this to take effect (and some fresh results to populate the now-empty Ralf_Recker username) and then I can make the requisite team changes.

Edit 2: team changes are now complete as well.