FernandoBontorin

from pyspark.sql.functions import col, when, lit, last_day, add_months

def retro_add_months(date, months):
    """
    Adds 'months' to the given 'date', but if the resulting date is not the last day of the month,
    as well the given date, it returns the last day of the resulting month of added months.
    """
    return when(last_day(date) != date, add_months(date, months)).otherwise(last_day(add_months(date, months)))

FernandoBontorin

// made by Costache Madalin (lllll llll)
// discord: costache madalin#8472



let url=window.location.href
var countApiKey = "support_sender";
var countNameSpace="madalinoTribalWarsScripts"

FernandoBontorin

javascript: selectTarget(444, 369, ''); let reserve_of_resources = Number(document.getElementById("storage").innerHTML)/9; let max_resources_send = Number(document.getElementById("market_merchant_max_transport").innerHTML); let wood = Number(document.getElementById("wood").innerHTML); let stone = Number(document.getElementById("stone").innerHTML); let iron = Number(document.getElementById("iron").innerHTML); let total = wood + stone + iron; document.getElementsByName("wood")[0].value = Math.max(0, Math.min(wood-reserve_of_resources, (wood/total*max_resources_send))); document.getElementsByName("stone")[0].value = Math.max(0, Math.min(stone-reserve_of_resources, (stone/total*max_resources_send))); document.getElementsByName("iron")[0].value = Math.max(0, Math.min(iron-reserve_of_resources, (iron/total*max_resources_send))); document.getElementsByClassName("btn")[0].click();

FernandoBontorin

javascript:$.getScript('https://media.innogamescdn.com/com_DS_BR/Scripts/Aprovados/AutoNotesFromReports.js');

FernandoBontorin

javascript: document.getElementsByClassName("btn_next_in_queue btn_next_in_queue_trigger")[0].click()

FernandoBontorin

javascript: var time = 0; function exec(e){time += 250; setTimeout(()=>{e.click()}, time)}; Array.from(document.getElementsByClassName("farm_icon_b")).forEach(x=>exec(x));

FernandoBontorin

function snip(dateISOformat, diff=0){
	var target = new Date(dateISOformat).getTime();
	var duration = document.getElementById("date_arrival").firstElementChild.getAttribute("data-duration")*1000;
	var send = target-duration;
	var timeout = send-new Date().getTime()-18000;
	setTimeout(()=>{document.getElementById("troop_confirm_submit").click()}, timeout+diff);
	console.log(new Date(timeout).toUTCString().slice(-11, -4));
};snip("2023-04-08T09:26:30.100-03:00", -34219)

FernandoBontorin

FernandoBontorin

import org.apache.spark.sql.functions.{col, max}
import org.apache.spark.sql.{DataFrame, Row}

import scala.reflect.ClassTag

object SparkUtils {
  def hasNull(df: DataFrame, cols: String*): Boolean = {
    hasNull(asArrayOf[Boolean](isNull(df, cols: _*).collect))
  }