event-player doesn't work #17

New Issue

2022-04-16T22:39:05Z

hiayaff commented

2022-04-16 22:39:05 +00:00

event-player returns none but when I enter the player's nickname normally, it works.

code that doesn't work:
on region enter:
if "%region%" contains "crab":
execute "SELECT * FROM test WHERE username= '%event-player%'" in {-sql} and store the result in {_output::*}
send "%{_output::username::1}%"

code that works:
on region enter:
if "%region%" contains "crab":
execute "SELECT * FROM test WHERE username= 'hiayaf'" in {-sql} and store the result in {_output::*}
send "%{_output::username::1}%"
probably the same with other expressions...

event-player returns none but when I enter the player's nickname normally, it works. code that doesn't work: on region enter: if "%region%" contains "crab": execute "SELECT * FROM `test` WHERE username= '**%event-player%**'" in {-sql} and store the result in {_output::*} send "%{_output::username::1}%" code that works: on region enter: if "%region%" contains "crab": execute "SELECT * FROM `test` WHERE username= '**hiayaf**'" in {-sql} and store the result in {_output::*} send "%{_output::username::1}%" probably the same with other expressions...

hiayaff commented

2022-04-16 22:49:00 +00:00

![image](/attachments/a4b7e9fd-f07d-4ff2-af9f-5339a51e87ba)

image.png

5.4 KiB

Govindas commented

2022-04-17 09:07:35 +00:00

player object is not serializable, you will need to use %player's name%

Govindas closed this issue

2022-04-17 09:07:45 +00:00

hiayaff commented

2022-04-17 10:25:51 +00:00

ok but if I give such a thing it does not work
execute "UPDATE test SET discoverisle=%{test::%player%}% WHERE username= '%name of player%'" in {-sql}

but when I give something like this it works
execute "UPDATE test SET discoverisle=%{test::%player%}% WHERE username= 'hiayaf'" in {-sql}

ok but if I give such a thing it does not work execute "UPDATE `test` SET `discoverisle`=%{test::%player%}% WHERE username= '%name of player%'" in {-sql} but when I give something like this it works execute "UPDATE `test` SET `discoverisle`=%{test::%player%}% WHERE username= 'hiayaf'" in {-sql}

hiayaff reopened this issue

2022-04-17 12:35:16 +00:00

Govindas commented

2022-04-17 13:00:10 +00:00

try removing ' ' around the expression