[Simple query_sql script] Deletion or set as 0

[Han25]

Hello, i just want to have atleast an example of executing the script from npc to sql database..

 

example

npc asked the player if he/she really wants to reset his faction then, (yes or no.)

as yes is chosen.. the npc will update the sql table from char , faction_id to 0.

i want to set this faction_id 10 as 0 to be registered as no faction_id,

 

thank you..

Edited June 29, 2014 by Elektrochemiestry

[Capuche]

well to set the faction id 10 to 0 in a npc

query_sql "update `your_faction_table` set `faction_id` = 0 where `faction_id` = 10";