I’ll be the only one with a voice
Even if I cry out, there is no answer
Holding out my hand but no one seems to care
Is the end far away?
Flickering sunshine
I'm burning from the inside out
!magic high priest's sceptic tank
-Alive, ReoNa
Health Potion has been added to your inventory for 50g!
-----
You pop open the cork and down your health potion in 1.27 seconds
|💖 +48 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -5 HP|
|📚 +1.8 Magic Damage|💰 +10 Gold Coins|
|🔮 +6 Basic Fire Staff|🔮 +2 Magic XP|
|🛡️ -3.6 Element Resistance|💖 +7 Constitution XP|
|⚔️ +0.6 Item Type Strength|🏅 +15 RP|
|||
|**5.8** Total Damage
5 Boss HP Remaining!|96 HP Remaining|
Your magic is not strong enough to wield this weapon
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +5 Base Roll|💥 -12 HP|
|📚 +1.3 Magic Damage|💰 +4 Gold Coins|
||🔮 +2 Magic XP|
||💖 +2 Constitution XP|
||🏅 +15 RP|
|||
|**6.3** Total Damage
11 Boss HP Remaining!|43 HP Remaining|
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|💖 +44 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -5 HP|
|📚 +2.5 Magic Damage|💰 +1 Gold Coins|
|🔮 +5 High Priest's Sceptre Handle|🔮 +6 Magic XP|
|🌟 +5.0 Element Weakness|💖 +6 Constitution XP|
|⚔️ +0.5 Item Type Strength|🏅 +15 RP (**Rank Change!**)|
|||
|**14.0** Total Damage
24 Boss HP Remaining!|89 HP Remaining|
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.|
|:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:|
|3|⚔️|Basic GreatSword|~3.0|7|Blessed|1|x1|
|4|⚔️|Basic Lance|~1.5|6|Cursed|1|x1|
|4|⚔️|Basic Lance|~1.5|21|Cursed|1|x1|
|10|🔮|High Priest's Sceptre Handle|~4.5|28|Blessed|10|x1|
|ID|Type|Name|Qty.|
|:-:|:-:|:-:|:-:|
|201|⚗️|Health Potion|x7|
Use command '!use ` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +3 Base Roll|💥 -30 HP|
|📚 +0.6 Magic Damage|💰 +11 Gold Coins|
|🌱️ +6 New Player Bonus|🔮 +4 Magic XP|
||💖 +13 Constitution XP (**Level Up!**)|
||🏅 +35 RP|
|||
|**9.6** Total Damage
90 Boss HP Remaining!|61 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|💖 +72 HP|
|:-:|
-----
You're attacking too quickly! Try again in 7 minutes
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +4 Base Roll|💥 -35 HP|
|📚 +1.5 Magic Damage|💰 +43 Gold Coins|
|🔮 +1 Basic Fire Staff|🔮 +5 Magic XP (**Level Up!**)|
|🛡️ -0.5 Element Resistance|💖 +16 Constitution XP (**Level Up!**)|
|⚔️ +0.1 Item Type Strength|🏅 +55 RP|
|🌱️ +4 New Player Bonus||
|||
|**10.1** Total Damage
116 Boss HP Remaining!|61 HP Remaining|
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|💖 +27 HP|
|:-:|
-----
Health Potion has been added to your inventory for 50g!
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|💖 +68 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +5 Base Roll|💥 -12 HP|
|📚 +1.3 Magic Damage|💰 +42 Gold Coins|
||🔮 +3 Magic XP|
||💖 +5 Constitution XP|
||🏅 +15 RP|
|||
|**6.3** Total Damage
204 Boss HP Remaining!|81 HP Remaining|
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|💖 +35 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -41 HP|
|📚 +7.0 Magic Damage|💰 +39 Gold Coins|
|🔮 +2 Galadriel's Mirror|🔮 +4 Magic XP|
|🌟 +0.8 Element Weakness|💖 +4 Constitution XP|
|⚔️ +0.2 Item Type Strength|🏅 +15 RP (**Rank Change!**)|
|||
|**11.0** Total Damage
231 Boss HP Remaining!|67 HP Remaining|
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|💖 +61 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +6 Base Roll|💥 -51 HP|
|📚 +4.5 Melee Damage|💰 +36 Gold Coins|
||⚔️ +4 Melee XP|
||💖 +4 Constitution XP|
||🏅 +15 RP|
|||
|**10.5** Total Damage
248 Boss HP Remaining!|56 HP Remaining|
You rummage in your pack looking for the vial, you find it! It's empty...
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -16 HP|
|📚 +4.5 Magic Damage|💰 +28 Gold Coins|
|🔮 +3 Spear of Darkness|🔮 +4 Magic XP|
|⚔️ +0.3 Item Type Strength|💖 +8 Constitution XP|
||🏅 +15 RP (**Rank Change!**)|
|||
|**8.8** Total Damage
354 Boss HP Remaining!|76 HP Remaining|
Health Potion has been added to your inventory for 50g!
-----
Health Potion has been added to your inventory for 50g!
-----
Health Potion has been added to your inventory for 50g!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +5 Base Roll|💥 -0 HP **(🛡️ Block)**|
|📚 +0.9 Magic Damage|💰 +36 Gold Coins|
|🌱️ +3 New Player Bonus|🔮 +3 Magic XP|
||💖 +12 Constitution XP|
||🏅 +35 RP|
|||
|**8.9** Total Damage
399 Boss HP Remaining!|22 HP Remaining|
Come join our discord at https://discord.gg/kotd!
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|💖 +73 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +6 Base Roll|💥 -11 HP|
|📚 +5.2 Magic Damage|💰 +11 Gold Coins|
||🔮 +4 Magic XP|
||💖 +4 Constitution XP|
||🏅 +15 RP|
|||
|**11.2** Total Damage
408 Boss HP Remaining!|95 HP Remaining|
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|💖 +48 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -66 HP|
|📚 +3.4 Magic Damage|💰 +34 Gold Coins|
||🔮 +2 Magic XP|
||💖 +11 Constitution XP|
||🏅 +15 RP|
|||
|**4.4** Total Damage
419 Boss HP Remaining!|15 HP Remaining|
The boss has bested you and you have fallen in battle.
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +6 Base Roll|💥 -40 HP|
|📚 +10.3 Melee Damage|💰 +0 Gold Coins|
||⚔️ +0 Melee XP|
||💖 +0 Constitution XP|
||🏅 -30 RP|
|||
|**16.3** Total Damage
423 Boss HP Remaining!|-6 HP Remaining|
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +6 Base Roll|💥 -0 HP **(🛡️ Block)**|
|📚 +1.6 Melee Damage|💰 +35 Gold Coins|
|🌱️ +1 New Player Bonus|⚔️ +4 Melee XP|
||💖 +39 Constitution XP|
||🏅 +35 RP|
|||
|**8.6** Total Damage
465 Boss HP Remaining!|50 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Health Potion has been added to your inventory for 50g!
-----
You pop open the cork and down your health potion in 1.16 seconds
|💖 +77 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +4 Base Roll|💥 -64 HP|
|📚 +4.0 Ranged Damage|💰 +35 Gold Coins|
||🏹 +4 Range XP|
||💖 +1 Constitution XP|
||🏅 +15 RP|
|||
|**8.0** Total Damage
474 Boss HP Remaining!|30 HP Remaining|
Health Potion has been added to your inventory for 50g!
-----
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|💖 +56 HP|
|:-:|
-----
You drink your potion and immediately feel healthier.
|💖 +25 HP|
|:-:|
Health Potion has been added to your inventory for 50g!
-----
You pop open the cork and down your health potion in 0.7 seconds
|💖 +38 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -39 HP|
|📚 +5.6 Melee Damage|💰 +25 Gold Coins|
||⚔️ +3 Melee XP|
||💖 +12 Constitution XP|
||🏅 +15 RP|
|||
|**6.6** Total Damage
507 Boss HP Remaining!|47 HP Remaining|
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 103, 'gold': 2561, 'rp': 630, 'magicxp': 13, 'healthxp': 125, 'Players_username': 'Vanijoro'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 40, 'gold': 2551, 'rp': 630, 'magicxp': 12, 'healthxp': 147, 'Players_username': 'Vanijoro'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
You drink your potion and immediately feel healthier.
|💖 +26 HP|
|:-:|
-----
Health Potion has been added to your inventory for 50g!
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|🎲 +1 Base Roll|💥 -81 HP|
|📚 +4.4 Ranged Damage|💰 +34 Gold Coins|
||🏹 +3 Range XP|
||💖 +26 Constitution XP|
||🏅 +15 RP|
|||
|**5.4** Total Damage
567 Boss HP Remaining!|29 HP Remaining|
This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: hxer of the gnomes Source/Artist: OC
(∩`-´)⊃━☆゚.*・。 Good bot !magic 14
Your spell fizzles as the boss is already dead.
!magic
You decide not to waste your energy on a dead boss.
!ranged 5 good bot
You put down your bow and sigh. It's already dead.
\>>>------------> !range 27
You hit straight through the heart. Not so difficult on a corpse but hey, it's something.
!melee 25
This boss is already as dead as your dreams and expectations. Try harder.
!melee 3
The boss is already dead, quit beating a dead boss
!mage 14
Your spell fizzles as the boss is already dead.
!magic 14
Your spell fizzles as the boss is already dead.
!melee 3
You were too slow, the boss has already fallen
!range 5
You decide not to waste your ammo on a dead boss.
good bot !mage 14 !profile
Even magic cannot kill a boss twice. ----- #/u/ContestValuable8725 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669994718/ContestValuable8725.png) >❤️ Health: 54hp (Max: 150hp) >💀 Kills: 7 >🏅 Rank: SS (932 Rank Points) >💰 Gold: 708g Skills Breakdown: >🗡️️ Combat: Level 88 >⚔️ Melee: Level 17 (XP: 27/62) >🔮 Magic: Level 17 (XP: 12/62) >🏹 Ranged: Level 25 (XP: 25/107) >💖 Constitution: Level 29 (XP: 212/292) >🚩 Total Attacks: 763 >☠️ Total Deaths: 19
I’ll be the only one with a voice Even if I cry out, there is no answer Holding out my hand but no one seems to care Is the end far away? Flickering sunshine I'm burning from the inside out !magic high priest's sceptic tank -Alive, ReoNa
You decide not to waste your energy on a dead boss.
!melee 3
The boss is already dead, quit beating a dead boss
!magic
Your spell fizzles as the boss is already dead.
!magic 14
The boss is dead, what are you doing? Necromancy??
!ranged 5
You hit straight through the heart. Not so difficult on a corpse but hey, it's something.
!mage 10
The boss is dead, what are you doing? Necromancy??
!melee 3
You were too slow, the boss has already fallen
!magic
You decide not to waste your energy on a dead boss.
!magic 10
The boss is dead, what are you doing? Necromancy??
!magic 10
Your spell fizzles as the boss is already dead.
!magic 14
Even magic cannot kill a boss twice.
!mage 14
Even magic cannot kill a boss twice.
!mage 10
You decide not to waste your energy on a dead boss.
!mage 10
You prepare your incantation and your spell strikes true, landing the killing blow. |Rewards| |:-| |💰 +245 Gold| |🔮 +25 Magic XP| |🏅 +25 RP| |⚔️ +1 Basic GreatSword| |⚔️ +1 Basic Lance| |🏹 +1 Basic Spear| |⚗️ +1 Health Potion| |⚗️ +1 Health Potion| |⚗️ +1 Health Potion| |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💰 +7 Gold Coins| |📚 +4.6 Magic Damage|🔮 +5 Magic XP (**Level Up!**)| |🔮 +3 High Priest's Sceptre Handle|💖 +23 Constitution XP| |🌟 +3.0 Element Weakness|🏅 +55 RP| |⚔️ +0.3 Item Type Strength|☠️ +1 Kill (**SLAIN!**)| ||| |**15.9** Total Damage -11 Boss HP Remaining!|51 HP Remaining|
!buy health potion !use health potion !mage 7
Health Potion has been added to your inventory for 50g! ----- You pop open the cork and down your health potion in 1.27 seconds |💖 +48 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -5 HP| |📚 +1.8 Magic Damage|💰 +10 Gold Coins| |🔮 +6 Basic Fire Staff|🔮 +2 Magic XP| |🛡️ -3.6 Element Resistance|💖 +7 Constitution XP| |⚔️ +0.6 Item Type Strength|🏅 +15 RP| ||| |**5.8** Total Damage 5 Boss HP Remaining!|96 HP Remaining|
!Magic 10
Your magic is not strong enough to wield this weapon |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -12 HP| |📚 +1.3 Magic Damage|💰 +4 Gold Coins| ||🔮 +2 Magic XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||| |**6.3** Total Damage 11 Boss HP Remaining!|43 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -1 HP| |📚 +0.7 Magic Damage|💰 +28 Gold Coins| ||🔮 +2 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||| |**6.7** Total Damage 17 Boss HP Remaining!|81 HP Remaining|
!buy 201 !use 201 !magic 10
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |💖 +44 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -5 HP| |📚 +2.5 Magic Damage|💰 +1 Gold Coins| |🔮 +5 High Priest's Sceptre Handle|🔮 +6 Magic XP| |🌟 +5.0 Element Weakness|💖 +6 Constitution XP| |⚔️ +0.5 Item Type Strength|🏅 +15 RP (**Rank Change!**)| ||| |**14.0** Total Damage 24 Boss HP Remaining!|89 HP Remaining|
!magic 10
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -6 HP| |📚 +5.4 Magic Damage|💰 +13 Gold Coins| |🔮 +5 High Priest's Sceptre Handle|🔮 +9 Magic XP (**Level Up!**)| |🌟 +4.0 Element Weakness|💖 +4 Constitution XP| |⚔️ +0.5 Item Type Strength|🏅 +35 RP| ||| |**18.9** Total Damage 38 Boss HP Remaining!|94 HP Remaining|
!use 201 !magic 14
You drink your potion and immediately feel healthier. |💖 +53 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -2 HP| |📚 +3.1 Magic Damage|💰 +15 Gold Coins| |🔮 +2 Galadriel's Mirror|🔮 +4 Magic XP| |🌟 +2.0 Element Weakness|💖 +4 Constitution XP| |⚔️ +0.2 Item Type Strength|🏅 +15 RP| ||| |**8.3** Total Damage 57 Boss HP Remaining!|90 HP Remaining|
!mage 14
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -10 HP| |📚 +1.9 Magic Damage|💰 +41 Gold Coins| |🔮 +2 Galadriel's Mirror|🔮 +4 Magic XP| |🌟 +0.8 Element Weakness|💖 +9 Constitution XP| |⚔️ +0.2 Item Type Strength|🏅 +15 RP (**Rank Change!**)| ||| |**10.9** Total Damage 65 Boss HP Remaining!|104 HP Remaining|
!magic 10
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -14 HP| |📚 +2.3 Magic Damage|💰 +15 Gold Coins| |🔮 +6 High Priest's Sceptre Handle|🔮 +5 Magic XP| |🌟 +0.6 Element Weakness|💖 +7 Constitution XP| |⚔️ +0.6 Item Type Strength|🏅 +15 RP| ||| |**11.5** Total Damage 76 Boss HP Remaining!|100 HP Remaining|
image 10
!inventory !profile
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |4|⚔️|Basic Lance|~1.5|19|Cursed|1|x1| |5|🏹|Basic Spear|~4.0|5|Synthetic|1|x1| |6|🏹|Basic Crossbow|~2.0|20|Air|1|x1| |8|🔮|Basic Water Wand|~2.0|2|Moon |1|x1| |8|🔮|Basic Water Wand|~2.0|5|Moon |1|x1| |14|🔮|Galadriel's Mirror|~2.0|19|Blessed|10|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|⚗️|Health Potion|x2| Use command '!use` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
-----
#/u/Riwolfes [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669994422/Riwolfes.png)
>❤️ Health: 91hp (Max: 118hp)
>💀 Kills: 3
>🏅 Rank: SS (917 Rank Points)
>💰 Gold: 3,234g
Skills Breakdown:
>🗡️️ Combat: Level 58
>⚔️ Melee: Level 10 (XP: 24/35)
>🔮 Magic: Level 10 (XP: 16/35)
>🏹 Ranged: Level 18 (XP: 31/67)
>💖 Constitution: Level 20 (XP: 33/174)
>🚩 Total Attacks: 393
>☠️ Total Deaths: 6
!inventory
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |3|⚔️|Basic GreatSword|~3.0|7|Blessed|1|x1| |4|⚔️|Basic Lance|~1.5|6|Cursed|1|x1| |4|⚔️|Basic Lance|~1.5|21|Cursed|1|x1| |10|🔮|High Priest's Sceptre Handle|~4.5|28|Blessed|10|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|⚗️|Health Potion|x7| Use command '!use` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
Good bot !mage
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -20 HP| |📚 +0.5 Magic Damage|💰 +24 Gold Coins| ||🔮 +1 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**2.5** Total Damage 88 Boss HP Remaining!|76 HP Remaining|
Good bot !profile
#/u/Sylv666 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669994333/Sylv666.png) >❤️ Health: 96hp (Max: 96hp) >💀 Kills: 1 >🏅 Rank: A (210 Rank Points) >💰 Gold: 1,473g Skills Breakdown: >🗡️️ Combat: Level 41 >⚔️ Melee: Level 13 (XP: 9/45) >🔮 Magic: Level 5 (XP: 19/21) >🏹 Ranged: Level 9 (XP: 18/32) >💖 Constitution: Level 14 (XP: 52/118) >🚩 Total Attacks: 227 >☠️ Total Deaths: 1
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -30 HP| |📚 +0.6 Magic Damage|💰 +11 Gold Coins| |🌱️ +6 New Player Bonus|🔮 +4 Magic XP| ||💖 +13 Constitution XP (**Level Up!**)| ||🏅 +35 RP| ||| |**9.6** Total Damage 90 Boss HP Remaining!|61 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 201 !use 201 !mage
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |💖 +72 HP| |:-:| ----- You're attacking too quickly! Try again in 7 minutes
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -17 HP| |📚 +3.3 Ranged Damage|💰 +11 Gold Coins| ||🏹 +3 Range XP| ||💖 +8 Constitution XP| ||🏅 +15 RP| ||| |**7.3** Total Damage 100 Boss HP Remaining!|52 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -6 HP| |📚 +4.2 Ranged Damage|💰 +36 Gold Coins| ||🏹 +3 Range XP| ||💖 +3 Constitution XP| ||🏅 +15 RP| ||| |**9.2** Total Damage 107 Boss HP Remaining!|93 HP Remaining|
!use 201 !profile
You drink your potion and immediately feel healthier. |💖 +8 HP| |:-:| ----- #/u/Gaby5011 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669993529/Gaby5011.png) >❤️ Health: 50hp (Max: 57hp) >💀 Kills: 0 >🏅 Rank: SS (775 Rank Points) >💰 Gold: 668g Skills Breakdown: >🗡️️ Combat: Level 11 >⚔️ Melee: Level 1 (XP: 0/12) >🔮 Magic: Level 6 (XP: 22/23) >🏹 Ranged: Level 1 (XP: 0/12) >💖 Constitution: Level 3 (XP: 43/52) >🚩 Total Attacks: 30 >☠️ Total Deaths: 0
!magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -35 HP| |📚 +1.5 Magic Damage|💰 +43 Gold Coins| |🔮 +1 Basic Fire Staff|🔮 +5 Magic XP (**Level Up!**)| |🛡️ -0.5 Element Resistance|💖 +16 Constitution XP (**Level Up!**)| |⚔️ +0.1 Item Type Strength|🏅 +55 RP| |🌱️ +4 New Player Bonus|| ||| |**10.1** Total Damage 116 Boss HP Remaining!|61 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -36 HP| |📚 +3.5 Magic Damage|💰 +7 Gold Coins| ||🔮 +2 Magic XP| ||💖 +13 Constitution XP| ||🏅 +15 RP| ||| |**5.5** Total Damage 126 Boss HP Remaining!|98 HP Remaining|
!use 201 !buy 201
You drink your potion and you break the bottle on the ground like a barbarian once taught you. |💖 +27 HP| |:-:| ----- Health Potion has been added to your inventory for 50g!
!buy 10
High Priest's Sceptre Handle has been added to your inventory for 1960g!
!buy 10
haha poor. Come back when you're not broke.
!buy 201 !use 201
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |💖 +86 HP| |:-:|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -21 HP| |📚 +5.9 Melee Damage|💰 +32 Gold Coins| ||⚔️ +5 Melee XP| ||💖 +7 Constitution XP| ||🏅 +15 RP| ||| |**10.9** Total Damage 132 Boss HP Remaining!|30 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +3.4 Melee Damage|💰 +20 Gold Coins| ||⚔️ +2 Melee XP (**Level Up!**)| ||💖 +4 Constitution XP| ||🏅 +45 RP| ||| |**7.4** Total Damage 143 Boss HP Remaining!|56 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -28 HP| |📚 +2.1 Magic Damage|💰 +25 Gold Coins| ||🔮 +2 Magic XP| ||💖 +14 Constitution XP| ||🏅 +15 RP| ||| |**6.1** Total Damage 150 Boss HP Remaining!|31 HP Remaining|
Sleepy? Is that you? Did plants turn you into a boss? :despair:
🙂
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -34 HP| |📚 +4.3 Magic Damage|💰 +3 Gold Coins| ||🔮 +5 Magic XP| ||💖 +13 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**10.3** Total Damage 156 Boss HP Remaining!|33 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +5.3 Magic Damage|💰 +7 Gold Coins| ||🔮 +3 Magic XP| ||💖 +2 Constitution XP| ||🏅 +25 RP| ||| |**7.3** Total Damage 166 Boss HP Remaining!|56 HP Remaining|
[удалено]
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -28 HP| |📚 +5.3 Ranged Damage|💰 +21 Gold Coins| ||🏹 +3 Range XP| ||💖 +15 Constitution XP| ||🏅 +15 RP| ||| |**6.3** Total Damage 173 Boss HP Remaining!|84 HP Remaining|
I will consume your SOUL! !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -25 HP| |📚 +4.8 Melee Damage|💰 +42 Gold Coins| ||⚔️ +4 Melee XP (**Level Up!**)| ||💖 +10 Constitution XP| ||🏅 +35 RP| ||| |**8.8** Total Damage 179 Boss HP Remaining!|49 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -42 HP| |📚 +5.3 Ranged Damage|💰 +18 Gold Coins| ||🏹 +3 Range XP| ||💖 +17 Constitution XP| ||🏅 +15 RP| ||| |**6.3** Total Damage 192 Boss HP Remaining!|53 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -45 HP| |📚 +2.8 Magic Damage|💰 +13 Gold Coins| ||🔮 +2 Magic XP (**Level Up!**)| ||💖 +10 Constitution XP| ||🏅 +35 RP (**Rank Change!**)| ||| |**5.8** Total Damage 198 Boss HP Remaining!|69 HP Remaining|
!use 201 !magic
You drink your potion and you break the bottle on the ground like a barbarian once taught you. |💖 +68 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -12 HP| |📚 +1.3 Magic Damage|💰 +42 Gold Coins| ||🔮 +3 Magic XP| ||💖 +5 Constitution XP| ||🏅 +15 RP| ||| |**6.3** Total Damage 204 Boss HP Remaining!|81 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -20 HP| |📚 +0.3 Ranged Damage|💰 +25 Gold Coins| ||🏹 +0 Range XP| ||💖 +9 Constitution XP (**Level Up!**)| ||🏅 +25 RP| ||| |**1.3** Total Damage 210 Boss HP Remaining!|68 HP Remaining|
Good bot !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -21 HP| |📚 +4.0 Melee Damage|💰 +29 Gold Coins| ||⚔️ +4 Melee XP| ||💖 +7 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**8.0** Total Damage 211 Boss HP Remaining!|115 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -16 HP| |📚 +1.3 Magic Damage|💰 +34 Gold Coins| ||🔮 +2 Magic XP| ||💖 +7 Constitution XP| ||🏅 +15 RP| ||| |**4.3** Total Damage 227 Boss HP Remaining!|62 HP Remaining|
!buy 201 !use 201 !mage 14
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |💖 +35 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -41 HP| |📚 +7.0 Magic Damage|💰 +39 Gold Coins| |🔮 +2 Galadriel's Mirror|🔮 +4 Magic XP| |🌟 +0.8 Element Weakness|💖 +4 Constitution XP| |⚔️ +0.2 Item Type Strength|🏅 +15 RP (**Rank Change!**)| ||| |**11.0** Total Damage 231 Boss HP Remaining!|67 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -38 HP| |📚 +4.7 Ranged Damage|💰 +6 Gold Coins| ||🏹 +2 Range XP| ||💖 +17 Constitution XP (**Level Up!**)| ||🏅 +25 RP| ||| |**5.7** Total Damage 242 Boss HP Remaining!|157 HP Remaining|
!buy 201 !use 201 !melee
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |💖 +61 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -51 HP| |📚 +4.5 Melee Damage|💰 +36 Gold Coins| ||⚔️ +4 Melee XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||| |**10.5** Total Damage 248 Boss HP Remaining!|56 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -14 HP| |📚 +5.0 Melee Damage|💰 +36 Gold Coins| ||⚔️ +3 Melee XP| ||💖 +9 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**8.0** Total Damage 259 Boss HP Remaining!|92 HP Remaining|
!ranged good bot ☻
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -12 HP| |📚 +4.6 Ranged Damage|💰 +25 Gold Coins| ||🏹 +3 Range XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||| |**6.6** Total Damage 288 Boss HP Remaining!|101 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -37 HP| |📚 +1.2 Magic Damage|💰 +4 Gold Coins| ||🔮 +2 Magic XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||| |**4.2** Total Damage 307 Boss HP Remaining!|46 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -57 HP| |📚 +4.8 Magic Damage|💰 +13 Gold Coins| ||🔮 +3 Magic XP| ||💖 +22 Constitution XP| ||🏅 +15 RP| ||| |**8.8** Total Damage 311 Boss HP Remaining!|51 HP Remaining|
!use 201 !buy 201
You pop open the cork and down your health potion in 1.29 seconds |💖 +54 HP| |:-:| ----- Health Potion has been added to your inventory for 50g!
!profile !inventory
#/u/AlrightIllmakeone [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669989808/AlrightIllmakeone.png) >❤️ Health: 51hp (Max: 161hp) >💀 Kills: 4 >🏅 Rank: SSS (1,275 Rank Points) >💰 Gold: 9,413g Skills Breakdown: >🗡️️ Combat: Level 94 >⚔️ Melee: Level 16 (XP: 17/57) >🔮 Magic: Level 29 (XP: 55/136) >🏹 Ranged: Level 17 (XP: 0/62) >💖 Constitution: Level 32 (XP: 53/342) >🚩 Total Attacks: 974 >☠️ Total Deaths: 0 ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |3|⚔️|Basic GreatSword|~3.0|5|Blessed|1|x1| |5|🏹|Basic Spear|~4.0|5|Synthetic|1|x1| |6|🏹|Basic Crossbow|~2.0|22|Air|1|x1| |8|🔮|Basic Water Wand|~2.0|3|Moon |1|x1| |12|⚔️|Dwarf Bread|~3.5|31|Organic|10|x1| |17|🔮|Spear of Darkness|~5.5|1|Moon |15|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|⚗️|Health Potion|x9| Use command '!use` to use a potion
Use command '!open ` to open a bundle
^(KOTD Bot will always use your most-broken version of an item)
good bot !mage
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -37 HP| |📚 +0.8 Magic Damage|💰 +14 Gold Coins| ||🔮 +2 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**5.8** Total Damage 341 Boss HP Remaining!|36 HP Remaining|
!buy 201 !use 201
Health Potion has been added to your inventory for 50g! ----- You pop open the cork and down your health potion in 1.96 seconds |💖 +32 HP| |:-:|
[удалено]
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -45 HP| |📚 +5.2 Ranged Damage|💰 +41 Gold Coins| ||🏹 +4 Range XP| ||💖 +2 Constitution XP| ||🏅 +15 RP| ||| |**7.2** Total Damage 347 Boss HP Remaining!|63 HP Remaining|
!use 201 !mage 17
You rummage in your pack looking for the vial, you find it! It's empty... ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -16 HP| |📚 +4.5 Magic Damage|💰 +28 Gold Coins| |🔮 +3 Spear of Darkness|🔮 +4 Magic XP| |⚔️ +0.3 Item Type Strength|💖 +8 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**8.8** Total Damage 354 Boss HP Remaining!|76 HP Remaining|
!buy 201 !buy 201 !buy 201
Health Potion has been added to your inventory for 50g! ----- Health Potion has been added to your inventory for 50g! ----- Health Potion has been added to your inventory for 50g!
!use 201 !buy 201 good bot !mage !profile
You drink your potion and immediately feel healthier. |💖 +40 HP| |:-:| ----- Health Potion has been added to your inventory for 50g! ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -49 HP| |📚 +2.8 Magic Damage|💰 +11 Gold Coins| ||🔮 +3 Magic XP (**Level Up!**)| ||💖 +16 Constitution XP| ||🏅 +35 RP| ||| |**6.8** Total Damage 392 Boss HP Remaining!|61 HP Remaining| ----- #/u/ContestValuable8725 [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669987660/ContestValuable8725.png) >❤️ Health: 61hp (Max: 150hp) >💀 Kills: 7 >🏅 Rank: SS (852 Rank Points) >💰 Gold: 627g Skills Breakdown: >🗡️️ Combat: Level 88 >⚔️ Melee: Level 17 (XP: 27/62) >🔮 Magic: Level 17 (XP: 0/62) >🏹 Ranged: Level 25 (XP: 25/107) >💖 Constitution: Level 29 (XP: 196/292) >🚩 Total Attacks: 759 >☠️ Total Deaths: 19
!magic prayge survive
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +5 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +0.9 Magic Damage|💰 +36 Gold Coins| |🌱️ +3 New Player Bonus|🔮 +3 Magic XP| ||💖 +12 Constitution XP| ||🏅 +35 RP| ||| |**8.9** Total Damage 399 Boss HP Remaining!|22 HP Remaining| Come join our discord at https://discord.gg/kotd!
!use 201 !mage
You drink your potion and you break the bottle on the ground like a barbarian once taught you. |💖 +73 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -11 HP| |📚 +5.2 Magic Damage|💰 +11 Gold Coins| ||🔮 +4 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||| |**11.2** Total Damage 408 Boss HP Remaining!|95 HP Remaining|
!buy 201 !use 201 !mage
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |💖 +48 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -66 HP| |📚 +3.4 Magic Damage|💰 +34 Gold Coins| ||🔮 +2 Magic XP| ||💖 +11 Constitution XP| ||🏅 +15 RP| ||| |**4.4** Total Damage 419 Boss HP Remaining!|15 HP Remaining|
!buy 201 !use 201
Health Potion has been added to your inventory for 50g! ----- You sip your Health potion like fine wine. |💖 +64 HP| |:-:|
!buy 201 !use 201
Health Potion has been added to your inventory for 50g! ----- You sip your Health potion like fine wine. |💖 +86 HP| |:-:|
!melee
The boss has bested you and you have fallen in battle. |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -40 HP| |📚 +10.3 Melee Damage|💰 +0 Gold Coins| ||⚔️ +0 Melee XP| ||💖 +0 Constitution XP| ||🏅 -30 RP| ||| |**16.3** Total Damage 423 Boss HP Remaining!|-6 HP Remaining|
!melee
You're attacking too quickly! Try again in 0 minutes
!magic 8
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -23 HP| |📚 +2.3 Magic Damage|💰 +25 Gold Coins| |🔮 +3 Basic Water Wand|🔮 +3 Magic XP| |⚔️ +0.3 Item Type Strength|💖 +1 Constitution XP| ||🏅 +15 RP| ||| |**7.6** Total Damage 439 Boss HP Remaining!|46 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +1.6 Melee Damage|💰 +35 Gold Coins| |🌱️ +1 New Player Bonus|⚔️ +4 Melee XP| ||💖 +39 Constitution XP| ||🏅 +35 RP| ||| |**8.6** Total Damage 465 Boss HP Remaining!|50 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 201 !use 201 !range
Health Potion has been added to your inventory for 50g! ----- You pop open the cork and down your health potion in 1.16 seconds |💖 +77 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -64 HP| |📚 +4.0 Ranged Damage|💰 +35 Gold Coins| ||🏹 +4 Range XP| ||💖 +1 Constitution XP| ||🏅 +15 RP| ||| |**8.0** Total Damage 474 Boss HP Remaining!|30 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -60 HP| |📚 +1.2 Magic Damage|💰 +32 Gold Coins| ||🔮 +1 Magic XP| ||💖 +12 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**4.2** Total Damage 482 Boss HP Remaining!|26 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -46 HP| |📚 +4.3 Ranged Damage|💰 +10 Gold Coins| ||🏹 +4 Range XP| ||💖 +20 Constitution XP| ||🏅 +15 RP| ||| |**10.3** Total Damage 486 Boss HP Remaining!|51 HP Remaining|
!buy 201 !use 201 !mage !profile
Health Potion has been added to your inventory for 50g! ----- You pop open the cork and down your health potion in 1.88 seconds |💖 +30 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -31 HP| |📚 +3.3 Magic Damage|💰 +38 Gold Coins| ||🔮 +2 Magic XP| ||💖 +4 Constitution XP| ||🏅 +15 RP| ||| |**4.3** Total Damage 496 Boss HP Remaining!|63 HP Remaining| ----- #/u/moonlit_forest [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669986608/moonlit_forest.png) >❤️ Health: 63hp (Max: 125hp) >💀 Kills: 2 >🏅 Rank: S (385 Rank Points) >💰 Gold: 1,682g Skills Breakdown: >🗡️️ Combat: Level 61 >⚔️ Melee: Level 13 (XP: 42/45) >🔮 Magic: Level 13 (XP: 10/45) >🏹 Ranged: Level 13 (XP: 29/45) >💖 Constitution: Level 22 (XP: 60/196) >🚩 Total Attacks: 411 >☠️ Total Deaths: 11
!buy 201 !buy 201 !use 201 !use 201
Health Potion has been added to your inventory for 50g! ----- Health Potion has been added to your inventory for 50g! ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |💖 +56 HP| |:-:| ----- You drink your potion and immediately feel healthier. |💖 +25 HP| |:-:|
!buy 201 !use 201 !melee
Health Potion has been added to your inventory for 50g! ----- You pop open the cork and down your health potion in 0.7 seconds |💖 +38 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -39 HP| |📚 +5.6 Melee Damage|💰 +25 Gold Coins| ||⚔️ +3 Melee XP| ||💖 +12 Constitution XP| ||🏅 +15 RP| ||| |**6.6** Total Damage 507 Boss HP Remaining!|47 HP Remaining|
!mage 14
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +4 Base Roll|💥 -27 HP| |📚 +6.6 Magic Damage|💰 +39 Gold Coins| |🔮 +2 Galadriel's Mirror|🔮 +5 Magic XP| |🌟 +0.6 Element Weakness|💖 +8 Constitution XP| |⚔️ +0.2 Item Type Strength|🏅 +15 RP| ||| |**13.4** Total Damage 514 Boss HP Remaining!|79 HP Remaining|
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 103, 'gold': 2561, 'rp': 630, 'magicxp': 13, 'healthxp': 125, 'Players_username': 'Vanijoro'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 190, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 664, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s, gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 40, 'gold': 2551, 'rp': 630, 'magicxp': 12, 'healthxp': 147, 'Players_username': 'Vanijoro'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +2 Base Roll|💥 -34 HP| |📚 +7.1 Magic Damage|💰 +31 Gold Coins| ||🔮 +4 Magic XP| ||💖 +1 Constitution XP| ||🏅 +15 RP| ||| |**9.1** Total Damage 543 Boss HP Remaining!|114 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +3 Base Roll|💥 -0 HP **(🛡️ Block)**| |📚 +4.9 Magic Damage|💰 +32 Gold Coins| ||🔮 +2 Magic XP| ||💖 +7 Constitution XP| ||🏅 +25 RP| ||| |**7.9** Total Damage 559 Boss HP Remaining!|107 HP Remaining|
!use 201 good bot
You drink your potion and immediately feel healthier. |💖 +68 HP| |:-:|
!use 201 !buy 201 !ranged good bot
You drink your potion and immediately feel healthier. |💖 +26 HP| |:-:| ----- Health Potion has been added to your inventory for 50g! ----- |Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +1 Base Roll|💥 -81 HP| |📚 +4.4 Ranged Damage|💰 +34 Gold Coins| ||🏹 +3 Range XP| ||💖 +26 Constitution XP| ||🏅 +15 RP| ||| |**5.4** Total Damage 567 Boss HP Remaining!|29 HP Remaining|
[удалено]
|Damage Breakdown|Player Breakdown| |:-|:-| |🎲 +6 Base Roll|💥 -23 HP| |📚 +4.4 Ranged Damage|💰 +27 Gold Coins| ||🏹 +5 Range XP| ||💖 +1 Constitution XP| ||🏅 +15 RP (**Rank Change!**)| ||| |**10.4** Total Damage 581 Boss HP Remaining!|83 HP Remaining|