public static function insertVideo($artist_id, $session_id, $name, $description, $youtube_id, $iframe_url, $votes, $upload_status_nbr, $video_status_nbr, $file, $is_active)
{
if (!is_string($name) || strlen($name) <= 0) {
return MyUtil::fnOk(false, "Name must be at least 1 character", null);
}
$orig_artist_id = $artist_id;
$artist_id = MyUtil::parseInt($artist_id);
if ($artist_id == null) {
return MyUtil::fnOk(false, "Must be a valid artist id: {$orig_artist_id}", null);
}
$orig_session_id = $session_id;
$session_id = MyUtil::parseInt($session_id);
if ($session_id == null) {
return MyUtil::fnOk(false, "Must be a valid session id: {$orig_session_id}", null);
}
$stm = "INSERT INTO " . self::$table_name . "(artist_id,session_id,name,description,youtube_id,iframe_url," . "votes,upload_status_nbr,video_status_nbr,updated_ts,updated_by,file,is_active) VALUES ( " . "nullIf('" . MyUtil::nvl($artist_id, -1) . "', -1), " . "nullIf('" . MyUtil::nvl($session_id, -1) . "', -1), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($name, "")) . "', ''), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($description, "")) . "', ''), " . "nullIf('" . MyUtil::nvl($youtube_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($iframe_url, "") . "', ''), " . "nullIf('" . MyUtil::nvl(MyUtil::null_if($votes, ''), 0) . "', -1), " . "nullIf('" . MyUtil::nvl($upload_status_nbr, 0) . "', -1), " . "nullIf('" . MyUtil::nvl($video_status_nbr, 0) . "', -1), " . "CURRENT_TIMESTAMP, " . "'" . $_SESSION['user'] . "', " . "nullIf('" . MyUtil::nvl($file, "") . "', ''), " . "'" . MyUtil::nvl($is_active, "false") . "' " . ")";
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
return MyUtil::fnOk(true, "Inserted Video", $result);
}
