[dokuwiki] sql help
- From: russell dyas <russell.dyas@xxxxxxxxx>
- To: dokuwiki@xxxxxxxxxxxxx
- Date: Tue, 27 Dec 2005 07:57:24 +0000
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:
