Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var serverlist_sheet = ss.getSheetByName('Player List')
- var real_array = [[7, 8, 9], [13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42], [46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75], [79]]
- //var player_name_roster = [7, 8, 9, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 79, 80, 81, 82, 83]
- var days_array = [12, 6, 7, 8, 9, 10, 11];
- var add_minutes = function(dt, minutes) {
- try{
- return new Date(dt.getTime() + minutes * 60000);
- }
- catch(err){
- return new Date()
- }
- }
- function checkLOAs() {
- for (var l = 0 ; l <= real_array.length - 1 ; l++){
- var date = new Date()
- var sheet = ss.getSheetByName("Personnel Roster")
- var range = sheet.getRange(real_array[l][0], 3, real_array[l][real_array[l].length - 1] - real_array[l][0] + 1, 2)
- Logger.log(range)
- var values = range.getValues()
- Logger.log(values)
- for (var i = 0; i <= real_array[l].length - 1; i++) {
- Logger.log(values[i])
- Logger.log(i)
- var dateToCheck = values[i][1]
- if (dateToCheck <= date && typeof dateToCheck != "string") {
- Logger.log(sheet.getRange(real_array[l][i], 4).getValue())
- sheet.getRange(real_array[l][i], 4).setValue("")
- }
- }
- }
- }
- function getData() {
- var queryString = Math.random();
- var sheet = ss.getSheetByName("Player List")
- var cellFunction1 = '=CLEAN(IMPORTXML("' + serverlist_sheet.getRange('B1').getValue() + '?' + queryString + '","' + serverlist_sheet.getRange('B2').getValue() + '"))';
- serverlist_sheet.getRange('C1').setValue(cellFunction1);
- }
- function checkplayer() {
- for (var l = 0 ; l <= real_array.length - 1 ; l++){
- var rank_sheet = ss.getSheetByName("Activity Manager");
- var playersheet = ss.getSheetByName("Player List");
- var day = days_array[new Date().getDay()]
- var onlinerange = playersheet.getRange(2, 3, 128)
- var onlineValues = onlinerange.getValues()
- var range = rank_sheet.getRange(real_array[l][0] - 1, 5, real_array[l][real_array[l].length - 1] - real_array[l][0] + 1)
- var values = range.getValues()
- Logger.log(values)
- for (var i = 0; i <= onlineValues.length - 1; i++) {
- var steamIDToTest = onlineValues[i][0]
- if (steamIDToTest == "") {
- continue
- }
- for (var j = 0; j <= real_array[l].length - 1; j++) {
- var steamID = values[j][0]
- Logger.log(steamID)
- if (steamID == "") {
- continue
- } else if (steamIDToTest == steamID) {
- Logger.log(real_array[l][j] - 1)
- var timeToEdit = rank_sheet.getRange(real_array[l][j] - 1, day)
- // Logger.log(steamIDToTest)
- // Logger.log(real_array[l][j])
- var time = timeToEdit.getValue()
- timeToEdit.setValue(add_minutes(time, 5))
- }
- }}
- }
- }
- function resetTime() {
- var sheet = ss.getSheetByName("Activity Manager")
- real_array.forEach(function(rangeToReset){
- sheet.getRange(rangeToReset[0] - 1, 6, rangeToReset.length, 7).setValue("00:00")
- })
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement