help with skript db | skUnity | Page 1

deep depot May 23, 2024, 6:24 PM

#

what version of skript-db are you using

#

skript-db version?

#

on join:
    execute "INSERT INTO Users (uuid,name,lastjoin) VALUES (%uuid of player%,%name of player%,%rounded unix timestamp of now%) ON DUPLICATE KEY UPDATE name=VALUES(name),lastjoin=VALUES(lastjoin)" in {-sql}

#

this is how i did it to enter a new users details into a DB on join

#

not sure if that helps

#

edit that how you need and it should work

stark granite May 23, 2024, 6:29 PM

#

deep depot this is how i did it to enter a new users details into a DB on join

didn't ya take that from the skript-db whatever spigot thing

deep depot May 23, 2024, 6:30 PM

#

stark granite didn't ya take that from the skript-db whatever spigot thing

pretty much but it works and its what i needed for mine😂

stark granite May 23, 2024, 6:30 PM

#

LOL

deep depot May 23, 2024, 6:31 PM

#

stark granite LOL

can you help me at all on mine #1243262191700807822

#

i think it would be set {_value} to {_output::id::1}

stark granite May 23, 2024, 6:37 PM

#

wdym "still nothing"?

deep depot May 23, 2024, 6:39 PM

#

remove the unsafe part of the execute

#

you are using the right versions

#

which do not need it

#

i use the same ones

#

just remove the set {_value} to {_output::id::1}

#

and do this

#

send "Mentionable setting value: %{_output::value::1}%" to player

mystic estuary May 23, 2024, 6:41 PM

#

let me try that

deep depot May 23, 2024, 6:42 PM

#

try that

#

because your column names are player_uuid, setting, value

#

arent they

#

so the table doesn't already exist?

#help with skript db