Advertisement
AutismAlex

uDiscordLink - Python

Nov 1st, 2019
654
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. import mysql.connector
  2. import discord
  3. from discord.ext import commands
  4.  
  5. BOT_TOKEN = "YOUR_BOT_TOKEN"
  6.  
  7. bot = commands.Bot(command_prefix='!')
  8.  
  9. @bot.command()
  10. async def uSearch(ctx, arg):
  11. mydb = mysql.connector.connect(
  12. host="YOUR_HOST",
  13. user="YOUR_USERNAME",
  14. passwd="YOUR_PASSWORD",
  15. database="YOUR_DATABASE"
  16. )
  17. mycursor = mydb.cursor()
  18. sql = "SELECT * FROM uDiscordStats WHERE name LIKE %s"
  19. search = "%"+arg+"%"
  20. mycursor.execute(sql, (search, ));
  21. myresult = mycursor.fetchall()
  22. epic=""
  23. for row in myresult:
  24. epic= epic + str("**Name:** %s **KD:** %s **Kills:** %s **Deaths:** %s \n" % (row[1], (row[2] / row[3]), row[2], row[3]))
  25. embed=discord.Embed(title="Discord Stats", description=epic, color=0x06f9e0)
  26. await ctx.channel.send(embed=embed)
  27. mydb.close()
  28.  
  29. bot.run(BOT_TOKEN)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement