Thread: [Phpwiki-talk] [WikiAdminUtils] create-user function updated

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

This version verify if user exists before to create / update

Greetings,
-- 
Thomas Harding

There is a typo in the precedent versions : prefs blob is not correctly
formatted.

find the patch in attachment.

-- 
Thomas Harding

For those who have already applied the precedent patch, find files in
attachment.

for others, there is the cvs diff (diff_02_09).

Greetings,
-- 
Thomas Harding

Sorry, I don't like to have pref code in WikiDB.

WikiDB is for pages and revisions only, user prefs and account
data can be stored in various ways.

One way is to store it into WikiDB (meta-data attached to the UserPage)
Other ways are:
  storing it into seperate SQL tables,
  external databases
  and so on.

The correct way to implement the create_user backend, would be
a method in WikiUserNew.php and it's backends and NOT in WikiDB and
its backends.
From 1.3.12 on the user table will be deprecated, pref and member for
wiki is enough. (schemas already in CVS)
user is confusing, the user table should be used as example how to
access external databases to synch phpwiki user account info to other
packages.

On 10/2/05, Thomas Harding <tho...@la...> wrote:
> For those who have already applied the precedent patch, find files in
> attachment.
> for others, there is the cvs diff (diff_02_09).
--
Reini Urban

On Mon, Oct 03, 2005 at 04:12:26PM +0100, Reini Urban wrote:
> Sorry, I don't like to have pref code in WikiDB.

> One way is to store it into WikiDB (meta-data attached to the UserPage)

OK.

Where is exactly stored meta-data 'prefs' ?
Users are logged as bogouser  when I try
the following code : 

/*************/
require_once ('lib/loadsave.php');
$prefs = array ('userid' => $username,'passwd' => $passwd);
$prefs = serialize ($prefs);
$template = Template('homepage_byadmin', $request);
$text = $template->getExpansion();
$pageinfo = array('prefs' => $prefs,
                'versiondata' => array('author' => $username), 
                'pagedata' => '', 
                'pagename' => $username, 
                'content' => $text); 
SavePage ($request, $pageinfo, false, false); 
$message = _('User created'); 
/**************/

-- 
Thomas Harding

On Fri, Oct 07, 2005 at 11:28:20PM +0200, Thomas Harding wrote:
> On Mon, Oct 03, 2005 at 04:12:26PM +0100, Reini Urban wrote:
> > Sorry, I don't like to have pref code in WikiDB.
> 
> > One way is to store it into WikiDB (meta-data attached to the UserPage)
> 
[...]

OK,
This patch touch only WikiUserNew, IniConfig, config-default.ini,
WikiUser/PearDb.php and plugin/WikiAdminUtils.php.

It works only with ENABLE_USER_NEW.

It works at least with pref stored in Db (I didn't find the way to store
prefs in homepage metadata. Maybe I have to turn off some options in
config-default.ini).

Q: Why in  config-default.ini there is a REPLACE statement, which is
Mysql specific?

Regards,
-- 
Thomas Harding

On Sat, Oct 08, 2005 at 11:59:08PM +0200, Thomas Harding wrote:
> On Fri, Oct 07, 2005 at 11:28:20PM +0200, Thomas Harding wrote:
> > On Mon, Oct 03, 2005 at 04:12:26PM +0100, Reini Urban wrote:
> > > Sorry, I don't like to have pref code in WikiDB.
> > 
> > > One way is to store it into WikiDB (meta-data attached to the UserPage)
> > 
> [...]
> 
> OK,
> This patch touch only WikiUserNew, IniConfig, config-default.ini,
> WikiUser/PearDb.php and plugin/WikiAdminUtils.php.

There is now a basic check on existing users (hasHomePage), and you can
either create user or update his passwd.

I think other auth methods than homepage and prefs are out of the scope
of this tool (external db, pop and others), so it is probably the last
version.

Note: the template file is on previous message.

Regards,
-- 
Thomas Harding

On Sun, Oct 09, 2005 at 08:16:23AM +0200, Thomas Harding wrote:
> There is now a basic check on existing users (hasHomePage), and you can
> either create user or update his passwd.
> 
> I think other auth methods than homepage and prefs are out of the scope
> of this tool (external db, pop and others), so it is probably the last
> version.
> 
> Note: the template file is on previous message.

and the diff in this one :/

-- 
Thomas Harding

On Sun, Oct 09, 2005 at 08:18:24AM +0200, Thomas Harding wrote:
> On Sun, Oct 09, 2005 at 08:16:23AM +0200, Thomas Harding wrote:
> > There is now a basic check on existing users (hasHomePage), and you can
> > either create user or update his passwd.
> > 
> > I think other auth methods than homepage and prefs are out of the scope
> > of this tool (external db, pop and others), so it is probably the last
> > version.
> > 
> > Note: the template file is on previous message.
> 
> and the diff in this one :/

Well, It worked... sometimes. Don't know how it passed through.

Last version for the week-end follows.

Regards,
-- 
Thomas Harding

On 10/8/05, Thomas Harding <tho...@la...> wrote:
> Q: Why in  config-default.ini there is a REPLACE statement, which is
> Mysql specific?

Currently we have this in config-dist.ini:
; Update the user's preferences
; DBAUTH_PREF_UPDATE =3D "UPDATE pref SET prefs=3D'$pref_blob' WHERE
userid=3D'$userid'"
; MYSQL: Note that REPLACE works only with mysql and destroys all other col=
umns!
; DBAUTH_PREF_UPDATE =3D "REPLACE INTO pref SET
prefs=3D'$pref_blob',userid=3D'$userid'"

The REPLACE line is just another example for customization.
--
Reini Urban
http://phpwiki.org/

This has been addressed in the patches I made to get phpwiki working with
Oracle, although not down to the config.ini.dist. See the JohnStevens page.
Also part of my gripe ;-)
Regards

On 10/10/05, Reini Urban <rei...@gm...> wrote:
>
> On 10/8/05, Thomas Harding <tho...@la...> wrote:
> > Q: Why in config-default.ini there is a REPLACE statement, which is
> > Mysql specific?
>
> Currently we have this in config-dist.ini:
> ; Update the user's preferences
> ; DBAUTH_PREF_UPDATE =3D "UPDATE pref SET prefs=3D'$pref_blob' WHERE
> userid=3D'$userid'"
> ; MYSQL: Note that REPLACE works only with mysql and destroys all other
> columns!
> ; DBAUTH_PREF_UPDATE =3D "REPLACE INTO pref SET
> prefs=3D'$pref_blob',userid=3D'$userid'"
>
> The REPLACE line is just another example for customization.
> --
> Reini Urban
> http://phpwiki.org/
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>