Plugin:Users MySQL

From ShoutIRC RadioBot Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

Configuration Page

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';