zen_record_admin_activity('Updated record company ' . (int) $v_record_company_id . ' via EP4.', 'info');
}
foreach ($langcode as $lang) {
$l_id = $lang['id'];
$sql = "UPDATE " . TABLE_RECORD_COMPANY_INFO . " SET\n\t\t\t\t\t\t\trecord_company_url = '" . addslashes($items[$filelayout['v_record_company_url_' . $lid]]) . "'\n\t\t\t\t\t\t\tWHERE record_company_id = '" . $v_record_company_id . "' AND languages_id = '" . $lid . "'";
$result = ep_4_query($sql);
if ($result) {
zen_record_admin_activity('Updated record company info ' . (int) $v_record_company_id . ' via EP4.', 'info');
}
}
} else {
// It is set to autoincrement, do not need to fetch max id
$sql = "INSERT INTO " . TABLE_RECORD_COMPANY . " (record_company_name, record_company_image, date_added, last_modified)\n\t\t\t\t\t\tVALUES ('" . addslashes(ep_4_curly_quotes($v_record_company_name)) . "', '" . addslashes($v_record_company_image) . "', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)";
$result = ep_4_query($sql);
if ($result) {
zen_record_admin_activity('Inserted record company ' . addslashes(ep_4_curly_quotes($v_record_company_name)) . ' via EP4.', 'info');
}
$v_record_company_id = $ep_uses_mysqli ? mysqli_insert_id($db->link) : mysql_insert_id();
// id is auto_increment, so can use this function
foreach ($langcode as $lang) {
$l_id = $lang['id'];
$sql = "INSERT INTO " . TABLE_RECORD_COMPANY_INFO . " (record_company_id, languages_id, record_company_url)\n\t\t\t\t\t\t\tVALUES ('" . addslashes($v_record_company_id) . "'," . (int) $l_id . ",'" . addslashes($items[$filelayout['v_record_company_url_' . $lid]]) . "')";
// seems we are skipping manufacturers url
$result = ep_4_query($sql);
if ($result) {
zen_record_admin_activity('Inserted record company info ' . (int) $v_record_company_id . ' via EP4.', 'info');
}
}
}
} else {
// $v_record_company_name == '' or name length violation
if (isset($v_record_company_name) && $v_record_company_name != '' && mb_strlen($v_record_company_name) <= $record_company_name_max_len) {
$sql = "SELECT record_company_id AS record_companyID FROM " . TABLE_RECORD_COMPANY . " WHERE record_company_name = '" . addslashes(ep_4_curly_quotes($v_record_company_name)) . "' LIMIT 1";
$result = ep_4_query($sql);
if ($row = $ep_uses_mysqli ? mysqli_fetch_array($result) : mysql_fetch_array($result)) {
$v_record_company_id = $row['record_companyID'];
// this id goes into the product_music_extra table
$sql = "UPDATE " . TABLE_RECORD_COMPANY . " SET \n\t\t\t\t\t\trecord_company_image = '" . addslashes($v_record_company_image) . "',\n\t\t\t\t\t\tlast_modified = CURRENT_TIMESTAMP\n\t\t\t\t\t\tWHERE record_company_id = '" . $v_record_company_id . "'";
$result = ep_4_query($sql);
foreach ($langcode as $lang) {
$l_id = $lang['id'];
$sql = "UPDATE " . TABLE_RECORD_COMPANY_INFO . " SET\n\t\t\t\t\t\t\trecord_company_url = '" . addslashes($items[$filelayout['v_record_company_url_' . $lid]]) . "'\n\t\t\t\t\t\t\tWHERE record_company_id = '" . $v_record_company_id . "' AND languages_id = '" . $lid . "'";
$result = ep_4_query($sql);
}
} else {
// It is set to autoincrement, do not need to fetch max id
$sql = "INSERT INTO " . TABLE_RECORD_COMPANY . " (record_company_name, record_company_image, date_added, last_modified)\n\t\t\t\t\t\tVALUES ('" . addslashes(ep_4_curly_quotes($v_record_company_name)) . "', '" . addslashes($v_record_company_image) . "', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)";
$result = ep_4_query($sql);
$v_record_company_id = $ep_uses_mysqli ? mysqli_insert_id($db->link) : mysql_insert_id();
// id is auto_increment, so can use this function
foreach ($langcode as $lang) {
$l_id = $lang['id'];
$sql = "INSERT INTO " . TABLE_RECORD_COMPANY_INFO . " (record_company_id, languages_id, record_company_url)\n\t\t\t\t\t\t\tVALUES ('" . addslashes($v_record_company_id) . "'," . (int) $l_id . ",'" . addslashes($items[$filelayout['v_record_company_url_' . $lid]]) . "')";
// seems we are skipping manufacturers url
$result = ep_4_query($sql);
}
}
} else {
// $v_record_company_name == '' or name length violation
if (mb_strlen($v_record_company_name) > $record_company_name_max_len) {
$display_output .= sprintf(EASYPOPULATE_4_DISPLAY_RESULT_RECORD_COMPANY_NAME_LONG, $v_record_company_name, $record_company_name_max_len);
$ep_error_count++;
