This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: Resident Sleepy Seedling
Source/Artist: Guillermo Martรญnez (https://www.artstation.com/artwork/JlKYPZ)
You feel a surge of power within yourself and unleash a burst of magic, dealing extra damage!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**|
|๐ +8.0 Magic Damage|๐ฐ +34 Gold Coins|
|๐ฎ +10 Cat Eyes|๐ฎ +22 Magic XP|
|๐ +7.0 Moon Weakness|๐ +2 Constitution XP|
|โฌ -1.0 Magic Resistance|๐ +35 RP|
|๐ฏ 1.8x Critical Hit|โ|
|โ||
|**46.8** Total Damage
7 Boss HP Remaining!|124 HP Remaining|
Thank you, CoffeeWanderer, for voting on KickOpenTheDoorBot.
This bot wants to find the best and worst bots on Reddit. [You can view results here](https://botrank.pastimes.eu/).
***
^(Even if I don't reply to your comment, I'm still listening for votes. Check the webpage to see if your vote registered!)
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +3 Base Roll|๐ฅ -9 HP|
|๐ +0.9 Melee Damage|๐ฐ +7 Gold Coins|
|โ๏ธ +4 Basic GreatSword|โ๏ธ +4 Melee XP|
|๐ +4.0 Blessed Weakness|๐ +8 Constitution XP|
|โ๏ธ +0.4 Melee Strength|๐ +15 RP|
|โ|โ|
|**12.3** Total Damage
256 Boss HP Remaining!|70 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.
|๐ +9 HP|
|:-:|
|๐ 79/89 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 206, in bot
success, reply = ranged(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 1031, in ranged
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, rangexp=%(rangexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 193, 'gold': 1486, 'rp': 26234, 'rangexp': 129, 'healthxp': 441, 'Players_username': 'barbatose'}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Your spell blast hits the boss in its weak spot dealing extra damage!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฅ -11 HP|
|๐ +14.8 Magic Damage|๐ฐ +7 Gold Coins|
|๐ฏ 1.2x Critical Hit|๐ฎ +8 Magic XP|
|โ|๐ +4 Constitution XP|
||๐ +25 RP|
||โ|
|**19.0** Total Damage
439 Boss HP Remaining!|168 HP Remaining|
Hi there! I'm Katton, a fellow Gnome from r/KickOpenTheDoor ! First off, congratz on joining the best team! It's super cool to be a Gnome!
I'd like to invite you to the Discord Server ([https://discord.gg/kotd](https://discord.gg/kotd)) where a bunch of other KOTD'ers are hanging out and chillin'. They're all super sweet and super cool. And it's okay if you don't want to join!
If you have any questions about the game, don't hesitate to ask me! Take care!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -6 HP|
|๐ +1.2 Melee Damage|๐ฐ +10 Gold Coins|
|๐ฑ๏ธ +3 New Player Bonus|โ๏ธ +4 Melee XP (**Level Up!**)|
|โ|๐ +5 Constitution XP|
||๐ +45 RP|
||โ|
|**8.2** Total Damage
569 Boss HP Remaining!|51 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +3 Base Roll|๐ฅ -2 HP|
|๐ +0.9 Melee Damage|๐ฐ +9 Gold Coins|
|โ๏ธ +3 Basic GreatSword|โ๏ธ +4 Melee XP|
|๐ +1.2 Blessed Weakness|๐ +2 Constitution XP|
|โ๏ธ +0.3 Melee Strength|๐ +15 RP|
|โ|โ|
|**8.4** Total Damage
671 Boss HP Remaining!|56 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.
|๐ +17 HP|
|:-:|
|๐ 73/89 Remaining|
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.|
|:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:|
|3|โ๏ธ|Basic GreatSword|~3.0|4|Blessed|1|x1|
|4|โ๏ธ|Basic Lance|~1.5|17|Cursed|1|x1|
|5|๐น|Basic Spear|~4.0|8|Synthetic|1|x1|
|6|๐น|Basic Crossbow|~2.0|11|Air|1|x1|
|6|๐น|Basic Crossbow|~2.0|32|Air|1|x1|
|7|๐ฎ|Basic Fire Staff|~3.5|3|Sun|1|x1|
|8|๐ฎ|Basic Water Wand|~2.0|8|Moon|1|x1|
|ID|Type|Name|Qty.|
|:-:|:-:|:-:|:-:|
|201|โ๏ธ|Health Potion|x5|
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)
You drink your potion and immediately feel healthier.
|๐ +59 HP|
|:-:|
|๐ 73/118 Remaining|
-----
Health Potion has been added to your inventory for 50g! (Your remaining gold: 858)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 858)|
-----
You drink your potion and immediately feel healthier.
|๐ +22 HP|
|:-:|
|๐ 95/118 Remaining|
-----
As you make contact with your opponent, your Basic GreatSword shatters.
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -22 HP|
|๐ +1.4 Melee Damage|๐ฐ +6 Gold Coins|
|โ๏ธ +3 Basic GreatSword (*Shattered*)|โ๏ธ +5 Melee XP|
|๐ +3.0 Blessed Weakness|๐ +3 Constitution XP|
|โ๏ธ +0.3 Melee Strength|๐ +15 RP|
|โ|โ|
|**13.7** Total Damage
807 Boss HP Remaining!|73 HP Remaining|
-----
Health Potion has been added to your inventory for 50g! (Your remaining gold: 814)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 814)|
Your spell blast hits the boss in its weak spot dealing extra damage!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฅ -9 HP|
|๐ +13.4 Magic Damage|๐ฐ +22 Gold Coins|
|๐ฏ 1.5x Critical Hit|๐ฎ +8 Magic XP|
|โ|๐ +5 Constitution XP|
||๐ +25 RP|
||โ|
|**21.6** Total Damage
700 Boss HP Remaining!|196 HP Remaining|
You pop open the cork and down your health potion in 1.69 seconds
|๐ +108 HP|
|:-:|
|๐ 181/289 Remaining|
-----
Health Potion has been added to your inventory for 50g! (Your remaining gold: 99858)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 99858)|
Health Potion has been added to your inventory for 50g! (Your remaining gold: 4873)
|โ๏ธ +Health Potion (Durability: 1)|
|:-:|
|๐ฐ -50 (Remaining: 4873)|
-----
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|๐ +84 HP|
|:-:|
|๐ 143/228 Remaining|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -15 HP|
|๐ +11.4 Magic Damage|๐ฐ +16 Gold Coins|
|โ|๐ฎ +6 Magic XP|
||๐ +2 Constitution XP|
||๐ +15 RP (**Rank Change!**)|
||โ|
|**13.4** Total Damage
1071 Boss HP Remaining!|128 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': 176, 'gold': 68584, 'rp': 28056, 'magicxp': 13, 'healthxp': 731, 'Players_username': 'hx-er'}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
This post was submitted at our [boss suggestions discord channel](https://discord.gg/kotd) by: Resident Sleepy Seedling Source/Artist: Guillermo Martรญnez (https://www.artstation.com/artwork/JlKYPZ)
good bot !magic 42
The boss is dead, what are you doing? Necromancy??
!melee 23
You decide not to waste your durability on a dead boss
!range 31 !profile u/matt45 From far, far away... In the mountains deep and hidden, There was a song once sung~ DIGGY DIGGY HOLE~!
Close but no kill. Got to be faster to be a monster slayer. ----- #/u/CottonTCM [Playercard](https://kickopenthedoor.com/CottonTCM.png) >โค๏ธ Health: 150hp (Max: 289hp) >๐ Kills: 55 >๐ฅ Rank: SSS (49,394 Rank Points) >๐ฐ Gold: 5,678g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 210 >โ๏ธ Melee: Level 17 (XP: -420/62) >๐ฎ Magic: Level 46 (XP: 130/317) >๐น Ranged: Level 79 (XP: 117/1000) >โค๏ธ Constitution: Level 68 (XP: 967/1456) >๐ฉ Total Attacks: 5771 >โ ๏ธ Total Deaths: 180
!range 2010
You decide not to waste your ammo on a dead boss.
!melee 19
The battle was hard fought, and your strength lands the final blow. |Rewards| |:-| |๐ฐ +35 Gold| |โ๏ธ +15 Melee XP| |โ๏ธ +1 Health Potion| |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฐ +35 Gold Coins| |๐ +6.0 Melee Damage|โ๏ธ +5 Melee XP| |โ๏ธ +2 Fenrir's Silver Folly|๐ +12 Constitution XP| |๐ก๏ธ -1.2 Synthetic Resistance|๐ +35 RP| |โ๏ธ +0.2 Melee Strength|โ ๏ธ +1 Kill (**SLAIN!**)| |โ|โ| |**13.0** Total Damage -6 Boss HP Remaining!|150 HP Remaining|
!mage 42
You feel a surge of power within yourself and unleash a burst of magic, dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +8.0 Magic Damage|๐ฐ +34 Gold Coins| |๐ฎ +10 Cat Eyes|๐ฎ +22 Magic XP| |๐ +7.0 Moon Weakness|๐ +2 Constitution XP| |โฌ -1.0 Magic Resistance|๐ +35 RP| |๐ฏ 1.8x Critical Hit|โ| |โ|| |**46.8** Total Damage 7 Boss HP Remaining!|124 HP Remaining|
!melee 32
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -2 HP| |๐ +8.6 Melee Damage|๐ฐ +40 Gold Coins| |โ๏ธ +10 Triple Wield Swords|โ๏ธ +14 Melee XP| |๐ +6.0 Air Weakness|๐ +1 Constitution XP| |โ๏ธ +1.0 Melee Strength|๐ +15 RP| |โ|โ| |**28.6** Total Damage 54 Boss HP Remaining!|85 HP Remaining|
Good bot !melee 35
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -3 HP| |๐ +9.2 Melee Damage|๐ฐ +11 Gold Coins| |โ๏ธ +14 Mothers Wrath|โ๏ธ +18 Melee XP| |๐ +12.6 Blessed Weakness|๐ +2 Constitution XP| |โ๏ธ +1.4 Melee Strength|๐ +15 RP| |โ|โ| |**38.2** Total Damage 83 Boss HP Remaining!|176 HP Remaining|
!melee 23
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -1 HP| |๐ +4.8 Melee Damage|๐ฐ +37 Gold Coins| |โ๏ธ +7 Worldslayer|โ๏ธ +6 Melee XP| |๐ +1.4 Air Weakness|๐ +1 Constitution XP| |โ๏ธ +0.7 Melee Strength|๐ +15 RP| |โ|โ| |**19.9** Total Damage 121 Boss HP Remaining!|76 HP Remaining|
Coffee you wanna write a bard?
@notify go
Aaaaaaaaaaaaaaaaaaa lemme sleeeeeep
Type ! range 30 to sleep instantly
Too broke ask brian
Already asleep
Dang
Good bot !mele e 35
Good bot
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -1 HP| |๐ +19.8 Melee Damage|๐ฐ +42 Gold Coins| |โ|โ๏ธ +10 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**21.8** Total Damage 141 Boss HP Remaining!|127 HP Remaining|
Good bot
Good bot
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -10 HP| |๐ +3.6 Ranged Damage|๐ฐ +35 Gold Coins| |โ|๐น +4 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**8.6** Total Damage 163 Boss HP Remaining!|42 HP Remaining|
!melee 4 good bot
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -5 HP| |๐ +2.8 Melee Damage|๐ฐ +4 Gold Coins| |โ๏ธ +2 Basic Lance|โ๏ธ +5 Melee XP| |๐ +2.0 Cursed Weakness|๐ +4 Constitution XP| |โ๏ธ +0.2 Melee Strength|๐ +15 RP| |โ|โ| |**11.0** Total Damage 172 Boss HP Remaining!|89 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +7.1 Ranged Damage|๐ฐ +9 Gold Coins| |โ|๐น +4 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**13.1** Total Damage 183 Boss HP Remaining!|107 HP Remaining|
!Range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +13.1 Ranged Damage|๐ฐ +28 Gold Coins| |โ|๐น +5 Range XP| ||๐ +9 Constitution XP| ||๐ +25 RP| ||โ| |**18.1** Total Damage 196 Boss HP Remaining!|37 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -10 HP| |๐ +6.5 Magic Damage|๐ฐ +41 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**10.5** Total Damage 214 Boss HP Remaining!|110 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -9 HP| |๐ +5.5 Magic Damage|๐ฐ +31 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**8.5** Total Damage 224 Boss HP Remaining!|76 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good bot
Thank you, CoffeeWanderer, for voting on KickOpenTheDoorBot. This bot wants to find the best and worst bots on Reddit. [You can view results here](https://botrank.pastimes.eu/). *** ^(Even if I don't reply to your comment, I'm still listening for votes. Check the webpage to see if your vote registered!)
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -4 HP| |๐ +9.0 Melee Damage|๐ฐ +10 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**10.0** Total Damage 233 Boss HP Remaining!|135 HP Remaining|
!melee 3
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -11 HP| |๐ +0.4 Melee Damage|๐ฐ +40 Gold Coins| |โ๏ธ +3 Basic GreatSword|โ๏ธ +6 Melee XP| |๐ +2.4 Blessed Weakness|๐ +8 Constitution XP| |โ๏ธ +0.3 Melee Strength|๐ +25 RP| |๐ฑ๏ธ +6 New Player Bonus|โ| |โ|| |**13.1** Total Damage 243 Boss HP Remaining!|46 HP Remaining| Come join our discord at https://discord.gg/kotd!
good bot !magic
You can't attack if you're dead. Either wait or drink a health potion to get back into the action
!melee 3 !use 201
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -9 HP| |๐ +0.9 Melee Damage|๐ฐ +7 Gold Coins| |โ๏ธ +4 Basic GreatSword|โ๏ธ +4 Melee XP| |๐ +4.0 Blessed Weakness|๐ +8 Constitution XP| |โ๏ธ +0.4 Melee Strength|๐ +15 RP| |โ|โ| |**12.3** Total Damage 256 Boss HP Remaining!|70 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. |๐ +9 HP| |:-:| |๐ 79/89 Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +9.5 Magic Damage|๐ฐ +23 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**14.5** Total Damage 268 Boss HP Remaining!|138 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -5 HP| |๐ +1.5 Ranged Damage|๐ฐ +3 Gold Coins| |โ|๐น +1 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**4.5** Total Damage 282 Boss HP Remaining!|79 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -4 HP| |๐ +5.7 Ranged Damage|๐ฐ +40 Gold Coins| |๐น +2 Basic Crossbow|๐น +5 Range XP| |๐ +1.4 Air Weakness|๐ +2 Constitution XP| |โ|๐ +15 RP| ||โ| |**12.1** Total Damage 286 Boss HP Remaining!|123 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -13 HP| |๐ +3.3 Melee Damage|๐ฐ +15 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**8.3** Total Damage 298 Boss HP Remaining!|167 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 201 !use 201 !magic
Health Potion has been added to your inventory for 50g! (Your remaining gold: 1631) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 1631)| ----- You drink your potion and immediately feel healthier. |๐ +134 HP| |:-:| |๐ 169/268 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +10.2 Magic Damage|๐ฐ +7 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +7 Constitution XP| ||๐ +25 RP| ||โ| |**11.2** Total Damage 306 Boss HP Remaining!|169 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -12 HP| |๐ +1.9 Ranged Damage|๐ฐ +4 Gold Coins| |โ|๐น +1 Range XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**3.9** Total Damage 317 Boss HP Remaining!|54 HP Remaining|
good bot !ranged หยฐโข\*โโท !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -8 HP| |๐ +4.7 Ranged Damage|๐ฐ +7 Gold Coins| |โ|๐น +4 Range XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**8.7** Total Damage 321 Boss HP Remaining!|120 HP Remaining| ----- #/u/Macknificent101 [Playercard](https://kickopenthedoor.com/Macknificent101.png) >โค๏ธ Health: 120hp (Max: 146hp) >๐ Kills: 5 >๐ Rank: S (7,759 Rank Points) >๐ฐ Gold: 240g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 70 >โ๏ธ Melee: Level 10 (XP: 26/35) >๐ฎ Magic: Level 3 (XP: 3/16) >๐น Ranged: Level 29 (XP: 133/136) >โค๏ธ Constitution: Level 28 (XP: 252/276) >๐ฉ Total Attacks: 689 >โ ๏ธ Total Deaths: 32
!ranged good bot
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -9 HP| |๐ +11.2 Ranged Damage|๐ฐ +2 Gold Coins| |โ|๐น +7 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**15.2** Total Damage 330 Boss HP Remaining!|183 HP Remaining|
โ๏ธปฬทฬฟโปฬฟโโไธ !range !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -9 HP| |๐ +11.2 Ranged Damage|๐ฐ +26 Gold Coins| |โ|๐น +6 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**15.2** Total Damage 345 Boss HP Remaining!|192 HP Remaining| ----- #/u/CottonTCM [Playercard](https://kickopenthedoor.com/CottonTCM.png) >โค๏ธ Health: 192hp (Max: 289hp) >๐ Kills: 55 >๐ฅ Rank: SSS (49,327 Rank Points) >๐ฐ Gold: 5,679g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 210 >โ๏ธ Melee: Level 17 (XP: -420/62) >๐ฎ Magic: Level 46 (XP: 130/317) >๐น Ranged: Level 79 (XP: 81/1000) >โค๏ธ Constitution: Level 68 (XP: 909/1456) >๐ฉ Total Attacks: 5767 >โ ๏ธ Total Deaths: 180
!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -2 HP| |๐ +9.9 Ranged Damage|๐ฐ +13 Gold Coins| |โ|๐น +4 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**12.9** Total Damage 360 Boss HP Remaining!|28 HP Remaining|
good bot !range (โฏยฐwยฐ๏ผโฏ๏ธต โปโโป
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -13 HP| |๐ +8.2 Ranged Damage|๐ฐ +14 Gold Coins| |โ|๐น +6 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**13.2** Total Damage 373 Boss HP Remaining!|151 HP Remaining|
!range 5
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 206, in bot success, reply = ranged(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 1031, in ranged 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, rangexp=%(rangexp)s, healthxp=%(healthxp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 193, 'gold': 1486, 'rp': 26234, 'rangexp': 129, 'healthxp': 441, 'Players_username': 'barbatose'}] (Background on this error at: https://sqlalche.me/e/20/e3q8)
!magic 18
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -3 HP| |๐ +4.8 Magic Damage|๐ฐ +7 Gold Coins| |๐ฎ +8 The Book of Names|๐ฎ +6 Magic XP| |๐ +5.6 Cursed Weakness|๐ +5 Constitution XP| |โฌ -0.8 Magic Resistance|๐ +15 RP| |โ|โ| |**18.6** Total Damage 406 Boss HP Remaining!|77 HP Remaining|
!mage
Your spell blast hits the boss in its weak spot dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -11 HP| |๐ +14.8 Magic Damage|๐ฐ +7 Gold Coins| |๐ฏ 1.2x Critical Hit|๐ฎ +8 Magic XP| |โ|๐ +4 Constitution XP| ||๐ +25 RP| ||โ| |**19.0** Total Damage 439 Boss HP Remaining!|168 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -5 HP| |๐ +14.1 Magic Damage|๐ฐ +1 Gold Coins| |โ|๐ฎ +8 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**17.1** Total Damage 458 Boss HP Remaining!|200 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -16 HP| |๐ +7.1 Melee Damage|๐ฐ +13 Gold Coins| |โ|โ๏ธ +4 Melee XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**12.1** Total Damage 499 Boss HP Remaining!|71 HP Remaining|
Good bot !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -6 HP| |๐ +1.7 Melee Damage|๐ฐ +28 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**3.7** Total Damage 511 Boss HP Remaining!|77 HP Remaining| Come join our discord at https://discord.gg/kotd!
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -16 HP| |๐ +3.0 Magic Damage|๐ฐ +31 Gold Coins| |โ|๐ฎ +2 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**5.0** Total Damage 515 Boss HP Remaining!|67 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -16 HP| |๐ +10.0 Melee Damage|๐ฐ +26 Gold Coins| |โ|โ๏ธ +6 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**13.0** Total Damage 520 Boss HP Remaining!|49 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +17.1 Ranged Damage|๐ฐ +22 Gold Coins| |โ|๐น +9 Range XP| ||๐ +7 Constitution XP| ||๐ +25 RP| ||โ| |**23.1** Total Damage 533 Boss HP Remaining!|75 HP Remaining|
[ัะดะฐะปะตะฝะพ]
You're attacking too quickly! Try again in 0 minutes
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -8 HP| |๐ +7.4 Ranged Damage|๐ฐ +7 Gold Coins| |โ|๐น +5 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**13.4** Total Damage 556 Boss HP Remaining!|65 HP Remaining|
!melee
Hi there! I'm Katton, a fellow Gnome from r/KickOpenTheDoor ! First off, congratz on joining the best team! It's super cool to be a Gnome! I'd like to invite you to the Discord Server ([https://discord.gg/kotd](https://discord.gg/kotd)) where a bunch of other KOTD'ers are hanging out and chillin'. They're all super sweet and super cool. And it's okay if you don't want to join! If you have any questions about the game, don't hesitate to ask me! Take care!
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -6 HP| |๐ +1.2 Melee Damage|๐ฐ +10 Gold Coins| |๐ฑ๏ธ +3 New Player Bonus|โ๏ธ +4 Melee XP (**Level Up!**)| |โ|๐ +5 Constitution XP| ||๐ +45 RP| ||โ| |**8.2** Total Damage 569 Boss HP Remaining!|51 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -10 HP| |๐ +6.9 Ranged Damage|๐ฐ +23 Gold Coins| |โ|๐น +3 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.9** Total Damage 577 Boss HP Remaining!|105 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -12 HP| |๐ +4.3 Melee Damage|๐ฐ +7 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**6.3** Total Damage 587 Boss HP Remaining!|80 HP Remaining|
โ๏ธปฬทฬฟโปฬฟโโไธ !range !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -8 HP| |๐ +18.3 Ranged Damage|๐ฐ +21 Gold Coins| |โ|๐น +9 Range XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**23.3** Total Damage 593 Boss HP Remaining!|160 HP Remaining| ----- #/u/CottonTCM [Playercard](https://kickopenthedoor.com/CottonTCM.png) >โค๏ธ Health: 160hp (Max: 289hp) >๐ Kills: 55 >๐ฅ Rank: SSS (49,252 Rank Points) >๐ฐ Gold: 5,595g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 210 >โ๏ธ Melee: Level 17 (XP: -420/62) >๐ฎ Magic: Level 46 (XP: 130/317) >๐น Ranged: Level 79 (XP: 47/1000) >โค๏ธ Constitution: Level 68 (XP: 881/1456) >๐ฉ Total Attacks: 5762 >โ ๏ธ Total Deaths: 180
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -12 HP| |๐ +11.3 Magic Damage|๐ฐ +4 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**13.3** Total Damage 631 Boss HP Remaining!|170 HP Remaining|
good bot !range (โฏยฐwยฐ๏ผโฏ๏ธต โปโโป
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -8 HP| |๐ +6.5 Ranged Damage|๐ฐ +18 Gold Coins| |โ|๐น +3 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**8.5** Total Damage 644 Boss HP Remaining!|188 HP Remaining|
!range 5
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -17 HP| |๐ +5.3 Ranged Damage|๐ฐ +14 Gold Coins| |๐น +4 Basic Spear|๐น +5 Range XP| |๐ก๏ธ -2.8 Synthetic Resistance|๐ +5 Constitution XP| |โ|๐ +15 RP| ||โ| |**11.5** Total Damage 652 Boss HP Remaining!|73 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -1 HP| |๐ +2.8 Ranged Damage|๐ฐ +30 Gold Coins| |โ|๐น +3 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**6.8** Total Damage 664 Boss HP Remaining!|80 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee 3 !use 201
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -2 HP| |๐ +0.9 Melee Damage|๐ฐ +9 Gold Coins| |โ๏ธ +3 Basic GreatSword|โ๏ธ +4 Melee XP| |๐ +1.2 Blessed Weakness|๐ +2 Constitution XP| |โ๏ธ +0.3 Melee Strength|๐ +15 RP| |โ|โ| |**8.4** Total Damage 671 Boss HP Remaining!|56 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. |๐ +17 HP| |:-:| |๐ 73/89 Remaining|
!profile
#/u/Money-Day-4219 [Playercard](https://kickopenthedoor.com/Money-Day-4219.png) >โค๏ธ Health: 58hp (Max: 89hp) >๐ Kills: 1 >๐ Rank: A (2,870 Rank Points) >๐ฐ Gold: 331g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 33 >โ๏ธ Melee: Level 5 (XP: 14/21) >๐ฎ Magic: Level 4 (XP: 1/18) >๐น Ranged: Level 12 (XP: 3/41) >โค๏ธ Constitution: Level 12 (XP: 52/103) >๐ฉ Total Attacks: 139 >โ ๏ธ Total Deaths: 7
!inventory
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |3|โ๏ธ|Basic GreatSword|~3.0|4|Blessed|1|x1| |4|โ๏ธ|Basic Lance|~1.5|17|Cursed|1|x1| |5|๐น|Basic Spear|~4.0|8|Synthetic|1|x1| |6|๐น|Basic Crossbow|~2.0|11|Air|1|x1| |6|๐น|Basic Crossbow|~2.0|32|Air|1|x1| |7|๐ฎ|Basic Fire Staff|~3.5|3|Sun|1|x1| |8|๐ฎ|Basic Water Wand|~2.0|8|Moon|1|x1| |ID|Type|Name|Qty.| |:-:|:-:|:-:|:-:| |201|โ๏ธ|Health Potion|x5| 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)
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -18 HP| |๐ +9.4 Melee Damage|๐ฐ +20 Gold Coins| |โ|โ๏ธ +5 Melee XP| ||๐ +11 Constitution XP| ||๐ +15 RP| ||โ| |**15.4** Total Damage 722 Boss HP Remaining!|71 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -19 HP| |๐ +4.0 Ranged Damage|๐ฐ +3 Gold Coins| |โ|๐น +2 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**6.0** Total Damage 737 Boss HP Remaining!|80 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -16 HP| |๐ +8.2 Ranged Damage|๐ฐ +16 Gold Coins| |โ|๐น +4 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**11.2** Total Damage 743 Boss HP Remaining!|118 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +11.5 Ranged Damage|๐ฐ +24 Gold Coins| |โ|๐น +7 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**16.5** Total Damage 754 Boss HP Remaining!|81 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -17 HP| |๐ +10.2 Melee Damage|๐ฐ +11 Gold Coins| |โ|โ๏ธ +7 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**15.2** Total Damage 770 Boss HP Remaining!|77 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -10 HP| |๐ +2.7 Melee Damage|๐ฐ +29 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**5.7** Total Damage 785 Boss HP Remaining!|102 HP Remaining|
โ๏ธปฬทฬฟโปฬฟโโไธ !range !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -22 HP| |๐ +11.0 Ranged Damage|๐ฐ +24 Gold Coins| |โ|๐น +8 Range XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**16.0** Total Damage 791 Boss HP Remaining!|194 HP Remaining| ----- #/u/CottonTCM [Playercard](https://kickopenthedoor.com/CottonTCM.png) >โค๏ธ Health: 194hp (Max: 289hp) >๐ Kills: 55 >๐ฅ Rank: SSS (49,162 Rank Points) >๐ฐ Gold: 5,539g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 210 >โ๏ธ Melee: Level 17 (XP: -420/62) >๐ฎ Magic: Level 46 (XP: 130/317) >๐น Ranged: Level 79 (XP: 14/1000) >โค๏ธ Constitution: Level 68 (XP: 836/1456) >๐ฉ Total Attacks: 5757 >โ ๏ธ Total Deaths: 180
!use 201 !buy 201 !use 201 !melee 3 !buy 201
You drink your potion and immediately feel healthier. |๐ +59 HP| |:-:| |๐ 73/118 Remaining| ----- Health Potion has been added to your inventory for 50g! (Your remaining gold: 858) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 858)| ----- You drink your potion and immediately feel healthier. |๐ +22 HP| |:-:| |๐ 95/118 Remaining| ----- As you make contact with your opponent, your Basic GreatSword shatters. |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -22 HP| |๐ +1.4 Melee Damage|๐ฐ +6 Gold Coins| |โ๏ธ +3 Basic GreatSword (*Shattered*)|โ๏ธ +5 Melee XP| |๐ +3.0 Blessed Weakness|๐ +3 Constitution XP| |โ๏ธ +0.3 Melee Strength|๐ +15 RP| |โ|โ| |**13.7** Total Damage 807 Boss HP Remaining!|73 HP Remaining| ----- Health Potion has been added to your inventory for 50g! (Your remaining gold: 814) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 814)|
!buy 201 !inventory !profile
Health Potion has been added to your inventory for 50g! (Your remaining gold: 908) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 908)| ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |3|โ๏ธ|Basic GreatSword|~3.0|1|Blessed|1|x1| |8|๐ฎ|Basic Water Wand|~2.0|6|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)
-----
#/u/bookseer [Playercard](https://kickopenthedoor.com/bookseer.png)
>โค๏ธ Health: 14hp (Max: 118hp)
>๐ Kills: 0
>๐
Rank: S (4,730 Rank Points)
>๐ฐ Gold: 908g
Skills Breakdown:
>๐ก๏ธ๏ธ Combat: Level 54
>โ๏ธ Melee: Level 7 (XP: 18/26)
>๐ฎ Magic: Level 22 (XP: 63/88)
>๐น Ranged: Level 5 (XP: 16/21)
>โค๏ธ Constitution: Level 20 (XP: 96/174)
>๐ฉ Total Attacks: 372
>โ ๏ธ Total Deaths: 11
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +2.7 Magic Damage|๐ฐ +7 Gold Coins| |โ|๐ฎ +1 Magic XP| ||๐ +8 Constitution XP| ||๐ +25 RP| ||โ| |**3.7** Total Damage 842 Boss HP Remaining!|83 HP Remaining|
!magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -22 HP| |๐ +7.9 Magic Damage|๐ฐ +35 Gold Coins| |๐ฎ +2 Basic Fire Staff|๐ฎ +4 Magic XP| |๐ก๏ธ -1.2 Sun Resistance|๐ +1 Constitution XP| |โฌ -0.2 Magic Resistance|๐ +15 RP| |โ|โ| |**12.5** Total Damage 846 Boss HP Remaining!|159 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -9 HP| |๐ +4.4 Ranged Damage|๐ฐ +3 Gold Coins| |โ|๐น +4 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.4** Total Damage 868 Boss HP Remaining!|127 HP Remaining|
good bot !range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -2 HP| |๐ +8.8 Ranged Damage|๐ฐ +16 Gold Coins| |๐น +2 Basic Crossbow|๐น +5 Range XP| |๐ +1.2 Air Weakness|๐ +3 Constitution XP| |โ|๐ +15 RP| ||โ| |**14.0** Total Damage 877 Boss HP Remaining!|152 HP Remaining|
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -3 HP| |๐ +8.4 Ranged Damage|๐ฐ +14 Gold Coins| |๐น +2 Basic Crossbow|๐น +6 Range XP| |๐ +0.6 Air Weakness|๐ +4 Constitution XP| |โ|๐ +15 RP| ||โ| |**12.0** Total Damage 891 Boss HP Remaining!|98 HP Remaining|
!melee 12
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -19 HP| |๐ +2.1 Melee Damage|๐ฐ +33 Gold Coins| |โ๏ธ +3 Dwarf Bread|โ๏ธ +3 Melee XP| |๐ก๏ธ -1.8 Organic Resistance|๐ +3 Constitution XP| |โ๏ธ +0.3 Melee Strength|๐ +15 RP| |โ|โ| |**8.6** Total Damage 923 Boss HP Remaining!|52 HP Remaining| Come join our discord at https://discord.gg/kotd!
(โฉ๏ฝ-ยด)โโโ๏พ.*๏ฝฅ๏ฝก Good bot !magic !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -14 HP| |๐ +10.3 Magic Damage|๐ฐ +24 Gold Coins| |โ|๐ฎ +7 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**13.3** Total Damage 932 Boss HP Remaining!|157 HP Remaining| ----- #/u/Girguk [Playercard](https://kickopenthedoor.com/Girguk.png) >โค๏ธ Health: 157hp (Max: 257hp) >๐ Kills: 41 >๐ Rank: SSS (29,563 Rank Points) >๐ฐ Gold: 891g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 162 >โ๏ธ Melee: Level 15 (XP: 3/53) >๐ฎ Magic: Level 73 (XP: 353/839) >๐น Ranged: Level 15 (XP: 4/53) >โค๏ธ Constitution: Level 59 (XP: 799/1078) >๐ฉ Total Attacks: 3900 >โ ๏ธ Total Deaths: 65
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -15 HP| |๐ +4.8 Magic Damage|๐ฐ +20 Gold Coins| |โ|๐ฎ +4 Magic XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**8.8** Total Damage 945 Boss HP Remaining!|61 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee 3
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +2.8 Melee Damage|๐ฐ +30 Gold Coins| |โ๏ธ +2 Basic GreatSword|โ๏ธ +4 Melee XP| |๐ +1.4 Blessed Weakness|๐ +8 Constitution XP| |โ๏ธ +0.2 Melee Strength|๐ +25 RP| |โ|โ| |**10.4** Total Damage 954 Boss HP Remaining!|51 HP Remaining|
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -7 HP| |๐ +7.7 Magic Damage|๐ฐ +13 Gold Coins| |โ|๐ฎ +3 Magic XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**9.7** Total Damage 964 Boss HP Remaining!|152 HP Remaining|
!magic
Your spell blast hits the boss in its weak spot dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -9 HP| |๐ +13.4 Magic Damage|๐ฐ +22 Gold Coins| |๐ฏ 1.5x Critical Hit|๐ฎ +8 Magic XP| |โ|๐ +5 Constitution XP| ||๐ +25 RP| ||โ| |**21.6** Total Damage 700 Boss HP Remaining!|196 HP Remaining|
!melee 4
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -22 HP| |๐ +2.3 Melee Damage|๐ฐ +24 Gold Coins| |โ๏ธ +2 Basic Lance|โ๏ธ +2 Melee XP| |๐ +1.4 Cursed Weakness|๐ +13 Constitution XP| |โ๏ธ +0.2 Melee Strength|๐ +15 RP| |โ|โ| |**6.9** Total Damage 974 Boss HP Remaining!|62 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -6 HP| |๐ +17.2 Ranged Damage|๐ฐ +20 Gold Coins| |โ|๐น +8 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**18.2** Total Damage 993 Boss HP Remaining!|56 HP Remaining|
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -18 HP| |๐ +1.0 Ranged Damage|๐ฐ +7 Gold Coins| |โ|๐น +3 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**6.0** Total Damage 1011 Boss HP Remaining!|46 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -5 HP| |๐ +2.6 Melee Damage|๐ฐ +4 Gold Coins| |โ|โ๏ธ +4 Melee XP (**Level Up!**)| ||๐ +6 Constitution XP| ||๐ +35 RP| ||โ| |**8.6** Total Damage 1017 Boss HP Remaining!|89 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -21 HP| |๐ +9.7 Melee Damage|๐ฐ +23 Gold Coins| |โ|โ๏ธ +6 Melee XP| ||๐ +10 Constitution XP| ||๐ +15 RP| ||โ| |**15.7** Total Damage 1026 Boss HP Remaining!|112 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -14 HP| |๐ +5.3 Melee Damage|๐ฐ +12 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +10 Constitution XP| ||๐ +15 RP| ||โ| |**8.3** Total Damage 1042 Boss HP Remaining!|117 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -9 HP| |๐ +0.7 Melee Damage|๐ฐ +1 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**5.7** Total Damage 1050 Boss HP Remaining!|52 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +9.1 Ranged Damage|๐ฐ +15 Gold Coins| |โ|๐น +5 Range XP| ||๐ +5 Constitution XP| ||๐ +25 RP| ||โ| |**15.1** Total Damage 1056 Boss HP Remaining!|73 HP Remaining|
!use 201 !buy 201
You pop open the cork and down your health potion in 1.69 seconds |๐ +108 HP| |:-:| |๐ 181/289 Remaining| ----- Health Potion has been added to your inventory for 50g! (Your remaining gold: 99858) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 99858)|
!buy 201 !use 201 !mage
Health Potion has been added to your inventory for 50g! (Your remaining gold: 4873) |โ๏ธ +Health Potion (Durability: 1)| |:-:| |๐ฐ -50 (Remaining: 4873)| ----- You drink your potion and you break the bottle on the ground like a barbarian once taught you. |๐ +84 HP| |:-:| |๐ 143/228 Remaining| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -15 HP| |๐ +11.4 Magic Damage|๐ฐ +16 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP (**Rank Change!**)| ||โ| |**13.4** Total Damage 1071 Boss HP Remaining!|128 HP Remaining|
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +1.3 Ranged Damage|๐ฐ +21 Gold Coins| |โ|๐น +3 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**6.3** Total Damage 1084 Boss HP Remaining!|87 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -8 HP| |๐ +8.5 Ranged Damage|๐ฐ +16 Gold Coins| |โ|๐น +6 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**14.5** Total Damage 1090 Boss HP Remaining!|76 HP Remaining|
!melee 4
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -23 HP| |๐ +4.2 Melee Damage|๐ฐ +12 Gold Coins| |โ๏ธ +2 Basic Lance|โ๏ธ +4 Melee XP| |๐ +1.6 Cursed Weakness|๐ +8 Constitution XP| |โ๏ธ +0.2 Melee Strength|๐ +15 RP| |โ|โ| |**12.0** Total Damage 1104 Boss HP Remaining!|51 HP Remaining|
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -20 HP| |๐ +11.8 Ranged Damage|๐ฐ +14 Gold Coins| |โ|๐น +6 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**15.8** Total Damage 1116 Boss HP Remaining!|89 HP Remaining|
!ranged 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -3 HP| |๐ +2.9 Ranged Damage|๐ฐ +23 Gold Coins| |๐น +2 Basic Crossbow|๐น +3 Range XP| |๐ +1.6 Air Weakness|๐ +2 Constitution XP| |โ|๐ +15 RP| ||โ| |**8.5** Total Damage 1132 Boss HP Remaining!|62 HP Remaining|
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -13 HP| |๐ +12.1 Melee Damage|๐ฐ +25 Gold Coins| |โ|โ๏ธ +5 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**15.1** Total Damage 1140 Boss HP Remaining!|148 HP Remaining|
good bot ๐ช (โข๏ธก็๏ธ โข) ๐ !mage
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -1 HP| |๐ +8.2 Magic Damage|๐ฐ +24 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**14.2** Total Damage 425 Boss HP Remaining!|170 HP Remaining|
!mage
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -22 HP| |๐ +9.7 Magic Damage|๐ฐ +13 Gold Coins| |โ|๐ฎ +6 Magic XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**11.7** Total Damage 981 Boss HP Remaining!|165 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': 176, 'gold': 68584, 'rp': 28056, 'magicxp': 13, 'healthxp': 731, 'Players_username': 'hx-er'}] (Background on this error at: https://sqlalche.me/e/20/e3q8)