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 'count-users' => '', 32 'update-user-info' => ' 33 UPDATE wpvk_users 34 SET display_name = :name, 35 user_email = :mail 36 WHERE ID = :uid 37 ', 38 'update-user-login' => ' 39 UPDATE wpvk_users 40 SET user_login = :newlogin 41 WHERE ID = :uid 42 ', 43 'update-user-pass' => ' 44 UPDATE wpvk_users 45 SET user_pass = :hash 46 WHERE ID = :uid 47 ', 48 'insert-group' => '', 49 'join-group' => '', 50 'leave-group' => '', 51 ), 52 'users' => array( 53 array( 54 'user' => 'admin', 55 'pass' => 'pass', 56 'name' => 'admin', 57 'mail' => 'admin@example.com', 58 'grps' => 59 array( 60 0 => 'group10', 61 ), 62 ), 63 array( 64 'user' => 'test1', 65 'pass' => 'pass', 66 'name' => 'Test1 Subscriber', 67 'mail' => 'test1@example.com', 68 'grps' => 69 array( 70 0 => 'group0', 71 ), 72 ), 73 array( 74 'user' => 'test2', 75 'pass' => 'pass', 76 'name' => 'Test2 Contributor', 77 'mail' => 'test2@example.com', 78 'grps' => 79 array( 80 0 => 'group1', 81 ), 82 ), 83 array( 84 'user' => 'test3', 85 'pass' => 'pass', 86 'name' => 'Test3 Author', 87 'mail' => 'test3@example.com', 88 'grps' => 89 array( 90 0 => 'group2', 91 ), 92 ), 93 ), 94); 95