--- trunk/web/reactos.org/htdocs/roscms/inc/admin_content_edit.php 2005-12-21 19:07:47 UTC (rev 20288)
+++ trunk/web/reactos.org/htdocs/roscms/inc/admin_content_edit.php 2005-12-21 20:34:30 UTC (rev 20289)
@@ -64,9 +64,14 @@
<td width="15%" bgcolor="#5984C3"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Content
ID </strong></font></div></td>
<td width="85%" bgcolor="#E2E2E2"> <div align="left"><font face="Arial, Helvetica, sans-serif">
- [#cont_
- <input name="txt_contentid" type="text" id="txt_contentid" value="<?php echo $result_content['content_name']; ?>" size="50" maxlength="50">
- ] (e.g. "about")</font></div></td>
+ [#cont_<?php
+ if ($rpm_page == "trans") {
+ echo '<input name="txt_contentid" type="hidden" id="txt_contentid" value="'.$result_content['content_name'].'"><b>'.$result_content['content_name'].'</b>';
+ }
+ else {
+ echo '<input name="txt_contentid" type="text" id="txt_contentid" value="'.$result_content['content_name'].'" size="50" maxlength="50">';
+ }
+ ?>] (e.g. "about")</font></div></td>
</tr>
<tr>
<td valign="top" bgcolor="#5984C3"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Language</strong></font></div></td>
@@ -81,10 +86,15 @@
ORDER BY 'lang_level' DESC Limit 1";
$sql_query_lang=mysql_query($sql_lang);
$myrow_lang=mysql_fetch_row($sql_query_lang); // Languages
- ?>
+?>
<optgroup label="languages">
+<?php
+ if ($rpm_page != "trans") {
+?>
<option value="all"<?php if ($cmsros_intern_temp_lang_short == "all") { echo ' selected="selected"'; } ?>>All</option>
- <?php
+<?php
+ }
+
// Languages
$sql_langa="SELECT *
@@ -93,18 +103,29 @@
ORDER BY 'lang_level' DESC";
$sql_query_langa=mysql_query($sql_langa);
while($myrow_langa=mysql_fetch_row($sql_query_langa)) {
- echo '<option value="'.$myrow_langa[0].'"';
- if ($myrow_lang[0] == $myrow_langa[0]) {
+ if ($rpm_page == "trans" && $myrow_langa[0] == "en") {
+ // temp
+ }
+ else {
+ echo '<option value="'.$myrow_langa[0].'"';
+ if ($myrow_lang[0] == $myrow_langa[0]) {
echo ' selected="selected"';
- }
- echo '>'.$myrow_langa[1].'</option>';
+ }
+ echo '>'.$myrow_langa[1].'</option>';
+ }
}
?>
</optgroup>
+ <?php
+ if ($rpm_page != "trans") {
+ ?>
<optgroup label="other">
<option value="xhtml"<?php if ($result_content['content_lang'] == "xhtml") { echo ' selected="selected"'; } ?>>XHTML</option>
<option value="html"<?php if ($result_content['content_lang'] == "html") { echo ' selected="selected"'; } ?>>HTML</option>
</optgroup>
+ <?php
+ }
+ ?>
</select>
</div></td>
</tr>
@@ -138,25 +159,36 @@
<td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Visible</strong></font></div></td>
<td valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif">
<?php
- if ($result_content['content_visible'] == 1) {
- echo ' <input name="content_visible" type="radio" value="yes" checked> yes <input type="radio" name="content_visible" value="no"> no';
+ if ($rpm_page == "trans") {
+ echo '<input name="content_visible" type="hidden" id="content_visible" value="yes">yes';
}
else {
- echo ' <input name="content_visible" type="radio" value="yes"> yes <input type="radio" name="content_visible" value="no" checked> no';
- }
+ if ($result_content['content_visible'] == 1) {
+ echo ' <input name="content_visible" type="radio" value="yes" checked> yes <input type="radio" name="content_visible" value="no"> no';
+ }
+ else {
+ echo ' <input name="content_visible" type="radio" value="yes"> yes <input type="radio" name="content_visible" value="no" checked> no';
+ }
+ }
?>
- </font></td>
+
+</font></td>
</tr>
<tr>
<td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Active</strong></font></div></td>
<td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif">
<?php
- if ($result_content['content_active'] == 1) {
- echo ' <input name="content_active" type="radio" value="yes" checked> yes <input type="radio" name="content_active" value="no"> no';
+ if ($rpm_page == "trans") {
+ echo '<input name="content_active" type="hidden" id="content_active" value="yes">yes';
}
else {
- echo ' <input name="content_active" type="radio" value="yes"> yes <input type="radio" name="content_active" value="no" checked> no';
- }
+ if ($result_content['content_active'] == 1) {
+ echo ' <input name="content_active" type="radio" value="yes" checked> yes <input type="radio" name="content_active" value="no"> no';
+ }
+ else {
+ echo ' <input name="content_active" type="radio" value="yes"> yes <input type="radio" name="content_active" value="no" checked> no';
+ }
+ }
?>
</font></td>
</tr>
@@ -187,14 +219,27 @@
<tr>
<td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Type</strong></font></div></td>
<td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif">
- <input name="txt_content_type" type="text" id="txt_content_type" value="<?php echo $result_content['content_type']; ?>" size="30" maxlength="30">
-("default", "layout", ...) </font></td>
+<?php
+
+ if ($rpm_page == "trans") {
+ echo '<input name="txt_content_type" type="hidden" id="txt_content_type" value="'.$result_content['content_type'].'">'.$result_content['content_type'];
+ }
+ else {
+ echo '<input name="txt_content_type" type="text" id="txt_content_type" value="'.$result_content['content_type'].'" size="30" maxlength="30"> ("default", "layout", ...)';
+ }
+?></font></td>
</tr>
<tr>
<td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></div></td>
<td valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif">
- <input name="txt_content_desc" type="text" id="txt_content_desc" value="<?php echo $result_content['content_description']; ?>" size="50" maxlength="255">
- </font></td>
+<?php
+ if ($rpm_page == "trans") {
+ echo '<input name="txt_content_desc" type="hidden" id="txt_content_desc" value="'.$result_content['content_description'].'">'.$result_content['content_description'];
+ }
+ else {
+ echo '<input name="txt_content_desc" type="text" id="txt_content_desc" value="'.$result_content['content_description'].'" size="50" maxlength="255">';
+ }
+ ?></font></td>
</tr>
<tr>
<td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Username</strong></font></div></td>
@@ -263,10 +308,11 @@
?>
</p>
<p>
- <?php if ($rpm_opt=="translate") { ?>
+ <?php if ($rpm_opt == "translate") { ?>
+
<input name="content_rad_opt" type="radio" value="translate" checked>
Translate
- <p><b><blink>Please check, if you selected the right language, before you
+ <p><b><blink>Please check, if you have selected the right language, before you
click "submit"!</blink></b></p>
<input type="submit" name="Submit" value="Submit">
<p> </p>
@@ -457,6 +503,7 @@
if ($content_savemode == "update") {
echo "<p>The content '".$result_content['content_name']."' (id='".$rpm_db_id."') has been saved!</p>";
echo "<p><a href=".$_SERVER['HTTP_REFERER'].">Back to the 'content edit' page</a></p>";
+ echo "<p> </p><p><fieldset><legend>Preview</legend><br>".$result_content['content_text']."</fieldset></p>";
}
else {
$query_content_new_revision_preview = mysql_query("SELECT *
@@ -470,8 +517,8 @@
echo "<p>A new version of content '".$result_content_new_revision_preview['content_name']."' (old id='".$rpm_db_id."', new id='". $result_content_new_revision_preview["content_id"] ."') has been saved!</p>";
echo "<p><a href='?page=". $rpm_page ."&sec=content&sec2=edit&sort=". $rpm_sort ."&filt=". $rpm_filt ."&langid=". $rpm_lang_id ."&db_id=". $result_content_new_revision_preview['content_id'] ."'>Go to the 'content edit' page (revision ". $result_content_new_revision_preview["content_id"] .")</a></p>";
echo "<p><a href='".$_SERVER['HTTP_REFERER']."'>Back to the 'content edit' page (revision ". $result_content['content_id'] .")</a></p>";
+ echo "<p> </p><p><fieldset><legend>Preview</legend><br>".$result_content_new_revision_preview['content_text']."</fieldset></p>";
}
- echo "<p> </p><p><fieldset><legend>Preview</legend><br>".$result_content['content_text']."</fieldset></p>";
}
?>
--- trunk/web/reactos.org/sql/roscms.sql 2005-12-21 19:07:47 UTC (rev 20288)
+++ trunk/web/reactos.org/sql/roscms.sql 2005-12-21 20:34:30 UTC (rev 20289)
@@ -1,29 +1,11 @@
---
--- RosCMS - ReactOS Content Management System
--- Copyright (C) 2005 Ge van Geldorp <gvg@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.
+-- Database: RosCMS
--
--- 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: `roscms`
---
-- --------------------------------------------------------
--
--- `content`
+-- Table structure for table `content`
--
DROP TABLE IF EXISTS `content`;
@@ -35,18 +17,37 @@
`content_version` int(11) NOT NULL default '0',
`content_active` tinyint(4) NOT NULL default '0',
`content_visible` tinyint(4) NOT NULL default '0',
+ `content_type` varchar(10) collate utf8_unicode_ci NOT NULL default 'default',
`content_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`content_editor` varchar(10) collate utf8_unicode_ci NOT NULL default '',
`content_usrname_id` bigint(20) NOT NULL default '0',
`content_date` date NOT NULL default '0000-00-00',
`content_time` time NOT NULL default '00:00:00',
PRIMARY KEY (`content_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents' AUTO_INCREMENT=0;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
+--
+-- Data for table`content`
+--
+
+INSERT INTO `content` (`content_id`, `content_name`, `content_lang`, `content_text`, `content_version`, `content_active`, `content_visible`, `content_type`, `content_description`, `content_editor`, `content_usrname_id`, `content_date`, `content_time`) VALUES (31, 'index', 'all', '<h1>ReactOS Content Management System - Test Page</h1>\r\n<p>English start page</p>', 1, 1, 1, 'default', '', 'richtext', 2, '2005-12-05', '11:48:43'),
+(2, 'bottom', 'all', '</div></td>\r\n </tr>\r\n</table>\r\n\r\n<!--\r\n links/lynx/etc.. dont handle css (atleast not external\r\n files by default) so dont overly depend on it.\r\n -->\r\n<hr style="height: 1px;"/>\r\n\r\n<address style="text-align:center;">\r\n ReactOS is a registered trademark or a trademark of ReactOS Foundation in the United States and other countries.</address>\r\n</body>\r\n</html> ', 1, 1, 1, 'layout', '', '', 2, '2005-09-19', '23:15:40'),
+(21, 'menu_top', 'all', '<div id="top">\r\n <div id="topMenu"> \r\n <!-- \r\n Use <p> to align things for links/lynx, then in the css make it\r\n margin: 0; and use text-align: left/right/etc;.\r\n -->\r\n <p style="text-align:left;"> \r\n <a href="[#link_index]">Home</a> <span style="color: #ffffff">|</span> \r\n <a href="[#link_news]">News</a> <span style="color: #ffffff">|</span> \r\n <a href="[#link_sitemap]">Sitemap</a></p>\r\n </div>\r\n </div>', 1, 1, 1, 'default', '2005-12-21 20:01:24 [2] |', '', 2, '2005-12-05', '11:49:02'),
+(24, 'menu_side', 'all', '<table style="border:0" width="100%" cellpadding="0" cellspacing="0">\r\n <tr valign="top">\r\n <td style="width:147px" id="leftNav"> \r\n <div class="navTitle">Navigation</div>\r\n <ol>\r\n <li><a href="[#link_index]">Home</a></li>\r\n <li><a href="[#link_news]">News</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li>\r\n </ol>\r\n <p></p>\r\n ', 1, 1, 1, 'default', '2005-12-21 20:01:51 [2] |', '', 2, '2005-12-05', '11:48:53'),
+(96, 'head', 'all', '<?xml version="1.0" encoding="[#inc_charset]"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"\r\n "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="[#roscms_language_short]" >\r\n\r\n<head>\r\n <title>ReactOS Homepage - [#roscms_pagetitle]</title>\r\n \r\n <meta http-equiv="Content-Type" content="application/xml" />\r\n <meta http-equiv="pics-label" content=''(pics-1.1 "http://www.icra.org/ratingsv02.html" l gen true for "http://www.reactos.com/" r (cz 1 lz 1 nz 1 oz 1 vz 1))'' />\r\n <meta http-equiv="Pragma" content="no-cache" />\r\n <meta name="Publisher" content="ReactOS Web Team" />\r\n <meta name="Copyright" content="ReactOS Foundation" />\r\n <meta name="generator" content="RosCMS" />\r\n <meta name="Keywords" content="reactos, ros, ros32, win32 ros64, roscms, operating system, wiki, forum, download, information, support database, compatibility database, compatibility, package database, reactos package manager, reactos content management system, reactos 0.1, reactos 0.2, reactos 0.3, ros 0.1, ros 0.2, ros 0.3" />\r\n <meta name="Description" content="ReactOS Homepage - ..." />\r\n <meta name="Page-topic" content="Betriebssystem, Computer, Software, downloads" />\r\n <meta name="Audience" content="all" />\r\n <meta name="Content-language" content="DE" />\r\n <meta name="Page-type" content="Operating System/Information/News" />\r\n <meta name="Robots" content="index,follow" />\r\n \r\n <link rel="SHORTCUT ICON" href="[#roscms_path_homepage]favicon.ico&!
quot; /&
gt;\r\n <link rel="alternate" type="application/rss+xml" title="ReactOS News Feed (RSS)" href="[#roscms_path_homepage]reactos.rdf" />\r\n <link href="[#roscms_path_homepage]style.css" type="text/css" rel="stylesheet" />\r\n</head>\r\n<body>', 2, 1, 1, 'layout', '2005-12-21 19:17:16 [2] |', '', 2, '2005-09-19', '23:38:29'),
+(228, 'menu_misc', 'all', '<div class="navTitle">Latest Update</div> \r\n <ol>\r\n <li><div style="text-align:center;">[#roscms_date] [#roscms_time]</div></li>\r\n </ol> \r\n <p> </p>\r\n </td>\r\n\r\n <td id="content"><div class="contentSmall"> ', 1, 1, 1, 'default', '', '', 2, '2005-12-21', '19:16:47'),
+(229, 'sidebar_right', 'all', '</div></td>\r\n\r\n <td id="rightNav">\r\n<h1>Latest Release</h1>\r\n<p><strong>Version [#inc_reactos_version]</strong>\r\n</p>\r\n', 8, 1, 1, 'default', '2005-12-21 19:50:38 [2] |', '', 2, '2005-12-21', '19:18:36'),
+(230, 'contmenu_home', 'all', '<div class="navTitle">Home</div> \r\n<ol> \r\n <li><a href="[#link_index]">Front Page</a></li>\r\n <li><a href="[#link_news]">News</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li>\r\n</ol>\r\n<p></p>', 4, 1, 1, 'default', '2005-12-21 20:02:26 [2] |', '', 2, '2005-12-21', '19:20:34'),
+(120, 'menu_search', 'all', ' <div class="navTitle">Search</div> \r\n <div class="navBox"><form method="get" action="http://www.google.com/search" style="padding:0;margin:0">\r\n <div style="text-align:center;">\r\n\r\n <input name="q" value="" size="12" maxlength="80" class="searchInput" type="text" /><input name="domains" value="http://www.reactos.org" type="hidden" /><input name="sitesearch" value="http://www.reactos.org" type="hidden" />\r\n <input name="btnG" value="Go" type="submit" class="button" />\r\n\r\n </div></form>\r\n </div>\r\n<p></p>', 2, 1, 1, 'default', '', '', 2, '2005-11-09', '23:04:31'),
+(128, 'index', 'de', '<h1>ReactOS Content Management System - Test Page</h1>\r\n<p>German start page</p>', 1, 1, 1, 'default', '', 'richtext', 1, '2005-11-29', '20:14:46'),
+(152, 'menu_language', 'all', '<div class="navTitle">Language</div> \r\n <div class="navBox"> \r\n <form method="post" action="[#roscms_path_homepage]?page=[#roscms_pagename]&forma=[#roscms_format]&lang=" style="padding:0;margin:0">\r\n <div style="text-align:center;"> \r\n <select id="lang" size="1" name="lang" class="selectbox" style="width:110px" onchange="window.open(''[#roscms_path_homepage]?page=[#roscms_pagename]&forma=[#roscms_format]&lang='' + this.options[this.selectedIndex].value,''_main'')">\r\n <optgroup label="current language"> \r\n <option value="#" selected="selected">[#roscms_language]</option>\r\n </optgroup>\r\n <optgroup label="most popular"> \r\n <option value="en">English</option>\r\n <option value="de">Deutsch (German)</option>\r\n </optgroup>\r\n </select>\r\n <input name="langsubmit" type="submit" id="langsubmit" value=">" />\r\n </div>\r\n </form>\r\n </div>\r\n<p></p>', 3, 1, 1, 'layout', '2005-12-21 20:00:23 [2] |', '', 2, '2005-11-10', '21:48:20'),
+(220, 'contmenu_home', 'de', '<div class="navTitle">Startseite</div> \r\n<ol> \r\n <li><a href="[#link_index]">Startseite</a></li>\r\n <li><a href="[#link_news]">Neuigkeiten</a></li>\r\n <li><a href="[#link_sitemap]">Sitemap</a></li> \r\n</ol>\r\n<p></p>', 3, 1, 1, 'default', '2005-12-21 20:02:35 [2] |', '', 15, '2005-12-07', '21:24:40'),
+(222, 'sidebar_right', 'all', '</div></td>\r\n\r\n <td id="rightNav">\r\n[#inc_javascript_screenshot]\r\n <a href="[#link_screenshots]">More Screenshots</a><br />\r\n <a href="[#link_tour]">Take a look at the ReactOS Tour</a>\r\n</div><br />\r\n<h1>Latest Release</h1>\r\n<p><strong>Version [#inc_reactos_version]</strong><br />\r\n <a href="[#link_download]">Download Now!</a><br />\r\n <a href="[#link_dev_changelogs]">Changelog</a>\r\n</p>\r\n[#inc_template_news_latest]\r\n[#inc_template_newsletter_latest]\r\n<div class="contentSmall">\r\n <span class="contentSmallTitle">Developer Quotes</span>\r\n\r\n[#inc_javascript_quote]', 7, 0, 1, 'default', '', '', 2, '2005-12-07', '21:30:53');
+
-- --------------------------------------------------------
--
--- `dyn_content`
+-- Table structure for table `dyn_content`
--
DROP TABLE IF EXISTS `dyn_content`;
@@ -68,12 +69,18 @@
`dyn_content_date` date NOT NULL default '0000-00-00',
`dyn_content_time` time NOT NULL default '00:00:00',
PRIMARY KEY (`dyn_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents' AUTO_INCREMENT=0 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contents';
+--
+-- Data for table`dyn_content`
+--
+
+INSERT INTO `dyn_content` (`dyn_id`, `dyn_content_id`, `dyn_content_nr`, `dyn_content_name`, `dyn_content_lang`, `dyn_content_text1`, `dyn_content_text2`, `dyn_content_text3`, `dyn_content_text4`, `dyn_content_version`, `dyn_content_active`, `dyn_content_visible`, `dyn_content_editor`, `dyn_content_usrname_id`, `dyn_content_date`, `dyn_content_time`) VALUES (28, 1, 1, 'news_page', 'all', 'RosCMS test news', '', 'RosCMS test news description', '<p><b><u>RosCMS</u></b> test news content</p> ...', 0, 1, 1, '', 2, '2005-12-21', '19:53:14');
+
-- --------------------------------------------------------
--
--- `include_text`
+-- Table structure for table `include_text`
--
DROP TABLE IF EXISTS `include_text`;
@@ -90,12 +97,25 @@
`inc_date` date NOT NULL default '0000-00-00',
`inc_time` time NOT NULL default '00:00:00',
PRIMARY KEY (`inc_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Replace words with text phrases' AUTO_INCREMENT=0 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Replace words with text phrases';
+--
+-- Data for table`include_text`
+--
+
+INSERT INTO `include_text` (`inc_id`, `inc_level`, `inc_word`, `inc_text`, `inc_lang`, `inc_extra`, `inc_vis`, `inc_seclevel`, `inc_usrname_id`, `inc_date`, `inc_time`) VALUES (48, 15, 'template_news_detail', '<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n $query_content = mysql_query("SELECT * \r\n FROM `dyn_content` \r\n WHERE 1 AND `dyn_content_name` = ''news_page'' AND `dyn_content_id` = ''$roscms_template_var_pageid''\r\n ORDER BY `dyn_content_nr` ASC Limit 1") ;\r\n \r\n $result_content = mysql_fetch_array($query_content);\r\n $roscms_usrnameid = $result_content["dyn_content_usrname_id"];\r\n $query_usraccount= mysql_query("SELECT * \r\n FROM `users` \r\n WHERE `user_id` = ".$roscms_usrnameid." LIMIT 1");\r\n $result_usraccount=mysql_fetch_array($query_usraccount);\r\n?>\r\n<h1><a href="[#link_index]">Home</a> > <a href="[#link_news]">ReactOS News</a> > News: <?php echo $result_content["dyn_content_text1"]; ?> #<?php echo $roscms_template_var_pageid; ?></h1> \r\n <p><strong><?php echo $result_content["dyn_content_text3"]; ?></strong></p>\r\n <p><i>by <?php echo $result_usraccount[''user_name'']; ?> on <?php echo $result_content[''dyn_content_date'']; ?></i></p>\r\n<?php echo $result_content[''dyn_content_text4'']; ?>\r\n<p><a href="[#link_news]">News Archive</a></p>', 'all', 'template_php', 1, 50, 1, '2005-12-21', '19:55:14'),
+(19, 10, 'path_homepage_media', '[#roscms_path_homepage]media/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35'),
+(20, 15, 'path_homepage_media_pictures', '[#roscms_path_homepage]media/pictures/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35'),
+(23, 15, 'template_news', '<h1><a href="[#link_index]">Home</a> > ReactOS News</h1>\r\n<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n\r\n $query_content = mysql_query("SELECT * \r\n FROM `dyn_content` \r\n WHERE 1 AND `dyn_content_name` = ''news_page'' AND `dyn_content_nr` = ''1''\r\n ORDER BY `dyn_content_id` DESC ") ;\r\n \r\n while($result_content = mysql_fetch_array($query_content)) { // content\r\n $roscms_usrnameid = $result_content["dyn_content_usrname_id"];\r\n $query_usraccount= mysql_query("SELECT * \r\n FROM `users` \r\n WHERE `user_id` = ".$roscms_usrnameid." LIMIT 0 , 1");\r\n $result_usraccount=mysql_fetch_array($query_usraccount);\r\n?>\r\n\r\n<p><b><a href="<?php echo "[#link_".$result_content["dyn_content_name"]."_".$result_content["dyn_content_id"]."]"; ?>"><?php echo $result_content["dyn_content_text1"]; ?></a></b>\r\n<br><?php echo $result_content[''dyn_content_text3'']; ?>\r\n<br><i>by <?php echo $result_usraccount[''user_name'']; ?> on <?php echo $result_content[''dyn_content_date'']; ?></i></p>\r\n <?php \r\n } // end while\r\n?>\r\n', 'all', 'template_php', 1, 50, 0, '2005-07-30', '11:50:18'),
+(26, 0, 'reactos_version', '0.2.8', 'all', '', 1, 50, 1, '2005-08-13', '16:18:56'),
+(27, 15, 'template_sitemap', '<h1><a href="[#link_index]">Home</a> > Sitemap</h1>\r\n<?php\r\n if ( !defined("ROSCMS_SYSTEM") ) {\r\n define ("ROSCMS_SYSTEM", "Version 0.1"); // to prevent hacking activity\r\n }\r\n\r\n include("db/connect_db.inc.php"); // database connection script\r\n\r\n\r\n $query_sitemap = mysql_query("SELECT * \r\n FROM pages\r\n WHERE page_active = ''1'' AND page_visible = ''1'' AND (page_language = ''all'' OR page_language = ''en'')\r\n ORDER BY ''page_name'' ASC") ;\r\n \r\n while($result_sitemap = mysql_fetch_array($query_sitemap)) { // content\r\n if ($result_sitemap[''page_description''] != "") {\r\n?>\r\n\r\n<p><b><a href="<?php echo "[#link_".$result_sitemap[''page_name'']."]"; ?>"><?php echo ucfirst($result_sitemap[''page_title'']); ?></a></b>\r\n<br><i><?php echo $result_sitemap[''page_description'']; ?></i></p>\r\n <?php\r\n } \r\n } // end while\r\n?>\r\n', 'all', 'template_php', 1, 50, 0, '2005-08-13', '20:58:04'),
+(34, 0, 'charset', 'utf-8', 'all', '', 1, 50, 1, '2005-08-27', '15:54:16'),
+(39, 15, 'path_homepage_media_screenshots', '[#roscms_path_homepage]media/screenshots/', 'all', '', 1, 50, 0, '2005-07-13', '18:00:35');
+
-- --------------------------------------------------------
--
--- `languages`
+-- Table structure for table `languages`
--
DROP TABLE IF EXISTS `languages`;
@@ -105,10 +125,18 @@
`lang_level` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='available languages';
+--
+-- Data for table`languages`
+--
+
+INSERT INTO `languages` (`lang_id`, `lang_name`, `lang_level`)
+VALUES ('en', 'English', 10),
+('de', 'German', 8);
+
-- --------------------------------------------------------
--
--- `pages`
+-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
@@ -117,6 +145,7 @@
`page_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`page_language` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`pages_extra` varchar(20) collate utf8_unicode_ci NOT NULL default '',
+ `pages_extention` varchar(10) collate utf8_unicode_ci NOT NULL default 'default',
`page_text` text collate utf8_unicode_ci NOT NULL,
`page_version` int(11) NOT NULL default '0',
`page_active` tinyint(4) NOT NULL default '0',
@@ -129,12 +158,21 @@
`page_title` varchar(150) collate utf8_unicode_ci NOT NULL default '',
`page_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
PRIMARY KEY (`page_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Pages' AUTO_INCREMENT=0 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Pages';
+--
+-- Data for table`pages`
+--
+
+INSERT INTO `pages` (`page_id`, `page_name`, `page_language`, `pages_extra`, `pages_extention`, `page_text`, `page_version`, `page_active`, `page_visible`, `page_usrname_id`, `page_date`, `page_time`, `page_generate_usrid`, `page_generate_timestamp`, `page_title`, `page_description`) VALUES (6, 'news_page', 'all', 'dynamic', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_news_detail]\r\n\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-09-12', '18:50:20', 1, '1135191757', 'News', ''),
+(7, 'news', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_news]\r\n\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-09-12', '18:50:28', 1, '1135191757', 'News', 'News page: latest ReactOS news, rss news feed'),
+(9, 'index', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#cont_index]\r\n\r\n[#cont_sidebar_right]\r\n[#cont_bottom]', 1, 1, 1, 1, '2005-12-21', '19:21:43', 1, '1135191757', 'Frontpage', 'Frontpage'),
+(91, 'sitemap', 'all', '', 'default', '[#cont_head]\r\n[#cont_menu_top]\r\n[#cont_menu_side]\r\n\r\n[#cont_contmenu_home]\r\n\r\n[#cont_menu_search]\r\n[#cont_menu_language]\r\n[#cont_menu_misc]\r\n\r\n[#inc_template_sitemap]\r\n\r\n[#cont_bottom]\r\n', 1, 1, 1, 1, '2005-12-21', '19:58:07', 1, '1135191757', 'Sitemap', 'Sitemap page');
+
-- --------------------------------------------------------
--
--- `roscms_security_log`
+-- Table structure for table `roscms_security_log`
--
DROP TABLE IF EXISTS `roscms_security_log`;
@@ -152,12 +190,17 @@
`roscms_sec_log_time` time NOT NULL default '00:00:00',
`roscms_sec_log_visible` int(11) NOT NULL default '1',
PRIMARY KEY (`roscms_sec_log_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS Security Log' AUTO_INCREMENT=0 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS Security Log';
+--
+-- Data for table`roscms_security_log`
+--
+
+
-- --------------------------------------------------------
--
--- `subsys_mappings`
+-- Table structure for table `subsys_mappings`
--
DROP TABLE IF EXISTS `subsys_mappings`;
@@ -168,10 +211,11 @@
PRIMARY KEY (`map_roscms_userid`,`map_subsys_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+
-- --------------------------------------------------------
--
--- `user_sessions`
+-- Table structure for table `user_sessions`
--
DROP TABLE IF EXISTS `user_sessions`;
@@ -181,13 +225,15 @@
`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';
+
-- --------------------------------------------------------
--
--- `usergroup_members`
+-- Table structure for table `usergroup_members`
--
DROP TABLE IF EXISTS `usergroup_members`;
@@ -196,10 +242,21 @@
`usergroupmember_usergroupid` varchar(10) collate utf8_unicode_ci NOT NULL default 'user'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+--
+-- Data for table`usergroup_members`
+--
+
+INSERT INTO `usergroup_members` (`usergroupmember_userid`, `usergroupmember_usergroupid`)
+VALUES (1, 'ros_sadmin'),
+(1, 'developer'),
+(1, 'translator'),
+(1, 'moderator'),
+(1, 'user');
+
-- --------------------------------------------------------
--
--- `usergroups`
+-- Table structure for table `usergroups`
--
DROP TABLE IF EXISTS `usergroups`;
@@ -213,10 +270,23 @@
UNIQUE KEY `usrgroup_name` (`usrgroup_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+--
+-- Data for table`usergroups`
+--
+
+INSERT INTO `usergroups` (`usrgroup_name_id`, `usrgroup_name`, `usrgroup_intern_id`, `usrgroup_securitylevel`, `usrgroup_description`) VALUES ('ros_admin', 'Administrator', 'roscms_usrgrp_admin', 70, 'Administrator-Group: manage the ReactOS homepage (content, database)'),
+('user', 'User', 'roscms_usrgrp_user', 0, 'Normal Visitors'),
+('developer', 'Developer', 'roscms_usrgrp_dev', 50, 'ReactOS Developer: persons with svn commit access'),
+('moderator', 'Moderator', 'roscms_usrgrp_team', 20, 'Homepage Moderators: for compatibility & package manager database, etc.'),
+('translator', 'Translator', 'roscms_usrgrp_trans', 10, 'Homepage Translators: translate the homepage content'),
+('ros_sadmin', 'Super-Administrator', 'roscms_usrgrp_sadmin', 100, 'Super-Administrator-Group: manage the ReactOS homepage (content, database, etc.); only persons who know what they are doing ...'),
+('mediateam', 'Media-Team', 'roscms_usrgrp_team', 20, 'Media-Team members: UI-Team, etc.'),
+('test', 'Test-User', 'roscms_usrgrp_team', 10, 'RosCMS tester group');
+
-- --------------------------------------------------------
--
--- `users`
+-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
@@ -239,11 +309,18 @@
`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 'true',
+ `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`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='RosCMS User Table' AUTO_INCREMENT=0 ;
+ 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';
+--
+-- Data for table`users`
+--
+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 (1, 'roscms_user', '', '', '', '2005-12-08 20:02:50', 1, 'yes', 'yes', '2005-08-20 20:18:06', 'ReactOS Content Management System Default User', 'ros-dev@reactos.org', 'http://www.reactos.org', 'en', '', '', '', 'RosCMS Default User', 'true', 'false', 'false', 'true');
\ No newline at end of file