diff options
| author | lethality <lethality@anope.org> | 2012-09-29 23:55:55 +0100 |
|---|---|---|
| committer | lethality <lethality@anope.org> | 2012-09-29 23:55:55 +0100 |
| commit | 74117a1e1e48faf71af8e8c75773ebb9b6c81510 (patch) | |
| tree | 05d1c86f15d1234d67a274f383c9210a4672bbb6 | |
| parent | 38ad523f91c5b89cebd01e6e0f61ea8859c02253 (diff) | |
added some example sql queries
| -rw-r--r-- | data/modules.example.conf | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/data/modules.example.conf b/data/modules.example.conf index 31a24d41e..db8b555ba 100644 --- a/data/modules.example.conf +++ b/data/modules.example.conf @@ -364,6 +364,13 @@ m_sql_authentication */ query = "SELECT `email_addr` AS `email` FROM `my_users` WHERE `username` = @a@ AND `password` = MD5(CONCAT('salt', @p@))" + /* We've also included some example queries for some popular website/forum systems. + * + * Drupal 6: "SELECT `mail` AS `email` FROM `users` WHERE `name` = @a@ AND `pass` = MD5(@p@) AND `status` = 1" + * e107 cms: "SELECT `user_email` AS `email` FROM `e107_user` WHERE `user_loginname` = @a@ AND `user_password` = MD5(@p@)" + * SMF Forum: "SELECT `email_address` AS `email` FROM `smf_members` WHERE `member_name` = @a@ AND `passwd` = SHA1(CONCAT(LOWER(@a@), @p@))" + * vBulletin: "SELECT `email` AS `email` FROM `user` WHERE `username` = @a@ AND `password` = MD5(CONCAT(MD5(@p@), `salt`))" + /* * Enable to have this module disable /nickserv register. */ |