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