[dokuwiki] sql help

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

Other related posts: