Mysql check

[helomi]

Hi, i try 2 hours create simple mysql row check, but dont work :/

I tried something like this:

Spoiler

On join:
   set {_check-%player%} to mysql result of query "SELECT Breaks_cobble FROM Stats_SB_Player WHERE 'Player' = '%player%'"
   if {_check-%player%} is not "%player%":
       ....

I need simple table check if player have row in table.

 

[ShaneBee]

function check(tbl: text, c: text, w: text) :: boolean:
     set {_result} to mysql result of query "SELECT %{_c}% FROM %{_tbl}% %{_w}%"
     set {_rc::*} to mysql object "%{_c}%" in {_result}
     if {_rc::*} is not set:
          set {_return} to false
     else:
          set {_return} to true
     return {_return}

if check("tableName", "Player", "WHERE Player='%{_p}%'") is true:

and get object

function get(tbl: text, c: text, w: text) :: objects:
     set {_result} to mysql result of query "SELECT %{_c}% FROM %{_tbl}% %{_w}%"
     set {_rt::*} to mysql object "%{_c}%" in {_result}
     return {_rt::*}