From a485e5c7f1274308d020fd0c24636f3dd608f541 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Wed, 17 Oct 2018 01:20:05 -0300 Subject: [skip ci] SQL is boring stuff --- npc/commands/discord.txt | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'npc/commands/discord.txt') diff --git a/npc/commands/discord.txt b/npc/commands/discord.txt index b34f46423..2f7feb494 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