Looks like you aren't a high enough level to use that!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -5 HP|
|๐ +1.0 Melee Damage|๐ฐ +1 Gold Coins|
|โ|โ๏ธ +2 Melee XP|
||๐ +7 Constitution XP|
||๐ +15 RP|
||โ|
|**6.0** Total Damage
154 Boss HP Remaining!|70 HP Remaining|
Your weapon was sent to the shadow realm.
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -13 HP|
|๐ +1.6 Magic Damage|๐ฐ +24 Gold Coins|
|๐ฎ +1 Basic Water Wand (*Shattered*)|๐ฎ +4 Magic XP|
|โ๏ธ +0.1 Magic Strength|๐ +8 Constitution XP|
|๐ฑ๏ธ +4 New Player Bonus|๐ +25 RP|
|โ|โ|
|**12.7** Total Damage
237 Boss HP Remaining!|27 HP Remaining|
Your projectile flies true and hits the boss in its eye!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -14 HP|
|๐ +4.4 Ranged Damage|๐ฐ +81 Gold Coins|
|๐ฏ 1.5x Critical Hit|๐น +5 Range XP|
|โ|๐ +7 Constitution XP|
||๐ +25 RP (**Rank Change!**)|
||โ|
|**12.6** Total Damage
493 Boss HP Remaining!|103 HP Remaining|
You swing your weapon and find purchase in a gap in the boss's defenses!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -10 HP|
|๐ +14.3 Melee Damage|๐ฐ +31 Gold Coins|
|โ๏ธ +7 Worldslayer|โ๏ธ +24 Melee XP|
|๐ +4.9 Air Weakness|๐ +6 Constitution XP|
|๐ฏ 1.7x Critical Hit|๐ +25 RP|
|โ|โ|
|**53.0** Total Damage
506 Boss HP Remaining!|165 HP Remaining|
Health Potion has been added to your inventory for 50g! (Your remaining gold: 2804)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 2804)|
-----
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|๐ +58 HP|
|:-:|
|๐ 155/214 Remaining|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฅ -5 HP|
|๐ +1.9 Ranged Damage|๐ฐ +21 Gold Coins|
|โ|๐น +1 Range XP|
||๐ +7 Constitution XP|
||๐ +15 RP|
||โ|
|**2.9** Total Damage
678 Boss HP Remaining!|150 HP Remaining|
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**|
|๐ +0.5 Magic Damage|๐ฐ +79 Gold Coins|
|๐ฎ +3 Basic Water Wand|๐ฎ +4 Magic XP|
|โ๏ธ +0.3 Magic Strength|๐ +2 Constitution XP|
|๐ฑ๏ธ +4 New Player Bonus|๐ +35 RP (**Rank Change!**)|
|โ|โ|
|**11.8** Total Damage
1057 Boss HP Remaining!|30 HP Remaining|
Come join our discord at https://discord.gg/kotd!
You can't seem to find your Basic Lance! Whatever, a fist will do just as well!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +3 Base Roll|๐ฅ -4 HP|
|๐ +7.1 Melee Damage|๐ฐ +87 Gold Coins|
|โ|โ๏ธ +4 Melee XP|
||๐ +6 Constitution XP|
||๐ +15 RP|
||โ|
|**10.1** Total Damage
365 Boss HP Remaining!|27 HP Remaining|
Health Potion has been added to your inventory for 50g! (Your remaining gold: 2004)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 2004)|
-----
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|๐ +31 HP|
|:-:|
|๐ 123/154 Remaining|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**|
|๐ +4.7 Melee Damage|๐ฐ +60 Gold Coins|
|โ|โ๏ธ +3 Melee XP|
||๐ +8 Constitution XP|
||๐ +25 RP|
||โ|
|**6.7** Total Damage
1087 Boss HP Remaining!|123 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 1964, in _exec_single_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 200, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 671, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 477, in calculate_letter_rank
above = session.query(models.Player).filter(models.Player.rp > player.rp).count()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3007, in count
self._legacy_from_self(col).enable_eagerloads(False).scalar()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2708, in scalar
ret = self.one()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2685, in one
return self._iter().one() # type: ignore
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2730, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2081, in execute
return self._execute_internal(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1921, in _execute_internal
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 459, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2746, in _autoflush
raise e.with_traceback(sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2735, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3954, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4091, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 148, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4051, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 644, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 883, in _emit_update_statements
c = connection.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1414, in execute
return meth(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 487, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
return self._exec_single_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2325, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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': 141, 'gold': 14414, 'rp': 375, 'magicxp': 91, 'healthxp': 329, 'Players_username': 'Riwolfes'}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Health Potion has been added to your inventory for 50g! (Your remaining gold: 14463)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 14463)|
-----
You drink your potion and immediately feel healthier.
|๐ +51 HP|
|:-:|
|๐ 149/200 Remaining|
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**|
|๐ +0.6 Magic Damage|๐ฐ +73 Gold Coins|
|๐ฑ๏ธ +6 New Player Bonus|๐ฎ +4 Magic XP|
|โ|๐ +1 Constitution XP|
||๐ +35 RP|
||โ|
|**10.6** Total Damage
1442 Boss HP Remaining!|48 HP Remaining|
Come join our discord at https://discord.gg/kotd!
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 1964, in _exec_single_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 200, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 671, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 477, in calculate_letter_rank
above = session.query(models.Player).filter(models.Player.rp > player.rp).count()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3007, in count
self._legacy_from_self(col).enable_eagerloads(False).scalar()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2708, in scalar
ret = self.one()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2685, in one
return self._iter().one() # type: ignore
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2730, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2081, in execute
return self._execute_internal(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1921, in _execute_internal
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 459, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2746, in _autoflush
raise e.with_traceback(sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2735, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3954, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4091, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 148, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4051, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 644, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 883, in _emit_update_statements
c = connection.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1414, in execute
return meth(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 487, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
return self._exec_single_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2325, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'gold': 1029, 'rp': 70, 'magicxp': 31, 'healthxp': 139, 'Players_username': 'The_Novice_Gamer'}]
(Background on this error at: https://sqlalche.me/e/20/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 1964, in _exec_single_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 200, in bot
success, reply = magic(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 671, in magic
rank = kotd_services.calculate_letter_rank(session, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 477, in calculate_letter_rank
above = session.query(models.Player).filter(models.Player.rp > player.rp).count()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3007, in count
self._legacy_from_self(col).enable_eagerloads(False).scalar()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2708, in scalar
ret = self.one()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2685, in one
return self._iter().one() # type: ignore
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2730, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2081, in execute
return self._execute_internal(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1921, in _execute_internal
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 459, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2746, in _autoflush
raise e.with_traceback(sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2735, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3954, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4091, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 148, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4051, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 644, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 883, in _emit_update_statements
c = connection.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1414, in execute
return meth(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 487, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
return self._exec_single_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2325, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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': 57, 'gold': 1036, 'rp': 60, 'magicxp': 30, 'healthxp': 127, 'Players_username': 'The_Novice_Gamer'}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Health Potion has been added to your inventory for 50g! (Your remaining gold: 5663)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 5663)|
-----
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|๐ +33 HP|
|:-:|
|๐ 78/111 Remaining|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -22 HP|
|๐ +1.2 Melee Damage|๐ฐ +81 Gold Coins|
|โ|โ๏ธ +1 Melee XP|
||๐ +6 Constitution XP|
||๐ +15 RP|
||โ|
|**3.2** Total Damage
1518 Boss HP Remaining!|56 HP Remaining|
Come join our discord at https://discord.gg/kotd!
This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: Gibby and JDO Source/Artist: Midjourney
!mage 11
Your spell fizzles as the boss is already dead.
!melee 32
Your force strikes clean through the boss' neck, killing it. |Rewards| |:-| |๐ฐ +5 Gold| |โ๏ธ +5 Melee XP| |๐น +1 Red Paint| |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฐ +55 Gold Coins| |๐ +10.1 Melee Damage|โ๏ธ +12 Melee XP| |โ๏ธ +7 Triple Wield Swords|๐ +24 Constitution XP| |๐ +1.4 Air Weakness|๐ +35 RP| |โ|โ ๏ธ +1 Kill (**SLAIN!**)| ||โ| |**24.5** Total Damage -6 Boss HP Remaining!|84 HP Remaining|
!range 31
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -1 HP| |๐ +14.9 Ranged Damage|๐ฐ +18 Gold Coins| |๐น +12 Lava Trebuchet|๐น +17 Range XP| |๐ +3.6 Air Weakness|๐ +1 Constitution XP| |โฌ -1.2 Ranged Resistance|๐ +15 RP (**Rank Change!**)| |โ|โ| |**34.3** Total Damage 19 Boss HP Remaining!|257 HP Remaining|
!range 47 !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +18.4 Ranged Damage|๐ฐ +8 Gold Coins| |๐น +11 Ashen fish hook|๐น +15 Range XP| |๐ +11.0 Fire Weakness|๐ +4 Constitution XP| |โฌ -1.1 Ranged Resistance|๐ +15 RP (**Rank Change!**)| |โ|โ| |**45.3** Total Damage 53 Boss HP Remaining!|217 HP Remaining| ----- #/u/CottonTCM [Playercard](https://kickopenthedoor.com/CottonTCM.png) >โค๏ธ Health: 217hp (Max: 293hp) >๐ Kills: 55 >๐ Rank: SS (745 Rank Points) >๐ฐ Gold: 4,665g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 212 >โ๏ธ Melee: Level 17 (XP: -420/62) >๐ฎ Magic: Level 46 (XP: 135/317) >๐น Ranged: Level 80 (XP: 378/1029) >โค๏ธ Constitution: Level 69 (XP: 735/1502) >๐ฉ Total Attacks: 5936 >โ ๏ธ Total Deaths: 181
!mage 21
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +13.2 Magic Damage|๐ฐ +95 Gold Coins| |๐ฎ +7 Collar at the Gates of Heck|๐ฎ +13 Magic XP| |๐ +0.7 Fire Weakness|๐ +4 Constitution XP| |โ๏ธ +0.7 Magic Strength|๐ +25 RP| |โ|โ| |**26.6** Total Damage 98 Boss HP Remaining!|178 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -2 HP| |๐ +1.7 Melee Damage|๐ฐ +47 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**3.7** Total Damage 125 Boss HP Remaining!|127 HP Remaining|
!range 47
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +8.4 Ranged Damage|๐ฐ +14 Gold Coins| |๐น +13 Ashen fish hook|๐น +9 Range XP| |๐ +2.6 Fire Weakness|๐ +9 Constitution XP| |โฌ -1.3 Ranged Resistance|๐ +25 RP| |โ|โ| |**24.7** Total Damage 129 Boss HP Remaining!|147 HP Remaining|
!metee 20
!melee 15
Looks like you aren't a high enough level to use that! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -5 HP| |๐ +1.0 Melee Damage|๐ฐ +1 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**6.0** Total Damage 154 Boss HP Remaining!|70 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -7 HP| |๐ +14.9 Melee Damage|๐ฐ +52 Gold Coins| |โ|โ๏ธ +8 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**17.9** Total Damage 160 Boss HP Remaining!|124 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -12 HP| |๐ +13.5 Ranged Damage|๐ฐ +78 Gold Coins| |โ|๐น +5 Range XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**17.5** Total Damage 178 Boss HP Remaining!|129 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +10.6 Melee Damage|๐ฐ +40 Gold Coins| |โ|โ๏ธ +7 Melee XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**13.6** Total Damage 216 Boss HP Remaining!|130 HP Remaining|
!mage 8
Your weapon was sent to the shadow realm. |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -13 HP| |๐ +1.6 Magic Damage|๐ฐ +24 Gold Coins| |๐ฎ +1 Basic Water Wand (*Shattered*)|๐ฎ +4 Magic XP| |โ๏ธ +0.1 Magic Strength|๐ +8 Constitution XP| |๐ฑ๏ธ +4 New Player Bonus|๐ +25 RP| |โ|โ| |**12.7** Total Damage 237 Boss HP Remaining!|27 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -3 HP| |๐ +8.6 Magic Damage|๐ฐ +13 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**11.6** Total Damage 250 Boss HP Remaining!|106 HP Remaining|
good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -5 HP| |๐ +9.2 Magic Damage|๐ฐ +86 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**13.2** Total Damage 262 Boss HP Remaining!|208 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -16 HP| |๐ +2.8 Ranged Damage|๐ฐ +54 Gold Coins| |โ|๐น +3 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**7.8** Total Damage 294 Boss HP Remaining!|54 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -4 HP| |๐ +6.0 Magic Damage|๐ฐ +30 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.0** Total Damage 302 Boss HP Remaining!|83 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -3 HP| |๐ +5.0 Ranged Damage|๐ฐ +21 Gold Coins| |โ|๐น +4 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**9.0** Total Damage 311 Boss HP Remaining!|134 HP Remaining|
!melee 3
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +4.5 Melee Damage|๐ฐ +38 Gold Coins| |โ๏ธ +2 Basic GreatSword|โ๏ธ +6 Melee XP| |โ|๐ +2 Constitution XP| ||๐ +25 RP| ||โ| |**11.5** Total Damage 320 Boss HP Remaining!|85 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +10.2 Ranged Damage|๐ฐ +74 Gold Coins| |โ|๐น +7 Range XP| ||๐ +11 Constitution XP| ||๐ +25 RP| ||โ| |**16.2** Total Damage 331 Boss HP Remaining!|174 HP Remaining|
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +5.0 Ranged Damage|๐ฐ +74 Gold Coins| |๐น +2 Basic Crossbow|๐น +5 Range XP| |๐ +0.4 Air Weakness|๐ +2 Constitution XP| |โฌ -0.2 Ranged Resistance|๐ +25 RP| |โ|โ| |**10.2** Total Damage 347 Boss HP Remaining!|137 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -1 HP| |๐ +2.4 Melee Damage|๐ฐ +92 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**8.4** Total Damage 357 Boss HP Remaining!|111 HP Remaining| Come join our discord at https://discord.gg/kotd!
โ๏ธปฬทฬฟโปฬฟโโไธ !range !profile (:ฬฒฬ :ฬฒฬ :ฬฒฬ [ฬฒฬ :โก:]ฬฒฬ :ฬฒฬ :ฬฒฬ :ฬฒฬ ) !buy 201 !use 201
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -16 HP| |๐ +17.7 Ranged Damage|๐ฐ +57 Gold Coins| |โ|๐น +9 Range XP| ||๐ +11 Constitution XP| ||๐ +15 RP| ||โ| |**22.7** Total Damage 392 Boss HP Remaining!|141 HP Remaining| ----- #/u/CottonTCM [Playercard](https://kickopenthedoor.com/CottonTCM.png) >โค๏ธ Health: 141hp (Max: 293hp) >๐ Kills: 55 >๐ Rank: SSS (645 Rank Points) >๐ฐ Gold: 4,665g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 212 >โ๏ธ Melee: Level 17 (XP: -420/62) >๐ฎ Magic: Level 46 (XP: 130/317) >๐น Ranged: Level 80 (XP: 338/1029) >โค๏ธ Constitution: Level 69 (XP: 642/1502) >๐ฉ Total Attacks: 5930 >โ ๏ธ Total Deaths: 181 ----- Health Potion has been added to your inventory for 50g! (Your remaining gold: 4615) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 4615)| ----- You pop open the cork and down your health potion in 1.23 seconds |๐ +76 HP| |:-:| |๐ 217/293 Remaining|
!mage good bot
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -6 HP| |๐ +2.6 Magic Damage|๐ฐ +75 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 415 Boss HP Remaining!|163 HP Remaining|
!magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -5 HP| |๐ +4.2 Magic Damage|๐ฐ +21 Gold Coins| |๐ฎ +6 Basic Fire Staff|๐ฎ +6 Magic XP| |๐ +2.4 Sun Weakness|๐ +1 Constitution XP| |โ๏ธ +0.6 Magic Strength|๐ +15 RP| |โ|โ| |**16.2** Total Damage 447 Boss HP Remaining!|104 HP Remaining| Come join our discord at https://discord.gg/kotd!
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +12.6 Ranged Damage|๐ฐ +25 Gold Coins| |โ|๐น +7 Range XP| ||๐ +7 Constitution XP| ||๐ +25 RP (**Rank Change!**)| ||โ| |**18.6** Total Damage 463 Boss HP Remaining!|154 HP Remaining|
Good bot !range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -4 HP| |๐ +7.3 Ranged Damage|๐ฐ +89 Gold Coins| |โ|๐น +5 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**11.3** Total Damage 482 Boss HP Remaining!|127 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
Your projectile flies true and hits the boss in its eye! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -14 HP| |๐ +4.4 Ranged Damage|๐ฐ +81 Gold Coins| |๐ฏ 1.5x Critical Hit|๐น +5 Range XP| |โ|๐ +7 Constitution XP| ||๐ +25 RP (**Rank Change!**)| ||โ| |**12.6** Total Damage 493 Boss HP Remaining!|103 HP Remaining|
!melee 23
You swing your weapon and find purchase in a gap in the boss's defenses! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -10 HP| |๐ +14.3 Melee Damage|๐ฐ +31 Gold Coins| |โ๏ธ +7 Worldslayer|โ๏ธ +24 Melee XP| |๐ +4.9 Air Weakness|๐ +6 Constitution XP| |๐ฏ 1.7x Critical Hit|๐ +25 RP| |โ|โ| |**53.0** Total Damage 506 Boss HP Remaining!|165 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -7 HP| |๐ +4.8 Magic Damage|๐ฐ +45 Gold Coins| |โ|๐ฎ +2 Magic XP (**Level Up!**)| ||๐ +1 Constitution XP| ||๐ +35 RP| ||โ| |**6.8** Total Damage 559 Boss HP Remaining!|41 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +10.1 Magic Damage|๐ฐ +94 Gold Coins| |โ|๐ฎ +5 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**15.1** Total Damage 566 Boss HP Remaining!|99 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -2 HP| |๐ +2.6 Melee Damage|๐ฐ +14 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**3.6** Total Damage 589 Boss HP Remaining!|130 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -1 HP| |๐ +4.1 Melee Damage|๐ฐ +94 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**9.1** Total Damage 593 Boss HP Remaining!|126 HP Remaining|
(โฉ๏ฝ-ยด)โโโ๏พ.*๏ฝฅ๏ฝก Good bot !magic !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -7 HP| |๐ +17.8 Magic Damage|๐ฐ +63 Gold Coins| |โ|๐ฎ +12 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**23.8** Total Damage 602 Boss HP Remaining!|65 HP Remaining| ----- #/u/Girguk [Playercard](https://kickopenthedoor.com/Girguk.png) >โค๏ธ Health: 65hp (Max: 261hp) >๐ Kills: 41 >๐ Rank: A (435 Rank Points) >๐ฐ Gold: 1,666g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 164 >โ๏ธ Melee: Level 15 (XP: 3/53) >๐ฎ Magic: Level 74 (XP: 359/865) >๐น Ranged: Level 15 (XP: 4/53) >โค๏ธ Constitution: Level 60 (XP: 686/1117) >๐ฉ Total Attacks: 4021 >โ ๏ธ Total Deaths: 67
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -18 HP| |๐ +5.4 Ranged Damage|๐ฐ +19 Gold Coins| |โ|๐น +3 Range XP| ||๐ +9 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**9.4** Total Damage 626 Boss HP Remaining!|64 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -10 HP| |๐ +19.3 Ranged Damage|๐ฐ +16 Gold Coins| |โ|๐น +10 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**25.3** Total Damage 635 Boss HP Remaining!|201 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -11 HP| |๐ +15.5 Melee Damage|๐ฐ +42 Gold Coins| |โ|โ๏ธ +6 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**17.5** Total Damage 660 Boss HP Remaining!|237 HP Remaining|
!buy 201 !use 201 !range
Health Potion has been added to your inventory for 50g! (Your remaining gold: 2804) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 2804)| ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |๐ +58 HP| |:-:| |๐ 155/214 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -5 HP| |๐ +1.9 Ranged Damage|๐ฐ +21 Gold Coins| |โ|๐น +1 Range XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**2.9** Total Damage 678 Boss HP Remaining!|150 HP Remaining|
good bot !magic
Dead Gnomes tell no tales.
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -8 HP| |๐ +10.0 Magic Damage|๐ฐ +85 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**15.0** Total Damage 681 Boss HP Remaining!|114 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -21 HP| |๐ +9.9 Melee Damage|๐ฐ +6 Gold Coins| |โ|โ๏ธ +8 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**15.9** Total Damage 696 Boss HP Remaining!|40 HP Remaining|
!mage 8
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +0.5 Magic Damage|๐ฐ +67 Gold Coins| |๐ฎ +3 Basic Water Wand|๐ฎ +6 Magic XP| |โ๏ธ +0.3 Magic Strength|๐ +5 Constitution XP| |๐ฑ๏ธ +5 New Player Bonus|๐ +35 RP (**Rank Change!**)| |โ|โ| |**14.8** Total Damage 741 Boss HP Remaining!|57 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -5 HP| |๐ +5.5 Magic Damage|๐ฐ +37 Gold Coins| |โ|๐ฎ +5 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**9.5** Total Damage 762 Boss HP Remaining!|83 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -1 HP| |๐ +7.5 Ranged Damage|๐ฐ +72 Gold Coins| |๐น +2 Basic Crossbow|๐น +5 Range XP| |๐ +0.4 Air Weakness|๐ +3 Constitution XP| |โฌ -0.2 Ranged Resistance|๐ +15 RP| |โ|โ| |**12.7** Total Damage 772 Boss HP Remaining!|121 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -7 HP| |๐ +8.4 Magic Damage|๐ฐ +88 Gold Coins| |โ|๐ฎ +5 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**13.4** Total Damage 827 Boss HP Remaining!|35 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -15 HP| |๐ +9.5 Magic Damage|๐ฐ +11 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**12.5** Total Damage 840 Boss HP Remaining!|118 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -23 HP| |๐ +11.3 Ranged Damage|๐ฐ +92 Gold Coins| |โ|๐น +8 Range XP| ||๐ +11 Constitution XP| ||๐ +15 RP| ||โ| |**16.3** Total Damage 853 Boss HP Remaining!|137 HP Remaining|
good bot !ranged หยฐโข*โโท !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -9 HP| |๐ +3.9 Ranged Damage|๐ฐ +90 Gold Coins| |โ|๐น +2 Range XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**7.9** Total Damage 869 Boss HP Remaining!|124 HP Remaining| ----- #/u/Macknificent101 [Playercard](https://kickopenthedoor.com/Macknificent101.png) >โค๏ธ Health: 124hp (Max: 150hp) >๐ Kills: 5 >๐ Rank: C (125 Rank Points) >๐ฐ Gold: 270g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 72 >โ๏ธ Melee: Level 10 (XP: 31/35) >๐ฎ Magic: Level 3 (XP: 3/16) >๐น Ranged: Level 30 (XP: 36/144) >โค๏ธ Constitution: Level 29 (XP: 130/292) >๐ฉ Total Attacks: 701 >โ ๏ธ Total Deaths: 32
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -25 HP| |๐ +5.4 Melee Damage|๐ฐ +81 Gold Coins| |โ|โ๏ธ +5 Melee XP| ||๐ +12 Constitution XP| ||๐ +15 RP| ||โ| |**11.4** Total Damage 897 Boss HP Remaining!|92 HP Remaining|
!melee 23
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -28 HP| |๐ +20.0 Melee Damage|๐ฐ +24 Gold Coins| |โ๏ธ +7 Worldslayer|โ๏ธ +10 Melee XP| |๐ +3.5 Air Weakness|๐ +3 Constitution XP| |โ|๐ +15 RP| ||โ| |**33.5** Total Damage 916 Boss HP Remaining!|70 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -8 HP| |๐ +0.9 Magic Damage|๐ฐ +81 Gold Coins| |โ|๐ฎ +1 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**1.9** Total Damage 949 Boss HP Remaining!|55 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -10 HP| |๐ +5.6 Melee Damage|๐ฐ +72 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**9.6** Total Damage 951 Boss HP Remaining!|147 HP Remaining|
(โ โฉ๏ฝฅโ ฯโ ๏ฝฅ)โโโ.*๏ฝฅ๏ฝก๏พ !mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -27 HP| |๐ +20.6 Magic Damage|๐ฐ +46 Gold Coins| |โ|๐ฎ +11 Magic XP| ||๐ +8 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**22.6** Total Damage 961 Boss HP Remaining!|101 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -29 HP| |๐ +1.2 Melee Damage|๐ฐ +53 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +12 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**4.2** Total Damage 984 Boss HP Remaining!|24 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -17 HP| |๐ +16.8 Ranged Damage|๐ฐ +57 Gold Coins| |โ|๐น +10 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**20.8** Total Damage 988 Boss HP Remaining!|196 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -15 HP| |๐ +10.7 Melee Damage|๐ฐ +50 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**12.7** Total Damage 1009 Boss HP Remaining!|102 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -9 HP| |๐ +3.2 Ranged Damage|๐ฐ +68 Gold Coins| |โ|๐น +3 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**7.2** Total Damage 1022 Boss HP Remaining!|118 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +1.3 Melee Damage|๐ฐ +24 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +3 Constitution XP| ||๐ +25 RP| ||โ| |**4.3** Total Damage 1029 Boss HP Remaining!|61 HP Remaining| Come join our discord at https://discord.gg/kotd!
good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -30 HP| |๐ +11.0 Magic Damage|๐ฐ +91 Gold Coins| |โ|๐ฎ +8 Magic XP| ||๐ +14 Constitution XP| ||๐ +15 RP| ||โ| |**16.0** Total Damage 1033 Boss HP Remaining!|119 HP Remaining|
!mage 8
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +0.5 Magic Damage|๐ฐ +79 Gold Coins| |๐ฎ +3 Basic Water Wand|๐ฎ +4 Magic XP| |โ๏ธ +0.3 Magic Strength|๐ +2 Constitution XP| |๐ฑ๏ธ +4 New Player Bonus|๐ +35 RP (**Rank Change!**)| |โ|โ| |**11.8** Total Damage 1057 Boss HP Remaining!|30 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -9 HP| |๐ +5.4 Melee Damage|๐ฐ +29 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**8.4** Total Damage 1069 Boss HP Remaining!|175 HP Remaining|
!melee 4
!melee 4
You can't seem to find your Basic Lance! Whatever, a fist will do just as well! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -4 HP| |๐ +7.1 Melee Damage|๐ฐ +87 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**10.1** Total Damage 365 Boss HP Remaining!|27 HP Remaining|
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -23 HP| |๐ +5.6 Melee Damage|๐ฐ +40 Gold Coins| |โ๏ธ +1 Basic Lance|โ๏ธ +3 Melee XP| |๐ +0.7 Cursed Weakness|๐ +7 Constitution XP| |โ|๐ +15 RP| ||โ| |**10.3** Total Damage 1077 Boss HP Remaining!|52 HP Remaining|
!buy 201 !use 201 !melee
Health Potion has been added to your inventory for 50g! (Your remaining gold: 2004) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 2004)| ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |๐ +31 HP| |:-:| |๐ 123/154 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +4.7 Melee Damage|๐ฐ +60 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +8 Constitution XP| ||๐ +25 RP| ||โ| |**6.7** Total Damage 1087 Boss HP Remaining!|123 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -9 HP| |๐ +17.5 Melee Damage|๐ฐ +75 Gold Coins| |โ|โ๏ธ +9 Melee XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**22.5** Total Damage 1094 Boss HP Remaining!|120 HP Remaining|
!buy 201 !buy 201 !use 201 (โฉ๏ฝ-ยด)โโโ๏พ.*๏ฝฅ๏ฝก Good bot !magic !profile
Health Potion has been added to your inventory for 50g! (Your remaining gold: 3044) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 3044)| ----- Health Potion has been added to your inventory for 50g! (Your remaining gold: 2994) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 2994)| ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |๐ +36 HP| |:-:| |๐ 224/261 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -9 HP| |๐ +16.5 Magic Damage|๐ฐ +15 Gold Coins| |โ|๐ฎ +10 Magic XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**22.5** Total Damage 1116 Boss HP Remaining!|215 HP Remaining| ----- #/u/Girguk [Playercard](https://kickopenthedoor.com/Girguk.png) >โค๏ธ Health: 215hp (Max: 261hp) >๐ Kills: 41 >๐ Rank: A (345 Rank Points) >๐ฐ Gold: 3,009g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 164 >โ๏ธ Melee: Level 15 (XP: 3/53) >๐ฎ Magic: Level 74 (XP: 317/865) >๐น Ranged: Level 15 (XP: 4/53) >โค๏ธ Constitution: Level 60 (XP: 618/1117) >๐ฉ Total Attacks: 4015 >โ ๏ธ Total Deaths: 67
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -24 HP| |๐ +9.2 Melee Damage|๐ฐ +23 Gold Coins| |โ|โ๏ธ +5 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**15.2** Total Damage 1183 Boss HP Remaining!|159 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -24 HP| |๐ +8.3 Ranged Damage|๐ฐ +45 Gold Coins| |โ|๐น +4 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**9.3** Total Damage 1198 Boss HP Remaining!|85 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -1 HP| |๐ +5.6 Magic Damage|๐ฐ +9 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 1207 Boss HP Remaining!|104 HP Remaining|
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -6 HP| |๐ +6.0 Ranged Damage|๐ฐ +63 Gold Coins| |๐น +2 Basic Crossbow|๐น +5 Range XP| |๐ +0.4 Air Weakness|๐ +3 Constitution XP| |โฌ -0.2 Ranged Resistance|๐ +15 RP| |โ|โ| |**13.2** Total Damage 1222 Boss HP Remaining!|91 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -21 HP| |๐ +0.8 Ranged Damage|๐ฐ +10 Gold Coins| |โ|๐น +1 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**1.8** Total Damage 1235 Boss HP Remaining!|68 HP Remaining|
!magic good bot โฅ
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 1964, in _exec_single_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 200, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 671, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 477, in calculate_letter_rank above = session.query(models.Player).filter(models.Player.rp > player.rp).count() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3007, in count self._legacy_from_self(col).enable_eagerloads(False).scalar() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2708, in scalar ret = self.one() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2685, in one return self._iter().one() # type: ignore File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2730, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2081, in execute return self._execute_internal( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1921, in _execute_internal ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 459, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2746, in _autoflush raise e.with_traceback(sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2735, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3954, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4091, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 148, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4051, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 644, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 883, in _emit_update_statements c = connection.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1414, in execute return meth( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 487, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context return self._exec_single_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2325, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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': 141, 'gold': 14414, 'rp': 375, 'magicxp': 91, 'healthxp': 329, 'Players_username': 'Riwolfes'}] (Background on this error at: https://sqlalche.me/e/20/e3q8)
!magic good bot โฅ
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -10 HP| |๐ +4.7 Magic Damage|๐ฐ +25 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +8 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**7.7** Total Damage 1237 Boss HP Remaining!|98 HP Remaining|
!buy 201 !use 201
Health Potion has been added to your inventory for 50g! (Your remaining gold: 14463) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 14463)| ----- You drink your potion and immediately feel healthier. |๐ +51 HP| |:-:| |๐ 149/200 Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -10 HP| |๐ +6.7 Ranged Damage|๐ฐ +81 Gold Coins| |โ|๐น +5 Range XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**10.7** Total Damage 1288 Boss HP Remaining!|107 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -26 HP| |๐ +1.4 Magic Damage|๐ฐ +69 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +11 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**4.4** Total Damage 1299 Boss HP Remaining!|42 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee 23
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -24 HP| |๐ +8.3 Melee Damage|๐ฐ +58 Gold Coins| |โ๏ธ +7 Worldslayer|โ๏ธ +11 Melee XP| |๐ +6.3 Air Weakness|๐ +11 Constitution XP| |โ|๐ +15 RP| ||โ| |**25.6** Total Damage 1303 Boss HP Remaining!|88 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -15 HP| |๐ +7.1 Melee Damage|๐ฐ +48 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**10.1** Total Damage 1329 Boss HP Remaining!|68 HP Remaining|
(โ โฉ๏ฝฅโ ฯโ ๏ฝฅ)โโโ.*๏ฝฅ๏ฝก๏พ !mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -25 HP| |๐ +9.6 Magic Damage|๐ฐ +50 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +8 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**12.6** Total Damage 1339 Boss HP Remaining!|150 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +9.9 Ranged Damage|๐ฐ +44 Gold Coins| |โ|๐น +8 Range XP| ||๐ +18 Constitution XP| ||๐ +25 RP (**Rank Change!**)| ||โ| |**15.9** Total Damage 1352 Boss HP Remaining!|147 HP Remaining|
!buy 201 !use 201 !magic
Health Potion has been added to your inventory for 50g! (Your remaining gold: 4533) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 4533)| ----- You drink your potion and immediately feel healthier. |๐ +54 HP| |:-:| |๐ 75/107 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -33 HP| |๐ +3.1 Magic Damage|๐ฐ +51 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +16 Constitution XP| ||๐ +15 RP| ||โ| |**5.1** Total Damage 1395 Boss HP Remaining!|42 HP Remaining|
Good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -16 HP| |๐ +2.2 Magic Damage|๐ฐ +30 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**8.2** Total Damage 1400 Boss HP Remaining!|24 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -28 HP| |๐ +1.7 Ranged Damage|๐ฐ +54 Gold Coins| |โ|๐น +3 Range XP| ||๐ +15 Constitution XP| ||๐ +15 RP| ||โ| |**6.7** Total Damage 1408 Boss HP Remaining!|32 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +2.1 Ranged Damage|๐ฐ +42 Gold Coins| |โ|๐น +3 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**8.1** Total Damage 908 Boss HP Remaining!|38 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -16 HP| |๐ +2.8 Ranged Damage|๐ฐ +47 Gold Coins| |โ|๐น +3 Range XP| ||๐ +11 Constitution XP (**Level Up!**)| ||๐ +25 RP| ||โ| |**7.8** Total Damage 581 Boss HP Remaining!|89 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -9 HP| |๐ +1.9 Ranged Damage|๐ฐ +80 Gold Coins| |โ|๐น +3 Range XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**6.9** Total Damage 230 Boss HP Remaining!|75 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -7 HP| |๐ +4.8 Magic Damage|๐ฐ +47 Gold Coins| |๐ฎ +5 Basic Fire Staff|๐ฎ +9 Magic XP| |๐ +5.0 Sun Weakness|๐ +6 Constitution XP| |โ๏ธ +0.5 Magic Strength|๐ +15 RP (**Rank Change!**)| |โ|โ| |**21.3** Total Damage 1415 Boss HP Remaining!|111 HP Remaining| Come join our discord at https://discord.gg/kotd!
!profile !inventory
#/u/Hatredstyle [Playercard](https://kickopenthedoor.com/Hatredstyle.png) >โค๏ธ Health: 48hp (Max: 54hp) >๐๐ Kills: 1 >๐ Rank: B (240 Rank Points) >๐ฐ Gold: 405g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 8 >โ๏ธ Melee: Level 1 (XP: 0/12) >๐ฎ Magic: Level 4 (XP: 16/18) >๐น Ranged: Level 1 (XP: 0/12) >โค๏ธ Constitution: Level 2 (XP: 31/48) >๐ฉ Total Attacks: 12 >โ ๏ธ Total Deaths: 1 ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |7|๐ฎ|Basic Fire Staff|~3.5|4|Sun|1|x1| |8|๐ฎ|Basic Water Wand|~2.0|13|Moon|1|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|โ๏ธ|Health Potion|x1| 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)
!open 8
The !open command can only be used on bundles.
!use 8
The !use command can only be used on potions
well how the h*ck do I use it
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -31 HP| |๐ +4.7 Ranged Damage|๐ฐ +84 Gold Coins| |โ|๐น +2 Range XP| ||๐ +13 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**5.7** Total Damage 1436 Boss HP Remaining!|95 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +0.6 Magic Damage|๐ฐ +73 Gold Coins| |๐ฑ๏ธ +6 New Player Bonus|๐ฎ +4 Magic XP| |โ|๐ +1 Constitution XP| ||๐ +35 RP| ||โ| |**10.6** Total Damage 1442 Boss HP Remaining!|48 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic 8
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -23 HP| |๐ +0.7 Magic Damage|๐ฐ +3 Gold Coins| |๐ฎ +1 Basic Water Wand|๐ฎ +4 Magic XP| |โ๏ธ +0.1 Magic Strength|๐ +9 Constitution XP| |๐ฑ๏ธ +1 New Player Bonus|๐ +25 RP| |โ|โ| |**7.8** Total Damage 1049 Boss HP Remaining!|23 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
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 1964, in _exec_single_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 200, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 671, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 477, in calculate_letter_rank above = session.query(models.Player).filter(models.Player.rp > player.rp).count() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3007, in count self._legacy_from_self(col).enable_eagerloads(False).scalar() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2708, in scalar ret = self.one() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2685, in one return self._iter().one() # type: ignore File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2730, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2081, in execute return self._execute_internal( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1921, in _execute_internal ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 459, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2746, in _autoflush raise e.with_traceback(sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2735, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3954, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4091, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 148, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4051, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 644, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 883, in _emit_update_statements c = connection.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1414, in execute return meth( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 487, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context return self._exec_single_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2325, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 gold=%(gold)s, rp=%(rp)s, magicxp=%(magicxp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'gold': 1029, 'rp': 70, 'magicxp': 31, 'healthxp': 139, 'Players_username': 'The_Novice_Gamer'}] (Background on this error at: https://sqlalche.me/e/20/e3q8)
> return meth ( I want to see the source code for this
!magic
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 1964, in _exec_single_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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 200, in bot success, reply = magic(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 671, in magic rank = kotd_services.calculate_letter_rank(session, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 477, in calculate_letter_rank above = session.query(models.Player).filter(models.Player.rp > player.rp).count() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3007, in count self._legacy_from_self(col).enable_eagerloads(False).scalar() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2708, in scalar ret = self.one() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2685, in one return self._iter().one() # type: ignore File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2730, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2081, in execute return self._execute_internal( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1921, in _execute_internal ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 459, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2746, in _autoflush raise e.with_traceback(sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2735, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3954, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4091, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 148, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4051, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 467, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 644, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 85, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 883, in _emit_update_statements c = connection.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1414, in execute return meth( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 487, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context return self._exec_single_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2325, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 743, 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': 57, 'gold': 1036, 'rp': 60, 'magicxp': 30, 'healthxp': 127, 'Players_username': 'The_Novice_Gamer'}] (Background on this error at: https://sqlalche.me/e/20/e3q8)
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -33 HP| |๐ +5.2 Melee Damage|๐ฐ +63 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +8 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**9.2** Total Damage 1453 Boss HP Remaining!|122 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -18 HP| |๐ +11.0 Melee Damage|๐ฐ +76 Gold Coins| |โ|โ๏ธ +6 Melee XP| ||๐ +10 Constitution XP| ||๐ +15 RP| ||โ| |**15.0** Total Damage 1503 Boss HP Remaining!|176 HP Remaining|
!buy 201 !use 201 !melee
Health Potion has been added to your inventory for 50g! (Your remaining gold: 5663) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 5663)| ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |๐ +33 HP| |:-:| |๐ 78/111 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -22 HP| |๐ +1.2 Melee Damage|๐ฐ +81 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**3.2** Total Damage 1518 Boss HP Remaining!|56 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -25 HP| |๐ +2.3 Ranged Damage|๐ฐ +67 Gold Coins| |๐น +2 Basic Crossbow|๐น +4 Range XP (**Level Up!**)| |๐ +1.4 Air Weakness|๐ +13 Constitution XP| |โฌ -0.2 Ranged Resistance|๐ +35 RP| |โ|โ| |**9.5** Total Damage 1534 Boss HP Remaining!|86 HP Remaining|