public static function buildMySQLValuesArr($json)
{
$json['USER_CRASH_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_CRASH_DATE']);
$json['USER_APP_START_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_APP_START_DATE']);
$values = array();
foreach ($json as $k => $v) {
$k = strtolower($k);
if (in_array(strtoupper($k), self::$mSerializedFields)) {
$values[$k] = base64_encode(serialize($v));
} else {
// report_id is translate to report_key
if (strcmp($k, 'report_id') == 0) {
$values['report_key'] = DBHelper::escapeString($v);
} else {
$values[$k] = DBHelper::escapeString($v);
}
}
}
return $values;
}
public static function buildMySQLValuesArr($json)
{
$json['USER_CRASH_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_CRASH_DATE']);
$json['USER_APP_START_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_APP_START_DATE']);
$values = array();
//error_log("JSON => ");error_log(print_r($json, true));
//error_log("BUILD => ");error_log(print_r($json['build'], true));
//error_log("BUILD_CONFIG => ");error_log(print_r($json['build_config'], true));
foreach ($json as $k => $v) {
$k = strtolower($k);
// my fix
if ($k == "build_config") {
continue;
}
if (in_array(strtoupper($k), self::$mSerializedFields)) {
$values[$k] = base64_encode(serialize($v));
} else {
// report_id is translate to report_key
//error_log($k . "=> ");error_log(print_r($v, true));
if (strcmp($k, 'report_id') == 0) {
$values['report_key'] = DBHelper::escapeString($v);
} else {
$values[$k] = DBHelper::escapeString($v);
}
}
}
return $values;
}
