Skip Navigation


Apache 2.2 mod_cache

Server Tuning

Petal i18n and I18NFool

HowTo Compile Apache 1.3 for MKDoc

Integrate Soupermail

Creating new document components

Translate MKDoc Templates

Checkout MKDoc via anon CVS

Configuring MKDoc::Apache_Cache

MySQL commands to make a user account an editor account

Using news headlines

Customisation with CSS

Hiding documents and creating private areas

Upgrade from 1.4 to 1.6

Discussion Board Moderation

Text Component Formatting

Site Administration

Email newsletters

Edit Templates in a Subversion Repository

Update the Metadata for all Documents

Import MS Word files into MKDoc

Sign up

If you sign up for an account on this web site you can customise elements of this site and subscribe to an email newsletter.

If you have an account on this web site you may login.

If you have an account on this site but have forgotten your user name and / or your password then you can request an account reminder email.

MySQL commands to make a user account an editor account

The easiest way to make a user an editor is to login to the site using the admin account and then use the web interface to select one or more base documents for the user.

Users with base documents are editors, editors are able to edit their base documents and any decendent documents.

If you do need to make a user an editor at a MySQL level then the following steps should work.

1. Find out the ID of the account you want to add a base document for:

  mysql> select * from Editor;

2. Get a list of the existing base documents for editors:

  mysql> select * from Base_Document;

3. Get a list of all the document IDs and the path of the document:

  mysql> select ID, Full_Path from Document;

4. Now you have enough information to add a record to the Base_Document table. If the front page of the site has ID 1 (Full_Path being /) and you want to give the user with ID 6 editor rights over the whole site then this will do it:

  mysql> insert Base_Document values (NULL, 6, 1);

<< | Up | >>

This document was last modified by Chris Croome on 2004-08-17 13:23:41
MKDoc Ltd., 31 Psalter Lane, Sheffield, S11 8YL, UK.
Copyright © 2001-2005 MKDoc Ltd.