RosCMS update:
Admin Interface: * membership page: improved the interface and sql queries, outsourced the color settings * account page: outsourced the color settings Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_accounts.php Modified: trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php _____
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-20 20:07:40 UTC (rev 20277) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_accounts.php 2005-12-20 20:34:03 UTC (rev 20278) @@ -459,24 +459,24 @@
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; - $farbe2=$roscms_intern_color2; - $zaehler="0"; + $color1=$roscms_intern_color1; + $color2=$roscms_intern_color2; + $colorcounter="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; + $colorcounter++; + if ($colorcounter == "1") { + echo $color1; + $farbe = $color1; } - elseif ($zaehler == "2") { - $zaehler="0"; - echo $farbe2; - $farbe = $farbe2; + elseif ($colorcounter == "2") { + $colorcounter="0"; + echo $color2; + $farbe = $color2; } ?>"> <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> _____
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 2005-12-20 20:07:40 UTC (rev 20277) +++ trunk/web/reactos.org/htdocs/roscms/inc/admin_user_group_members.php 2005-12-20 20:34:03 UTC (rev 20278) @@ -23,123 +23,340 @@
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>Language: '; + if ($rpm_lang_id == "all") { + echo '<b>All</b>'; + $ros_cms_intern_users_lang = "AND A1.user_language LIKE '%'"; } - //echo '<p>Filter: '; - //echo '<b>active</b>'; - $ros_cms_intern_users_filt = " "; - //echo '</p>'; + else { + echo '<a href="?page=admin&sec=usrgrpmbr&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=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$roscms_sel_la ng.'">'.$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=usrgrpmbr&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=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=all&langid='.$rpm_lang_id.'">all users</a>'; + } + echo '</p>'; + + if ($rpm_sort == "") { + $rpm_sort="all"; + } + echo '<p>Filter by Group: '; + if ($rpm_sort == "all") { echo '<b>all</b>'; - $ros_cms_intern_users_filt = " "; + $ros_cms_intern_users_sortby=" AND A2.usergroupmember_usergroupid LIKE '%'"; } else { - echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt=active&langid='.$rpm_lang_id.'">all</a>'; + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=all&filt= '.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">all</a>' ; } echo ' | '; - if ($rpm_filt == "sadmin") { + if ($rpm_sort == "ros_sadmin") { echo '<b>super admin</b>'; - $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'ros_sadmin' "; + $ros_cms_intern_users_sortby=" AND A2.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 '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=ros_sadmin&am p;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">s uper admin</a>'; } echo ' | '; - if ($rpm_filt == "admin") { + if ($rpm_sort == "ros_admin") { echo '<b>admin</b>'; - $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'ros_admin' "; + $ros_cms_intern_users_sortby=" AND A2.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 '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=ros_admin& ;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">ad min</a>'; } echo ' | '; - if ($rpm_filt == "dev") { + if ($rpm_sort == "developer") { echo '<b>developer</b>'; - $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'developer' "; + $ros_cms_intern_users_sortby=" AND A2.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 '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=developer& ;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">de veloper</a>'; } echo ' | '; - if ($rpm_filt == "mod") { + if ($rpm_sort == "moderator") { echo '<b>moderator</b>'; - $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'moderator' "; + $ros_cms_intern_users_sortby=" AND A2.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 '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=moderator& ;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">mo derator</a>'; } echo ' | '; - if ($rpm_filt == "trans") { + if ($rpm_sort == "translator") { echo '<b>translator</b>'; - $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'translator' "; + $ros_cms_intern_users_sortby=" AND A2.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 '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=translator&am p;filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">t ranslator</a>'; } echo ' | '; - if ($rpm_filt == "user") { - echo '<b>normal user</b>'; - $ros_cms_intern_users_filt = " WHERE `usergroupmember_usergroupid` = 'user' "; + if ($rpm_sort == "user") { + echo '<b>user</b>'; + $ros_cms_intern_users_sortby=" AND A2.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>'; + echo '<a href="?page=admin&sec=usrgrpmbr&sec2=view&sort=user&filt ='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.'">user</a
';
} + echo '</p>';
- if ($rpm_sort == "") { - $rpm_sort="id"; +?> + <?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"]); + + + + echo '<p align="center">'; + + if ($roscms_SET_letter == "all" || $roscms_SET_letter == "") { + echo ' <b>All</b> '; } - 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='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=all" class="letterbarlink">All</a> '; } + + if ($roscms_SET_letter == "a") { + echo ' <b>A</b> '; + } 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 ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=a" class="letterbarlink">A</a> '; } - echo ' | '; - if ($rpm_sort == "group") { - echo '<b>group ID</b>'; - $ros_cms_intern_users_sortby="usergroupmember_usergroupid"; - $ros_cms_intern_users_sort="ASC"; + + if ($roscms_SET_letter == "b") { + echo ' <b>B</b> '; } 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 ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=b" class="letterbarlink">B</a> '; } - echo '</p>';
-?> -<?php + if ($roscms_SET_letter == "c") { + echo ' <b>C</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=c" class="letterbarlink">C</a> '; + }
-// Setting: -$roscms_intern_items_per_page = 50; + if ($roscms_SET_letter == "d") { + echo ' <b>D</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=d" class="letterbarlink">D</a> '; + }
+ if ($roscms_SET_letter == "e") { + echo ' <b>E</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=e" class="letterbarlink">E</a> '; + }
-$roscms_SET_curpos = ""; -if (array_key_exists("curpos", $_GET)) $roscms_SET_curpos=htmlspecialchars($_GET["curpos"]); + if ($roscms_SET_letter == "f") { + echo ' <b>F</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=f" class="letterbarlink">F</a> '; + } + + if ($roscms_SET_letter == "g") { + echo ' <b>G</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=g" class="letterbarlink">G</a> '; + } + + if ($roscms_SET_letter == "h") { + echo ' <b>H</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=h" class="letterbarlink">H</a> '; + } + + if ($roscms_SET_letter == "i") { + echo ' <b>I</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=i" class="letterbarlink">I</a> '; + } + + if ($roscms_SET_letter == "j") { + 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.' &letter=j" class="letterbarlink">J</a> '; + } + + if ($roscms_SET_letter == "k") { + echo ' <b>K</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=k" class="letterbarlink">K</a> '; + } + + if ($roscms_SET_letter == "l") { + echo ' <b>L</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=l" class="letterbarlink">L</a> '; + } + + if ($roscms_SET_letter == "m") { + echo ' <b>M</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=m" class="letterbarlink">M</a> '; + } + + if ($roscms_SET_letter == "n") { + echo ' <b>N</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=n" class="letterbarlink">N</a> '; + } + + if ($roscms_SET_letter == "o") { + echo ' <b>O</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=o" class="letterbarlink">O</a> '; + } + + if ($roscms_SET_letter == "p") { + echo ' <b>P</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=p" class="letterbarlink">P</a> '; + } + + if ($roscms_SET_letter == "q") { + echo ' <b>Q</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=q" class="letterbarlink">Q</a> '; + } + + if ($roscms_SET_letter == "r") { + echo ' <b>R</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=r" class="letterbarlink">R</a> '; + } + + if ($roscms_SET_letter == "s") { + echo ' <b>S</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=s" class="letterbarlink">S</a> '; + } + + if ($roscms_SET_letter == "t") { + echo ' <b>T</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=t" class="letterbarlink">T</a> '; + } + + if ($roscms_SET_letter == "u") { + echo ' <b>U</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=u" class="letterbarlink">U</a> '; + } + + if ($roscms_SET_letter == "v") { + echo ' <b>V</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=v" class="letterbarlink">V</a> '; + } + + if ($roscms_SET_letter == "w") { + echo ' <b>W</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=w" class="letterbarlink">W</a> '; + } + + if ($roscms_SET_letter == "x") { + echo ' <b>X</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=x" class="letterbarlink">X</a> '; + } + + if ($roscms_SET_letter == "y") { + echo ' <b>Y</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=y" class="letterbarlink">Y</a> '; + } + + if ($roscms_SET_letter == "z") { + echo ' <b>Z</b> '; + } + else { + echo ' <a href="?page=admin&sec=usrgrpmbr&sec2=view&sort='.$rpm_sort.' &filt='.$rpm_filt.'&opt='.$rpm_opt.'&langid='.$rpm_lang_id.' &letter=z" class="letterbarlink">Z</a> '; + } + + echo "</p>"; + + + 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 ;"); +if ($roscms_SET_letter == "all") { + $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 ;"); $result_count_cat = mysql_fetch_row($query_count_cat);
echo "<p align='center'>"; @@ -150,84 +367,75 @@ 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> "; + echo "<a href='?page=admin&sec=usrgrpmbr&sec2=view&sort=".$rpm_sort." &filt=".$rpm_filt."&opt=".$rpm_opt."&langid=".$rpm_lang_id." &letter=".$roscms_SET_letter."&curpos=".$i."'>".$j."</a> "; } } $j=0; echo "</p>";
-?> -<table width="100%" border="0" cellpadding="1" cellspacing="1"> +?> + <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr bgcolor="#5984C3"> - <td width="6%"> + <td width="10%"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Action</strong></font></div></td> - <td width="4%" bgcolor="#5984C3"> + <td width="10%" bgcolor="#5984C3"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>ID</strong></font></div></td> - <td width="20%" bgcolor="#5984C3"> + <td width="40%" bgcolor="#5984C3"> <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Nick</strong></font></div></td> - <td width="20%"> + <td width="40%"> <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 { - //AND user_account_hidden != 0 - $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 ." ;") ; - } + $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 '" . $roscms_SET_letter . "%' + $ros_cms_intern_users_filt $ros_cms_intern_users_lang $ros_cms_intern_users_sortby + GROUP BY A1.user_name + LIMIT ". $roscms_SET_curpos ." , ". $roscms_intern_items_per_page ." + ;"; +// echo $roscms_TEMP_sql; + $query_page = mysql_query($roscms_TEMP_sql) ;
- $farbe1="#E2E2E2"; - $farbe2="#EEEEEE"; - $zaehler="0"; + $color1=$roscms_intern_color1; + $color2=$roscms_intern_color2; + $colorcounter="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; + <td valign="middle" bgcolor="<?php + $colorcounter++; + if ($colorcounter == "1") { + echo $color1; + $farbe = $color1; } - elseif ($zaehler == "2") { - $zaehler="0"; - echo $farbe2; - $farbe = $farbe2; + elseif ($colorcounter == "2") { + $colorcounter="0"; + echo $color2; + $farbe = $color2; } ?>"> - <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="Delete 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)!'); + <div align="center"><a href="?page=admin&sec=usrgrpmbr&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=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="Delete Membership" width="19" height="18" border="0"></a></div></td> + <td valign="middle" bgcolor="<?php echo $farbe; ?>"> <div align="center"><font face="Arial, Helvetica, sans-serif"><?php echo "<b>".$result_page['user_id']."</b>"; ?></font></div></td> + <td 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['user_id']."'") 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>"; ?> + echo $result_usra['user_name']." <a href='?page=user&sec=profil&sec2=".$result_page['user_id']."'>[P rofil]</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"> + <td 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']; + 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> + </tr> <?php } // end while ?>
-
frik85＠svn.reactos.com