Plugin:Users MySQL
Jump to navigation
Jump to search
The MySQL Users plugin was created so user information (username, password, user flags) can be stored in a MySQL database.
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
MySQL Database
RadioBot will create 2 tables, one called RadioBot_Users and RadioBot_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 RadioBot_Users WHERE Nick='somenick';
Example updating a user's password: UPDATE RadioBot_Users SET Pass=AES_ENCRYPT('new_password', 'EncKey') WHERE Nick='somenick';