Date: 2015/10/14 18:26:49 UTC-07:00
Type: Denizen Script
on testyml command:
- ^define jugador <player.name>
- ~sql id:<player.name> connect:localhost:3306/lmacias_esparcraft username:lmacias_drakness password:drakness666
- ^sql id:<player.name> "query:SELECT user_id FROM phpbb_users WHERE username='<def[jugador]>';" save:resultado
- ^narrate "<entry[resultado].result.as_cslist>"
- ^yaml create id:<player.name>
- ^yaml id:<player.name> set UserID:<entry[resultado].result.as_cslist>
- ^yaml id:<player.name> set UserID:<-:/
- ^yaml savefile:personal/<player.name>.yml id:<player.name>
- ^yaml unload id:<player.name>
- sql id:<player.name> "update:UPDATE phpbb_profile_fields_data SET pf_pb_wow_race='1' WHERE user_id=<yaml[<player.name>].read[UserID].as_cslist>;"
- sql disconnect id:<player.name>
- ^DETERMINE cancelled
================================
as I can get the value of the clean list?
<entry[resultado].result.as_cslist> result "2/"
<entry[resultado].result.as_list> result "li@2/"
<entry[resultado].result> result "li@2"
I need this result "2"