--- note: i was typing this post but figured out what was wrong before i submitted, so read entire post to see the fix for it at end ---
Ok so i'm trying to register nicknames from my website, and besides the whole 'not in phase 3 for mysql on anope' making it very difficult to find out if a nickname is registered or not, ive encountered a very odd issue.
If I register a nickname with this module, it creates just fine. However, the access list is screwed for first login or something.
Whoever logs into a nick name registered through misc_sqlcmd is automatically identified with full access to that nickname even without supplying password, however they do not get mode +r
Its odd, but /ns logout then identify again and its fine, or connect and be bugged auto identify -> disconnect -> reconnect will lead back to needing to use password.
The very first login only is bugged..
After considering what was wrong, i thought about maybe the 'is currently identified flag isnt being set to false on register'.
And I was right, but the author seems to of intentionally did it..
misc_sqlcmd_nick.c line 175
na->status = (int16) (NS_IDENTIFIED | NS_RECOGNIZED);
This is causing the problem, and simply replacing with
na->status = (int16) 0;
Remedies the issue.
Kinda sad the developer of this module has vanished :/ as its very useful until anope is at the point of not needing it (which will likely be a long time) but hopefully this will help some others experiencing this issue.