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++;