addDataParam('i', $clip_id); $rsDelete = $wrapperObj->executeQuery($sqlDelete, $dataParams, MysqliWrapper::RETURN_AFFECTED_ROWS); if ($rsDelete === false) { showierror($sqlDelete); } $msg = '0d187d3b'; header("Location: add_video_clips_pop.php?track_id=$track_id&vendor_id=$vendor_id&confirm_msg=$msg"); exit(); } if($err_msg == "") { $length_minutes = $length_hour ? (($length_hour*60) + $length_minutes) : $length_minutes; $update_query = 'UPDATE track_video_clips SET clip_number = ?, clip_title = ?, length_minutes = ?, length_seconds = ?, asset_type = ?, aspect_ratio = ?, keywords = ?, synopsis = ?, submitted_by = ? WHERE clip_id = ? LIMIT 1'; $dataParams = new QueryData(); $dataParams->addDataParam('i', $clip_number); $dataParams->addDataParam('s', stripControlChars($clip_title)); $dataParams->addDataParam('i', $length_minutes); $dataParams->addDataParam('i', $length_seconds); $dataParams->addDataParam('s', $asset_type); $dataParams->addDataParam('s', $aspect_ratio); $dataParams->addDataParam('s', stripControlChars($keywords)); $dataParams->addDataParam('s', stripTextAreaControlChars($synopsis)); $dataParams->addDataParam('i', $_SESSION['S_USERID']); $dataParams->addDataParam('i', $clip_id); if ($wrapperObj->executeQuery($update_query, $dataParams, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) { showierror($update_query); } $msg = '000de069'; header("Location: add_video_clips_pop.php?track_id=$track_id&vendor_id=$vendor_id&confirm_msg=$msg"); exit(); } else { header("Location: add_video_clips_pop.php?track_id=$track_id&vendor_id=$vendor_id" . $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.
    • '; if(!preg_match("/^[0-9][0-9]:[0-5][0-9]:[0-5][0-9]$/",($length_hour.':'.$length_minutes.':'.$length_seconds))){ $err_msg .= "Invalid Duration Format."; } if($err_msg == "") { $length_minutes = $length_hour ? (($length_hour*60) + $length_minutes) : $length_minutes; $insert_query = 'INSERT INTO track_video_clips (clip_number, clip_title, length_minutes, length_seconds, asset_type, aspect_ratio, keywords, synopsis, track_id, date_created, submitted_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), ?)'; $dataParams = new QueryData(); $dataParams->addDataParam('i', $clip_number); $dataParams->addDataParam('s', stripControlChars($clip_title)); $dataParams->addDataParam('i', $length_minutes); $dataParams->addDataParam('i', $length_seconds); $dataParams->addDataParam('s', $asset_type); $dataParams->addDataParam('s', $aspect_ratio); $dataParams->addDataParam('s', stripControlChars($keywords)); $dataParams->addDataParam('s', stripTextAreaControlChars($synopsis)); $dataParams->addDataParam('i', $track_id); $dataParams->addDataParam('i', $_SESSION['S_USERID']); $clip_id = $wrapperObj->executeQuery($insert_query, $dataParams, MysqliWrapper::RETURN_INSERT_ID); if ($clip_id === false) { showierror($insert_query); } $msg = '810f2ce2'; header("Location: add_video_clips_pop.php?track_id=$track_id&vendor_id=$vendor_id&confirm_msg=$msg"); exit(); } } #get all previously entered clips. $get_clips_query = 'SELECT tc.clip_id, tc.clip_number, tc.clip_title, tc.length_minutes, tc.length_seconds, tc.asset_type, tc.aspect_ratio, tc.keywords, tc.synopsis, tc.track_id FROM track_video_clips tc WHERE tc.track_id = ?'; $dataParams = new QueryData(); $dataParams->addDataParam('i', $track_id); $get_clips_result = $wrapperObj->executeQuery($get_clips_query, $dataParams); if ($get_clips_result === false) { showierror($get_clips_query); } ?>

    Update Track Video Clips

    0 ) { $rci = 0; $i = 1; foreach ($get_clips_result as $get_clips_row) { $row_class = (++$rci & 1) ? '' : 'alt'; ?>
    " />
    Clip No Clip Title Duration (HH:MM:SS) Asset Type Aspect Ratio Keywords
    " class="textField small" /> " class="textField small" /> " class="textField small" /> " class="textField small" /> " class="textField small" /> " class="textField small" />
    Synopsis


    Add Track Clip

    Clip No Clip Title Duration (HH:MM:SS) Asset Type Aspect Ratio Keywords
    Synopsis