Advertisement
Guest User

Untitled

a guest
Jan 20th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.76 KB | None | 0 0
  1.     @commands.group()
  2.     @commands.guild_only()
  3.     @checks.is_guild_owner()
  4.     async def twitterset(self, ctx):
  5.         """Admin twitter related commands"""
  6.  
  7.         if ctx.invoked_subcommand is None:
  8.  
  9.             query = "SELECT * FROM social_config WHERE guild_id = $1"
  10.             results = await self.bot.pool.fetch(query, ctx.guild.id)
  11.             if results is None:
  12.                 tweeter_role = tweeter_number = 0
  13.             elif len(results) == 0:
  14.                 tweeter_role = tweeter_number = 0
  15.             else:
  16.                 tweeter_role = results[0]["tweeter_role_id"]
  17.                 tweeter_number = results[0]["tweeter_reaction"]
  18.                 feed_channel = results[0]["feed_channel"]
  19.             msg = box("Reactions until tweet: {0} 🐦\n"
  20.                       "Tweeter role ID:  {1}\n"
  21.                       "Twitter Feed Channel {2}\n"
  22.                       .format(tweeter_number or "0", tweeter_role or "0", str(self.bot.get_channel(feed_channel)) or "OFF"))
  23.             msg += "\n {}twittetset tweeter <role>".format(ctx.prefix)
  24.             msg += "\n {}twitterset tweetnumber <number>".format(ctx.prefix)
  25.             msg += "\n {}twitterset tweetcreds".format(ctx.prefix)
  26.             msg += "\n {}twitterset feedchannel <channel>".format(ctx.prefix)
  27.             em = discord.Embed(color=ctx.message.author.color, description=msg)
  28.             em.set_author(name="Twitter Settings Help", icon_url="http://bit.ly/2qrhjLu")
  29.             await ctx.send(embed=em)
  30.  
  31.  
  32.     @twitterset.command()
  33.     @commands.guild_only()
  34.     @checks.is_admin()
  35.     async def feedchannel(self, ctx, channel : discord.TextChannel):
  36.  
  37.  
  38.         insertquery = "INSERT INTO social_config (guild_id, feed_channel) VALUES ($1, $2)"
  39.         alterquery = "UPDATE social_config SET feed_channel = $2 WHERE guild_id = $1"
  40.  
  41.         try:
  42.             await ctx.db.execute(insertquery, ctx.guild.id, channel.id)
  43.         except asyncpg.UniqueViolationError:
  44.             await ctx.db.execute(alterquery, ctx.guild.id, channel.id)
  45.         await ctx.send('Channel Set')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement