on load:
	send "[Statystyki] Trwa proba polaczenia z serwerem bazodanowym MySQL..." to console
	set {_TIME.1} to unix timestamp of now          #current system milliseconds
	execute "SELECT version()" in {STATYSTYKI.SQL} and store the result in {_TMP::*}
	set {_TIME.2} to unix timestamp of now          #current system milliseconds
	set {_LOAD.TIME} to {_TIME.2} - {_TIME.1}
	if last database error is not set:
		send "[Statystyki] Proba polaczenia z serwerem bazy danych przebiegla pomyslnie." to console
		if {STATYSTYKI.SQL.RUN} is set:
			clear {STATYSTYKI.SQL.RUN}
			send "[Statystyki] Topka jest juz aktualizowana." to console
	else:
		send "[Statystyki] Napotkano na problemy podczas proby polaczenia z serwerem bazy danych." to console
		send "[Statystyki] Napotkany problem: %last database error%." to console
		send "[Statystyki] Topka nie bedzie juz aktualizowana." to console
		send "[Statystyki] Polaczenie MYSQL zawiodlo, posimy powiadomic Wlasciciela." to all ops
		set {STATYSTYKI.SQL.RUN} to 1
	send "[Statystyki] Czas proby polaczenia: %{_LOAD.TIME}%ms." to console
	send "[Statystyki] Czas proby polaczenia: %{_LOAD.TIME}%ms." to "szumielxd_" parsed as player

function UPDATE():
	if {STATYSTYKI.SQL.RUN} is set:
		send "[Statystyki] Tablica TOP graczy nie zostala zaaktualizowana." to console
		stop
	loop 10 times:
		execute "SELECT PLAYER_NAME FROM `tbl_options_players_stats` WHERE STAT_TYPE='KILLS' ORDER BY `tbl_options_players_stats`.`QUANTITY` DESC LIMIT 1 OFFSET %loop-number - 1%" in {STATYSTYKI.SQL} and store the result in {_TMP0::%loop-number%::*}
		set {_STATYSTYKI::%loop-number%} to {_TMP0::%loop-number%::PLAYER_NAME::1}
		execute "SELECT UNIQUEID FROM tbl_options_players_stats WHERE PLAYER_NAME=%{_STATYSTYKI::%loop-number%}%" in {STATYSTYKI.SQL} and store the result in {_TMP1::%loop-number%::*}
		set {_UNIQUEID::%loop-number%} to {_TMP1::%loop-number%::UNIQUEID::1}
		execute "SELECT QUANTITY FROM tbl_options_players_stats WHERE UNIQUEID=%{_UNIQUEID::%loop-number%}%" in {STATYSTYKI.SQL} and store the result in {_TMP2::%loop-number%::*}
		execute "SELECT STAT_TYPE FROM tbl_options_players_stats WHERE UNIQUEID=%{_UNIQUEID::%loop-number%}%" in {STATYSTYKI.SQL} and store the result in {_TMP2::%loop-number%::*}
		set {_i} to 0
		loop {_TMP2::%loop-number%::STAT_TYPE::*}:
			add 1 to {_i}
			if loop-value-2 is "KILLS":
				set {_STATYSTYKI1::%loop-number%} to {_TMP2::%loop-number%::QUANTITY::%{_i}%}
			else if loop-value-2 is "DEATHS":
				set {_STATYSTYKI2::%loop-number%} to {_TMP2::%loop-number%::QUANTITY::%{_i}%}
			else if loop-value-2 is "DANAGE_NEXUSES":
				set {_STATYSTYKI3::%loop-number%} to {_TMP2::%loop-number%::QUANTITY::%{_i}%}
			else if loop-value-2 is "WINS":
				set {_STATYSTYKI4::%loop-number%} to {_TMP2::%loop-number%::QUANTITY::%{_i}%}
		if {_STATYSTYKI::%loop-number%} is not set:
			execute console command "npc select %26 + loop-number%"
			execute console command "npc rename &c&lBRAK GRACZA"
		else:
			execute console command "npc select %26 + loop-number%"
			execute console command "npc rename &6%{_STATYSTYKI::%loop-number%}%"
		if {_STATYSTYKI1::%loop-number%} is not set:
			execute console command "/hd setline top%loop-number% 2 &7&l» &eIlosc zabojstw: &c&lBRAK DANYCH"
		else:
			execute console command "/hd setline top%loop-number% 2 &7&l» &eIlosc zabojstw: &a&l%{_STATYSTYKI1::%loop-number%}%"
		if {_STATYSTYKI2::%loop-number%} is not set:
			execute console command "/hd setline top%loop-number% 3 &7&l» &eIlosc zgonow: &c&lBRAK DANYCH"
		else:
			execute console command "/hd setline top%loop-number% 3 &7&l» &eIlosc zgonow: &a&l%{_STATYSTYKI2::%loop-number%}%"
		if {_STATYSTYKI3::%loop-number%} is not set:
			execute console command "/hd setline top%loop-number% 4 &7&l» &eZniszczone kamienie dusz: &c&lBRAK DANYCH"
		else:
			execute console command "/hd setline top%loop-number% 4 &7&l» &eZniszczone kamienie dusz: &a&l%{_STATYSTYKI3::%loop-number%}%"
		if {_STATYSTYKI4::%loop-number%} is not set:
			execute console command "/hd setline top%loop-number% 5 &7&l» &eWygrane gry: &c&lBRAK DANYCH"
		else:
			execute console command "/hd setline top%loop-number% 5 &7&l» &eWygrane gry: &a&l%{_STATYSTYKI4::%loop-number%}%"

every 1500 seconds:
	UPDATE()

command /topupdate [<text>]:
	permission: pomocnik+
	permission message: [Statystyki] Nie posiadasz dostepu.
	trigger:
		send "[Statystyki] Zapytanie do serwera bazodanowego MYSQL zostalo wyslane!"
		UPDATE()