Insp SQL Theory
From the makers of InspIRCd.
 |
Historical Material - Information posted here may be inaccurate as a result of being obsolete. This information is kept for historical reference purposes. This is a historical page noting our ideas for SQL before the release of 1.0. |
m_sql
This module would be required to make persistent SQL connections to one or more SQL servers. The config syntax would be similar to this:
<database server="127.0.0.1" username="me" password="IAmNotTellingYou" name="My_Database" id="1"> <database server="192.168.0.4" username="me" password="SECRET" name="My_Other_database" id="2">
m_auth
Other SQL modules would use the connections made my m_sql, and reference which connections it uses via <database:id> (as a note, thats my new way of 'referencing' tags), so an example config here would be:
<m_auth connection="1"
table="users"
userfield="username"
passfield="password"
md5="yes/no">
This would allow for an easy intergration of one or more mysql modules, with multiple hosts, as well as multiple with a single host.
This method would also prevent many unneeded SQL connections, if you have multiple modules using the same database.
