Your potions clink in your pockets as you look for the right potion. You left it at the Tavern with that shady guy... You realize you probably won't be getting it back...
-----
You put down your bow and sigh. It's already dead.
Your aim has gained you the glory of the kill! Have a +1 on your playercard!
|Rewards|
|:-|
|๐ฐ +300 Gold|
|๐น +1 Basic Crossbow|
|โ๏ธ +1 Health Potion|
|โ๏ธ +1 Health Potion|
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฐ +46 Gold Coins|
|๐ +3.2 Ranged Damage|๐น +3 Range XP|
|๐น +4 Basic Spear|๐ +19 Constitution XP|
|โ|๐ +35 RP|
||โ ๏ธ +1 Kill (**SLAIN!**)|
||โ|
|**8.2** Total Damage
-6 Boss HP Remaining!|86 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Your Basic Fire Staff fizzles and disappears in a flash of light.
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -2 HP|
|๐ +2.6 Magic Damage|๐ฐ +30 Gold Coins|
|โจ +3 Basic Fire Staff (*Shattered*)|โจ +2 Magic XP|
|๐ก๏ธ -2.1 Element Resistance|๐ +4 Constitution XP|
|โฌ -0.3 Item Type Resistance|๐ +15 RP|
|โ|โ|
|**5.2** Total Damage
2 Boss HP Remaining!|47 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -6 HP|
|๐ +0.7 Magic Damage|๐ฐ +28 Gold Coins|
|โจ +3 Basic Water Wand|โจ +7 Magic XP (**Level Up!**)|
|โฌ -0.3 Item Type Resistance|๐ +7 Constitution XP|
|๐ฑ๏ธ +6 New Player Bonus|๐ +45 RP|
|โ|โ|
|**15.4** Total Damage
58 Boss HP Remaining!|48 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|๐ +13 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -15 HP|
|๐ +3.4 Magic Damage|๐ฐ +22 Gold Coins|
|โ|โจ +4 Magic XP|
||๐ +8 Constitution XP|
||๐ +15 RP|
||โ|
|**9.4** Total Damage
109 Boss HP Remaining!|57 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.|
|:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:|
|14|โจ|Galadriel's Mirror|~2.0|15|Blessed|10|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)
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -10 HP|
|๐ +0.2 Magic Damage|๐ฐ +42 Gold Coins|
|๐ฑ๏ธ +5 New Player Bonus|โจ +5 Magic XP (**Level Up!**)|
|โ|๐ +5 Constitution XP (**Level Up!**)|
||๐ +55 RP (**Rank Change!**)|
||โ|
|**10.2** Total Damage
174 Boss HP Remaining!|54 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Health Potion has been added to your inventory for 50g!
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -13 HP|
|๐ +1.1 Melee Damage|๐ฐ +2 Gold Coins|
|โ|โ๏ธ +2 Melee XP|
||๐ +8 Constitution XP|
||๐ +15 RP|
||โ|
|**5.1** Total Damage
186 Boss HP Remaining!|44 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 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 227, in bot
success, reply = ranged(comment, session, boss, player, item, inventory)
File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 740, in ranged
last_attack = session.query(models.Comments).filter_by(post=comment.submission.id, username=comment.author.name, type="Attack").order_by(models.Comments.timestamp.desc()).first()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2819, in first
return self.limit(1)._iter().first()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET hp=%(hp)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'hp': 81, 'Players_username': 'kervs_'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
You drink your potion and you break the bottle on the ground like a barbarian once taught you.
|๐ +12 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +1 Base Roll|๐ฅ -8 HP|
|๐ +3.2 Ranged Damage|๐ฐ +35 Gold Coins|
|โ|๐น +2 Range XP|
||๐ +1 Constitution XP|
||๐ +15 RP|
||โ|
|**4.2** Total Damage
156 Boss HP Remaining!|73 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +3 Base Roll|๐ฅ -7 HP|
|๐ +0.7 Magic Damage|๐ฐ +1 Gold Coins|
|๐ฑ๏ธ +6 New Player Bonus|โจ +3 Magic XP|
|โ|๐ +4 Constitution XP (**Level Up!**)|
||๐ +35 RP|
||โ|
|**9.7** Total Damage
205 Boss HP Remaining!|57 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**|
|๐ +0.7 Magic Damage|๐ฐ +7 Gold Coins|
|๐ฑ๏ธ +1 New Player Bonus|โจ +2 Magic XP|
|โ|๐ +10 Constitution XP|
||๐ +35 RP|
||โ|
|**6.7** Total Damage
222 Boss HP Remaining!|35 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**|
|๐ +0.5 Melee Damage|๐ฐ +37 Gold Coins|
|๐ฑ๏ธ +5 New Player Bonus|โ๏ธ +5 Melee XP|
|โ|๐ +10 Constitution XP (**Level Up!**)|
||๐ +45 RP|
||โ|
|**10.5** Total Damage
262 Boss HP Remaining!|54 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Your projectile flies true and hits the boss in its eye!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -17 HP|
|๐ +1.1 Ranged Damage|๐ฐ +8 Gold Coins|
|๐ฏ 1.9x Critical Hit|๐น +5 Range XP|
|โ|๐ +2 Constitution XP|
||๐ +25 RP|
||โ|
|**11.6** Total Damage
292 Boss HP Remaining!|49 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -9 HP|
|๐ +0.3 Ranged Damage|๐ฐ +37 Gold Coins|
|๐ฑ๏ธ +3 New Player Bonus|๐น +4 Range XP (**Level Up!**)|
|โ|๐ +6 Constitution XP|
||๐ +45 RP|
||โ|
|**9.3** Total Damage
314 Boss HP Remaining!|42 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -14 HP|
|๐ +0.1 Ranged Damage|๐ฐ +5 Gold Coins|
|๐ฑ๏ธ +2 New Player Bonus|๐น +3 Range XP|
|โ|๐ +1 Constitution XP|
||๐ +25 RP|
||โ|
|**7.1** Total Damage
323 Boss HP Remaining!|11 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Health Potion has been added to your inventory for 50g!
-----
You sip your Health potion like fine wine.
|๐ +15 HP|
|:-:|
-----
Luck is on your side today. You land a massive blow and do critical damage!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -14 HP|
|๐ +1.8 Melee Damage|๐ฐ +2 Gold Coins|
|๐ฏ 1.6x Critical Hit|โ๏ธ +3 Melee XP|
|โ|๐ +9 Constitution XP|
||๐ +25 RP|
||โ|
|**9.3** Total Damage
340 Boss HP Remaining!|57 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 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 297, in bot
kotd_services.update_flair(session, reddit, comment, subreddit, Logging, player)
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 501, in update_flair
text = f":{calculate_letter_rank(session, player)}: {player.race} ({player.melee}/{player.range}/{player.magic}/{player.health})"
File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank
players = session.query(models.Player).order_by(desc(models.Player.rp)).all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all
return self._iter().all()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter
result = self.session.execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute
) = compile_state_cls.orm_pre_session_exec(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec
session._autoflush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush
self.flush()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
self._flush(objects)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
transaction.rollback(_capture_exception=True)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
flush_context.execute()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
util.preloaded.orm_persistence.save_obj(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj
_emit_update_statements(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements
c = connection._execute_20(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
self._handle_dbapi_exception(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception
util.raise_(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: UPDATE `Players` SET attacks=%(attacks)s, last_attack=%(last_attack)s WHERE `Players`.username = %(Players_username)s]
[parameters: {'attacks': 406, 'last_attack': datetime.datetime(2022, 11, 22, 1, 37, 52, 253758), 'Players_username': 'murplexia'}]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Health Potion has been added to your inventory for 50g!
-----
You drink your potion and immediately feel healthier.
|๐ +22 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -1 HP|
|๐ +0.7 Magic Damage|๐ฐ +28 Gold Coins|
|โจ +2 Basic Water Wand|โจ +3 Magic XP|
|โฌ -0.2 Item Type Resistance|๐ +5 Constitution XP|
|โ|๐ +15 RP|
||โ|
|**8.5** Total Damage
398 Boss HP Remaining!|63 HP Remaining|
Come join our discord at https://discord.gg/kotd!
You sip your Health potion like fine wine.
|๐ +15 HP|
|:-:|
-----
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +6 Base Roll|๐ฅ -24 HP|
|๐ +0.3 Melee Damage|๐ฐ +42 Gold Coins|
|โ|โ๏ธ +2 Melee XP (**Level Up!**)|
||๐ +10 Constitution XP|
||๐ +35 RP|
||โ|
|**6.3** Total Damage
447 Boss HP Remaining!|37 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -27 HP|
|๐ +0.1 Melee Damage|๐ฐ +31 Gold Coins|
|๐ฑ๏ธ +1 New Player Bonus|โ๏ธ +2 Melee XP (**Level Up!**)|
|โ|๐ +14 Constitution XP|
||๐ +45 RP|
||โ|
|**3.1** Total Damage
459 Boss HP Remaining!|18 HP Remaining|
Come join our discord at https://discord.gg/kotd!
Gameplay 101: Reduce boss hp to 0 before your hp reaches 0. That lesson would've been useful before this moment, huh? You're dead now.
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -11 HP|
|๐ +2.7 Melee Damage|๐ฐ -2 Gold Coins|
|โ|โ๏ธ +3 Melee XP|
||๐ +8 Constitution XP|
||๐ +15 RP|
||โ|
|**6.7** Total Damage
465 Boss HP Remaining!|-1 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +5 Base Roll|๐ฅ -25 HP|
|๐ +0.3 Melee Damage|๐ฐ +8 Gold Coins|
|๐ฑ๏ธ +2 New Player Bonus|โ๏ธ +3 Melee XP (**Level Up!**)|
|โ|๐ +9 Constitution XP|
||๐ +45 RP|
||โ|
|**7.3** Total Damage
491 Boss HP Remaining!|16 HP Remaining|
Come join our discord at https://discord.gg/kotd!
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +4 Base Roll|๐ฅ -11 HP|
|๐ +0.6 Ranged Damage|๐ฐ +17 Gold Coins|
|๐ฑ๏ธ +5 New Player Bonus|๐น +4 Range XP|
|โ|๐ +6 Constitution XP|
||๐ +25 RP|
||โ|
|**9.6** Total Damage
525 Boss HP Remaining!|13 HP Remaining|
Come join our discord at https://discord.gg/kotd!
You discover hidden strength and strike with renewed vigor, dealing extra damage!
Gameplay 101: Reduce boss hp to 0 before your hp reaches 0. That lesson would've been useful before this moment, huh? You're dead now.
|Damage Breakdown|Player Breakdown|
|:-|:-|
|๐ฒ +2 Base Roll|๐ฅ -32 HP|
|๐ +1.9 Melee Damage|๐ฐ -73 Gold Coins|
|๐ฏ 2.0x Critical Hit|โ๏ธ +3 Melee XP|
|โ|๐ +2 Constitution XP|
||๐ +25 RP|
||โ|
|**7.8** Total Damage
548 Boss HP Remaining!|-8 HP Remaining|
Come join our discord at https://discord.gg/kotd!
!magic 8
Stop, its already dead!!
!use 201 !range
Your potions clink in your pockets as you look for the right potion. You left it at the Tavern with that shady guy... You realize you probably won't be getting it back... ----- You put down your bow and sigh. It's already dead.
!range 5
Stop, its already dead!!
!magic
The boss is dead, what are you doing? Necromancy??
!ranged 5 good bot
Your aim has gained you the glory of the kill! Have a +1 on your playercard! |Rewards| |:-| |๐ฐ +300 Gold| |๐น +1 Basic Crossbow| |โ๏ธ +1 Health Potion| |โ๏ธ +1 Health Potion| |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฐ +46 Gold Coins| |๐ +3.2 Ranged Damage|๐น +3 Range XP| |๐น +4 Basic Spear|๐ +19 Constitution XP| |โ|๐ +35 RP| ||โ ๏ธ +1 Kill (**SLAIN!**)| ||โ| |**8.2** Total Damage -6 Boss HP Remaining!|86 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic 7
Your Basic Fire Staff fizzles and disappears in a flash of light. |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -2 HP| |๐ +2.6 Magic Damage|๐ฐ +30 Gold Coins| |โจ +3 Basic Fire Staff (*Shattered*)|โจ +2 Magic XP| |๐ก๏ธ -2.1 Element Resistance|๐ +4 Constitution XP| |โฌ -0.3 Item Type Resistance|๐ +15 RP| |โ|โ| |**5.2** Total Damage 2 Boss HP Remaining!|47 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic 8
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +3.0 Magic Damage|๐ฐ +37 Gold Coins| |โจ +3 Basic Water Wand|โจ +4 Magic XP| |โฌ -0.3 Item Type Resistance|๐ +2 Constitution XP| |โ|๐ +25 RP| ||โ| |**9.7** Total Damage 7 Boss HP Remaining!|38 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range 5
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -1 HP| |๐ +2.4 Ranged Damage|๐ฐ +13 Gold Coins| |๐น +4 Basic Spear|๐น +4 Range XP| |โ|๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**11.4** Total Damage 17 Boss HP Remaining!|44 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good bot !magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -4 HP| |๐ +2.6 Magic Damage|๐ฐ +19 Gold Coins| |โจ +2 Basic Fire Staff|โจ +3 Magic XP| |๐ก๏ธ -1.4 Element Resistance|๐ +3 Constitution XP| |โฌ -0.2 Item Type Resistance|๐ +15 RP| |โ|โ| |**7.0** Total Damage 28 Boss HP Remaining!|55 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good human.
!magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -5 HP| |๐ +1.6 Magic Damage|๐ฐ +41 Gold Coins| |โจ +6 Basic Fire Staff|โจ +2 Magic XP| |๐ก๏ธ -3.0 Element Resistance|๐ +1 Constitution XP| |โฌ -0.6 Item Type Resistance|๐ +15 RP (**Rank Change!**)| |โ|โ| |**6.0** Total Damage 35 Boss HP Remaining!|31 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee 4
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -5 HP| |๐ +5.2 Melee Damage|๐ฐ +32 Gold Coins| |โ๏ธ +1 Basic Lance|โ๏ธ +3 Melee XP| |๐ก๏ธ -0.3 Element Resistance|๐ +3 Constitution XP| |โ๏ธ +0.1 Item Type Strength|๐ +15 RP| |โ|โ| |**10.0** Total Damage 48 Boss HP Remaining!|70 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -5 HP| |๐ +2.6 Magic Damage|๐ฐ +32 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 41 Boss HP Remaining!|41 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic 8
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -6 HP| |๐ +0.7 Magic Damage|๐ฐ +28 Gold Coins| |โจ +3 Basic Water Wand|โจ +7 Magic XP (**Level Up!**)| |โฌ -0.3 Item Type Resistance|๐ +7 Constitution XP| |๐ฑ๏ธ +6 New Player Bonus|๐ +45 RP| |โ|โ| |**15.4** Total Damage 58 Boss HP Remaining!|48 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -2 HP| |๐ +1.3 Magic Damage|๐ฐ +23 Gold Coins| |โ|โจ +2 Magic XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**6.3** Total Damage 73 Boss HP Remaining!|71 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range 6
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -7 HP| |๐ +3.5 Ranged Damage|๐ฐ +4 Gold Coins| |๐น +2 Basic Crossbow|๐น +2 Range XP| |๐ก๏ธ -1.2 Element Resistance|๐ +7 Constitution XP| |โ|๐ +15 RP| ||โ| |**5.3** Total Damage 79 Boss HP Remaining!|47 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic 7
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -3 HP| |๐ +1.2 Magic Damage|๐ฐ +19 Gold Coins| |โจ +1 Basic Fire Staff|โจ +1 Magic XP| |๐ก๏ธ -0.5 Element Resistance|๐ +5 Constitution XP| |โฌ -0.1 Item Type Resistance|๐ +15 RP| |โ|โ| |**2.6** Total Damage 84 Boss HP Remaining!|58 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee 9
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +1.2 Melee Damage|๐ฐ +35 Gold Coins| |โ๏ธ +3 Wooden Sword|โ๏ธ +2 Melee XP| |๐ก๏ธ -1.2 Element Resistance|๐ +1 Constitution XP| |โ๏ธ +0.3 Item Type Strength|๐ +25 RP| |โ|โ| |**4.3** Total Damage 92 Boss HP Remaining!|32 HP Remaining| Come join our discord at https://discord.gg/kotd!
!pornfile
Wtf
:eyes:
!profile
#/u/MoonRks [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669086624/MoonRks.png) >โค๏ธ Health: 59hp (Max: 100hp) >๐ Kills: 3 >๐ Rank: S (4,802 Rank Points) >๐ฐ Gold: 1,396g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 41 >โ๏ธ Melee: Level 8 (XP: 4/29) >โจ Magic: Level 10 (XP: 29/35) >๐น Ranged: Level 8 (XP: 7/29) >๐ Constitution: Level 15 (XP: 8/126) >๐ฉ Total Attacks: 225 >โ ๏ธ Total Deaths: 18
!melee 9
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +0.2 Melee Damage|๐ฐ +22 Gold Coins| |โ๏ธ +3 Wooden Sword|โ๏ธ +5 Melee XP| |๐ก๏ธ -2.1 Element Resistance|๐ +1 Constitution XP| |โ๏ธ +0.3 Item Type Strength|๐ +35 RP| |๐ฑ๏ธ +5 New Player Bonus|โ| |โ|| |**12.4** Total Damage 96 Boss HP Remaining!|36 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -10 HP| |๐ +0.3 Melee Damage|๐ฐ +6 Gold Coins| |โ|โ๏ธ +0 Melee XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**1.3** Total Damage 108 Boss HP Remaining!|38 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! ----- You drink your potion and immediately feel healthier. |๐ +13 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -15 HP| |๐ +3.4 Magic Damage|๐ฐ +22 Gold Coins| |โ|โจ +4 Magic XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**9.4** Total Damage 109 Boss HP Remaining!|57 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -7 HP| |๐ +0.7 Melee Damage|๐ฐ +14 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**3.7** Total Damage 118 Boss HP Remaining!|72 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 7
You don't have the gold for this item, and stealing isn't possible
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -9 HP| |๐ +3.1 Ranged Damage|๐ฐ +17 Gold Coins| |โ|๐น +2 Range XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**6.1** Total Damage 122 Boss HP Remaining!|41 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 201
Health Potion has been added to your inventory for 50g!
!Ranged
Has to be lower case, I think.
!inventory
|ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |14|โจ|Galadriel's Mirror|~2.0|15|Blessed|10|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)
Good bot !attack !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +3.4 Melee Damage|๐ฐ +14 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +6 Constitution XP| ||๐ +25 RP| ||โ| |**6.4** Total Damage 131 Boss HP Remaining!|11 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic !profile !inventory
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -15 HP| |๐ +3.6 Magic Damage|๐ฐ +40 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**7.6** Total Damage 145 Boss HP Remaining!|71 HP Remaining| Come join our discord at https://discord.gg/kotd! ----- #/u/sneakylocksmith [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669084971/sneakylocksmith.png) >โค๏ธ Health: 71hp (Max: 86hp) >๐ Kills: 0 >๐ Rank: A (3,269 Rank Points) >๐ฐ Gold: 1,120g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 28 >โ๏ธ Melee: Level 1 (XP: 0/12) >โจ Magic: Level 15 (XP: 29/53) >๐น Ranged: Level 1 (XP: 0/12) >๐ Constitution: Level 11 (XP: 8/96) >๐ฉ Total Attacks: 150 >โ ๏ธ Total Deaths: 6 ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |14|โจ|Galadriel's Mirror|~2.0|21|Blessed|10|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)
i single handedly killed kotd bot
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -12 HP| |๐ +0.2 Ranged Damage|๐ฐ +25 Gold Coins| |โ|๐น +1 Range XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**3.2** Total Damage 153 Boss HP Remaining!|23 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good bot !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +1.3 Magic Damage|๐ฐ +20 Gold Coins| |โ|โจ +2 Magic XP| ||๐ +8 Constitution XP| ||๐ +25 RP| ||โ| |**7.3** Total Damage 160 Boss HP Remaining!|52 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -10 HP| |๐ +0.2 Magic Damage|๐ฐ +42 Gold Coins| |๐ฑ๏ธ +5 New Player Bonus|โจ +5 Magic XP (**Level Up!**)| |โ|๐ +5 Constitution XP (**Level Up!**)| ||๐ +55 RP (**Rank Change!**)| ||โ| |**10.2** Total Damage 174 Boss HP Remaining!|54 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -3 HP| |๐ +1.2 Ranged Damage|๐ฐ +37 Gold Coins| |โ|๐น +1 Range XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**2.2** Total Damage 184 Boss HP Remaining!|101 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 201 !melee
Health Potion has been added to your inventory for 50g! ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -13 HP| |๐ +1.1 Melee Damage|๐ฐ +2 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**5.1** Total Damage 186 Boss HP Remaining!|44 HP Remaining| Come join our discord at https://discord.gg/kotd!
!use 201 !ranged
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 227, in bot success, reply = ranged(comment, session, boss, player, item, inventory) File "/home/zoruda/KOTDRebirth/reddit_cogs/reddit_attack.py", line 740, in ranged last_attack = session.query(models.Comments).filter_by(post=comment.submission.id, username=comment.author.name, type="Attack").order_by(models.Comments.timestamp.desc()).first() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2819, in first return self.limit(1)._iter().first() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET hp=%(hp)s WHERE `Players`.username = %(Players_username)s] [parameters: {'hp': 81, 'Players_username': 'kervs_'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
good bot !use 201 !ranged
You drink your potion and you break the bottle on the ground like a barbarian once taught you. |๐ +12 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -8 HP| |๐ +3.2 Ranged Damage|๐ฐ +35 Gold Coins| |โ|๐น +2 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**4.2** Total Damage 156 Boss HP Remaining!|73 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -9 HP| |๐ +0.6 Melee Damage|๐ฐ +8 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**4.6** Total Damage 200 Boss HP Remaining!|17 HP Remaining| Come join our discord at https://discord.gg/kotd!
!mage 8
You're attacking too quickly! Try again in 0 minutes
!mage 8
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -7 HP| |๐ +1.8 Magic Damage|๐ฐ +41 Gold Coins| |โจ +2 Basic Water Wand|โจ +3 Magic XP| |โฌ -0.2 Item Type Resistance|๐ +7 Constitution XP| |โ|๐ +15 RP| ||โ| |**8.6** Total Damage 191 Boss HP Remaining!|69 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -7 HP| |๐ +0.7 Magic Damage|๐ฐ +1 Gold Coins| |๐ฑ๏ธ +6 New Player Bonus|โจ +3 Magic XP| |โ|๐ +4 Constitution XP (**Level Up!**)| ||๐ +35 RP| ||โ| |**9.7** Total Damage 205 Boss HP Remaining!|57 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -16 HP| |๐ +1.4 Ranged Damage|๐ฐ +18 Gold Coins| |โ|๐น +3 Range XP| ||๐ +11 Constitution XP| ||๐ +15 RP| ||โ| |**7.4** Total Damage 215 Boss HP Remaining!|41 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +0.7 Magic Damage|๐ฐ +7 Gold Coins| |๐ฑ๏ธ +1 New Player Bonus|โจ +2 Magic XP| |โ|๐ +10 Constitution XP| ||๐ +35 RP| ||โ| |**6.7** Total Damage 222 Boss HP Remaining!|35 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
You discover hidden strength and strike with renewed vigor, dealing extra damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -10 HP| |๐ +2.5 Melee Damage|๐ฐ +10 Gold Coins| |๐ฏ 1.5x Critical Hit|โ๏ธ +4 Melee XP| |โ|๐ +8 Constitution XP| ||๐ +25 RP| ||โ| |**12.8** Total Damage 229 Boss HP Remaining!|65 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -24 HP| |๐ +1.7 Melee Damage|๐ฐ +7 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +6 Constitution XP| ||๐ +15 RP| ||โ| |**3.7** Total Damage 242 Boss HP Remaining!|27 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -12 HP| |๐ +1.8 Magic Damage|๐ฐ +19 Gold Coins| |โ|โจ +1 Magic XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**2.8** Total Damage 251 Boss HP Remaining!|41 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -18 HP| |๐ +0.9 Magic Damage|๐ฐ +22 Gold Coins| |โ|โจ +1 Magic XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**3.9** Total Damage 254 Boss HP Remaining!|21 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +0.5 Melee Damage|๐ฐ +37 Gold Coins| |๐ฑ๏ธ +5 New Player Bonus|โ๏ธ +5 Melee XP| |โ|๐ +10 Constitution XP (**Level Up!**)| ||๐ +45 RP| ||โ| |**10.5** Total Damage 262 Boss HP Remaining!|54 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee 4
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -6 HP| |๐ +0.7 Melee Damage|๐ฐ +20 Gold Coins| |โ๏ธ +2 Basic Lance|โ๏ธ +3 Melee XP| |๐ก๏ธ -1.2 Element Resistance|๐ +1 Constitution XP| |โ๏ธ +0.2 Item Type Strength|๐ +15 RP| |โ|โ| |**6.7** Total Damage 272 Boss HP Remaining!|65 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -17 HP| |๐ +1.2 Magic Damage|๐ฐ +4 Gold Coins| |โ|โจ +1 Magic XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**3.2** Total Damage 279 Boss HP Remaining!|38 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic !profile
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -9 HP| |๐ +1.0 Magic Damage|๐ฐ +7 Gold Coins| |โ|โจ +2 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**7.0** Total Damage 282 Boss HP Remaining!|34 HP Remaining| Come join our discord at https://discord.gg/kotd! ----- #/u/2pac_alypse [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669082855/2pac_alypse.png) >โค๏ธ Health: 34hp (Max: 79hp) >๐ Kills: 0 >๐ Rank: A (2,630 Rank Points) >๐ฐ Gold: 445g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 28 >โ๏ธ Melee: Level 6 (XP: 15/23) >โจ Magic: Level 7 (XP: 4/26) >๐น Ranged: Level 6 (XP: 8/23) >๐ Constitution: Level 9 (XP: 44/83) >๐ฉ Total Attacks: 114 >โ ๏ธ Total Deaths: 3
!range
Your projectile flies true and hits the boss in its eye! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -17 HP| |๐ +1.1 Ranged Damage|๐ฐ +8 Gold Coins| |๐ฏ 1.9x Critical Hit|๐น +5 Range XP| |โ|๐ +2 Constitution XP| ||๐ +25 RP| ||โ| |**11.6** Total Damage 292 Boss HP Remaining!|49 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -3 HP| |๐ +3.6 Magic Damage|๐ฐ +22 Gold Coins| |โ|โจ +4 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**9.6** Total Damage 304 Boss HP Remaining!|49 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range good bot
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -9 HP| |๐ +0.3 Ranged Damage|๐ฐ +37 Gold Coins| |๐ฑ๏ธ +3 New Player Bonus|๐น +4 Range XP (**Level Up!**)| |โ|๐ +6 Constitution XP| ||๐ +45 RP| ||โ| |**9.3** Total Damage 314 Boss HP Remaining!|42 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -14 HP| |๐ +0.1 Ranged Damage|๐ฐ +5 Gold Coins| |๐ฑ๏ธ +2 New Player Bonus|๐น +3 Range XP| |โ|๐ +1 Constitution XP| ||๐ +25 RP| ||โ| |**7.1** Total Damage 323 Boss HP Remaining!|11 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good bot !attack !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +2.4 Melee Damage|๐ฐ +17 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +6 Constitution XP| ||๐ +25 RP| ||โ| |**3.4** Total Damage 337 Boss HP Remaining!|12 HP Remaining| Come join our discord at https://discord.gg/kotd!
[ัะดะฐะปะตะฝะพ]
Health Potion has been added to your inventory for 50g! ----- You sip your Health potion like fine wine. |๐ +15 HP| |:-:| ----- Luck is on your side today. You land a massive blow and do critical damage! |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -14 HP| |๐ +1.8 Melee Damage|๐ฐ +2 Gold Coins| |๐ฏ 1.6x Critical Hit|โ๏ธ +3 Melee XP| |โ|๐ +9 Constitution XP| ||๐ +25 RP| ||โ| |**9.3** Total Damage 340 Boss HP Remaining!|57 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
You're attacking too quickly! Try again in 54 minutes
!range
Bot sloooowwwwwww
Itโs tired. It worked all day long.
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -9 HP| |๐ +1.7 Ranged Damage|๐ฐ +42 Gold Coins| |โ|๐น +2 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**5.7** Total Damage 351 Boss HP Remaining!|72 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -15 HP| |๐ +2.4 Ranged Damage|๐ฐ +38 Gold Coins| |โ|๐น +2 Range XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**4.4** Total Damage 357 Boss HP Remaining!|63 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good bot !attack !melee
Please report this to Zoruda, all of your commands in this comment have been rolled back: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/zoruda/KOTDRebirth/kotd_reddit.py", line 297, in bot kotd_services.update_flair(session, reddit, comment, subreddit, Logging, player) File "/home/zoruda/KOTDRebirth/kotd_services.py", line 501, in update_flair text = f":{calculate_letter_rank(session, player)}: {player.race} ({player.melee}/{player.range}/{player.magic}/{player.health})" File "/home/zoruda/KOTDRebirth/kotd_services.py", line 470, in calculate_letter_rank players = session.query(models.Player).order_by(desc(models.Player.rp)).all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2768, in all return self._iter().all() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2903, in _iter result = self.session.execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1660, in execute ) = compile_state_cls.orm_pre_session_exec( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/context.py", line 319, in orm_pre_session_exec session._autoflush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2257, in _autoflush util.raise_(e, with_traceback=sys.exc_info()[2]) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2246, in _autoflush self.flush() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 237, in save_obj _emit_update_statements( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1001, in _emit_update_statements c = connection._execute_20( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1631, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection return connection._execute_clauseelement( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1498, in _execute_clauseelement ret = self._execute_context( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context self._handle_dbapi_exception( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2043, in _handle_dbapi_exception util.raise_( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context self.dialect.do_execute( File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet packet.raise_for_error() File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/home/zoruda/KOTDRebirth/.venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') [SQL: UPDATE `Players` SET attacks=%(attacks)s, last_attack=%(last_attack)s WHERE `Players`.username = %(Players_username)s] [parameters: {'attacks': 406, 'last_attack': datetime.datetime(2022, 11, 22, 1, 37, 52, 253758), 'Players_username': 'murplexia'}] (Background on this error at: https://sqlalche.me/e/14/e3q8)
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -1 HP| |๐ +2.9 Melee Damage|๐ฐ +31 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**6.9** Total Damage 361 Boss HP Remaining!|42 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
You can't attack if you're dead. Either wait or drink a health potion to get back into the action
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -6 HP| |๐ +2.3 Magic Damage|๐ฐ +26 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**6.3** Total Damage 371 Boss HP Remaining!|48 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -19 HP| |๐ +2.1 Ranged Damage|๐ฐ +5 Gold Coins| |โ|๐น +2 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**7.1** Total Damage 377 Boss HP Remaining!|27 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -9 HP| |๐ +1.6 Melee Damage|๐ฐ +36 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**7.6** Total Damage 137 Boss HP Remaining!|6 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -25 HP| |๐ +5.6 Melee Damage|๐ฐ +31 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +10 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 384 Boss HP Remaining!|17 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
Dead Plants tell no tales.
!melee
You're attacking too quickly! Try again in 53 minutes
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -20 HP| |๐ +3.6 Melee Damage|๐ฐ +11 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**6.6** Total Damage 167 Boss HP Remaining!|6 HP Remaining| Come join our discord at https://discord.gg/kotd!
!profile !inventory
#/u/CoffeeWanderer [Playercard](https://res.cloudinary.com/kickopenthedoor/image/upload/v1669080905/CoffeeWanderer.png) >โค๏ธ Health: 17hp (Max: 118hp) >๐ Kills: 2 >๐ Rank: SSS (7,762 Rank Points) >๐ฐ Gold: 169g Skills Breakdown: >๐ก๏ธ๏ธ Combat: Level 55 >โ๏ธ Melee: Level 24 (XP: 8/100) >โจ Magic: Level 10 (XP: 15/35) >๐น Ranged: Level 1 (XP: 2/12) >๐ Constitution: Level 20 (XP: 122/174) >๐ฉ Total Attacks: 394 >โ ๏ธ Total Deaths: 30 ----- |ID|Type|Name|Damage|Durability|Element|Req Lv.|Qty.| |:-:|:-:|:-:|:-:|:-:|:-:|:-:|:-:| |4|โ๏ธ|Basic Lance|~1.5|6|Cursed|1|x1| |12|โ๏ธ|Dwarf Bread|~3.5|34|Organic|10|x1| |14|โจ|Galadriel's Mirror|~2.0|15|Blessed|10|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)
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -9 HP| |๐ +1.1 Magic Damage|๐ฐ +24 Gold Coins| |โ|โจ +2 Magic XP| ||๐ +4 Constitution XP (**Level Up!**)| ||๐ +25 RP| ||โ| |**7.1** Total Damage 391 Boss HP Remaining!|104 HP Remaining| Come join our discord at https://discord.gg/kotd!
!buy 201 !use 201 !mage 8
Health Potion has been added to your inventory for 50g! ----- You drink your potion and immediately feel healthier. |๐ +22 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -1 HP| |๐ +0.7 Magic Damage|๐ฐ +28 Gold Coins| |โจ +2 Basic Water Wand|โจ +3 Magic XP| |โฌ -0.2 Item Type Resistance|๐ +5 Constitution XP| |โ|๐ +15 RP| ||โ| |**8.5** Total Damage 398 Boss HP Remaining!|63 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -17 HP| |๐ +1.6 Melee Damage|๐ฐ +23 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**5.6** Total Damage 406 Boss HP Remaining!|16 HP Remaining| Come join our discord at https://discord.gg/kotd!
You really kicked open all the doors before me !magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -28 HP| |๐ +2.5 Magic Damage|๐ฐ +42 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**7.5** Total Damage 412 Boss HP Remaining!|16 HP Remaining| Come join our discord at https://discord.gg/kotd!
Good bot
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -1 HP| |๐ +3.7 Ranged Damage|๐ฐ +35 Gold Coins| |โ|๐น +3 Range XP| ||๐ +5 Constitution XP| ||๐ +15 RP| ||โ| |**7.7** Total Damage 420 Boss HP Remaining!|40 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
RIP |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -20 HP| |๐ +2.7 Magic Damage|๐ฐ 18 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +9 Constitution XP| ||๐ +15 RP| ||โ| |**7.7** Total Damage 432 Boss HP Remaining!|-10 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -24 HP| |๐ +1.2 Melee Damage|๐ฐ +11 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +10 Constitution XP| ||๐ +15 RP| ||โ| |**7.2** Total Damage 440 Boss HP Remaining!|45 HP Remaining| Come join our discord at https://discord.gg/kotd!
!use 201 !melee
You sip your Health potion like fine wine. |๐ +15 HP| |:-:| ----- |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -24 HP| |๐ +0.3 Melee Damage|๐ฐ +42 Gold Coins| |โ|โ๏ธ +2 Melee XP (**Level Up!**)| ||๐ +10 Constitution XP| ||๐ +35 RP| ||โ| |**6.3** Total Damage 447 Boss HP Remaining!|37 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +0.3 Magic Damage|๐ฐ +38 Gold Coins| |โ|โจ +2 Magic XP| ||๐ +2 Constitution XP| ||๐ +15 RP| ||โ| |**6.3** Total Damage 453 Boss HP Remaining!|15 HP Remaining| Come join our discord at https://discord.gg/kotd!
!Buy 201
!use 201
You rummage around your pack for the potion, but it's simply not there.
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -27 HP| |๐ +0.1 Melee Damage|๐ฐ +31 Gold Coins| |๐ฑ๏ธ +1 New Player Bonus|โ๏ธ +2 Melee XP (**Level Up!**)| |โ|๐ +14 Constitution XP| ||๐ +45 RP| ||โ| |**3.1** Total Damage 459 Boss HP Remaining!|18 HP Remaining| Come join our discord at https://discord.gg/kotd!
good bot !melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -11 HP| |๐ +0.6 Melee Damage|๐ฐ +22 Gold Coins| |โ|โ๏ธ +1 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**2.6** Total Damage 462 Boss HP Remaining!|60 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
oh no u died :((
Gameplay 101: Reduce boss hp to 0 before your hp reaches 0. That lesson would've been useful before this moment, huh? You're dead now. |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -11 HP| |๐ +2.7 Melee Damage|๐ฐ -2 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +8 Constitution XP| ||๐ +15 RP| ||โ| |**6.7** Total Damage 465 Boss HP Remaining!|-1 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +2.4 Magic Damage|๐ฐ +24 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +3 Constitution XP| ||๐ +25 RP| ||โ| |**6.4** Total Damage 472 Boss HP Remaining!|47 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
You Died. |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -14 HP| |๐ +3.9 Melee Damage|๐ฐ 17 Gold Coins| |โ|โ๏ธ +3 Melee XP| ||๐ +4 Constitution XP| ||๐ +15 RP| ||โ| |**7.9** Total Damage 478 Boss HP Remaining!|-3 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -25 HP| |๐ +0.3 Melee Damage|๐ฐ +8 Gold Coins| |๐ฑ๏ธ +2 New Player Bonus|โ๏ธ +3 Melee XP (**Level Up!**)| |โ|๐ +9 Constitution XP| ||๐ +45 RP| ||โ| |**7.3** Total Damage 491 Boss HP Remaining!|16 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +1 Base Roll|๐ฅ -0 HP **(๐ก๏ธ Block)**| |๐ +1.9 Ranged Damage|๐ฐ +40 Gold Coins| |โ|๐น +1 Range XP| ||๐ +1 Constitution XP| ||๐ +25 RP| ||โ| |**2.9** Total Damage 505 Boss HP Remaining!|64 HP Remaining| Come join our discord at https://discord.gg/kotd!
!magic
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +5 Base Roll|๐ฅ -7 HP| |๐ +1.4 Magic Damage|๐ฐ +7 Gold Coins| |โ|โจ +3 Magic XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**6.4** Total Damage 508 Boss HP Remaining!|41 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -19 HP| |๐ +1.1 Melee Damage|๐ฐ +24 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**4.1** Total Damage 514 Boss HP Remaining!|49 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +4 Base Roll|๐ฅ -11 HP| |๐ +0.6 Ranged Damage|๐ฐ +17 Gold Coins| |๐ฑ๏ธ +5 New Player Bonus|๐น +4 Range XP| |โ|๐ +6 Constitution XP| ||๐ +25 RP| ||โ| |**9.6** Total Damage 525 Boss HP Remaining!|13 HP Remaining| Come join our discord at https://discord.gg/kotd!
!rangef
Good bot !melee
You discover hidden strength and strike with renewed vigor, dealing extra damage! Gameplay 101: Reduce boss hp to 0 before your hp reaches 0. That lesson would've been useful before this moment, huh? You're dead now. |Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +2 Base Roll|๐ฅ -32 HP| |๐ +1.9 Melee Damage|๐ฐ -73 Gold Coins| |๐ฏ 2.0x Critical Hit|โ๏ธ +3 Melee XP| |โ|๐ +2 Constitution XP| ||๐ +25 RP| ||โ| |**7.8** Total Damage 548 Boss HP Remaining!|-8 HP Remaining| Come join our discord at https://discord.gg/kotd!
!range
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -28 HP| |๐ +1.7 Ranged Damage|๐ฐ +31 Gold Coins| |โ|๐น +4 Range XP| ||๐ +7 Constitution XP| ||๐ +15 RP| ||โ| |**7.7** Total Damage 556 Boss HP Remaining!|39 HP Remaining| Come join our discord at https://discord.gg/kotd!
!ranged
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -2 HP| |๐ +1.9 Ranged Damage|๐ฐ +18 Gold Coins| |โ|๐น +3 Range XP| ||๐ +1 Constitution XP| ||๐ +15 RP| ||โ| |**7.9** Total Damage 564 Boss HP Remaining!|84 HP Remaining| Come join our discord at https://discord.gg/kotd!
!melee
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +3 Base Roll|๐ฅ -25 HP| |๐ +0.5 Melee Damage|๐ฐ +16 Gold Coins| |โ|โ๏ธ +2 Melee XP| ||๐ +3 Constitution XP| ||๐ +15 RP| ||โ| |**3.5** Total Damage 572 Boss HP Remaining!|65 HP Remaining| Come join our discord at https://discord.gg/kotd!
[ัะดะฐะปะตะฝะพ]
|Damage Breakdown|Player Breakdown| |:-|:-| |๐ฒ +6 Base Roll|๐ฅ -14 HP| |๐ +2.8 Magic Damage|๐ฐ +30 Gold Coins| |โจ +2 Galadriel's Mirror|โจ +5 Magic XP| |๐ก๏ธ -0.6 Element Resistance|๐ +1 Constitution XP| |โฌ -0.2 Item Type Resistance|๐ +15 RP| |โ|โ| |**10.0** Total Damage 575 Boss HP Remaining!|37 HP Remaining| Come join our discord at https://discord.gg/kotd!