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
|
#!/usr/bin/php
<?php
/**
* $Horde: horde/scripts/remove_prefs.php,v 1.3.10.7 2006/04/18 16:25:31 jan Exp $
*
* This script removes a pref from users' settings. Helps when a setting is
* to be moved from locked = false, to locked = true and there have already
* been prefs set by the users.
*/
/**
** Set this to true if you want DB modifications done.
**/
$live = false;
// No auth.
@define('AUTH_HANDLER', true);
// Find the base file path of Horde.
@define('HORDE_BASE', dirname(__FILE__) . '/..');
// Do CLI checks and environment setup first.
require_once HORDE_BASE . '/lib/core.php';
require_once 'Horde/CLI.php';
// Make sure no one runs this from the web.
if (!Horde_CLI::runningFromCLI()) {
exit("Must be run from the command line\n");
}
// Load the CLI environment - make sure there's no time limit, init
// some variables, etc.
Horde_CLI::init();
$cli = &new Horde_CLI();
require_once HORDE_BASE . '/lib/base.php';
require_once 'Horde/DataTree.php';
require_once 'Horde/Group.php';
require_once 'Horde/Share.php';
/* Make sure there's no compression. */
ob_end_clean();
$scope = $cli->prompt(_("Enter value for pref_scope:"));
$name = $cli->prompt(_("Enter value for pref_name:"));
/* Open the database. */
$db = &DB::connect($conf['sql']);
if (is_a($db, 'PEAR_Error')) {
var_dump($db); exit;
}
// Set DB portability options.
switch ($db->phptype) {
case 'mssql':
$db->setOption('portability', DB_PORTABILITY_LOWERCASE | DB_PORTABILITY_ERRORS | DB_PORTABILITY_RTRIM);
break;
default:
$db->setOption('portability', DB_PORTABILITY_LOWERCASE | DB_PORTABILITY_ERRORS);
}
if ($live) {
$sql = 'DELETE FROM horde_prefs WHERE pref_scope = ? AND pref_name = ?';
$values = array($scope, $name);
$result = $db->getAll($sql, $values);
if (is_a($result, 'PEAR_Error')) {
var_dump($result);
} elseif (empty($result)) {
$cli->writeln(sprintf(_("No preference \"%s\" found in scope \"%s\"."), $name, $scope));
} else {
$cli->writeln(sprintf(_("Preferences \"%s\" deleted in scope \"%s\"."), $name, $scope));
}
} else {
$sql = 'SELECT * FROM horde_prefs WHERE pref_scope = ? AND pref_name = ?';
$values = array($scope, $name);
$result = $db->getAll($sql, $values);
if (empty($result)) {
$cli->writeln(sprintf(_("No preference \"%s\" found in scope \"%s\"."), $name, $scope));
} else {
var_dump($result);
}
}
|
