RecordCount(); $grow = array_map('htmlspecialchars', $grpresult->FetchRow()); } $usergroupsummary = "\n"; $usergroupsummary .= "

 

"; //CSS Firefox 2 transition fix } if ($action == "adduser" || $action=="deluser" || $action == "moduser" || $action == "userrights" || $action == "usertemplates") { include("usercontrol.php"); } if ($action == "setusertemplates") { refreshtemplates(); $usersummary = "\n
\n\t
".$clang->gT('Edit template permissions')."

\n\n\t\n\t\n\t\n"; $userlist = getuserlist(); foreach ($userlist as $usr) { if ($usr['uid'] == $postuserid) { $templaterights = array(); $squery = 'SELECT '.db_quote_id('folder').','.db_quote_id('use')." FROM {$dbprefix}templates_rights WHERE uid={$usr['uid']}"; $sresult = db_execute_assoc($squery) or safe_die($connect->ErrorMsg());//Checked while ($srow = $sresult->FetchRow()) { $templaterights[$srow["folder"]] = array("use"=>$srow["use"]); } $usersummary .= "\t\n\n\n\t\n" ."\t\n\n\n"; $tquery = "SELECT * FROM ".$dbprefix."templates"; $tresult = db_execute_assoc($tquery) or safe_die($connect->ErrorMsg()); //Checked $table_row_odd_even = 'odd'; while ($trow = $tresult->FetchRow()) { if($table_row_odd_even == 'odd' ) { $row_class = ' class="row_odd"'; $table_row_odd_even = 'even'; } else { $row_class = ' class="row_even"'; $table_row_odd_even = 'odd'; }; $usersummary .= "\t\n\n"; $usersummary .= "\n\t\n\n" ."\t
\n" . $clang->gT('Set templates that this user may access').': '.$_POST['user']."
" .$clang->gT('Template Name') ."" .$clang->gT('Allowed') ."
{$trow["folder"]}\n" ."\tgT('Save Settings')."\" />\n" ."\t\n" ."\t\n
\n" ."

\n"; continue; } } } if ($action == "modifyuser") { if (isset($postuserid) && $postuserid) { $squery = "SELECT uid FROM {$dbprefix}users WHERE uid=$postuserid AND parent_id=".$_SESSION['loginID']; // added by Dennis $sresult = $connect->Execute($squery);//Checked $sresultcount = $sresult->RecordCount(); } else { include("access_denied.php"); } // RELIABLY CHECK MY RIGHTS if ($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || $_SESSION['loginID'] == $postuserid || ( $_SESSION['USER_RIGHT_CREATE_USER'] && $sresultcount > 0 ) ) { $usersummary = "
\n".$clang->gT("Editing user")."

\n" ."
\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; $muq = "SELECT a.users_name, a.full_name, a.email, a.uid, b.users_name AS parent FROM ".db_table_name('users')." AS a LEFT JOIN ".db_table_name('users')." AS b ON a.parent_id = b.uid WHERE a.uid='{$postuserid}'"; // added by Dennis //echo($muq); $mur = db_select_limit_assoc($muq, 1); $usersummary .= ""; while ($mrw = $mur->FetchRow()) { $mrw = array_map('htmlspecialchars', $mrw); $usersummary .= "\n" . "\n"; $usersummary .= "\n"; } $usersummary .= "\n\n" . "
".$clang->gT("Username")."".$clang->gT("Email")."".$clang->gT("Full name")."".$clang->gT("Password")."
{$mrw['users_name']}\n" . "\n\n\n" . "\n" . "\n
\n" . "\n" . "
\n"; } else { include("access_denied.php"); } } if ($action == "setuserrights") { if (isset($postuserid) && $postuserid) { $squery = "SELECT uid FROM {$dbprefix}users WHERE uid=$postuserid AND parent_id=".$_SESSION['loginID']; // added by Dennis $sresult = $connect->Execute($squery);//Checked $sresultcount = $sresult->RecordCount(); } else { include("access_denied.php"); } // RELIABLY CHECK MY RIGHTS if ($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || ( $_SESSION['USER_RIGHT_CREATE_USER'] && $sresultcount > 0 && $_SESSION['loginID'] != $postuserid ) ) // if($_SESSION['loginID'] != $postuserid) { $usersummary = "\n\n"; // HERE WE LIST FOR USER RIGHTS YOU CAN SET TO a USER // YOU CAN ONLY SET AT MOST THE RIGHTS YOU have yourself $userlist = getuserlist(); foreach ($userlist as $usr) { if ($usr['uid'] == $postuserid) { $squery = "SELECT create_survey, configurator, create_user, delete_user, superadmin, manage_template, manage_label FROM {$dbprefix}users WHERE uid={$_SESSION['loginID']}"; // added by Dennis $sresult = $connect->Execute($squery); //Checked $parent = $sresult->FetchRow(); // Initial SuperAdmin has parent_id == 0 $adminquery = "SELECT uid FROM {$dbprefix}users WHERE parent_id=0"; $adminresult = db_select_limit_assoc($adminquery, 1); $row=$adminresult->FetchRow(); // Only Initial SuperAdmin can give SuperAdmin rights if($row['uid'] == $_SESSION['loginID']) { // RENAMED AS SUPERADMIN $usersummary .= "\n"; } if($parent['create_survey']) { $usersummary .= "\n"; } if($parent['configurator']) { $usersummary .= "\n"; } if($parent['create_user']) { $usersummary .= "\n"; } if($parent['delete_user']) { $usersummary .= "\n"; } if($parent['manage_template']) { $usersummary .= "\n"; } if($parent['manage_label']) { $usersummary .= "\n"; } $usersummary .="\n\n" ."" ."\n"; //content // Only Initial SuperAdmmin can give SuperAdmin right if($row['uid'] == $_SESSION['loginID']) { $usersummary .= "" ."" . "
\n" . "".$clang->gT("Set User Rights").": ".htmlspecialchars(sanitize_user($_POST['user']))."
".$clang->gT("SuperAdministrator")."".$clang->gT("Create Survey")."".$clang->gT("Configurator")."".$clang->gT("Create User")."".$clang->gT("Delete User")."".$clang->gT("Manage Template")."".$clang->gT("Manage Labels")."
" ."" ."" ."
\n"; continue; } // if } // foreach } // if else { include("access_denied.php"); } } // if if($action == "setasadminchild") { // Set user as child of ADMIN FOR // MORE RIGHT MANAGEMENT POSSIBILITIES // DON'T TOUCH user CHILDS, they remain his childs if($_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { $query = "UPDATE ".db_table_name('users')." SET parent_id =1 WHERE uid = ".$postuserid; $connect->Execute($query) or safe_die($connect->ErrorMsg()." ".$query); //Checked $usersummary = "
".$clang->gT("Setting as Administrator Child")."
" . "
".$clang->gT("Set Parent successful.")."
" . "
".$clang->gT("Continue")."
 \n"; } else { include("access_denied.php"); } } if ($action == "editusers") { $usersummary = "
".$clang->gT("User Control")."

" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; $userlist = getuserlist(); $ui = count($userlist); $usrhimself = $userlist[0]; unset($userlist[0]); // output users // output admin user only if the user logged in has user management rights $usersummary .= "\n"; // Action colum first $usersummary .= "\n" . "\n" . "\n" . "\n" . "\n"; if(isset($usrhimself['parent_id']) && $usrhimself['parent_id']!=0) { $uquery = "SELECT users_name FROM ".db_table_name('users')." WHERE uid=".$usrhimself['parent_id']; $uresult = db_execute_assoc($uquery); //Checked $srow = $uresult->FetchRow(); $usersummary .= "\n"; } else { $usersummary .= "\n"; } $usersummary.="\n"; // other users $row = 0; $usr_arr = $userlist; for($i=1; $i<=count($usr_arr); $i++) { if (!isset($bgcc)) {$bgcc="evenrow";} else { if ($bgcc == "evenrow") {$bgcc = "oddrow";} else {$bgcc = "evenrow";} } $usr = $usr_arr[$i]; $usersummary .= "\n"; $usersummary .= "\n"; $usersummary .= "\n" . "\n" . "\n"; // passwords of other users will not be displayed $usersummary .= "\n"; // Get Parent's User Name $uquery = "SELECT users_name FROM ".db_table_name('users')." WHERE uid=".$usr['parent_id']; $uresult = db_execute_assoc($uquery); //Checked $userlist = array(); $srow = $uresult->FetchRow(); $usr['parent'] = $srow['users_name']; //TODO: Find out why parent isn't set // ==> because it is parent_id ;-) if (isset($usr['parent_id'])) { $usersummary .= "\n"; } else { $usersummary .= "\n"; } $usersummary .= "\n"; $row++; } $usersummary .= "
".$clang->gT("Action")."".$clang->gT("Username")."".$clang->gT("Email")."".$clang->gT("Full name")."".$clang->gT("Password")."".$clang->gT("Created by")."
\n"; $usersummary .= "
" ."" ."" ."" ."
"; if ($usrhimself['parent_id'] != 0 && $_SESSION['USER_RIGHT_DELETE_USER'] == 1 ) { $usersummary .= "
" ."" ."" ."" ."" ."
"; } $usersummary .= "
{$usrhimself['user']}{$usrhimself['email']}{$usrhimself['full_name']}********{$srow['users_name']}---
\n"; if ($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || $usr['uid'] == $_SESSION['loginID'] || ($_SESSION['USER_RIGHT_CREATE_USER'] == 1 && $usr['parent_id'] == $_SESSION['loginID'])) { $usersummary .= "
" ."" ."" ."" ."
"; } if ( (($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 && $usr['uid'] != $_SESSION['loginID'] ) || ($_SESSION['USER_RIGHT_CREATE_USER'] == 1 && $usr['parent_id'] == $_SESSION['loginID'])) && $usr['uid']!=1) { $usersummary .= "
" ."" ."" ."" ."" ."
"; } if ($_SESSION['loginID'] == "1" && $usr['parent_id'] !=1 ) { $usersummary .= "
" ."" ."" ."" ."" ."
"; } if (($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || $_SESSION['USER_RIGHT_MANAGE_TEMPLATE'] == 1) && $usr['uid']!=1) { $usersummary .= "
" ."" ."" ."" ."" ."
"; } // users are allowed to delete all successor users (but the admin not himself) if (($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || ($_SESSION['USER_RIGHT_DELETE_USER'] == 1 && $usr['parent_id'] == $_SESSION['loginID']))&& $usr['uid']!=1) { $usersummary .= "
" ."" ."" ."" ."" ."
"; } $usersummary .= "
{$usr['user']}{$usr['email']}{$usr['full_name']}******{$usr['parent']}-----

"; if($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || $_SESSION['USER_RIGHT_CREATE_USER']) { $usersummary .= "
\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "
".$clang->gT("Add user:")."".$clang->gT("(Sent by email)")."" . "

\n"; } } if ($action == "addusergroup") { if ($_SESSION['USER_RIGHT_SUPERADMIN'] == 1) // only admins may do that { $usersummary ="
".$clang->gT("Add User Group")."
\n" . "
" . "

\n" . "\n" . "

\n"; } } if ($action == "editusergroup") { if ($_SESSION['USER_RIGHT_SUPERADMIN'] == 1) { $query = "SELECT * FROM ".db_table_name('user_groups')." WHERE ugid = ".$_GET['ugid']." AND owner_id = ".$_SESSION['loginID']; $result = db_select_limit_assoc($query, 1); $esrow = $result->FetchRow(); $usersummary = "
".sprintf($clang->gT("Editing user group (Owner: %s)"),$_SESSION['user'])."
" ."
" . "