aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/lib/plugins/authpdo/_test/mysql/wordpress.php
blob: f0d93f0f6a1ce80d43eae9abe715bd2f875efe55 (plain) (blame)
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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<?php
/**
 * Basic Wordpress config
 *
 * Wordpress has no proper groups. This configures the default access permissions as groups. Better group
 * support is available through a Wrdpress plugin
 */
/** @noinspection SqlResolve */
$data = array(
    'passcrypt' => 'pmd5',
    'conf' => array(
        'select-user' => '
            SELECT ID AS uid,
                   user_login AS user,
                   display_name AS name,
                   user_pass AS hash,
                   user_email AS mail
              FROM wpvk_users
             WHERE user_login = :user
        ',
        'select-user-groups' => '
            SELECT CONCAT("group",meta_value) AS `group`
              FROM wpvk_usermeta
             WHERE user_id = :uid
               AND meta_key = "wpvk_user_level"
        ',
        'select-groups' => '',
        'insert-user' => '',
        'delete-user' => '',
        'list-users' => '
            SELECT DISTINCT user_login AS user
              FROM wpvk_users U, wpvk_usermeta M
             WHERE U.ID = M.user_id
               AND M.meta_key = "wpvk_user_level"
               AND CONCAT("group", M.meta_value) LIKE :group
               AND U.user_login LIKE :user
               AND U.display_name LIKE :name
               AND U.user_email LIKE :mail
          ORDER BY user_login
             LIMIT :limit
            OFFSET :start
        ',
        'count-users' => '
            SELECT COUNT(DISTINCT user_login) as `count`
              FROM wpvk_users U, wpvk_usermeta M
             WHERE U.ID = M.user_id
               AND M.meta_key = "wpvk_user_level"
               AND CONCAT("group", M.meta_value) LIKE :group
               AND U.user_login LIKE :user
               AND U.display_name LIKE :name
               AND U.user_email LIKE :mail
        ',
        'update-user-info' => '
            UPDATE wpvk_users
               SET display_name = :name,
                   user_email = :mail
             WHERE ID = :uid
        ',
        'update-user-login' => '
            UPDATE wpvk_users
               SET user_login  = :newlogin
             WHERE ID = :uid
        ',
        'update-user-pass' => '
            UPDATE wpvk_users
               SET user_pass = :hash
             WHERE ID = :uid
        ',
        'insert-group' => '',
        'join-group' => '',
        'leave-group' => '',
    ),
    'users' => array(
        array(
            'user' => 'admin',
            'pass' => 'pass',
            'name' => 'admin',
            'mail' => 'admin@example.com',
            'grps' =>
                array(
                    0 => 'group10',
                ),
        ),
        array(
            'user' => 'test1',
            'pass' => 'pass',
            'name' => 'Test1 Subscriber',
            'mail' => 'test1@example.com',
            'grps' =>
                array(
                    0 => 'group0',
                ),
        ),
        array(
            'user' => 'test2',
            'pass' => 'pass',
            'name' => 'Test2 Contributor',
            'mail' => 'test2@example.com',
            'grps' =>
                array(
                    0 => 'group1',
                ),
        ),
        array(
            'user' => 'test3',
            'pass' => 'pass',
            'name' => 'Test3 Author',
            'mail' => 'test3@example.com',
            'grps' =>
                array(
                    0 => 'group2',
                ),
        ),
    ),
);