Hello, I'm currently using the misc_sqlcmd module to register users from the site, but my last main issue is detecting if a nickname is registered or not.
At first i was querying my Denora user table and checking for Y on +r, but then i noticed if user logs out of room unauthed that its left to N.
Then theres the issue of the mysql tables only updating after such time (2hrs?) so new user registration wont be able to detect that a nick is registered until then...
So im really out of clues on my own for doing this.
Does anyone have an idea on best approach to detecting this? The only thing i can think of is a module that syncs a db table itself for registered nicks, but thats a lil bit duplication of data. Is that likely going to be my only option?