Anope Bug Tracker - Anope Stable (2.0.x series)
View Issue Details
0001679Anope Stable (2.0.x series)[All Projects] Generalpublic2016-05-28 21:532016-11-05 16:37
capitaine 
Adam 
normalminoralways
resolvedfixed 
0001679: IRC2SQL does not update status modes
From IRC2SQL, users status modes like +vho are updated only on join, but not when staying in a channel.
/MODE #Foo +vho John

mysql> SELECT i.modes FROM irc_user AS u, irc_ison AS i, irc_chan AS c WHERE u.nick = "John" AND c.channel = "#Foo" AND u.nickid = i.nickid AND c.chanid = i.chanid;

+-------+
| modes |
+-------+
| |
+-------+
Suggested fix attached
No tags attached.
patch 0001-IRC2SQL-update-status-modes.patch (1,712) 2016-05-28 21:53
https://bugs.anope.org/file_download.php?file_id=360&type=bug
Issue History
2016-05-28 21:53capitaineNew Issue
2016-05-28 21:53capitaineFile Added: 0001-IRC2SQL-update-status-modes.patch
2016-05-28 21:58cronusNote Added: 0006793
2016-05-28 22:07capitaineNote Added: 0006794
2016-05-29 02:54cronusNote Added: 0006795
2016-11-05 16:37AdamNote Added: 0006814
2016-11-05 16:37AdamStatusnew => resolved
2016-11-05 16:37AdamResolutionopen => fixed
2016-11-05 16:37AdamAssigned To => Adam

Notes
(0006814)
Adam   
2016-11-05 16:37   
Thanks, fixed in a5fdf7c546ccb0f70a70543ea8afb54d155a13cc
(0006795)
cronus   
2016-05-29 02:54   
Didn't notice you used another table, Im use to JOINs on other tables :P
(0006794)
capitaine   
2016-05-28 22:07   
I know, my report is about ison.modes, not tables channels.modes nor user.modes
(0006793)
cronus   
2016-05-28 21:58   
That table has modes for user modes, not channel modes. The Channel modes you seek are in the "ison" table.