RosCMS update:
* improve pages and content "view/edit/save" functions * improve "group members" interface * and some minor changes Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_content_edit.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_edit.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_save.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_accounts.php Added: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php Added: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members_edit.ph p Deleted: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_memebers.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/inc_description_table.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/website_status.php _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -147,7 +147,24 @@
include("inc/admin_user_groups.php"); break; case "usrgrpmbr": - include("inc/admin_user_group_memebers.php"); + if ($rpm_sec2=="view" || $rpm_sec2=="") { + include("inc/admin_user_group_members.php"); + } + else if ($rpm_sec2=="edit") { + include("inc/admin_user_group_members_edit.php"); + } + else if ($rpm_sec2=="add") { + include("inc/admin_user_group_members_edit.php"); + } + else if ($rpm_sec2=="save") { + include("inc/admin_user_group_members_edit.php"); + } + else if ($rpm_sec2=="insert") { + include("inc/admin_user_group_members_edit.php"); + } + else if ($rpm_sec2=="delete") { + include("inc/admin_user_group_members_edit.php"); + } break; case "sessions": include("inc/admin_user_sessions.php"); _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_content_edit.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_content_edit.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_content_edit.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -66,7 +66,7 @@
<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. "media")</font></div></td> + ] (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> @@ -182,9 +182,35 @@ </optgroup> </select> </td> </tr> + <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> + </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> + </tr> + <tr> + <td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Username</strong></font></div></td> + <td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif"><?php + + if ($result_content['content_usrname_id']) { + $query_user_name = mysql_query("SELECT * + FROM `users` + WHERE `user_id` = ". $result_content['content_usrname_id'] ." ;") ; + $result_user_name = mysql_fetch_array($query_user_name); + + echo "<b>".$result_user_name['user_name']."</b> (".$result_user_name['user_fullname'].") <a href='?page=user&sec=profil&sec2=".$result_content['content_usrn ame_id']."' target='_blank'>[Profile]</a>"; + } + ?></font></td> + </tr> <tr> <td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Date</strong></font></div></td> - <td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif"> + <td valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif"> <?php echo $result_content['content_date']; ?> @@ -192,7 +218,7 @@ </tr> <tr> <td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Time</strong></font></div></td> - <td valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif"> + <td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif"> <?php echo $result_content['content_time']; ?> @@ -303,6 +329,8 @@ $content_act=""; $content_extra=""; $content_savemode=""; + $content_typea=""; + $content_desca="";
if (array_key_exists("txt_contentid", $_POST)) $content_contentid=$_POST['txt_contentid']; if (array_key_exists("txt_langa", $_POST)) $content_langa=$_POST['txt_langa']; @@ -310,7 +338,10 @@ if (array_key_exists("content_active", $_POST)) $content_act=$_POST['content_active']; if (array_key_exists("txt_extra", $_POST)) $content_extra=$_POST['txt_extra']; if (array_key_exists("content_rad_opt", $_POST)) $content_savemode=$_POST['content_rad_opt']; + if (array_key_exists("txt_content_type", $_POST)) $content_typea=$_POST['txt_content_type']; + if (array_key_exists("txt_content_desc", $_POST)) $content_desca=$_POST['txt_content_desc'];
+ //echo "<br>".$content_act; if ($content_langa == "") { $content_langa = "all"; @@ -363,7 +394,7 @@
if ($content_savemode == "update") { - $content_description = date("Y-m-d H:i:s")." [".$roscms_intern_account_id."] "; + $content_description = date("Y-m-d H:i:s")." [".$roscms_intern_account_id."] | ".$content_desca; $content_posta="UPDATE `content` SET `content_name` = '". mysql_escape_string($content_contentid) ."', `content_lang` = '". mysql_escape_string($content_langa) ."', @@ -371,12 +402,14 @@ `content_text` = '". mysql_real_escape_string($content_data) ."', `content_visible` = '". mysql_escape_string($content_vis) ."', `content_active` = '". mysql_escape_string($content_act) ."', - `content_description` = '". mysql_escape_string($content_description) ."' + `content_description` = '". mysql_escape_string($content_description) ."', + `content_type` = '". mysql_escape_string($content_description) ."' WHERE `content_id` = '$rpm_db_id' LIMIT 1 ;"; //`content_active` = '1', //`content_usrname_id` = '$roscms_intern_account_id', //`content_date` = CURDATE( ) , //`content_time` = CURTIME( ) + $content_post_lista=mysql_query($content_posta); } elseif ($content_savemode == "translate") { _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_edit.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_edit.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_edit.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -122,9 +122,9 @@
?> </font></td> </tr> - <tr> + <tr> <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="#EEEEEE"><font face="Arial, Helvetica, sans-serif"> + <td valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif"> <?php if ($result_page['page_visible'] == 1) { echo ' <input name="page_visible" type="radio" value="yes" checked> yes <input type="radio" name="page_visible" value="no"> no'; @@ -133,6 +133,19 @@ echo ' <input name="page_visible" type="radio" value="yes"> yes <input type="radio" name="page_visible" value="no" checked> no'; } ?> +</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_page['page_active'] == 1) { + echo ' <input name="page_active" type="radio" value="yes" checked> yes <input type="radio" name="page_active" value="no"> no'; + } + else { + echo ' <input name="page_active" type="radio" value="yes"> yes <input type="radio" name="page_active" value="no" checked> no'; + } + ?> </font></td> </tr> <tr> @@ -158,6 +171,12 @@ </optgroup> </select> </td> </tr> + <tr> + <td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Extention</strong></font></div></td> + <td valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif"> + <input name="txt_pageextent" type="text" id="txt_pageextent" value="<?php echo $result_page['pages_extention']; ?>" size="10" maxlength="10"> +("default", "xml", ...) </font></td> + </tr> <tr> <td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Date</strong></font></div></td> <td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif"> _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_save.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_save.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_pages_save.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -50,7 +50,10 @@
$page_savemode=$_POST['page_rad_opt']; $page_pagetitle=$_POST['txt_pagetitle']; $page_pagedesc=$_POST['txt_pagedesc']; + $page_pageextention=$_POST['txt_pageextent']; + $page_pageactive=$_POST['page_active']; + if ($page_langa == "") { $page_langa = "all"; } @@ -61,6 +64,13 @@ else { $page_vis="0"; } + + if ($page_pageactive == "yes") { + $page_pageactive="1"; + } + else { + $page_pageactive="0"; + } $page_data=$_POST['textarea_pages'];
@@ -73,6 +83,8 @@ `page_description` = '". mysql_real_escape_string($page_pagedesc) ."', `page_text` = '". mysql_real_escape_string($page_data) ."', `page_visible` = '". mysql_real_escape_string($page_vis) ."', + `pages_extention` = '". mysql_real_escape_string($page_pageextention) ."', + `page_active` = '". mysql_real_escape_string($page_pageactive) ."', `page_date` = CURDATE( ) , `page_time` = CURTIME( ) WHERE `page_id` = '$rpm_db_id' LIMIT 1 ;"; //`page_active` = '1', _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_accounts.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_user_accounts.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_accounts.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -168,9 +168,62 @@
else { echo '<a href="?page=admin&sec=users&sec2=view&sort=language&filt ='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">languag e</a>'; } + echo ' | '; + if ($rpm_sort == "occupation") { + echo '<b>occupation</b>'; + $ros_cms_intern_users_sortby="user_occupation"; + $ros_cms_intern_users_sort="ASC"; + } + else { + echo '<a href="?page=admin&sec=users&sec2=view&sort=occupation&fi lt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">occup ation</a>'; + } + echo ' | '; + if ($rpm_sort == "counter") { + echo '<b>counter</b>'; + $ros_cms_intern_users_sortby="user_login_counter"; + $ros_cms_intern_users_sort="DESC"; + } + else { + echo '<a href="?page=admin&sec=users&sec2=view&sort=counter&filt= '.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">counter< /a>'; + } echo '</p>';
?> + +<?php + +// Setting: +$roscms_intern_items_per_page = 50; + + +$roscms_SET_curpos = ""; +if (array_key_exists("curpos", $_GET)) $roscms_SET_curpos=htmlspecialchars($_GET["curpos"]); +if (!$roscms_SET_curpos) { + $roscms_SET_curpos = 0; +} + +$query_count_cat=mysql_query("SELECT COUNT('user_id') + FROM `users` + WHERE `user_account_enabled` = 'yes' + AND `user_account_hidden` = 'no' + ORDER BY `user_name` ASC ;"); +$result_count_cat = mysql_fetch_row($query_count_cat); + + echo "<p align='center'>"; + $j=0; + for ($i=0; $i < $result_count_cat[0]; $i += $roscms_intern_items_per_page) { + $j++; + if ($roscms_SET_curpos == $i) { + echo "<b>".$j."</b> "; + } + else { + echo "<a href='?page=admin&sec=users&sec2=view&sort=".$rpm_sort."& ;filt=".$rpm_filt."&opt=".$rpm_opt."&langid=".$rpm_lang_id."& ;curpos=".$i."'>".$j."</a> "; + } + } + $j=0; + echo "</p>"; + +?> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr bgcolor="#5984C3"> <td width="9%"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Action</strong></font></div></td> @@ -192,13 +245,13 @@ $query_page = mysql_query("SELECT * FROM users $ros_cms_intern_users_filt $ros_cms_intern_users_lang - ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort") ; + ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort LIMIT ". $roscms_SET_curpos ." , ". $roscms_intern_items_per_page ." ;") ; } else { $query_page = mysql_query("SELECT * FROM users $ros_cms_intern_users_filt AND user_account_hidden != 0 $ros_cms_intern_users_lang - ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort") ; + ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort LIMIT ". $roscms_SET_curpos ." , ". $roscms_intern_items_per_page ." ;") ; }
$farbe1=$roscms_intern_color1; @@ -220,8 +273,8 @@
echo $farbe2;
$farbe = $farbe2; } - ?>" title="RosCMS action buttons: * View account * Delete account * Email * Website"> - <div align="center"><img src="images/view.gif" alt="View" width="19" height="18" border="0"> + ?>"> + <div align="center"><a href="<?php echo "?page=user&sec=profil&sec2=".$result_page['user_id']; ?>"><img src="images/view.gif" alt="Profil" width="19" height="18" border="0"></a> <?php if ($result_page['user_email'] != "") { ?> @@ -289,6 +342,20 @@ } // end while ?> </table> +<p align="center"><b><?php + + echo ($roscms_SET_curpos+1)." to "; + + if (($roscms_SET_curpos + $roscms_intern_items_per_page) > $result_count_cat[0]) { + echo $result_count_cat[0]; + } + else { + echo ($roscms_SET_curpos + $roscms_intern_items_per_page); + } + + echo " of ".$result_count_cat[0]; + +?></b></p> <?php $roscms_infotable = "user"; include("inc/inc_description_table.php"); _____
Added: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -0,0 +1,251 @@
+<?php + + // To prevent hacking activity: + if ( !defined('ROSCMS_SYSTEM') OR !defined('ROSCMS_SYSTEM_ADMIN') ) + { + if ( !defined('ROSCMS_SYSTEM_LOG') ) { + define ("ROSCMS_SYSTEM_LOG", "Hacking attempt"); + } + $seclog_section="roscms_admin_interface"; + $seclog_level="50"; + $seclog_reason="Hacking attempt: admin_users.php"; + define ("ROSCMS_SYSTEM", "Hacking attempt"); + include('securitylog.php'); // open security log + die("Hacking attempt"); + } + +?> +<div class="contentSmall"> <span class="contentSmallTitle">Admin Interface - Group Members</span> + <ul> + <li><strong>Group Members</strong></li> + </ul> + <p>Action: <a href="?page=admin&sec=usrgrpmbr&sec2=add&sec3=new&db_id= new">New Membership</a> | <a href="?page=admin&sec=usrgrpmbr&sec2=view">reset + filters & sort</a></p> + <?php + + + if ($rpm_lang_id == "") { + $rpm_lang_id="all"; + } + //echo '<p>Language: '; + //echo '<b>All</b>'; + $ros_cms_intern_users_lang = " "; + //echo '</p>'; + + if ($rpm_filt == "") { + $rpm_filt="active"; + } + //echo '<p>Filter: '; + //echo '<b>active</b>'; + $ros_cms_intern_users_filt = " "; + //echo '</p>'; + + if ($rpm_filt == "") { + $rpm_filt="active"; + } + echo '<p>Filter: '; + if ($rpm_filt == "active") { + echo '<b>all</b>'; + $ros_cms_intern_users_filt = " "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=active&langid='.$rpm_lang_id.'">all</a>'; + } + echo ' | '; + if ($rpm_filt == "sadmin") { + echo '<b>super admin</b>'; + $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'ros_sadmin' "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=sadmin&langid='.$rpm_lang_id.'">super admin</a>'; + } + echo ' | '; + if ($rpm_filt == "admin") { + echo '<b>admin</b>'; + $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'ros_admin' "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=admin&langid='.$rpm_lang_id.'">admin</a>'; + } + echo ' | '; + if ($rpm_filt == "dev") { + echo '<b>developer</b>'; + $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'developer' "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=dev&langid='.$rpm_lang_id.'">developer</a>'; + } + echo ' | '; + if ($rpm_filt == "mod") { + echo '<b>moderator</b>'; + $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'moderator' "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=mod&langid='.$rpm_lang_id.'">moderator</a>'; + } + echo ' | '; + if ($rpm_filt == "trans") { + echo '<b>translator</b>'; + $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'translator' "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=trans&langid='.$rpm_lang_id.'">translator</a>'; + } + echo ' | '; + if ($rpm_filt == "user") { + echo '<b>normal user</b>'; + $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'user' "; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=user&langid='.$rpm_lang_id.'">normal user</a>'; + } + + if ($rpm_sort == "") { + $rpm_sort="id"; + } + echo '<p>Sorted by: '; + if ($rpm_sort == "id") { + echo '<b>user ID</b>'; + $ros_cms_intern_users_sortby="usergroupmember_userid"; + $ros_cms_intern_users_sort="ASC"; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=id&filt=' .$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">user ID</a>'; + } + echo ' | '; + if ($rpm_sort == "group") { + echo '<b>group ID</b>'; + $ros_cms_intern_users_sortby="usergroupmember_usergroupid"; + $ros_cms_intern_users_sort="ASC"; + } + else { + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=group&fil t='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">group ID</a>'; + } + echo '</p>'; + +?> +<?php + +// Setting: +$roscms_intern_items_per_page = 50; + + +$roscms_SET_curpos = ""; +if (array_key_exists("curpos", $_GET)) $roscms_SET_curpos=htmlspecialchars($_GET["curpos"]); +if (!$roscms_SET_curpos) { + $roscms_SET_curpos = 0; +} + +$query_count_cat=mysql_query("SELECT COUNT('usergroupmember_userid') + FROM `usergroup_members` + " . $ros_cms_intern_users_filt . " + ORDER BY `usergroupmember_userid` ASC ;"); +$result_count_cat = mysql_fetch_row($query_count_cat); + + echo "<p align='center'>"; + $j=0; + for ($i=0; $i < $result_count_cat[0]; $i += $roscms_intern_items_per_page) { + $j++; + if ($roscms_SET_curpos == $i) { + echo "<b>".$j."</b> "; + } + else { + echo "<a href='?page=admin&sec=usrgrpmbr&sec2=view&sort=".$rpm_sort." &filt=".$rpm_filt."&opt=".$rpm_opt."&langid=".$rpm_lang_id." &curpos=".$i."'>".$j."</a> "; + } + } + $j=0; + echo "</p>"; + +?> +<table width="100%" border="0" cellpadding="1" cellspacing="1"> + <tr bgcolor="#5984C3"> + <td width="6%"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Action</strong></font></div></td> + <td width="4%" bgcolor="#5984C3"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>ID</strong></font></div></td> + <td width="20%" bgcolor="#5984C3"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Nick</strong></font></div></td> + <td width="20%"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Usergroup</strong></font></div></td> + <td width="50%" bgcolor="#5984C3"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Usergroup + description</strong></font></div></td> + </tr> + <?php + + if($roscms_intern_account_level==100) { + $query_page = mysql_query("SELECT * + FROM usergroup_members + $ros_cms_intern_users_filt $ros_cms_intern_users_lang + ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort LIMIT ". $roscms_SET_curpos ." , ". $roscms_intern_items_per_page ." ;") ; + } + else { + $query_page = mysql_query("SELECT * + FROM usergroup_members + $ros_cms_intern_users_filt AND user_account_hidden != 0 $ros_cms_intern_users_lang + ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort LIMIT ". $roscms_SET_curpos ." , ". $roscms_intern_items_per_page ." ;") ; + } + + $farbe1="#E2E2E2"; + $farbe2="#EEEEEE"; + $zaehler="0"; + //$farbe="#CCCCC"; + + while($result_page = mysql_fetch_array($query_page)) { // users +?> + <tr> + <td width="9%" valign="middle" bgcolor="<?php + $zaehler++; + if ($zaehler == "1") { + echo $farbe1; + $farbe = $farbe1; + } + elseif ($zaehler == "2") { + $zaehler="0"; + echo $farbe2; + $farbe = $farbe2; + } + ?>"> + <div align="center"><a href="?page=admin&sec=usrgrpmbr&sec2=edit&sec3=<?php echo $result_page['usergroupmember_usergroupid']; ?>&db_id=<?php echo $result_page['usergroupmember_userid']; ?>"><img src="images/view.gif" alt="Edit Membership" width="19" height="18" border="0"></a> <a href="?page=admin&sec=usrgrpmbr&sec2=add&sec3=new&db_id= <?php echo $result_page['usergroupmember_userid']; ?>"><img src="images/tool.gif" alt="Add Membership" width="19" height="18" border="0"></a> <a href="?page=admin&sec=usrgrpmbr&sec2=delete&sec3=<?php echo $result_page['usergroupmember_usergroupid']; ?>&db_id=<?php echo $result_page['usergroupmember_userid']; ?>"><img src="images/delete.gif" alt="Add Membership" width="19" height="18" border="0"></a></div></td> + <td width="7%" valign="middle" bgcolor="<?php echo $farbe; ?>"> <div align="center"><font face="Arial, Helvetica, sans-serif"><?php echo "<b>".$result_page['usergroupmember_userid']."</b>"; ?></font></div></td> + <td width="10%" valign="middle" bgcolor="<?php echo $farbe; ?>"><font face="Arial, Helvetica, sans-serif"><?php + $query_usra = mysql_query("SELECT user_id, user_name FROM users WHERE user_id = '".$result_page['usergroupmember_userid']."'") or die('DB error (membership script)!'); + $result_usra = mysql_fetch_array($query_usra); // or die('DB error (show_sessions script)'); + + echo $result_usra['user_name']." <a href='?page=user&sec=profil&sec2=".$result_page['usergroupmember _userid']."'>[Profil]</a>"; ?> + </font></td> + <td width="13%" valign="middle" bgcolor="<?php echo $farbe; ?>" title="<?php echo $result_page['usergroupmember_usergroupid']; ?>"><div align="left"><font face="Arial, Helvetica, sans-serif"> + <?php + //echo "SELECT usrgroup_name_id, usrgroup_name FROM usergroups WHERE usrgroup_name_id = '".$result_page['usergroupmember_usergroupid']."'<br>"; + $query_grpb = mysql_query("SELECT usrgroup_name_id, usrgroup_name, usrgroup_description FROM usergroups WHERE usrgroup_name_id = '".$result_page['usergroupmember_usergroupid']."'") or die('DB error (membership script)!'); + $result_grpb = mysql_fetch_array($query_grpb) or die('DB error (membership script)'); + + echo $result_grpb['usrgroup_name']; + ?> + </font></div></td> + <td width="15%" valign="middle" bgcolor="<?php echo $farbe; ?>"> <font face="Arial, Helvetica, sans-serif"><?php + echo substr(htmlentities($result_grpb['usrgroup_description'], ENT_QUOTES), 0, 50)."..."; + ?></font></tr> + <?php + } // end while +?> + </table> +<p align="center"><b><?php + + echo ($roscms_SET_curpos+1)." to "; + + if (($roscms_SET_curpos + $roscms_intern_items_per_page) > $result_count_cat[0]) { + echo $result_count_cat[0]; + } + else { + echo ($roscms_SET_curpos + $roscms_intern_items_per_page); + } + + echo " of ".$result_count_cat[0]; + +?></b></p> + <?php + $roscms_infotable = "user"; + include("inc/inc_description_table.php"); +?> +</div> Property changes on: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php ___________________________________________________________________ Name: svn:eol-style + native _____
Added: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members_edit.ph p --- trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members_edit.ph p 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members_edit.ph p 2005-12-06 19:57:28 UTC (rev 19938) @@ -0,0 +1,176 @@
+<?php +if ($rpm_sec2=="delete") { +?> +<div class="contentSmall"> <span class="contentSmallTitle">Admin Interface - Group Members - Delete Membership</span> + <ul> + <li><strong><a href="?page=admin&sec=usrgrpmbr&sec2=view">Group Members</a></strong> + <ul> + <li>Delete Membership</li> + </ul> + </li> + </ul> +<?php + $spdas="DELETE FROM `usergroup_members` WHERE `usergroupmember_userid` = ".mysql_real_escape_string($rpm_db_id)." AND `usergroupmember_usergroupid` = '".mysql_real_escape_string($rpm_sec3)."' LIMIT 1;"; + $spdaslists=mysql_query($spdas); + echo "<p>The group membership '".$rpm_sec3."' for the user '".$rpm_db_id."' has been deleted!</p>"; +} +else { +?> + +<div class="contentSmall"> <span class="contentSmallTitle">Admin Interface - Group Members - <?php if ($rpm_sec2=="edit") { echo "Edit"; } elseif ($rpm_sec2=="add") { echo "Add"; } ?> Membership</span> + <ul> + <li><strong><a href="?page=admin&sec=usrgrpmbr&sec2=view">Group Members</a></strong> + <ul> + <li><?php if ($rpm_sec2=="edit") { echo "Edit"; } elseif ($rpm_sec2=="add") { echo "Add"; } ?> Membership</li> + </ul> + </li> + </ul> +<?php + + $query_contenta = mysql_query("SELECT * FROM users WHERE user_id = '".$roscms_intern_account_id."'") ; + + $farbe="#E2E2E2"; + + $result_contenta = mysql_fetch_array($query_contenta); + + if ($rpm_sec2=="save") { + $save_account_member_usrid=""; + $save_account_member_usrgrp=""; + + if (array_key_exists("usrid", $_POST)) $save_account_member_usrid=$_POST['usrid']; + if (array_key_exists("usrgrp", $_POST)) $save_account_member_usrgrp=$_POST['usrgrp']; + + if ($save_account_member_usrgrp == "ros_sadmin" && $roscms_intern_usrgrp_sadmin != true) { + die("Not possible! You will need a higher account membership level!"); + } + if ($save_account_member_usrgrp == "ros_admin" && ($roscms_intern_usrgrp_sadmin != true || $roscms_intern_usrgrp_admin != true)) { + die("Not possible! You will need a higher account membership level!"); + } + + if ($save_account_member_usrid && $save_account_member_usrgrp && $rpm_sec3) { + $content_posta="UPDATE `usergroup_members` SET `usergroupmember_usergroupid` = '". mysql_real_escape_string($save_account_member_usrgrp) ."' + WHERE `usergroupmember_userid` =". mysql_real_escape_string($save_account_member_usrid) ." + AND CONVERT( `usergroupmember_usergroupid` USING utf8 ) = '". mysql_real_escape_string($rpm_sec3) ."' + LIMIT 1 ;"; + $content_post_lista=mysql_query($content_posta); + echo "<p><b>saved</b></p>"; + $rpm_db_id = $save_account_member_usrid; + } + } + if ($rpm_sec2=="insert") { + $save_account_member_usrid=""; + $save_account_member_usrgrp=""; + $save_account_member_usridname=""; + + if (array_key_exists("usrid", $_POST)) $save_account_member_usrid=$_POST['usrid']; + if (array_key_exists("usridname", $_POST)) $save_account_member_usridname=$_POST['usridname']; + if (array_key_exists("usrgrp", $_POST)) $save_account_member_usrgrp=$_POST['usrgrp']; + + if ($save_account_member_usridname == "1") { + $accountinfo_query = @mysql_query("SELECT user_name, user_id FROM users WHERE user_name = '".mysql_real_escape_string($save_account_member_usrid)."'") or die('DB error (admin group members edit interface)!'); + $accountinfo_result = @mysql_fetch_array($accountinfo_query); + if ($accountinfo_result['user_id']) { + $save_account_member_usrid = $accountinfo_result['user_id']; + } + else { + die("<blink>Username not found!</blink>"); + } + } + + if ($save_account_member_usrgrp == "ros_sadmin" && $roscms_intern_usrgrp_sadmin != true) { + die("Not possible! You will need a higher account membership level!"); + } + if ($save_account_member_usrgrp == "ros_admin" && ($roscms_intern_usrgrp_sadmin != true || $roscms_intern_usrgrp_admin != true)) { + die("Not possible! You will need a higher account membership level!"); + } + + if ($save_account_member_usrid && $save_account_member_usrgrp && $rpm_sec3) { + $content_postb="INSERT INTO `usergroup_members` ( `usergroupmember_userid` , `usergroupmember_usergroupid` ) + VALUES ( + '". mysql_real_escape_string($save_account_member_usrid) ."', '". mysql_real_escape_string($save_account_member_usrgrp) ."') ;"; + $content_post_listb=mysql_query($content_postb); + echo "<p><b>saved (".$save_account_member_usrid." -> ".$save_account_member_usrgrp.")</b></p>"; + $rpm_db_id = $save_account_member_usrid; + } + } +?> + <form name="cms_content" method="post" action="?page=admin&sec=usrgrpmbr&sec2=<?php if ($rpm_sec2=="edit") { echo "save"; } elseif ($rpm_sec2=="add") { echo "insert"; } ?>&sec3=<?php echo $rpm_sec3; ?>"> + <table width="600" border="0" cellpadding="1" cellspacing="1"> + <tr> + <td width="15%" valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>User + ID </strong></font></div></td> + <td width="85%" valign="top" bgcolor="#E2E2E2"><font face="Arial, Helvetica, sans-serif"> + <?php + if ($rpm_db_id == "new") { + ?> + <input name="usrid" type="text" id="usrid" size="30" maxlength="50"> + <input name="usridname" type="hidden" id="usridname" value="1"> + <?php + } + else { + $query_usra = mysql_query("SELECT user_id, user_name FROM users WHERE user_id = '". $rpm_db_id ."'") or die('DB error (admin membership script)!'); + $result_usra = mysql_fetch_array($query_usra); // or die('DB error (user_group_members_edit)'); + + echo "<b>".$rpm_db_id."</b> (".$result_usra['user_name'].")"; ?> + <input name="usrid" type="hidden" id="usrid" value="<?php echo $rpm_db_id; ?>"> + <?php + } + ?> + </font></td> + </tr> + <tr> + <td valign="top" bgcolor="#5984C3"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Usergroup</strong></font></div></td> + <td valign="top" bgcolor="#EEEEEE"><font face="Arial, Helvetica, sans-serif"> + <select id="usrgrp" size="1" name="usrgrp" class="selectbox"> + <?php + $sql_lang="SELECT * + FROM `usergroup_members` + WHERE `usergroupmember_userid` = ". $rpm_db_id ." + AND `usergroupmember_usergroupid` = '". $rpm_sec3 ."' + LIMIT 1 "; + $sql_query_lang=mysql_query($sql_lang); + $myrow_lang=mysql_fetch_array($sql_query_lang); // Languages + ?> + <optgroup label="usergroups"> + <?php + + // User Groups + $sql_langa="SELECT * + FROM `usergroups` + ORDER BY `usrgroup_securitylevel` ASC "; + $sql_query_langa=mysql_query($sql_langa); + while($myrow_langa=mysql_fetch_array($sql_query_langa)) { + echo '<option value="'.$myrow_langa['usrgroup_name_id'].'"'; + //echo "<br>=>".$myrow_lang['usergroupmember_userid']." == ".$myrow_langa['usrgroup_name_id']; + if ($myrow_lang['usergroupmember_usergroupid'] == $myrow_langa['usrgroup_name_id']) { + echo ' selected="selected"'; + } + echo '>'.$myrow_langa['usrgroup_name'].'</option>'; + } + ?> + </optgroup> + </select> + </font></td> + </tr> + </table> + <br /> + <input type="submit" name="Submit" value="Save"> + </form> + <p> </p> + <?php + if ($rpm_db_id != "new") { + + echo "<p><b>".$result_usra['user_name']." is currently member of the following usergroups:</b></p><ul>"; + + $query_page = mysql_query("SELECT * + FROM `usergroup_members` + WHERE `usergroupmember_userid` = $rpm_db_id + ORDER BY `usergroupmember_usergroupid` ASC ;") ; + while($result_page = mysql_fetch_array($query_page)) { + echo "<li>".$result_page['usergroupmember_usergroupid']."</li>"; + } + echo "</ul>"; + } +} +?> +</div> Property changes on: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members_edit.ph p ___________________________________________________________________ Name: svn:eol-style + native _____
Deleted: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_memebers.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_memebers.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_memebers.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -1,164 +0,0 @@
-<?php - /* - RosCMS - ReactOS Content Management System - Copyright (C) 2005 Klemens Friedl <frik85@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. - */ - - // To prevent hacking activity: - if ( !defined('ROSCMS_SYSTEM') OR !defined('ROSCMS_SYSTEM_ADMIN') ) - { - if ( !defined('ROSCMS_SYSTEM_LOG') ) { - define ("ROSCMS_SYSTEM_LOG", "Hacking attempt"); - } - $seclog_section="roscms_admin_interface"; - $seclog_level="50"; - $seclog_reason="Hacking attempt: admin_users.php"; - define ("ROSCMS_SYSTEM", "Hacking attempt"); - include('securitylog.php'); // open security log - die("Hacking attempt"); - } - -?> -<div class="contentSmall"> <span class="contentSmallTitle">Admin Interface - Group Members</span> - <ul> - <li><strong>Group Members</strong></li> - </ul> - - - <p>Action: <a href="#">New Membership</a> | <a href="?page=admin&sec=usrgrpmbr&sec2=view">reset - filters & sort</a></p> -<?php - - - if ($rpm_lang_id == "") { - $rpm_lang_id="all"; - } - echo '<p>Language: '; - echo '<b>All</b>'; - $ros_cms_intern_users_lang = " "; - echo '</p>'; - - if ($rpm_filt == "") { - $rpm_filt="active"; - } - echo '<p>Filter: '; - echo '<b>active</b>'; - $ros_cms_intern_users_filt = " "; - echo '</p>'; - - if ($rpm_sort == "") { - $rpm_sort="id"; - } - echo '<p>Sorted by: '; - if ($rpm_sort == "id") { - echo '<b>user ID</b>'; - $ros_cms_intern_users_sortby="usergroupmember_userid"; - $ros_cms_intern_users_sort="ASC"; - } - else { - echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=id&filt=' .$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">user ID</a>'; - } - echo ' | '; - if ($rpm_sort == "group") { - echo '<b>group ID</b>'; - $ros_cms_intern_users_sortby="usergroupmember_usergroupid"; - $ros_cms_intern_users_sort="ASC"; - } - else { - echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=group&fil t='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">group ID</a>'; - } - echo '</p>'; - -?> - <table width="100%" border="0" cellpadding="1" cellspacing="1"> - <tr bgcolor="#5984C3"> - <td width="6%"> - <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Action</strong></font></div></td> - <td width="4%" bgcolor="#5984C3"> - <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>ID</strong></font></div></td> - <td width="20%" bgcolor="#5984C3"> - <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Nick</strong></font></div></td> - <td width="20%"> - <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Usergroup</strong></font></div></td> - <td width="50%" bgcolor="#5984C3"> - <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Usergroup - description</strong></font></div></td> - </tr> - <?php - - if($roscms_intern_account_level==100) { - $query_page = mysql_query("SELECT * - FROM usergroup_members - $ros_cms_intern_users_filt $ros_cms_intern_users_lang - ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort") ; - } - else { - $query_page = mysql_query("SELECT * - FROM usergroup_members - $ros_cms_intern_users_filt AND user_account_hidden != 0 $ros_cms_intern_users_lang - ORDER BY '$ros_cms_intern_users_sortby' $ros_cms_intern_users_sort") ; - } - - $farbe1=$roscms_intern_color1; - $farbe2=$roscms_intern_color2; - $zaehler="0"; - //$farbe="#CCCCC"; - - while($result_page = mysql_fetch_array($query_page)) { // users -?> - <tr> - <td width="9%" valign="middle" bgcolor="<?php - $zaehler++; - if ($zaehler == "1") { - echo $farbe1; - $farbe = $farbe1; - } - elseif ($zaehler == "2") { - $zaehler="0"; - echo $farbe2; - $farbe = $farbe2; - } - ?>" title="RosCMS action buttons: * View account * Delete account * Email * Website"> - <div align="center"><img src="images/view.gif" alt="View" width="19" height="18" border="0"></div></td> - <td width="7%" valign="middle" bgcolor="<?php echo $farbe; ?>"> <div align="center"><font face="Arial, Helvetica, sans-serif"><?php echo "<b>".$result_page['usergroupmember_userid']."</b>"; ?></font></div></td> - <td width="10%" valign="middle" bgcolor="<?php echo $farbe; ?>"><font face="Arial, Helvetica, sans-serif"><?php - $query_usra = mysql_query("SELECT user_id, user_name FROM users WHERE user_id = '".$result_page['usergroupmember_userid']."'") or die('DB error (membership script)!'); - $result_usra = mysql_fetch_array($query_usra) or die('DB error (show_sessions script)'); - - echo $result_usra['user_name']; ?> - </font></td> - <td width="13%" valign="middle" bgcolor="<?php echo $farbe; ?>" title="<?php echo $result_page['usergroupmember_usergroupid']; ?>"><div align="left"><font face="Arial, Helvetica, sans-serif"> - <?php - //echo "SELECT usrgroup_name_id, usrgroup_name FROM usergroups WHERE usrgroup_name_id = '".$result_page['usergroupmember_usergroupid']."'<br>"; - $query_grpb = mysql_query("SELECT usrgroup_name_id, usrgroup_name, usrgroup_description FROM usergroups WHERE usrgroup_name_id = '".$result_page['usergroupmember_usergroupid']."'") or die('DB error (membership script)!'); - $result_grpb = mysql_fetch_array($query_grpb) or die('DB error (membership script)'); - - echo $result_grpb['usrgroup_name']; - ?> - </font></div></td> - <td width="15%" valign="middle" bgcolor="<?php echo $farbe; ?>"> <font face="Arial, Helvetica, sans-serif"><?php - echo substr(htmlentities($result_grpb['usrgroup_description'], ENT_QUOTES), 0, 50)."..."; - ?></font></tr> - <?php - } // end while -?> - </table> - <?php - $roscms_infotable = "user"; - include("inc/inc_description_table.php"); -?> -</div> _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/inc_description_table.php --- trunk/web/reactos.org/htdocs/roscms/inc/inc_description_table.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/inc_description_table.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -30,7 +30,7 @@
<td width="50%" valign="top"> <table width="100%" border="0"> <tr> <td width="25" valign="top"><img src="images/view.gif" width="19" height="18" border="0"></td> - <td valign="middle"><font size="1"><strong>View</strong> entry</font></td> + <td valign="middle"><font size="1"><strong>View/Edit</strong> entry</font></td> </tr> <tr> <td valign="top"><img src="images/tool.gif" width="19" height="18" border="0"></td> @@ -96,8 +96,12 @@ <td width="50%" valign="top"> <table width="100%" border="0"> <tr> <td width="25" valign="top"><img src="images/view.gif" width="19" height="18" border="0"></td> - <td valign="middle"><font size="1"><strong>View</strong> entry</font></td> + <td valign="middle"><font size="1"><strong>View/Edit</strong> entry</font></td> </tr> + <tr> + <td valign="top"><img src="images/tool.gif" width="19" height="18" border="0"></td> + <td valign="middle"><font size="1"><strong>Add</strong> entry</font></td> + </tr> <tr> <td valign="top"><img src="images/delete.gif" width="19" height="18"></td> <td valign="middle"><font size="1"><strong>Delete</strong> entry</font></td> _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/website_status.php --- trunk/web/reactos.org/htdocs/roscms/inc/website_status.php 2005-12-06 19:43:53 UTC (rev 19937) +++ trunk/web/reactos.org/htdocs/roscms/inc/website_status.php 2005-12-06 19:57:28 UTC (rev 19938) @@ -40,7 +40,7 @@
<td width="200"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Title</strong></font></div></td> <td width="250"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></div></td> - <td width="150"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Filename</strong></font></div></td> + <td width="200"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Name</strong></font></div></td> <td width="150"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Language</strong></font></div></td> <td width="150"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Date & Time </strong></font></div></td> @@ -53,7 +53,7 @@
AND `content_visible` = 1
AND `content_type` = 'default'
ORDER BY `content_id` DESC - LIMIT 0 , 10 ;") ; + LIMIT 0 , 15 ;") ; $color=""; $color1=$roscms_intern_color1; $color2=$roscms_intern_color2; @@ -74,7 +74,7 @@ [truncated at 1000 lines; 61 more skipped]