Advertisement
Guest User

Untitled

a guest
May 24th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. async def fish_thing(rarity, message):
  2. query = "INSERT INTO fish_command (discord_user_id, fish_amount_rarity_" + str(rarity) + ") VALUES ('" + message.author.id + "', 1) ON DUPLICATE KEY UPDATE `fish_amount_rarity_" + str(rarity) + "`=`fish_amount_rarity_" + str(
  3. rarity) + "` + 1"
  4. print(query)
  5. cursor.execute(query)
  6. conn.commit()
  7.  
  8. query = "SELECT discord_user_id, fish_amount_rarity_" + str(rarity) + " FROM fish_command WHERE discord_user_id = '" + message.author.id + "'"
  9. cursor.execute(query)
  10.  
  11. for (discord_user_id, fish_amount) in cursor:
  12. await client.send_message(message.channel,
  13. "{} has caught another rarity {} level fish! {} in total.".format(message.author.name,
  14. rarity, fish_amount))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement