PHPortal

I keep getting this error when I go to my index

Fatal error: Call to undefined function: is_a() in /usr/www/htdocs/stormgods/index.php on line 30

I can not seem to get the thing to install. I was really looking forward to working with it. It appears to have alot of potential (like not making me learn python).

OK now the main questions? How do I define my site correctly because I cant seem to do it in auto
and I am uncertain looking at the config file for the manual version.

I had to work with the sql file provided with the 2.7, it had 3 or 4 errors. Then I sent the wrong one to the xpc admin so here is the correct one with the fixes made to it already.

The SQL file:

# PHPortal-Xpc MySQL-Dump
# version 0.2.7
# http://dev.4arrow.com
# http://sourceforge.net/projects/xpc (download page)
#
# Host: localhost
# Generation Time: Jan 05, 2003 at 12:53 PM
# Server version: 3.23.53
# PHP Version: 4.2.3
# Database : `xpc_sample`
# --------------------------------------------------------

# user:pass
# admin:test
# based on the default sample_site.php cfg 'pass_phrase'
# both should be changed once installed.
# The last table 'xpc_apps' and its data belong only in the 'shared_db' from site cfg

#
# Table structure for table `xpc_access`
#

CREATE TABLE xpc_access (
id bigint(24) NOT NULL auto_increment,
oid bigint(24) NOT NULL default '1',
rid bigint(24) NOT NULL default '1',
peid bigint(24) NOT NULL default '1',
acquire enum('y','n') NOT NULL default 'y',
PRIMARY KEY (id),
KEY oid(oid,rid,peid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_access`
#

INSERT INTO xpc_access VALUES (1, 2, 1, 1, 'y');
INSERT INTO xpc_access VALUES (2, 1, 1, 1, 'y');
INSERT INTO xpc_access VALUES (3, 3, 1, 1, 'y');
INSERT INTO xpc_access VALUES (4, 4, 1, 1, 'y');
INSERT INTO xpc_access VALUES (5, 5, 1, 1, 'y');
INSERT INTO xpc_access VALUES (6, 6, 1, 1, 'y');
INSERT INTO xpc_access VALUES (7, 1, 4, 2, 'y');
INSERT INTO xpc_access VALUES (8, 1, 3, 2, 'y');
INSERT INTO xpc_access VALUES (9, 1, 3, 3, 'y');
INSERT INTO xpc_access VALUES (10, 1, 3, 4, 'y');
INSERT INTO xpc_access VALUES (11, 1, 3, 5, 'y');
INSERT INTO xpc_access VALUES (12, 1, 4, 5, 'y');
INSERT INTO xpc_access VALUES (13, 1, 4, 4, 'y');
INSERT INTO xpc_access VALUES (14, 1, 4, 3, 'y');
INSERT INTO xpc_access VALUES (15, 1, 4, 6, 'y');
INSERT INTO xpc_access VALUES (16, 1, 4, 7, 'y');
INSERT INTO xpc_access VALUES (17, 1, 4, 8, 'y');
INSERT INTO xpc_access VALUES (18, 1, 4, 9, 'y');
INSERT INTO xpc_access VALUES (19, 1, 4, 10, 'y');
INSERT INTO xpc_access VALUES (20, 1, 4, 11, 'y');
INSERT INTO xpc_access VALUES (21, 1, 4, 12, 'y');
INSERT INTO xpc_access VALUES (22, 1, 4, 13, 'y');
INSERT INTO xpc_access VALUES (23, 1, 4, 14, 'y');
INSERT INTO xpc_access VALUES (24, 1, 4, 15, 'y');
INSERT INTO xpc_access VALUES (25, 1, 4, 16, 'y');
INSERT INTO xpc_access VALUES (26, 1, 4, 17, 'y');
INSERT INTO xpc_access VALUES (27, 1, 4, 18, 'y');
INSERT INTO xpc_access VALUES (28, 1, 4, 19, 'y');
INSERT INTO xpc_access VALUES (29, 1, 4, 20, 'y');
INSERT INTO xpc_access VALUES (30, 1, 4, 21, 'y');
INSERT INTO xpc_access VALUES (31, 1, 4, 22, 'y');
INSERT INTO xpc_access VALUES (32, 1, 4, 23, 'y');
INSERT INTO xpc_access VALUES (33, 1, 4, 24, 'y');
INSERT INTO xpc_access VALUES (34, 1, 4, 25, 'y');
INSERT INTO xpc_access VALUES (35, 1, 4, 26, 'y');
INSERT INTO xpc_access VALUES (36, 1, 4, 27, 'y');
INSERT INTO xpc_access VALUES (37, 1, 4, 28, 'y');
INSERT INTO xpc_access VALUES (38, 1, 4, 29, 'y');
INSERT INTO xpc_access VALUES (39, 1, 4, 30, 'y');
INSERT INTO xpc_access VALUES (40, 1, 4, 31, 'y');
INSERT INTO xpc_access VALUES (41, 1, 4, 32, 'y');
INSERT INTO xpc_access VALUES (42, 1, 4, 33, 'y');
INSERT INTO xpc_access VALUES (43, 1, 4, 34, 'y');
INSERT INTO xpc_access VALUES (44, 1, 4, 35, 'y');
INSERT INTO xpc_access VALUES (45, 1, 4, 36, 'y');
INSERT INTO xpc_access VALUES (46, 1, 3, 37, 'y');
INSERT INTO xpc_access VALUES (47, 1, 3, 38, 'y');
INSERT INTO xpc_access VALUES (48, 1, 3, 39, 'y');
INSERT INTO xpc_access VALUES (49, 1, 3, 40, 'y');
INSERT INTO xpc_access VALUES (50, 1, 3, 41, 'y');
INSERT INTO xpc_access VALUES (51, 1, 3, 42, 'y');
INSERT INTO xpc_access VALUES (52, 1, 3, 43, 'y');
INSERT INTO xpc_access VALUES (53, 1, 3, 44, 'y');
INSERT INTO xpc_access VALUES (54, 11, 4, 45, 'y');
INSERT INTO xpc_access VALUES (55, 11, 4, 46, 'y');
INSERT INTO xpc_access VALUES (56, 11, 4, 47, 'y');
INSERT INTO xpc_access VALUES (57, 11, 4, 48, 'y');
INSERT INTO xpc_access VALUES (58, 11, 4, 49, 'y');
INSERT INTO xpc_access VALUES (59, 11, 4, 50, 'y');
# --------------------------------------------------------

#
# Table structure for table `xpc_apps`
#

CREATE TABLE xpc_apps (
id tinyint(4) NOT NULL auto_increment,
name varchar(150) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY name(name)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_apps`
#

INSERT INTO xpc_apps VALUES (1, 'binary');
INSERT INTO xpc_apps VALUES (2, 'document');
INSERT INTO xpc_apps VALUES (3, 'file');
INSERT INTO xpc_apps VALUES (4, 'folder');
INSERT INTO xpc_apps VALUES (5, 'members');
INSERT INTO xpc_apps VALUES (6, 'method');
INSERT INTO xpc_apps VALUES (7, 'search');
INSERT INTO xpc_apps VALUES (8, 'userfolder');
INSERT INTO xpc_apps VALUES (9, 'version');
INSERT INTO xpc_apps VALUES (10, 'product');
INSERT INTO xpc_apps VALUES (11, 'script');
INSERT INTO xpc_apps VALUES (12, 'vhost');
INSERT INTO xpc_apps VALUES (13, 'template');
# --------------------------------------------------------

#
# Table structure for table `xpc_help`
#

CREATE TABLE xpc_help (
id tinyint(11) NOT NULL auto_increment,
aid tinyint(11) NOT NULL default '0',
name varchar(150) NOT NULL default '',
content text NOT NULL,
PRIMARY KEY (id),
KEY oid(aid),
FULLTEXT KEY content(content)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_help`
#

INSERT INTO xpc_help VALUES (1, 1, 'Image - Edit', '<html>\r\n<head>\r\n<title>Image - Edit</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="/help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Image - Edit: Image Properties.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to edit Image properties.</P>\r\n<H5>File information</H5>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the Image.</P>\r\n<DT><CODE>Size</CODE>\r\n<DD>\r\n<P>The size of the Image.</P>\r\n<DT><CODE>Last modified</CODE>\r\n<DD>\r\n<P>The last time the Image was changed.</P></DD></DL>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the Image.</P>\r\n<DT><CODE>Content type</CODE>\r\n<DD>\r\n<P>The content type of the Image. PHPortal will try to guess an appropriate content \r\ntype when you upload an Image.</P>\r\n<DT><CODE>File Data</CODE>\r\n<DD>\r\n<P>The file to upload. Use the <CODE>Browse...</CODE> button to select a local \r\nfile.</P>\r\n<DT><CODE>Upload</CODE>\r\n<DD>\r\n<P>Uploads the file.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (2, 2, 'Document Edit', '<html>\r\n<head>\r\n<title>Document Edit</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="/help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>PHPortal Document/Method - Edit: Edit contents.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to edit the contents of a PHPortal Document or Method.</P>\r\n<H5>Information</H5>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the PHPortal Document or Method.</P>\r\n<DT><CODE>Size</CODE>\r\n<DD>\r\n<P>The size of the contents.</P>\r\n<DT><CODE>Last modified</CODE>\r\n<DD>\r\n<P>The time the object was last changed.</P></DD></DL>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title.</P>\r\n<DT><CODE>[Text area]</CODE>\r\n<DD>\r\n<P>The contents of the PHPortal Document or Method.</P>\r\n<DT><CODE>Taller</CODE> and <CODE>Shorter</CODE>\r\n<DD>\r\n<P>Allows to adjust the height of the contents text area.</P>\r\n<DT><CODE>Wider</CODE> and <CODE>Narrower</CODE>\r\n<DD>\r\n<P>Allows to adjust the width of the contents text area.</P>\r\n<DT><CODE>Save Changes</CODE>\r\n<DD>\r\n<P>Changes the contents.</P>\r\n<P><STRONG>Note: When you change the contents it is parsed for correct PHPortal \r\nsyntax. If there is a syntax error, the contents will not be \r\nchanged.</STRONG></P>\r\n<DT><CODE>File</CODE>\r\n<DD>\r\n<P>Indicates a file to be uploaded to replace the contents of the current \r\nobject. Use the <CODE>Browse ...</CODE> button to select a local file.</P>\r\n<DT><CODE>Upload File</CODE>\r\n<DD>\r\n<P>Upload the file and change the contents. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (3, 3, 'File - Edit', '<html>\r\n<head>\r\n<title>File - Edit</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="/help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>File - Edit: File Properties.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to edit File properties.</P>\r\n<H5>File information</H5>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the File.</P>\r\n<DT><CODE>Size</CODE>\r\n<DD>\r\n<P>The size of the File.</P>\r\n<DT><CODE>Last modified</CODE>\r\n<DD>\r\n<P>The last time the File was changed.</P></DD></DL>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the File.</P>\r\n<DT><CODE>Content type</CODE>\r\n<DD>\r\n<P>The content type of the file. PHPortal will try to guess an appropriate content \r\ntype when you upload a File.</P>\r\n<DT><CODE>Precondition</CODE>\r\n<DD>\r\n<P>Allows you to specify a precondition for the File. A precondition is a method \r\nor document which is executed before the File is viewed or downloaded. If the \r\nprecondition raises an exception then the File cannot be viewed.</P>\r\n<DT><CODE>File Data</CODE>\r\n<DD>\r\n<P>The file to upload. Use the <CODE>Browse...</CODE> button to select a local \r\nfile.</P>\r\n<DT><CODE>Upload</CODE>\r\n<DD>\r\n<P>Uploads the file. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (4, 4, 'Folder', '<html>\r\n<head>\r\n<title>Folder</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="/help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Folder - Add: Add a Folder.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to create a new Folder.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the Folder.</P>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the Folder.</P>\r\n<DT><CODE>Create public interface</CODE>\r\n<DD>\r\n<P>Creates an <CODE>index_html</CODE> PHPortal Method inside the new Folder.</P>\r\n<DT><CODE>Create user folder</CODE>\r\n<DD>\r\n<P>Creates a User Folder inside the new Folder to hold authorization information \r\nfor the Folder.</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Creates a new Folder.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (5, 6, 'Method Edit', '<html>\r\n<head>\r\n<title>Method Edit</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>PHPortal Document/Method - Edit: Edit contents.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to edit the contents of a PHPortal-XPC Document or Method.</P>\r\n<H5>Information</H5>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the PHPortal-XPC Document or Method.</P>\r\n<DT><CODE>Size</CODE>\r\n<DD>\r\n<P>The size of the contents.</P>\r\n<DT><CODE>Last modified</CODE>\r\n<DD>\r\n<P>The time the object was last changed.</P></DD></DL>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title.</P>\r\n<DT><CODE>[Text area]</CODE>\r\n<DD>\r\n<P>The contents of the PHPortal-XPC Document or Method.</P>\r\n<DT><CODE>Taller</CODE> and <CODE>Shorter</CODE>\r\n<DD>\r\n<P>Allows to adjust the height of the contents text area.</P>\r\n<DT><CODE>Wider</CODE> and <CODE>Narrower</CODE>\r\n<DD>\r\n<P>Allows to adjust the width of the contents text area.</P>\r\n<DT><CODE>Save Changes</CODE>\r\n<DD>\r\n<P>Changes the contents.</P>\r\n<P><STRONG>Note: When you change the contents it is parsed for correct PHPortal-XPC \r\nsyntax. If there is a syntax error, the contents will not be \r\nchanged.</STRONG></P>\r\n<DT><CODE>File</CODE>\r\n<DD>\r\n<P>Indicates a file to be uploaded to replace the contents of the current \r\nobject. Use the <CODE>Browse ...</CODE> button to select a local file.</P>\r\n<DT><CODE>Upload File</CODE>\r\n<DD>\r\n<P>Upload the file and change the contents. </P></DD></DL>\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (6, 9, 'Version - Join', '<html>\r\n<head>\r\n<title>Version - Join</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="/help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Version - Join/Leave: Start/Stop working in a Version.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to start and stop working in a private Version.</P>\r\n<P>When you are working in a version all changes you make will be hidden from \r\nother users. You may join and leave a Version as many times as necessary until \r\nyou are ready to commit the Version or discard it.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Start Working in</CODE>\r\n<DD>\r\n<P>Join the Version.</P>\r\n<DT><CODE>Quit Working in</CODE>\r\n<DD>\r\n<P>Leave the Version.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (7, 11, 'Script (PHP)', '<html>\r\n<head>\r\n\r\n<title>Script (PHP)</title></head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n\r\n<h1>API Documentation</h1>\r\n\r\n<h3>Classes</h3>\r\n<dl><dd>\r\n<h2 class="api">\r\n<a href="#PHPScript">PHPScript</a>\r\n</h2>\r\n</dd></dl>\r\n\r\n<h3>Functions</h3>\r\n<dl><dd>\r\n<h2 class="api">\r\n<a href="#manage_addPHPScript">manage_addPHPScript</a>\r\n</h2>\r\n</dd></dl>\r\n\r\n\r\n <h2>Classes</h2>\r\n <a name="PHPScript"></a>\r\n<h2 class="api">class\r\n PHPScript(Script)\r\n</h2>\r\n\r\n<dl>\r\n<dd>\r\n<p>PHP Scripts contain PHP code that gets executed when you call the\r\nscript by:\r\n<ul>\r\n<li>Calling the script through the web by going to its location with a\r\n web browser.</li>\r\n<li>Calling the script from another script object.</li>\r\n<li>Calling the script from a method object, such as a XPC Method.</li>\r\n\r\n</ul>\r\n<p></p>\r\n<p>PHP Scripts can contain a "safe" subset of the PHP language.\r\nPHP Scripts must be safe because they can be potentially edited by\r\nmany different users through an insecure medium like the web. The\r\nfollowing safety issues drive the need for secure PHP Scripts:\r\n<ul>\r\n<li>Because many users can use PHPortal, a PHP Script must make sure it\r\n does not allow a user to do something they are not allowed to do,\r\n like deleting an object they do not have permission to delete.\r\n Because of this requirement, PHP Scripts do many security checks\r\n in the course of their execution.</li>\r\n<li>Because PHP Scripts can be edited through the insecure medium of\r\n the web, they are not allowed access to the PHPortal server\'s\r\n file-system. Normal PHP builtins like <code>open</code> are, therefore,\r\n not allowed.</li>\r\n<li>Because many standard PHP modules break the above two security\r\n restrictions, only a small subset of PHP modules may be imported\r\n into a PHP Scripts with the "import" statement unless they have\r\n been validated by PHPortal\'s security policy. Currently, the following\r\n standard PHP modules have been validated:\r\n<ul>\r\n<li>string</li>\r\n<li>math</li>\r\n<li>whrandom and random</li>\r\n<li>Products.PHPScripts.standard</li>\r\n\r\n</ul>\r\n</li>\r\n<li>Because it allows you to execute arbitrary PHP code, the PHP\r\n "exec" statement is not allowed in PHP methods.</li>\r\n<li>Because they may represent or cause security violations, some\r\n PHP builtin functions are not allowed. The following\r\n PHP builtins are not allowed:\r\n<ul>\r\n<li>open</li>\r\n<li>input</li>\r\n<li>raw_input</li>\r\n<li>eval</li>\r\n <li>exec</li>\r\n<li>compile</li>\r\n<li>type</li>\r\n<li>coerce</li>\r\n<li>intern</li>\r\n<li>dir</li>\r\n<li>globals</li>\r\n<li>locals</li>\r\n<li>vars</li>\r\n<li>buffer</li>\r\n<li>reduce</li>\r\n\r\n</ul>\r\n</li>\r\n<li>Other builtins are restricted in nature. The following builtins\r\n are restricted:<dl>\r\n<dt> range</dt>\r\n<dd>Due to possible memory denial of service attacks, the\r\n range builtin is restricted to creating ranges less than 10,000\r\n elements long.</dd>\r\n<dt> filter, map, tuple, list</dt>\r\n<dd>For the same reason, builtins\r\n that construct lists from sequences do not operate on strings.</dd>\r\n<dt> getattr, setattr, delattr</dt>\r\n<dd>Because these may enable PHP\r\n code to circumvent PHPortal\'s security system, they are replaced with\r\n custom, security constrained versions.</dd>\r\n</dl>\r\n</li>\r\n<li>In order to be consistent with the PHP expressions\r\n available to XPC, the builtin functions are augmented with a\r\n small number of functions and a class:\r\n<ul>\r\n<li>test</li>\r\n<li>namespace</li>\r\n<li>render</li>\r\n<li>same_type</li>\r\n<li>DateTime</li>\r\n\r\n</ul>\r\n</li>\r\n <li>Because the "print" or "echo" statement cannot operate normally \r\n in PHPortal, using it will output before the scripts execution end.</li>\r\n\r\n</ul>\r\n<p></p>\r\n\r\n</dd>\r\n</dl>\r\n\r\n<hr>\r\n<h3>Product Constructor</h3>\r\n <a name="manage_addPHPScript"></a>\r\n<h2 class="method">manage_addPHPScript(id, REQUEST=None):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Add a PHP script to a folder.</p>\r\n\r\n</dd></dl>\r\n\r\n \r\n<hr>\r\n\r\n\r\n<h3>Methods</h3>\r\n <a name="document_src"></a>\r\n<h2 class="method">document_src(REQUEST=None, RESPONSE=None):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Return the text of the <code>read</code> method, with content type\r\n<code>text/plain</code> set on the RESPONSE.</p>\r\n\r\n</dd></dl>\r\n\r\n <a name="ZPHPScript_edit"></a>\r\n<h2 class="method">ZPHPScript_edit(params,\r\nbody):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Change the parameters and body of the script. This method accepts\r\ntwo arguments:<dl>\r\n<dt> params</dt>\r\n<dd>The new value of the PHP Script\'s parameters. Must\r\n be a comma seperated list of values in valid PHP function\r\n signature syntax. If it does not contain a valid signature\r\n string, a SyntaxError is raised.</dd>\r\n<dt> body</dt>\r\n<dd>The new value of the PHP Script\'s body. Must contain\r\n valid PHP syntax. If it does not contain valid PHP syntax,\r\n a SyntaxError is raised.</dd>\r\n</dl>\r\n<p></p>\r\n\r\n</dd></dl>\r\n\r\n <a name="ZPHPScript_setTitle"></a>\r\n<h2 class="method">ZPHPScript_setTitle(title):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Change the script\'s title. This method accepts one argument,\r\n<code>title</code> which is the new value for the script\'s title and must be a\r\nstring.</p>\r\n\r\n</dd></dl>\r\n\r\n <a name="ZPHPScriptHTML_upload"></a>\r\n<h2 class="method">ZPHPScriptHTML_upload(REQUEST, file=):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Pass the text in file to the <code>write</code> method.</p>\r\n\r\n</dd></dl>\r\n\r\n <a name="write"></a>\r\n<h2 class="method">write(text):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Change the script by parsing the text argument into parts.\r\nLeading lines that begin with <code>##</code> are stripped off, and if\r\nthey are of the form <code>##name=value</code>, they are used to set\r\nmeta-data such as the title and parameters. The remainder of\r\nthe text is set as the body of the PHP Script.</p>\r\n\r\n</dd></dl>\r\n\r\n <a name="ZScriptHTML_tryParams"></a>\r\n<h2 class="method">ZScriptHTML_tryParams():\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Return a list of the required parameters with which to\r\ntest the script.</p>\r\n\r\n</dd></dl>\r\n\r\n <a name="read"></a>\r\n<h2 class="method">read():\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Return the body of the PHP Script, with a special comment\r\nblock prepended. This block contains meta-data in the form of\r\ncomment lines as expected by the <code>write</code> method.</p>\r\n\r\n</dd></dl>\r\n\r\n <a name="ZPHPScriptHTML_editAction"></a>\r\n<h2 class="method">ZPHPScriptHTML_editAction(REQUEST,\r\ntitle,\r\nparams,\r\nbody):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Change the script\'s main parameters. This method accepts the\r\nfollowing arguments:<dl>\r\n<dt> REQUEST</dt>\r\n<dd>The current request.</dd>\r\n<dt> title</dt>\r\n<dd>The new value of the PHP Script\'s title. This must\r\n be a string.</dd>\r\n<dt> params</dt>\r\n<dd>The new value of the PHP Script\'s parameters. Must\r\n be a comma seperated list of values in valid PHP function\r\n signature syntax. If it does not contain a valid signature\r\n string, a SyntaxError is raised.</dd>\r\n<dt> body</dt>\r\n<dd>The new value of the PHP Script\'s body. Must contain\r\n valid PHP syntax. If it does not contain valid PHP syntax,\r\n a SyntaxError is raised.</dd>\r\n</dl>\r\n<p></p>\r\n\r\n</dd></dl>\r\n\r\n\r\n\r\n\r\n <hr noshade>\r\n \r\n <h2>Functions</h2>\r\n <a name="manage_addPHPScript"></a>\r\n<h2 class="method">manage_addPHPScript(id, REQUEST=None):\r\n</h2>\r\n\r\n<dl><dd>\r\n<p>Add a PHP script to a folder.</p>\r\n\r\n</dd></dl>\r\n\r\n \r\n</body></html>');
INSERT INTO xpc_help VALUES (8, 13, 'Template Edit', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Edit View: Edit A Page Template</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to edit the template\'s text, upload new\r\n text, or change the content type and title of the template.</p>\r\n<h4> Template Text</h4>\r\n<p> The text in a template must be well-formed HTML if the content\r\n type is <code>text/html</code>. Otherwise, it must be well-formed XML.\r\n Either way, it may include Dynamic blocks or curly braces\r\n markup containing XPC method expressions.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>Title</code></dt>\r\n<dd>Allows you to specify the PHPortal title of the template.</dd>\r\n<dt> <code>Content-Type</code></dt>\r\n<dd>Allows you to specify the content-type that\r\n will be given to renderings of this template. Also, if the\r\n content type is <code>text/html</code> (the default) then the template is\r\n assumed to contain HTML, not XML. This affects both parsing\r\n and rendering of the template, and can be overridden by giving\r\n the template an <code>is_html</code> property. In HTML mode you don\'t\r\n need to explicitly declare <code>tal</code> and <code>DYNAMIC</code> XML namespaces. In\r\n XML mode you must explicitly declare <code>tal</code> and <code>DYNAMIC</code> XML\r\n namespaces, and PHPortal assumes that your template contains\r\n well-formed XML.</dd>\r\n<dt> <code>Expand macros when editing</code></dt>\r\n <dd>Allows you to turn the expansion of DYNAMIC macros on or off. This only \r\n affects viewing of the source code, not rendering.</dd>\r\n</dl>\r\n<h4> Buttons and Other Form Elements</h4>\r\n<dl>\r\n<dt> <code>Save Changes</code></dt>\r\n<dd>saves changes you make to the body, title, or\r\n content type.</dd>\r\n<dt> <code>Taller</code>/<code>Shorter</code>/<code>Wider</code>/<code>Narrower</code></dt>\r\n<dd>make the body textarea\r\n taller, shorter, wider, or narrower.</dd>\r\n<dt> <code>File</code></dt>\r\n<dd>upload a file into this template.</dd>\r\n</dl>\r\n<h4> File Upload Details</h4>\r\n<p> Files uploaded into a template must be valid HTML or XML text.</p>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (9, 8, 'User Folder', '<html>\r\n<head>\r\n<title>User Folder</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="/help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>User Folder - Contents: Manage users.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to manage the users defined in a User Folder.</P>\r\n<H4>Controls</H4>\r\n<P>Users are listed one per line. Click on a user to edit the user.</P>\r\n<DL>\r\n<DT><CODE>[Checkbox]</CODE>\r\n<DD>\r\n<P>Selects users.</P>\r\n<DT><CODE>Add...</CODE>\r\n<DD>\r\n<P>Adds a new user.</P>\r\n<DT><CODE>Delete</CODE>\r\n<DD>\r\n<P>Deletes the selected users.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (10, 4, 'Control-Panel_Contents', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Control Panel - Contents: PHPortal system controls</h3>\r\n<h4> Description</h4>\r\n<p> This view displays information about the PHPortal process and\r\n allows you to restart and/or shutdown PHPortal.</p>\r\n<h5> System Information</h5>\r\n<dl>\r\n<dt> <code>PHPortal version</code></dt>\r\n<dd>The version of PHPortal, the type of the release\r\n (binary/source), the PHP version, and the platform the\r\n binaries were compiled on.</dd>\r\n<dt> <code>PHP version</code></dt>\r\n<dd>The PHP version that PHPortal is using.</dd>\r\n<dt> <code>System Platform</code></dt>\r\n<dd>The type of machine PHPortal is running on.</dd>\r\n<dt> <code>SOFTWARE_HOME</code></dt>\r\n<dd>The filesystem path of the core PHPortal software.</dd>\r\n<dt> <code>INSTANCE_HOME</code></dt>\r\n<dd>The filesystem path where PHPortal loads add-on\r\n software.</dd>\r\n<dt> <code>CLIENT_HOME</code></dt>\r\n<dd>The filesystem path where PHPortal stores data and\r\n log files.</dd>\r\n<dt> <code>Process ID</code></dt>\r\n<dd>The PID of the PHPortal process.</dd>\r\n<dt> <code>Running for</code></dt>\r\n<dd>How long the PHPortal process has been running.</dd>\r\n</dl>\r\n<h5> Management Options</h5>\r\n<dl>\r\n<dt> <code>Database Management</code></dt>\r\n<dd>Provides access to the database\r\n management functions such as packing and cache management.</dd>\r\n<dt> <code>Version Management</code></dt>\r\n<dd>Provides access to version management\r\n functions, including version commit and abort.</dd>\r\n<dt> <code>Product Management</code></dt>\r\n<dd>Provides access to management functions\r\n for installed PHPortal Products.</dd>\r\n</dl>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>Shutdown</code></dt>\r\n<dd>Shutsdown the PHPortal process. <strong>Important: You will\r\n not be able to access PHPortal through the web after shutting it\r\n down.</strong></dd>\r\n<dt> <code>Restart</code></dt>\r\n<dd>Restarts PHPortal. This control will only appear if PHPortal\r\n is running under daemon control or as a win32 service. <strong>Note: It\r\n may take a few moments until the PHPortal comes back up after being\r\n restarted.</strong></dd>\r\n</dl>\r\n<p> If your browser supports JavaScript, you should be able to add the\r\n following link to your bookmarks/favorites and use it to restart\r\n any PHPortal site: <code>restart</code>,(Restart PHPortal).</p>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (11, 4, 'Folder - Local Roles', '<html>\r\n<head>\r\n<title>Folder - Local Roles</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Folder - Local Roles: Manage local roles.</H3>\r\n<H4>Description</H4>\r\n<P>Local roles allow you to give users additional roles in the context of an \r\nobject.</P>\r\n<H4>Controls</H4>\r\n<H5>Editing local roles</H5>\r\n<DL>\r\n<DT><CODE>[Checkbox]</CODE>\r\n<DD>\r\n<P>Select users. Click a user\'s name to edit their local roles.</P>\r\n<DT><CODE>Remove</CODE>\r\n<DD>\r\n<P>Deletes local roles for the selected users.</P></DD></DL>\r\n<H5>Creating local roles</H5>\r\n<DL>\r\n<DT><CODE>User</CODE>\r\n<DD>\r\n<P>The user for which you would like to define local roles.</P>\r\n<DT><CODE>Roles</CODE>\r\n<DD>\r\n<P>The local roles you would like to assign to the user.</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Adds the selected local roles for the selected user. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (12, 4, 'Folder - Manage Permission', '<html>\r\n<head>\r\n<title>Folder - Manage Permission</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Folder - Manage Permission: Assign roles to a permission.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to assign roles to a permission.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>[Role List]</CODE>\r\n<DD>\r\n<P>The roles assigned to the permission.</P>\r\n<DT><CODE>Also use roles acquired from folders containing this object</CODE>\r\n<DD>\r\n<P>Whether or not to acquire permissions settings for the permission.</P>\r\n<DT><CODE>Change</CODE>\r\n<DD>\r\n<P>Changes the security settings. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (13, 4, 'Folder - Manage Role', '<html>\r\n<head>\r\n<title>Folder - Manage Role</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Folder - Manage Role: Assign permissions to a role.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to assign permissions to a role.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>[Permissions List]</CODE>\r\n<DD>\r\n<P>The permissions assigned to the role.</P>\r\n<DT><CODE>Change</CODE>\r\n<DD>\r\n<P>Changes the security settings.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (14, 4, 'History', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>History: Object history.</h3>\r\n<h4> Description</h4>\r\n<p> XPC Documents and Methods keep a history of their contents. This\r\n view allows you to browse, compare, and revert to old versions.</p>\r\n<h4> Controls</h4>\r\n<p> Historical revisions are described by a date, a user and a\r\n URL. This describes at what time by whom and at what URL the\r\n object was changed.</p>\r\n<p> Click on a historical version to view the object as it existed at\r\n a given point in history.</p>\r\n<dl>\r\n<dt> \'[Checkbox]\'</dt>\r\n<dd>Select a historical revision.</dd>\r\n<dt> <code>Copy to present</code></dt>\r\n<dd>Changes the object to the same state as the\r\n selected historical revision.</dd>\r\n<dt> <code>Compare</code></dt>\r\n<dd>Summarizes the difference between two historical\r\n revisions. If you select one historical revision it will be\r\n compared to the current state.<p> The comparison shows the changes needed to change the older\r\n revision to match the newer revision.</p>\r\n</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (15, 4, 'properties', '<html>\r\n<head>\r\n<title>Properties - Define properties</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Properties - Define properties.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to edit and define properties on the current object.</P>\r\n<H5>Property types</H5>\r\n<DL>\r\n<DT><CODE>boolean</CODE>\r\n<DD>\r\n<P>1 or 0. </P>\r\n<DT><CODE>date</CODE>\r\n<DD>\r\n<P>A <CODE>DateTime</CODE> value, for example <CODE>12/31/1999 15:42:52 \r\nPST</CODE>.</P>\r\n<DT><CODE>float</CODE>\r\n<DD>\r\n<P>A decimal number, for example <CODE>12.4</CODE>. </P>\r\n<DT><CODE>int</CODE>\r\n<DD>\r\n<P>An integer number, for example, <CODE>12</CODE>. </P>\r\n<DT><CODE>lines</CODE>\r\n<DD>\r\n<P>A list of strings, one per line. </P>\r\n<DT><CODE>long</CODE>\r\n<DD>\r\n<P>A long integer, for example <CODE>12232322322323232323423</CODE>. </P>\r\n<DT><CODE>string</CODE>\r\n<DD>\r\n<P>A string of characters, for example <CODE>This is a string</CODE>. </P>\r\n<DT><CODE>text</CODE>\r\n<DD>\r\n<P>A multi-line string, for example a paragraph. </P>\r\n<DT><CODE>tokens</CODE>\r\n<DD>\r\n<P>A list of strings separated by white space, for example <CODE>one two \r\nthree</CODE>. </P>\r\n<DT><CODE>selection</CODE>\r\n<DD>\r\n<P>A string selected by a pop-up menu. </P>\r\n<DT><CODE>multiple selection</CODE>\r\n<DD>\r\n<P>A list of strings selected by a selection list.</P></DD></DL>\r\n<H4>Controls</H4>\r\n<H5>Editing Properties</H5>\r\n<P>Existing properties can be edited by selecting them.</P>\r\n<DL>\r\n<DT><CODE>[Checkbox]</CODE>\r\n<DD>\r\n<P>Select the properties to change.</P>\r\n<DT><CODE>Property</CODE>\r\n<DD>\r\n<P>The value of the property. </P>\r\n<DT><CODE>Save Changes</CODE>\r\n<DD>\r\n<P>Changes the value of the selected properties.</P>\r\n<DT><CODE>Delete</CODE>\r\n<DD>\r\n<P>Deletes the selected properties.</P></DD></DL>\r\n<H5>Creating new properties</H5>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the property.</P>\r\n<DT><CODE>Type</CODE>\r\n<DD>\r\n<P>The type of the property.</P>\r\n<DT><CODE>Value</CODE>\r\n<DD>\r\n<P>The value of the property.</P>\r\n<P><STRONG>Note: When creating <CODE>selection</CODE> and <CODE>multiple \r\nselection</CODE> properties, specify the name of another property (or method) as \r\nthe <CODE>Value</CODE>. This property (or method) should return a list of \r\nstrings will be used to provide choices for the selection.</STRONG> </P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Creates a new property.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (16, 4, 'Ownership', '<html>\r\n<head>\r\n<title>Ownership</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Ownership: Manage ownership.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to set the ownership of an object.</P>\r\n<P>On the top of the page PHPortal will tell you whether the object has an owner and \r\nwho it is.</P>\r\n<P>All PHPortal objects except objects within the Control Panel support ownership. \r\nWhen an object is created, copied or imported in PHPortal, the logged-in user \r\nperforming the operation becomes the owner of the resulting object(s). Note that \r\nsimply moving or renaming an object does not change its ownership.</P>\r\n<P>Ownership is most important for PHPortal objects that "execute" content supplied \r\nthrough the web, such as PHPortal Methods, PHPortal Documents and SQL Methods. The \r\nabilities of these executable objects are constrained by the abilities of the \r\nobject\'s owner as well as the user causing the object to execute from a PHPortal \r\nsecurity point of view. In other words, an executable cannot perform operations \r\nthat its owner could not perform directly.</P>\r\n<P>While most PHPortal objects support ownership, objects may not always have an \r\nowner assigned. Objects that do not have an assigned owner are <EM>unowned</EM>. \r\nAn unowned executable object executes with the permissions of the user running \r\nthe object.</P>\r\n<P>It is possible to remove a user in your PHPortal installation while objects that \r\nwere owned by that user remain (for instance, someone in your organization moves \r\non, so you remove his account on your PHPortal server). When you remove a PHPortal user, \r\nobjects that were owned by that user still have ownership information that \r\nrefers to that user. This will not cause an error, but it is important to \r\nunderstand what happens to PHPortal objects whose owners no longer exist. This is \r\nmost important for "executable" objects. Usually, the abilities of executable \r\nobjects are constrained by the abilities of the object\'s owner as well as the \r\nuser causing the object to execute. If PHPortal cannot find the user that the \r\nexecutable\'s ownership information refers to when it tries to execute the \r\nobject, it will use the special <CODE>nobody</CODE> or anonymous user instead. \r\nThe <CODE>nobody</CODE> user has very minimal privileges, so you should take \r\nthis into account when deciding what to do about a user\'s owned objects when you \r\ndelete the user. If the user had PHPortal documents or other executable objects that \r\ndepended upon their owner to have a higher level of privilege than the \r\n<CODE>nobody</CODE> user, they will not work correctly until their ownership has \r\nbeen reassigned to another user with sufficient privileges.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Take ownership</CODE>\r\n<DD>\r\n<P>Gives you ownership of this object.</P>\r\n<P><STRONG>Note: For this operation you have the <CODE>Take ownership</CODE> \r\nrole.</STRONG></P>\r\n<DT><CODE>Also take ownership of all sub-objects</CODE>\r\n<DD>\r\n<P>Gives you ownership of all the current object\'s sub-objects when you take \r\nownership of the current object. Normally you should leave this option \r\nchecked.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (17, 4, 'Undo', '<html>\r\n<head>\r\n<title>Undo</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Undo - Undo management actions.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to undo changes to PHPortal\'s database.</P>\r\n<P>PHPortal allows you to undo changes to its database. Changes are defined in terms \r\nof transactions which group together related changes. Each transaction has a URL \r\nand a user associated with it. In general the URL of a transaction indicates the \r\nURL that was called to initiate the changes.</P>\r\n<P>If an object was changed several times and you want to recover a version \r\nseveral changes back, you have to undo all the intermediary transactions as \r\nwell.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>[Checkbox]</CODE>\r\n<DD>\r\n<P>Selects one or more transactions. Each line shows one transaction. The \r\ntransactions are sorted by date and time. The checkbox in the front allows you \r\nto check the transactions you would like to undo. The next entry on the line is \r\nthe URL that caused the transaction, followed by the user who committed the \r\ntransaction and the time transaction was performed.</P>\r\n<DT><CODE>Earlier Transactions</CODE>\r\n<DD>\r\n<P>Allows you to see transactions that were performed earlier then the ones you \r\ncurrently see.</P>\r\n<DT><CODE>Later Transactions</CODE>\r\n<DD>\r\n<P>Allows you to see transactions that were performed later then the ones you \r\ncurrently see.</P>\r\n<DT><CODE>Undo</CODE>\r\n<DD>\r\n<P>Undo the selected transactions. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (18, 4, 'Find', '<html>\r\n<head>\r\n<title>ObjectManager Find</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>ObjectManager - Find: Search PHPortal.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to search for PHPortal objects.</P>\r\n<P>To find objects you specify search criteria in the top frame and then click \r\nthe <CODE>Find</CODE> button. The find results will appear in the button frame. \r\nFor more search criteria click the <CODE>Advanced...</CODE> link.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Find objects of type</CODE>\r\n<DD>\r\n<P>The types of objects to find.</P>\r\n<DT><CODE>with ids</CODE>\r\n<DD>\r\n<P>The ids of objects to find. You may specify one or more ids separated by \r\nspaces.</P>\r\n<DT><CODE>containing</CODE>\r\n<DD>\r\n<P>The text that must be contained in the <EM>body</EM> of found items. Text in \r\nthe title or other attribute fields will not be searched.</P>\r\n<DT><CODE>modified</CODE>\r\n<DD>\r\n<P>Allows you to restrict your search to a specific time period. You can choose \r\nwhether objects <CODE>before</CODE> or <CODE>after</CODE> a specified \r\ndate/time.</P>\r\n<P><STRONG>Note: The date should be a DateTime string such as <CODE>YYYY/MM/DD \r\nhh:mm:ss</CODE>, <CODE>YYYY-MM-DD</CODE>, or <CODE>hh:mm</CODE>.</STRONG></P>\r\n<DT><CODE>Search only in this folder</CODE>\r\n<DD>\r\n<P>Find objects in this folder.</P>\r\n<DT><CODE>Search all subfolders</CODE>\r\n<DD>\r\n<P>Find objects in all subfolders.</P>\r\n<DT><CODE>Find</CODE>\r\n<DD>\r\n<P>Find objects matching the find criteria.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (19, 4, 'Security - Permissions', '<html>\r\n<head>\r\n<title>Security - Permissions</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Security - Permissions Acquisition: Security acquisition settings.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to manage security acquisition settings. You can control \r\nwhich permissions acquire security settings.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>[Permissions List]</CODE>\r\n<DD>\r\n<P>The permissions which should acquire security settings.</P>\r\n<DT><CODE>Change</CODE>\r\n<DD>\r\n<P>Sets the acquisition settings. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (20, 4, 'Security', '<html>\r\n<head>\r\n<title>Security</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>Security - Define security settings.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to define security settings.</P>\r\n<P>Security settings are defined in terms of <EM>roles</EM> and \r\n<EM>permissions</EM>. When a role is assigned to a permission users with the \r\ngiven role will be able to perform tasks associated with the permission on the \r\nobject.</P>\r\n<H4>Controls</H4>\r\n<H5>Assign Roles to Permissions</H5>\r\n<P>Roles are listed in columns and permissions are listed in rows. To assign a \r\nrole to a permission check the checkbox at the intersection of the row and \r\ncolumn. You can also manage roles and permissions individually by clicking on \r\ntheir name links.</P>\r\n<H5>Create Roles</H5>\r\n<P>You can create new roles by entering the role name in the text entry field \r\nunder the <CODE>User defined roles</CODE> heading and clicking the <CODE>Add \r\nRole</CODE> button. You can delete any existing user defined roles by selecting \r\nthem from the selection list under the <CODE>User defined roles</CODE> heading \r\nand clicking the <CODE>Delete Role</CODE> button.</P>\r\n<H5>Local Roles</H5>\r\n<P>You can create and manage local roles by clicking the <CODE>local \r\nroles</CODE> link. </P>\r\n<H5>Assign Permissions to a Role</H5>\r\n<P>You can manage the permissions assigned to a role by clicking on the role \r\nname.</P>\r\n<H5>Assign Roles to a Permission</H5>\r\n<P>You can manage the roles assigned to a permission by clicking on the \r\npermission name.</P>\r\n<H5>Acquire Permissions</H5>\r\n<P>The <CODE>Acquire permission settings</CODE> check box next to each \r\npermission indicates whether this item should inherit security settings for this \r\npermission from its container object. The acquired permission settings may be \r\naugmented by selecting roles for a permission in addition to selecting to \r\nacquire permissions.</P>\r\n<P>You can manage the acquisition of permission settings individually by \r\nclicking the <CODE>Acquire permission settings</CODE> link. </P>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (21, 4, 'Security_Define-Permissions', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Security - Define Permissions: Map permissions.</h3>\r\n<h4> Description</h4>\r\n<p> The "Define Permissions" view is used to define how the operations\r\n of this object (or objects that acquire permission settings from\r\n this object) correspond to the operations defined by your product\r\n or XClass.</p>\r\n<h5> Permissions</h5>\r\n<p> Permissions are used to represent abstract operations or types of\r\n usage. A permission may correspond to many low-level object\r\n operations. Permissions provide a way to control access to\r\n operations without having to list each operation explicitly.</p>\r\n<p> When creating Products or XClasses, we use high-level objects,\r\n like XPC Methods to define operations. These high-level objects\r\n have their own permissions, which represent abstract operations on\r\n the low-level operations of these high-level objects.</p>\r\n<p> When defining permissions for our products and XClasses we need\r\n to define what low-level operations these new permissions\r\n correspond to. We could enumerate the low-level operations of\r\n the high-level objects used to implement the operations of our\r\n products or XClasses, but this would be cumbersome, error prone,\r\n and likely to break as the interfaces of the high-level objects\r\n evolve.</p>\r\n<p> What we do instead is to treat the permissions of the high-level\r\n objects used to implement a Product or XClass operations as the\r\n low-level operations that the product or XClass operations\r\n abstract.</p>\r\n<h4> Controls</h4>\r\n<p> The view has a table with two columns. The first column lists the\r\n permissions for an object. The second column specifies the\r\n permissions that should have this permission in this product or\r\n XClass. For XClass methods only permissions that are defined for\r\n the XClass are permitted.</p>\r\n<p> In general any permissions that include operations that change\r\n (mutate) an object should be disabled. Otherwise, a method could\r\n be modified when used on an instance, such as a XClass instance.</p>\r\n<p> This interface is used to define how the operations of this object\r\n (or objects that acquire permission settings from this object)\r\n correspond to the operations defined by your product or XClass.</p>\r\n<p> **Note: The <code>View</code> permission should be always mapped to the\r\n <code>View</code> permission, since every user, even <code>Anonymous User</code> has\r\n this permission.**</p>\r\n<dl>\r\n<dt> <code>Permission for this object</code></dt>\r\n<dd>The object permission to map.</dd>\r\n<dt> <code>Permissions that correspond to (i.e. have) this permission</code></dt>\r\n<dd>The Product or XClass permission to map to.</dd>\r\n<dt> <code>Change</code></dt>\r\n<dd>Changes the permissions mapping.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (22, 1, 'Image', '<html>\r\n<head>\r\n<title>Image</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>File/Image - Add: Create a File or Image.</H3>\r\n<H4>Description</H4>\r\n<P>Creates a new File or Image.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the File or Image.</P>\r\n<P><STRONG>Note: If you do not provide an Id then the file name will be \r\nused.</STRONG></P>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the File or Image.</P>\r\n<DT><CODE>File</CODE>\r\n<DD>\r\n<P>The file to upload. use the <CODE>Browse...</CODE> button to select a local \r\nfile.</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Creates a new File or Image. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (23, 2, 'Document', '<html>\r\n<head>\r\n<title>Document</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>PHPortal Document/Method - Add: Create a PHPortal Document/Method</H3>\r\n<H4>Description</H4>\r\n<P>Creates a new PHPortal Document or Method.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the PHPortal Document or Method.</P>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the PHPortal Document or Method.</P>\r\n<DT><CODE>File</CODE>\r\n<DD>\r\n<P>Allows you to upload a file to provide the contents for the PHPortal Document or \r\nMethod. Use the <CODE>Browse...</CODE> button to select a local file.</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Create the PHPortal Document or Method.</P>\r\n<DT><CODE>Add and Edit</CODE>\r\n<DD>\r\n<P>Create the PHPortal Document or Method, and return the <CODE>Edit</CODE> view of \r\nthe created object.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (24, 3, 'File', '<html>\r\n<head>\r\n<title>File</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>File/Image - Add: Create a File or Image.</H3>\r\n<H4>Description</H4>\r\n<P>Creates a new File or Image.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the File or Image.</P>\r\n<P><STRONG>Note: If you do not provide an Id then the file name will be \r\nused.</STRONG></P>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the File or Image.</P>\r\n<DT><CODE>File</CODE>\r\n<DD>\r\n<P>The file to upload. use the <CODE>Browse...</CODE> button to select a local \r\nfile.</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Creates a new File or Image. </P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (25, 6, 'Method', '<html>\r\n<head>\r\n<title>Method</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>PHPortal Document/Method - Add: Create a PHPortal Document/Method</H3>\r\n<H4>Description</H4>\r\n<P>Creates a new PHPortal Document or Method.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Id</CODE>\r\n<DD>\r\n<P>The id of the PHPortal Document or Method.</P>\r\n<DT><CODE>Title</CODE>\r\n<DD>\r\n<P>The optional title of the PHPortal Document or Method.</P>\r\n<DT><CODE>File</CODE>\r\n<DD>\r\n<P>Allows you to upload a file to provide the contents for the PHPortal Document or \r\nMethod. Use the <CODE>Browse...</CODE> button to select a local file.</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Create the PHPortal Document or Method.</P>\r\n<DT><CODE>Add and Edit</CODE>\r\n<DD>\r\n<P>Create the PHPortal Document or Method, and return the <CODE>Edit</CODE> view of \r\nthe created object.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (26, 8, 'User Folder - Add', '<H3>User Folder - Add User: Define a new user.</H3>\r\n<H4>Description</H4>\r\n<P>This view allows you to define a new user.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Name</CODE>\r\n<DD>\r\n<P>The user\'s name.</P>\r\n<DT><CODE>Password</CODE>\r\n<DD>\r\n<P>The user\'s password.</P>\r\n<DT><CODE>Confirm</CODE>\r\n<DD>\r\n<P>Confirm the user\'s password.</P>\r\n<DT><CODE>Domains</CODE>\r\n<DD>\r\n<P>Optionally allows you to restrict the Internet domains from which the user \r\ncan log in. Domains should be separated by spaces. For example, \r\n<CODE>dev.4arrow.com phportal.org</CODE></P>\r\n<DT><CODE>Roles</CODE>\r\n<DD>\r\n<P>The user\'s roles</P>\r\n<DT><CODE>Add</CODE>\r\n<DD>\r\n<P>Create a new user. </P></DD></DL>');
INSERT INTO xpc_help VALUES (27, 8, 'User Folder Edit', '<html>\r\n<head>\r\n<title>User Folder Edit</title>\r\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css">\r\n</head>\r\n\r\n<body bgcolor="#FFFFFF" text="#000000">\r\n<H3>User Folder - Edit User: Edit a user</H3>\r\n<H4>Descriptions</H4>\r\n<P>This view allows you to edit a user.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>Name</CODE>\r\n<DD>\r\n<P>The user\'s name.</P>\r\n<DT><CODE>Password</CODE>\r\n<DD>\r\n<P>The user\'s password.</P>\r\n<DT><CODE>Confirm</CODE>\r\n<DD>\r\n<P>Confirm the user\'s password.</P>\r\n<DT><CODE>Domains</CODE>\r\n<DD>\r\n<P>Optionally allows you to restrict the Internet domains from which the user \r\ncan log in. Domains should be separated by spaces. For example, \r\n<CODE>digicool.com PHPortal.org</CODE></P>\r\n<DT><CODE>Roles</CODE>\r\n<DD>\r\n<P>The user\'s roles</P>\r\n<DT><CODE>Change</CODE>\r\n<DD>\r\n<P>Change the user.</P></DD></DL>\r\n\r\n</body>\r\n</html>');
INSERT INTO xpc_help VALUES (28, 11, 'PHPScript_edit', '<html>\r\n<head>\r\n<title>Script (PHP)</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Edit View: Edit A Script (PHP)</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to edit the logic which composes a script\r\n in PHP. Script instances execute in a restricted\r\n context, bounded by your user\'s privilege level in PHPortal, and\r\n certain global restrictions of all through-the-web code. For\r\n information about what you "can" and "cannot" do in a Script\r\n instance as opposed to non-through-the-web PHP,\r\n see the API Reference documentation for "Script (PHP)" in\r\n this help system.</p>\r\n<h4> Controls</h4>\r\n<dl> \r\n <dt> <code>Title</code></dt>\r\n <dd>Allows you to specify the PHPortal title of the script.</dd>\r\n <dt> <code>Id</code></dt>\r\n <dd>Allows you to specify the id of the script.</dd>\r\n <dt> <code>Parameter List</code></dt>\r\n <dd>Enter function parameters for this script separated by commas. For example: \r\n <em>foo, bar, baz</em></dd>\r\n</dl>\r\n<p> More information about bindings can be found by visiting the\r\n help screens of the "Bindings" tab of a Script (PHP)\r\n instance.</p>\r\n<h4> Buttons and Other Form Elements</h4>\r\n<dl>\r\n<dt> <code>Save Changes</code></dt>\r\n<dd>saves changes you make to the body, title, or\r\n parameter list.</dd>\r\n<dt> <code>Taller</code>/<code>Shorter</code>/<code>Wider</code>/<code>Narrower</code></dt>\r\n<dd>make the body textarea\r\n taller, shorter, wider, or narrower.</dd>\r\n<dt> <code>File</code></dt>\r\n<dd>upload a file into this Script (PHP) instance.</dd>\r\n</dl>\r\n<h5> File Upload Details</h5>\r\n<p> Files uploaded into a Script (PHP) instance may consist only of the actual \r\n body of the function. For example, a file uploaded into a Script (PHP) instance \r\n might be simply: \r\n<pre>\r\n return "Hello"\r\n</pre>\r\n<p></p>\r\n<p> If you upload this file into a Script (PHP) instance, the existing settings \r\n (or default settings) for parameters, and title will remain.</p>\r\n</body></html>');
INSERT INTO xpc_help VALUES (29, 9, 'Version', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Version - Private session.</h3>\r\n<h4> Description</h4>\r\n<p> A Version allows you to make changes to PHPortal in a private session.</p>\r\n<p> No one else can see changes you make in a Version. Later you can\r\n make your changes public or discard them.</p>\r\n<p> Objects changed in a Version are locked.</p>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (30, 9, 'Version_Add', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Version - Add: Create a new Version</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to create a new Version.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>Title</code></dt>\r\n<dd>The title of the Version.</dd>\r\n<dt> <code>Add</code></dt>\r\n<dd>Creates a new Version.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (31, 9, 'Version_Properties', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Version - Properties: Edit Version Properties.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to edit the title of a Version.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>Title</code></dt>\r\n<dd>The title of the Version.</dd>\r\n<dt> <code>Edit</code></dt>\r\n<dd>Changes the title of the Version.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (32, 9, 'Version_Save-Discard', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Version - Save/Discard: Commit/abort Version changes.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to commit or discard changes made in a\r\n Version.</p>\r\n<h4> Controls</h4>\r\n<p> When committing or discarding a Version you can enter comments in\r\n the comments text area.</p>\r\n<dl>\r\n<dt> <code>Save</code></dt>\r\n<dd>Commit the changes in the Version and make them public.</dd>\r\n<dt> <code>Discard</code></dt>\r\n<dd>Discard the changes made in the Version.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (33, 9, 'Version-Management', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Version Management - Control PHPortal versions.</h3>\r\n<h4> Description</h4>\r\n<p> Version Management allows you to control all PHPortal Versions.</p>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (34, 9, 'Version-Management_Version', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Version Management - Version: Manage versions.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to manage versions.</p>\r\n<h4> Controls</h4>\r\n<p> Non-empty versions are listed one per line. Click on a version to\r\n edit it.</p>\r\n<dl>\r\n<dt> <code>[Checkbox]</code></dt>\r\n<dd>Selects versions.</dd>\r\n<dt> <code>Save</code></dt>\r\n<dd>Commits the selected versions.</dd>\r\n<dt> <code>Discard</code></dt>\r\n<dd>Aborts the selected versions.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (35, 4, 'Object Manager', '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">\r\n<HTML>\r\n<HEAD>\r\n<meta name="GENERATOR" content="Microsoft&reg; HTML Help Workshop 4.1">\r\n<Title>Object Manager</Title>\r\n<LINK REL="StyleSheet" HREF="help.css" TYPE="text/css"> \r\n</HEAD>\r\n<BODY>\r\n<UL>\r\n<H3>ObjectManager - Contents: Edit contained objects.</H3>\r\n<H4>Description</H4>\r\n<P>This view displays the contained objects and allows you to add, delete and \r\nchange them.</P>\r\n<P>Each contained object is displayed on a line and is identified by an icon, an \r\nid and a title in parenthesis. Additionally, the size (if applicable) and the \r\ndate during which the object was last modified are displayed. You can manage an \r\nobject by clicking on its identifying link.</P>\r\n<H5>Sorting</H5>\r\n<P>You can sort contained objects by type, name (id), size, or modification \r\ndate. To do so, click on the appropriate column heading. Clicking a second time \r\non any column heading will reverse the sort on that field.</P>\r\n<H5>Versions</H5>\r\n<P>If you are currently working in a version there will be a notice at the top \r\nof the list of objects indicating this.</P>\r\n<P>If there is a red diamond following the name of an object this indicates that \r\nthe object has been modified in the version you are currently working in. If \r\nthere is a red diamond with a lock after an object, this indicates the the \r\nobject has been modified in another version.</P>\r\n<H4>Controls</H4>\r\n<DL>\r\n<DT><CODE>[Checkbox]</CODE> \r\n<DD>\r\n<P>Selects the object in order to perform operations on it. The operations you \r\ncan perform are rename, cut, copy, delete, and export. Some operations may not \r\nbe visible if they are not allowed.</P>\r\n<DT><CODE>Rename</CODE> \r\n<DD>\r\n<P>Changes the ids of the selected objects.</P>\r\n<DT><CODE>Cut</CODE> \r\n<DD>\r\n<P>Cuts selected objects and place them into the clipboard. This is similar to \r\ncut in most file managers. Cut objects can be pasted in a new location. When cut \r\nobjects are pasted into another location the old objects are deleted.</P>\r\n<DT><CODE>Copy</CODE> \r\n<DD>\r\n<P>Copies selected objects and place them in the clipboard. This is similar to \r\ncopy in most file managers. Copied objects can be pasted in a new location.</P>\r\n<DT><CODE>Paste</CODE> \r\n<DD>\r\n<P>Allows you to paste objects from the clipboard into this object. \r\n<STRONG>Note: This option will only appear if objects have previously been \r\ncopied or cut.</STRONG></P>\r\n<DT><CODE>Delete</CODE> \r\n<DD>\r\n<P>Deletes the selected objects. Deleted objects are <EM>not</EM> placed in the \r\nclipboard.</P>\r\n<DT><CODE>Import/Export</CODE> \r\n<DD>\r\n<P>Imports or exports a XPC object.</P>\r\n<DT><CODE>Available Objects</CODE> \r\n<DD>\r\n<P>Selects a type of object to add.</P>\r\n<DT><CODE>Add</CODE> \r\n<DD>\r\n<P>Adds an object specified in <CODE>Available Objects</CODE>.</P>\r\n<DT><CODE>Select All (Deselect All)</CODE> \r\n<DD>\r\n<P>Toggles between selecting and deselecting each item currently displayed in \r\nthe contents view. <STRONG>Note: This control will only appear if your browser \r\nis javascript-enabled.</STRONG> </P></DD></DL></UL>\r\n</BODY>\r\n</HTML>');
INSERT INTO xpc_help VALUES (36, 4, 'ObjectManager_Import-Export', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Folder - Import/Export: Import/export PHPortal objects.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to import or export PHPortal objects. Imported\r\n objects will be inserted into the current object. Exported objects\r\n will be saved to a file on the PHPortal server or downloaded to the\r\n local client.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>Export object id</code></dt>\r\n<dd>The id of the object to be exported.\r\n <strong>Note: The exported object must be contained by the current\r\n object.</strong></dd>\r\n<dt> <code>Export to</code></dt>\r\n<dd>Where you want to save the exported file. <code>Download\r\n to local machine</code> downloads the export file to your client, <code>Save to\r\n file server</code> saves the export file to the PHPortal <code>var</code> directory.</dd>\r\n<dt> <code>XML format?</code></dt>\r\n<dd>Whether the exported object\r\n is in a binary format or in XML format.</dd>\r\n<dt> <code>Export</code></dt>\r\n<dd>Exports the object.</dd>\r\n<dt> <code>Import file name</code></dt>\r\n<dd>The filename of the PHPortal export file that\r\n you would like to import. The file must be located in the PHPortal\r\n <code>import</code> directory.</dd>\r\n<dt> <code>Import</code></dt>\r\n<dd>Imports the object.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (37, 4, 'ObjectManager_Rename', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>ObjectManager - Rename: Change object ids.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to change the id of one or more objects.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>to</code></dt>\r\n<dd>The new id of each object. The\r\n default value is the old id.</dd>\r\n<dt> <code>OK</code></dt>\r\n<dd>Changes the ids of the objects.</dd>\r\n<dt> <code>Cancel</code></dt>\r\n<dd>Cancels renaming operation.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (38, 4, 'Security_Local-Roles', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Folder - Local Roles: Manage local roles.</h3>\r\n<h4> Description</h4>\r\n<p> Local roles allow you to give users additional roles in the\r\n context of an object.</p>\r\n<h4> Controls</h4>\r\n<h5> Editing local roles</h5>\r\n<dl>\r\n<dt> \'[Checkbox]\'</dt>\r\n<dd>Select users. Click a user\'s name to edit their\r\n local roles.</dd>\r\n<dt> <code>Remove</code></dt>\r\n<dd>Deletes local roles for the selected users.</dd>\r\n</dl>\r\n<h5> Creating local roles</h5>\r\n<dl>\r\n<dt> <code>User</code></dt>\r\n<dd>The user for which you would like to define local\r\n roles.</dd>\r\n<dt> <code>Roles</code></dt>\r\n<dd>The local roles you would like to assign to the user.</dd>\r\n<dt> <code>Add</code></dt>\r\n<dd>Adds the selected local roles for the selected user.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (39, 4, 'Security_Manage-Acquisition', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Security - Permissions Acquisition: Security acquisition settings.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to manage security acquisition settings. You\r\n can control which permissions acquire security settings.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>[Permissions List]</code></dt>\r\n<dd>The permissions which\r\n should acquire security settings.</dd>\r\n<dt> <code>Change</code></dt>\r\n<dd>Sets the acquisition settings.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (40, 4, 'Security_Manage-Permission', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Folder - Manage Permission: Assign roles to a permission.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to assign roles to a permission.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>[Role List]</code></dt>\r\n<dd>The roles assigned to the permission.</dd>\r\n<dt> <code>Also use roles acquired from folders containing this object</code></dt>\r\n<dd>Whether or not to acquire permissions settings for the permission.</dd>\r\n<dt> <code>Change</code></dt>\r\n<dd>Changes the security settings.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (41, 4, 'Security_Manage-Role', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Folder - Manage Role: Assign permissions to a role.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to assign permissions to a role.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>[Permissions List]</code></dt>\r\n<dd>The permissions\r\n assigned to the role.</dd>\r\n<dt> <code>Change</code></dt>\r\n<dd>Changes the security settings.</dd>\r\n</dl>\r\n\r\n</body></html>');
INSERT INTO xpc_help VALUES (42, 4, 'Security_User-Local-Roles', '<html>\r\n<head>\r\n<title>PHPortal Help</title>\r\n\r\n<style type="text/css">\r\n\r\n.instructions{\r\nbackground: #FFFFAA;\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.explanation{\r\nborder-width: thin;\r\nborder-style: solid;\r\npadding: 10pt;\r\n}\r\n\r\n.api{\r\nfont-size: 14pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n.attribute, .method{\r\nfont-size: 12pt;\r\nfont-family : "Courier New", Courier, monospace;\r\n}\r\n\r\n</style>\r\n\r\n</head>\r\n<body bgcolor="#FFFFFF">\r\n\r\n<h3>Security - User local roles: Manage local roles.</h3>\r\n<h4> Description</h4>\r\n<p> This view allows you to manage a user\'s local roles.</p>\r\n<h4> Controls</h4>\r\n<dl>\r\n<dt> <code>User</code></dt>\r\n<dd>The user whose local roles you going to change.</dd>\r\n<dt> <code>Roles</code></dt>\r\n<dd>The user\'s local roles.</dd>\r\n<dt> <code>Change</code></dt>\r\n<dd>Change the local roles.</dd>\r\n</dl>\r\n\r\n</body></html>');
# --------------------------------------------------------

#
# Table structure for table `xpc_help_props`
#

CREATE TABLE xpc_help_props (
id tinyint(11) NOT NULL auto_increment,
oid tinyint(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
value mediumtext NOT NULL,
type enum('boolean','date','dynamic','float','int','lines','long','string','text','tokens','selection','multiple selection') NOT NULL default 'string',
sys enum('y','n','i','a') NOT NULL default 'y',
PRIMARY KEY (id),
KEY oid(oid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_help_props`
#

INSERT INTO xpc_help_props VALUES (1, 1, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (2, 2, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (3, 3, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (4, 4, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (5, 5, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (6, 6, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (7, 7, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (8, 8, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (9, 9, 'date_added', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (10, 1, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (11, 2, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (12, 3, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (13, 4, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (14, 5, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (15, 6, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (16, 7, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (17, 8, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (18, 9, 'date_modified', '2003-01-03 00:26:23', 'date', 'y');
INSERT INTO xpc_help_props VALUES (19, 10, 'date_modified', '2003-01-03 00:26:23', 'date', 'i');
INSERT INTO xpc_help_props VALUES (20, 11, 'date_added', '2002-12-30 11:04:21', 'date', 'i');
INSERT INTO xpc_help_props VALUES (21, 11, 'date_modified', '2002-12-30 11:04:21', 'date', 'i');
INSERT INTO xpc_help_props VALUES (22, 11, 'title', '', 'string', 'y');
INSERT INTO xpc_help_props VALUES (23, 11, 'uri', '/Control_Panel/Products/folder/Help.xpc/Folder - Local Roles', 'string', 'i');
INSERT INTO xpc_help_props VALUES (24, 12, 'date_added', '2002-12-30 11:08:58', 'date', 'i');
INSERT INTO xpc_help_props VALUES (25, 12, 'date_modified', '2002-12-30 11:08:58', 'date', 'i');
INSERT INTO xpc_help_props VALUES (26, 12, 'title', '', 'string', 'y');
INSERT INTO xpc_help_props VALUES (27, 12, 'uri', '/Control_Panel/Products/folder/Help.xpc/Folder - Manage Permission', 'string', 'i');
INSERT INTO xpc_help_props VALUES (28, 13, 'date_added', '2002-12-30 11:46:16', 'date', 'i');
INSERT INTO xpc_help_props VALUES (29, 13, 'date_modified', '2002-12-30 11:46:16', 'date', 'i');
INSERT INTO xpc_help_props VALUES (30, 13, 'title', 'Folder - Manage Role.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (31, 13, 'uri', '/Control_Panel/Products/folder/Help.xpc/Folder - Manage Role', 'string', 'i');
INSERT INTO xpc_help_props VALUES (32, 14, 'date_added', '2002-12-30 19:03:01', 'date', 'i');
INSERT INTO xpc_help_props VALUES (33, 14, 'date_modified', '2002-12-30 19:03:01', 'date', 'i');
INSERT INTO xpc_help_props VALUES (34, 14, 'title', 'History.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (35, 14, 'uri', '/Control_Panel/Products/folder/Help.xpc/History', 'string', 'i');
INSERT INTO xpc_help_props VALUES (36, 15, 'date_added', '2002-12-30 19:03:55', 'date', 'i');
INSERT INTO xpc_help_props VALUES (37, 15, 'date_modified', '2002-12-30 19:03:55', 'date', 'i');
INSERT INTO xpc_help_props VALUES (38, 15, 'title', 'properties.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (39, 15, 'uri', '/Control_Panel/Products/folder/Help.xpc/properties', 'string', 'i');
INSERT INTO xpc_help_props VALUES (40, 16, 'date_added', '2002-12-30 19:04:22', 'date', 'i');
INSERT INTO xpc_help_props VALUES (41, 16, 'date_modified', '2002-12-30 19:04:22', 'date', 'i');
INSERT INTO xpc_help_props VALUES (42, 16, 'title', 'Ownership.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (43, 16, 'uri', '/Control_Panel/Products/folder/Help.xpc/Ownership', 'string', 'i');
INSERT INTO xpc_help_props VALUES (44, 17, 'date_added', '2002-12-30 19:04:35', 'date', 'i');
INSERT INTO xpc_help_props VALUES (45, 17, 'date_modified', '2002-12-30 19:04:35', 'date', 'i');
INSERT INTO xpc_help_props VALUES (46, 17, 'title', 'Undo.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (47, 17, 'uri', '/Control_Panel/Products/folder/Help.xpc/Undo', 'string', 'i');
INSERT INTO xpc_help_props VALUES (48, 18, 'date_added', '2002-12-30 19:04:46', 'date', 'i');
INSERT INTO xpc_help_props VALUES (49, 18, 'date_modified', '2002-12-30 19:04:46', 'date', 'i');
INSERT INTO xpc_help_props VALUES (50, 18, 'title', 'Find.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (51, 18, 'uri', '/Control_Panel/Products/folder/Help.xpc/Find', 'string', 'i');
INSERT INTO xpc_help_props VALUES (52, 19, 'date_added', '2002-12-30 19:05:17', 'date', 'i');
INSERT INTO xpc_help_props VALUES (53, 19, 'date_modified', '2002-12-30 19:05:17', 'date', 'i');
INSERT INTO xpc_help_props VALUES (54, 19, 'title', 'Security - Permissions.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (55, 19, 'uri', '/Control_Panel/Products/folder/Help.xpc/Security - Permissions', 'string', 'i');
INSERT INTO xpc_help_props VALUES (56, 20, 'date_added', '2002-12-30 19:05:31', 'date', 'i');
INSERT INTO xpc_help_props VALUES (57, 20, 'date_modified', '2002-12-30 19:05:31', 'date', 'i');
INSERT INTO xpc_help_props VALUES (58, 20, 'title', 'Security.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (59, 20, 'uri', '/Control_Panel/Products/folder/Help.xpc/Security', 'string', 'i');
INSERT INTO xpc_help_props VALUES (60, 21, 'date_added', '2002-12-30 19:06:43', 'date', 'i');
INSERT INTO xpc_help_props VALUES (61, 21, 'date_modified', '2002-12-30 19:06:43', 'date', 'i');
INSERT INTO xpc_help_props VALUES (62, 21, 'title', 'Security_Define-Permissions.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (63, 21, 'uri', '/Control_Panel/Products/folder/Help.xpc/Security_Define-Permissions', 'string', 'i');
INSERT INTO xpc_help_props VALUES (64, 22, 'date_added', '2002-12-30 19:08:07', 'date', 'i');
INSERT INTO xpc_help_props VALUES (65, 22, 'date_modified', '2002-12-30 19:08:07', 'date', 'i');
INSERT INTO xpc_help_props VALUES (66, 22, 'title', 'Image.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (67, 22, 'uri', '/Control_Panel/Products/binary/Help.xpc/Image', 'string', 'i');
INSERT INTO xpc_help_props VALUES (68, 23, 'date_added', '2002-12-30 19:08:25', 'date', 'i');
INSERT INTO xpc_help_props VALUES (69, 23, 'date_modified', '2002-12-30 19:08:25', 'date', 'i');
INSERT INTO xpc_help_props VALUES (70, 23, 'title', 'Document.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (71, 23, 'uri', '/Control_Panel/Products/document/Help.xpc/Document', 'string', 'i');
INSERT INTO xpc_help_props VALUES (72, 24, 'date_added', '2002-12-30 19:08:39', 'date', 'i');
INSERT INTO xpc_help_props VALUES (73, 24, 'date_modified', '2002-12-30 19:08:39', 'date', 'i');
INSERT INTO xpc_help_props VALUES (74, 24, 'title', 'File.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (75, 24, 'uri', '/Control_Panel/Products/file/Help.xpc/File', 'string', 'i');
INSERT INTO xpc_help_props VALUES (76, 25, 'date_added', '2002-12-30 19:08:54', 'date', 'i');
INSERT INTO xpc_help_props VALUES (77, 25, 'date_modified', '2002-12-30 19:08:54', 'date', 'i');
INSERT INTO xpc_help_props VALUES (78, 25, 'title', 'Method.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (79, 25, 'uri', '/Control_Panel/Products/method/Help.xpc/Method', 'string', 'i');
INSERT INTO xpc_help_props VALUES (80, 26, 'date_added', '2002-12-30 19:09:41', 'date', 'i');
INSERT INTO xpc_help_props VALUES (81, 26, 'date_modified', '2002-12-30 19:09:41', 'date', 'i');
INSERT INTO xpc_help_props VALUES (82, 26, 'title', 'User Folder - Add.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (83, 26, 'uri', '/Control_Panel/Products/userfolder/Help.xpc/User Folder - Add', 'string', 'i');
INSERT INTO xpc_help_props VALUES (84, 27, 'date_added', '2002-12-30 19:09:51', 'date', 'i');
INSERT INTO xpc_help_props VALUES (85, 27, 'date_modified', '2002-12-30 19:09:51', 'date', 'i');
INSERT INTO xpc_help_props VALUES (86, 27, 'title', 'User Folder Edit.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (87, 27, 'uri', '/Control_Panel/Products/userfolder/Help.xpc/User Folder Edit', 'string', 'i');
INSERT INTO xpc_help_props VALUES (88, 28, 'date_added', '2002-12-30 19:10:39', 'date', 'i');
INSERT INTO xpc_help_props VALUES (89, 28, 'date_modified', '2002-12-30 19:10:39', 'date', 'i');
INSERT INTO xpc_help_props VALUES (90, 28, 'title', 'PHPScript_edit.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (91, 28, 'uri', '/Control_Panel/Products/script/Help.xpc/PHPScript_edit', 'string', 'i');
INSERT INTO xpc_help_props VALUES (92, 29, 'date_added', '2002-12-30 19:14:55', 'date', 'i');
INSERT INTO xpc_help_props VALUES (93, 29, 'date_modified', '2002-12-30 19:14:55', 'date', 'i');
INSERT INTO xpc_help_props VALUES (94, 29, 'title', 'Version.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (95, 29, 'uri', '/Control_Panel/Products/version/Help.xpc/Version', 'string', 'i');
INSERT INTO xpc_help_props VALUES (96, 30, 'date_added', '2002-12-30 19:15:09', 'date', 'i');
INSERT INTO xpc_help_props VALUES (97, 30, 'date_modified', '2002-12-30 19:15:09', 'date', 'i');
INSERT INTO xpc_help_props VALUES (98, 30, 'title', 'Version_Add.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (99, 30, 'uri', '/Control_Panel/Products/version/Help.xpc/Version_Add', 'string', 'i');
INSERT INTO xpc_help_props VALUES (100, 31, 'date_added', '2002-12-30 19:15:23', 'date', 'i');
INSERT INTO xpc_help_props VALUES (101, 31, 'date_modified', '2002-12-30 19:15:23', 'date', 'i');
INSERT INTO xpc_help_props VALUES (102, 31, 'title', 'Version_Properties.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (103, 31, 'uri', '/Control_Panel/Products/version/Help.xpc/Version_Properties', 'string', 'i');
INSERT INTO xpc_help_props VALUES (104, 32, 'date_added', '2002-12-30 19:15:40', 'date', 'i');
INSERT INTO xpc_help_props VALUES (105, 32, 'date_modified', '2002-12-30 19:15:40', 'date', 'i');
INSERT INTO xpc_help_props VALUES (106, 32, 'title', 'Version_Save-Discard.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (107, 32, 'uri', '/Control_Panel/Products/version/Help.xpc/Version_Save-Discard', 'string', 'i');
INSERT INTO xpc_help_props VALUES (108, 33, 'date_added', '2002-12-30 19:15:58', 'date', 'i');
INSERT INTO xpc_help_props VALUES (109, 33, 'date_modified', '2002-12-30 19:15:58', 'date', 'i');
INSERT INTO xpc_help_props VALUES (110, 33, 'title', 'Version-Management.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (111, 33, 'uri', '/Control_Panel/Products/version/Help.xpc/Version-Management', 'string', 'i');
INSERT INTO xpc_help_props VALUES (112, 34, 'date_added', '2002-12-30 19:16:07', 'date', 'i');
INSERT INTO xpc_help_props VALUES (113, 34, 'date_modified', '2002-12-30 19:16:07', 'date', 'i');
INSERT INTO xpc_help_props VALUES (114, 34, 'title', 'Version-Management_Version.htm', 'string', 'y');
INSERT INTO xpc_help_props VALUES (115, 34, 'uri', '/Control_Panel/Products/version/Help.xpc/Version-Management_Version', 'string', 'i');
# --------------------------------------------------------

#
# Table structure for table `xpc_history`
#

CREATE TABLE xpc_history (
id int(11) NOT NULL auto_increment,
oid int(11) NOT NULL default '1',
vid decimal(3,1) NOT NULL default '1.0',
name text NOT NULL,
value text NOT NULL,
uid int(11) NOT NULL default '1',
date int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY oid(oid),
KEY vid(vid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_history`
#

# --------------------------------------------------------

#
# Table structure for table `xpc_objects`
#

CREATE TABLE xpc_objects (
id bigint(24) NOT NULL auto_increment,
pid bigint(24) NOT NULL default '1',
oid bigint(24) NOT NULL default '1',
uid bigint(24) NOT NULL default '1',
name varchar(255) NOT NULL default '',
value text NOT NULL,
type varchar(155) NOT NULL default '',
object varchar(155) NOT NULL default '',
PRIMARY KEY (id),
KEY pid(pid),
KEY oid(oid),
FULLTEXT KEY name(name,value)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_objects`
#

INSERT INTO xpc_objects VALUES (1, 0, 1, 1, 'root', 'root folder object', 'folder', '');
INSERT INTO xpc_objects VALUES (2, 1, 1, 1, 'index', '<XPC:standard_html_header/>\n<XPC:EXP_inc file="./manage/tpl/quickstart.html"/>\n<XPC:standard_html_footer/>', 'document', '');
INSERT INTO xpc_objects VALUES (3, 1, 1, 1, 'standard_html_header', '<table width="80%" align="center" border="1">\n<tr align="left"><td>\n<a href="http://dev.4arrow.com"><img alt="PHPortal - The PHP Application Builder" src="/manage/tpl/img/logos/phportal.gif" border="0" /></a></td></tr><tr>\n<td>', 'document', '');
INSERT INTO xpc_objects VALUES (4, 1, 1, 1, 'standard_html_footer', '</td>\n</tr>\n</table>', 'document', '');
INSERT INTO xpc_objects VALUES (5, 1, 1, 1, 'acl_users', '', 'userfolder', '');
INSERT INTO xpc_objects VALUES (6, 1, 1, 1, 'standard_error_message', '<XPC:standard_html_header/>\n <TABLE BORDER="0" WIDTH="100%">\n <TR VALIGN="TOP">\n <TD WIDTH="10%" ALIGN="CENTER">\n <a href="http://xpc.4arrow.com">\n <img alt="4Arrow Xpc - eXtensible Page Creation" src="/manage/tpl/img/logos/xpc_logo.jpeg" height="187" width="129" border="" />\n </a>\n </TD>\n <TD WIDTH="90%">\n <H2>{ERROR_TYPE}</H2>\n {ERROR}\n </TD></TR>\n </TABLE>\n <!--\n Traceback (innermost last):\n {TRACEBACK}\n -->\n <XPC:standard_html_footer/>', 'document', '');
INSERT INTO xpc_objects VALUES (7, 1, 1, 1, 'HelpSys', '', 'help', '');
INSERT INTO xpc_objects VALUES (8, 1, 1, 1, 'Control_Panel', 'Control Panel', 'folder', 'control');
INSERT INTO xpc_objects VALUES (9, 8, 1, 1, 'Database', 'Database Management', 'folder', 'db');
INSERT INTO xpc_objects VALUES (10, 8, 1, 1, 'Versions', 'Version Management', 'folder', 'version');
INSERT INTO xpc_objects VALUES (11, 8, 1, 1, 'Products', 'Product Management', 'folder', 'product');
INSERT INTO xpc_objects VALUES (12, 11, 1, 1, 'binary', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (13, 11, 1, 1, 'document', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (14, 11, 1, 1, 'file', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (15, 11, 1, 1, 'folder', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (16, 11, 1, 1, 'method', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (17, 11, 1, 1, 'version', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (18, 11, 1, 1, 'script', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (19, 11, 1, 1, 'template', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (20, 11, 1, 1, 'userfolder', 'Product', 'folder', 'product');
INSERT INTO xpc_objects VALUES (21, 12, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (22, 13, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (23, 14, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (24, 15, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (25, 16, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (26, 17, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (27, 18, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (28, 19, 1, 1, 'Help', '', 'folder', 'Product_Help');
INSERT INTO xpc_objects VALUES (29, 20, 1, 1, 'Help', '', 'folder', 'Product_Help');
# --------------------------------------------------------

#
# Table structure for table `xpc_perms`
#

CREATE TABLE xpc_perms (
id bigint(24) NOT NULL auto_increment,
aid tinyint(11) NOT NULL default '0',
name char(155) NOT NULL default '',
PRIMARY KEY (id),
KEY aid(aid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_perms`
#

INSERT INTO xpc_perms VALUES (1, 0, 'read');
INSERT INTO xpc_perms VALUES (2, 0, 'manage');
INSERT INTO xpc_perms VALUES (3, 0, 'top');
INSERT INTO xpc_perms VALUES (4, 0, 'menu');
INSERT INTO xpc_perms VALUES (5, 0, 'main');
INSERT INTO xpc_perms VALUES (6, 0, 'space');
INSERT INTO xpc_perms VALUES (7, 0, 'prop');
INSERT INTO xpc_perms VALUES (8, 0, 'perms');
INSERT INTO xpc_perms VALUES (9, 0, 'undo');
INSERT INTO xpc_perms VALUES (10, 0, 'owner');
INSERT INTO xpc_perms VALUES (11, 0, 'find');
INSERT INTO xpc_perms VALUES (12, 0, 'edit');
INSERT INTO xpc_perms VALUES (13, 0, 'control');
INSERT INTO xpc_perms VALUES (14, 0, 'add');
INSERT INTO xpc_perms VALUES (15, 0, 'history');
INSERT INTO xpc_perms VALUES (16, 0, 'change');
INSERT INTO xpc_perms VALUES (17, 0, 'upload');
INSERT INTO xpc_perms VALUES (18, 0, 'exp');
INSERT INTO xpc_perms VALUES (19, 7, 'store');
INSERT INTO xpc_perms VALUES (20, 4, 'add_binary');
INSERT INTO xpc_perms VALUES (21, 4, 'add_document');
INSERT INTO xpc_perms VALUES (22, 4, 'add_file');
INSERT INTO xpc_perms VALUES (23, 4, 'add_folder');
INSERT INTO xpc_perms VALUES (24, 4, 'add_members');
INSERT INTO xpc_perms VALUES (25, 4, 'add_method');
INSERT INTO xpc_perms VALUES (26, 4, 'add_search');
INSERT INTO xpc_perms VALUES (27, 4, 'add_userfolder');
INSERT INTO xpc_perms VALUES (28, 4, 'Rename');
INSERT INTO xpc_perms VALUES (29, 4, 'Cut');
INSERT INTO xpc_perms VALUES (30, 4, 'Copy');
INSERT INTO xpc_perms VALUES (31, 4, 'Delete');
INSERT INTO xpc_perms VALUES (32, 4, 'Import_Export');
INSERT INTO xpc_perms VALUES (33, 0, 'prop_form');
INSERT INTO xpc_perms VALUES (34, 0, 'prop_add');
INSERT INTO xpc_perms VALUES (35, 0, 'prop_edit');
INSERT INTO xpc_perms VALUES (36, 0, 'prop_del');
INSERT INTO xpc_perms VALUES (37, 0, 'editBinary');
INSERT INTO xpc_perms VALUES (38, 0, 'editDocument');
INSERT INTO xpc_perms VALUES (39, 0, 'editFile');
INSERT INTO xpc_perms VALUES (40, 0, 'editMethod');
INSERT INTO xpc_perms VALUES (41, 4, 'add_script');
INSERT INTO xpc_perms VALUES (42, 0, 'editScript');
INSERT INTO xpc_perms VALUES (43, 4, 'add_vhost');
INSERT INTO xpc_perms VALUES (44, 0, 'editVhost');
INSERT INTO xpc_perms VALUES (45, 4, 'add_Help_Topic');
INSERT INTO xpc_perms VALUES (46, 10, 'editHelp_Topic');
INSERT INTO xpc_perms VALUES (47, 10, 'access');
INSERT INTO xpc_perms VALUES (48, 10, 'readme');
INSERT INTO xpc_perms VALUES (49, 10, 'refresh');
INSERT INTO xpc_perms VALUES (50, 10, 'add_product');
# --------------------------------------------------------

#
# Table structure for table `xpc_props`
#

CREATE TABLE xpc_props (
id bigint(24) NOT NULL auto_increment,
oid bigint(24) NOT NULL default '1',
uid bigint(24) NOT NULL default '1',
name varchar(155) NOT NULL default '',
value mediumtext NOT NULL,
type enum('boolean','date','dynamic','float','int','lines','long','string','text','tokens','selection','multiple selection') NOT NULL default 'string',
sys enum('y','n','i','a') NOT NULL default 'y',
PRIMARY KEY (id),
KEY uid(uid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_props`
#

INSERT INTO xpc_props VALUES (1, 2, 1, 'uri', '/index.xpc', 'string', 'i');
INSERT INTO xpc_props VALUES (2, 3, 1, 'uri', '/standard_html_header.xpc', 'string', 'i');
INSERT INTO xpc_props VALUES (3, 4, 1, 'uri', '/standard_html_footer.xpc', 'string', 'i');
INSERT INTO xpc_props VALUES (4, 5, 1, 'uri', '/acl_users/', 'string', 'i');
INSERT INTO xpc_props VALUES (5, 6, 1, 'uri', '/standard_error_message.xpc', 'string', 'i');
INSERT INTO xpc_props VALUES (6, 2, 1, 'date_added', '2002-11-03 20:14:35', 'date', 'i');
INSERT INTO xpc_props VALUES (7, 3, 1, 'date_added', '2002-11-03 20:14:35', 'date', 'i');
INSERT INTO xpc_props VALUES (8, 4, 1, 'date_added', '2002-11-03 20:14:35', 'date', 'i');
INSERT INTO xpc_props VALUES (9, 5, 1, 'date_added', '2002-11-03 20:14:35', 'date', 'i');
INSERT INTO xpc_props VALUES (10, 6, 1, 'date_added', '2002-11-03 20:14:35', 'date', 'i');
INSERT INTO xpc_props VALUES (11, 2, 1, 'title', 'Home Page', 'string', 'y');
INSERT INTO xpc_props VALUES (12, 3, 1, 'title', 'Standard Html Header', 'string', 'y');
INSERT INTO xpc_props VALUES (13, 4, 1, 'title', 'Standard Html Footer', 'string', 'y');
INSERT INTO xpc_props VALUES (14, 5, 1, 'title', 'User Folder', 'string', 'y');
INSERT INTO xpc_props VALUES (15, 6, 1, 'title', 'Standard Error Message', 'string', 'y');
INSERT INTO xpc_props VALUES (16, 8, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (17, 9, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (18, 10, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (19, 11, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (20, 12, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (21, 13, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (22, 14, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (23, 15, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (24, 16, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (25, 17, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (26, 18, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (27, 19, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (28, 20, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (29, 21, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (30, 22, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (31, 23, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (32, 24, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (33, 25, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (34, 26, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (35, 27, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (36, 28, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
INSERT INTO xpc_props VALUES (37, 29, 1, 'date_added', '2002-11-11 09:31:06', 'date', 'i');
# --------------------------------------------------------

#
# Table structure for table `xpc_props_revisions`
#

CREATE TABLE xpc_props_revisions (
id bigint(24) NOT NULL default '0',
oid bigint(24) NOT NULL default '1',
uid bigint(24) NOT NULL default '1',
name varchar(155) NOT NULL default '',
value mediumtext NOT NULL,
type enum('boolean','date','dynamic','float','int','lines','long','string','text','tokens','selection','multiple selection') NOT NULL default 'string',
sys enum('y','n','i','a') NOT NULL default 'y',
version decimal(3,1) NOT NULL default '1.0',
date timestamp(14) NOT NULL,
KEY pid(oid),
KEY id(id),
KEY uid(uid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_props_revisions`
#

# --------------------------------------------------------

#
# Table structure for table `xpc_roles`
#

CREATE TABLE xpc_roles (
id bigint(24) NOT NULL auto_increment,
oid bigint(24) NOT NULL default '1',
name char(155) NOT NULL default '',
PRIMARY KEY (id),
KEY oid(oid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_roles`
#

INSERT INTO xpc_roles VALUES (1, 1, 'anonymous');
INSERT INTO xpc_roles VALUES (2, 1, 'authenticated');
INSERT INTO xpc_roles VALUES (3, 1, 'manager');
INSERT INTO xpc_roles VALUES (4, 1, 'owner');
# --------------------------------------------------------

#
# Table structure for table `xpc_tmp`
#

CREATE TABLE xpc_tmp (
id bigint(24) NOT NULL default '0',
pid bigint(24) NOT NULL default '1',
oid bigint(24) NOT NULL default '1',
uid bigint(24) NOT NULL default '1',
name varchar(255) NOT NULL default '',
value text NOT NULL,
type varchar(155) NOT NULL default '',
object varchar(155) NOT NULL default '',
KEY pid(pid),
KEY oid(oid),
KEY id(id)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_tmp`
#

# --------------------------------------------------------

#
# Table structure for table `xpc_user_roles`
#

CREATE TABLE xpc_user_roles (
id bigint(24) NOT NULL auto_increment,
oid bigint(24) NOT NULL default '1',
rid bigint(24) NOT NULL default '1',
uid bigint(24) NOT NULL default '1',
PRIMARY KEY (id),
KEY gid(rid,uid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_user_roles`
#

INSERT INTO xpc_user_roles VALUES (1, 1, 1, 1);
INSERT INTO xpc_user_roles VALUES (2, 1, 2, 1);
INSERT INTO xpc_user_roles VALUES (3, 1, 3, 1);
INSERT INTO xpc_user_roles VALUES (4, 1, 4, 1);
# --------------------------------------------------------

#
# Table structure for table `xpc_users`
#

CREATE TABLE xpc_users (
id bigint(24) NOT NULL auto_increment,
pid bigint(24) NOT NULL default '0',
oid bigint(24) NOT NULL default '0',
name varchar(255) NOT NULL default '',
value varchar(50) NOT NULL default '',
domain varchar(150) NOT NULL default '',
email varchar(150) NOT NULL default '',
mdhash text NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
confirmed enum('y','n') NOT NULL default 'n',
PRIMARY KEY (id),
UNIQUE KEY email(email),
UNIQUE KEY name(name),
UNIQUE KEY id(id),
UNIQUE KEY domain(domain),
KEY pid(pid),
KEY oid(oid)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_users`
#

INSERT INTO xpc_users VALUES (1, 0, 5, 'admin', '%C8%F1%896', 'admin.domain.com', 'admin@domain.com', '', '2002-02-06 10:18:48', 'y');
# --------------------------------------------------------

#
# Table structure for table `xpc_versions`
#

CREATE TABLE xpc_versions (
id bigint(24) NOT NULL default '0',
pid bigint(24) NOT NULL default '1',
oid bigint(24) NOT NULL default '1',
uid bigint(24) NOT NULL default '1',
name varchar(255) NOT NULL default '',
value text NOT NULL,
type varchar(155) NOT NULL default '',
object varchar(155) NOT NULL default '',
version decimal(3,1) NOT NULL default '1.0',
date timestamp(14) NOT NULL,
KEY pid(pid),
KEY oid(oid),
KEY id(id)
) TYPE=MyISAM;

#
# Dumping data for table `xpc_versions`
#