summaryrefslogtreecommitdiff
path: root/npc/commands
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2018-10-16 19:39:53 -0300
committerJesusaves <cpntb1@ymail.com>2018-10-16 19:39:53 -0300
commitdb783bdca57192a4c8b6ffc0aed509e00ce03d15 (patch)
treeac8e791ebe41e4aa17f545e88a0f2cfcda41a076 /npc/commands
parent979164a8d796c27b1db34376fc380b3a851369f8 (diff)
downloadserverdata-db783bdca57192a4c8b6ffc0aed509e00ce03d15.tar.gz
serverdata-db783bdca57192a4c8b6ffc0aed509e00ce03d15.tar.bz2
serverdata-db783bdca57192a4c8b6ffc0aed509e00ce03d15.tar.xz
serverdata-db783bdca57192a4c8b6ffc0aed509e00ce03d15.zip
Update Discord table fields to be discord-bot compliant
Diffstat (limited to 'npc/commands')
-rw-r--r--npc/commands/discord.txt5
1 files changed, 3 insertions, 2 deletions
diff --git a/npc/commands/discord.txt b/npc/commands/discord.txt
index f854e23b0..2b6264519 100644
--- a/npc/commands/discord.txt
+++ b/npc/commands/discord.txt
@@ -20,7 +20,7 @@ OnCall:
close;
@discord=1;
- .@nb = query_sql("select `discord_id` from `discord` WHERE `account_id` == "+getcharid(3), .@discord$);
+ .@nb = query_sql("select `discord_name` from `discord` WHERE `account_id` == "+getcharid(3), .@discord$);
do
@@ -40,7 +40,8 @@ OnCall:
input .@discord$;
.@discord$=escape_sql(.@discord$);
mes "";
- query_sql("UPDATE `discord` SET `discord_id` = '"+.@discord$+"' 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));
break;
case 2:
query_sql("DELETE FROM `discord` WHERE `account_id` == "+getcharid(3));