1 files changed, 41 insertions, 0 deletions
diff --git a/cogs/adv_inc/PlayerDeath.py b/cogs/adv_inc/PlayerDeath.py
new file mode 100644
index 0000000..29fc34f
--- /dev/null
+++ b/cogs/adv_inc/PlayerDeath.py
@@ -0,0 +1,41 @@
+import time
+import pymysql
+import importlib
+import utils
+
+from cogs.adv_inc import Calculate
+
+importlib.reload(utils)
+importlib.reload(Calculate)
+
+
+async def character_death(player_stats, params):
+    # Create death entry
+    sql = 'CALL adventurersinc.add_player_graveyard_death(%s, %s, %s, %s, %s, %s);'
+    query_params = (params['nick'], player_stats['character_name'], player_stats['clan_name'], player_stats["total_items"], player_stats['challenge_rating'], str(params['game_version']),)
+    # print(f"1 {sql % query_params}")
+    await utils.sql_postgres(sql, query_params, False)
+
+    # Delete players Inventory
+    sql = 'CALL adventurersinc.del_player_inventory(%s);'
+    query_params = (params['nick'],)
+    # print(f"2 {sql % query_params}")
+    await utils.sql_postgres(sql, query_params, False)
+
+    # Delete players opponent
+    sql = 'CALL adventurersinc.del_player_enemies(%s);'
+    query_params = (params['nick'],)
+    # print(f"3 {sql % query_params}")
+    await utils.sql_postgres(sql, query_params, False)
+
+    # Delete players shop
+    sql = 'CALL adventurersinc.del_player_shop(%s);'
+    query_params = (params['nick'],)
+    # print(f"4 {sql % query_params}")
+    await utils.sql_postgres(sql, query_params, False)
+
+    # Update player record for new character + lose gold on death
+    sql = 'CALL adventurersinc.set_player_death(%s);'
+    query_params = (params['nick'],)
+    # print(f"5 {sql % query_params}")
+    await utils.sql_postgres(sql, query_params, False)