summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--data/modules.example.conf7
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.
*/