If you wish to attach one or more files enter the details below. You may also attach files by dragging and dropping them in the message box.
by ssorenn » Wed Aug 22, 2018 7:12 pm
ssorenn wrote: ↑Wed Aug 08, 2018 12:31 am RR should not be given to any new player till x amount of game have been finished by the player. Then the aggregate of his moves from the X amount of games is complied giving him a RR score. This stops newbs from joining games with RR requirement. Too many games, especially gunboat are ruined by new player who don’t know the ethics of finishing what they start. I think that was swordsmans point. Or part of it at least. I will say for the record that i committed these transgressions when i first joined. This was the first real competitive site i ever joined online. But as a new player, i thought”it’s just a stupid game, who cares”. Only later to figure out it really matters to a lot of people. So, having to earn a score may be better, and some type of testimonial when you join, explaining that these games take a long amounts time and people take them seriously. What the X number is , up for debate.
by CptMike » Fri Aug 10, 2018 5:50 am
by SuperSteve » Fri Aug 10, 2018 5:10 am
by bo_sox48 » Fri Aug 10, 2018 5:05 am
by jmo1121109 » Fri Aug 10, 2018 3:54 am
by Squigs44 » Fri Aug 10, 2018 3:51 am
by Squigs44 » Fri Aug 10, 2018 2:56 am
by jollycream » Thu Aug 09, 2018 9:27 pm
by Mercy » Thu Aug 09, 2018 5:52 am
jmo1121109 wrote: ↑Thu Aug 09, 2018 4:40 amNMR's are weighted to about 1/3 of a CD.
by jmo1121109 » Thu Aug 09, 2018 4:47 am
Nephthys wrote: ↑Wed Aug 08, 2018 8:29 am Surely at the very least this can be made public (as far as I know it isn't, may be wrong though)
by jmo1121109 » Thu Aug 09, 2018 4:40 am
Code: Select all
UPDATE wD_Users u SET u.cdCount = (SELECT COUNT(1) FROM wD_CivilDisorders c WHERE c.userID = u.id AND c.forcedByMod=0), u.nmrCount = (SELECT COUNT(1) FROM wD_NMRs n WHERE n.userID = u.id), u.gameCount = ( SELECT COUNT(1) FROM wD_Members m WHERE m.userID = u.id) + ( SELECT COUNT(1) FROM wD_CivilDisorders c LEFT JOIN wD_Members m ON c.gameID = m.gameID AND c.userID = m.userID AND c.countryID = m.countryID WHERE m.id IS NULL AND c.userID = u.id), u.cdTakenCount = ( SELECT COUNT(1) FROM wD_Members ct INNER JOIN wD_CivilDisorders c ON c.gameID = ct.gameID AND c.countryID = ct.countryID AND NOT c.userID = ct.userID WHERE ct.userID = u.id AND c.turn = ( SELECT MAX(sc.turn) FROM wD_CivilDisorders sc WHERE sc.gameID = c.gameID AND sc.countryID = c.countryID ) ), u.reliabilityRating = (POW( ( (100 * ( 1.0 - ((cast(u.cdCount as signed) + u.deletedCDs) / (u.gameCount+1)) )) + (100 * (1.0 - ((u.nmrCount)/(u.phaseCount+1)))) )/2 , 3)/10000)"
by PRINCE WILLIAM » Wed Aug 08, 2018 6:06 pm
by swordsman3003 » Wed Aug 08, 2018 6:01 pm
ChippeRock wrote: ↑Wed Aug 08, 2018 9:38 amI had 40 some CDs... And after playing 100+ games with a near perfect record I was only able to raise it 10 percentage points. I feel like you should be able to advance higher in RR quicker than this.
by Claesar » Wed Aug 08, 2018 4:28 pm
by Foxcastle » Wed Aug 08, 2018 3:25 pm
by ChippeRock » Wed Aug 08, 2018 9:38 am
swordsman3003 wrote: ↑Mon Aug 06, 2018 9:23 pm In my opinion, after multiple CDs, it make sense that you would have to establish yourself over many games before your rating would change. Even one CD can be a terrible experience for your fellow players. The passage of time does not establish that a player is reliable.
by Claesar » Wed Aug 08, 2018 9:19 am
Nephthys wrote: ↑Wed Aug 08, 2018 8:29 am ... 2) A more clear algorithm for RR. I have no clue what it takes for me to rise by a certain percentage. Surely at the very least this can be made public (as far as I know it isn't, may be wrong though)
by Nephthys » Wed Aug 08, 2018 8:29 am
by RoganJosh » Wed Aug 08, 2018 7:24 am
by RoganJosh » Wed Aug 08, 2018 7:21 am
Mercy wrote: ↑Wed Aug 08, 2018 4:43 am As I understand it, the discussion was about making RR a better indicator of someones true reliability.
Top