RosCMS update:
* add RosCMS user group history page Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php Added: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_history.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/inc_menu_admin.php _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin.php 2006-01-11 19:18:57 UTC (rev 20786) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin.php 2006-01-11 20:01:03 UTC (rev 20787) @@ -147,6 +147,9 @@
case "usergroups": include("inc/admin_user_groups.php"); break; + case "userhistory": + include("inc/admin_user_history.php"); + break; case "usrgrpmbr": if ($rpm_sec2=="view" || $rpm_sec2=="") {
include("inc/admin_user_group_members.php"); _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php 2006-01-11 19:18:57 UTC (rev 20786) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php 2006-01-11 20:01:03 UTC (rev 20787) @@ -351,12 +351,14 @@
$roscms_SET_letter = "%"; }
-$query_count_cat=mysql_query("SELECT COUNT('user_id') - FROM `users` - WHERE `user_account_enabled` = 'yes' - AND `user_account_hidden` = 'no' - AND `user_name` LIKE '" . $roscms_SET_letter . "%' - ORDER BY `user_name` ASC ;"); +$query_count_cat=mysql_query("SELECT COUNT('A1.user_id') + FROM users A1 + WHERE A1.user_account_enabled = 'yes' + AND A1.user_account_hidden = 'no' + AND A1.user_name LIKE '" . $roscms_SET_letter . "%' + $ros_cms_intern_users_filt + $ros_cms_intern_users_lang + ORDER BY A1.user_name ASC ;"); $result_count_cat = mysql_fetch_row($query_count_cat);
echo "<p align='center'>"; _____
Added: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_history.php --- trunk/web/reactos.org/htdocs/roscms/inc/admin_user_history.php 2006-01-11 19:18:57 UTC (rev 20786) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_history.php 2006-01-11 20:01:03 UTC (rev 20787) @@ -0,0 +1,291 @@
+<?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 - User History</span> + <ul> + <li><strong>User History</strong></li> + </ul> + <p>Action: <a href="?page=admin&sec=userhistory&sec2=view">reset + filters & sort</a></p> + <?php + + if ($rpm_lang_id == "") { + $rpm_lang_id="all"; + } + echo '<p>Language: '; + if ($rpm_lang_id == "all") { + echo '<b>All</b>'; + $ros_cms_intern_users_lang = "AND A1.user_language LIKE '%'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort='.$rpm_sort .'&filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid=all">All</a>'; + } + // Languages + $sql_lang="SELECT * + FROM languages + WHERE lang_level != '0' + ORDER BY 'lang_level' DESC"; + $sql_query_lang=mysql_query($sql_lang); + while($myrow_lang=mysql_fetch_row($sql_query_lang)) { + $roscms_sel_lang = $myrow_lang[0]; + echo ' | '; + if ($rpm_lang_id == $roscms_sel_lang) { + echo '<b>'.$myrow_lang[1].'</b>'; + $ros_cms_intern_users_lang = "AND A1.user_language = '".$roscms_sel_lang."'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort='.$rpm_sort .'&filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$roscms_sel_ lang.'">'.$myrow_lang[1].'</a>'; + } + } + + + if ($rpm_filt == "") { + $rpm_filt="active"; + } + echo '<p>Filter: '; + if ($rpm_filt == "active") { + echo '<b>active users</b>'; + $ros_cms_intern_users_filt = "AND A1.user_account_enabled = 'yes'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort='.$rpm_sort .'&filt=active&langid='.$rpm_lang_id.'">active users</a>'; + } + echo ' | '; + if ($rpm_filt == "all") { + echo '<b>all users</b>'; + $ros_cms_intern_users_filt = "AND A1.user_account_enabled != ''"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort='.$rpm_sort .'&filt=all&langid='.$rpm_lang_id.'">all users</a>'; + } + echo '</p>'; + + if ($rpm_sort == "") { + $rpm_sort="translator"; + } + echo '<p>Filter by Group: '; +/* if ($rpm_sort == "all") { + echo '<b>all</b>'; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid LIKE '%'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort=all&fil t='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">all</a
';
+ } + echo ' | ';*/ + if ($rpm_sort == "ros_sadmin") { + echo '<b>super admin</b>'; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid = 'ros_sadmin'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort=ros_sadmin& amp;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'"
super admin</a>';
+ } + echo ' | '; + if ($rpm_sort == "ros_admin") { + echo '<b>admin</b>'; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid = 'ros_admin'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort=ros_admin&a mp;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'"> admin</a>'; + } + echo ' | '; + if ($rpm_sort == "developer") { + echo '<b>developer</b>'; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid = 'developer'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort=developer&a mp;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'"> developer</a>'; + } + echo ' | '; + if ($rpm_sort == "moderator") { + echo '<b>moderator</b>'; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid = 'moderator'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort=moderator&a mp;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'"> moderator</a>'; + } + echo ' | '; + if ($rpm_sort == "translator") { + echo '<b>translator</b>'; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid = 'translator'"; + } + else { + echo '<a href="?page=admin&sec=userhistory&sec2=view&sort=translator& amp;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'"
translator</a>';
+ } + echo '</p>'; + +?> + <?php + +// Setting: +$roscms_intern_items_per_page = 50; + +$roscms_SET_curpos = ""; +$roscms_SET_letter = ""; +if (array_key_exists("curpos", $_GET)) $roscms_SET_curpos=htmlspecialchars($_GET["curpos"]); +if (array_key_exists("letter", $_GET)) $roscms_SET_letter=htmlspecialchars($_GET["letter"]); + + + + +?> + <table width="100%" border="0" cellpadding="1" cellspacing="1"> + <tr bgcolor="#5984C3"> + <td width="10%"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Action</strong></font></div></td> + <td width="20%" bgcolor="#5984C3"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Name</strong></font></div></td> + <td width="70%" bgcolor="#5984C3"> + <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>History</strong></font></div> </td> + </tr> + <?php + + + $roscms_TEMP_sql = "SELECT A1.user_id, A1.user_name, A2.usergroupmember_userid, A2.usergroupmember_usergroupid + FROM users A1, usergroup_members A2 + WHERE A1.user_id = A2.usergroupmember_userid + AND A1.user_name LIKE '%' + $ros_cms_intern_users_filt $ros_cms_intern_users_lang $ros_cms_intern_users_sortby + GROUP BY A1.user_name + ;"; +// echo $roscms_TEMP_sql; + $query_page = mysql_query($roscms_TEMP_sql) ; + + $color1=$roscms_intern_color1; + $color2=$roscms_intern_color2; + $colorcounter="0"; + //$farbe="#CCCCC"; + + while($result_page = mysql_fetch_array($query_page)) { // users +?> + <tr> + <td valign="top" bgcolor="<?php + $colorcounter++; + if ($colorcounter == "1") { + echo $color1; + $farbe = $color1; + } + elseif ($colorcounter == "2") { + $colorcounter="0"; + echo $color2; + $farbe = $color2; + } + ?>"> + <div align="center"><a href="?page=admin&sec=userhistory&sec2=edit&sec3=<?php echo $result_page['usergroupmember_usergroupid']; ?>&db_id=<?php echo $result_page['user_id']; ?>"><img src="images/view.gif" alt="Edit Membership" width="19" height="18" border="0"></a> <a href="?page=admin&sec=userhistory&sec2=add&sec3=new&db_i d=<?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=userhistory&sec2=delete&sec3=<?php echo $result_page['usergroupmember_usergroupid']; ?>&db_id=<?php echo $result_page['usergroupmember_userid']; ?>"><img src="images/delete.gif" alt="Delete Membership" width="19" height="18" border="0"></a></div></td> + <td valign="top" bgcolor="<?php echo $farbe; ?>"> <div align="left"> + <p align="center"><font face="Arial, Helvetica, sans-serif"><?php echo $result_page['user_id']. " - "; + $query_usra = mysql_query("SELECT user_id, user_name FROM users WHERE user_id = '".$result_page['user_id']."'") or die('DB error (membership script)!'); + $result_usra = mysql_fetch_array($query_usra); // or die('DB error (show_sessions script)'); + + echo "<b>".$result_usra['user_name']."</b><br /><a href='?page=user&sec=profil&sec2=".$result_page['user_id']."'>[P rofil]</a>"; ?> + </font></p> + <p><font face="Arial, Helvetica, sans-serif"> <?php + echo "<ul>"; + $query_grpmbr = mysql_query("SELECT * + FROM `usergroup_members` + WHERE `usergroupmember_userid` = ".$result_usra['user_id']." + ORDER BY `usergroupmember_usergroupid` ASC ;") ; + while($result_grpmbr = mysql_fetch_array($query_grpmbr)) { + echo "<li>".$result_grpmbr['usergroupmember_usergroupid']."</li>"; + } + echo "</ul>"; + ?> + </font></p> + </div></td> + <td valign="top" bgcolor="<?php echo $farbe; ?>"><?php + + // Contents + echo "<b><u><i>Contents:</i></u></b> "; + $query_count_contents=mysql_query("SELECT COUNT('content_id') + FROM `content` + WHERE `content_usrname_id` = ".$result_page['user_id']." + ORDER BY `content_id` DESC;"); + $result_count_contents = mysql_fetch_row($query_count_contents); + echo $result_count_contents[0]."<br /><br />"; + if ($result_count_contents[0] != 0) { + $query_entries_contents = mysql_query("SELECT * + FROM `content` + WHERE `content_usrname_id` = ".$result_page['user_id']." + ORDER BY `content_id` DESC + LIMIT 0 , 25 ;") ; + while($result_entries_contents = mysql_fetch_array($query_entries_contents)) { + echo " ".$result_entries_contents['content_id']. " - ".$result_entries_contents['content_name']." <font size='1'>- ".$result_entries_contents['content_lang']." / ".$result_entries_contents['content_type']." (".$result_entries_contents['content_date']." ".$result_entries_contents['content_time'].")</font><br />"; + } + if ($result_count_contents[0] > 25) { + echo " ...<br />"; + } + echo "<br />"; + } + + + // Pages + echo "<b><u><i>Pages:</i></u></b> "; + $query_count_contents=mysql_query("SELECT COUNT('page_id') + FROM `pages` + WHERE `page_usrname_id` = ".$result_page['user_id']." + ORDER BY `page_id` DESC;"); + $result_count_contents = mysql_fetch_row($query_count_contents); + echo $result_count_contents[0]."<br /><br />"; + if ($result_count_contents[0] != 0) { + $query_entries_contents = mysql_query("SELECT * + FROM `pages` + WHERE `page_usrname_id` = ".$result_page['user_id']." + ORDER BY `page_id` DESC + LIMIT 0 , 25 ;") ; + while($result_entries_contents = mysql_fetch_array($query_entries_contents)) { + echo " ".$result_entries_contents['page_id']." - ".$result_entries_contents['page_name']." <font size='1'>- ".$result_entries_contents['page_language']." / ".$result_entries_contents['pages_extention']." (".$result_entries_contents['page_date']." ".$result_entries_contents['page_time'].")</font><br />"; + } + if ($result_count_contents[0] > 25) { + echo " ...<br />"; + } + echo "<br />"; + } + + + // Pages + echo "<b><u><i>DynContent:</i></u></b> "; + $query_count_contents=mysql_query("SELECT COUNT('dyn_id') + FROM `dyn_content` + WHERE `dyn_content_usrname_id` = ".$result_page['user_id']." + ORDER BY `dyn_id` DESC;"); + $result_count_contents = mysql_fetch_row($query_count_contents); + echo $result_count_contents[0]."<br /><br />"; + if ($result_count_contents[0] != 0) { + $query_entries_contents = mysql_query("SELECT * + FROM `dyn_content` + WHERE `dyn_content_usrname_id` = ".$result_page['user_id']." + ORDER BY `dyn_id` DESC + LIMIT 0 , 25 ;") ; + while($result_entries_contents = mysql_fetch_array($query_entries_contents)) { + echo " ".$result_entries_contents['dyn_id']." - ".$result_entries_contents['dyn_content_name']."_".$result_entries_conte nts['dyn_content_id'].".".$result_entries_contents['dyn_content_nr']." <font size='1'>- ".$result_entries_contents['dyn_content_lang']." (".$result_entries_contents['dyn_content_date']." ".$result_entries_contents['dyn_content_time'].")</font><br />"; + } + if ($result_count_contents[0] > 25) { + echo " ...<br />"; + } + echo "<br />"; + } + + ?></td> + </tr> + <?php + } // end while +?> + </table> + <?php + $roscms_infotable = "user"; + include("inc/inc_description_table.php"); +?> +</div> Property changes on: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_history.php ___________________________________________________________________ Name: svn:eol-style + native _____
Modified: trunk/web/reactos.org/htdocs/roscms/inc/inc_menu_admin.php --- trunk/web/reactos.org/htdocs/roscms/inc/inc_menu_admin.php 2006-01-11 19:18:57 UTC (rev 20786) +++ trunk/web/reactos.org/htdocs/roscms/inc/inc_menu_admin.php 2006-01-11 20:01:03 UTC (rev 20787) @@ -34,11 +34,12 @@
?> <li><a href="?page=admin&sec=users">User Accounts</a></li> <?php - if ($rpm_sec == "users" || $rpm_sec == "usergroups" || $rpm_sec == "usrgrpmbr" || $rpm_sec == "sessions") { + if ($rpm_sec == "users" || $rpm_sec == "usergroups" || $rpm_sec == "usrgrpmbr" || $rpm_sec == "userhistory" || $rpm_sec == "sessions") { ?> <li><a href="?page=admin&sec=usergroups"> - Usergroups</a></li> <li><a href="?page=admin&sec=usrgrpmbr"> - Group Members</a></li> <li><a href="?page=admin&sec=sessions"> - Sessions</a></li> + <li><a href="?page=admin&sec=userhistory"> - User History</a></li> <?php } ?>