Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- import discord
- from discord.ext import commands
- BOT_TOKEN = "YOUR_BOT_TOKEN"
- bot = commands.Bot(command_prefix='!')
- @bot.command()
- async def uSearch(ctx, arg):
- mydb = mysql.connector.connect(
- host="YOUR_HOST",
- user="YOUR_USERNAME",
- passwd="YOUR_PASSWORD",
- database="YOUR_DATABASE"
- )
- mycursor = mydb.cursor()
- sql = "SELECT * FROM uDiscordStats WHERE name LIKE %s"
- search = "%"+arg+"%"
- mycursor.execute(sql, (search, ));
- myresult = mycursor.fetchall()
- epic=""
- for row in myresult:
- epic= epic + str("**Name:** %s **KD:** %s **Kills:** %s **Deaths:** %s \n" % (row[1], (row[2] / row[3]), row[2], row[3]))
- embed=discord.Embed(title="Discord Stats", description=epic, color=0x06f9e0)
- await ctx.channel.send(embed=embed)
- mydb.close()
- bot.run(BOT_TOKEN)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement