Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.97 KB | None | 0 0
  1. starboard_channel = reaction.message.guild.get_channel(int(starboard_id))
  2. if reaction.emoji==(starsone):
  3. try:
  4. cursor.execute(f"SELECT amount FROM starcount WHERE guildid = '{reaction.message.guild.id}'")
  5. aids = cursor.fetchone()
  6. reaction_counter = int(aids[0])
  7. except:
  8. reaction_counter = 1
  9.  
  10. if reaction.count==(reaction_counter):
  11. cursor.execute(f"SELECT messageid FROM starboard WHERE reactionid = '{reaction.message.id}'")
  12. data = cursor.fetchone()
  13. try:
  14. before_id = data[0]
  15. return
  16. except:
  17. print("OK")
  18. message = await starboard_channel.send(f"{starsone} **#{reaction_counter}**")
  19. try:
  20. file = reaction.message.attachments[0]
  21. if '[]' in str(message.content):
  22. embedd = discord.Embed(timestamp=reaction.message.created_at)
  23. embedd.set_image(url=file.url)
  24. embedd.set_author(icon_url=reaction.message.author.avatar_url,name=reaction.message.author.display_name)
  25. embedd.set_footer(text=f"Server: {reaction.message.guild} | Channel: {reaction.message.channel} ")
  26. await starboard_channel.send(embed=embedd)
  27. return
  28.  
  29. embed = discord.Embed(description=reaction.message.content,timestamp=reaction.message.created_at)
  30. embed.set_image(url=file.url)
  31. embed.set_author(icon_url=reaction.message.author.avatar_url,name=reaction.message.author.display_name)
  32. embed.set_footer(text=f"Server: {reaction.message.guild} | Channel: {reaction.message.channel} ")
  33. await starboard_channel.send(embed=embed)
  34. except:
  35. embed = discord.Embed(description=reaction.message.content,timestamp=reaction.message.created_at)
  36. embed.set_author(icon_url=reaction.message.author.avatar_url,name=reaction.message.author.display_name)
  37. embed.set_footer(text=f"Server: {reaction.message.guild} | Channel: {reaction.message.channel} ")
  38. await starboard_channel.send(embed=embed)
  39.  
  40. cursor.execute(f"DELETE FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  41. database.commit()
  42. cursor.execute(f"INSERT INTO starboard VALUES ('{message.id}','1','{reaction.message.guild.id}','{reaction.message.id}')")
  43. database.commit()
  44. return
  45. if reaction.count == (reaction_counter + 1):
  46. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  47. data = cursor.fetchone()
  48. message_id = data[0]
  49. messages = await starboard_channel.fetch_message(message_id)
  50. await messages.edit(content=f"{starsone} **#{reaction_counter + 1}**")
  51. return
  52. if reaction.count==(reaction_counter + 2):
  53. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  54. data = cursor.fetchone()
  55. message_id = data[0]
  56. messages = await starboard_channel.fetch_message(message_id)
  57. await messages.edit(content=f"{starsone} **#{reaction_counter + 2}**")
  58. return
  59. if reaction.count==(reaction_counter + 3):
  60. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  61. data = cursor.fetchone()
  62. message_id = data[0]
  63. messages = await starboard_channel.fetch_message(message_id)
  64. await messages.edit(content=f"{starsone} **#{reaction_counter + 3}**")
  65. return
  66. if reaction.count==(reaction_counter + 4):
  67. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  68. data = cursor.fetchone()
  69. message_id = data[0]
  70. messages = await starboard_channel.fetch_message(message_id)
  71. await messages.edit(content=f"{starsone} **#{reaction_counter + 4}**")
  72. return
  73. if reaction.count==(reaction_counter + 5):
  74. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  75. data = cursor.fetchone()
  76. message_id = data[0]
  77. messages = await starboard_channel.fetch_message(message_id)
  78. await messages.edit(content=f"{starsone} **#{reaction_counter + 5}**")
  79. return
  80. if reaction.count==(reaction_counter + 6):
  81. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  82. data = cursor.fetchone()
  83. message_id = data[0]
  84. messages = await starboard_channel.fetch_message(message_id)
  85. await messages.edit(content=f"{starsone} **#{reaction_counter + 6}**")
  86. return
  87. if reaction.count==(reaction_counter + 7):
  88. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  89. data = cursor.fetchone()
  90. message_id = data[0]
  91. messages = await starboard_channel.fetch_message(message_id)
  92. await messages.edit(content=f"{starsone} **#{reaction_counter + 7}**")
  93. return
  94. if reaction.count==(reaction_counter + 8):
  95. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  96. data = cursor.fetchone()
  97. message_id = data[0]
  98. messages = await starboard_channel.fetch_message(message_id)
  99. await messages.edit(content=f"{starsone} **#{reaction_counter + 8}**")
  100. return
  101. if reaction.count==(reaction_counter + 9):
  102. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  103. data = cursor.fetchone()
  104. message_id = data[0]
  105. messages = await starboard_channel.fetch_message(message_id)
  106. await messages.edit(content=f"{starsone} **#{reaction_counter + 9}**")
  107. return
  108. if reaction.count==(reaction_counter + 10):
  109. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  110. data = cursor.fetchone()
  111. message_id = data[0]
  112. messages = await starboard_channel.fetch_message(message_id)
  113. await messages.edit(content=f"{starsone} **#{reaction_counter + 10}**")
  114. return
  115. if reaction.count==(reaction_counter + 11):
  116. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  117. data = cursor.fetchone()
  118. message_id = data[0]
  119. messages = await starboard_channel.fetch_message(message_id)
  120. await messages.edit(content=f"{starsone} **#{reaction_counter + 11}**")
  121. return
  122. if reaction.count==(reaction_counter + 12):
  123. cursor.execute(f"SELECT messageid FROM starboard WHERE guildid = '{reaction.message.guild.id}'")
  124. data = cursor.fetchone()
  125. message_id = data[0]
  126. messages = await starboard_channel.fetch_message(message_id)
  127. await messages.edit(content=f"{starsone} **#{reaction_counter + 12}**")
  128. return
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement