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
|
<?php
require_once dirname(__FILE__) . '/../init.php';
$stmt = "SELECT MAX(usr_id)+1 FROM eventum_user";
$res = DB_Helper::getInstance()->getOne($stmt);
if (PEAR::isError($res)) {
echo 'ERROR: ', $res->getMessage(), ': ', $res->getDebugInfo(), "\n";
exit(1);
}
$new_usr_id = $res;
$stmt = "UPDATE eventum_user SET usr_id = $new_usr_id WHERE usr_id = 1";
$res = DB_Helper::getInstance()->query($stmt);
if (PEAR::isError($res)) {
echo 'ERROR: ', $res->getMessage(), ': ', $res->getDebugInfo(), "\n";
exit(1);
}
$fixes = array(
"UPDATE eventum_custom_filter SET cst_usr_id = $new_usr_id WHERE cst_usr_id = 1",
"UPDATE eventum_issue SET iss_usr_id = $new_usr_id WHERE iss_usr_id = 1",
"UPDATE eventum_issue_attachment SET iat_usr_id = $new_usr_id WHERE iat_usr_id = 1",
"UPDATE eventum_issue_requirement SET isr_usr_id = $new_usr_id WHERE isr_usr_id = 1",
"UPDATE eventum_issue_user SET isu_usr_id = $new_usr_id WHERE isu_usr_id = 1",
"UPDATE eventum_note SET not_usr_id = $new_usr_id WHERE not_usr_id = 1",
"UPDATE eventum_project SET prj_lead_usr_id = $new_usr_id WHERE prj_lead_usr_id = 1",
"UPDATE eventum_project_user SET pru_usr_id = $new_usr_id WHERE pru_usr_id = 1",
"UPDATE eventum_subscription SET sub_usr_id = $new_usr_id WHERE sub_usr_id = 1",
"UPDATE eventum_time_tracking SET ttr_usr_id = $new_usr_id WHERE ttr_usr_id = 1",
"UPDATE eventum_phone_support SET phs_usr_id = $new_usr_id WHERE phs_usr_id = 1",
"UPDATE eventum_reminder_action_list SET ral_usr_id = $new_usr_id WHERE ral_usr_id = 1",
"UPDATE eventum_news SET nws_usr_id = $new_usr_id WHERE nws_usr_id = 1",
"UPDATE eventum_round_robin_user SET rru_usr_id = $new_usr_id WHERE rru_usr_id = 1",
"UPDATE eventum_email_draft SET emd_usr_id = $new_usr_id WHERE emd_usr_id = 1"
);
foreach ($fixes as $stmt) {
$res = DB_Helper::getInstance()->query($stmt);
if (PEAR::isError($res)) {
echo 'ERROR: ', $res->getMessage(), ': ', $res->getDebugInfo(), "\n";
exit(1);
}
}
// add the system account as user id == 1
$stmt = "INSERT INTO
eventum_user
(
usr_id,
usr_created_date,
usr_password,
usr_full_name,
usr_email,
usr_role,
usr_preferences
) VALUES (
1,
'" . Date_Helper::getCurrentDateGMT() . "',
'14589714398751513457adf349173434',
'system',
'system-account@example.com',
5,
''
)";
$res = DB_Helper::getInstance()->query($stmt);
if (PEAR::isError($res)) {
echo 'ERROR: ', $res->getMessage(), ': ', $res->getDebugInfo(), "\n";
exit(1);
}
|