https://wiki.shoutirc.com/index.php?action=history&feed=atom&title=Plugin%3AUsers_MySQLPlugin:Users MySQL - Revision history2026-04-29T03:28:32ZRevision history for this page on the wikiMediaWiki 1.43.0https://wiki.shoutirc.com/index.php?title=Plugin:Users_MySQL&diff=4421&oldid=prevIndy: Text replacement - "IRCBot" to "RadioBot"2013-10-25T14:13:00Z<p>Text replacement - "IRCBot" to "RadioBot"</p>
<p><b>New page</b></p><div>The MySQL Users [[Plugins|plugin]] was created so user information (username, password, user flags) can be stored in a MySQL database.<br />
[[Category:RadioBot Plugins|Users_MySQL]]<br />
<br />
==[[IPC Messages]] Supported==<br />
IB_GETUSERINFO<br />
IB_ADD_USER<br />
IB_DEL_USER<br />
IB_ADD_HOSTMASK<br />
IB_DEL_HOSTMASK<br />
IB_DEL_HOSTMASKS<br />
IB_CHANGE_FLAGS<br />
IB_CHANGE_PASS<br />
<br />
==Configuration==<br />
[[Configuration:Users_MySQL|Configuration Page]]<br />
<br />
==MySQL Database==<br />
RadioBot will create 2 tables, one called RadioBot_Users and RadioBot_UserHostmasks.<br />
<br />
==Developer Info==<br />
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.<br /><br />
<br />
Example reading a user including decrypting password:<br />
SELECT *,AES_DECRYPT(Pass, 'EncKey') AS dPass FROM RadioBot_Users WHERE Nick='somenick';<br />
<br />
Example updating a user's password:<br />
UPDATE RadioBot_Users SET Pass=AES_ENCRYPT('new_password', 'EncKey') WHERE Nick='somenick';</div>Indy