summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAdam <Adam@anope.org>2012-11-24 02:15:19 -0500
committerAdam <Adam@anope.org>2012-11-24 02:15:19 -0500
commit002f00d7ebf6c50b87b91cc328526bc1f58f6031 (patch)
tree7a424e34ef2f511cfc520449a19acb144f26a02c
parentded89b0d4939c4c1b9bbbb9007cd12286ff077a0 (diff)
Add IP.Board m_sql_authentication query to modules.example.conf, from Genesis2001
-rw-r--r--data/modules.example.conf3
1 files changed, 2 insertions, 1 deletions
diff --git a/data/modules.example.conf b/data/modules.example.conf
index 299dd1818..a9c7d5cb9 100644
--- a/data/modules.example.conf
+++ b/data/modules.example.conf
@@ -373,7 +373,8 @@ m_sql_authentication
* 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`))"
+ * vBulletin: "SELECT `email` FROM `user` WHERE `username` = @a@ AND `password` = MD5(CONCAT(MD5(@p@), `salt`))"
+ * IP.Board: "SELECT `email` FROM `ibf_members` WHERE `name` = @a@ AND `members_pass_hash` = MD5(CONCAT(MD5(`members_pass_salt`), MD5(@p@)))"
*/
query = "SELECT `email_addr` AS `email` FROM `my_users` WHERE `username` = @a@ AND `password` = MD5(CONCAT('salt', @p@))"