[Summary view] [Print] [Text view]

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