| 1 |
<?php |
| 2 |
/* |
| 3 |
* This file is part of the ManageWP Worker plugin. |
| 4 |
* |
| 5 |
* (c) ManageWP LLC <contact@managewp.com> |
| 6 |
* |
| 7 |
* For the full copyright and license information, please view the LICENSE |
| 8 |
* file that was distributed with this source code. |
| 9 |
*/ |
| 10 |
|
| 11 |
class MWP_WordPress_Query_User extends MWP_WordPress_Query_Abstract |
| 12 |
{ |
| 13 |
public function query(array $options = array()) |
| 14 |
{ |
| 15 |
$options += array( |
| 16 |
'query' => null, |
| 17 |
'simplifiedQuery' => null, |
| 18 |
'prefixName' => '{{prefix}}', |
| 19 |
'deserialize' => array(), |
| 20 |
'tryDeserialize' => array(), |
| 21 |
); |
| 22 |
|
| 23 |
// Depending on the total number of users we choose whether we will run the query or the simplified query without sorts. |
| 24 |
$query = $options['query']; |
| 25 |
$users_count = $this->getDb()->get_var('SELECT COUNT(*) FROM '.$this->getDb()->base_prefix.'users'); |
| 26 |
if ($users_count > 500) { |
| 27 |
$query = $options['simplifiedQuery']; |
| 28 |
} |
| 29 |
|
| 30 |
// We change the {{prefix}}users and {{prefix}}usermeta string with base_prefix because in a multisite network, |
| 31 |
// all of the websites are sharing the same users and usermeta tables. |
| 32 |
$query = str_replace($options['prefixName'].'users', $this->getDb()->base_prefix.'users', $query); |
| 33 |
$query = str_replace($options['prefixName'].'usermeta', $this->getDb()->base_prefix.'usermeta', $query); |
| 34 |
$query = str_replace($options['prefixName'], $this->getDb()->prefix, $query); |
| 35 |
$users = $this->getDb()->get_results($query, ARRAY_A); |
| 36 |
$this->deserialize($users, $options['deserialize'], $options['tryDeserialize']); |
| 37 |
|
| 38 |
return $users; |
| 39 |
} |
| 40 |
} |
| 41 |
|
