Paste #20895: List clean

Date: 2015/10/14 18:26:49 UTC-07:00
Type: Denizen Script

View Raw Paste Download This Paste
Copy Link


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"