20 Dec
2005
20 Dec
'05
8:34 p.m.
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
?>