"); // if usergroupid invalid then unauthorised view and exit if($usergroupid != "0") { die("$lang_err_unauthorized"); } // if not action set ..set action to users if(!isset($action)) { $action = "users"; } //------------------------------------------------------------- /** * Function PrintUsers * * Prints the users out * */ //------------------------------------------------------------- // Semi-Usable - Interface based function printusers() { global $sess, $default, $lang_users; //create a new connection $sql = new Owl_DB; // create a new active session $sql_active_sess = new Owl_DB; $sql->query("select username,name,id,maxsessions from $default->owl_users_table order by name"); /* print(""); print("

table_header_bg>$lang_users

"); print(""); print(""); print("

"); while($sql->next_record()) { $uid = $sql->f("id"); $username = $sql->f("username"); $name = $sql->f("name"); $maxsess = $sql->f("maxsessions") + 1; $numrows = 0; $sql_active_sess->query("select * from $default->owl_sessions_table where uid = $uid"); $sql_active_sess->next_record(); $numrows = $sql_active_sess->num_rows($sql_active_sess); if ($name == "") print("".$username.""); else if ($uid == $owluser) print("(".$numrows."/".$maxsess.") ".$name.""); else print("(".$numrows."/".$maxsess.") ".$name.""); } print("

"); */ print("table_border>"); while($sql->next_record()) { // loop through record getting user information $uid = $sql->f("id"); $username = $sql->f("username"); $name = $sql->f("name"); $maxsess = $sql->f("maxsessions") + 1; $numrows = 0; // find active sessions $sql_active_sess->query("select * from $default->owl_sessions_table where uid = $uid"); $sql_active_sess->next_record(); $numrows = $sql_active_sess->num_rows($sql_active_sess); // print out information ->not usable if ($name == "") print(""); else print(""); print(""); } print("

table_header_bg>$lang_users	table_header_bg>
".$username."
".$name."	(".$numrows."/".$maxsess.")

"); } //------------------------------------------------------------- /** * Function PrintGroups * * Prints the Groups out * */ //------------------------------------------------------------- // Semi-Usable -> Interface Based function printgroups() {// print out all groups global $sess, $lang_groups, $default; $sql = new Owl_DB; $sql->query("select name,id from $default->owl_groups_table order by name"); print("table_border>"); while($sql->next_record()) { print(""); } print("

table_header_bg>$lang_groups

".$sql->f("name")."

"); } //------------------------------------------------------------- /** * Function PrintUsr($id) * * Prints the User out * * @param $id * The Id of the user who's info is to be printed * */ //------------------------------------------------------------- // Semi-Usable -> Interface Based function printuser($id) { //declare globals global $sess,$change,$lang_saved,$lang_title,$lang_group,$lang_username,$lang_password,$lang_change,$lang_quota,$lang_groupmember,$lang_noprefaccess,$lang_disableuser, $lang_userlang, $lang_maxsessions, $lang_attach_file; global $lang_flush_sessions_alt, $lang_flushed, $lang_deleteuser, $lang_email, $lang_notification, $default, $flush; if($change == 1) { print("$lang_saved
"); } if ($flush == 1) { flushsessions($id, $sess); print($lang_flushed); } $sql = new Owl_DB; $sql->query("select id,name from $default->owl_groups_table order by name"); $i=0; // store groups in array while($sql->next_record()) { $groups[$i][0] = $sql->f("id"); $groups[$i][1] = $sql->f("name"); $i++; } $sql->query("select * from $default->owl_users_table where id = '$id'"); //post to dbmodify any changes and their values while($sql->next_record()) { print(""); print(""); print(""); print(""); print("table_border>"); print(""); //******************************* // Display the Language dropdown //******************************* print(""); // Bozz Change begin //This is to allow a user to be part of more than one group // assign a user to more than one group print(""); print(""); print(""); print(""); print(""); // if notify is on ..set its value to checked if ( $sql->f("notify") == 1) { print(""); } else { print(""); } // if attachfile is on ..set its value to checked if ( $sql->f("attachfile") == 1) { print(""); } else { print(""); } if ($id != 1) { // if disabled is on ..set its value to checked if ( $sql->f("disabled") == 1) { print(""); } else { print(""); } // if noprefaccess is on ..set its value to checked if ( $sql->f("noprefaccess") == 1) { print(""); } else { print(""); } } print("

table_header_bg align=right>$lang_title
table_header_bg align=right>$lang_group	"); print("".group_to_name($sql->f("groupid"))); foreach($groups as $g) { print("$g[1]"); } print("
table_header_bg align=right>$lang_userlang	"); print("".$sql->f("language")); $dir = dir($default->owl_LangDir); $dir->rewind(); while($file=$dir->read()) { if ($file != "." and $file != "..") print("$file"); } $dir->close(); print("
table_header_bg align=right>$lang_groupmember	"); $i=0; $sqlmemgroup = new Owl_DB; foreach($groups as $g) { $is_set_gid = $g[0]; $sqlmemgroup->query("select userid from $default->owl_users_grpmem_table where userid = '$id' and groupid = '$is_set_gid'"); $sqlmemgroup->next_record(); if ($sqlmemgroup->num_rows($sqlmemgroup) > 0) { print("$g[1] "); } else { print("$g[1] "); } $i++; } // This hidden field is to store the nubmer of displayed groups for future use // when the records are saved to the db print(""); // Bozz Change End print("
table_header_bg ALIGN=RIGHT>$lang_username
table_header_bg align=right>$lang_quota	".$sql->f("quota_current")." /
table_header_bg align=right>$lang_maxsessions	".($sql->f("maxsessions") + 1)." /
table_header_bg align=right>$lang_password
table_header_bg align=right>$lang_email
table_header_bg align=right>$lang_notification
table_header_bg align=right>$lang_notification
table_header_bg align=right>$lang_attach_file
table_header_bg align=right>$lang_attach_file
table_header_bg align=right>$lang_disableuser
table_header_bg align=right>$lang_disableuser
table_header_bg align=right>$lang_noprefaccess
table_header_bg align=right>$lang_noprefaccess

"); // delete user if id != 1 if ($sql->f("id") != 1) { print(""); } print(""); } } //------------------------------------------------------------- /** * Function flushsessions($id, $sess) * * Flushes the session variable form the db * * @param $id * The Id of the user * @param $sess * The session variable */ //------------------------------------------------------------- // Usable function flushsessions($id, $sess) { global $default; $sql= new Owl_DB; $sql->query("delete from $default->owl_sessions_table where uid='$id' AND sessid!='$sess'"); } //------------------------------------------------------------- /** * Function printgroup($id) * * Prints out the group * * @param $id * The Id of the user * */ //------------------------------------------------------------- // Semi-Usable -> interface based function printgroup($id) { global $sess,$change,$lang_title,$lang_change,$lang_deletegroup,$lang_saved,$default; if(isset($change)) { print("$lang_saved
"); } $sql = new Owl_DB; $sql->query("select id,name from $default->owl_groups_table where id = '$id'"); // post to dbmodify with several values while($sql->next_record()) { print("

"); print(""); print(""); print(""); print("table_border>

table_header_bg>$lang_title

"); print("
"); // delete the group if($sql->f("id") != 0) { print(""); } print("

"); } } //------------------------------------------------------------- /** * Function printnewgroup() * * Prints out a new group * */ //------------------------------------------------------------- // NOT Usable function printnewgroup() { global $default, $sess,$lang_title,$lang_add; print("

"); print(""); print(""); print(""); print("table_border>

table_header_bg>$lang_title

"); } //------------------------------------------------------------- /** * Function printnewuserr() * * Prints out a new user * */ //------------------------------------------------------------- // Semi-Usable function printnewuser() { global $sess,$lang_title,$lang_username,$lang_group,$lang_password,$lang_add,$default, $lang_quota,$lang_groupmember; global $lang_email, $lang_notification, $lang_noprefaccess, $lang_disableuser, $lang_userlang, $lang_maxsessions, $lang_attach_file; $sql = new Owl_DB; $sql->query("select id,name from $default->owl_groups_table order by name"); $i=0; // get all groups while($sql->next_record()) { $groups[$i][0] = $sql->f("id"); $groups[$i][1] = $sql->f("name"); $i++; } print("

"); print(""); print(""); print(""); print("table_border>"); print(""); print(""); //******************************* // Display the Language dropdown //******************************* print(""); // Bozz Change begin //This is to allow a user to be part of more than one group print(""); print(""); print(""); print(""); print(""); print(""); print(""); print("

table_header_bg align=right>$lang_title
table_header_bg align=right>$lang_username
table_header_bg align=right>$lang_group	"); foreach($groups as $g) { print("$g[1]"); } print("
table_header_bg align=right>$lang_userlang	"); $dir = dir($default->owl_LangDir); $dir->rewind(); while($file=$dir->read()) { if ($file != "." and $file != "..") { //janu's change BEGIN print("owl_lang) print (" SELECTED"); print(">$file"); //janu's change END } } $dir->close(); print("
table_header_bg align=right>$lang_groupmember	"); $i=0; foreach($groups as $g) { print("$g[1] "); $i++; } // This hidden field is to store the nubmer of displayed groups for future use // when the records are saved to the db print(""); // Bozz Change End print("
table_header_bg align=right>$lang_quota
table_header_bg align=right>$lang_maxsessions
table_header_bg align=right>$lang_password
table_header_bg align=right>$lang_email
table_header_bg align=right>$lang_attach_file
table_header_bg align=right>$lang_disableuser
table_header_bg align=right>$lang_noprefaccess

"); } //------------------------------------------------------------- /** * Function printHTML() * * Prints out the required HTML * */ //------------------------------------------------------------- // NOT Usable function printhtml() { global $default, $sess, $lang_add, $lang_change, $change, $lang_saved; global $lang_ht_tbl_border_sz, $lang_ht_tbl_hd_bg, $lang_ht_tbl_cell_bg_cl, $lang_ht_tbl_cell_bg_al, $lang_ht_tbl_bg_cl, $lang_ht_expand_width, $lang_ht_collapse_width, $lang_ht_bd_bg_cl, $lang_ht_bd_txt_cl, $lang_ht_bd_lnk_cl, $lang_ht_bd_vlnk_cl, $lang_ht_bd_width; if(isset($change)) print("$lang_saved
"); print("

"); print(""); print(""); print(""); print("table_border>"); print(""); print(""); print(""); print(""); print(""); print(""); print(""); print(""); print(""); print(""); print(""); print("

table_header_bg align=right>$lang_ht_tbl_border_sz
table_header_bg align=right>$lang_ht_tbl_hd_bg	table_header_bg>
table_header_bg align=right>$lang_ht_tbl_cell_bg_cl
table_header_bg align=right>$lang_ht_tbl_cell_bg_al
table_header_bg align=right>$lang_ht_expand_width
table_header_bg align=right>$lang_ht_collapse_width
table_header_bg align=right>Main Header Background Color
table_header_bg align=right>$lang_ht_bd_bg_cl
table_header_bg align=right>$lang_ht_bd_txt_cl
table_header_bg align=right>$lang_ht_bd_lnk_cl
table_header_bg align=right>$lang_ht_bd_vlnk_cl

"); } //------------------------------------------------------------- /** * Function printPrefs() * * Prints out the preferences in a specific format * */ //------------------------------------------------------------- // NOT Usable function printprefs() { global $default, $sess, $lang_add, $lang_change, $change, $lang_saved; global $lang_owl_title_email, $lang_owl_email_from, $lang_owl_email_fromname, $lang_owl_email_replyto , $lang_owl_email_server, $lang_owl_title_HD, $lang_owl_lookAtHD, $lang_owl_def_file_security, $lang_owl_def_file_group_owner, $lang_owl_def_file_owner, $lang_owl_def_file_title, $lang_owl_def_file_meta , $lang_owl_def_fold_sec, $lang_owl_def_fold_group_owner, $lang_owl_def_fold_owner, $lang_owl_title_other, $lang_owl_max_filesize, $lang_owl_owl_timeout, $lang_owl_owl_expand, $lang_owl_version_control, $lang_owl_restrict_view ; global $lang_owl_title_tools, $lang_owl_dbdump_path,$lang_owl_gzip_path, $lang_owl_tar_path; if(isset($change)) print("$lang_saved
"); print("

"); print(""); print(""); print(""); print("table_border>"); print(""); print(""); print(""); print(""); print(""); print(""); if ( $default->owl_LookAtHD == "false" ) { print(""); print(""); print(""); print(""); print(""); print(""); print(""); print(""); print(""); } else { print(""); printfileperm($default->owl_def_file_security, "def_file_security", $lang_owl_def_file_security, "user"); $sql = new Owl_DB; $sql->query("select id,name from $default->owl_groups_table"); $i=0; // get all groups while($sql->next_record()) { $groups[$i][0] = $sql->f("id"); $groups[$i][1] = $sql->f("name"); $i++; } print(""); $sql = new Owl_DB; $sql->query("select id,name from $default->owl_users_table"); $i=0; // get all users while($sql->next_record()) { $users[$i][0] = $sql->f("id"); $users[$i][1] = $sql->f("name"); $i++; } print(""); print(""); print(""); printgroupperm($default->owl_def_fold_security, "def_fold_security", $lang_owl_def_fold_sec, "user"); print(""); print(""); } print(""); print(""); print(""); //if expansion is true if ( $default->expand == 1 ) { print(""); } else { print(""); } // if version control checked if ( $default->owl_version_control == 1 ) { print(""); } else { print(""); } // restrict view checked if true if ( $default->restrict_view == 1 ) { print(""); } else { print(""); } print(""); print(""); print(""); print(""); print("

main_header_bgcolor align=CENTER colspan=2>$lang_owl_title_email
table_header_bg align=right>$lang_owl_email_from
table_header_bg align=right>$lang_owl_email_fromname
table_header_bg align=right>$lang_owl_email_replyto
table_header_bg align=right>$lang_owl_email_server
main_header_bgcolor align=CENTER colspan=2>$lang_owl_title_HD
table_header_bg align=right>$lang_owl_lookAtHD
table_header_bg align=right>$lang_owl_lookAtHD
table_header_bg>$lang_owl_def_file_group_owner	"); // loop through all groups foreach($groups as $g) { print("owl_def_file_group_owner) print("SELECTED"); print(">$g[1]"); } print("
table_header_bg>$lang_owl_def_file_owner	"); // loop through users foreach($users as $g) { print("owl_def_file_owner) print("SELECTED"); print(">$g[1]"); } print("
table_header_bg align=right>$lang_owl_def_file_title
table_header_bg align=right>$lang_owl_def_file_meta
table_header_bg>$lang_owl_def_fold_group_owner	"); foreach($groups as $g) { print("owl_def_fold_group_owner) print("SELECTED"); print(">$g[1]"); } print("
table_header_bg>$lang_owl_def_fold_owner	"); foreach($users as $g) { print("owl_def_fold_owner) print("SELECTED"); print(">$g[1]"); } print("
main_header_bgcolor align=CENTER colspan=2>$lang_owl_title_other
table_header_bg align=right>$lang_owl_max_filesize
table_header_bg align=right>$lang_owl_owl_timeout
table_header_bg align=right>$lang_owl_owl_expand
table_header_bg align=right>$lang_owl_owl_expand:
table_header_bg align=right>$lang_owl_version_control
table_header_bg align=right>$lang_owl_version_control
table_header_bg align=right>$lang_owl_restrict_view
table_header_bg align=right>$lang_owl_restrict_view
main_header_bgcolor align=CENTER colspan=2>$lang_owl_title_tools
table_header_bg align=right>$lang_owl_dbdump_path
table_header_bg align=right>$lang_owl_gzip_path
table_header_bg align=right>$lang_owl_tar_path

"); } //------------------------------------------------------------- /** * Function DoBackup() * * Does a backup by zipping relevant data * */ //------------------------------------------------------------- // NOT Usable function dobackup() { global $default; $command = $default->dbdump_path . " --opt --host=" . $default->owl_db_host . " --user=" . $default->owl_db_user . " --password=" . $default->owl_db_pass . " " . $default->owl_db_name . " | " . $default->gzip_path . " -fc"; $date = date("Ymd.Hms"); header("Content-Disposition: attachment; filename=\"" . $default->owl_db_name . "-$date.sql.gz\""); header("Content-Location: " . $default->owl_db_name . "-$date.sql.gz"); header("Content-Type: application/octet-stream"); //header("Content-Length: $fsize"); //header("Pragma: no-cache"); header("Expires: 0"); passthru($command); exit(); } // if action has been selected..do it.. if($action) { print("table_expand_width BGCOLOR=$default->main_header_bgcolor CELLSPACING=0 CELLPADDING=0 BORDER=$default->table_border HEIGHT=30>"); print(""); print(""); print(""); print(""); print(""); print("

"); print("
"); print uid_to_name($userid); print(" : $lang_logout	$lang_owl_admin

"); print("

---

table_expand_width>
"); print("table_expand_width BORDER=$default->table_border>

"); print("table_border> "); print(" "); print(" "); print(" "); print(" "); if (file_exists($default->dbdump_path) && file_exists($default->gzip_path)) { print(" "); } else { print(" "); } // print("$lang_upg_MD5 "); printusers(); print(" "); printgroups(); print(" "); print("

"); // if user action selected..print user if(isset($owluser)) { printuser($owluser); } //if group action selected print group if(isset($group)) { printgroup($group); } // if newgroup action slelected print the new group if($action == "newgroup") { printnewgroup(); } // if the newuser action print the new user if($action == "newuser") { printnewuser(); } //if the edit html action has been selected run the printHTML if($action == "edhtml") { printhtml(); } // if edit preferences selected print the preferences if($action == "edprefs") { printprefs(); } print("

"); } else { exit("$lang_err_general"); } print("

---

table_expand_width>
"); ?>