Variable in UPDATE #4

New Issue

2021-04-05T01:20:53Z

Envqu commented

2021-04-05 01:20:53 +00:00

(Migrated from github.com)

Hi.
Why Variables in Update not working?

It works:

execute "UPDATE stats SET level = %{_level}%, xp = %{_xp}% WHERE nick = 'Player123'" in {sql}

But not this:
execute "UPDATE stats SET level = %{_level}%, xp = %{_xp}% WHERE nick = %player's nickname%" in {sql}

I also tried:

set {_p} to player's nickname
and WHERE nick = %{_p}%" in {sql}

%player% gives error: "Parameter cannot be serialized: org.bukkit.craftbukkit.v1_16_R3.entity.CraftPlayer

WHERE nick = '%{_p}%'" in {sql} gives error: Could not set parameter at position 3 (values was 'Player123')

Hi. Why Variables in Update not working? It works: execute "UPDATE `stats` SET `level` = %{_level}%, xp = %{_xp}% WHERE `nick` = 'Player123'" in {sql} But not this: execute "UPDATE `stats` SET `level` = %{_level}%, xp = %{_xp}% WHERE `nick` = %player's nickname%" in {sql} I also tried: set {_p} to player's nickname and WHERE `nick` = %{_p}%" in {sql} %player% gives error: "Parameter cannot be serialized: org.bukkit.craftbukkit.v1_16_R3.entity.CraftPlayer WHERE `nick` = '%{_p}%'" in {sql} gives error: Could not set parameter at position 3 (values was 'Player123')

GovindasOM commented

2021-04-05 08:17:42 +00:00

(Migrated from github.com)

try name of player

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Limework/skript-db#4