admin_dbmodify.php
6.45 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?php
/*
* admin_dbmodify.php
*
* Copyright (c) 1999-2002 The Owl Project Team
* Licensed under the GNU GPL. For full terms see the file COPYING.
*
* $Id$
*/
require("../config/owl.php");
require("../lib/owl.lib.php");
require("../config/html.php");
if(owlusergroup($userid) != 0) exit("$lang_err_unauth_area");
if($action == "user") {
$maxsessions = $maxsessions - 1; // always is stored - 1
$sql = new Owl_DB;
$sql->query("SELECT * FROM $default->owl_users_table WHERE id = '$id'");
$sql->next_record();
$newpass = $sql->f("password");
if ($newpass == $password) {
$sql->query("UPDATE $default->owl_users_table SET groupid='$groupid',username='$loginname',name='$name',password='$password',quota_max='$quota', email='$email',notify='$notify',email='$email',attachfile='$attachfile',disabled='$disabled',noprefaccess='$noprefaccess',language='$newlanguage',maxsessions='$maxsessions' where id = '$id'");
}
else
{
$sql->query("UPDATE $default->owl_users_table SET groupid='$groupid',username='$loginname',name='$name',password='" . md5($password) ."',quota_max='$quota', email='$email', notify='$notify',attachfile='$attachfile',disabled='$disabled',noprefaccess='$noprefaccess',language='$newlanguage',maxsessions='$maxsessions' where id = '$id'");
}
// Bozz Change BEGIN
// Clean Up the member group table first
$sql->query("DELETE FROM $default->owl_users_grpmem_table WHERE userid = $id");
// Insert the new Choices the member group table with selected groups
for ( $i = 0 ; $i <= $no_groups_displayed; $i++ ) {
$checkboxfields = 'group' . $i;
if($$checkboxfields != '') {
$checkboxvalue = $$checkboxfields;
$sql->query("INSERT INTO $default->owl_users_grpmem_table (userid,groupid) VALUES ('$id', '$checkboxvalue')");
}
}
/* Bozz Change END */
header("Location: index.php?sess=$sess&action=users&owluser=$id&change=1");
}
if($action == "group") {
global $default;
$sql = new Owl_DB;
$sql->query("UPDATE $default->owl_groups_table SET name='$name' where id = '$id'");
header("Location: index.php?sess=$sess&action=groups&group=$id&change=1");
}
// BEGIN BUG FIX: #448232 mistake in admin_dbmodify.php
if($action == $lang_deleteuser) {
// END BUG FIX: #448232 mistake in admin_dbmodify.php
$sql = new Owl_DB;
$sql->query("DELETE FROM $default->owl_users_table WHERE id = '$id'");
// Bozz Change Begin
// Also Clean up the groupmember table when a user is deleted
$sql->query("DELETE FROM $default->owl_users_grpmem_table WHERE userid = $id");
// Bozz Change End
header("Location: index.php?sess=$sess&action=users");
}
if($action == "edhtml") {
$sql = new Owl_DB;
$sql->query("UPDATE $default->owl_html_table SET table_border='$border', table_header_bg='$header_bg', table_cell_bg='$cell_bg',table_cell_bg_alt='$cell_bg_alt',body_bgcolor='$body_bgcolor',body_textcolor='$body_textcolor',body_link='$body_link',body_vlink='$body_vlink',table_expand_width='$expand_width',table_collapse_width='$collapse_width', main_header_bgcolor='$main_header_bgcolor' ");
header("Location: index.php?sess=$sess&action=edhtml&change=1");
}
if($action == "edprefs") {
$sql = new Owl_DB;
if ($lookAtHD != "false" )
$lookAtHD = "true";
if ($owl_expand != "1")
$owl_expand = "0";
if ($version_control != "1")
$version_control = "0";
$sql->query("UPDATE $default->owl_prefs_table SET email_from='$email_from', email_fromname='$email_fromname', email_replyto='$email_replyto', email_server='$email_server', lookAtHD='$lookAtHD', def_file_security='$def_file_security', def_file_group_owner='$def_file_group_owner', def_file_owner='$def_file_owner', def_file_title='$def_file_title', def_file_meta='$def_file_meta', def_fold_security='$def_fold_security', def_fold_group_owner='$def_fold_group_owner', def_fold_owner='$def_fold_owner', max_filesize='$max_filesize', timeout='$owl_timeout', expand='$owl_expand', version_control='$version_control', restrict_view='$restrict_view', dbdump_path='$dbdump_path', gzip_path='$gzip_path', tar_path='$tar_path'");
header("Location: index.php?sess=$sess&action=edprefs&change=1");
}
// BEGIN BUG FIX: #448232 mistake in admin_dbmodify.php
if($action == $lang_deletegroup ) {
// END BUG FIX: #448232 mistake in admin_dbmodify.php
global $default;
$sql = new Owl_DB;
$sql->query("DELETE FROM $default->owl_groups_table WHERE id = '$id'");
header("Location: index.php?sess=$sess&action=groups");
}
if($action == "add") {
if($type == "user") {
$maxsessions = $maxsessions - 1; // always is stored - 1
$sql = new Owl_DB;
$sql->query("SELECT * FROM $default->owl_users_table WHERE username = '$loginname'");
if($sql->num_rows($sql) > 0) die ("$lang_err_user_exists");
$sql->query("INSERT INTO $default->owl_users_table (groupid,username,name,password,quota_max,quota_current,email,notify,attachfile,disabled,noprefaccess,language,maxsessions) VALUES ('$groupid', '$loginname', '$name', '" . md5($password) . "', '$quota', '0', '$email', '$notify','$attachfile', '$disabled', '$noprefaccess', '$newlanguage', '$maxsessions')");
// Bozz Change BEGIN
// Populated the member group table with selected groups
$sql->query("SELECT id FROM $default->owl_users_table WHERE username = '$loginname'");
$sql->next_record();
$newuid = $sql->f("id");
for ( $i = 0 ; $i <= $no_groups_displayed; $i++ ) {
$checkboxfields = 'group' . $i;
if($$checkboxfields != '') {
$checkboxvalue = $$checkboxfields;
$sql->query("INSERT INTO $default->owl_users_grpmem_table (userid,groupid) VALUES ('$newuid', '$checkboxvalue')");
}
}
/* Bozz Change END */
if($home == "1") {
$sql->query("select * from $default->owl_users_table where username = '$loginname'");
while($sql->next_record()) $id = $sql->f("id");
$sql->query("insert into $default->owl_folders_table values (0, '$loginname', '2', '54', '$groupid', '$id')");
mkdir($default->owl_fs_root."/".fid_to_name("1")."/Home/$loginname", 0777);
}
header("Location: index.php?sess=$sess");
} elseif($type == "group") {
$sql = new Owl_DB;
$sql->query("INSERT INTO $default->owl_groups_table (name) VALUES ('$name')");
header("Location: index.php?sess=$sess");
}
}
?>