Hi, when someone connect the skript dont insert nothing in database but if i replace %player% and %ip of player% to any text this works.
Why?
Why?
Code:
on load:
set {sql} to the database "mysql://<ip>:3306/<database>?user=<user>&password=<password>useSSL=false"
execute "CREATE TABLE IF NOT EXISTS `joinIPs` (`id` INT AUTO_INCREMENT PRIMARY KEY, `username` TEXT, `ip` TEXT, `hora` TIMESTAMP DEFAULT CURRENT_TIMESTAMP)" in {sql}
on connect:
execute "INSERT INTO `joinIPs` (`username`, `ip`) VALUES (%player%, %ip of player%)" in {sql}