Plugin:Users MySQL

The MySQL Users plugin was created so user information (username, password, user flags) can be stored in a MySQL database.

Contents 1 IPC Messages Supported 2 Configuration 3 MySQL Database 4 Developer Info

IPC Messages Supported

IB_GETUSERINFO
IB_ADD_USER
IB_DEL_USER
IB_ADD_HOSTMASK
IB_DEL_HOSTMASK
IB_DEL_HOSTMASKS
IB_CHANGE_FLAGS
IB_CHANGE_PASS

Configuration

Configuration Page

MySQL Database

IRCBot will create 2 tables, one called IRCBot_Users and IRCBot_UserHostmasks.

Developer Info

Passwords are stored using MySQL's built-in AES encryption. This is simple to use so shouldn't be a problem for any PHP developer.

Example reading a user including decrypting password: SELECT *,AES_DECRYPT(Pass, 'EncKey') AS dPass FROM IRCBot_Users WHERE Nick='somenick';

Example updating a user's password: UPDATE IRCBot_Users SET Pass=AES_ENCRYPT('new_password', 'EncKey') WHERE Nick='somenick';