e818a96066fc9841a394ada202002c00233fae77
1 <?php
2 class oxchangeAccount extends plugin
3 {
4 /* Definitions */
5 var $plHeadline= "Open-Xchange";
6 var $plDescription= "This does something";
8 /* CLI vars */
9 var $cli_summary= "Management of Open-Xchange accounts";
10 var $cli_description= "Some longer text\nfor help";
11 var $cli_parameters= array("eins" => "Eins ist toll", "zwei" => "Zwei ist noch besser");
13 /* GW attributes */
14 var $OXAppointmentDays="500";
15 var $OXTaskDays="5";
16 var $OXTimeZone="GMT";
17 var $writeGlobalAddressBook="FALSE";
18 var $mailEnabled="OK";
20 /* attribute list for save action */
21 var $attributes= array("OXAppointmentDays", "OXTaskDays", "OXTimeZone","writeGlobalAddressBook","mailEnabled");
22 var $objectclasses= array("OXUserObject");
25 var $oxconf = array();
27 var $timezones=array(
28 "Africa/Abidjan",
29 "Africa/Accra",
30 "Africa/Addis_Ababa",
31 "Africa/Algiers",
32 "Africa/Asmera",
33 "Africa/Bamako",
34 "Africa/Bangui",
35 "Africa/Banjul",
36 "Africa/Bissau",
37 "Africa/Blantyre",
38 "Africa/Brazzaville",
39 "Africa/Bujumbura",
40 "Africa/Cairo",
41 "Africa/Casablanca",
42 "Africa/Ceuta",
43 "Africa/Conakry",
44 "Africa/Dakar",
45 "Africa/Dar_es_Salaam",
46 "Africa/Djibouti",
47 "Africa/Douala",
48 "Africa/El_Aaiun",
49 "Africa/Freetown",
50 "Africa/Gaborone",
51 "Africa/Harare",
52 "Africa/Johannesburg",
53 "Africa/Kampala",
54 "Africa/Khartoum",
55 "Africa/Kigali",
56 "Africa/Kinshasa",
57 "Africa/Lagos",
58 "Africa/Libreville",
59 "Africa/Lome",
60 "Africa/Luanda",
61 "Africa/Lubumbashi",
62 "Africa/Lusaka",
63 "Africa/Malabo",
64 "Africa/Maputo",
65 "Africa/Maseru",
66 "Africa/Mbabane",
67 "Africa/Mogadishu",
68 "Africa/Monrovia",
69 "Africa/Nairobi",
70 "Africa/Ndjamena",
71 "Africa/Niamey",
72 "Africa/Nouakchott",
73 "Africa/Ouagadougou",
74 "Africa/Porto-Novo",
75 "Africa/Sao_Tome",
76 "Africa/Timbuktu",
77 "Africa/Tripoli",
78 "Africa/Tunis",
79 "Africa/Windhoek",
80 "America/Adak",
81 "America/Anchorage",
82 "America/Anguilla",
83 "America/Antigua",
84 "America/Araguaina",
85 "America/Aruba",
86 "America/Asuncion",
87 "America/Atka",
88 "America/Barbados",
89 "America/Belem",
90 "America/Belize",
91 "America/Boa_Vista",
92 "America/Bogota",
93 "America/Boise",
94 "America/Buenos_Aires",
95 "America/Cambridge_Bay",
96 "America/Cancun",
97 "America/Caracas",
98 "America/Catamarca",
99 "America/Cayenne",
100 "America/Cayman",
101 "America/Chicago",
102 "America/Chihuahua",
103 "America/Cordoba",
104 "America/Costa_Rica",
105 "America/Cuiaba",
106 "America/Curacao",
107 "America/Danmarkshavn",
108 "America/Dawson",
109 "America/Dawson_Creek",
110 "America/Denver",
111 "America/Detroit",
112 "America/Dominica",
113 "America/Edmonton",
114 "America/Eirunepe",
115 "America/El_Salvador",
116 "America/Ensenada",
117 "America/Fortaleza",
118 "America/Fort_Wayne",
119 "America/Glace_Bay",
120 "America/Godthab",
121 "America/Goose_Bay",
122 "America/Grand_Turk",
123 "America/Grenada",
124 "America/Guadeloupe",
125 "America/Guatemala",
126 "America/Guayaquil",
127 "America/Guyana",
128 "America/Halifax",
129 "America/Havana",
130 "America/Hermosillo",
131 "America/Indiana",
132 "America/Indiana/Indianapolis",
133 "America/Indiana/Knox",
134 "America/Indiana/Marengo",
135 "America/Indiana/Vevay",
136 "America/Indianapolis",
137 "America/Inuvik",
138 "America/Iqaluit",
139 "America/Jamaica",
140 "America/Jujuy",
141 "America/Juneau",
142 "America/Kentucky",
143 "America/Kentucky/Louisville",
144 "America/Kentucky/Monticello",
145 "America/Knox_IN",
146 "America/La_Paz",
147 "America/Lima",
148 "America/Los_Angeles",
149 "America/Louisville",
150 "America/Maceio",
151 "America/Managua",
152 "America/Manaus",
153 "America/Martinique",
154 "America/Mazatlan",
155 "America/Mendoza",
156 "America/Menominee",
157 "America/Merida",
158 "America/Mexico_City",
159 "America/Miquelon",
160 "America/Monterrey",
161 "America/Montevideo",
162 "America/Montreal",
163 "America/Montserrat",
164 "America/Nassau",
165 "America/New_York",
166 "America/Nipigon",
167 "America/Nome",
168 "America/Noronha",
169 "America/North_Dakota",
170 "America/North_Dakota/Center",
171 "America/Panama",
172 "America/Pangnirtung",
173 "America/Paramaribo",
174 "America/Phoenix",
175 "America/Port-au-Prince",
176 "America/Porto_Acre",
177 "America/Porto_Velho",
178 "America/Port_of_Spain",
179 "America/Puerto_Rico",
180 "America/Rainy_River",
181 "America/Rankin_Inlet",
182 "America/Recife",
183 "America/Regina",
184 "America/Rio_Branco",
185 "America/Rosario",
186 "America/Santiago",
187 "America/Santo_Domingo",
188 "America/Sao_Paulo",
189 "America/Scoresbysund",
190 "America/Shiprock",
191 "America/St_Johns",
192 "America/St_Kitts",
193 "America/St_Lucia",
194 "America/St_Thomas",
195 "America/St_Vincent",
196 "America/Swift_Current",
197 "America/Tegucigalpa",
198 "America/Thule",
199 "America/Thunder_Bay",
200 "America/Tijuana",
201 "America/Tortola",
202 "America/Vancouver",
203 "America/Virgin",
204 "America/Whitehorse",
205 "America/Winnipeg",
206 "America/Yakutat",
207 "America/Yellowknife",
208 "Antarctica/Casey",
209 "Antarctica/Davis",
210 "Antarctica/DumontDUrville",
211 "Antarctica/Mawson",
212 "Antarctica/McMurdo",
213 "Antarctica/Palmer",
214 "Antarctica/South_Pole",
215 "Antarctica/Syowa",
216 "Antarctica/Vostok",
217 "Arctic/Longyearbyen",
218 "Asia/Aden",
219 "Asia/Almaty",
220 "Asia/Amman",
221 "Asia/Anadyr",
222 "Asia/Aqtau",
223 "Asia/Aqtobe",
224 "Asia/Ashgabat",
225 "Asia/Ashkhabad",
226 "Asia/Baghdad",
227 "Asia/Bahrain",
228 "Asia/Baku",
229 "Asia/Bangkok",
230 "Asia/Beirut",
231 "Asia/Bishkek",
232 "Asia/Brunei",
233 "Asia/Calcutta",
234 "Asia/Choibalsan",
235 "Asia/Chongqing",
236 "Asia/Chungking",
237 "Asia/Colombo",
238 "Asia/Dacca",
239 "Asia/Damascus",
240 "Asia/Dhaka",
241 "Asia/Dili",
242 "Asia/Dubai",
243 "Asia/Dushanbe",
244 "Asia/Gaza",
245 "Asia/Harbin",
246 "Asia/Hong_Kong",
247 "Asia/Hovd",
248 "Asia/Irkutsk",
249 "Asia/Istanbul",
250 "Asia/Jakarta",
251 "Asia/Jayapura",
252 "Asia/Jerusalem",
253 "Asia/Kabul",
254 "Asia/Kamchatka",
255 "Asia/Karachi",
256 "Asia/Kashgar",
257 "Asia/Katmandu",
258 "Asia/Krasnoyarsk",
259 "Asia/Kuala_Lumpur",
260 "Asia/Kuching",
261 "Asia/Kuwait",
262 "Asia/Macao",
263 "Asia/Macau",
264 "Asia/Magadan",
265 "Asia/Manila",
266 "Asia/Muscat",
267 "Asia/Nicosia",
268 "Asia/Novosibirsk",
269 "Asia/Omsk",
270 "Asia/Oral",
271 "Asia/Phnom_Penh",
272 "Asia/Pontianak",
273 "Asia/Pyongyang",
274 "Asia/Qatar",
275 "Asia/Qyzylorda",
276 "Asia/Rangoon",
277 "Asia/Riyadh",
278 "Asia/Riyadh87",
279 "Asia/Riyadh88",
280 "Asia/Riyadh89",
281 "Asia/Saigon",
282 "Asia/Sakhalin",
283 "Asia/Samarkand",
284 "Asia/Seoul",
285 "Asia/Shanghai",
286 "Asia/Singapore",
287 "Asia/Taipei",
288 "Asia/Tashkent",
289 "Asia/Tbilisi",
290 "Asia/Tehran",
291 "Asia/Tel_Aviv",
292 "Asia/Thimbu",
293 "Asia/Thimphu",
294 "Asia/Tokyo",
295 "Asia/Ujung_Pandang",
296 "Asia/Ulaanbaatar",
297 "Asia/Ulan_Bator",
298 "Asia/Urumqi",
299 "Asia/Vientiane",
300 "Asia/Vladivostok",
301 "Asia/Yakutsk",
302 "Asia/Yekaterinburg",
303 "Asia/Yerevan",
304 "Atlantic/Azores",
305 "Atlantic/Bermuda",
306 "Atlantic/Canary",
307 "Atlantic/Cape_Verde",
308 "Atlantic/Faeroe",
309 "Atlantic/Jan_Mayen",
310 "Atlantic/Madeira",
311 "Atlantic/Reykjavik",
312 "Atlantic/South_Georgia",
313 "Atlantic/Stanley",
314 "Atlantic/St_Helena",
315 "Australia/ACT",
316 "Australia/Adelaide",
317 "Australia/Brisbane",
318 "Australia/Broken_Hill",
319 "Australia/Canberra",
320 "Australia/Darwin",
321 "Australia/Hobart",
322 "Australia/LHI",
323 "Australia/Lindeman",
324 "Australia/Lord_Howe",
325 "Australia/Melbourne",
326 "Australia/North",
327 "Australia/NSW",
328 "Australia/Perth",
329 "Australia/Queensland",
330 "Australia/South",
331 "Australia/Sydney",
332 "Australia/Tasmania",
333 "Australia/Victoria",
334 "Australia/West",
335 "Australia/Yancowinna",
336 "Brazil/Acre",
337 "Brazil/DeNoronha",
338 "Brazil/East",
339 "Brazil/West",
340 "Canada/Atlantic",
341 "Canada/Central",
342 "Canada/East-Saskatchewan",
343 "Canada/Eastern",
344 "Canada/Mountain",
345 "Canada/Newfoundland",
346 "Canada/Pacific",
347 "Canada/Saskatchewan",
348 "Canada/Yukon",
349 "CET",
350 "Chile/Continental",
351 "Chile/EasterIsland",
352 "CST6CDT",
353 "Cuba",
354 "EET",
355 "Egypt",
356 "Eire",
357 "EST",
358 "EST5EDT",
359 "Etc/GMT",
360 "Etc/GMT+0",
361 "Etc/GMT+1",
362 "Etc/GMT+10",
363 "Etc/GMT+11",
364 "Etc/GMT+12",
365 "Etc/GMT+2",
366 "Etc/GMT+3",
367 "Etc/GMT+4",
368 "Etc/GMT+5",
369 "Etc/GMT+6",
370 "Etc/GMT+7",
371 "Etc/GMT+8",
372 "Etc/GMT+9",
373 "Etc/GMT-0",
374 "Etc/GMT-1",
375 "Etc/GMT-10",
376 "Etc/GMT-11",
377 "Etc/GMT-12",
378 "Etc/GMT-13",
379 "Etc/GMT-14",
380 "Etc/GMT-2",
381 "Etc/GMT-3",
382 "Etc/GMT-4",
383 "Etc/GMT-5",
384 "Etc/GMT-6",
385 "Etc/GMT-7",
386 "Etc/GMT-8",
387 "Etc/GMT-9",
388 "Etc/GMT0",
389 "Etc/Greenwich",
390 "Etc/UCT",
391 "Etc/Universal",
392 "Etc/UTC",
393 "Etc/Zulu",
394 "Europe/Amsterdam",
395 "Europe/Andorra",
396 "Europe/Athens",
397 "Europe/Belfast",
398 "Europe/Belgrade",
399 "Europe/Berlin",
400 "Europe/Bratislava",
401 "Europe/Brussels",
402 "Europe/Bucharest",
403 "Europe/Budapest",
404 "Europe/Chisinau",
405 "Europe/Copenhagen",
406 "Europe/Dublin",
407 "Europe/Gibraltar",
408 "Europe/Helsinki",
409 "Europe/Istanbul",
410 "Europe/Kaliningrad",
411 "Europe/Kiev",
412 "Europe/Lisbon",
413 "Europe/Ljubljana",
414 "Europe/London",
415 "Europe/Luxembourg",
416 "Europe/Madrid",
417 "Europe/Malta",
418 "Europe/Minsk",
419 "Europe/Monaco",
420 "Europe/Moscow",
421 "Europe/Nicosia",
422 "Europe/Oslo",
423 "Europe/Paris",
424 "Europe/Prague",
425 "Europe/Riga",
426 "Europe/Rome",
427 "Europe/Samara",
428 "Europe/San_Marino",
429 "Europe/Sarajevo",
430 "Europe/Simferopol",
431 "Europe/Skopje",
432 "Europe/Sofia",
433 "Europe/Stockholm",
434 "Europe/Tallinn",
435 "Europe/Tirane",
436 "Europe/Tiraspol",
437 "Europe/Uzhgorod",
438 "Europe/Vaduz",
439 "Europe/Vatican",
440 "Europe/Vienna",
441 "Europe/Vilnius",
442 "Europe/Warsaw",
443 "Europe/Zagreb",
444 "Europe/Zaporozhye",
445 "Europe/Zurich",
446 "Factory",
447 "GB",
448 "GB-Eire",
449 "GMT",
450 "GMT+0",
451 "GMT-0",
452 "GMT0",
453 "Greenwich",
454 "Hongkong",
455 "HST",
456 "Iceland",
457 "Indian/Antananarivo",
458 "Indian/Chagos",
459 "Indian/Christmas",
460 "Indian/Cocos",
461 "Indian/Comoro",
462 "Indian/Kerguelen",
463 "Indian/Mahe",
464 "Indian/Maldives",
465 "Indian/Mauritius",
466 "Indian/Mayotte",
467 "Indian/Reunion",
468 "Iran",
469 "Israel",
470 "Jamaica",
471 "Japan",
472 "Kwajalein",
473 "Libya",
474 "MET",
475 "Mexico/BajaNorte",
476 "Mexico/BajaSur",
477 "Mexico/General",
478 "Mideast/Riyadh87",
479 "Mideast/Riyadh88",
480 "Mideast/Riyadh89",
481 "MST",
482 "MST7MDT",
483 "Navajo",
484 "NZ",
485 "NZ-CHAT",
486 "Pacific/Apia",
487 "Pacific/Auckland",
488 "Pacific/Chatham",
489 "Pacific/Easter",
490 "Pacific/Efate",
491 "Pacific/Enderbury",
492 "Pacific/Fakaofo",
493 "Pacific/Fiji",
494 "Pacific/Funafuti",
495 "Pacific/Galapagos",
496 "Pacific/Gambier",
497 "Pacific/Guadalcanal",
498 "Pacific/Guam",
499 "Pacific/Honolulu",
500 "Pacific/Johnston",
501 "Pacific/Kiritimati",
502 "Pacific/Kosrae",
503 "Pacific/Kwajalein",
504 "Pacific/Majuro",
505 "Pacific/Marquesas",
506 "Pacific/Midway",
507 "Pacific/Nauru",
508 "Pacific/Niue",
509 "Pacific/Norfolk",
510 "Pacific/Noumea",
511 "Pacific/Pago_Pago",
512 "Pacific/Palau",
513 "Pacific/Pitcairn",
514 "Pacific/Ponape",
515 "Pacific/Port_Moresby",
516 "Pacific/Rarotonga",
517 "Pacific/Saipan",
518 "Pacific/Samoa",
519 "Pacific/Tahiti",
520 "Pacific/Tarawa",
521 "Pacific/Tongatapu",
522 "Pacific/Truk",
523 "Pacific/Wake",
524 "Pacific/Wallis",
525 "Pacific/Yap",
526 "Poland",
527 "Portugal",
528 "PRC",
529 "PST8PDT",
530 "ROC",
531 "ROK",
532 "Singapore",
533 "SystemV/AST4",
534 "SystemV/AST4ADT",
535 "SystemV/CST6",
536 "SystemV/CST6CDT",
537 "SystemV/EST5",
538 "SystemV/EST5EDT",
539 "SystemV/HST10",
540 "SystemV/MST7",
541 "SystemV/MST7MDT",
542 "SystemV/PST8",
543 "SystemV/PST8PDT",
544 "SystemV/YST9",
545 "SystemV/YST9YDT",
546 "Turkey",
547 "UCT",
548 "Universal",
549 "US/Alaska",
550 "US/Aleutian",
551 "US/Arizona",
552 "US/Central",
553 "US/East-Indiana",
554 "US/Eastern",
555 "US/Hawaii",
556 "US/Indiana-Starke",
557 "US/Michigan",
558 "US/Mountain",
559 "US/Pacific",
560 "US/Samoa",
561 "UTC",
562 "W-SU",
563 "WET",
564 "Zulu"
565 );
569 function oxchangeAccount ($config, $dn= NULL)
570 {
571 plugin::plugin ($config, $dn);
572 for ($i=0;$i<count($this->config->data['TABS']['CONNECTIVITY']);$i++){
573 if($this->config->data['TABS']['CONNECTIVITY'][$i]['CLASS']=='oxchangeAccount')
574 {
575 $this->oxconf=$this->config->data['TABS']['CONNECTIVITY'][$i];
576 break;
577 }
578 }
579 }
581 function execute()
582 {
584 /* Show tab dialog headers */
585 $display= "";
587 /* Show main page */
588 $smarty= get_smarty();
590 if (function_exists("pg_connect")){
591 $smarty->assign("pg", true);
592 }else{
593 $smarty->assign("pg", false);
594 }
596 /* Load attributes */
597 foreach($this->attributes as $val){
598 $smarty->assign("$val", $this->$val);
599 $smarty->assign($val."ACL", chkacl($this->acl, "$val"));
600 }
601 if ($this->is_account){
602 $smarty->assign("oxchangeState", "checked");
603 } else {
604 $smarty->assign("fstate", "disabled");
605 }
607 // if ($this->is_account){
608 $smarty->assign("timezones", $this->timezones);
609 // } else {
610 // $smarty->assign("timezones", array("GMT"));
611 // }
614 if ($this->parent != NULL){
615 $smarty->assign("tabbed", 1);
616 }
618 $display.= $smarty->fetch (get_template_path('oxchange.tpl', TRUE, dirname(__FILE__)));
619 return ($display);
620 }
622 function remove_from_parent()
623 {
624 $sqldeluser=array(
625 "delete from prg_notes where (user_right like '".$this->attrs['uid'][0]."') and (group_right like 's')",
626 "delete from prg_documents_read where (user_right like '".$this->attrs['uid'][0]."')",
627 "delete from prg_documents_mod where (user_right like '".$this->attrs['uid'][0]."')",
628 "delete from prg_docufolders_read where (user_right like '".$this->attrs['uid'][0]."')",
629 "delete from prg_docufolders_mod where (user_right like '".$this->attrs['uid'][0]."')",
630 "delete from prg_date_rights where (user_right like '".$this->attrs['uid'][0]."')",
631 "delete from prg_date_notification where (member_uid like '".$this->attrs['uid'][0]."')",
632 "delete from prg_dates_members where (member_uid like '".$this->attrs['uid'][0]."')",
633 "delete from prg_knowledge_read where (user_right like '".$this->attrs['uid'][0]."')",
634 "delete from prg_knowledge_mod where (user_right like '".$this->attrs['uid'][0]."')",
635 "delete from prg_knowledge_folder_read where (user_right like '".$this->attrs['uid'][0]."')",
636 "delete from prg_knowledge_folder_mod where (user_right like '".$this->attrs['uid'][0]."')",
637 "delete from prg_pin_board_read where (user_right like '".$this->attrs['uid'][0]."')",
638 "delete from prg_pin_board_mod where (user_right like '".$this->attrs['uid'][0]."')",
639 "delete from prg_bookmarks_read where (user_right like '".$this->attrs['uid'][0]."')",
640 "delete from prg_bookmarks_mod where (user_right like '".$this->attrs['uid'][0]."')",
641 "delete from prg_bookmarks_folder_read where (user_right like '".$this->attrs['uid'][0]."')",
642 "delete from prg_bookmarks_folder_mod where (user_right like '".$this->attrs['uid'][0]."')",
643 "delete from prg_tasks_rights where (user_right like '".$this->attrs['uid'][0]."')",
644 "delete from prg_tasks_notification where (member_uid like '".$this->attrs['uid'][0]."')",
645 "delete from prg_tasks_members where (member_uid like '".$this->attrs['uid'][0]."')",
646 "delete from prg_projects_rights where (user_right like '".$this->attrs['uid'][0]."')",
647 "delete from prg_projects_notification where (member_uid like '".$this->attrs['uid'][0]."')",
648 "delete from prg_projects_members where (member_uid like '".$this->attrs['uid'][0]."')",
649 "delete from oxfolder_permissions where (entity like '".$this->attrs['uid'][0]."') AND ((role = 256) OR (role = 1024))",
650 "delete from oxfolder_standardfolders where owner like '".$this->attrs['uid'][0]."'",
651 "delete from prg_forum_read where user_right = '".$this->attrs['uid'][0]."'",
652 "delete from prg_forum_mod where user_right = '".$this->attrs['uid'][0]."'",
653 "delete from prg_forum_abo where user_right = '".$this->attrs['uid'][0]."'",
654 "delete from prg_forum_seen where username = '".$this->attrs['uid'][0]."'",
655 "delete from sys_holiday where (userid like '".$this->attrs['uid'][0]."')",
656 "delete from usr_holiday where (userid like '".$this->attrs['uid'][0]."')");
658 /* Trying to open a Postgresql Database Server */
659 if (function_exists("pg_connect")){
660 if(isset($this->oxconf["PGUSER"]) and isset($this->oxconf["PGHOST"]) and isset($this->oxconf["PGDBNAME"]) and isset($this->oxconf["PGPASSWD"])){
661 $pgcon = pg_connect("host=".$this->oxconf["PGHOST"]." user=".$this->oxconf["PGUSER"]." password=".$this->oxconf["PGPASSWD"]." dbname=".$this->oxconf["PGDBNAME"]);
662 if (! $pgcon){
663 print_red(_("Couldn't Connect To Postgresql Database"));
664 return;
665 }
666 }else{
667 print_red(_("Needed Parameters to openexchange connectivity plugin failed!"));
668 return;
669 }
670 }else{
671 print_red(_("PHP4 module for Postgresql Database Failed!"));
672 return;
673 }
675 plugin::remove_from_parent();
676 $ldap= $this->config->get_ldap_link();
678 $ldap->cd($this->dn);
679 @DEBUG (DEBUG_LDAP, __LINE__, __FUNCTION__, __FILE__,
680 $this->attributes, "Save");
681 $ldap->modify($this->attrs);
682 show_ldap_error($ldap->get_error());
684 /* Optionally execute a command after we're done */
685 $this->postremove();
687 /* Finally remove data from postgresql server */
688 foreach ($sqldeluser as $sqls){
689 pg_exec($pgcon,$sqls);
690 }
691 pg_close();
692 }
694 /* Save data to object */
695 function save_object()
696 {
697 /* Do we need to flip is_account state? */
698 if (isset($_POST['connectivityTab'])){
699 if (isset($_POST['oxchange'])){
700 if (!$this->is_account && $_POST['oxchange'] == "B"){
701 $this->is_account= TRUE;
702 }
703 } else {
704 $this->is_account= FALSE;
705 }
706 }
708 plugin::save_object();
709 if (isset($_POST["oxchangeStatus"])){
710 $this->oxchangeStatus = "disabled";
711 } else {
712 $this->oxchangeStatus = "enabled";
713 }
714 }
717 /* Save to LDAP */
718 function save()
719 {
721 /* Trying to open a Postgresql Database Server */
722 if (function_exists("pg_connect")){
723 if(isset($this->oxconf["PGUSER"]) and isset($this->oxconf["PGHOST"]) and isset($this->oxconf["PGDBNAME"]) and isset($this->oxconf["PGPASSWD"])){
724 $pgcon = pg_connect("host=".$this->oxconf["PGHOST"]." user=".$this->oxconf["PGUSER"]." password=".$this->oxconf["PGPASSWD"]." dbname=".$this->oxconf["PGDBNAME"]);
725 if (! $pgcon){
726 print_red(_("Couldn't Connect To Postgresql Database"));
727 return;
728 }
729 }else{
730 print_red(_("Needed Parameters to openexchange connectivity plugin failed!"));
731 return;
732 }
733 }else{
734 print_red(_("PHP4 module for Postgresql Database Failed!"));
735 return;
736 }
738 $uid=$this->attrs['uid'][0];
740 plugin::save();
742 /* Write back to ldap */
743 $ldap= $this->config->get_ldap_link();
744 $ldap->cd($this->dn);
745 $ldap->modify($this->attrs);
746 show_ldap_error($ldap->get_error());
748 /* Optionally execute a command after we're done */
749 $this->postcreate();
751 /* Finally save data to postgresql server */
752 pg_set_client_encoding ("UNICODE");
753 $nv = "SELECT nextval ('serial_id')";
754 $ot = "insert into oxfolder_tree (fuid, parent, fname, module, type, owner, creator, creating_date, created_from, changing_date, changed_from) VALUES (%d, 1, '%s', '%s', 'private', '%s', '%s', 'now', 'System', 'now', 'System')";
755 $op = "INSERT INTO oxfolder_permissions (puid, pid, role, entity, sealed, fp, orp, owp, odp) VALUES (%d, %d, 32768, '%s', 0, 128, 128, 128, 128)";
756 $os = "insert into oxfolder_standardfolders (owner,module_calendar,module_contact,module_task) VALUES ('%s',%d,%d,%d)";
757 $ugr= "INSERT INTO usr_general_rights SELECT creating_date, created_from, changing_date, changed_from,text('%s'), addr_u, addr_r, addr_d, cont_u, cont_r, cont_d, data_u, data_r, data_d, serie_u, serie_r, serie_d, task_u, task_r, task_d, refer, proj_u, proj_r, proj_d, dfolder_u, dfolder_r, dfolder_d, doc_u, doc_r, doc_d, knowl_u, knowl_r, knowl_d, bfolder_u, bfolder_r, bfolder_d, bookm_u, bookm_r, bookm_d, pin_u, pin_r, pin_d, forum_n, fentrie_n, setup, pin_public, internal, int_groups, kfolder_u, kfolder_r, kfolder_d, webmail FROM sys_gen_rights_template WHERE login LIKE 'default_template'";
759 $res=pg_exec($pgcon,$nv); $calendarid=pg_fetch_row($res); pg_freeresult($res);
760 $q=sprintf($ot,$calendarid[0],'My Appointments','calendar',$uid,$uid);
761 pg_exec($pgcon,$q);
762 $res=pg_exec($pgcon,$nv); $nid=pg_fetch_row($res); pg_freeresult($res);
763 $q=sprintf($op,$nid[0],$calendarid[0],$uid);
764 pg_exec($pgcon,$q);
765 $res=pg_exec($pgcon,$nv); $contactsid=pg_fetch_row($res); pg_freeresult($res);
766 $q=sprintf($ot,$contactsid[0],'My Contacts','contact',$uid,$uid);
767 pg_exec($pgcon,$q);
768 $res=pg_exec($pgcon,$nv); $nid=pg_fetch_row($res); pg_freeresult($res);
769 $q=sprintf($op,$nid[0],$contactsid[0],$uid);
770 pg_exec($pgcon,$q);
771 $res=pg_exec($pgcon,$nv); $tasksid=pg_fetch_row($res); pg_freeresult($res);
772 $q=sprintf($ot,$tasksid[0],'My Tasks','task',$uid,$uid);
773 pg_exec($pgcon,$q);
774 $res=pg_exec($pgcon,$nv); $nid=pg_fetch_row($res); pg_freeresult($res);
775 $q=sprintf($op,$nid[0],$tasksid[0],$uid);
776 pg_exec($pgcon,$q);
777 $q=sprintf($os,$uid,$calendarid[0],$contactsid[0],$tasksid[0]);
778 pg_exec($pgcon,$q);
779 $q=sprintf($ugr,$uid);
780 pg_exec($pgcon,$q);
781 pg_close($pgcon);
782 }
783 }
785 ?>