var ss = SpreadsheetApp.getActiveSpreadsheet();
var serverlist_sheet = ss.getSheets()[N]
var player_name_array = [7,15,20,32,40,58,64]; // This is the only thing that is manual,
// Get data is what updates the server and gets the player list
function getData() {
  var queryString = Math.random();
  var sheet = ss.getSheets()[N]

  var cellFunction1 = '=IMPORTXML("' + serverlist_sheet.getRange('A1').getValue() + '?' + queryString + '","'+ serverlist_sheet.getRange('A2').getValue() + '")';
  serverlist_sheet.getRange('C1').setValue(cellFunction1);

  var cellFunction2 = '=IMPORTXML("' + serverlist_sheet.getRange('E1').getValue() + '?' + queryString + '","'+ serverlist_sheet.getRange('E2').getValue() + '")';
  serverlist_sheet.getRange('G1').setValue(cellFunction2);
}

// Check player checks if the player
function checkplayer() {
 var rank_sheet = ss.getSheets()[H];
 var playersheet = ss.getSheets()[N];
  for(var i = 2; i < 101 ; i++) {
    if(playersheet.getRange(i,3).getValue() == "") {
    }
    else {
      for(var p = 0; p < player_name_array.length; p++) {
     var player = rank_sheet.getRange(i,6);
        if (rank_sheet.getRange(player_name_array[p],2).getValue() == playersheet.getRange(i,3).getValue()) {
           rank_sheet.getRange(player_name_array[p],6).setValue("0")}

    }
  }
}
}

function updateplayer() {
  var rank_sheet = ss.getSheets()[H];
  for(var i = 0; i < player_name_array.length; i++) {
    var player_days = rank_sheet.getRange(player_name_array,6);
    player_days.setValue(player_days.getValue()+1)}
    }