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',
),
),
),
);
|