diff options
| author | Jesusaves <cpntb1@ymail.com> | 2018-10-17 01:20:05 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2018-10-17 01:20:05 -0300 |
| commit | a485e5c7f1274308d020fd0c24636f3dd608f541 (patch) | |
| tree | a25092464de1461e005b47c3ad8c5d5ec631d12f /npc/commands | |
| parent | 8ad9c660dcbf1c74effb6c59810454d57b841c55 (diff) | |
| download | serverdata-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.txt | 10 |
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; } |