1<?php
2/**
3 * Basic Wordpress config
4 *
5 * Wordpress has no proper groups. This configures the default access permissions as groups. Better group
6 * support is available through a Wrdpress plugin
7 */
8/** @noinspection SqlResolve */
9$data = array(
10    'passcrypt' => 'pmd5',
11    'conf' => array(
12        'select-user' => '
13            SELECT ID AS uid,
14                   user_login AS user,
15                   display_name AS name,
16                   user_pass AS hash,
17                   user_email AS mail
18              FROM wpvk_users
19             WHERE user_login = :user
20        ',
21        'select-user-groups' => '
22            SELECT CONCAT("group",meta_value) AS `group`
23              FROM wpvk_usermeta
24             WHERE user_id = :uid
25               AND meta_key = "wpvk_user_level"
26        ',
27        'select-groups' => '',
28        'insert-user' => '',
29        'delete-user' => '',
30        'list-users' => '
31            SELECT DISTINCT user_login AS user
32              FROM wpvk_users U, wpvk_usermeta M
33             WHERE U.ID = M.user_id
34               AND M.meta_key = "wpvk_user_level"
35               AND CONCAT("group", M.meta_value) LIKE :group
36               AND U.user_login LIKE :user
37               AND U.display_name LIKE :name
38               AND U.user_email LIKE :mail
39          ORDER BY user_login
40             LIMIT :limit
41            OFFSET :start
42        ',
43        'count-users' => '
44            SELECT COUNT(DISTINCT user_login) as `count`
45              FROM wpvk_users U, wpvk_usermeta M
46             WHERE U.ID = M.user_id
47               AND M.meta_key = "wpvk_user_level"
48               AND CONCAT("group", M.meta_value) LIKE :group
49               AND U.user_login LIKE :user
50               AND U.display_name LIKE :name
51               AND U.user_email LIKE :mail
52        ',
53        'update-user-info' => '
54            UPDATE wpvk_users
55               SET display_name = :name,
56                   user_email = :mail
57             WHERE ID = :uid
58        ',
59        'update-user-login' => '
60            UPDATE wpvk_users
61               SET user_login  = :newlogin
62             WHERE ID = :uid
63        ',
64        'update-user-pass' => '
65            UPDATE wpvk_users
66               SET user_pass = :hash
67             WHERE ID = :uid
68        ',
69        'insert-group' => '',
70        'join-group' => '',
71        'leave-group' => '',
72    ),
73    'users' => array(
74        array(
75            'user' => 'admin',
76            'pass' => 'pass',
77            'name' => 'admin',
78            'mail' => 'admin@example.com',
79            'grps' =>
80                array(
81                    0 => 'group10',
82                ),
83        ),
84        array(
85            'user' => 'test1',
86            'pass' => 'pass',
87            'name' => 'Test1 Subscriber',
88            'mail' => 'test1@example.com',
89            'grps' =>
90                array(
91                    0 => 'group0',
92                ),
93        ),
94        array(
95            'user' => 'test2',
96            'pass' => 'pass',
97            'name' => 'Test2 Contributor',
98            'mail' => 'test2@example.com',
99            'grps' =>
100                array(
101                    0 => 'group1',
102                ),
103        ),
104        array(
105            'user' => 'test3',
106            'pass' => 'pass',
107            'name' => 'Test3 Author',
108            'mail' => 'test3@example.com',
109            'grps' =>
110                array(
111                    0 => 'group2',
112                ),
113        ),
114    ),
115);
116