$member_migrate = array();

            $mysqli = new mysqli('localhost', 'zteam_zlicense', 'NQSh2OuZ5qLK9guW', 'zteam_zlicense') or die($mysqli->error);
            //`access` = 3 OR `access` = 2 OR
            $queryM = $mysqli->query('SELECT * FROM `customer` WHERE `access` = 4') or die($mysqli->error);

            while ($rowM = $queryM->fetch_object()) {

                // member primary
                $member_migrate[$rowM->id]['username'] = $rowM->user;
                $member_migrate[$rowM->id]['email'] = $rowM->email;

                // member subscription
                $queryS = $mysqli->query('SELECT * FROM `subscription` WHERE `cid` = '.$rowM->id.'') or die($mysqli->error);

                while ($rowS = $queryS->fetch_object()) {

                    $member_migrate[$rowM->id]['cache'][1]['until'] = time();
                    $member_migrate[$rowM->id]['cache'][1]['last'] = array(2 => time());

                    if($rowS->end_date > time())
                    {

                        $member_migrate[$rowM->id]['cache'][1]['until'] = $rowS->end_date;

                    }

                }

                // member licenses
                $queryL = $mysqli->query('SELECT * FROM `license` WHERE `cid` = '.$rowM->id.'') or die($mysqli->error);

                while ($rowL = $queryL->fetch_object()) {

                    $member_migrate[$rowM->id]['license'][$rowL->id]['name'] = $rowL->name;
                    $member_migrate[$rowM->id]['license'][$rowL->id]['driver_id'] = $rowL->driveid;
                    $member_migrate[$rowM->id]['license'][$rowL->id]['adapter'] = array($rowL->adapter0,$rowL->adapter1,$rowL->adapter2,$rowL->adapter3,$rowL->adapter4,$rowL->adapter5,$rowL->adapter6,$rowL->adapter7);
                    $member_migrate[$rowM->id]['license'][$rowL->id]['last_edit'] = strtotime($rowL->modified);

                }

                // STORE CONVERTED DATA

                    // members
                    foreach ($member_migrate as $m_id => $value) {

                        $insertData = array('id'=>$m_id, 'username'=>$value['username'], 'email'=>$value['email'], 'cache'=>json_encode($value['cache']));
                        app::$obj->mysql->insert('members', $insertData);

                        if(!empty($value['license']))
                        {

                            foreach ($value['license'] as $l_id => $value) {

                                $insertData = array('id'=>$l_id,'name'=>$value['name'], 'package_id' => 1, 'member_id' => $m_id, 'driver_id'=>$value['driver_id'], 'adapter' => json_encode($value['adapter']), 'last_edit'=>$value['last_edit']);
                                app::$obj->mysql->insert('license', $insertData);

                            }

                        }

                    }

                $this->exportvars['transfer'] = $member_migrate;

            }

            view::import($this->exportvars);