Witam
Ostatnio szukam osoby która pomoże mi przepisać mój skript używając dodatku skript-db
oto mój skript:
script options:
$ init com.mysql.jdbc.Driver
$ db url jdbc:mysql://local:3306/base
$ db username ***
$ db password ***
options:
table_prefix: staty_
On script load:
update "CREATE TABLE IF NOT EXISTS `{@table_prefix}Player` (`Gracz` varchar(255),`Zabojstwa` varchar(255),`Zgony` varchar(255),`Poziom RPG` varchar(255),`Progres RPG` varchar(255),`Klasa` varchar(255),`Poziom Klasy` varchar(255),`Ranga` varchar(255))"
on join:
if {zgony.ilosc::%player%} is not set:
set {zgony.ilosc::%player%} to 0
set {zabojstwa.ilosc::%player%} to 0
update "INSERT INTO `{@table_prefix}Player` (`Gracz`, `Zabojstwa`, `Zgony`, `Poziom RPG`, `Progres RPG`, `Klasa`, `Poziom Klasy`, `Ranga`, `Kiedy Dolaczyl`) VALUES ('%player%', '0', '0', '0', '0', '0', '0', '%coloured player's prefix%')"
every 5 second:
loop all players:
update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Poziom RPG` = '%{poziom::%loop-player%}%' WHERE `{@table_prefix}Player`.`Gracz` = '%loop-player%'"
update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Klasa` = '%{RPGSkript.klasachat.%loop-player%}%' WHERE `{@table_prefix}Player`.`Gracz` = '%loop-player%'"
update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Poziom Klasy` = '%{Klasa.vip.Exp.%loop-player%}%' WHERE `{@table_prefix}Player`.`Gracz` = '%loop-player%'"
update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Progres RPG` = '%{xp::%loop-player%}%/%{mxp::%loop-player%}%' WHERE `{@table_prefix}Player`.`Gracz` = '%loop-player%'"
update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Zabojstwa` = '%{zabojstwa.ilosc::%loop-player%}%' WHERE `{@table_prefix}Player`.`Gracz` = '%loop-player%'"
update "UPDATE `{@table_prefix}Player` SET `{@table_prefix}Player`.`Zgony` = '%{zgony.ilosc::%loop-player%}%' WHERE `{@table_prefix}Player`.`Gracz` = '%loop-player%'"