A suggestion for a slightly silly but mysterious one [Archive]

MarkRBright

01-24-2017, 04:32 AM

OK, how about this for a suggestion for a new cross-denomination, cross project/sub-project MM version of a a SuperDuperBok, that might appeal, due to it being slightly ridiculous, and nearly impossible to get, and therefore potentially very mysterious!
Here goes. For every value-based MM, you get one of these when you hit the target on the nose. So for every Project and Subproject, if I were to have actually achieved a score of exactly 1 Million (or 1K/10K/25K/50K etc.), then I would get one of these. Obviously there has to be a level of tolerance to accommodate projects that give out decimal cobblestones, just like of for Trigggls/Boks etc. but it has to be brutal - it is +/- 0.5.
Not sure how easy it would be to code for but I just thought I would throw it into the pot. I would imagine that at the same time you are accumulating all the value related MM’s you could stick a plus one into a new counter for each one that is bang on.
In case you go for it, I have thought up some suggestions for a name for this new MM, and offer up the following selection. Nebbers, Conks or Brightys - my favourite is Nebber.
I openly confess that I only thought of this when I realised that I had achieved a second one of them today, without actually trying to. I would currently get one for the Primaboinca project where I have exactly 1M, and one for SRBase’s ‘Sierpinski Base’ Sub-project where I have – probably fleetingly - exactly 250K.
It’s actually quite easy to check if you have any as a quick scan down the Score column on CPIUD page and the SubProject page looking for the exact MM target numbers.
For something like this it would be nonsense to have a limit of more than one before it showed, as I suspect that very few people will have any at all, never mind more than one – I would not be remotely surprised to find that I was in the number one spot with two.
So, mysterious and hard to get. Are you not a wee bit tempted? :-)

MarkRBright

02-12-2017, 12:47 PM

I am guessing it was just a bit too silly then. :(

Bok

02-12-2017, 03:45 PM

no, it has merit, just not got round to it...

MarkRBright

02-14-2017, 04:00 AM

That's good, but having said that I have had a bit of a thought about this and I think the +/- 0.5 stones is probably too tight, and possibly too difficult to get! There is no point in having a mysterious one if there is nobody to notice the mystery! My instinct tells me that there ought to be some small sensible tolerance - the same across all MM targets to keep things simple - and I think it probably ought to be either +/- 10 stones, or perhaps 0.1% of the relevant MM (i.e. plus OR minus 0.1%) if that is easy to do.
I feel that this way people would see a few more of them and wonder how they got something for reaching 999,001!!! If anything it would probably add to the mystique. What do you think?

MarkRBright

02-18-2020, 08:02 PM

Just thought I'd post something to this again so that it stays alive. I still like this idea.

MarkRBright

10-14-2020, 05:26 AM

Still liking this one!

Dirk Broer

10-15-2020, 01:14 PM

Still liking this one!

Let's call it the SmartyPants then, SuperDuperBok is slightly over the top IMHO, and it gives the opportunity to switch pants -with the SquarePants....
It is even related: https://encrypted-tbn0.gstatic.com/images?q=tbn%3AANd9GcQuflmPdbblAVI96UK5kg3cmn7FiHffVbDIaw&usqp=CAU

Bok

10-15-2020, 03:35 PM

So this would need to check

for each project
(have I got exactly 10k or 25K or 50K or 100K or 500K or 1M etc

Whilst doable, that's a lot of calculations. But i will try and see

Bok

10-15-2020, 03:44 PM

PDW

10-15-2020, 04:41 PM

Not so keen on this one, Coleslaw's https://www.free-dc.org/showthread.php?57942-Coleslaws however is a winner ;)

Bok

10-15-2020, 05:07 PM

Not so keen on this one, Coleslaw's https://www.free-dc.org/showthread.php?57942-Coleslaws however is a winner ;)

Not so sure for the reasons I have on that post. I could just create a new team, move all my accounts to it and not allow new users. I'd be #1 in any active project available :)

PDW

10-15-2020, 05:09 PM

Not so sure for the reasons I have on that post. I could just create a new team, move all my accounts to it and not allow new users. I'd be #1 in any active project available :)
Need to weight it against the number of other active team mates and possibly the amount of output they are doing.

Bok

10-15-2020, 11:30 PM

Need to weight it against the number of other active team mates and possibly the amount of output they are doing.

Well, good point, but the cynic in me says that you could also create as many other id's you like and add them to the team and skew the team numbers like that.

Unsure, but it feels like this one could be gamed. Happy for you to counter the argument though :)

MarkRBright

10-16-2020, 04:35 AM

This might work ?

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user where truncate(metric1,0) in (10000,100000,500000,1000000) group by cpid order by mycount desc limit 0,10;
+----------------------------------+------------+---------+
| cpid | nick | mycount |
+----------------------------------+------------+---------+
| 0dd9749ec16c8900f065d871290156bc | BAR | 7 |
+----------------------------------+------------+---------+
10 rows in set (8.956 sec)

Sorry to interrupt, but can we please stay on track here:hiya:, this is about Nebbers! :D
Excuse my lack of SQL but is this just a trial? I was thinking more ALL of the credit-value based MMs so 1000 10000, 25000 etc and for both Projects and SubProjects and with a tolerance of somewhere about 0.1% either way. It may seem like a lot to do but I feel there will not be many of them so perhaps it won't take too long, though if it does, then by all means drop the idea. Cheers

Bok

10-16-2020, 08:59 AM

This was just to show how it could be done.

Bok

10-16-2020, 01:48 PM

MarkRBright

10-16-2020, 05:12 PM

I think I see, and that looks like a promising start - other than the "MySQL server has gone away" bit!
Combine it with SubProject breakpoints and Nebbers is go - assuming there's some tolerance in there somewhere - though I don't see it if it is. No I'm not looking for a free SQL lesson! ;-) Good work I think!

MarkRBright

10-16-2020, 05:20 PM

The nice thing about this one is that I think everyone is as likely as anyone else to get one. OK so the more projects / SubProjects you have worked on increases the odds a fair bit, but someone could have worked on 5 projects and have one or two of these and quite probably wont know why! I always got the impression that you were quite keen on mysterious ones Bok.
I do think the 0.1% tolerance would make a difference if you haven't already got it in there. I would have thought that they will be far more commonplace with that tweak. Or would it be easier to just arbitrarily say plus or minus 500 say, or some such? I'm not bothered, but I suspect you will find more of them with percentages. Why not have a look at the data and pick what you think works best.

Bok

10-17-2020, 12:57 AM

MarkRBright

10-17-2020, 03:53 AM

I feel that it wouldn't really be worth doing if there were going to be so few of them - so I wouldn't bother unless tolerances are doable. Just had a quick look at BAR and it appears that whoever he or she is, ramped up a bunch of Trigggls and stopped and may not have Boinced for some time so this could be wasted on them!!! (On that note, would it be easy to introduce a Date Last Seen under the current date First Seen in the headers - perhaps you already track this but don't show it? Obviously you do track the hosts but that would be a much more long winded approach, and you could just update a date when you update any other stuff in the daily update. When displaying you could just show "Unknown" if the date is blank - Sorry - I digress)
In your example above I would argue that it should have been between 99990 and 100010 for the second one, though after seeing it 0.5% (maybe more?) might be more interesting, as more people would get them and quite possibly have no clue as to why. Why anyone think they would get 'rewarded' for a subproject reaching 99952, 499751 or 24876 credits after all? That would be more interesting. Maybe you should delete this thread once you have decided ;-)

MarkRBright

10-19-2020, 08:35 PM

Just in case it helps you Bok, I knocked this up - it doesn't take into account SubProjects but I suspect a bit of copy and paste would do so in a few seconds. I went for a 0.5% tolerance. Why not see how long it takes to run and decide if it's doable or not

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user
where
(truncate(metric1,0) between 9995 and 10005)
or (truncate(metric1,0) between 24975 and 25025)
or (truncate(metric1,0) between 49950 and 50050)
or (truncate(metric1,0) between 99995 and 10050)
or (truncate(metric1,0) between 249750 and 250250)
or (truncate(metric1,0) between 499500 and 500500)
or (truncate(metric1,0) between 749250 and 750750)
or (truncate(metric1,0) between 999995 and 1000050)
or (truncate(metric1,0) between 2497500 and 2502500)
or (truncate(metric1,0) between 4995000 and 5005000)
or (truncate(metric1,0) between 9999995 and 10000050)
or (truncate(metric1,0) between 24975000 and 25025000)
or (truncate(metric1,0) between 49950000 and 50050000)
or (truncate(metric1,0) between 99999995 and 100000050)
or (truncate(metric1,0) between 249750000 and 250250000)
or (truncate(metric1,0) between 499500000 and 500500000)
or (truncate(metric1,0) between 999999995 and 1000000050)
or (truncate(metric1,0) between 2497500000 and 2502500000)
or (truncate(metric1,0) between 4995000000 and 5005000000)
or (truncate(metric1,0) between 9999999995 and 10000000050)
or (truncate(metric1,0) between 24975000000 and 25025000000)
or (truncate(metric1,0) between 49950000000 and 50050000000)
or (truncate(metric1,0) between 99999999995 and 100000000500)
or (truncate(metric1,0) between 249750000000 and 250250000000)
or (truncate(metric1,0) between 499500000000 and 500500000000)
or (truncate(metric1,0) between 999999999995 and 1000000000050)
or (truncate(metric1,0) between 2497500000000 and 2502500000000)
or (truncate(metric1,0) between 4995000000000 and 5005000000000)
or (truncate(metric1,0) between 9999999999995 and 10000000000050)

group by cpid order by mycount desc limit 0,10;

Bok

10-19-2020, 10:49 PM

MarkRBright

10-20-2020, 03:50 AM

subprojects are a different table so it that complicates..
I'm not sure you have them all correct, for instance 99995 and 10050, in fact all of your ones like that have a 5 tolerance on the prior but much more on the post side :)
Ah yes, sorry - I had a rush of blood just after 1am and started doing that. I was tired and started copying and pasting and just adding zeros. Never a good time for my best work - apologies (I guess I lose the chance of being a subcontractor! ;-), not that I have touched SQL for nearly 30 years anyway
So, whilst I think we could expect a good few more entries if it were corrected and if Subcontracts were added, Nebbers looks like being a fun enough one to me. What do you think?
I'll correct my mistakes and return it later today.
And what were you doing checking it out at 3:49am or is that my time?

MarkRBright

10-20-2020, 04:27 AM

Apologies again for my stupid errors in that, that is probably the first time in all my years of programming that I didn't know how to calculate the values at runtime from an array of fixed values and a parameterised percentage tolerance! Bring back Cobol! Hey ho, it was fun but this ought to be a bit better, hopefully even right.

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user
where
metric1 between 995 and 1005
or metric1 between 9950 and 10050
or metric1 between 24875 and 25125
or metric1 between 49750 and 50250
or metric1 between 99500 and 100500

or metric1 between 248750 and 251250
or metric1 between 497500 and 502500
or metric1 between 746250 and 753750
or metric1 between 995000 and 1005000

or metric1 between 2487500 and 2512500
or metric1 between 4975000 and 5025000
or metric1 between 9950000 and 10050000

or metric1 between 24987500 and 25012500
or metric1 between 49950000 and 50050000
or metric1 between 99950000 and 100050000

or metric1 between 249875000 and 250125000
or metric1 between 499500000 and 500500000
or metric1 between 999500000 and 1000500000

or metric1 between 2498750000 and 2501250000
or metric1 between 4995000000 and 5005000000
or metric1 between 9995000000 and 10005000000

or metric1 between 24987500000 and 25012500000
or metric1 between 49950000000 and 50050000000
or metric1 between 99950000000 and 100050000000

group by cpid order by mycount desc limit 0,10;

I assume you can just copy and paste and change the names for SubProjects but I don't know.

Bok

10-20-2020, 08:48 AM

MarkRBright

10-20-2020, 08:27 PM

OK then I'll leave it in your capable hands.

MarkRBright

10-23-2020, 05:30 PM

Gah! I mad another mistake in it with putting zeros and 9's in the wrong places, it should be

MariaDB [static]> select cpid,nick,count(*) as mycount from boinc_user
where
metric1 between 995 and 1005
or metric1 between 9950 and 10050
or metric1 between 24875 and 25125
or metric1 between 49750 and 50250
or metric1 between 99500 and 100500

or metric1 between 248750 and 251250
or metric1 between 497500 and 502500
or metric1 between 746250 and 753750
or metric1 between 995000 and 1005000

or metric1 between 2487500 and 2512500
or metric1 between 4975000 and 5025000
or metric1 between 9950000 and 10050000

or metric1 between 24875000 and 25125000
or metric1 between 49950000 and 50050000
or metric1 between 99500000 and 100500000

or metric1 between 248750000 and 251250000
or metric1 between 499500000 and 500500000
or metric1 between 995000000 and 1005000000

or metric1 between 2487500000 and 2512500000
or metric1 between 4995000000 and 5005000000
or metric1 between 9950000000 and 10050000000

or metric1 between 24875000000 and 25125000000
or metric1 between 49950000000 and 50050000000
or metric1 between 99500000000 and 100500000000

group by cpid order by mycount desc limit 0,25;

This highlights the benefits of being able to parameterise it and work it out automatically at run time! I have no idea if SQL allows this but it would be good if it did. Anyway - sorry for messing you about, I am fairly sure it is right now.

MarkRBright

10-24-2020, 04:23 AM

Double ARGGGH! So I was just sorting out a test for this in a spreadsheet, and I was horrified to see that there were still some differences once I had built some formulas - which I think just goes to show how tricky it will be for people to work out why the have suddenly gotten whatever number of Nebbers they get :-) Anyway according to my spreadsheet your SQL statement should be as follows :

select cpid,nick,count(*) as mycount from boinc_user
where
metric1 between 995 and 1005
or metric1 between 9950 and 10050
or metric1 between 24875 and 25125
or metric1 between 49750 and 50250
or metric1 between 99500 and 100500

or metric1 between 248750 and 251250
or metric1 between 497500 and 502500
or metric1 between 746250 and 753750
or metric1 between 995000 and 1005000

or metric1 between 2487500 and 2512500
or metric1 between 4975000 and 5025000
or metric1 between 9950000 and 10050000

or metric1 between 24875000 and 25125000
or metric1 between 49750000 and 50250000
or metric1 between 99500000 and 100500000

or metric1 between 248750000 and 251250000
or metric1 between 497500000 and 502500000
or metric1 between 995000000 and 1005000000

or metric1 between 2487500000 and 2512500000
or metric1 between 4975000000 and 5025000000
or metric1 between 9950000000 and 10050000000

or metric1 between 24875000000 and 25125000000
or metric1 between 49750000000 and 50250000000
or metric1 between 99500000000 and 100500000000

or metric1 between 248750000000 and 251250000000
or metric1 between 497500000000 and 502500000000
or metric1 between 995000000000 and 1005000000000

group by cpid order by mycount desc limit 0,25;

I also chucked another band on the end as there are probably some people out there with trillions.
OK I will shut up for a bit now, and stop making blattantly obviuos mustakes (hopfully)

MarkRBright

10-30-2020, 05:06 AM

So I was testing this Nebbers idea out yesterday and I calculated on my spreadsheet how many I would get as a test, and for a laugh I added a line to the bottom of the MMs data that I import to see it's effect on my various other tables/graphs.
Well... we are just moving to the highest Tier of Covid Restrictions here this weekend so I might as well get used to filling my time!
Anyway, having been pushed into guessing my rank for Nebbers I thought that it might be amusing - if only for me - to publish my predictions just so I have something to really look forward to in Lockdown - Namely "Just how wrong could I be?"
So with that, here are the predictions from my panel of experts ;-)

MM Type Nebbers
Many 53
RankP 300
RankT 3
RankC 14
#Maxwell 80
#TeraMiRB 49
#MiRB 12

Ooh! I just can't wait! :banana::rolleyes:

MarkRBright

10-30-2020, 05:15 AM

BTW Bok , if you do ever find the time to do this one (and I'm not nagging you here), could you please put it above SubClanks and Clanks on the MMs table, as it is probably slightly less volatile than those two.

Bok

10-30-2020, 08:59 AM

Going to try an implement this tomorrow. My wife and daughter are away for hockey this weekend, so I get some time :)

MarkRBright

10-30-2020, 02:24 PM

I'll keep my eyes peeled :thumbs:

Bok

11-01-2020, 10:16 AM

I kind of got it working yesterday, btu oly for the main projects. The subproject data is giving me fits due in main to cpid changes leaving orphaned data in the subproject table.

I may just implement it for main data only for now.

MarkRBright

11-01-2020, 01:00 PM

I suppose that would make it all the more mysterious and intriguing when you added them later! :thumbs:

MarkRBright

11-02-2020, 07:26 PM

It has just occurred to me that it could be fun to confuse Nebbers even more by adding some additional (arguably missing) ones like 2,500 5,000, 7,500, 75,000, 7,500,000, 75,000,000 etc.
It would also differentiate it a bit more from Squarepants.
I doubt many Boincers would get many of these though as I suspect most people would not stop on those, but it might give some interesting temporary rises and falls in the number of Nebbers as they 'pass through', which could keep it interesting.
Just a thought.

Bok

11-03-2020, 09:18 AM

Have a look on stats6 and see if the data looks correct, then I'll add it to stats.

MarkRBright

11-03-2020, 12:31 PM

My spreadsheet predicted 27 non-SubProject Nebbers for me and that is what I have gotten so that is cool - excellent work as ever Bok.
The only alarm bell for me is that stats6 still has SubBoks and SubTeraBoks (of all things!) missing and Nebbers is appearing below Clanks. I only mention it because I don't know if you copy the whole thing or just the amended code but could you put Nebbers above Clanks and SubClanks please.
Thanks again and I look forward to you working out how to include SubProjects one of these days.

Bok

11-03-2020, 02:11 PM

My spreadsheet predicted 27 non-SubProject Nebbers for me and that is what I have gotten so that is cool - excellent work as ever Bok.
The only alarm bell for me is that stats6 still has SubBoks and SubTeraBoks (of all things!) missing and Nebbers is appearing below Clanks. I only mention it because I don't know if you copy the whole thing or just the amended code but could you put Nebbers above Clanks and SubClanks please.
Thanks again and I look forward to you working out how to include SubProjects one of these days.

They will be above clanks after everything re-runs tonight. For now I only ran it for them and they are sharing the same unique number which sorts them.

SubBoks and subteraboks look like they are giving an error during calculation on stats6 and it's the same issue I get with Nebbers (NULL cpid on orphaned subproject data).

the newer version of Mariadb is more strict here than the mysql version on the older stats server which is why it does not appear there.

I need to solve that.

MarkRBright

11-03-2020, 04:58 PM

They will be above clanks after everything re-runs tonight. For now I only ran it for them and they are sharing the same unique number which sorts them.
SubBoks and subteraboks look like they are giving an error during calculation on stats6 and it's the same issue I get with Nebbers (NULL cpid on orphaned subproject data).
the newer version of Mariadb is more strict here than the mysql version on the older stats server which is why it does not appear there.
I need to solve that.
Looks like you sorted the SubBoks and SubTeraBoks out, and I see what you mean about sharing the same number now (2395) I assume you are just rejigging the lower numbers to make room. Looks good.
I assume that you have only run Nebbers for a subset of all users as I can't believe I would be so high up the running order otherwise. I also assume that the Maxwell/MiRB and TeraMiRB values will come with a full run.
Great stuff.

MarkRBright

11-04-2020, 04:04 AM

Stats6 looks good to me now - good work, thanks. :thumbs:

Dirk Broer

11-07-2020, 06:41 PM

Stats6 looks good to me now - good work, thanks. :thumbs:

But not to me. Two of my WCG badges are off -Open Pandemics-COVID-19 shows as sapphire badge while it should be a 5 year diamond and Africa Rainfall Project shows a silver badge while it hould be ruby. Both are showing right in the production environment.

The view 'Badges (test)/Badges stats' shows three kind of badges: Total credit level badges, sub-project badges and RAC badges.
As the last category mostly shows the exact same badges for each project having them and are just temporary they might as well be left out, according to me.
For the other two categories the same amount of credit is displayed for all badges belonging to one project. This is strange, because there are columns 'next badge' and 'credit needed' which are meaningless when you give the same credit for each entry, while the correct level is available at FreeDC and shown at 'Subproject credits/Usersubprojects Stats'.
The 'credit needed' column has green 'v' images where a numeric value should be [Two values showing right though: Rakesearch total credit and MM badge]. 'Next badge' should have those images, but has no entries of any kind.

MarkRBright

11-08-2020, 04:03 AM

I was referring specifically to Nebbers, which is what this thread is about. It think it might be more productive for you to raise this as a new thread, especially as this one isn't quite finished yet. Cheers.

MarkRBright

11-18-2020, 03:38 AM

Thanks again and I look forward to you working out how to include SubProjects one of these days.
Any joy on that yet. My vision for a truly great Megamilestone feels a little incomplete 😎🤣😂

Werinbert

11-18-2020, 07:31 PM

Now I have been infested with Nebbers....do I need to call the exterminator or the Ghost Busters?

Still not as bad as the Gibsons...where I am ranked 5 for the project but still it is not enough for a Maxwell.

MarkRBright

11-18-2020, 08:13 PM

Still not as bad as the Gibsons...where I am ranked 5 for the project but still it is not enough for a Maxwell.
LOL I am in 3rd place for Gibsons with 6 and I still need 2 more for a Maxwell. Some MM's are a little easier than others. :D

Bok

11-19-2020, 09:16 AM

Any joy on that yet. My vision for a truly great Megamilestone feels a little incomplete 😎🤣😂

I've not had a chance to go back and look yet.