addDataParam('i', $clip_id); $rsDelete = $wrapperObj->executeQuery($sqlDelete, $data_params, MysqliWrapper::RETURN_AFFECTED_ROWS); if ($rsDelete === false) { showierror($sqlDelete); } $msg = '0d187d3b'; header("Location: add_track_clips_pop.php?track_id=$track_id&cd=$cd&upc=$upc&confirm_msg=$msg"); exit(); } $start_time_arr = explode(':',$start_time); $end_time_arr = explode(':',$end_time); $start_time = ((intval($start_time_arr[0])*3600) + (intval($start_time_arr[1])*60) + $start_time_arr[2] + 0)*1000; $end_time = ((intval($end_time_arr[0])*3600) + (intval($end_time_arr[1])*60) + $end_time_arr[2] + 0)*1000; $length = ($end_time - $start_time) ? $end_time - $start_time : 0; if($length < 0) $err_msg .= '&err_msg[]=efcda439'; if($err_msg == "") { $update_query = 'UPDATE track_clips SET clip_number = ?, clip_title = ?, start_time = ?, end_time = ?, length = ?, submitted_by = ? WHERE clip_id = ? LIMIT 1'; $data_params = new QueryData(); $data_params->addDataParam('i', $clip_number); $data_params->addDataParam('s', stripControlChars($clip_title)); $data_params->addDataParam('i', $start_time); $data_params->addDataParam('i', $end_time); $data_params->addDataParam('i', $length); $data_params->addDataParam('i', $_SESSION['S_USERID']); $data_params->addDataParam('i', $clip_id); if ($wrapperObj->executeQuery($update_query, $data_params, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) { showierror($update_query); } $msg = '000de069'; header("Location: add_track_clips_pop.php?track_id=$track_id&cd=$cd&upc=$upc&confirm_msg=$msg"); exit(); } else { header("Location: add_track_clips_pop.php?track_id=$track_id&cd=$cd&upc=$upc" . $err_msg); exit(); } } elseif ( $a == "insert") { if(trim($clip_title) == '') $err_msg .= '

Please enter valid clip title.

'; if(empty($clip_number) || !is_numeric($clip_number)) $err_msg .= '

Please enter a valid clip number.

'; $start_time_arr = explode(':',$start_time); $end_time_arr = explode(':',$end_time); $start_time = ((intval($start_time_arr[0])*3600) + (intval($start_time_arr[1])*60) + $start_time_arr[2] + 0)*1000; $end_time = ((intval($end_time_arr[0])*3600) + (intval($end_time_arr[1])*60) + $end_time_arr[2] + 0)*1000; $length = ($end_time - $start_time) ? $end_time - $start_time : 0; if($length < 0 && (!preg_match("/^[0-9][0-9]+:+[0-5][0-9]+:+[0-5][0-9]+.+[0-9][0-9][0-9]$/",$start_time) || !preg_match("/^[0-9][0-9]+:+[0-5][0-9]+:+[0-5][0-9]+.+[0-9][0-9][0-9]$/",$end_time))){ $err_msg .= 'Invalid Start/End Time Format.'; } $sql = 'select * from track_clips where upc = ? and cd = ? and track_id = ? and clip_number = ?'; $data_params = new QueryData(); $data_params->addDataParam('i', $upc); $data_params->addDataParam('i', $cd); $data_params->addDataParam('i', $track_id); $data_params->addDataParam('i', $clip_number); $rs = $wrapperObj->executeQuery($sql, $data_params); if ($rs === false) { showierror($sql); } if (count($rs) > 0) { $err_msg .= 'Clip Code Already Exist.'; } if($err_msg == "") { $insert_query = 'INSERT INTO track_clips (upc, cd, track_id, clip_number, clip_title, start_time, end_time, length, date_created, submitted_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW(), ?)'; $data_params = new QueryData(); $data_params->addDataParam('i', $upc); $data_params->addDataParam('i', $cd); $data_params->addDataParam('i', $track_id); $data_params->addDataParam('i', $clip_number); $data_params->addDataParam('s', stripControlChars($clip_title)); $data_params->addDataParam('i', $start_time); $data_params->addDataParam('i', $end_time); $data_params->addDataParam('i', $length); $data_params->addDataParam('i', $_SESSION['S_USERID']); $clip_id = $wrapperObj->executeQuery($insert_query, $data_params, MysqliWrapper::RETURN_INSERT_ID); if ($clip_id === false) { showierror($insert_query); } $msg = '75d94ba5'; header("Location: add_track_clips_pop.php?track_id=$track_id&cd=$cd&upc=$upc&confirm_msg=$msg"); exit(); } } #get all previously entered clips. $get_clips_query = 'SELECT tc.clip_id, tc.upc, tc.cd, tc.track_id, tc.clip_number, tc.clip_title, tc.start_time, tc.end_time, tc.length FROM track_clips tc WHERE tc.track_id = ? AND tc.cd = ? AND tc.upc = ?'; $data_params = new QueryData(); $data_params->addDataParam('i', $track_id); $data_params->addDataParam('i', $cd); $data_params->addDataParam('i', $upc); $get_clips_result = $wrapperObj->executeQuery($get_clips_query, $data_params); if ($get_clips_result === false) { showierror($sql); } ?>

Update Track Clips

0) { $rci = 0; $i = 1; foreach ($get_clips_result as $get_clips_row) { $row_class = (++$rci & 1) ? '' : 'alt'; ?>

" />

Clip No	Clip Title	Start Time	End Time	Length
" class="textField small" />	" class="textField small" />	" class="textField small" />	" class="textField small" />

Update Track Clips

Add Track Clip