"; //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";
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";
}
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"
. "".$clang->gT("Set User Rights").": ".htmlspecialchars(sanitize_user($_POST['user']))."
\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";
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"
. "
".$clang->gT("Action")."
\n"
. "
".$clang->gT("Username")."
\n"
. "
".$clang->gT("Email")."
\n"
. "
".$clang->gT("Full name")."
\n"
. "
".$clang->gT("Password")."
\n"
. "
".$clang->gT("Created by")."
\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";
// 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 .= "
{$usr['parent']}
\n";
} else
{
$usersummary .= "
-----
\n";
}
$usersummary .= "
\n";
$row++;
}
$usersummary .= "
";
if($_SESSION['USER_RIGHT_SUPERADMIN'] == 1 || $_SESSION['USER_RIGHT_CREATE_USER'])
{
$usersummary .= " \n";
}
}
if ($action == "addusergroup")
{
if ($_SESSION['USER_RIGHT_SUPERADMIN'] == 1) // only admins may do that
{
$usersummary ="
".$clang->gT("Add User Group")."
\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'])."
"
."\n";
}
}
if ($action == "mailusergroup")
{
$query = "SELECT a.ugid, a.name, a.owner_id, b.uid FROM ".db_table_name('user_groups') ." AS a LEFT JOIN ".db_table_name('user_in_groups') ." AS b ON a.ugid = b.ugid WHERE a.ugid = {$ugid} AND uid = {$_SESSION['loginID']} ORDER BY name";
$result = db_execute_assoc($query); //Checked
$crow = $result->FetchRow();
$usersummary = "
";
}
$eguquery = "SELECT * FROM ".db_table_name("user_in_groups")." AS a INNER JOIN ".db_table_name("users")." AS b ON a.uid = b.uid WHERE ugid = " . $ugid . " ORDER BY b.users_name";
$eguresult = db_execute_assoc($eguquery); //Checked
$usergroupsummary .= "
\n"
. "
\n"
. "
".$clang->gT("Action")."
\n"
. "
".$clang->gT("Username")."
\n"
. "
".$clang->gT("Email")."
\n"
. "
\n";
$query2 = "SELECT ugid FROM ".db_table_name('user_groups')." WHERE ugid = ".$ugid." AND owner_id = ".$_SESSION['loginID'];
$result2 = db_select_limit_assoc($query2, 1);
$row2 = $result2->FetchRow();
$row = 1;
$usergroupentries='';
while ($egurow = $eguresult->FetchRow())
{
if (!isset($bgcc)) {$bgcc="evenrow";}
else
{
if ($bgcc == "evenrow") {$bgcc = "oddrow";}
else {$bgcc = "evenrow";}
}
if($egurow['uid'] == $crow['owner_id'])
{
$usergroupowner = "
\n";
}
function updateusergroup($name, $description, $ugid)
{
global $dbprefix, $scriptname, $connect;
$uquery = "UPDATE ".db_table_name('user_groups')." SET name = '$name', description = '$description' WHERE ugid =$ugid";
// TODO
return $connect->Execute($uquery) or safe_die($connect->ErrorMsg()) ; //Checked
}
function refreshtemplates() {
global $connect ;
global $dbprefix ;
$template_a = gettemplatelist();
foreach ($template_a as $tp) {
// check for each folder if there is already an entry in the database
// if not create it with current user as creator (user with rights "create user" can assign template rights)
$query = "SELECT * FROM ".$dbprefix."templates WHERE folder LIKE '".$tp."'";
$result = db_execute_assoc($query) or safe_die($connect->ErrorMsg()); //Checked
if ($result->RecordCount() == 0) {
$query2 = "INSERT INTO ".$dbprefix."templates (".db_quote_id('folder').",".db_quote_id('creator').") VALUES ('".$tp."', ".$_SESSION['loginID'].')' ;
$connect->Execute($query2) or safe_die($connect->ErrorMsg()); //Checked
}
}
return true;
}
// adds Usergroups in Database by Moses
function addUserGroupInDB($group_name, $group_description) {
global $connect;
$iquery = "INSERT INTO ".db_table_name('user_groups')." (name, description, owner_id) VALUES('{$group_name}', '{$group_description}', '{$_SESSION['loginID']}')";
if($connect->Execute($iquery)) { //Checked
$id = $connect->Insert_Id(db_table_name_nq('user_groups'),'ugid');
if($id > 0) {
$iquery = "INSERT INTO ".db_table_name('user_in_groups')." VALUES($id, '{$_SESSION['loginID']}')";
$connect->Execute($iquery ) or safe_die($connect->ErrorMsg()); //Checked
}
return $id;
} else {
return -1;
}
}
?>