public function convert() { // get data from database $query = 'SELECT * FROM ' . $this->getDB()->getSourcePrefix() . 'users'; $stmt = $this->getDB()->getSource()->query($query); // create array of PP_Users $pp_users = array(); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $pp_user = new PP_Users($this->getDB()); $pp_user->setOldId($row['user_id']); // set values for each fields $pp_user->setUsername($row['user_name']); $pp_user->setEmail($row['email_address']); // $pp_user->setToken(); // $pp_user->setSalt(); // $pp_user->setTwister(); $pp_user->setDisplay_name($row['real_name']); //$pp_user->setHomepage(); //$pp_user->setTitle(); //$pp_user->setAvatar_file(); //$pp_user->setUse_gravatar(); $pp_user->setTimezone($row['time_zone']); $pp_user->setCreated_on(time2SqlDateTime($row['register_date'])); $pp_user->setUpdated_on(time2SqlDateTime(time())); //$pp_user->setLast_login(); //$pp_user->setLast_visit(); //$pp_user->setLast_activity(); //$pp_user->setIs_admin(); //$pp_user->setAuto_assign(); $config = $this->getConfig(); $pp_user->company_id = $config['projectpier']['default_compagny_id']; $pp_users[ $row['user_id'] ] = $pp_user; } $stmt->closeCursor(); // insert in db $this->setNewIds($pp_users[ array_rand($pp_users) ]->writes2DB($pp_users)); // clean memory unset($pp_users); }
public static function get_all_users($cols = 'id', $args = array()) { require_once PPC_ABSPATH . '/users_pp.php'; $args['cols'] = $cols; return PP_Users::get_users($args); }