Esempio n. 1
0
 static function js_update_records($get)
 {
     $db = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
     mysql_select_db(DB_DATABASE, $db);
     mysql_query('SET NAMES utf8');
     $page_params = Tracking::parse_location($get["url"]);
     $jqry = '
   UPDATE
     tracking_visits
   SET
     tracking_width="' . (int) $get['scr_width'] . '",
     tracking_height="' . (int) $get['scr_height'] . '",
     tracking_viewport_size="' . mysql_real_escape_string($get['viewport_size']) . '",
     tracking_flash="' . mysql_real_escape_string($get['flash']) . '",
     tracking_java="' . mysql_real_escape_string($get['java']) . '",
     tracking_title="' . mysql_real_escape_string($get['title']) . '",
     tracking_description="' . mysql_real_escape_string($get['description']) . '",
     tracking_encoding="' . mysql_real_escape_string($get['encoding']) . '",
     tracking_user_language="' . mysql_real_escape_string($get['user_language']) . '",
     tracking_caching=tracking_caching-' . (int) $get['ch'] . ',
     tracking_utm_source="' . mysql_real_escape_string($page_params['utm_source']) . '",
     tracking_utm_medium="' . mysql_real_escape_string($page_params['utm_medium']) . '",
     tracking_utm_campaign="' . mysql_real_escape_string($page_params['utm_campaign']) . '",
     tracking_utm_content="' . mysql_real_escape_string($page_params['utm_content']) . '",
     tracking_utm_term="' . mysql_real_escape_string($page_params['utm_term']) . '",
     tracking_utm_id="' . mysql_real_escape_string($page_params['utm_id']) . '",
     tracking_gclid="' . mysql_real_escape_string($page_params['gclid']) . '",
     tracking_url="' . mysql_real_escape_string($get['url']) . '"
   WHERE
     tracking_id="' . (int) $get['uid'] . '"
     ';
     mysql_query($jqry);
     file_put_contents("out", $jqry);
 }