From 8ad9c660dcbf1c74effb6c59810454d57b841c55 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Wed, 17 Oct 2018 01:18:17 -0300 Subject: Fix broken command --- npc/commands/discord.txt | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'npc') 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; } -- cgit v1.2.3-70-g09d2