Anope Bug Tracker - Anope Stable (2.0.x series)
View Issue Details
0001724Anope Stable (2.0.x series)[All Projects] Generalpublic2019-07-22 23:012019-07-24 08:33
simos 
 
normalminoralways
newopen 
0001724: NS SET KILL doesn't update fields on mysql table
Running /NS SET KILL have some problem updating data on mysql.

NS SET KILL on work fine and set 1 on KILLPROTECT sql field
NS SET KILL quick work fine and set 1 on KILL_QUICK sql field
NS SET KILL immed work fine and set 1 on KILL_IMMED sql field

everything look work fine until you have set KILL QUICK or KILL IMMED , than sql data are no more correctly updated, ns set kill off, ns set kill immed and ns set kill quick set right value for your account but not on mysql table, this until you run NS SET KILL ON again wich update mysql table settings KILLPROTECT to 1 and NULL on the other.

Not tested on mysq live.
trying the steps in description.
No tags attached.
Issue History
2019-07-22 23:01simosNew Issue
2019-07-24 00:53simosNote Added: 0006855
2019-07-24 00:54simosNote Deleted: 0006855
2019-07-24 00:54simosNote Added: 0006856
2019-07-24 08:33genius3000Note Added: 0006857

Notes
(0006857)
genius3000   
2019-07-24 08:33   
I can reproduce this using m_sqlite and both db_sql and db_sql_live.
In exact order:
NS SET KILL on: updates the DB
NS SET KILL quick: updates the DB
NS SET KILL immed: does not update the DB
NS SET KILL off: does not update the DB
NS SET KILL on: updates the DB
NS SET KILL off: updates the DB

It seems like "on" helps reset the issue and the next command works, but then they stop working.
(0006856)
simos   
2019-07-24 00:54   
I've set debug on and look for query, it seems that anope don't execute query if immed or quick is set until you run again ns set kill on .