Das hier laufende Wiki wurde so angepasst, dass es die Wiki Benutzer über die auch von Xoops verwendete Datenbank authoriesiert werden. Ein Benutzer des Xoops kann sich mit seinen Anmeldedaten auch hier im Wiki anmelden. Umgekehrt wir ein Benutzer der sich im Wiki Registriert auch im Xoops Angelegt und kann dieses mit seien Anmeldedaten verwenden.

  <?php
  /*
  This is an example of how a local.php could look like.
  Simply copy the options you want to change from dokuwiki.php
  to this file and change them
  */
  
  $conf['passcrypt'] = 'md5';
  $conf['authtype'] = 'mysql';
  $conf['defaultgroup'] = 'registered_users';
  
  $conf['auth']['mysql']['server']   = 'localhost';
  $conf['auth']['mysql']['user']     = 'lalal';
  $conf['auth']['mysql']['password'] = 'secret';
  
  $conf['auth']['mysql']['database'] = 'databasname';
  $conf['auth']['mysql']['getpass']= "SELECT pass
                                        FROM xoops_users
                                       WHERE uname='%u'";
  
  $conf['auth']['mysql']['userinfo'] = "SELECT name, email AS mail
                                        FROM xoops_users 
                                       WHERE uname='%u'";
  
  $conf['auth']['mysql']['groups']   = "SELECT a.name AS `group`
                                        FROM xoops_groups a,
					     xoops_users b,
					     xoops_groups_users_link c
                                       WHERE a.groupid = c.groupid
                                         AND c.uid = b.uid
                                         AND b.uname='%u'";
   
  $conf['auth']['mysql']['adduser'] = "INSERT INTO xoops_users
                                             SET uname = '%u',
                                                 pass = '%p',
                                                 name = '%n',
                                                 email = '%e',
						 url = '',
						 user_avatar = 'blank.gif',
						 user_regdate = '',
						 user_icq = '',
						 user_from = 'wikiUser',
                                                 user_sig = '',
						 user_viewemail = '0',
						 user_aim = '',
						 user_yim = '',
						 user_msnm = '',
						 posts = '0',
						 attachsig = '0',
						 rank = '0',
						 level= '1',
						 theme = '',
						 timezone_offset = '0.0',
						 umode = 'flat',
						 last_login = '',
						 uorder = '0',
						 notify_method = '1',
						 notify_mode = '0',
						 user_occ = '',
						 bio = '',
						 user_intrest = '',
						 user_mailok = '1'";
  
  
  
  
  // $conf['auth']['mysql']['addusergroup']= "INSERT INTO flyspray_users_in_groups
  //                                                (user_id,group_id) VALUES ('%uid', '%gid')";
  
  $conf['auth']['mysql']['getgroupid']  = "SELECT groupid as `gid`
                                           FROM xoops_groups
                                          WHERE name='%g'";
  
  $conf['auth']['mysql']['addusergroup']= "INSERT INTO xoops_groups_users_link
                                          SET groupid = '2',
					      uid = '%uid'";
  ?>

— Bernd 2005/10/27 13:02