26 Sep
2008
26 Sep
'08
12:07 p.m.
Author: cfinck
Date: Fri Sep 26 07:07:07 2008
New Revision: 36536
URL: http://svn.reactos.org/svn/reactos?rev=36536&view=rev
Log:
Commit missing stuff from the server (2/2)
This is not yet meant to work, I'm just committing unmodified files from the Web
server for making it easier to track my changes later.
Added a new "roscms" subdirectory to the "resources" directory,
installation and conversion files should go there.
This way, the "roscms" dir on the server might really become a simple SVN
checkout someday... :-)
Added:
trunk/web/reactos.org/resources/roscms/
trunk/web/reactos.org/resources/roscms/install.php
- copied unchanged from r36512, trunk/web/reactos.org/htdocs/roscms/install.php
trunk/web/reactos.org/resources/roscms/roscms.sql
- copied unchanged from r36512, trunk/web/reactos.org/sql/roscms.sql
trunk/web/reactos.org/resources/roscms/roscms_2to3_content.php
- copied unchanged from r36512,
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_content.php
trunk/web/reactos.org/resources/roscms/roscms_2to3_dyncontent.php
- copied unchanged from r36512,
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_dyncontent.php
trunk/web/reactos.org/resources/roscms/roscms_2to3_page.php
- copied unchanged from r36512,
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_page.php
trunk/web/reactos.org/resources/roscms/roscms_2to3_script.php
- copied unchanged from r36512,
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_script.php
Removed:
trunk/web/reactos.org/htdocs/roscms/install.php
trunk/web/reactos.org/htdocs/roscms/roscms.sql
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_content.php
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_dyncontent.php
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_page.php
trunk/web/reactos.org/htdocs/roscms/roscms_2to3_script.php
trunk/web/reactos.org/sql/roscms.sql
Removed: trunk/web/reactos.org/htdocs/roscms/install.php
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/inst…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/install.php [iso-8859-1] (original)
+++ trunk/web/reactos.org/htdocs/roscms/install.php (removed)
@@ -1,398 +1,0 @@
-<?php
- /* RosCMS install script */
-
- // This function was taken from the sourceStream() function of "Database.php"
of MediaWiki 1.10.0 and modified
- function import_sql_dump( $file )
- {
- $ret = TRUE;
- $fp = fopen( $file, "r" );
-
- while( !feof( $fp ) )
- {
- $line = trim( fgets( $fp, 1024 ) );
- $sl = strlen( $line ) - 1;
-
- // Skip empty and comment lines
- if( $sl < 0 || ( $line{0} == "-" && $line{1} == "-" )
)
- continue;
-
- // If this lines ends with a semicolon, it terminates the command
- if( $line{$sl} == ";" )
- {
- $done = true;
- $line = substr( $line, 0, $sl );
- }
-
- $cmd .= "$line\n";
-
- if( $done )
- {
- if( !mysql_query( $cmd ) )
- {
- $ret = FALSE;
- echo "<br />" . mysql_errno() . ": " . mysql_error();
- }
-
- $done = false;
- $cmd = "";
- }
- }
-
- fclose( $fp );
-
- if( $ret )
- echo "OK";
-
- return $ret;
- }
-
- $rpm_ready = "";
- if (array_key_exists("ready", $_GET))
$rpm_ready=htmlspecialchars($_GET["ready"]);
-?>
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
-<html>
-<head>
- <title>RosCMS v3 - Install Script</title>
- <style type="text/css">
- <!--
-
- body {
- font-family: Verdana;
- font-size: 12px;
- }
-
- hr {
- margin: 5px 0 5px 0;
- color: #8D8D8D;
- }
-
- h1 {
- font-size: 24px;
- color: #5984C3;
- font-weight: bold;
- }
-
- h2 {
- font-size: 22px;
- color: #5984C3;
- font-weight: bold;
- }
-
- h3 {
- font-size: 18px;
- color: #5984C3;
- font-weight: bold;
- }
-
- a {
- font-size: 12px;
- color: #006090;
- }
-
- a:hover {
- background-color: #DDEEFF;
- color: #000000;
- }
- -->
- </style>
-</head>
-<body>
-<?php
- if ($rpm_ready == "step2") {
-?>
- <h1>RosCMS v3 - Install Script - Step2</h1>
- <form id="form1" method="post"
action="install.php?ready=step3">
- <h3>Database Information</h3>
-
- <table>
- <tr>
- <td>Database Host Name:</td>
- <td><input name="dbHost" type="text"
id="dbHost" value="localhost" size="25"
maxlength="255" /></td>
- </tr>
- <tr>
- <td>Database User Name:</td>
- <td><input name="dbUser" type="text"
id="dbUser" value="root" size="25" maxlength="255"
/></td>
- </tr>
- <tr>
- <td>Database User Password:</td>
- <td><input name="dbPass" type="text"
id="dbPass" size="25" maxlength="255" /></td>
- </tr>
- <tr>
- <td>Database Name:</td>
- <td><input name="dbName" type="text"
id="dbName" value="roscms" size="25"
maxlength="255" /></td>
- </tr>
- </table>
-
- <h3>Server Information</h3>
- <p>Complete Server Path: <input name="path_server"
type="text" id="path_server"
value="http://localhost/domain.com/" size="50"
maxlength="255" />
- </p>
-
- <h3>RosCMS Settings</h3>
- <p>RosCMS directory :
- <input name="roscmsdir" type="text"
id="roscmsdir" value="roscms" size="20"
maxlength="50" />
- </p>
- <p>Default Language:
- <input name="lang_std" type="text"
id="lang_std" value="en" size="5" maxlength="2"
/>
- </p>
- <p>Default Language Name:
- <input name="lang_std_full" type="text"
id="lang_std_full" value="English" size="20"
maxlength="50" />
- </p>
- <p>Default Translation Language:
- <input name="lang_std_trans" type="text"
id="lang_std_trans" value="de" size="5"
maxlength="2" />
- </p>
-
- <h3>Super Administrator Account</h3>
- <p>Account-Name:
- <input name="admin_name" type="text" id="admin_name"
value="Admin" size="20" maxlength="50" />
- </p>
- <p>Fullname:
- <input name="admin_fullname" type="text"
id="admin_fullname" value="Administrator" size="20"
maxlength="50" />
-</p>
- <p>Password:
- <input name="admin_pwd" type="password"
id="admin_pwd" size="20" maxlength="50" />
- <font size="1">(6 or more characters)</font></p>
- <p>E-Mail Address:
- <input name="admin_email" type="text"
id="admin_email" value="admin(a)domain.com" size="50"
maxlength="255" />
-</p>
- <p> </p>
- <input type="submit" name="Submit" value="Install RosCMS
..." />
- </form>
-<?php
- }
- else if ($rpm_ready == "step3") {
- echo "<h1>RosCMS v3 - Install Script - Step3</h1>";
-
- $dbHost = "localhost";
- $dbUser = "root";
- $dbPass = "";
- $dbName = "roscms";
- $path_server = "";
- $path_roscms = "";
- $lang_std = "";
- $lang_std_full = "";
- $lang_std_trans = "";
- $admin_name = "";
- $admin_fullname = "";
- $admin_pwd = "";
- $admin_email = "";
-
- if (array_key_exists("dbHost", $_POST))
$dbHost=htmlspecialchars($_POST["dbHost"]);
- if (array_key_exists("dbUser", $_POST))
$dbUser=htmlspecialchars($_POST["dbUser"]);
- if (array_key_exists("dbPass", $_POST))
$dbPass=htmlspecialchars($_POST["dbPass"]);
- if (array_key_exists("dbName", $_POST))
$dbName=htmlspecialchars($_POST["dbName"]);
- if (array_key_exists("path_server", $_POST))
$path_server=htmlspecialchars($_POST["path_server"]);
- if (array_key_exists("roscmsdir", $_POST))
$path_roscms=htmlspecialchars($_POST["roscmsdir"]);
- if (array_key_exists("lang_std", $_POST))
$lang_std=htmlspecialchars($_POST["lang_std"]);
- if (array_key_exists("lang_std_full", $_POST))
$lang_std_full=htmlspecialchars($_POST["lang_std_full"]);
- if (array_key_exists("lang_std_trans", $_POST))
$lang_std_trans=htmlspecialchars($_POST["lang_std_trans"]);
- if (array_key_exists("admin_name", $_POST))
$admin_name=htmlspecialchars($_POST["admin_name"]);
- if (array_key_exists("admin_fullname", $_POST))
$admin_fullname=htmlspecialchars($_POST["admin_fullname"]);
- if (array_key_exists("admin_pwd", $_POST))
$admin_pwd=htmlspecialchars($_POST["admin_pwd"]);
- if (array_key_exists("admin_email", $_POST))
$admin_email=htmlspecialchars($_POST["admin_email"]);
-
-
- if ($path_server == "") {
- die("Invalid server-path!");
- }
-
- if ($path_roscms == "" || $lang_std == "" || $lang_std_full ==
"" || lang_std_trans == "") {
- die("Invalid RosCMS config settings!");
- }
-
- if ($admin_name == "" || $admin_pwd == "" || $admin_email ==
"") {
- die("Invalid account settings!");
- }
-
-
- echo "Connecting to the MySQL Server... ";
- $connect = mysql_connect($dbHost, $dbUser, $dbPass) or die("Cannot connect to the
MySQL Server!");
- echo "OK<br />";
-
- echo "Creating the Database... ";
- mysql_query("CREATE DATABASE `". mysql_real_escape_string($dbName)
."`") or die( mysql_errno() . ": " . mysql_error() );
- echo "OK<br />";
-
- echo "Selecting the Database... ";
- mysql_select_db($dbName, $connect) or die("Cannot find and select
<b>".$dbName."</b>!");
- echo "OK<br />";
-
- echo "Importing the SQL Data... ";
- if( !import_sql_dump( "roscms.sql" ) ) {
- die("Error: import not successfull!");
- }
- echo "<br />";
-
- echo "Adding first account... ";
- $insert_account = mysql_query("INSERT INTO `users` ( `user_id` , `user_name` ,
`user_roscms_password` , `user_roscms_getpwd_id` , `user_timestamp_touch` ,
`user_timestamp_touch2` , `user_login_counter` , `user_account_enabled` ,
`user_account_hidden` , `user_register` , `user_fullname` , `user_email` , `user_website`
, `user_language` , `user_country` , `user_timezone` , `user_occupation` ,
`user_description` , `user_setting_multisession` , `user_setting_browseragent` ,
`user_setting_ipaddress` , `user_setting_timeout` )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($admin_name)."',
- MD5( '".mysql_real_escape_string($admin_pwd)."' ) ,
- '',
- '',
- NOW( ) ,
- '0',
- 'yes',
- 'no',
- NOW( ) ,
- '".mysql_real_escape_string($admin_fullname)."',
- '".mysql_real_escape_string($admin_email)."',
- '".mysql_real_escape_string($path_server)."',
- '".mysql_real_escape_string($lang_std)."',
- '',
- '',
- '',
- '',
- 'true',
- 'true',
- 'true',
- 'true'
- );") or die("Cannot insert first account!");
- echo "OK<br />";
-
- echo "Adding account memberships... ";
- $insert_membership = mysql_query("INSERT INTO `usergroup_members` (
`usergroupmember_userid` , `usergroupmember_usergroupid` )
- VALUES (
- '1',
- 'user'
- ),
- (
- '1',
- 'ros_sadmin'
- );") or die("Cannot insert account memberships!");
- echo "OK<br />";
-
-
- // RosCMS settings
- echo "Creating roscms config file... ";
- $fp = fopen("custom.php", "w");
- flock($fp,2);
- fputs($fp, '<?php
-
- /*
- RosCMS - ReactOS Content Management System
- Copyright (C) 2007 Klemens Friedl <frik85(a)reactos.org>
-
- This program is free software; you can redistribute it and/or modify
- it under the terms of the GNU General Public License as published by
- the Free Software Foundation; either version 2 of the License, or
- (at your option) any later version.
-
- This program is distributed in the hope that it will be useful,
- but WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- GNU General Public License for more details.
-
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
- */
-
-
- global $rpm_page;
-
- $roscms_extern_brand = "RosCMS";
- $roscms_extern_version = "v3";
- $roscms_extern_version_detail = "v3.0731";
-
- $roscms_intern_webserver_pages = "'.$path_server.'";
-
- $roscms_intern_roscms_dir = "'.$path_roscms.'";
- $roscms_intern_webserver_roscms =
"'.$path_server.'".$roscms_intern_roscms_dir."/";
- $roscms_intern_page_link = $roscms_intern_webserver_roscms . "?page=";
- $roscms_intern_script_name = $roscms_intern_page_link . $rpm_page;
-
- $roscms_intern_script_branch = $roscms_intern_script_name. "&branch=";
-
- $roscms_standard_language="'.$lang_std.'"; // en/de/fr/...
- $roscms_standard_language_full="'.$lang_std_full.'"; //
English/German/...
- $roscms_standard_language_trans="'.$lang_std_trans.'"; //
en/de/fr/...');
-
- fputs($fp, "\n ?>");
- flock($fp, 3);
- fclose($fp);
- echo "OK<br />";
-
- // RosCMS database login config
- echo "Creating roscms database config file... ";
- $fp = fopen("connect.db.php", "w");
- flock($fp,2);
- fputs($fp, '<?php
- /*
- RosCMS - ReactOS Content Management System
- Copyright (C) 2005-2007 Klemens Friedl <frik85(a)reactos.org>
-
- This program is free software; you can redistribute it and/or modify
- it under the terms of the GNU General Public License as published by
- the Free Software Foundation; either version 2 of the License, or
- (at your option) any later version.
-
- This program is distributed in the hope that it will be useful,
- but WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- GNU General Public License for more details.
-
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
- */
-
-
- // Database:
- $dbHost = "'.$dbHost.'";
- $dbUser = "'.$dbUser.'";
- $dbPass = "'.$dbPass.'";
- $dbName = "'.$dbName.'";
- $roscms_database = $dbName;
-
- $connect = @mysql_connect($dbHost, $dbUser, $dbPass) or die("ERROR: Cannot
connect to the database!");
- $selectDB = @mysql_select_db($dbName, $connect) or die("Cannot find and select
<b>".$dbName."</b>!");
-
- // Delete (set nothing) the vars after usage:
- $dbHost = "";
- $dbUser = "";
- $dbPass = "";
- $dbName = "";');
-
- fputs($fp, "\n ?>");
- flock($fp, 3);
- fclose($fp);
- echo "OK<br />";
-
-
- echo "<p> </p>";
- echo "<p><b>RosCMS was set up
successfully!</b></p>";
-
- echo "<p> </p>";
- echo "<p>Delete this \"install.php\" file on the server and <a
href=\"index.php?page=login\">then login into RosCMS</a> with your
account.</p>";
-
- }
- else {
-?>
- <h1>RosCMS v3 - Install Script - Step1</h1>
- <p><i>© Klemens Friedl 2005-2007, GNU GPL 2
license</i></p>
- <p> </p>
-<?php
- if (get_magic_quotes_gpc()) {
- die("<p>ERROR: Disable 'magic quotes' in php.ini
(=Off)</p>");
- }
-
- $phpver = explode('-', phpversion());
- $phpver = $phpver[0];
-
- if (substr($phpver, 0, 1) <= 3) {
- die("<p>ERROR: RosCMS v3 don't work with versions prior to PHP
4!</p>");
- }
- else if (substr($phpver, 0, 1) == 4) {
- echo "<p>RosCMS v3 should work fine with PHP 4, make sure you use an
up-to-date PHP 4 version. If possible and reasonable, upgrade to PHP 5 or
later.</p>";
- }
-?>
- <p>Your PHP installation is configured correctly. RosCMS has been tested with
MySQL 4 and 5. </p>
- <p>Click <i>Next</i> to continue!</p>
-
- <p><a href="install.php?ready=step2"><b>Next
></b></a></p>
-<?php
- }
-?>
-</body>
-</html>
Removed: trunk/web/reactos.org/htdocs/roscms/roscms.sql
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/rosc…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/roscms.sql [iso-8859-1] (original)
+++ trunk/web/reactos.org/htdocs/roscms/roscms.sql (removed)
@@ -1,486 +1,0 @@
--- Database: `roscms`
---
--- Date: 2007-08-13 11:12
--- MySQL-Version: 5.0.33
--- PHP-Version: 5.2.1
---
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_`
---
-
-CREATE TABLE `data_` (
- `data_id` int(11) NOT NULL auto_increment,
- `data_name` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'together with
page_type unique entries',
- `data_type` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT '"page",
"layout", "content", "script"',
- `data_acl` varchar(50) collate utf8_unicode_ci NOT NULL default 'default',
- PRIMARY KEY (`data_id`),
- KEY `data_name` (`data_name`,`data_type`),
- KEY `data_type` (`data_type`),
- KEY `data_acl` (`data_acl`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1
"pages", "content", "dyncontent" and
"inctext"';
-
-INSERT INTO `data_` VALUES (1, 'index', 'page', 'defaultpage');
-INSERT INTO `data_` VALUES (2, 'default', 'template', 'layout');
-INSERT INTO `data_` VALUES (3, 'index', 'content', 'default');
-INSERT INTO `data_` VALUES (4, 'news', 'script', 'script');
-INSERT INTO `data_` VALUES (5, 'news_page', 'content',
'default');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_a`
---
-
-CREATE TABLE `data_a` (
- `data_id` int(11) NOT NULL auto_increment,
- `data_name` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'together with
page_type unique entries',
- `data_type` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT '"page",
"layout", "content", "script"',
- `data_acl` varchar(50) collate utf8_unicode_ci NOT NULL default 'default',
- PRIMARY KEY (`data_id`),
- KEY `data_name` (`data_name`,`data_type`),
- KEY `data_type` (`data_type`),
- KEY `data_acl` (`data_acl`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1
"pages", "content", "dyncontent" and
"inctext"';
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_revision`
---
-
-CREATE TABLE `data_revision` (
- `rev_id` int(11) NOT NULL auto_increment COMMENT 'unique revisions id',
- `data_id` int(11) NOT NULL,
- `rev_version` int(11) NOT NULL COMMENT 'version number increase with every entry
change',
- `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT 'language code
("en", "de", etc.)',
- `rev_usrid` int(11) NOT NULL COMMENT 'user id who saved the entry',
- `rev_datetime` datetime NOT NULL,
- `rev_date` date NOT NULL,
- `rev_time` time NOT NULL,
- PRIMARY KEY (`rev_id`),
- KEY `data_id` (`data_id`),
- KEY `rev_language` (`rev_language`),
- KEY `rev_version` (`rev_version`),
- KEY `rev_datetime` (`rev_datetime`),
- KEY `rev_usrid` (`rev_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_revision` VALUES (1, 1, 1, 'en', 1, '2007-08-13
17:03:44', '2007-08-13', '17:03:44');
-INSERT INTO `data_revision` VALUES (2, 2, 1, 'en', 1, '2007-08-13
17:05:03', '2007-08-13', '17:05:03');
-INSERT INTO `data_revision` VALUES (6, 3, 2, 'en', 1, '2007-08-13
17:15:15', '2007-08-13', '17:15:15');
-INSERT INTO `data_revision` VALUES (5, 4, 2, 'en', 1, '2007-08-13
17:11:36', '2007-08-13', '17:11:36');
-INSERT INTO `data_revision` VALUES (7, 5, 1, 'en', 1, '2007-08-13
17:15:20', '2007-08-13', '17:15:20');
-INSERT INTO `data_revision` VALUES (8, 5, 1, 'en', 1, '2007-08-13
17:15:45', '2007-08-13', '17:15:45');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_revision_a`
---
-
-CREATE TABLE `data_revision_a` (
- `rev_id` int(11) NOT NULL auto_increment COMMENT 'unique revisions id',
- `data_id` int(11) NOT NULL,
- `rev_version` int(11) NOT NULL COMMENT 'version number increase with every entry
change',
- `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT 'language code
("en", "de", etc.)',
- `rev_usrid` int(11) NOT NULL COMMENT 'user id who saved the entry',
- `rev_datetime` datetime NOT NULL,
- `rev_date` date NOT NULL,
- `rev_time` time NOT NULL,
- PRIMARY KEY (`rev_id`),
- KEY `data_id` (`data_id`),
- KEY `rev_language` (`rev_language`),
- KEY `rev_version` (`rev_version`),
- KEY `rev_datetime` (`rev_datetime`),
- KEY `rev_usrid` (`rev_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_security`
---
-
-CREATE TABLE `data_security` (
- `sec_name` varchar(50) collate utf8_unicode_ci NOT NULL,
- `sec_fullname` varchar(100) collate utf8_unicode_ci NOT NULL,
- `sec_description` varchar(255) collate utf8_unicode_ci NOT NULL,
- `sec_branch` varchar(10) collate utf8_unicode_ci NOT NULL,
- `sec_lev1_read` tinyint(4) NOT NULL default '0',
- `sec_lev1_write` tinyint(4) NOT NULL default '0',
- `sec_lev1_add` tinyint(4) NOT NULL default '0',
- `sec_lev1_pub` tinyint(4) NOT NULL default '0',
- `sec_lev1_trans` tinyint(4) NOT NULL default '0',
- `sec_lev2_read` tinyint(4) NOT NULL default '0',
- `sec_lev2_write` tinyint(4) NOT NULL default '0',
- `sec_lev2_add` tinyint(4) NOT NULL default '0',
- `sec_lev2_pub` tinyint(4) NOT NULL default '0',
- `sec_lev2_trans` tinyint(4) NOT NULL default '0',
- `sec_lev3_read` tinyint(4) NOT NULL default '0',
- `sec_lev3_write` tinyint(4) NOT NULL default '0',
- `sec_lev3_add` tinyint(4) NOT NULL default '0',
- `sec_lev3_pub` tinyint(4) NOT NULL default '0',
- `sec_lev3_trans` tinyint(4) NOT NULL default '0',
- `sec_allow` varchar(255) collate utf8_unicode_ci NOT NULL,
- `sec_deny` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`sec_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS content
security';
-
-INSERT INTO `data_security` VALUES ('default', 'Content (default)',
'Default content security ACL; normal translator cannot publish nor add new
content', 'website', 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '',
'');
-INSERT INTO `data_security` VALUES ('script', 'Script or Variable',
'Entry contain scripts, variables or similar content which can only be accessed and
altered by admins.', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0,
'', '');
-INSERT INTO `data_security` VALUES ('layout', 'Layout', 'Website
layout related content, changing may destroy the website layout, so be careful!',
'website', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, '',
'|transmaint|');
-INSERT INTO `data_security` VALUES ('announcement', 'Official
announcement', 'Official announcement, which shouldn''t be altered by
anyone except admins and devs', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,
1, 1, 1, '|developer|', '');
-INSERT INTO `data_security` VALUES ('notrans', 'No translation needed',
'Content don''t need a translation.', '', 1, 0, 0, 0, 0, 1, 1, 1,
1, 0, 1, 1, 1, 1, 1, '', '');
-INSERT INTO `data_security` VALUES ('rosversion', 'ReactOS versions
number', 'Currrent ReactOS version number, change the related contents on every
release day!', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0,
'|developer|', '');
-INSERT INTO `data_security` VALUES ('defaultpage', 'Page (default)',
'Default page security ACL', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,
1, 1, 1, 1, '|developer|', '');
-INSERT INTO `data_security` VALUES ('defaultmenu', 'Menu (default)',
'Menu content which can be translated by language maintainers', 'website',
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '|transmaint|', '');
-INSERT INTO `data_security` VALUES ('system', 'System', 'RosCMS
system', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
'|ros_sadmin|', '');
-INSERT INTO `data_security` VALUES ('readonly', 'Read-Only', 'Read
only, noone can alter this', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0,
0, 0, '', '');
-INSERT INTO `data_security` VALUES ('langmaint', 'Language Maintainer',
'Language-Group related content', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
1, 1, 1, 1, 1, '|transmaint|', '');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_stext`
---
-
-CREATE TABLE `data_stext` (
- `stext_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`stext_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `stext_content` (`stext_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_stext` VALUES (14, 1, 'description', 'test page');
-INSERT INTO `data_stext` VALUES (13, 1, 'comment', '');
-INSERT INTO `data_stext` VALUES (12, 2, 'description', 'test template');
-INSERT INTO `data_stext` VALUES (15, 1, 'title', 'Index');
-INSERT INTO `data_stext` VALUES (19, 6, 'description', 'test content');
-INSERT INTO `data_stext` VALUES (18, 5, 'description', 'news php
script');
-INSERT INTO `data_stext` VALUES (22, 7, 'description', 'news issue 1');
-INSERT INTO `data_stext` VALUES (23, 7, 'title', 'News_page');
-INSERT INTO `data_stext` VALUES (26, 8, 'description', 'news issue 2');
-INSERT INTO `data_stext` VALUES (27, 8, 'title', 'News_page');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_stext_a`
---
-
-CREATE TABLE `data_stext_a` (
- `stext_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`stext_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `stext_content` (`stext_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag`
---
-
-CREATE TABLE `data_tag` (
- `tag_id` int(11) NOT NULL auto_increment,
- `data_id` int(11) NOT NULL,
- `data_rev_id` int(11) NOT NULL,
- `tag_name_id` int(11) NOT NULL,
- `tag_value_id` int(11) NOT NULL,
- `tag_usrid` int(11) NOT NULL,
- PRIMARY KEY (`tag_id`),
- KEY `data_id` (`data_id`),
- KEY `data_rev_id` (`data_rev_id`),
- KEY `tag_name_id` (`tag_name_id`),
- KEY `tag_value_id` (`tag_value_id`),
- KEY `tag_usrid` (`tag_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_tag` VALUES (11, 1, 1, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (2, 1, 1, 2, 2, -1);
-INSERT INTO `data_tag` VALUES (10, 2, 2, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (15, 4, 5, 5, 7, -1);
-INSERT INTO `data_tag` VALUES (14, 4, 5, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (24, 3, 6, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (22, 5, 7, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (18, 5, 7, 6, 9, -1);
-INSERT INTO `data_tag` VALUES (21, 5, 8, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (20, 5, 8, 6, 10, -1);
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_a`
---
-
-CREATE TABLE `data_tag_a` (
- `tag_id` int(11) NOT NULL auto_increment,
- `data_id` int(11) NOT NULL,
- `data_rev_id` int(11) NOT NULL,
- `tag_name_id` int(11) NOT NULL,
- `tag_value_id` int(11) NOT NULL,
- `tag_usrid` int(11) NOT NULL,
- PRIMARY KEY (`tag_id`),
- KEY `data_id` (`data_id`),
- KEY `data_rev_id` (`data_rev_id`),
- KEY `tag_name_id` (`tag_name_id`),
- KEY `tag_value_id` (`tag_value_id`),
- KEY `tag_usrid` (`tag_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_name`
---
-
-CREATE TABLE `data_tag_name` (
- `tn_id` int(11) NOT NULL auto_increment,
- `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tn_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_tag_name` VALUES (1, 'status');
-INSERT INTO `data_tag_name` VALUES (2, 'extension');
-INSERT INTO `data_tag_name` VALUES (4, 'star');
-INSERT INTO `data_tag_name` VALUES (5, 'kind');
-INSERT INTO `data_tag_name` VALUES (6, 'number');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_name_a`
---
-
-CREATE TABLE `data_tag_name_a` (
- `tn_id` int(11) NOT NULL auto_increment,
- `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tn_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_value`
---
-
-CREATE TABLE `data_tag_value` (
- `tv_id` int(11) NOT NULL auto_increment,
- `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tv_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_tag_value` VALUES (7, 'php');
-INSERT INTO `data_tag_value` VALUES (2, 'html');
-INSERT INTO `data_tag_value` VALUES (4, 'off');
-INSERT INTO `data_tag_value` VALUES (5, 'stable');
-INSERT INTO `data_tag_value` VALUES (9, '1');
-INSERT INTO `data_tag_value` VALUES (10, '2');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_value_a`
---
-
-CREATE TABLE `data_tag_value_a` (
- `tv_id` int(11) NOT NULL auto_increment,
- `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tv_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_text`
---
-
-CREATE TABLE `data_text` (
- `text_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `text_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `text_content` text collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`text_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `text_content` (`text_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_text` VALUES (9, 1, 'content', '[#templ_default]');
-INSERT INTO `data_text` VALUES (8, 2, 'content',
'[#cont_head][#cont_menu_top][#cont_menu_side][#cont_contmenu_[#%NAME%]][#cont_menu_search][#cont_menu_language][#cont_menu_misc][#cont_%NAME%][#cont_bottom]');
-INSERT INTO `data_text` VALUES (13, 6, 'content', '<h1>Welcome to
RosCMS v3</h1><p>RosCMS test page</p>[#inc_news]');
-INSERT INTO `data_text` VALUES (15, 7, 'content', 'news #1 ...');
-INSERT INTO `data_text` VALUES (17, 8, 'content', 'news #2');
-INSERT INTO `data_text` VALUES (12, 5, 'content', '<h3>News</h3>
<?php $tmp_year = "2085"; $query_content = mysql_query("SELECT
d.data_name, r.rev_usrid, s1.stext_content AS ''title'', s2.stext_content
AS ''description'', v.tv_value as ''numb'', r.rev_date
FROM data_ d, data_revision r, data_stext s1, data_stext s2, data_tag a, data_tag_name n,
data_tag_value v WHERE d.data_name = ''news_page'' AND d.data_type =
''content'' AND r.data_id = d.data_id AND (r.rev_language =
''".mysql_real_escape_string($roscms_template_var_lang)."'' OR
r.rev_language = ''en'') AND r.rev_version > 0 AND s1.data_rev_id =
r.rev_id AND s1.stext_name = ''title'' AND s2.data_rev_id = r.rev_id
AND s2.stext_name = ''description'' AND r.data_id = a.data_id AND
r.rev_id = a.data_rev_id AND a.tag_usrid = ''-1'' AND a.tag_name_id =
n.tn_id AND n.tn_name = ''number'' AND a.tag_value_id = v.tv_id ORDER
BY r.rev_datetime DESC LIMIT 3;"); while($result_content =
mysql_fetch_array($query_content)) {
-if ($tmp_year > substr($result_content[''rev_date''], 0, 4)) {
$tmp_year = substr($result_content[''rev_date''], 0, 4); echo
"<h3>".$tmp_year."</h3>"; } $query_usraccount=
mysql_query("SELECT user_name, user_fullname FROM users WHERE user_id =
''".mysql_real_escape_string($result_content["rev_usrid"])."''
LIMIT 1;"); $result_usraccount=mysql_fetch_array($query_usraccount); ?> <p
align="left"><b><font color="#666666"><?php echo
$result_content[''rev_date'']; ?>, <?php if
($result_usraccount[''user_fullname'']) { echo
$result_usraccount[''user_fullname'']; } else { echo
$result_usraccount[''user_name'']; } ?>
</font></b><br /> <b><a href="<?php echo
"[#link_".$result_content["data_name"]."_".$result_content["numb"]."]";
?>"><?php echo $result_content["title"];
?></a></b><br /> <?php echo
$result_content["description"]; ?></p> <?php } // end while ?>
');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_text_a`
---
-
-CREATE TABLE `data_text_a` (
- `text_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `text_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `text_content` text collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`text_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `text_content` (`text_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_user_filter`
---
-
-CREATE TABLE `data_user_filter` (
- `filt_id` int(11) NOT NULL auto_increment,
- `filt_usrid` int(11) NOT NULL,
- `filt_title` varchar(50) collate utf8_unicode_ci NOT NULL,
- `filt_type` smallint(6) NOT NULL default '1',
- `filt_string` varchar(255) collate utf8_unicode_ci NOT NULL,
- `filt_datetime` datetime NOT NULL,
- `filt_usage` int(11) NOT NULL,
- `filt_usagedate` datetime NOT NULL,
- PRIMARY KEY (`filt_id`),
- KEY `filt_usrid` (`filt_usrid`),
- KEY `filt_name` (`filt_title`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `languages`
---
-
-CREATE TABLE `languages` (
- `lang_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
- `lang_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
- `lang_name_org` varchar(100) collate utf8_unicode_ci NOT NULL,
- `lang_level` int(11) NOT NULL default '0',
- PRIMARY KEY (`lang_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='available
languages';
-
-INSERT INTO `languages` VALUES ('en', 'English', 'English', 10);
-INSERT INTO `languages` VALUES ('de', 'German', 'Deutsch', 8);
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `subsys_mappings`
---
-
-CREATE TABLE `subsys_mappings` (
- `map_roscms_userid` bigint(20) NOT NULL default '0',
- `map_subsys_name` varchar(10) character set utf8 NOT NULL default '',
- `map_subsys_userid` int(7) NOT NULL default '0',
- PRIMARY KEY (`map_roscms_userid`,`map_subsys_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `user_sessions`
---
-
-CREATE TABLE `user_sessions` (
- `usersession_id` varchar(32) character set utf8 NOT NULL default '' COMMENT
'Unique ID of this session',
- `usersession_user_id` bigint(20) NOT NULL default '0' COMMENT 'User this
session belongs to',
- `usersession_expires` datetime default NULL COMMENT 'Expiry date/time (NULL if does
not expire)',
- `usersession_browseragent` varchar(255) character set utf8 NOT NULL default ''
COMMENT 'HTTP_USER_AGENT when this session was created',
- `usersession_ipaddress` varchar(15) character set utf8 NOT NULL default ''
COMMENT 'IP address from which this session was created',
- `usersession_created` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT
'session created (date/time) - all session will get deleted ... by date',
- PRIMARY KEY (`usersession_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0
COMMENT='Sessions';
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `usergroup_members`
---
-
-CREATE TABLE `usergroup_members` (
- `usergroupmember_userid` bigint(20) NOT NULL default '0',
- `usergroupmember_usergroupid` varchar(10) collate utf8_unicode_ci NOT NULL default
'user'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `usergroups`
---
-
-CREATE TABLE `usergroups` (
- `usrgroup_name_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
- `usrgroup_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
- `usrgroup_intern_id` varchar(25) collate utf8_unicode_ci NOT NULL default '',
- `usrgroup_seclev` tinyint(4) NOT NULL default '0',
- `usrgroup_securitylevel` tinyint(4) NOT NULL default '0',
- `usrgroup_description` varchar(255) collate utf8_unicode_ci NOT NULL default
'',
- PRIMARY KEY (`usrgroup_name_id`),
- UNIQUE KEY `usrgroup_name` (`usrgroup_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `usergroups` VALUES ('ros_admin', 'Administrator',
'roscms_usrgrp_admin', 3, 70, 'Administrator-Group');
-INSERT INTO `usergroups` VALUES ('user', 'User',
'roscms_usrgrp_user', 0, 0, 'Normal Visitors');
-INSERT INTO `usergroups` VALUES ('developer', 'Developer',
'roscms_usrgrp_dev', 2, 50, 'Developer');
-INSERT INTO `usergroups` VALUES ('moderator', 'Moderator',
'roscms_usrgrp_team', 2, 20, 'Website Moderators');
-INSERT INTO `usergroups` VALUES ('translator', 'Translator',
'roscms_usrgrp_trans', 1, 10, 'Translators');
-INSERT INTO `usergroups` VALUES ('ros_sadmin', 'Super-Administrator',
'roscms_usrgrp_sadmin', 3, 100, 'Super-Administrator-Group');
-INSERT INTO `usergroups` VALUES ('transmaint', 'Tranlation Maintainer',
'roscms_usrgrp_trans', 2, 15, 'Translation Maintainer');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `users`
---
-
-CREATE TABLE `users` (
- `user_id` bigint(20) NOT NULL auto_increment,
- `user_name` varchar(20) collate utf8_unicode_ci NOT NULL default '',
- `user_roscms_password` varchar(32) collate utf8_unicode_ci NOT NULL default
'',
- `user_roscms_getpwd_id` varchar(50) collate utf8_unicode_ci NOT NULL default
'',
- `user_timestamp_touch` varchar(50) collate utf8_unicode_ci NOT NULL default
'',
- `user_timestamp_touch2` timestamp NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
- `user_login_counter` bigint(20) NOT NULL default '0',
- `user_account_enabled` varchar(10) collate utf8_unicode_ci NOT NULL default
'no',
- `user_account_hidden` varchar(5) collate utf8_unicode_ci NOT NULL default
'no',
- `user_register` timestamp NULL default NULL,
- `user_fullname` varchar(100) collate utf8_unicode_ci NOT NULL default '',
- `user_email` varchar(150) collate utf8_unicode_ci NOT NULL default '',
- `user_website` varchar(150) collate utf8_unicode_ci NOT NULL default '',
- `user_language` varchar(2) collate utf8_unicode_ci NOT NULL default '',
- `user_country` varchar(2) collate utf8_unicode_ci NOT NULL default '',
- `user_timezone` varchar(3) collate utf8_unicode_ci NOT NULL default '',
- `user_occupation` varchar(50) collate utf8_unicode_ci NOT NULL default '',
- `user_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
- `user_setting_multisession` varchar(5) collate utf8_unicode_ci NOT NULL default
'false',
- `user_setting_browseragent` varchar(5) collate utf8_unicode_ci NOT NULL default
'true',
- `user_setting_ipaddress` varchar(5) collate utf8_unicode_ci NOT NULL default
'true',
- `user_setting_timeout` varchar(5) collate utf8_unicode_ci NOT NULL default
'true',
- PRIMARY KEY (`user_id`),
- UNIQUE KEY `user_name` (`user_name`),
- UNIQUE KEY `user_email` (`user_email`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User
Table';
-
Removed: trunk/web/reactos.org/htdocs/roscms/roscms_2to3_content.php
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/rosc…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/roscms_2to3_content.php [iso-8859-1] (original)
+++ trunk/web/reactos.org/htdocs/roscms/roscms_2to3_content.php (removed)
@@ -1,143 +1,0 @@
-<?php
-
- error_reporting(E_ALL);
- ini_set('error_reporting', E_ALL);
-
- if (get_magic_quotes_gpc()) {
- die("ERROR: Disable 'magic quotes' in php.ini (=Off)");
- }
-
- if ( !defined('ROSCMS_SYSTEM') ) {
- define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking
activity
- }
-
-
- require("connect.db.php");
- require("inc/data_edit.php");
-
-
- echo "<h1>RosCMS Database Update - v2 to v3 - Content</h1>";
-
- set_time_limit(0); // unlimited script run time
-
-
- echo "<h3>Contents</h3>";
- echo "<ul>";
- $query_i_content = mysql_query("SELECT *
- FROM content
- WHERE content_active = 1
- AND content_lang != 'xhtml'
- ORDER BY content_lang ASC, content_name ASC, content_version DESC,
content_active DESC;");
- while ($result_i_content = mysql_fetch_array($query_i_content)) {
- $roscms_i_lang = $result_i_content['content_lang'];
- if ($roscms_i_lang == "all") {
- $roscms_i_lang = "en";
- }
- if ($roscms_i_lang == "html") {
- $roscms_i_lang = "en";
- }
-
- echo "<li>".$result_i_content['content_name']."
(".$result_i_content['content_lang'].")</li>";
-
- $query_import_content = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_content['content_name'])."'
- AND data_type = 'content'
- LIMIT 1;");
- $result_import_content = mysql_fetch_array($query_import_content);
-
-
- if ($result_import_content['data_id'] == "") {
- $insert_page = mysql_query("INSERT INTO `data_` ( `data_id` , `data_name` ,
`data_type` , `data_acl`)
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_i_content['content_name'])."',
- 'content',
- 'default'
- );");
- }
-
- $query_import_content3 = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_content['content_name'])."'
- AND data_type = 'content'
- ORDER BY data_id DESC
- LIMIT 1;");
- $result_import_content3 = mysql_fetch_array($query_import_content3);
-
- $query_import_content2 = mysql_query("SELECT COUNT(*)
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_content3['data_id'])."'
- AND rev_language =
'".mysql_real_escape_string($roscms_i_lang)."'
- LIMIT 1;");
- $result_import_content2 = mysql_fetch_row($query_import_content2);
-
- if ($result_import_content2[0] <= 0) {
- echo "<h6>lang:
".$result_i_content['content_lang']."</h6>";
- // revision entry doesn't exist
- $insert_content_rev = mysql_query("INSERT INTO data_revision ( rev_id , data_id ,
rev_version , rev_language , rev_usrid , rev_datetime , rev_date , rev_time )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_content3['data_id'])."',
- '".mysql_real_escape_string($result_i_content['content_version'])."',
- '".mysql_real_escape_string($roscms_i_lang)."',
- '".mysql_real_escape_string($result_i_content['content_usrname_id'])."',
- '".mysql_real_escape_string($result_i_content['content_date']."
".$result_i_content['content_time'])."',
- '".mysql_real_escape_string($result_i_content['content_date'])."',
- '".mysql_real_escape_string($result_i_content['content_time'])."'
- );");
-
-
- $query_import_content4 = mysql_query("SELECT rev_id
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_content3['data_id'])."'
- AND rev_language =
'".mysql_real_escape_string($roscms_i_lang)."'
- ORDER BY rev_id DESC
- LIMIT 1;");
- $result_import_content4 = mysql_fetch_array($query_import_content4);
-
- if ($result_import_content4['rev_id'] != "") {
-
- // stext: titel, description, extention, (property)
- $insert_import_content_stext = mysql_query("INSERT INTO data_stext ( stext_id ,
data_rev_id , stext_name , stext_content )
- VALUES
- (
- NULL ,
- '".mysql_real_escape_string($result_import_content4['rev_id'])."',
- 'description',
- '".mysql_real_escape_string($result_i_content['content_name'])."'
- );");
-
- // text: content
- $insert_import_content_text = mysql_query("INSERT INTO data_text ( text_id ,
data_rev_id , text_name , text_content )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_content4['rev_id'])."',
- 'content',
- '".mysql_real_escape_string($result_i_content['content_text'])."'
- );");
-
- // tag: status = stable
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "status", "stable",
"-1");
-
- // tag: visible = all
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "visible", "all",
"-1");
-
- // tag: kind = default
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "kind", "default",
"-1");
- }
- }
- }
- echo "</ul>";
-
-
- echo "\n<hr />\n";
-
-
-
-
-
- echo "\n<hr />\n";
-
-
-?>
Removed: trunk/web/reactos.org/htdocs/roscms/roscms_2to3_dyncontent.php
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/rosc…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/roscms_2to3_dyncontent.php [iso-8859-1]
(original)
+++ trunk/web/reactos.org/htdocs/roscms/roscms_2to3_dyncontent.php (removed)
@@ -1,139 +1,0 @@
-<?php
-
- error_reporting(E_ALL);
- ini_set('error_reporting', E_ALL);
-
- if (get_magic_quotes_gpc()) {
- die("ERROR: Disable 'magic quotes' in php.ini (=Off)");
- }
-
- if ( !defined('ROSCMS_SYSTEM') ) {
- define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking
activity
- }
-
-
- require("connect.db.php");
- require("inc/data_edit.php");
-
-
- echo "<h1>RosCMS Database Update - v2 to v3 - DynContent</h1>";
-
- set_time_limit(0); // unlimited script run time
-
- echo "<h3>Dynamic Contents</h3>";
- echo "<ul>";
- $query_i_content = mysql_query("SELECT *
- FROM dyn_content
- WHERE dyn_content_active = 1
- AND dyn_content_nr = 1
- AND dyn_content_lang = 'all'
- ORDER BY dyn_content_lang ASC, dyn_content_name ASC, dyn_content_id
ASC;");
- while ($result_i_content = mysql_fetch_array($query_i_content)) {
- $roscms_i_lang = $result_i_content['dyn_content_lang'];
- if ($roscms_i_lang == "all") {
- $roscms_i_lang = "en";
- }
-
- echo
"<li>".$result_i_content['dyn_content_name']."_".$result_i_content['dyn_content_id']."
(".$result_i_content['dyn_content_lang'].")</li>";
-
- $query_import_content = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_content['dyn_content_name'])."'
- AND data_type = 'content'
- LIMIT 1;");
- $result_import_content = mysql_fetch_array($query_import_content);
-
-
- if ($result_import_content['data_id'] == "") {
- $insert_page = mysql_query("INSERT INTO `data_` ( `data_id` , `data_name` ,
`data_type` , `data_acl` )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_i_content['dyn_content_name'])."',
- 'content',
- 'default'
- );");
- }
-
- $query_import_content3 = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_content['dyn_content_name'])."'
- AND data_type = 'content'
- ORDER BY data_id DESC
- LIMIT 1;");
- $result_import_content3 = mysql_fetch_array($query_import_content3);
-
-
- // revision entry doesn't exist
- $insert_content_rev = mysql_query("INSERT INTO data_revision ( rev_id , data_id ,
rev_version , rev_language , rev_usrid , rev_datetime , rev_date , rev_time )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_content3['data_id'])."',
- '1',
- '".mysql_real_escape_string($roscms_i_lang)."',
- '".mysql_real_escape_string($result_i_content['dyn_content_usrname_id'])."',
- '".mysql_real_escape_string($result_i_content['dyn_content_date']."
".$result_i_content['dyn_content_time'])."',
- '".mysql_real_escape_string($result_i_content['dyn_content_date'])."',
- '".mysql_real_escape_string($result_i_content['dyn_content_time'])."'
- );");
- echo "<li> =>
".$result_i_content['dyn_content_name']."_".$result_i_content['dyn_content_id']."
(".$result_i_content['dyn_content_text1'].")</li>";
-
-
- $query_import_content4 = mysql_query("SELECT rev_id
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_content3['data_id'])."'
- AND rev_language =
'".mysql_real_escape_string($roscms_i_lang)."'
- ORDER BY rev_id DESC
- LIMIT 1;");
- $result_import_content4 = mysql_fetch_array($query_import_content4);
-
- if ($result_import_content4['rev_id'] != "") {
-
- // stext: titel, description, extention, (property)
- $insert_import_content_stext = mysql_query("INSERT INTO data_stext ( stext_id ,
data_rev_id , stext_name , stext_content )
- VALUES
- (
- NULL ,
- '".mysql_real_escape_string($result_import_content4['rev_id'])."',
- 'description',
- '".mysql_real_escape_string($result_i_content['dyn_content_text3'])."'
- ),
- (
- NULL ,
- '".mysql_real_escape_string($result_import_content4['rev_id'])."',
- 'title',
- '".mysql_real_escape_string($result_i_content['dyn_content_text1'])."'
- );");
-
- // text: content
- $insert_import_content_text = mysql_query("INSERT INTO data_text ( text_id ,
data_rev_id , text_name , text_content )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_content4['rev_id'])."',
- 'content',
- '".mysql_real_escape_string($result_i_content['dyn_content_text4'])."'
- );");
-
- // tag: status = stable
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "status", "stable",
"-1");
-
- // tag: visible = all
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "visible", "all",
"-1");
-
- // tag: kind = dynamic
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "kind", "dynamic",
"-1");
-
- // tag: number = ...
- tag_add($result_import_content3['data_id'],
$result_import_content4['rev_id'], "number",
$result_i_content['dyn_content_id'], "-1");
- }
- }
- echo "</ul>";
-
-
- echo "\n<hr />\n";
-
-
-
- echo "\n<hr />\n";
-
-
-?>
Removed: trunk/web/reactos.org/htdocs/roscms/roscms_2to3_page.php
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/rosc…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/roscms_2to3_page.php [iso-8859-1] (original)
+++ trunk/web/reactos.org/htdocs/roscms/roscms_2to3_page.php (removed)
@@ -1,186 +1,0 @@
-<?php
-
- error_reporting(E_ALL);
- ini_set('error_reporting', E_ALL);
-
- if (get_magic_quotes_gpc()) {
- die("ERROR: Disable 'magic quotes' in php.ini (=Off)");
- }
-
- if ( !defined('ROSCMS_SYSTEM') ) {
- define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking
activity
- }
-
-
- require("connect.db.php");
- require("inc/data_edit.php");
-
-
- echo "<h1>RosCMS Database Update - v2 to v3 - Page</h1>";
-
- set_time_limit(0); // unlimited script run time
-
- echo "<h3>Pages</h3>";
- echo "<ul>";
- $query_i_page = mysql_query("SELECT *
- FROM pages
- WHERE page_active = 1
- ORDER BY page_name ASC, page_version DESC, page_active DESC;");
- while ($result_i_page = mysql_fetch_array($query_i_page)) {
- $roscms_i_lang = $result_i_page['page_language'];
- if ($roscms_i_lang == "all") {
- $roscms_i_lang = "en";
- }
-
- echo "<li>".$result_i_page['page_name']."
(".$roscms_i_lang.")</li>";
-
- $query_import_page = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_page['page_name'])."'
- AND data_type = 'page'
- LIMIT 1;");
- $result_import_page = mysql_fetch_array($query_import_page);
- echo "<h6>data-ID:
".$result_import_page['data_id']."</h6>";
-
-
- if ($result_import_page['data_id'] == "") {
- $insert_page = mysql_query("INSERT INTO `data_` ( `data_id` , `data_name` ,
`data_type` , `data_acl` )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_i_page['page_name'])."',
- 'page',
- 'defaultpage'
- );");
- }
-
-
- $query_import_page3 = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_page['page_name'])."'
- AND data_type = 'page'
- LIMIT 1;");
- $result_import_page3 = mysql_fetch_array($query_import_page3);
-
- echo "<p>data_id:
".$result_import_page3['data_id']."</p>";
-
- $query_import_page2 = mysql_query("SELECT COUNT(*)
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_page3['data_id'])."'
- AND rev_language =
'".mysql_real_escape_string($roscms_i_lang)."'
- LIMIT 1;");
- $result_import_page2 = mysql_fetch_row($query_import_page2);
- echo "<p>data_id-count:
".$result_import_page2[0]."</p>";
-
- if ($result_import_page2[0] <= 0) {
- // revision entry doesn't exist
- $insert_page_rev = mysql_query("INSERT INTO data_revision ( rev_id , data_id ,
rev_version , rev_language , rev_usrid , rev_datetime , rev_date , rev_time )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_page3['data_id'])."',
- '".mysql_real_escape_string($result_i_page['page_version'])."',
- '".mysql_real_escape_string($roscms_i_lang)."',
- '".mysql_real_escape_string($result_i_page['page_usrname_id'])."',
- '".mysql_real_escape_string($result_i_page['page_date']."
".$result_i_page['page_time'])."',
- '".mysql_real_escape_string($result_i_page['page_date'])."',
- '".mysql_real_escape_string($result_i_page['page_time'])."'
- );");
-
-
- $query_import_page4 = mysql_query("SELECT rev_id
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_page3['data_id'])."'
- AND rev_language =
'".mysql_real_escape_string($roscms_i_lang)."'
- ORDER BY rev_id DESC
- LIMIT 1;");
- $result_import_page4 = mysql_fetch_array($query_import_page4);
-
- if ($result_import_page4['rev_id'] != "") {
-
- if ($result_i_page['pages_extention'] == "default") {
- $roscms_i_page_extention = "html";
- }
- else {
- $roscms_i_page_extention = $result_i_page['pages_extention'];
- }
-
- /*
- if ($result_i_page['pages_extra'] == "dynamic") {
- $roscms_i_page_extra = ", (
- NULL ,
- '".mysql_real_escape_string($result_import_page4['rev_id'])."',
- 'property',
- '".mysql_real_escape_string($result_i_page['pages_extra'])."'
- )";
- }
- else {
- $roscms_i_page_extra = "";
- }
- ".$roscms_i_page_extra."
- ,(
- NULL ,
- '".mysql_real_escape_string($result_import_page4['rev_id'])."',
- 'extention',
- '".mysql_real_escape_string($roscms_i_page_extention)."'
- )
- */
-
- // stext: titel, description, extention, (property)
- $insert_import_page_stext = mysql_query("INSERT INTO data_stext ( stext_id ,
data_rev_id , stext_name , stext_content )
- VALUES
- (
- NULL ,
- '".mysql_real_escape_string($result_import_page4['rev_id'])."',
- 'description',
- '".mysql_real_escape_string($result_i_page['page_description'])."'
- ),
- (
- NULL ,
- '".mysql_real_escape_string($result_import_page4['rev_id'])."',
- 'title',
- '".mysql_real_escape_string($result_i_page['page_title'])."'
- )
- ;");
-
- // text: content
- $insert_import_page_text = mysql_query("INSERT INTO data_text ( text_id ,
data_rev_id , text_name , text_content )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_page4['rev_id'])."',
- 'content',
- '".mysql_real_escape_string($result_i_page['page_text'])."'
- );");
-
- // tag: status = stable
- tag_add($result_import_page3['data_id'],
$result_import_page4['rev_id'], "status" /* name */, "stable"
/* value */, "-1" /* usrid */);
-
- if ($result_i_page['pages_extra'] == "dynamic") {
- // tag: kind = dynamic
- tag_add($result_import_page3['data_id'],
$result_import_page4['rev_id'], "kind" /* name */, "dynamic"
/* value */, "-1" /* usrid */);
- }
- else {
- // tag: kind = default
- tag_add($result_import_page3['data_id'],
$result_import_page4['rev_id'], "kind" /* name */, "default"
/* value */, "-1" /* usrid */);
- }
-
- if ($result_i_page['pages_extention'] == "default") {
- // tag: extention = html
- tag_add($result_import_page3['data_id'],
$result_import_page4['rev_id'], "extention" /* name */, "html"
/* value */, "-1" /* usrid */);
- }
- else {
- // tag: extention = ...
- tag_add($result_import_page3['data_id'],
$result_import_page4['rev_id'], "extention" /* name */,
$result_i_page['pages_extention'] /* value */, "-1" /* usrid */);
- }
- }
- }
- }
- echo "</ul>";
-
-
- echo "\n<hr />\n";
-
-
-
- echo "\n<hr />\n";
-
-
-?>
Removed: trunk/web/reactos.org/htdocs/roscms/roscms_2to3_script.php
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/rosc…
==============================================================================
--- trunk/web/reactos.org/htdocs/roscms/roscms_2to3_script.php [iso-8859-1] (original)
+++ trunk/web/reactos.org/htdocs/roscms/roscms_2to3_script.php (removed)
@@ -1,144 +1,0 @@
-<?php
-
- error_reporting(E_ALL);
- ini_set('error_reporting', E_ALL);
-
- if (get_magic_quotes_gpc()) {
- die("ERROR: Disable 'magic quotes' in php.ini (=Off)");
- }
-
- if ( !defined('ROSCMS_SYSTEM') ) {
- define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking
activity
- }
-
-
- require("connect.db.php");
- require("inc/data_edit.php");
-
-
- echo "<h1>RosCMS Database Update - v2 to v3 - Script</h1>";
-
- set_time_limit(0); // unlimited script run time
-
-
-
- echo "<h3>Scripts</h3>";
- echo "<ul>";
- $query_i_script = mysql_query("SELECT *
- FROM include_text
- WHERE inc_vis = '1'
- ORDER BY inc_word ASC;");
- while ($result_i_script = mysql_fetch_array($query_i_script)) {
- echo
"<li>".$result_i_script['inc_word']."</li>";
-
- $query_import_script = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_script['inc_word'])."'
- AND data_type = 'script'
- LIMIT 1;");
- $result_import_script = mysql_fetch_array($query_import_script);
-
-
- if ($result_import_script['data_id'] == "") {
- $insert_page = mysql_query("INSERT INTO `data_` ( `data_id` , `data_name` ,
`data_type` , `data_acl` )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_i_script['inc_word'])."',
- 'script',
- 'script'
- );");
- }
-
- $query_import_script3 = mysql_query("SELECT *
- FROM data_
- WHERE data_name =
'".mysql_real_escape_string($result_i_script['inc_word'])."'
- AND data_type = 'script'
- ORDER BY data_id DESC
- LIMIT 1;");
- $result_import_script3 = mysql_fetch_array($query_import_script3);
-
- echo "<p>data_id:
".$result_import_script3['data_id']."</p>";
-
- $query_import_script2 = mysql_query("SELECT COUNT(*)
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_script3['data_id'])."'
- AND rev_language = 'en'
- LIMIT 1;");
- $result_import_script2 = mysql_fetch_row($query_import_script2);
-
- echo "<p>data_id-count:
".$result_import_script2[0]."</p>";
-
- if ($result_import_script2[0] <= 0) {
- // revision entry doesn't exist
- $insert_script_rev = mysql_query("INSERT INTO data_revision ( rev_id , data_id ,
rev_version , rev_language , rev_usrid , rev_datetime , rev_date , rev_time )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_script3['data_id'])."',
- '1',
- 'en',
- '".mysql_real_escape_string($result_i_script['inc_usrname_id'])."',
- '".mysql_real_escape_string($result_i_script['inc_date']."
".$result_i_script['inc_time'])."',
- '".mysql_real_escape_string($result_i_script['inc_date'])."',
- '".mysql_real_escape_string($result_i_script['inc_time'])."'
- );");
-
-
-
- $query_import_script4 = mysql_query("SELECT rev_id
- FROM data_revision
- WHERE data_id =
'".mysql_real_escape_string($result_import_script3['data_id'])."'
- AND rev_language = 'en'
- ORDER BY rev_id DESC
- LIMIT 1;");
- $result_import_script4 = mysql_fetch_array($query_import_script4);
-
- if ($result_import_script4['rev_id'] != "") {
-
- // stext: titel, description
- $insert_import_script_stext = mysql_query("INSERT INTO data_stext ( stext_id ,
data_rev_id , stext_name , stext_content )
- VALUES
- (
- NULL ,
- '".mysql_real_escape_string($result_import_script4['rev_id'])."',
- 'description',
- '".mysql_real_escape_string($result_i_script['inc_word'])."'
- );");
-
- // text: content
- $insert_import_script_text = mysql_query("INSERT INTO data_text ( text_id ,
data_rev_id , text_name , text_content )
- VALUES (
- NULL ,
- '".mysql_real_escape_string($result_import_script4['rev_id'])."',
- 'content',
- '".mysql_real_escape_string($result_i_script['inc_text'])."'
- );");
-
- // tag: status = stable
- tag_add($result_import_script3['data_id'],
$result_import_script4['rev_id'], "status", "stable",
"-1");
-
- // tag: visible = admin
- tag_add($result_import_script3['data_id'],
$result_import_script4['rev_id'], "visible", "admin",
"-1");
-
- if ($result_i_script['inc_extra'] == "template_php") {
- // tag: kind = php
- tag_add($result_import_script3['data_id'],
$result_import_script4['rev_id'], "kind", "php",
"-1");
- }
- else {
- // tag: kind = var
- tag_add($result_import_script3['data_id'],
$result_import_script4['rev_id'], "kind", "var",
"-1");
- }
- }
- }
- }
- echo "</ul>";
-
-
- echo "\n<hr />\n";
-
-
-
-
- echo "\n<hr />\n";
-
-
-?>
Removed: trunk/web/reactos.org/sql/roscms.sql
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/sql/roscms.sql?rev…
==============================================================================
--- trunk/web/reactos.org/sql/roscms.sql [iso-8859-1] (original)
+++ trunk/web/reactos.org/sql/roscms.sql (removed)
@@ -1,486 +1,0 @@
--- Database: `roscms`
---
--- Date: 2007-08-13 11:12
--- MySQL-Version: 5.0.33
--- PHP-Version: 5.2.1
---
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_`
---
-
-CREATE TABLE `data_` (
- `data_id` int(11) NOT NULL auto_increment,
- `data_name` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'together with
page_type unique entries',
- `data_type` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT '"page",
"layout", "content", "script"',
- `data_acl` varchar(50) collate utf8_unicode_ci NOT NULL default 'default',
- PRIMARY KEY (`data_id`),
- KEY `data_name` (`data_name`,`data_type`),
- KEY `data_type` (`data_type`),
- KEY `data_acl` (`data_acl`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1
"pages", "content", "dyncontent" and
"inctext"';
-
-INSERT INTO `data_` VALUES (1, 'index', 'page', 'defaultpage');
-INSERT INTO `data_` VALUES (2, 'default', 'template', 'layout');
-INSERT INTO `data_` VALUES (3, 'index', 'content', 'default');
-INSERT INTO `data_` VALUES (4, 'news', 'script', 'script');
-INSERT INTO `data_` VALUES (5, 'news_page', 'content',
'default');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_a`
---
-
-CREATE TABLE `data_a` (
- `data_id` int(11) NOT NULL auto_increment,
- `data_name` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT 'together with
page_type unique entries',
- `data_type` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT '"page",
"layout", "content", "script"',
- `data_acl` varchar(50) collate utf8_unicode_ci NOT NULL default 'default',
- PRIMARY KEY (`data_id`),
- KEY `data_name` (`data_name`,`data_type`),
- KEY `data_type` (`data_type`),
- KEY `data_acl` (`data_acl`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='all RosCMS v1
"pages", "content", "dyncontent" and
"inctext"';
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_revision`
---
-
-CREATE TABLE `data_revision` (
- `rev_id` int(11) NOT NULL auto_increment COMMENT 'unique revisions id',
- `data_id` int(11) NOT NULL,
- `rev_version` int(11) NOT NULL COMMENT 'version number increase with every entry
change',
- `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT 'language code
("en", "de", etc.)',
- `rev_usrid` int(11) NOT NULL COMMENT 'user id who saved the entry',
- `rev_datetime` datetime NOT NULL,
- `rev_date` date NOT NULL,
- `rev_time` time NOT NULL,
- PRIMARY KEY (`rev_id`),
- KEY `data_id` (`data_id`),
- KEY `rev_language` (`rev_language`),
- KEY `rev_version` (`rev_version`),
- KEY `rev_datetime` (`rev_datetime`),
- KEY `rev_usrid` (`rev_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_revision` VALUES (1, 1, 1, 'en', 1, '2007-08-13
17:03:44', '2007-08-13', '17:03:44');
-INSERT INTO `data_revision` VALUES (2, 2, 1, 'en', 1, '2007-08-13
17:05:03', '2007-08-13', '17:05:03');
-INSERT INTO `data_revision` VALUES (6, 3, 2, 'en', 1, '2007-08-13
17:15:15', '2007-08-13', '17:15:15');
-INSERT INTO `data_revision` VALUES (5, 4, 2, 'en', 1, '2007-08-13
17:11:36', '2007-08-13', '17:11:36');
-INSERT INTO `data_revision` VALUES (7, 5, 1, 'en', 1, '2007-08-13
17:15:20', '2007-08-13', '17:15:20');
-INSERT INTO `data_revision` VALUES (8, 5, 1, 'en', 1, '2007-08-13
17:15:45', '2007-08-13', '17:15:45');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_revision_a`
---
-
-CREATE TABLE `data_revision_a` (
- `rev_id` int(11) NOT NULL auto_increment COMMENT 'unique revisions id',
- `data_id` int(11) NOT NULL,
- `rev_version` int(11) NOT NULL COMMENT 'version number increase with every entry
change',
- `rev_language` varchar(10) collate utf8_unicode_ci NOT NULL COMMENT 'language code
("en", "de", etc.)',
- `rev_usrid` int(11) NOT NULL COMMENT 'user id who saved the entry',
- `rev_datetime` datetime NOT NULL,
- `rev_date` date NOT NULL,
- `rev_time` time NOT NULL,
- PRIMARY KEY (`rev_id`),
- KEY `data_id` (`data_id`),
- KEY `rev_language` (`rev_language`),
- KEY `rev_version` (`rev_version`),
- KEY `rev_datetime` (`rev_datetime`),
- KEY `rev_usrid` (`rev_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_security`
---
-
-CREATE TABLE `data_security` (
- `sec_name` varchar(50) collate utf8_unicode_ci NOT NULL,
- `sec_fullname` varchar(100) collate utf8_unicode_ci NOT NULL,
- `sec_description` varchar(255) collate utf8_unicode_ci NOT NULL,
- `sec_branch` varchar(10) collate utf8_unicode_ci NOT NULL,
- `sec_lev1_read` tinyint(4) NOT NULL default '0',
- `sec_lev1_write` tinyint(4) NOT NULL default '0',
- `sec_lev1_add` tinyint(4) NOT NULL default '0',
- `sec_lev1_pub` tinyint(4) NOT NULL default '0',
- `sec_lev1_trans` tinyint(4) NOT NULL default '0',
- `sec_lev2_read` tinyint(4) NOT NULL default '0',
- `sec_lev2_write` tinyint(4) NOT NULL default '0',
- `sec_lev2_add` tinyint(4) NOT NULL default '0',
- `sec_lev2_pub` tinyint(4) NOT NULL default '0',
- `sec_lev2_trans` tinyint(4) NOT NULL default '0',
- `sec_lev3_read` tinyint(4) NOT NULL default '0',
- `sec_lev3_write` tinyint(4) NOT NULL default '0',
- `sec_lev3_add` tinyint(4) NOT NULL default '0',
- `sec_lev3_pub` tinyint(4) NOT NULL default '0',
- `sec_lev3_trans` tinyint(4) NOT NULL default '0',
- `sec_allow` varchar(255) collate utf8_unicode_ci NOT NULL,
- `sec_deny` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`sec_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS content
security';
-
-INSERT INTO `data_security` VALUES ('default', 'Content (default)',
'Default content security ACL; normal translator cannot publish nor add new
content', 'website', 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '',
'');
-INSERT INTO `data_security` VALUES ('script', 'Script or Variable',
'Entry contain scripts, variables or similar content which can only be accessed and
altered by admins.', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0,
'', '');
-INSERT INTO `data_security` VALUES ('layout', 'Layout', 'Website
layout related content, changing may destroy the website layout, so be careful!',
'website', 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, '',
'|transmaint|');
-INSERT INTO `data_security` VALUES ('announcement', 'Official
announcement', 'Official announcement, which shouldn''t be altered by
anyone except admins and devs', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,
1, 1, 1, '|developer|', '');
-INSERT INTO `data_security` VALUES ('notrans', 'No translation needed',
'Content don''t need a translation.', '', 1, 0, 0, 0, 0, 1, 1, 1,
1, 0, 1, 1, 1, 1, 1, '', '');
-INSERT INTO `data_security` VALUES ('rosversion', 'ReactOS versions
number', 'Currrent ReactOS version number, change the related contents on every
release day!', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0,
'|developer|', '');
-INSERT INTO `data_security` VALUES ('defaultpage', 'Page (default)',
'Default page security ACL', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1,
1, 1, 1, 1, '|developer|', '');
-INSERT INTO `data_security` VALUES ('defaultmenu', 'Menu (default)',
'Menu content which can be translated by language maintainers', 'website',
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '|transmaint|', '');
-INSERT INTO `data_security` VALUES ('system', 'System', 'RosCMS
system', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
'|ros_sadmin|', '');
-INSERT INTO `data_security` VALUES ('readonly', 'Read-Only', 'Read
only, noone can alter this', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0,
0, 0, '', '');
-INSERT INTO `data_security` VALUES ('langmaint', 'Language Maintainer',
'Language-Group related content', 'website', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
1, 1, 1, 1, 1, '|transmaint|', '');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_stext`
---
-
-CREATE TABLE `data_stext` (
- `stext_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`stext_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `stext_content` (`stext_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_stext` VALUES (14, 1, 'description', 'test page');
-INSERT INTO `data_stext` VALUES (13, 1, 'comment', '');
-INSERT INTO `data_stext` VALUES (12, 2, 'description', 'test template');
-INSERT INTO `data_stext` VALUES (15, 1, 'title', 'Index');
-INSERT INTO `data_stext` VALUES (19, 6, 'description', 'test content');
-INSERT INTO `data_stext` VALUES (18, 5, 'description', 'news php
script');
-INSERT INTO `data_stext` VALUES (22, 7, 'description', 'news issue 1');
-INSERT INTO `data_stext` VALUES (23, 7, 'title', 'News_page');
-INSERT INTO `data_stext` VALUES (26, 8, 'description', 'news issue 2');
-INSERT INTO `data_stext` VALUES (27, 8, 'title', 'News_page');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_stext_a`
---
-
-CREATE TABLE `data_stext_a` (
- `stext_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `stext_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `stext_content` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`stext_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `stext_content` (`stext_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag`
---
-
-CREATE TABLE `data_tag` (
- `tag_id` int(11) NOT NULL auto_increment,
- `data_id` int(11) NOT NULL,
- `data_rev_id` int(11) NOT NULL,
- `tag_name_id` int(11) NOT NULL,
- `tag_value_id` int(11) NOT NULL,
- `tag_usrid` int(11) NOT NULL,
- PRIMARY KEY (`tag_id`),
- KEY `data_id` (`data_id`),
- KEY `data_rev_id` (`data_rev_id`),
- KEY `tag_name_id` (`tag_name_id`),
- KEY `tag_value_id` (`tag_value_id`),
- KEY `tag_usrid` (`tag_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_tag` VALUES (11, 1, 1, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (2, 1, 1, 2, 2, -1);
-INSERT INTO `data_tag` VALUES (10, 2, 2, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (15, 4, 5, 5, 7, -1);
-INSERT INTO `data_tag` VALUES (14, 4, 5, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (24, 3, 6, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (22, 5, 7, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (18, 5, 7, 6, 9, -1);
-INSERT INTO `data_tag` VALUES (21, 5, 8, 1, 5, -1);
-INSERT INTO `data_tag` VALUES (20, 5, 8, 6, 10, -1);
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_a`
---
-
-CREATE TABLE `data_tag_a` (
- `tag_id` int(11) NOT NULL auto_increment,
- `data_id` int(11) NOT NULL,
- `data_rev_id` int(11) NOT NULL,
- `tag_name_id` int(11) NOT NULL,
- `tag_value_id` int(11) NOT NULL,
- `tag_usrid` int(11) NOT NULL,
- PRIMARY KEY (`tag_id`),
- KEY `data_id` (`data_id`),
- KEY `data_rev_id` (`data_rev_id`),
- KEY `tag_name_id` (`tag_name_id`),
- KEY `tag_value_id` (`tag_value_id`),
- KEY `tag_usrid` (`tag_usrid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_name`
---
-
-CREATE TABLE `data_tag_name` (
- `tn_id` int(11) NOT NULL auto_increment,
- `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tn_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_tag_name` VALUES (1, 'status');
-INSERT INTO `data_tag_name` VALUES (2, 'extension');
-INSERT INTO `data_tag_name` VALUES (4, 'star');
-INSERT INTO `data_tag_name` VALUES (5, 'kind');
-INSERT INTO `data_tag_name` VALUES (6, 'number');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_name_a`
---
-
-CREATE TABLE `data_tag_name_a` (
- `tn_id` int(11) NOT NULL auto_increment,
- `tn_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tn_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_value`
---
-
-CREATE TABLE `data_tag_value` (
- `tv_id` int(11) NOT NULL auto_increment,
- `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tv_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_tag_value` VALUES (7, 'php');
-INSERT INTO `data_tag_value` VALUES (2, 'html');
-INSERT INTO `data_tag_value` VALUES (4, 'off');
-INSERT INTO `data_tag_value` VALUES (5, 'stable');
-INSERT INTO `data_tag_value` VALUES (9, '1');
-INSERT INTO `data_tag_value` VALUES (10, '2');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_tag_value_a`
---
-
-CREATE TABLE `data_tag_value_a` (
- `tv_id` int(11) NOT NULL auto_increment,
- `tv_value` varchar(255) collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`tv_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_text`
---
-
-CREATE TABLE `data_text` (
- `text_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `text_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `text_content` text collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`text_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `text_content` (`text_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `data_text` VALUES (9, 1, 'content', '[#templ_default]');
-INSERT INTO `data_text` VALUES (8, 2, 'content',
'[#cont_head][#cont_menu_top][#cont_menu_side][#cont_contmenu_[#%NAME%]][#cont_menu_search][#cont_menu_language][#cont_menu_misc][#cont_%NAME%][#cont_bottom]');
-INSERT INTO `data_text` VALUES (13, 6, 'content', '<h1>Welcome to
RosCMS v3</h1><p>RosCMS test page</p>[#inc_news]');
-INSERT INTO `data_text` VALUES (15, 7, 'content', 'news #1 ...');
-INSERT INTO `data_text` VALUES (17, 8, 'content', 'news #2');
-INSERT INTO `data_text` VALUES (12, 5, 'content', '<h3>News</h3>
<?php $tmp_year = "2085"; $query_content = mysql_query("SELECT
d.data_name, r.rev_usrid, s1.stext_content AS ''title'', s2.stext_content
AS ''description'', v.tv_value as ''numb'', r.rev_date
FROM data_ d, data_revision r, data_stext s1, data_stext s2, data_tag a, data_tag_name n,
data_tag_value v WHERE d.data_name = ''news_page'' AND d.data_type =
''content'' AND r.data_id = d.data_id AND (r.rev_language =
''".mysql_real_escape_string($roscms_template_var_lang)."'' OR
r.rev_language = ''en'') AND r.rev_version > 0 AND s1.data_rev_id =
r.rev_id AND s1.stext_name = ''title'' AND s2.data_rev_id = r.rev_id
AND s2.stext_name = ''description'' AND r.data_id = a.data_id AND
r.rev_id = a.data_rev_id AND a.tag_usrid = ''-1'' AND a.tag_name_id =
n.tn_id AND n.tn_name = ''number'' AND a.tag_value_id = v.tv_id ORDER
BY r.rev_datetime DESC LIMIT 3;"); while($result_content =
mysql_fetch_array($query_content)) {
-if ($tmp_year > substr($result_content[''rev_date''], 0, 4)) {
$tmp_year = substr($result_content[''rev_date''], 0, 4); echo
"<h3>".$tmp_year."</h3>"; } $query_usraccount=
mysql_query("SELECT user_name, user_fullname FROM users WHERE user_id =
''".mysql_real_escape_string($result_content["rev_usrid"])."''
LIMIT 1;"); $result_usraccount=mysql_fetch_array($query_usraccount); ?> <p
align="left"><b><font color="#666666"><?php echo
$result_content[''rev_date'']; ?>, <?php if
($result_usraccount[''user_fullname'']) { echo
$result_usraccount[''user_fullname'']; } else { echo
$result_usraccount[''user_name'']; } ?>
</font></b><br /> <b><a href="<?php echo
"[#link_".$result_content["data_name"]."_".$result_content["numb"]."]";
?>"><?php echo $result_content["title"];
?></a></b><br /> <?php echo
$result_content["description"]; ?></p> <?php } // end while ?>
');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_text_a`
---
-
-CREATE TABLE `data_text_a` (
- `text_id` int(11) NOT NULL auto_increment,
- `data_rev_id` int(11) NOT NULL,
- `text_name` varchar(100) collate utf8_unicode_ci NOT NULL,
- `text_content` text collate utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`text_id`),
- KEY `data_rev_id` (`data_rev_id`),
- FULLTEXT KEY `text_content` (`text_content`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `data_user_filter`
---
-
-CREATE TABLE `data_user_filter` (
- `filt_id` int(11) NOT NULL auto_increment,
- `filt_usrid` int(11) NOT NULL,
- `filt_title` varchar(50) collate utf8_unicode_ci NOT NULL,
- `filt_type` smallint(6) NOT NULL default '1',
- `filt_string` varchar(255) collate utf8_unicode_ci NOT NULL,
- `filt_datetime` datetime NOT NULL,
- `filt_usage` int(11) NOT NULL,
- `filt_usagedate` datetime NOT NULL,
- PRIMARY KEY (`filt_id`),
- KEY `filt_usrid` (`filt_usrid`),
- KEY `filt_name` (`filt_title`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `languages`
---
-
-CREATE TABLE `languages` (
- `lang_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
- `lang_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
- `lang_name_org` varchar(100) collate utf8_unicode_ci NOT NULL,
- `lang_level` int(11) NOT NULL default '0',
- PRIMARY KEY (`lang_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='available
languages';
-
-INSERT INTO `languages` VALUES ('en', 'English', 'English', 10);
-INSERT INTO `languages` VALUES ('de', 'German', 'Deutsch', 8);
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `subsys_mappings`
---
-
-CREATE TABLE `subsys_mappings` (
- `map_roscms_userid` bigint(20) NOT NULL default '0',
- `map_subsys_name` varchar(10) character set utf8 NOT NULL default '',
- `map_subsys_userid` int(7) NOT NULL default '0',
- PRIMARY KEY (`map_roscms_userid`,`map_subsys_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `user_sessions`
---
-
-CREATE TABLE `user_sessions` (
- `usersession_id` varchar(32) character set utf8 NOT NULL default '' COMMENT
'Unique ID of this session',
- `usersession_user_id` bigint(20) NOT NULL default '0' COMMENT 'User this
session belongs to',
- `usersession_expires` datetime default NULL COMMENT 'Expiry date/time (NULL if does
not expire)',
- `usersession_browseragent` varchar(255) character set utf8 NOT NULL default ''
COMMENT 'HTTP_USER_AGENT when this session was created',
- `usersession_ipaddress` varchar(15) character set utf8 NOT NULL default ''
COMMENT 'IP address from which this session was created',
- `usersession_created` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT
'session created (date/time) - all session will get deleted ... by date',
- PRIMARY KEY (`usersession_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0
COMMENT='Sessions';
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `usergroup_members`
---
-
-CREATE TABLE `usergroup_members` (
- `usergroupmember_userid` bigint(20) NOT NULL default '0',
- `usergroupmember_usergroupid` varchar(10) collate utf8_unicode_ci NOT NULL default
'user'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `usergroups`
---
-
-CREATE TABLE `usergroups` (
- `usrgroup_name_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
- `usrgroup_name` varchar(100) collate utf8_unicode_ci NOT NULL default '',
- `usrgroup_intern_id` varchar(25) collate utf8_unicode_ci NOT NULL default '',
- `usrgroup_seclev` tinyint(4) NOT NULL default '0',
- `usrgroup_securitylevel` tinyint(4) NOT NULL default '0',
- `usrgroup_description` varchar(255) collate utf8_unicode_ci NOT NULL default
'',
- PRIMARY KEY (`usrgroup_name_id`),
- UNIQUE KEY `usrgroup_name` (`usrgroup_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-INSERT INTO `usergroups` VALUES ('ros_admin', 'Administrator',
'roscms_usrgrp_admin', 3, 70, 'Administrator-Group');
-INSERT INTO `usergroups` VALUES ('user', 'User',
'roscms_usrgrp_user', 0, 0, 'Normal Visitors');
-INSERT INTO `usergroups` VALUES ('developer', 'Developer',
'roscms_usrgrp_dev', 2, 50, 'Developer');
-INSERT INTO `usergroups` VALUES ('moderator', 'Moderator',
'roscms_usrgrp_team', 2, 20, 'Website Moderators');
-INSERT INTO `usergroups` VALUES ('translator', 'Translator',
'roscms_usrgrp_trans', 1, 10, 'Translators');
-INSERT INTO `usergroups` VALUES ('ros_sadmin', 'Super-Administrator',
'roscms_usrgrp_sadmin', 3, 100, 'Super-Administrator-Group');
-INSERT INTO `usergroups` VALUES ('transmaint', 'Tranlation Maintainer',
'roscms_usrgrp_trans', 2, 15, 'Translation Maintainer');
-
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `users`
---
-
-CREATE TABLE `users` (
- `user_id` bigint(20) NOT NULL auto_increment,
- `user_name` varchar(20) collate utf8_unicode_ci NOT NULL default '',
- `user_roscms_password` varchar(32) collate utf8_unicode_ci NOT NULL default
'',
- `user_roscms_getpwd_id` varchar(50) collate utf8_unicode_ci NOT NULL default
'',
- `user_timestamp_touch` varchar(50) collate utf8_unicode_ci NOT NULL default
'',
- `user_timestamp_touch2` timestamp NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
- `user_login_counter` bigint(20) NOT NULL default '0',
- `user_account_enabled` varchar(10) collate utf8_unicode_ci NOT NULL default
'no',
- `user_account_hidden` varchar(5) collate utf8_unicode_ci NOT NULL default
'no',
- `user_register` timestamp NULL default NULL,
- `user_fullname` varchar(100) collate utf8_unicode_ci NOT NULL default '',
- `user_email` varchar(150) collate utf8_unicode_ci NOT NULL default '',
- `user_website` varchar(150) collate utf8_unicode_ci NOT NULL default '',
- `user_language` varchar(2) collate utf8_unicode_ci NOT NULL default '',
- `user_country` varchar(2) collate utf8_unicode_ci NOT NULL default '',
- `user_timezone` varchar(3) collate utf8_unicode_ci NOT NULL default '',
- `user_occupation` varchar(50) collate utf8_unicode_ci NOT NULL default '',
- `user_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
- `user_setting_multisession` varchar(5) collate utf8_unicode_ci NOT NULL default
'false',
- `user_setting_browseragent` varchar(5) collate utf8_unicode_ci NOT NULL default
'true',
- `user_setting_ipaddress` varchar(5) collate utf8_unicode_ci NOT NULL default
'true',
- `user_setting_timeout` varchar(5) collate utf8_unicode_ci NOT NULL default
'true',
- PRIMARY KEY (`user_id`),
- UNIQUE KEY `user_name` (`user_name`),
- UNIQUE KEY `user_email` (`user_email`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User
Table';
-