plugins/personal/connectivity/class_oxchangeAccount.inc

   1 <?php
   2 class oxchangeAccount extends plugin
   3 {
   4   /* Definitions */
   5   var $plHeadline= "Open-Xchange";
   6   var $plDescription= "This does something";
   7
   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");
  12
  13   /* GW attributes */
  14   var $OXAppointmentDays="500";
  15   var $OXTaskDays="5";
  16   var $OXTimeZone="GMT";
  17   var $writeGlobalAddressBook="FALSE";
  18   var $mailEnabled="OK";
  19
  20   /* attribute list for save action */
  21   var $attributes= array("OXAppointmentDays", "OXTaskDays", "OXTimeZone","writeGlobalAddressBook","mailEnabled");
  22   var $objectclasses= array("OXUserObject");
  23
  24
  25   var $oxconf = array();
  26
  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   );
 566
 567
 568
 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   }
 580
 581   function execute()
 582   {
 583
 584         /* Show tab dialog headers */
 585         $display= "";
 586
 587         /* Show main page */
 588         $smarty= get_smarty();
 589
 590         if (function_exists("pg_connect")){
 591                 $smarty->assign("pg", true);
 592         }else{
 593                 $smarty->assign("pg", false);
 594         }
 595
 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         }
 606
 607 //      if ($this->is_account){
 608                 $smarty->assign("timezones", $this->timezones);
 609 //      } else {
 610 //              $smarty->assign("timezones", array("GMT"));
 611 //      }
 612
 613
 614         if ($this->parent != NULL){
 615                 $smarty->assign("tabbed", 1);
 616         }
 617
 618         $display.= $smarty->fetch (get_template_path('oxchange.tpl', TRUE, dirname(__FILE__)));
 619         return ($display);
 620   }
 621
 622   function remove_from_parent()
 623   {
 624         $sqldeluser=array(
 625         "delete from prg_notes where (user_right like '".$this->attrs['cn'][0]."') and (group_right like 's')",
 626         "delete from prg_documents_read where (user_right like '".$this->attrs['cn'][0]."')",
 627         "delete from prg_documents_mod where (user_right like '".$this->attrs['cn'][0]."')",
 628         "delete from prg_docufolders_read where (user_right like '".$this->attrs['cn'][0]."')",
 629         "delete from prg_docufolders_mod where (user_right like '".$this->attrs['cn'][0]."')",
 630         "delete from prg_date_rights where (user_right like '".$this->attrs['cn'][0]."')",
 631         "delete from prg_date_notification where (member_uid like '".$this->attrs['cn'][0]."')",
 632         "delete from prg_dates_members where (member_uid like '".$this->attrs['cn'][0]."')",
 633         "delete from prg_knowledge_read where (user_right like '".$this->attrs['cn'][0]."')",
 634         "delete from prg_knowledge_mod where (user_right like '".$this->attrs['cn'][0]."')",
 635         "delete from prg_knowledge_folder_read where (user_right like '".$this->attrs['cn'][0]."')",
 636         "delete from prg_knowledge_folder_mod where (user_right like '".$this->attrs['cn'][0]."')",
 637         "delete from prg_pin_board_read where (user_right like '".$this->attrs['cn'][0]."')",
 638         "delete from prg_pin_board_mod where (user_right like '".$this->attrs['cn'][0]."')",
 639         "delete from prg_bookmarks_read where (user_right like '".$this->attrs['cn'][0]."')",
 640         "delete from prg_bookmarks_mod where (user_right like '".$this->attrs['cn'][0]."')",
 641         "delete from prg_bookmarks_folder_read where (user_right like '".$this->attrs['cn'][0]."')",
 642         "delete from prg_bookmarks_folder_mod where (user_right like '".$this->attrs['cn'][0]."')",
 643         "delete from prg_tasks_rights where (user_right like '".$this->attrs['cn'][0]."')",
 644         "delete from prg_tasks_notification where (member_uid like '".$this->attrs['cn'][0]."')",
 645         "delete from prg_tasks_members where (member_uid like '".$this->attrs['cn'][0]."')",
 646         "delete from prg_projects_rights where (user_right like '".$this->attrs['cn'][0]."')",
 647         "delete from prg_projects_notification where (member_uid like '".$this->attrs['cn'][0]."')",
 648         "delete from prg_projects_members where (member_uid like '".$this->attrs['cn'][0]."')",
 649         "delete from oxfolder_permissions where (entity like '".$this->attrs['cn'][0]."') AND ((role = 256) OR (role = 1024))",
 650         "delete from oxfolder_standardfolders where owner like '".$this->attrs['cn'][0]."'",
 651         "delete from prg_forum_read where user_right = '".$this->attrs['cn'][0]."'",
 652         "delete from prg_forum_mod where user_right = '".$this->attrs['cn'][0]."'",
 653         "delete from prg_forum_abo where user_right = '".$this->attrs['cn'][0]."'",
 654         "delete from prg_forum_seen where username = '".$this->attrs['cn'][0]."'",
 655         "delete from sys_holiday where (userid like '".$this->attrs['cn'][0]."')",
 656         "delete from usr_holiday where (userid like '".$this->attrs['cn'][0]."')");
 657
 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         }
 674
 675         plugin::remove_from_parent();
 676         $ldap= $this->config->get_ldap_link();
 677
 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());
 683
 684         /* Optionally execute a command after we're done */
 685         $this->postremove();
 686
 687         /* Finally remove data from postgresql server */
 688         foreach ($sqldeluser as $sqls){
 689                 pg_exec($pgcon,$sqls);
 690         }
 691         pg_close();
 692   }
 693
 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         }
 707
 708         plugin::save_object();
 709         if (isset($_POST["oxchangeStatus"])){
 710                 $this->oxchangeStatus = "disabled";
 711         } else {
 712                 $this->oxchangeStatus = "enabled";
 713         }
 714   }
 715
 716
 717   /* Save to LDAP */
 718   function save()
 719   {
 720
 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         }
 737
 738         $uid=$this->attrs['cn'][0];
 739
 740         plugin::save();
 741
 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());
 747
 748         /* Optionally execute a command after we're done */
 749         $this->postcreate();
 750
 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'";
 758
 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 }
 784
 785 ?>