MysQl 2

[Thraenkost]

Arkadaşlar biz şimdi bi siteden {_kredi} yapcaz. Ama onu siteden alcaz. Onun bilgisini siteden nasıl alabilirim ?

Yaptığımız Kod (Çalışmayan)

script options:
    $ init com.mysql.jdbc.Driver
    $ db url jdbc:host
    $ db username username
    $ db password password
command /mysql:
        trigger:
            send "&7Your Uuid Code: &6%uuid of player%"
            set {_kredi} to the first element out of objects in column "kredi" from result of query "SELECT `column` FROM `table` WHERE `column1` = ""%player%""" and close
            add objects in column "kredi" from result of query "SELECT `column` FROM `table` WHERE `column1` = ""%player%""" and close to {_column::*}
            send "%{_kredi}%"

command /kredim:
    trigger:
        update "INSERT INTO playerinfo (kredi) VALUES (100)"
        set {_uuid} to "%uuid of player%"
        set {_kredi} to index 1 of objects in column "kredi" from result of query "select kredi from playerinfo where uuid='%{_uuid}%'"
        send "&b%{_uuid}%"
        send "&8[&bKredi&8] &7Krediniz: %{_kredi}%"
        
join:
    wait a second
    update "INSERT INTO playerinfo (kredi) VALUES (100)"
    set {_uuid} to "%uuid of player%"
    set {_kredi} to index 1 of objects in column "kredi" from result of query "select kredi from playerinfo where uuid='%{_uuid}%'"
    send "&b%{_uuid}%"
    send "&8[&bKredi&8] &7Krediniz: %{_kredi}%"