public function migrate_stats($offset = 0, $limit = 9999999)
{
global $wpdb;
$wpfx = $wpdb->prefix;
$data_mapping = $this->value_map['stats'];
//var_dump($data_mapping);
//$this->migrate('paypal_logs', 'crf_paypal_logs', 'rm_paypal_logs');
$res = $wpdb->get_results("SELECT * FROM `" . $wpfx . "crf_stats` WHERE 1 LIMIT {$offset}, {$limit}", ARRAY_A);
if (!$res) {
return;
}
//echo "<pre>", var_dump($res), "</pre>";
//require_once 'Browser.php';
require_once plugin_dir_path(plugin_dir_path(__FILE__)) . 'external/Browser/Browser.php';
foreach ($res as $index => $row) {
// echo "<pre>", var_dump($row), "</pre>";
$details = maybe_unserialize($row['details']);
//var_dump($details['submit_time']);echo"<br>ONErun<br><br>";
if (!$details['Browser']) {
$browser_name = 'Unknown';
} else {
$browser = new RM_Browser($details['Browser']);
$browser_name = $browser->getBrowser();
}
$a = array('stat_id' => '', 'form_id' => '', 'user_ip' => '', 'ua_string' => '', 'browser_name' => '', 'visited_on' => '', 'submitted_on' => null, 'time_taken' => null);
$a['stat_id'] = $row['id'];
$a['form_id'] = $row['form_id'];
$a['user_ip'] = $details['User_IP'];
$a['ua_string'] = $details['Browser'];
$a['browser_name'] = $browser_name;
$a['visited_on'] = $details['timestamp'];
$a['submitted_on'] = isset($details['submit_time']) ? $details['submit_time'] : null;
$a['time_taken'] = isset($details['total_time']) ? $details['total_time'] : null;
$res[$index] = $a;
}
//echo "<pre>", var_dump($res), "</pre>";
$this->insert_array('stats', $wpfx . "rm_stats", $res);
}
public function create_stat_entry($params)
{
$form_id = (int) $params['form_id'];
$visited_on = time();
$user_ip = $this->get_user_ip();
if ($user_ip == null) {
die("Unauthorised request. Access denied.");
}
if (isset($_SERVER['HTTP_USER_AGENT'])) {
$ua_string = $_SERVER['HTTP_USER_AGENT'];
} else {
$ua_string = "no_user_agent_found";
}
require_once plugin_dir_path(plugin_dir_path(__FILE__)) . 'external/Browser/Browser.php';
$browser = new RM_Browser($ua_string);
$browser_name = $browser->getBrowser();
return RM_DBManager::insert_row('STATS', array('form_id' => $form_id, 'user_ip' => $user_ip, 'ua_string' => $ua_string, 'browser_name' => $browser_name, 'visited_on' => $visited_on), array('%d', '%s', '%s', '%s'));
}
