script options:
    $ init com.mysql.jdbc.Driver
    $ db url jdbc:mysql://localhost:3306/pokemaster
    $ db username root
    $ db password haselko


#CRON



#funkcje
function "isProfileExist": #sprawdza czy dany profil istnieje zwracając po prostu... jego nick.
	$ access
	set {_checkoutput} to the first element out of objects in column "nick" from result of query "SELECT nick FROM odznaki WHERE nick = '%{_checkuser}%'" and close
	return

function "generateProfile": #generowanie profilu - czyli chujowa obsługa MySql z skQuery :(
	$ access
	set {odznakaFire.%{_generateuser}%} to the first element out of objects in column "fire" from result of query "SELECT fire FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaWater.%{_generateuser}%} to the first element out of objects in column "water" from result of query "SELECT water FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaGrass.%{_generateuser}%} to the first element out of objects in column "grass" from result of query "SELECT grass FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaRock.%{_generateuser}%} to the first element out of objects in column "rock" from result of query "SELECT rock FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaElectric.%{_generateuser}%} to the first element out of objects in column "electric" from result of query "SELECT electric FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaRandom.%{_generateuser}%} to the first element out of objects in column "random" from result of query "SELECT random FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaPsychic.%{_generateuser}%} to the first element out of objects in column "psychic" from result of query "SELECT psychic FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaPoison.%{_generateuser}%} to the first element out of objects in column "poison" from result of query "SELECT poison FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	$ access
	set {odznakaGround.%{_generateuser}%} to the first element out of objects in column "ground" from result of query "SELECT ground FROM odznaki WHERE nick = '%{_generateuser}%'" and close
	wait 1 tick
	$ access
	set {generujprofil::%{_generateuser}%} to false
	wait 1 tick # wyłącza generowanie profilu
	return



on load:
	broadcast "&3&lLaczenie z serwerem uslugi PokeMaster..."

#komendy debuggingowe/administratorskie

command /resetujgenerowanie [<player>]:
	description: wymusza generowanie profilu przy nastepnym jego wczytaniu
	permission: pokemaster.admin.debug
	trigger:
		if argument 1 is not set:
			clear {generujprofil::%sender%}
			send "%{generujprofil::%sender%}%"
			send "&4Mozesz wygenerowac profil na nowa komenda /profil"

#komendy zarzadzania/administratorskie

command /ustawleadera <text> <player>:
	description: ustawia leadera sali
	permission: pokemaster.admin.leader
	trigger:
		if argument 1 is not "Fire" or "Water" or "Psychic":
			send "Niepoprawny Leader"
		else:
			if {leader.%argument 2%} is set:
				send "&4Ten gracz jest juz leaderem &2%{leader.%argument 2%}%"
				send "&4Aby ustawic go jako leadera innej sali najpierw uzyj /usunleadera"
			else:
				set {leader.%argument 2%} to argument 1
				if argument 1 is "fire": #rozwiazanie tymczasowe, nie funkcja. Kapitalizacja w zadnym z dodatkow nie dziala.
					set {leaderfire} to argument 2
				if argument 1 is "water":
					set {leaderwater} to argument 2
				if argument 1 is "stone":
					set {leaderstone} to argument 2
				if argument 1 is "grass":
					set {leadergrass} to argument 2
				if argument 1 is "poison":
					set {leaderpoison} to argument 2
				if argument 1 is "psychic":
					set {leaderpsychic} to argument 2
				if argument 1 is "rock":
					set {leaderrock} to argument 2
				if argument 1 is "random":
					set {leaderrandom} to argument 2
				send "Ustawiono gracza %argument 2% na leadera %argument 1%"
				broadcast "&3&lGracz &2%argument 2% &3jest teraz leaderem sali &2%argument 1%"




#komendy gracza

command /wyzwij <nick>
	description: wyzwij leadera
	uage: /wyzwij [nick] na leaderze
	executable by: players
	trigger:


command /bazadanych <text>:
	description: test polaczenia z baza
	usage: /bazadanych
	executable by: players
	trigger:
		broadcast "&3Dodawanieee rekordu..."
		update "INSERT INTO `odznaki`(`nick`, ` `, `water`, `grass`) VALUES (""%argument 1%"",""1"",""1"",""1"")"
		broadcast "&3Zakonczono."

command /profil [<player>]:
	description: Wyswietla Twoj profil gracza
	trigger:
		if argument 1 is not set:
			set {_checkuser} to name of sender
			access "isProfileExist"
			if {_checkoutput} is equal to name of sender:
				send "&6Znaleziono Profil!"
			else:
				send "&6Tworzenie profilu..."
				set {generujprofil::%player%} to true
				update "INSERT INTO `odznaki`(`nick`) VALUES (""%name of sender%"")"
				send "&6Profil utworzony!"
			if {generujprofil::%player%} is set:
				send "Odczytano Twoj profil trenera z pamieci lokalnej"
			else:
				send "Odczytywanie profilu..."
				set {_generateuser} to name of sender
				access "generateProfile"
				wait 2 ticks
				send "Odczytano Twoj profil trenera z bazy danych"
			send "&3===========" #Wyswietlanie profilu, do aktualizacji skQuery bez funkcji, poniewaz wywolywala bledy
			if {odznakaFire.%sender%} is true: #fire
				send "&5Odznaka Fire: &2Posiadasz"
			else:
				send "&5Odznaka Fire: &4Nie Posiadasz"
			if {odznakaWater.%sender%} is true: #water
				send "&5Odznaka Water: &2Posiadasz"
			else:
				send "&5Odznaka Water: &4Nie Posiadasz"
			if {odznakaGrass.%sender%} is true: #grass
				send "&5Odznaka Grass: &2Posiadasz"
			else:
				send "&5Odznaka Grass: &4Nie Posiadasz"
			if {odznakaGround.%sender%} is true: #ground
				send "&5Odznaka Ground: &2Posiadasz"
			else:
				send "&5Odznaka Ground: &4Nie Posiadasz"
			if {odznakaPoison.%sender%} is true: #poison
				send "&5Odznaka Poison: &2Posiadasz"
			else:
				send "&5Odznaka Poison: &4Nie Posiadasz"
			if {odznakaPsychic.%sender%} is true: #psychic
				send "&5Odznaka Psychic: &2Posiadasz"
			else:
				send "&5Odznaka Psychic: &4Nie Posiadasz"
			if {odznakaRock.%sender%} is true: #rock
				send "&5Odznaka Rock: &2Posiadasz"
			else:
				send "&5Odznaka Rock: &4Nie Posiadasz"
			if {odznakaElectric.%sender%} is true: #electric
				send "&5Odznaka Electric: &2Posiadasz"
			else:
				send "&5Odznaka Electric: &4Nie Posiadasz"
			if {odznakaRandom.%sender%} is true: #random
				send "&5Odznaka Random: &2Posiadasz"
			else:
				send "&5Odznaka Random: &4Nie Posiadasz"
			send "&3Pelny Profil:"
			send "&r&npokeblock.pl/pokemaster/trener.php?user=%sender%" #koniec profilu




		#set {_variable} to the first element out of objects in column "fire" from result of query "SELECT fire FROM odznaki WHERE nick = '%argument 1%'" and close
		#broadcast "%{_variable}%"