SonicSpot Rankings

So is this just for Generations or do the classics get some respect too?demoman_chaos

And how would we do proof for the cIassic games?Cloud_765

[QUOTE="demoman_chaos"]So is this just for Generations or do the classics get some respect too?sonicphc

*sigh* Well, submitted my times for all levels up to Planet Wisp Act 1. None of my times are anything special, though. I just submitted mine so the rankings felt more full.

I hope there's a form for Sonic Colors soon. I'd make it myself but my head was throbbing in pain figuring out how to the hell to make it work myself and I pretty much gave up. I'll continue to try and make the Colors Wii one though, so we have it.

*sigh* Well, submitted my times for all levels up to Planet Wisp Act 1. None of my times are anything special, though. I just submitted mine so the rankings felt more full.

I hope there's a form for Sonic Colors soon. I'd make it myself but my head was throbbing in pain figuring out how to the hell to make it work myself and I pretty much gave up. I'll continue to try and make the Colors Wii one though, so we have it.

Cloud_765

*sigh* Well, submitted my times for all levels up to Planet Wisp Act 1. None of my times are anything special, though. I just submitted mine so the rankings felt more full.

I hope there's a form for Sonic Colors soon. I'd make it myself but my head was throbbing in pain figuring out how to the hell to make it work myself and I pretty much gave up. I'll continue to try and make the Colors Wii one though, so we have it.

Cloud_765

[QUOTE="Cloud_765"]

*sigh* Well, submitted my times for all levels up to Planet Wisp Act 1. None of my times are anything special, though. I just submitted mine so the rankings felt more full.

I hope there's a form for Sonic Colors soon. I'd make it myself but my head was throbbing in pain figuring out how to the hell to make it work myself and I pretty much gave up. I'll continue to try and make the Colors Wii one though, so we have it.

sonicphc

[QUOTE="Cloud_765"]

*sigh* Well, submitted my times for all levels up to Planet Wisp Act 1. None of my times are anything special, though. I just submitted mine so the rankings felt more full.

I hope there's a form for Sonic Colors soon. I'd make it myself but my head was throbbing in pain figuring out how to the hell to make it work myself and I pretty much gave up. I'll continue to try and make the Colors Wii one though, so we have it.

SuperSmashBro1

Ah well alright. Good thing, I'd have no idea how all the submitted data gets turned into the spreadsheet at the end. XD Cloud_765

Like this: (replace (lt) and (gt) with less than and greater than signs... stupid HTML rules)

var submissionSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var configSheet = submissionSpreadsheet.getSheetByName("Configuration");
var submissionSheet = submissionSpreadsheet.getSheetByName("Ranking Submissions");
var processedRow = 2;
var processedCol = 2;

var rankingSpreadsheet = SpreadsheetApp.openById("0Ajmx6NrUBIJrdGlZVjRrMDdUTHBFeGd0ZE1tTHMzZ1E");

function updateRankings() {
  var lastSubmission = submissionSheet.getLastRow();
  var lastProcessed = configSheet.getRange(processedRow, processedCol).getValue();
  var newSubmissions = lastSubmission - lastProcessed;
 
  if (newSubmissions == 0) {
    return;
  }
 
  for (var i = 1; i (lt)= newSubmissions; i++) {
    updateRanking(lastProcessed + i);
  }
 
  configSheet.getRange(processedRow, processedCol).setValue(lastSubmission);
}

function updateRanking(rowNum) {
  if (rowNum === undefined) {
    rowNum = SpreadsheetApp.getActiveRange().getRow();
  }
 
  var ranking = getRanking_(rowNum);
  try {
    var gameSheet = rankingSpreadsheet.getSheetByName(ranking.game);
    var stageColumn = findStage_(gameSheet, ranking.stage + (ranking.act ? " " + ranking.act : ""));
    var validation = gameSheet.getRange(3, 1).getValue();
   
    if (validation) {
      ranking.valid = new RegExp(validation).test(ranking.value);
    }
   
    var sortAsc = gameSheet.getRange(7,1).getValue() == "Ascending";
    var existingCount = eval(gameSheet.getRange(1, stageColumn + 1).getValue());
    var existingUsers = eval(gameSheet.getRange(1, stageColumn + 2).getValue());
    var existingRow = existingUsers.indexOf(ranking.username) + 4;
    var newRow = existingCount + 4;
   
    if (existingRow (gt) 3) {
      if (!shouldReplace_(stageColumn, existingRow, gameSheet, ranking, sortAsc)) {
        submissionSheet.getRange(rowNum, 7).setValue("IGNORED");
        return;
      }
     
      newRow = existingRow;
    }
    else {
      existingCount++;
    }
   
    var newVals = [ranking.valid ? "" : "???", ranking.username, ranking.value];
    gameSheet.getRange(newRow, stageColumn, 1, 3).setValues([newVals]).setFontColor(ranking.valid ? 'black' : 'red');
    gameSheet.getRange(newRow, stageColumn + 2).setComment(ranking.proof);
    gameSheet.getRange(4, stageColumn, existingCount, 3).sort({column: stageColumn + 2, ascending: sortAsc});
   
    var rank = 1;
    var rankArray = [];
    for (var i = 0; i (lt) existingCount; i++) {
      var range = gameSheet.getRange(i + 4, stageColumn);
      if (range.getValue() != "???") {
        range.setValue(rank++);
      }
      rankArray.push(range.offset(0, 1).getValue());
    }
   
    gameSheet.getRange(1, stageColumn + 1).setValue(existingCount);
   
    var rankArrayString = "[";
    for (var i = 0; i (lt) rankArray.length; i++) {
      if (i != 0) {
        rankArrayString += ",";
      }
      rankArrayString += "\"" + rankArray + "\"";
    }
    rankArrayString += "]";
   
    gameSheet.getRange(1, stageColumn + 2).setValue(rankArrayString);
  } catch (e) {
    submissionSheet.getRange(rowNum, 7).setValue("REJECTED");
    submissionSheet.getRange(rowNum, 8).setValue(e);
    return;
  }
 
  submissionSheet.getRange(rowNum, 7).setValue(ranking.valid ? "COMMITTED" : "VALIDATION");
}

function getRanking_(rowNum) {
  var data = submissionSheet.getRange(rowNum, 1, 1, 6).getValues()[0];
  return {
    username: data[0],
    game: data[1],
    stage: data[2],
    act: data[3],
    value: data[4],
    proof: data[5],
    valid: true
  }
}

var stageCache = {};

function findStage_(gameSheet, stageName) {
  if (stageCache[stageName]) {
    return stageCache[stageName];
  }
 
  var lastColumn = gameSheet.getLastColumn();
  for (var i = 2; i (lt) lastColumn; i += 3) {
    if (gameSheet.getRange(2, i).getValue() === stageName) {
      stageCache[stageName] = i;
      return i;
    }
  }
 
  throw "Cannot find act " + stageName;
}

function shouldReplace_(stageColumn, existingRowNum, gameSheet, ranking, sortAsc) {
  if (gameSheet.getRange(existingRowNum, stageColumn).getValue() === "???" && ranking.valid) {
    return true;
  }
 
  if (!(gameSheet.getRange(existingRowNum, stageColumn + 2).getComment()) && ranking.proof) {
    return true;
  }
 
  var oldValue = gameSheet.getRange(existingRowNum, stageColumn + 2).getValue();
  return ranking.value == oldValue || ((ranking.value (lt) oldValue) == sortAsc);
}

You do know that I have no idea what any of that means, right?Cloud_765

Heh. I just copy pasted the code from the docs code project :)

We really need moar submissions here, don't we? At least don't let this go the same way as the Challenges...srbrans

I need some kind of incentive to go back and improve your time once somebody beat you (other than "look I'm winning"). Also, I need to fix these last two bugs and then send out a PM announcing this to the entire union, not just the forum browsers. That should, hopefully, increase the pool of data.