ok trying to get dokuwiki intergrated into e107 using latest daily build version of dokuwiki... started to look at what sql conf i need to use not even looked at group parts first just tryng to get it to deny it to non members etc anyway what i am using on config file is <code> $conf['auth']['mysql']['server '] = 'localhost'; $conf['auth']['mysql']['user'] = 'russdev'; $conf['auth']['mysql']['password'] = 'dilbert'; $conf['auth']['mysql']['database'] = 'russdev_com_-_radio'; $conf['auth']['mysql']['passcheck']= "SELECT username AS 'login' FROM e107_user WHERE user_name = '%u' AND user_password = MD5('%p')"; $conf['auth']['mysql']['userinfo'] = "SELECT username AS name, user_email AS mail FROM e107_user WHERE user_name='%u'"; </code> with the auth mode being mysql etc anyway lets me do what i like and does not deny access to non members here is rip of sql table with passwords and emails removed <code> -- phpMyAdmin SQL Dump -- version 2.6.0-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 26, 2005 at 06:24 PM -- Server version: 3.23.58 -- PHP Version: 4.3.2 -- -- Database: `russdev_com_-_radio` -- -- -------------------------------------------------------- -- -- Table structure for table `e107_user` -- CREATE TABLE `e107_user` ( `user_id` int(10) unsigned NOT NULL auto_increment, `user_name` varchar(100) NOT NULL default '', `user_customtitle` varchar(100) NOT NULL default '', `user_password` varchar(32) NOT NULL default '', `user_sess` varchar(32) NOT NULL default '', `user_email` varchar(100) NOT NULL default '', `user_homepage` varchar(150) NOT NULL default '', `user_icq` varchar(10) NOT NULL default '', `user_aim` varchar(100) NOT NULL default '', `user_msn` varchar(100) NOT NULL default '', `user_location` varchar(150) NOT NULL default '', `user_birthday` date NOT NULL default '0000-00-00', `user_signature` text NOT NULL, `user_image` varchar(100) NOT NULL default '', `user_timezone` char(3) NOT NULL default '', `user_hideemail` tinyint(3) unsigned NOT NULL default '0', `user_join` int(10) unsigned NOT NULL default '0', `user_lastvisit` int(10) unsigned NOT NULL default '0', `user_currentvisit` int(10) unsigned NOT NULL default '0', `user_lastpost` int(10) unsigned NOT NULL default '0', `user_chats` int(10) unsigned NOT NULL default '0', `user_comments` int(10) unsigned NOT NULL default '0', `user_forums` int(10) unsigned NOT NULL default '0', `user_ip` varchar(20) NOT NULL default '', `user_ban` tinyint(3) unsigned NOT NULL default '0', `user_prefs` text NOT NULL, `user_new` text NOT NULL, `user_viewed` text NOT NULL, `user_visits` int(10) unsigned NOT NULL default '0', `user_admin` tinyint(3) unsigned NOT NULL default '0', `user_login` varchar(100) NOT NULL default '', `user_class` text NOT NULL, `user_perms` text NOT NULL, `user_realm` text NOT NULL, `user_pwchange` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Dumping data for table `e107_user` -- INSERT INTO `e107_user` VALUES (1, 'admin', '', 'md5 password', '', 'email', '', '', '', '', '', '0000-00-00', '', '', '', 0, 1135545706, 1135613015, 1135620922, 0, 0, 0, 0, '', 0, '', '', '', 7, 1, '', '.1.2', '0', '', 1135545706); INSERT INTO `e107_user` VALUES (2, 'test', '', 'md5password', '', 'email', 'http://', '', '', '', '', '0000-00-00', '', '', '-12', 0, 1135621209, 0, 1135621209, 0, 0, 0, 0, '195.137.7.228', 0, '0', '', '', 0, 0, '', '.1', '', '', 0); </code> as for groups way it tells groups is user_class and can see from two users there each class id is assinged in anthier table in so on my website .1 is assigned as a wiki group so only want users to see/edit wiki if have .1 in that field bearing in mind that if second class added field it adds it on ie. .1.2.4.5 see test user who has had a second class added to it. so anyhelp on this would be great... cheers Russell