summaryrefslogtreecommitdiff
path: root/doc/sample-insert-sharedfolder_types.php
blob: 6e316a46f9d538b87e678db27cde3b1f087e7d98 (plain)
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
#!/usr/bin/php
<?php

    if (isset($_SERVER["REQUEST_METHOD"]) && !empty($SERVER["REQUEST_METHOD"])) {
        die("Not intended for execution through the webserver, sorry!");
    }

    require_once("lib/functions.php");

    $db   = SQL::get_instance();

    $result = $db->query("TRUNCATE TABLE `sharedfolder_types`");

    $attributes = Array(
            "auto_form_fields" => Array(
                ),
            "fields" => Array(
                    "kolabfoldertype" => Array(
                            "contact",
                        ),
                    "objectclass" => Array(
                            "top",
                            "kolabsharedfolder",
                        ),
                ),
            "form_fields" => Array(
                    "acl" => Array(
                            "type" => "imap_acl",
                            "optional" => true,
                            "default" => "anyone, lrs",
                        ),
                    "cn" => Array(),
                ),
        );

    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('addressbook','Shared Address Book', 'A shared address book'," .
                "'" . json_encode($attributes) . "')");

    $attributes["fields"]["kolabfoldertype"] = Array('event');
    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('calendar','Shared Calendar', 'A shared calendar'," .
                "'" . json_encode($attributes) . "')");

    $attributes["fields"]["kolabfoldertype"] = Array('journal');
    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('journal','Shared Journal', 'A shared journal'," .
                "'" . json_encode($attributes) . "')");

    $attributes["fields"]["kolabfoldertype"] = Array('task');
    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('task','Shared Tasks', 'A shared tasks folder'," .
                "'" . json_encode($attributes) . "')");

    $attributes["fields"]["kolabfoldertype"] = Array('note');
    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('note','Shared Notes', 'A shared Notes folder'," .
                "'" . json_encode($attributes) . "')");

    $attributes["fields"]["kolabfoldertype"] = Array('file');
    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('file','Shared Files', 'A shared Files folder'," .
                "'" . json_encode($attributes) . "')");

    $attributes["fields"]["kolabfoldertype"] = Array('mail');
    $attributes["form_fields"]["alias"] = Array(
            "type" => "list",
            "optional" => true,
        );

    $attributes["form_fields"]["kolabdelegate"] = Array(
            "type" => "list",
            "autocomplete" => true,
            "optional" => true,
        );

    $attributes["form_fields"]["kolaballowsmtprecipient"] = Array(
            "type" => "list",
            "optional" => true,
        );

    $attributes["form_fields"]["kolaballowsmtpsender"] = Array(
            "type" => "list",
            "optional" => true,
        );

    $attributes["form_fields"]["kolabtargetfolder"] = Array('cn');
    $attributes["form_fields"]["mail"] = Array();
    $attributes["fields"]["objectclass"][] = "mailrecipient";

    $result = $db->query("INSERT INTO `sharedfolder_types` (`key`, `name`, `description`, `attributes`) " .
                "VALUES ('mail','Shared Mail Folder', 'A shared mail folder'," .
                "'" . json_encode($attributes) . "')");

?>