-
Notifications
You must be signed in to change notification settings - Fork 120
/
dbinstall.php
1325 lines (1237 loc) · 103 KB
/
dbinstall.php
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
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<?php
/* Copyright (c) Anuko International Ltd. https://www.anuko.com
License: See license.txt */
require_once('WEB-INF/config.php');
require_once('WEB-INF/lib/common.lib.php');
require_once('initialize.php');
import('ttUserHelper');
import('ttTaskHelper');
import('ttRoleHelper');
import('ttOrgHelper');
// TODO: we need an installer.
// ttExecute - executes an sql statement and prints either an error or a success message.
function ttExecute($sql) {
print "<pre>".$sql."</pre>";
$mdb2 = getConnection();
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
print '<font color="red">Error: '.$affected->getMessage().'.</font><br>';
else
print "Successful update.<br>\n";
}
// ttGenerateKeys - generates keys for groups that do not have them.
function ttGenerateKeys() {
$mdb2 = getConnection();
$sql = "select id from tt_groups where group_key is null and status = 1";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) die($res->getMessage());
$numGroups = 0;
while ($val = $res->fetchRow()) {
$group_id = $val['id'];
$group_key = $mdb2->quote(ttRandomString());
$sql = "update tt_groups set group_key = $group_key where id = $group_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) die($affected->getMessage());
$numGroups++;
}
print "<br>Generated keys for $numGroups groups.<br>\n";
}
if ($request->isGet()) {
echo('<h2>Environment Checks</h2>');
// Determine if cookies are enabled in browser.
// session_start(); // already called in initialize.php.
$session_id1 = session_id();
session_destroy();
session_start();
$session_id2 = session_id();
if ($session_id1 != $session_id2) {
echo('<font color="red">Error: browser cookies are off.</font><br>');
}
// Check if WEB-INF/templates_c dir is writable.
if (is_writable(APP_DIR.'/WEB-INF/templates_c/')) {
echo('WEB-INF/templates_c/ directory is writable.<br>');
} else {
echo('<font color="red">Error: WEB-INF/templates_c/ directory is not writable.</font><br>');
}
// Require the configuration file with application settings.
if (file_exists(APP_DIR."/WEB-INF/config.php")) {
echo('WEB-INF/config.php file exists.<br>');
// Config file must start with the PHP opening tag. We are checking this because
// a Unicode editor may insert a byte order mark (BOM) before it.
// This is not good as it is printed as unintentional white space in output.
// Consequences:
// 1) PHP redirects may stop working, depending on server settings.
// 2) PDF reports and attachment downloads will become unusable (cannot open files).
$file = fopen(APP_DIR.'/WEB-INF/config.php', 'r');
$line = fgets($file);
if (strcmp("<?php\n", $line) !== 0 && strcmp("<?php\r\n", $line) !== 0) {
echo('<font color="red">Error: WEB-INF/config.php file does not start with a PHP opening tag.</font> See <a href="https://www.anuko.com/lp/tt_33.htm" target="_blank">explanation</a>.<br>');
}
fclose($file);
} else {
echo('<font color="red">Error: WEB-INF/config.php file does not exist.</font><br>');
}
// Check whether DSN is defined.
if (defined('DSN')) {
// echo('DSN is defined as '.DSN.'<br>');
echo('DSN is defined.<br>');
} else {
echo('<font color="red">Error: DSN value is not defined. Check your config.php file.</font><br>');
}
// Check if PHP version is good enough.
$required_version = '7.0'; // smarty 4.3.0 that we embed uses null coalescing operator (introduced in php 7).
// Print a warning about php <= 7.4 because we are no longer testing there.
if (version_compare(phpversion(), '7.4', '<')) {
echo('<font color="red">Warning: This app is no longer tested with PHP version: '.phpversion().'.</font><br>');
}
// Print a warning about php >= 8.2 because of insufficient testing there.
if (version_compare(phpversion(), '8.2', '>=')) {
echo('<font color="red">Error: This app was not tested with PHP version: '.phpversion().'.</font><br>');
} else {
if (version_compare(phpversion(), $required_version, '>=')) {
echo('PHP version: '.phpversion().', good enough.<br>');
} else {
echo('<font color="red">Error: PHP version is not high enough: '.phpversion().'. Required: '.$required_version.'.</font><br>');
}
}
// Depending on DSN, require either mysqli or mysql extensions.
if (strrpos(DSN, 'mysqli://', -strlen(DSN)) !== FALSE) {
if (extension_loaded('mysqli')) {
echo('mysqli PHP extension is loaded.<br>');
} else {
echo('<font color="red">Error: mysqli PHP extension is required but is not loaded.</font><br>');
}
}
if (strrpos(DSN, 'mysql://', -strlen(DSN)) !== FALSE) {
if (extension_loaded('mysql')) {
echo('mysql PHP extension is loaded.<br>');
} else {
echo('<font color="red">Error: mysql PHP extension is required but is not loaded.</font><br>');
}
}
// Check mbstring extension.
if (extension_loaded('mbstring')) {
echo('mbstring PHP extension is loaded.<br>');
} else {
echo('<font color="red">Error: mbstring PHP extension is not loaded.</font><br>');
}
// Check gd extension.
if (extension_loaded('gd')) {
echo('gd PHP extension is loaded.<br>');
} else {
echo('<font color="red">Error: gd PHP extension is not loaded. It is required for charts plugin.</font><br>');
}
// Check ldap extension.
if (AUTH_MODULE == 'ldap') {
if (extension_loaded('ldap')) {
echo('ldap PHP extension is loaded.<br>');
} else {
echo('<font color="red">Error: ldap PHP extension is not loaded. It is required for LDAP authentication.</font><br>');
}
}
// Check is libxml is enabled (which is a PHP default).
if (!function_exists('libxml_clear_errors')) {
echo('<font color="red">Error: libxml is not enabled. It is required for import group operation (to parse XML).</font><br>');
}
// Check database access.
require_once('MDB2.php');
$conn = MDB2::connect(DSN);
if (!is_a($conn, 'MDB2_Error')) {
echo('Connection to database successful.<br>');
} else {
die('<font color="red">Error: connection to database failed. '.$conn->getMessage().'</font><br>');
}
$conn->setOption('debug', true);
$conn->setFetchMode(MDB2_FETCHMODE_ASSOC);
$sql = "show tables";
$res = $conn->query($sql);
if (is_a($res, 'MDB2_Error')) {
die('<font color="red">Error: show tables returned an error. '.$res->getMessage().'</font><br>');
}
$tblCnt = 0;
while ($val = $res->fetchRow()) {
$tblCnt++;
}
if ($tblCnt > 0) {
echo("There are $tblCnt tables in database.<br>");
} else {
echo('<font color="red">There are no tables in database. Execute step 1 - Create database structure.</font><br>');
}
try {
$sql = "select param_value from tt_site_config where param_name = 'version_db'";
$res = $conn->query($sql);
if (is_a($res, 'MDB2_Error')) {
echo('<font color="red">Error: database schema version query failed. '.$res->getMessage().'</font><br>');
} else {
$val = $res->fetchRow();
echo('Database version is: '.$val['param_value'].'.');
}
} catch (Exception $e) {
echo('<font color="red">Caught exception: '.$e->getMessage().'</font><br>');
}
$conn->disconnect();
}
if ($_POST) {
print "Processing...<br>\n";
if (array_key_exists('crstructure', $_POST)) {
$sqlQuery = join("\n", file("mysql.sql"));
$sqlQuery = str_replace("TYPE=MyISAM","",$sqlQuery);
$queries = explode(";",$sqlQuery);
if (is_array($queries)) {
foreach ($queries as $query) {
$query = trim($query);
if (strlen($query)>0) {
ttExecute($query);
}
}
}
}
if (array_key_exists('convert5to7', $_POST)) {
ttExecute("alter table `activity_log` CHANGE al_comment al_comment text");
ttExecute("CREATE TABLE `sysconfig` (`sysc_id` int(11) unsigned NOT NULL auto_increment,`sysc_name` varchar(32) NOT NULL default '',`sysc_value` varchar(70) default NULL, PRIMARY KEY (`sysc_id`), UNIQUE KEY `sysc_id` (`sysc_id`), UNIQUE KEY `sysc_name` (`sysc_name`))");
ttExecute("alter table `companies` add c_locktime int(4) default -1");
ttExecute("alter table `activity_log` add al_billable tinyint(4) default 0");
ttExecute("alter table `sysconfig` drop INDEX `sysc_name`");
ttExecute("alter table `sysconfig` add sysc_id_u int(4)");
ttExecute("alter table `report_filter_set` add rfs_billable VARCHAR(10)");
ttExecute("ALTER TABLE clients MODIFY clnt_id int(11) NOT NULL AUTO_INCREMENT");
ttExecute("ALTER TABLE `users` ADD `u_show_pie` smallint(2) DEFAULT '1'");
ttExecute("alter table `users` ADD `u_pie_mode` smallint(2) DEFAULT '1'");
ttExecute("alter table users drop `u_aprojects`");
}
if (array_key_exists('convert7to133', $_POST)) {
ttExecute("ALTER TABLE users ADD COLUMN u_lang VARCHAR(20) DEFAULT NULL");
ttExecute("ALTER TABLE users ADD COLUMN u_email VARCHAR(100) DEFAULT NULL");
ttExecute("ALTER TABLE `activity_log` drop `al_proof`");
ttExecute("ALTER TABLE `activity_log` drop `al_charge`");
ttExecute("ALTER TABLE `activities` drop `a_project_id`");
ttExecute("DROP TABLE `activity_status_list`");
ttExecute("DROP TABLE `project_status_list`");
ttExecute("DROP TABLE `user_status_list`");
ttExecute("DROP TABLE `companies_c_id_seq`");
ttExecute("ALTER TABLE projects ADD COLUMN p_activities TEXT");
}
// The update_projects function updates p_activities field in the projects table so that we could
// improve performance of the application by using this field instead of activity_bind table.
if (array_key_exists('update_projects', $_POST)) {
$mdb2 = getConnection();
// $sql = "select p_id from projects where p_status = 1 and p_activities is NULL";
$sql = "select p_id from projects where p_status = 1";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
// Iterate through projects.
while ($val = $res->fetchRow()) {
$project_id = $val['p_id'];
// Get activity binds for project (old way).
// $sql = "select ab_id_a from activity_bind where ab_id_p = $project_id";
$sql = "select ab_id_a, a_id, a_name from activity_bind
inner join activities on (ab_id_a = a_id)
where ab_id_p = $project_id order by a_name";
$result = $mdb2->query($sql);
if (is_a($result, 'PEAR_Error')) {
die($result->getMessage());
}
$activity_arr = array();
while ($value = $result->fetchRow()) {
$activity_arr[] = $value['ab_id_a'];
}
$a_comma_separated = implode(",", $activity_arr); // This is a comma-separated list of associated activity ids.
// Re-bind the project to activities (new way).
$sql = "update projects set p_activities = ".$mdb2->quote($a_comma_separated)." where p_id = $project_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) {
die($affected->getMessage());
}
}
}
if (array_key_exists('convert133to1340', $_POST)) {
ttExecute("ALTER TABLE companies ADD COLUMN c_show_pie smallint(2) DEFAULT 1");
ttExecute("ALTER TABLE companies ADD COLUMN c_pie_mode smallint(2) DEFAULT 1");
ttExecute("ALTER TABLE companies ADD COLUMN c_lang varchar(20) default NULL");
}
// The update_companies function sets up c_show_pie, c_pie_mode, and c_lang
// fields in the companies table from the corresponding manager fields.
if (array_key_exists('update_companies', $_POST)) {
$mdb2 = getConnection();
// Get all active managers.
$sql = "select u_company_id, u_show_pie, u_pie_mode, u_lang from users
where u_manager_id is NULL and u_login <> 'admin' and u_company_id is not NULL and u_active = 1";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
// Iterate through managers and set fields in the companies table.
while ($val = $res->fetchRow()) {
$company_id = $val['u_company_id'];
$show_pie = $val['u_show_pie'];
$pie_mode = $val['u_pie_mode'];
$lang = $val['u_lang'];
$sql = "update companies set
c_show_pie = $show_pie, c_pie_mode = $pie_mode, c_lang = ".$mdb2->quote($lang).
" where c_id = $company_id";
$result = $mdb2->query($sql);
if (is_a($result, 'PEAR_Error')) {
die($result->getMessage());
}
}
}
if (array_key_exists('convert1340to1485', $_POST)) {
ttExecute("ALTER TABLE users DROP u_show_pie");
ttExecute("ALTER TABLE users DROP u_pie_mode");
ttExecute("ALTER TABLE users DROP u_lang");
ttExecute("ALTER TABLE `users` modify u_login varchar(100) NOT NULL");
ttExecute("ALTER TABLE `users` modify u_active smallint(6) default '1'");
ttExecute("drop index u_login_idx on users");
ttExecute("create unique index u_login_idx on users(u_login, u_active)");
ttExecute("ALTER TABLE companies MODIFY `c_lang` varchar(20) NOT NULL default 'en'");
ttExecute("ALTER TABLE companies ADD COLUMN `c_date_format` varchar(20) NOT NULL default '%Y-%m-%d'");
ttExecute("ALTER TABLE companies ADD COLUMN `c_time_format` varchar(20) NOT NULL default '%H:%M'");
ttExecute("ALTER TABLE companies ADD COLUMN `c_week_start` smallint(2) NOT NULL DEFAULT '0'");
ttExecute("ALTER TABLE clients MODIFY `clnt_status` smallint(6) default '1'");
ttExecute("create unique index clnt_name_idx on clients(clnt_id_um, clnt_name, clnt_status)");
ttExecute("ALTER TABLE projects modify p_status smallint(6) default '1'");
ttExecute("update projects set p_status = NULL where p_status = 1000");
ttExecute("drop index p_manager_idx on projects");
ttExecute("create unique index p_name_idx on projects(p_manager_id, p_name, p_status)");
ttExecute("ALTER TABLE activities modify a_status smallint(6) default '1'");
ttExecute("update activities set a_status = NULL where a_status = 1000");
ttExecute("drop index a_manager_idx on activities");
ttExecute("create unique index a_name_idx on activities(a_manager_id, a_name, a_status)");
ttExecute("RENAME TABLE companies TO teams");
ttExecute("RENAME TABLE teams TO att_teams");
ttExecute("ALTER TABLE att_teams CHANGE c_id id int(11) NOT NULL auto_increment");
ttExecute("RENAME TABLE users TO att_users");
ttExecute("update att_users set u_company_id = 0 where u_company_id is NULL");
ttExecute("ALTER TABLE att_users CHANGE u_company_id team_id int(11) NOT NULL");
ttExecute("RENAME TABLE att_teams TO tt_teams");
ttExecute("RENAME TABLE att_users TO tt_users");
ttExecute("ALTER TABLE tt_teams CHANGE c_name name varchar(80) NOT NULL");
ttExecute("ALTER TABLE `tt_teams` drop `c_www`");
ttExecute("ALTER TABLE `tt_teams` MODIFY `name` varchar(80) default NULL");
ttExecute("ALTER TABLE clients ADD COLUMN `your_name` varchar(255) default NULL");
ttExecute("ALTER TABLE tt_teams ADD COLUMN `address` varchar(255) default NULL");
ttExecute("ALTER TABLE invoice_header ADD COLUMN `client_name` varchar(255) default NULL");
ttExecute("ALTER TABLE invoice_header ADD COLUMN `client_addr` varchar(255) default NULL");
ttExecute("ALTER TABLE report_filter_set ADD COLUMN `rfs_cb_cost` tinyint(4) default '0'");
ttExecute("ALTER TABLE activity_log DROP primary key");
ttExecute("ALTER TABLE activity_log ADD COLUMN `id` bigint NOT NULL auto_increment primary key");
ttExecute("CREATE TABLE `tt_custom_fields` (`id` int(11) NOT NULL auto_increment, `team_id` int(11) NOT NULL, `type` tinyint(4) NOT NULL default '0', `label` varchar(32) NOT NULL default '', PRIMARY KEY (`id`))");
ttExecute("CREATE TABLE `tt_custom_field_options` (`id` int(11) NOT NULL auto_increment, `field_id` int(11) NOT NULL, `value` varchar(32) NOT NULL default '', PRIMARY KEY (`id`))");
ttExecute("CREATE TABLE `tt_custom_field_log` (`id` bigint NOT NULL auto_increment, `al_id` bigint NOT NULL, `field_id` int(11) NOT NULL, `value` varchar(255) default NULL, PRIMARY KEY (`id`))");
ttExecute("ALTER TABLE tt_users DROP u_level");
ttExecute("ALTER TABLE tt_custom_fields ADD COLUMN `status` tinyint(4) default '1'");
ttExecute("ALTER TABLE report_filter_set ADD COLUMN `rfs_cb_cf_1` tinyint(4) default '0'");
ttExecute("ALTER TABLE tt_teams ADD COLUMN `plugins` varchar(255) default NULL");
ttExecute("ALTER TABLE tt_teams MODIFY c_locktime int(4) default '0'");
ttExecute("ALTER TABLE clients DROP your_name");
ttExecute("ALTER TABLE clients DROP clnt_addr_your");
ttExecute("ALTER TABLE `tt_custom_fields` ADD COLUMN `required` tinyint(4) default '0'");
ttExecute("ALTER TABLE tt_teams DROP c_pie_mode");
ttExecute("RENAME TABLE report_filter_set TO tt_fav_reports");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_id id int(11) unsigned NOT NULL auto_increment");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_name name varchar(200) NOT NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_id_u user_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_id_p project_id int(11) default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_id_a task_id int(11) default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_users users text default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_period period tinyint(4) default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_period_start period_start date default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_period_finish period_end date default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_project show_project tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_activity show_task tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_note show_note tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_start show_start tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_finish show_end tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_duration show_duration tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_cost show_cost tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_cf_1 show_custom_field_1 tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_idle show_empty_days tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_cb_totals_only show_totals_only tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_groupby group_by varchar(20) default NULL");
ttExecute("ALTER TABLE tt_fav_reports CHANGE rfs_billable billable tinyint(4) default NULL");
ttExecute("ALTER TABLE projects CHANGE p_activities tasks text default NULL");
ttExecute("ALTER TABLE tt_teams CHANGE c_currency currency varchar(7) default NULL");
ttExecute("ALTER TABLE tt_teams CHANGE c_locktime locktime int(4) default '0'");
ttExecute("ALTER TABLE tt_teams CHANGE c_show_pie show_pie smallint(2) DEFAULT '1'");
ttExecute("ALTER TABLE tt_teams CHANGE c_lang lang varchar(10) NOT NULL default 'en'");
ttExecute("ALTER TABLE tt_teams CHANGE c_date_format date_format varchar(20) NOT NULL default '%Y-%m-%d'");
ttExecute("ALTER TABLE tt_teams CHANGE c_time_format time_format varchar(20) NOT NULL default '%H:%M'");
ttExecute("ALTER TABLE tt_teams CHANGE c_week_start week_start smallint(2) NOT NULL DEFAULT '0'");
ttExecute("ALTER TABLE tt_users CHANGE u_id id int(11) NOT NULL auto_increment");
ttExecute("ALTER TABLE tt_users CHANGE u_timestamp timestamp timestamp NOT NULL");
ttExecute("ALTER TABLE tt_users CHANGE u_login login varchar(50) NOT NULL");
ttExecute("drop index u_login_idx on tt_users");
ttExecute("create unique index login_idx on tt_users(login, u_active)");
ttExecute("ALTER TABLE tt_users CHANGE u_password password varchar(50) default NULL");
ttExecute("ALTER TABLE tt_users CHANGE u_name name varchar(100) default NULL");
ttExecute("ALTER TABLE tt_users CHANGE u_email email varchar(100) default NULL");
ttExecute("ALTER TABLE tt_users CHANGE u_rate rate float(6,2) NOT NULL default '0.00'");
ttExecute("update tt_users set u_active = NULL where u_active = 1000");
ttExecute("ALTER TABLE tt_users CHANGE u_active status tinyint(4) default '1'");
ttExecute("ALTER TABLE tt_teams ADD COLUMN status tinyint(4) default '1'");
ttExecute("ALTER TABLE tt_users ADD COLUMN role int(11) default '4'");
ttExecute("update tt_users set role = 1024 where login = 'admin'");
ttExecute("update tt_users set role = 68 where u_comanager = 1");
ttExecute("update tt_users set role = 324 where u_manager_id is null and login != 'admin'");
ttExecute("ALTER TABLE user_bind CHANGE ub_checked status tinyint(4) default '1'");
ttExecute("ALTER TABLE activities ADD COLUMN team_id int(11) NOT NULL");
ttExecute("ALTER TABLE clients ADD COLUMN team_id int(11) NOT NULL");
ttExecute("ALTER TABLE projects ADD COLUMN team_id int(11) NOT NULL");
}
// The update_to_team_id function sets team_id field projects, activities, and clients tables.
if (array_key_exists('update_to_team_id', $_POST)) {
$mdb2 = getConnection();
// Update projects.
$sql = "select p_id, p_manager_id from projects where team_id = 0 limit 1000";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
// Iterate through projects.
$projects_updated = 0;
while ($val = $res->fetchRow()) {
$project_id = $val['p_id'];
$manager_id = $val['p_manager_id'];
$sql = "select team_id from tt_users where id = $manager_id";
$res2 = $mdb2->query($sql);
if (is_a($res2, 'PEAR_Error')) {
die($res2->getMessage());
}
$val2 = $res2->fetchRow();
$team_id = $val2['team_id'];
if ($team_id) {
$sql = "update projects set team_id = $team_id where p_id = $project_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) {
die($affected->getMessage());
}
$projects_updated += $affected;
}
}
print "Updated $projects_updated projects...<br>\n";
// Update tasks.
$sql = "select a_id, a_manager_id from activities where team_id = 0 limit 1000";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
// Iterate through tasks.
$tasks_updated = 0;
while ($val = $res->fetchRow()) {
$task_id = $val['a_id'];
$manager_id = $val['a_manager_id'];
$sql = "select team_id from tt_users where id = $manager_id";
$res2 = $mdb2->query($sql);
if (is_a($res2, 'PEAR_Error')) {
die($res2->getMessage());
}
$val2 = $res2->fetchRow();
$team_id = $val2['team_id'];
if ($team_id) {
$sql = "update activities set team_id = $team_id where a_id = $task_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) {
die($affected->getMessage());
}
$tasks_updated += $affected;
}
}
print "Updated $tasks_updated tasks...<br>\n";
// Update clients.
$sql = "select clnt_id, clnt_id_um from clients where team_id = 0 limit 1000";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
// Iterate through clients.
$clients_updated = 0;
while ($val = $res->fetchRow()) {
$client_id = $val['clnt_id'];
$manager_id = $val['clnt_id_um'];
$sql = "select team_id from tt_users where id = $manager_id";
$res2 = $mdb2->query($sql);
if (is_a($res2, 'PEAR_Error')) {
die($res2->getMessage());
}
$val2 = $res2->fetchRow();
$team_id = $val2['team_id'];
if ($team_id) {
$sql = "update clients set team_id = $team_id where clnt_id = $client_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) {
die($affected->getMessage());
}
$clients_updated += $affected;
}
}
print "Updated $clients_updated clients...<br>\n";
}
if (array_key_exists('convert1485to1579', $_POST)) {
ttExecute("ALTER TABLE tt_fav_reports MODIFY id int(11) NOT NULL auto_increment");
ttExecute("RENAME TABLE clients TO tt_clients");
ttExecute("ALTER TABLE tt_clients CHANGE clnt_id id int(11) NOT NULL AUTO_INCREMENT");
ttExecute("ALTER TABLE tt_clients CHANGE clnt_status status tinyint(4) default '1'");
ttExecute("ALTER TABLE tt_clients DROP clnt_id_um");
ttExecute("ALTER TABLE tt_clients CHANGE clnt_name name varchar(80) NOT NULL");
ttExecute("drop index clnt_name_idx on tt_clients");
ttExecute("drop index client_name_idx on tt_clients");
ttExecute("create unique index client_name_idx on tt_clients(team_id, name, status)");
ttExecute("ALTER TABLE tt_teams ADD COLUMN `timestamp` timestamp NOT NULL");
ttExecute("ALTER TABLE tt_clients CHANGE clnt_addr_cust address varchar(255) default NULL");
ttExecute("ALTER TABLE tt_clients DROP clnt_discount");
ttExecute("ALTER TABLE tt_clients DROP clnt_comment");
ttExecute("ALTER TABLE tt_clients DROP clnt_fsubtotals");
ttExecute("ALTER TABLE tt_clients CHANGE clnt_tax tax float(6,2) NOT NULL default '0.00'");
ttExecute("ALTER TABLE activity_log ADD COLUMN client_id int(11) default NULL");
ttExecute("ALTER TABLE tt_teams DROP show_pie");
ttExecute("ALTER TABLE tt_fav_reports CHANGE group_by sort_by varchar(20) default 'date'");
ttExecute("RENAME TABLE tmp_refs TO tt_tmp_refs");
ttExecute("ALTER TABLE tt_tmp_refs CHANGE tr_created timestamp timestamp NOT NULL");
ttExecute("ALTER TABLE tt_tmp_refs CHANGE tr_code ref char(32) NOT NULL default ''");
ttExecute("ALTER TABLE tt_tmp_refs CHANGE tr_userid user_id int(11) NOT NULL");
ttExecute("RENAME TABLE projects TO tt_projects");
ttExecute("ALTER TABLE tt_projects CHANGE p_id id int(11) NOT NULL auto_increment");
ttExecute("ALTER TABLE tt_projects DROP p_timestamp");
ttExecute("ALTER TABLE tt_projects CHANGE p_name name varchar(80) NOT NULL");
ttExecute("ALTER TABLE tt_projects CHANGE p_status status tinyint(4) default '1'");
ttExecute("drop index p_name_idx on tt_projects");
ttExecute("create unique index project_idx on tt_projects(team_id, name, status)");
ttExecute("RENAME TABLE activities TO tt_tasks");
ttExecute("ALTER TABLE tt_tasks CHANGE a_id id int(11) NOT NULL auto_increment");
ttExecute("ALTER TABLE tt_tasks DROP a_timestamp");
ttExecute("ALTER TABLE tt_tasks CHANGE a_name name varchar(80) NOT NULL");
ttExecute("ALTER TABLE tt_tasks CHANGE a_status status tinyint(4) default '1'");
ttExecute("drop index a_name_idx on tt_tasks");
ttExecute("create unique index task_idx on tt_tasks(team_id, name, status)");
ttExecute("RENAME TABLE invoice_header TO tt_invoice_headers");
ttExecute("ALTER TABLE tt_invoice_headers CHANGE ih_user_id user_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_invoice_headers CHANGE ih_number number varchar(20) default NULL");
ttExecute("ALTER TABLE tt_invoice_headers DROP ih_addr_your");
ttExecute("ALTER TABLE tt_invoice_headers DROP ih_addr_cust");
ttExecute("ALTER TABLE tt_invoice_headers CHANGE ih_comment comment varchar(255) default NULL");
ttExecute("ALTER TABLE tt_invoice_headers CHANGE ih_tax tax float(6,2) default '0.00'");
ttExecute("ALTER TABLE tt_invoice_headers CHANGE ih_discount discount float(6,2) default '0.00'");
ttExecute("ALTER TABLE tt_invoice_headers CHANGE ih_fsubtotals subtotals tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_users DROP u_comanager");
ttExecute("ALTER TABLE tt_tasks DROP a_manager_id");
ttExecute("ALTER TABLE tt_projects DROP p_manager_id");
ttExecute("ALTER TABLE tt_users DROP u_manager_id");
ttExecute("ALTER TABLE activity_bind DROP ab_id");
ttExecute("RENAME TABLE activity_bind TO tt_project_task_binds");
ttExecute("ALTER TABLE tt_project_task_binds CHANGE ab_id_p project_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_project_task_binds CHANGE ab_id_a task_id int(11) NOT NULL");
ttExecute("RENAME TABLE user_bind TO tt_user_project_binds");
ttExecute("ALTER TABLE tt_user_project_binds CHANGE ub_rate rate float(6,2) NOT NULL default '0.00'");
ttExecute("ALTER TABLE tt_user_project_binds CHANGE ub_id_p project_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_user_project_binds CHANGE ub_id_u user_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_user_project_binds CHANGE ub_id id int(11) NOT NULL auto_increment");
ttExecute("CREATE TABLE `tt_client_project_binds` (`client_id` int(11) NOT NULL, `project_id` int(11) NOT NULL)");
ttExecute("ALTER TABLE tt_user_project_binds MODIFY rate float(6,2) default '0.00'");
ttExecute("ALTER TABLE tt_clients MODIFY tax float(6,2) default '0.00'");
ttExecute("RENAME TABLE activity_log TO tt_log");
ttExecute("ALTER TABLE tt_log CHANGE al_timestamp timestamp timestamp NOT NULL");
ttExecute("ALTER TABLE tt_log CHANGE al_user_id user_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_log CHANGE al_date date date NOT NULL");
ttExecute("drop index al_date_idx on tt_log");
ttExecute("create index date_idx on tt_log(date)");
ttExecute("ALTER TABLE tt_log CHANGE al_from start time default NULL");
ttExecute("ALTER TABLE tt_log CHANGE al_duration duration time default NULL");
ttExecute("ALTER TABLE tt_log CHANGE al_project_id project_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_log MODIFY project_id int(11) default NULL");
ttExecute("ALTER TABLE tt_log CHANGE al_activity_id task_id int(11) default NULL");
ttExecute("ALTER TABLE tt_log CHANGE al_comment comment text");
ttExecute("ALTER TABLE tt_log CHANGE al_billable billable tinyint(4) default '0'");
ttExecute("drop index al_user_id_idx on tt_log");
ttExecute("drop index al_project_id_idx on tt_log");
ttExecute("drop index al_activity_id_idx on tt_log");
ttExecute("create index user_idx on tt_log(user_id)");
ttExecute("create index project_idx on tt_log(project_id)");
ttExecute("create index task_idx on tt_log(task_id)");
ttExecute("ALTER TABLE tt_custom_field_log CHANGE al_id log_id bigint NOT NULL");
ttExecute("RENAME TABLE sysconfig TO tt_config");
ttExecute("ALTER TABLE tt_config DROP sysc_id");
ttExecute("ALTER TABLE tt_config CHANGE sysc_id_u user_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_config CHANGE sysc_name param_name varchar(32) NOT NULL");
ttExecute("ALTER TABLE tt_config CHANGE sysc_value param_value varchar(80) default NULL");
ttExecute("create unique index param_idx on tt_config(user_id, param_name)");
ttExecute("ALTER TABLE tt_log ADD COLUMN invoice_id int(11) default NULL");
ttExecute("ALTER TABLE tt_projects ADD COLUMN description varchar(255) default NULL");
ttExecute("CREATE TABLE `tt_invoices` (`id` int(11) NOT NULL auto_increment, `team_id` int(11) NOT NULL, `number` varchar(20) default NULL, `client_name` varchar(255) default NULL, `client_addr` varchar(255) default NULL, `comment` varchar(255) default NULL, `tax` float(6,2) default '0.00', `discount` float(6,2) default '0.00', PRIMARY KEY (`id`))");
ttExecute("ALTER TABLE tt_invoices drop number");
ttExecute("ALTER TABLE tt_invoices drop client_name");
ttExecute("ALTER TABLE tt_invoices drop client_addr");
ttExecute("ALTER TABLE tt_invoices drop comment");
ttExecute("ALTER TABLE tt_invoices drop tax");
ttExecute("ALTER TABLE tt_invoices ADD COLUMN name varchar(80) NOT NULL");
ttExecute("ALTER TABLE tt_invoices ADD COLUMN client_id int(11) NOT NULL");
ttExecute("ALTER TABLE tt_invoices ADD COLUMN start_date date NOT NULL");
ttExecute("ALTER TABLE tt_invoices ADD COLUMN end_date date NOT NULL");
ttExecute("create unique index name_idx on tt_invoices(team_id, name)");
ttExecute("drop index ub_id_u on tt_user_project_binds");
ttExecute("create unique index bind_idx on tt_user_project_binds(user_id, project_id)");
ttExecute("create index client_idx on tt_log(client_id)");
ttExecute("create index invoice_idx on tt_log(invoice_id)");
}
if (array_key_exists('convert1579to1600', $_POST)) {
ttExecute("ALTER TABLE tt_invoices ADD COLUMN date date NOT NULL");
ttExecute("ALTER TABLE tt_teams ADD COLUMN custom_logo tinyint(4) default '0'");
ttExecute("ALTER TABLE tt_tasks ADD COLUMN description varchar(255) default NULL");
ttExecute("ALTER TABLE tt_projects MODIFY name varchar(80) COLLATE utf8_bin NOT NULL");
ttExecute("ALTER TABLE tt_users MODIFY login varchar(50) COLLATE utf8_bin NOT NULL");
ttExecute("ALTER TABLE tt_tasks MODIFY name varchar(80) COLLATE utf8_bin NOT NULL");
ttExecute("ALTER TABLE tt_invoices MODIFY name varchar(80) COLLATE utf8_bin NOT NULL");
ttExecute("ALTER TABLE tt_clients MODIFY name varchar(80) COLLATE utf8_bin NOT NULL");
ttExecute("ALTER TABLE tt_clients ADD COLUMN projects text default NULL");
ttExecute("ALTER TABLE tt_custom_field_log ADD COLUMN option_id int(11) default NULL");
ttExecute("ALTER TABLE tt_teams ADD COLUMN tracking_mode smallint(2) NOT NULL DEFAULT '2'");
ttExecute("ALTER TABLE tt_teams ADD COLUMN record_type smallint(2) NOT NULL DEFAULT '0'");
ttExecute("ALTER TABLE tt_invoices DROP start_date");
ttExecute("ALTER TABLE tt_invoices DROP end_date");
}
// The update_clients function updates projects field in tt_clients table.
if (array_key_exists('update_clients', $_POST)) {
$mdb2 = getConnection();
$sql = "select id from tt_clients where status = 1 or status = 0";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
$clients_updated = 0;
// Iterate through clients.
while ($val = $res->fetchRow()) {
$client_id = $val['id'];
// Get projects binds for client.
$sql = "select cpb.project_id from tt_client_project_binds cpb
left join tt_projects p on (p.id = cpb.project_id)
where cpb.client_id = $client_id order by p.name";
$result = $mdb2->query($sql);
if (is_a($result, 'PEAR_Error'))
die($result->getMessage());
$project_arr = array();
while ($value = $result->fetchRow()) {
$project_arr[] = $value['project_id'];
}
$comma_separated = implode(',', $project_arr); // This is a comma-separated list of associated project ids.
// Update the projects field.
$sql = "update tt_clients set projects = ".$mdb2->quote($comma_separated)." where id = $client_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
die($affected->getMessage());
$clients_updated += $affected;
}
print "Updated $clients_updated clients...<br>\n";
}
// The update_custom_fields function updates option_id field in tt_custom_field_log table.
if (array_key_exists('update_custom_fields', $_POST)) {
$mdb2 = getConnection();
$sql = "update tt_custom_field_log set option_id = value where option_id is null and value is not null and field_id in (select id from tt_custom_fields where type = 2)";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
die($affected->getMessage());
print "Updated $affected custom fields...<br>\n";
}
// The update_tracking_mode function sets the tracking_mode field in tt_teams table to 2 (== MODE_PROJECTS_AND_TASKS).
if (array_key_exists('update_tracking_mode', $_POST)) {
$mdb2 = getConnection();
$sql = "update tt_teams set tracking_mode = 2 where tracking_mode = 0";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
die($affected->getMessage());
print "Updated $affected teams...<br>\n";
}
if (array_key_exists('convert1600to11400', $_POST)) {
ttExecute("DROP TABLE IF EXISTS tt_invoice_headers");
ttExecute("ALTER TABLE tt_fav_reports ADD COLUMN `client_id` int(11) default NULL");
ttExecute("ALTER TABLE tt_fav_reports ADD COLUMN `cf_1_option_id` int(11) default NULL");
ttExecute("ALTER TABLE tt_fav_reports ADD COLUMN `show_client` tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports ADD COLUMN `show_invoice` tinyint(4) NOT NULL default '0'");
ttExecute("ALTER TABLE tt_fav_reports ADD COLUMN `group_by` varchar(20) default NULL");
ttExecute("CREATE TABLE `tt_expense_items` (`id` bigint NOT NULL auto_increment, `date` date NOT NULL, `user_id` int(11) NOT NULL, `client_id` int(11) default NULL, `project_id` int(11) default NULL, `name` varchar(255) NOT NULL, `cost` decimal(10,2) default '0.00', `invoice_id` int(11) default NULL, PRIMARY KEY (`id`))");
ttExecute("create index date_idx on tt_expense_items(date)");
ttExecute("create index user_idx on tt_expense_items(user_id)");
ttExecute("create index client_idx on tt_expense_items(client_id)");
ttExecute("create index project_idx on tt_expense_items(project_id)");
ttExecute("create index invoice_idx on tt_expense_items(invoice_id)");
ttExecute("ALTER TABLE tt_fav_reports DROP sort_by");
ttExecute("ALTER TABLE tt_fav_reports DROP show_empty_days");
ttExecute("ALTER TABLE tt_invoices DROP discount");
ttExecute("ALTER TABLE tt_users ADD COLUMN `client_id` int(11) default NULL");
ttExecute("ALTER TABLE tt_teams ADD COLUMN `decimal_mark` char(1) NOT NULL default '.'");
ttExecute("ALTER TABLE tt_fav_reports ADD COLUMN `invoice` tinyint(4) default NULL");
ttExecute("CREATE TABLE `tt_cron` (`id` int(11) NOT NULL auto_increment, `cron_spec` varchar(255) NOT NULL, `last` int(11) default NULL, `next` int(11) default NULL, `report_id` int(11) default NULL, `email` varchar(100) default NULL, `status` tinyint(4) default '1', PRIMARY KEY (`id`))");
ttExecute("ALTER TABLE tt_cron ADD COLUMN `team_id` int(11) NOT NULL");
ttExecute("create index client_idx on tt_client_project_binds(client_id)");
ttExecute("create index project_idx on tt_client_project_binds(project_id)");
ttExecute("ALTER TABLE tt_log ADD COLUMN status tinyint(4) default '1'");
ttExecute("ALTER TABLE tt_custom_field_log ADD COLUMN status tinyint(4) default '1'");
ttExecute("ALTER TABLE tt_expense_items ADD COLUMN status tinyint(4) default '1'");
ttExecute("ALTER TABLE tt_invoices ADD COLUMN status tinyint(4) default '1'");
ttExecute("DROP INDEX name_idx on tt_invoices");
ttExecute("create unique index name_idx on tt_invoices(team_id, name, status)");
ttExecute("ALTER TABLE tt_teams ADD COLUMN lock_spec varchar(255) default NULL");
ttExecute("ALTER TABLE tt_teams DROP locktime");
ttExecute("CREATE TABLE `tt_monthly_quota` (`team_id` int(11) NOT NULL, `year` smallint(5) UNSIGNED NOT NULL, `month` tinyint(3) UNSIGNED NOT NULL, `quota` smallint(5) UNSIGNED NOT NULL, PRIMARY KEY (`year`,`month`,`team_id`))");
ttExecute("ALTER TABLE `tt_monthly_quota` ADD CONSTRAINT `FK_TT_TEAM_CONSTRAING` FOREIGN KEY (`team_id`) REFERENCES `tt_teams` (`id`) ON DELETE CASCADE ON UPDATE CASCADE");
ttExecute("ALTER TABLE `tt_teams` ADD `workday_hours` SMALLINT NULL DEFAULT '8' AFTER `lock_spec`");
ttExecute("RENAME TABLE tt_monthly_quota TO tt_monthly_quotas");
ttExecute("ALTER TABLE tt_expense_items modify `name` text NOT NULL");
ttExecute("ALTER TABLE `tt_teams` ADD `uncompleted_indicators` SMALLINT(2) NOT NULL DEFAULT '0' AFTER `record_type`");
ttExecute("CREATE TABLE `tt_predefined_expenses` (`id` int(11) NOT NULL auto_increment, `team_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `cost` decimal(10,2) default '0.00', PRIMARY KEY (`id`))");
ttExecute("ALTER TABLE `tt_teams` ADD `task_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
ttExecute("ALTER TABLE `tt_teams` ADD `project_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
ttExecute("ALTER TABLE `tt_cron` ADD `report_condition` varchar(255) default NULL AFTER `email`");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `status` tinyint(4) default '1'");
ttExecute("ALTER TABLE `tt_teams` ADD `bcc_email` varchar(100) default NULL AFTER `uncompleted_indicators`");
ttExecute("ALTER TABLE `tt_cron` ADD `cc` varchar(100) default NULL AFTER `email`");
ttExecute("ALTER TABLE `tt_cron` ADD `subject` varchar(100) default NULL AFTER `cc`");
ttExecute("ALTER TABLE `tt_log` ADD `paid` tinyint(4) NULL default '0' AFTER `billable`");
}
if (array_key_exists('convert11400to11744', $_POST)) {
ttExecute("ALTER TABLE `tt_teams` DROP `address`");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `report_spec` text default NULL AFTER `user_id`");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `paid_status` tinyint(4) default NULL AFTER `invoice`");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `show_paid` tinyint(4) NOT NULL DEFAULT '0' AFTER `show_invoice`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `paid` tinyint(4) NULL default '0' AFTER `invoice_id`");
ttExecute("ALTER TABLE `tt_monthly_quotas` MODIFY `quota` decimal(5,2) NOT NULL");
ttExecute("ALTER TABLE `tt_teams` MODIFY `workday_hours` decimal(5,2) DEFAULT '8.00'");
ttExecute("ALTER TABLE `tt_teams` ADD `config` text default NULL AFTER `custom_logo`");
ttExecute("ALTER TABLE `tt_monthly_quotas` ADD `minutes` int(11) DEFAULT NULL");
ttExecute("ALTER TABLE `tt_teams` ADD `workday_minutes` smallint(4) DEFAULT '480' AFTER `workday_hours`");
ttExecute("UPDATE `tt_teams` SET `workday_minutes` = 60 * `workday_hours`");
ttExecute("ALTER TABLE `tt_teams` DROP `workday_hours`");
ttExecute("UPDATE `tt_monthly_quotas` SET `minutes` = 60 * `quota`");
ttExecute("ALTER TABLE `tt_monthly_quotas` DROP `quota`");
ttExecute("ALTER TABLE `tt_teams` DROP `uncompleted_indicators`");
ttExecute("ALTER TABLE `tt_users` MODIFY `timestamp` timestamp default CURRENT_TIMESTAMP");
ttExecute("ALTER TABLE `tt_teams` MODIFY `timestamp` timestamp default CURRENT_TIMESTAMP");
ttExecute("ALTER TABLE `tt_log` MODIFY `timestamp` timestamp default CURRENT_TIMESTAMP");
ttExecute("ALTER TABLE `tt_tmp_refs` MODIFY `timestamp` timestamp default CURRENT_TIMESTAMP");
ttExecute("CREATE TABLE `tt_roles` (`id` int(11) NOT NULL auto_increment, `team_id` int(11) NOT NULL, `name` varchar(80) default NULL, `rank` int(11) default 0, `rights` text default NULL, `status` tinyint(4) default 1, PRIMARY KEY (`id`))");
ttExecute("create unique index role_idx on tt_roles(team_id, `rank`, status)");
ttExecute("ALTER TABLE `tt_roles` ADD `description` varchar(255) default NULL AFTER `name`");
ttExecute("ALTER TABLE `tt_users` ADD `role_id` int(11) default NULL AFTER `role`");
ttExecute("CREATE TABLE `tt_site_config` (`param_name` varchar(32) NOT NULL, `param_value` text default NULL, `created` datetime default NULL, `updated` datetime default NULL, PRIMARY KEY (`param_name`))");
ttExecute("INSERT INTO `tt_site_config` (`param_name`, `param_value`, `created`) VALUES ('version_db', '1.17.34', now())");
ttExecute("INSERT INTO `tt_roles` (`team_id`, `name`, `rank`, `rights`) VALUES (0, 'Site administrator', 1024, 'administer_site')");
ttExecute("INSERT INTO `tt_roles` (`team_id`, `name`, `rank`, `rights`) VALUES (0, 'Top manager', 512, 'data_entry,view_own_data,manage_own_settings,view_users,on_behalf_data_entry,view_data,override_punch_mode,swap_roles,approve_timesheets,manage_users,manage_projects,manage_tasks,manage_custom_fields,manage_clients,manage_invoices,manage_features,manage_basic_settings,manage_advanced_settings,manage_roles,export_data,manage_subgroups')");
ttExecute("UPDATE `tt_site_config` SET `param_value` = '1.17.35' where param_name = 'version_db'");
ttExecute("update `tt_users` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.35') set role_id = (select id from tt_roles where `rank` = 1024) where role = 1024");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.35') set rights = 'data_entry,view_own_reports,view_own_charts,view_own_invoices,manage_own_settings,view_users,on_behalf_data_entry,view_reports,view_charts,override_punch_mode,swap_roles,approve_timesheets,manage_users,manage_projects,manage_tasks,manage_custom_fields,manage_clients,manage_invoices,manage_features,manage_basic_settings,manage_advanced_settings,manage_roles,export_data,manage_subgroups' where team_id = 0 and `rank` = 512");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.35') set rights = replace(rights, 'view_own_data', 'view_own_reports,view_own_charts') where team_id > 0");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.35') set rights = replace(rights, 'view_data', 'view_reports,view_charts') where team_id > 0");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.35') set rights = replace(rights, 'view_own_charts,manage_own_settings', 'view_own_charts,view_own_invoices,manage_own_settings') where team_id > 0 and `rank` = 16");
ttExecute("UPDATE `tt_site_config` SET `param_value` = '1.17.40' where param_name = 'version_db'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.40') set rights = replace(rights, 'on_behalf_data_entry', 'track_time,track_expenses')");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.40') set rights = replace(rights, 'data_entry', 'track_own_time,track_own_expenses')");
ttExecute("UPDATE `tt_site_config` SET `param_value` = '1.17.43' where param_name = 'version_db'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.43') set rights = replace(rights, 'override_punch_mode,swap_roles', 'override_punch_mode,override_date_lock,swap_roles')");
ttExecute("UPDATE `tt_site_config` SET `param_value` = '1.17.44' where param_name = 'version_db'");
}
// The update_role_id function assigns a role_id to users, who don't have it.
if (array_key_exists('update_role_id', $_POST)) {
import('I18n');
$mdb2 = getConnection();
$sql = "select u.id, u.team_id, u.role, t.lang from tt_users u inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.44') left join tt_teams t on (u.team_id = t.id) where u.role_id is NULL and u.status is NOT NULL";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) die($res->getMessage());
$users_updated = 0;
// Iterate through users.
while ($val = $res->fetchRow()) {
$user_id = $val['id'];
$team_id = $val['team_id'];
$lang = $val['lang'];
$legacy_role = $val['role'];
$sql = "select count(*) as count from tt_roles where team_id = $team_id";
$result = $mdb2->query($sql);
if (is_a($result, 'PEAR_Error')) die($result->getMessage());
$row = $result->fetchRow();
if ($row['count'] == 0)
ttRoleHelper::createPredefinedRoles_1_17_44($team_id, $lang);
// Obtain new role id based on legacy role.
$role_id = ttRoleHelper::getRoleByRank_1_17_44($legacy_role, $team_id);
if (!$role_id) continue; // Role not found, nothing to do.
$sql = "update tt_users set role_id = $role_id where id = $user_id and team_id = $team_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) die($affected->getMessage());
$users_updated++;
// if ($users_updated >= 1000) break; // TODO: uncomment for large user sets to run multiple times.
}
print "Updated $users_updated users...<br>\n";
}
if (array_key_exists('convert11744to11797', $_POST)) {
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.44') set rights = replace(rights, 'override_punch_mode,override_date_lock', 'override_punch_mode,override_own_punch_mode,override_date_lock')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.48' where param_name = 'version_db' and param_value = '1.17.44'");
ttExecute("update `tt_users` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.48') set role_id = (select id from tt_roles where team_id = 0 and `rank` = 512) where role = 324");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.49' where param_name = 'version_db' and param_value = '1.17.48'");
ttExecute("ALTER TABLE `tt_users` drop role");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.50' where param_name = 'version_db' and param_value = '1.17.49'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.50') set rights = replace(rights, 'override_date_lock,swap_roles', 'override_date_lock,override_own_date_lock,swap_roles')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.51' where param_name = 'version_db' and param_value = '1.17.50'");
ttExecute("ALTER TABLE `tt_users` ADD `created` datetime default NULL AFTER `email`");
ttExecute("ALTER TABLE `tt_users` ADD `created_ip` varchar(45) default NULL AFTER `created`");
ttExecute("ALTER TABLE `tt_users` ADD `created_by` int(11) default NULL AFTER `created_ip`");
ttExecute("ALTER TABLE `tt_users` ADD `modified` datetime default NULL AFTER `created_by`");
ttExecute("ALTER TABLE `tt_users` ADD `modified_ip` varchar(45) default NULL AFTER `modified`");
ttExecute("ALTER TABLE `tt_users` ADD `modified_by` int(11) default NULL AFTER `modified_ip`");
ttExecute("ALTER TABLE `tt_users` ADD `accessed` datetime default NULL AFTER `modified_by`");
ttExecute("ALTER TABLE `tt_users` ADD `accessed_ip` varchar(45) default NULL AFTER `accessed`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.52' where param_name = 'version_db' and param_value = '1.17.51'");
ttExecute("ALTER TABLE `tt_site_config` CHANGE `updated` `modified` datetime default NULL");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.53', modified = now() where param_name = 'version_db' and param_value = '1.17.52'");
ttExecute("ALTER TABLE `tt_log` ADD `created` datetime default NULL AFTER `paid`");
ttExecute("ALTER TABLE `tt_log` ADD `created_ip` varchar(45) default NULL AFTER `created`");
ttExecute("ALTER TABLE `tt_log` ADD `created_by` int(11) default NULL AFTER `created_ip`");
ttExecute("ALTER TABLE `tt_log` ADD `modified` datetime default NULL AFTER `created_by`");
ttExecute("ALTER TABLE `tt_log` ADD `modified_ip` varchar(45) default NULL AFTER `modified`");
ttExecute("ALTER TABLE `tt_log` ADD `modified_by` int(11) default NULL AFTER `modified_ip`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.56', modified = now() where param_name = 'version_db' and param_value = '1.17.53'");
ttExecute("ALTER TABLE `tt_expense_items` ADD `created` datetime default NULL AFTER `paid`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `created_ip` varchar(45) default NULL AFTER `created`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `created_by` int(11) default NULL AFTER `created_ip`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `modified` datetime default NULL AFTER `created_by`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `modified_ip` varchar(45) default NULL AFTER `modified`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `modified_by` int(11) default NULL AFTER `modified_ip`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.59', modified = now() where param_name = 'version_db' and param_value = '1.17.56'");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `show_ip` tinyint(4) NOT NULL DEFAULT '0' AFTER `show_paid`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.61', modified = now() where param_name = 'version_db' and param_value = '1.17.59'");
ttExecute("update `tt_log` l inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.61') set l.created = l.timestamp where l.created is null");
ttExecute("ALTER TABLE `tt_log` drop `timestamp`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.64', modified = now() where param_name = 'version_db' and param_value = '1.17.61'");
ttExecute("ALTER TABLE `tt_teams` ADD `created` datetime default NULL AFTER `config`");
ttExecute("ALTER TABLE `tt_teams` ADD `created_ip` varchar(45) default NULL AFTER `created`");
ttExecute("ALTER TABLE `tt_teams` ADD `created_by` int(11) default NULL AFTER `created_ip`");
ttExecute("ALTER TABLE `tt_teams` ADD `modified` datetime default NULL AFTER `created_by`");
ttExecute("ALTER TABLE `tt_teams` ADD `modified_ip` varchar(45) default NULL AFTER `modified`");
ttExecute("ALTER TABLE `tt_teams` ADD `modified_by` int(11) default NULL AFTER `modified_ip`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.65', modified = now() where param_name = 'version_db' and param_value = '1.17.64'");
ttExecute("update `tt_teams` t inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.65') set t.created = t.timestamp where t.created is null");
ttExecute("update `tt_users` u inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.65') set u.created = u.timestamp where u.created is null");
ttExecute("ALTER TABLE `tt_teams` drop `timestamp`");
ttExecute("ALTER TABLE `tt_users` drop `timestamp`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.66', modified = now() where param_name = 'version_db' and param_value = '1.17.65'");
ttExecute("ALTER TABLE `tt_tmp_refs` ADD `created` datetime default NULL AFTER `timestamp`");
ttExecute("ALTER TABLE `tt_tmp_refs` drop `timestamp`");
ttExecute("delete from `tt_tmp_refs`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.67', modified = now() where param_name = 'version_db' and param_value = '1.17.66'");
ttExecute("ALTER TABLE `tt_teams` ADD `parent_id` int(11) default NULL AFTER `id`");
ttExecute("ALTER TABLE `tt_teams` ADD `org_id` int(11) default NULL AFTER `parent_id`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.76', modified = now() where param_name = 'version_db' and param_value = '1.17.67'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.76') set rights = replace(rights, ',manage_users', ',manage_own_account,manage_users')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.77', modified = now() where param_name = 'version_db' and param_value = '1.17.76'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.77') set rights = replace(rights, 'manage_own_settings,view_users', 'manage_own_settings,view_projects,view_users')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.78', modified = now() where param_name = 'version_db' and param_value = '1.17.77'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.78') set rights = replace(rights, 'manage_own_settings,view_projects,view_users', 'view_own_projects,manage_own_settings,view_users')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.79', modified = now() where param_name = 'version_db' and param_value = '1.17.78'");
ttExecute("RENAME TABLE `tt_teams` TO `tt_groups`");
ttExecute("ALTER TABLE `tt_monthly_quotas` DROP FOREIGN KEY FK_TT_TEAM_CONSTRAING");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.80', modified = now() where param_name = 'version_db' and param_value = '1.17.79'");
ttExecute("ALTER TABLE `tt_roles` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_users` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_projects` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_tasks` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_invoices` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_cron` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_clients` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_custom_fields` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_predefined_expenses` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("ALTER TABLE `tt_monthly_quotas` CHANGE `team_id` `group_id` int(11) NOT NULL");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.81', modified = now() where param_name = 'version_db' and param_value = '1.17.80'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.81') set rights = replace(rights, ',manage_invoices', ',manage_invoices,view_all_reports')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.82', modified = now() where param_name = 'version_db' and param_value = '1.17.81'");
ttExecute("ALTER TABLE `tt_groups` ADD `allow_ip` varchar(255) default NULL AFTER `bcc_email`");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.82') set rights = replace(rights, 'manage_invoices,view_all_reports', 'manage_invoices,override_allow_ip,view_all_reports')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.83', modified = now() where param_name = 'version_db' and param_value = '1.17.82'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.83') set rights = replace(rights, 'view_own_projects,manage_own_settings', 'view_own_projects,view_own_tasks,manage_own_settings')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.84', modified = now() where param_name = 'version_db' and param_value = '1.17.83'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.84') set rights = replace(rights, 'view_charts,override_punch_mode', 'view_charts,view_own_clients,override_punch_mode')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.85', modified = now() where param_name = 'version_db' and param_value = '1.17.84'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.85') set rights = replace(rights, 'override_allow_ip,view_all_reports', 'override_allow_ip,manage_basic_settings,view_all_reports')");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.85') set rights = replace(rights, 'manage_features,manage_basic_setting,manage_advanced_settings', 'manage_features,manage_advanced_settings')");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.86', modified = now() where param_name = 'version_db' and param_value = '1.17.85'");
ttExecute("ALTER TABLE `tt_groups` ADD `password_complexity` varchar(64) default NULL AFTER `allow_ip`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.87', modified = now() where param_name = 'version_db' and param_value = '1.17.86'");
ttExecute("update `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.17.87') set rights = replace(rights, 'manage_subgroups', 'manage_subgroups,delete_group') where `rank` = 512");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.88', modified = now() where param_name = 'version_db' and param_value = '1.17.87'");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `show_work_units` tinyint(4) NOT NULL DEFAULT '0' AFTER `show_custom_field_1`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.92', modified = now() where param_name = 'version_db' and param_value = '1.17.88'");
ttExecute("ALTER TABLE `tt_log` ADD `group_id` int(11) default NULL AFTER `user_id`");
ttExecute("ALTER TABLE `tt_expense_items` ADD `group_id` int(11) default NULL AFTER `user_id`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.96', modified = now() where param_name = 'version_db' and param_value = '1.17.92'");
ttExecute("create index group_idx on tt_log(group_id)");
ttExecute("create index group_idx on tt_expense_items(group_id)");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.17.97', modified = now() where param_name = 'version_db' and param_value = '1.17.96'");
}
// The update_group_id function updates group_id field in tt_log and tt_expense_items tables.
if (array_key_exists('update_group_id', $_POST)) {
$mdb2 = getConnection();
$sql = "(select distinct user_id from tt_log where group_id is null) union distinct (select distinct user_id from tt_expense_items where group_id is null)";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) {
die($res->getMessage());
}
$users_updated = 0;
$tt_log_records_updated = 0;
$tt_expense_items_updated = 0;
// Iterate through result set.
while ($val = $res->fetchRow()) {
$user_id = $val['user_id'];
$sql = "select group_id from tt_users where id = $user_id";
$result = $mdb2->query($sql);
if (is_a($result, 'PEAR_Error')) {
die($res->getMessage());
}
$value = $result->fetchRow();
$group_id = $value['group_id'];
if ($group_id) {
$sql = "update tt_log set group_id = $group_id where user_id = $user_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) {
die($affected->getMessage());
}
$tt_log_records_updated += $affected;
$sql = "update tt_expense_items set group_id = $group_id where user_id = $user_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) {
die($affected->getMessage());
}
$tt_expense_items_updated += $affected;
$users_updated++;
} else {
print "Error: Could not find group for user $user_id...<br>\n";
}
}
print "Updated $tt_log_records_updated tt_log records...<br>\n";
print "Updated $tt_expense_items_updated tt_expense_items records...<br>\n";
}
if (array_key_exists('convert11797to11900', $_POST)) {
ttExecute("ALTER TABLE `tt_fav_reports` CHANGE `group_by` `group_by1` varchar(20) default NULL");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `group_by2` varchar(20) default NULL AFTER `group_by1`");
ttExecute("ALTER TABLE `tt_fav_reports` ADD `group_by3` varchar(20) default NULL AFTER `group_by2`");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.00', modified = now() where param_name = 'version_db' and param_value = '1.17.97'");
ttExecute("create index log_idx on tt_custom_field_log(log_id)");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.05', modified = now() where param_name = 'version_db' and param_value = '1.18.00'");
ttExecute("UPDATE `tt_groups` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.05') set org_id = id where org_id is null");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.06', modified = now() where param_name = 'version_db' and param_value = '1.18.05'");
ttExecute("ALTER TABLE `tt_users` ADD `org_id` int(11) default NULL AFTER `group_id`");
ttExecute("UPDATE `tt_users` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.06') set org_id = group_id where org_id is null");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.07', modified = now() where param_name = 'version_db' and param_value = '1.18.06'");
ttExecute("ALTER TABLE `tt_roles` ADD `org_id` int(11) default NULL AFTER `group_id`");
ttExecute("UPDATE `tt_roles` inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.07') set org_id = group_id where org_id is null");
ttExecute("UPDATE `tt_site_config` SET param_value = '1.18.08', modified = now() where param_name = 'version_db' and param_value = '1.18.07'");