summaryrefslogtreecommitdiff
path: root/npc/commands
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2018-10-17 01:20:05 -0300
committerJesusaves <cpntb1@ymail.com>2018-10-17 01:20:05 -0300
commita485e5c7f1274308d020fd0c24636f3dd608f541 (patch)
treea25092464de1461e005b47c3ad8c5d5ec631d12f /npc/commands
parent8ad9c660dcbf1c74effb6c59810454d57b841c55 (diff)
downloadserverdata-a485e5c7f1274308d020fd0c24636f3dd608f541.tar.gz
serverdata-a485e5c7f1274308d020fd0c24636f3dd608f541.tar.bz2
serverdata-a485e5c7f1274308d020fd0c24636f3dd608f541.tar.xz
serverdata-a485e5c7f1274308d020fd0c24636f3dd608f541.zip
[skip ci] SQL is boring stuff
Diffstat (limited to 'npc/commands')
-rw-r--r--npc/commands/discord.txt10
1 files changed, 5 insertions, 5 deletions
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;
}