diff options
Diffstat (limited to 'npc/commands')
| -rw-r--r-- | npc/commands/discord.txt | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/npc/commands/discord.txt b/npc/commands/discord.txt index 43c4758c6..b34f46423 100644 --- a/npc/commands/discord.txt +++ b/npc/commands/discord.txt @@ -20,7 +20,7 @@ OnCall: close; @discord=1; - .@nb = query_sql("select `discord_name` from `discord` WHERE `account_id` == "+getcharid(3), .@discord$); + .@nb = query_sql("select `discord_name` from `discord` WHERE `account_id` == '"+getcharid(3)+"'", .@discord$); do @@ -40,13 +40,13 @@ OnCall: input .@discord$; .@discord$=escape_sql(.@discord$); mes ""; - query_sql("UPDATE `discord` SET `discord_name` = '"+.@discord$+"' WHERE `account_id` == "+getcharid(3)); - query_sql("UPDATE `discord` SET `verified` = '0' WHERE `account_id` == "+getcharid(3)); - query_sql("UPDATE `discord` SET `discord_id` = '' WHERE `account_id` == "+getcharid(3)); + query_sql("UPDATE `discord` SET `discord_name` = '"+.@discord$+"' WHERE `account_id` == '"+getcharid(3)+"'"); + query_sql("UPDATE `discord` SET `verified` = '0' WHERE `account_id` == '"+getcharid(3)+"'"); + query_sql("UPDATE `discord` SET `discord_id` = '' WHERE `account_id` == '"+getcharid(3)+"'"); mesc l("You must send ##B/verify##b to Discord bot for the linking be complete."), 1; break; case 2: - query_sql("DELETE FROM `discord` WHERE `account_id` == "+getcharid(3)); + query_sql("DELETE FROM `discord` WHERE `account_id` == '"+getcharid(3)+"'"); .@discord$=""; break; } |