/[sudobot]/trunk/src/commands/automation/BallotCommand.ts
ViewVC logotype

Diff of /trunk/src/commands/automation/BallotCommand.ts

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 59 by rakin, Mon Jul 29 17:28:25 2024 UTC revision 393 by rakin, Mon Jul 29 17:29:59 2024 UTC
# Line 1  Line 1 
1    /**
2    * This file is part of SudoBot.
3    *
4    * Copyright (C) 2021-2022 OSN Inc.
5    *
6    * SudoBot is free software; you can redistribute it and/or modify it
7    * under the terms of the GNU Affero General Public License as published by
8    * the Free Software Foundation, either version 3 of the License, or
9    * (at your option) any later version.
10    *
11    * SudoBot is distributed in the hope that it will be useful, but
12    * WITHOUT ANY WARRANTY; without even the implied warranty of
13    * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14    * GNU Affero General Public License for more details.
15    *
16    * You should have received a copy of the GNU Affero General Public License
17    * along with SudoBot. If not, see <https://www.gnu.org/licenses/>.
18    */
19    
20  import { CommandInteraction, EmojiIdentifierResolvable, GuildMember, Message, TextChannel, User } from 'discord.js';  import { CommandInteraction, EmojiIdentifierResolvable, GuildMember, Message, TextChannel, User } from 'discord.js';
21  import BaseCommand from '../../utils/structures/BaseCommand';  import BaseCommand from '../../utils/structures/BaseCommand';
22  import DiscordClient from '../../client/Client';  import DiscordClient from '../../client/Client';
# Line 84  export default class BallotCommand exten Line 103  export default class BallotCommand exten
103          });          });
104    
105          await ballot.save();          await ballot.save();
106            
         // await client.db.runAsync('INSERT INTO ballots(content, author, msg_id, guild_id, date, channel_id) VALUES(?, ?, ?, ?, ?, ?)', [content, anonymous ? null : msg.member?.user.id, message.id, msg.guild!.id, new Date().toISOString(), msg.channel!.id]);  
         // const ballot = await client.db.getAsync("SELECT * FROM ballots WHERE msg_id = ? AND guild_id = ? ORDER BY id DESC LIMIT 0, 1", [message.id, msg.guild!.id]);  
   
107          await message.react(<EmojiIdentifierResolvable> await fetchEmoji('check'));          await message.react(<EmojiIdentifierResolvable> await fetchEmoji('check'));
108          await message.react(<EmojiIdentifierResolvable> await fetchEmoji('error'));          await message.react(<EmojiIdentifierResolvable> await fetchEmoji('error'));
109    
# Line 110  export default class BallotCommand exten Line 126  export default class BallotCommand exten
126          }          }
127                    
128          try {          try {
129              const id = options.isInteraction ? options.options.getInteger('id') : options.args[0];              const id = options.isInteraction ? options.options.getString('id') : options.args[0];
130              //const ballot = await client.db.getAsync("SELECT * FROM ballots WHERE id = ? ORDER BY id DESC LIMIT 0, 1", [id]);              //const ballot = await client.db.getAsync("SELECT * FROM ballots WHERE id = ? ORDER BY id DESC LIMIT 0, 1", [id]);
131              const ballot = (await Ballot.findOne({              const ballot = await Ballot.findById(id);
                 where: {  
                     id  
                 }  
             }))?.get();  
132    
133              if (!ballot)              if (!ballot)
134                  throw new Error();                  throw new Error();
Legend:
Removed from v.59  
changed lines
  Added in v.393
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26