/**
* Renders a text from the database.
*
* If the user is logged in as an admin user,
* then a link to the appropriate page in the admin section is provided.
*
* If the user is not logged in and the section required is 'content',
* then the exception is propagated.
*
* Otherwise, the function does nothing.
*/
public static function render_page_section($page_name, $section_name)
{
if (DEBUG) {
echo DEBUG_DELIM_OPEN;
echo __FILE__ . PHP_EOL;
echo 'Line: ' . __LINE__ . PHP_EOL;
echo 'Method: ' . __METHOD__ . PHP_EOL;
echo DEBUG_DELIM_CLOSE;
}
try {
$filtered_page_section = DBPages_SPoE::get_filtered_page_section($page_name, $section_name);
if (Admin_LogInHelper::is_logged_id()) {
DBPages_AdminHelper::render_link_p_to_edit_section_admin_page($page_name, $section_name);
}
echo $filtered_page_section;
} catch (DBPages_PageSectionNotFoundException $e) {
#print_r($e);
if (Admin_LogInHelper::is_logged_id()) {
DBPages_AdminHelper::render_link_p_to_add_new_section_admin_page($page_name, $section_name);
} else {
if ($section_name == 'content') {
throw $e;
} else {
#echo '<p class="error">Text not found.</p>' . "\n";
}
}
}
}
/**
* Renders a text from the database.
*
* If the user is logged in as an admin user,
* then a link to the appropriate page in the admin section is provided.
*
* if the user is not logged in and the section required is 'content', then the exception
* is propagated.
*
* Otherwise, the function does nothing.
*/
public static function render_page_section($page_name, $section_name)
{
try {
$filtered_page_section = DBPages_SPoE::get_filtered_page_section($page_name, $section_name);
if (Admin_LogInHelper::is_logged_id()) {
DBPages_AdminHelper::render_link_p_to_edit_section_admin_page($page_name, $section_name);
}
echo $filtered_page_section;
} catch (DBPages_PageSectionNotFoundException $e) {
#print_r($e);
if (Admin_LogInHelper::is_logged_id()) {
DBPages_AdminHelper::render_link_p_to_add_new_section_admin_page($page_name, $section_name);
} else {
if ($section_name == 'content') {
throw $e;
} else {
#echo '<p class="error">Text not found.</p>' . "\n";
}
}
}
}
protected function do_actions()
{
//print_r($_POST);exit;
/** EXAMPLE FORM POST
*<textarea name="contents">
*$contents
*</textarea>
*<input type="hidden" name="filter_function" value="$filter_function" />
*<input type="hidden" name="page" value="$page" />
*<input type="hidden" name="section" value="$section" />
*<input type="hidden" name="language" value="$name" />
*<input type="hidden" name="path" value="$path" />
*<input type="submit" value="Edit" />
*/
$return_url = VideoLibrary_URLHelper::get_home_page_url();
if (Admin_LogInHelper::is_logged_id()) {
$return_url = $this->get_redirect_script_return_url();
// print_r($return_url);exit;
try {
if (isset($_POST['name']) && $_POST['name'] != '' && (isset($_POST['length']) && $this->validate_length($_POST['length'])) && (isset($_POST['external_video_provider_id']) && $_POST['external_video_provider_id'] != '') && (isset($_POST['external_video_library_id']) && $_POST['external_video_library_id'] != '') && (isset($_POST['providers_internal_id']) && $_POST['providers_internal_id'] != '') && (isset($_POST['status']) && $_POST['status'] != '') && $this->is_video_unique($_POST['external_video_provider_id'], $_POST['providers_internal_id'])) {
$dbh = DB::m();
$name = htmlentities($_POST['name']);
$name = mysql_real_escape_string($name, $dbh);
$length_seconds = $this->get_length_in_seconds_from_input($_POST['length']);
$length_seconds = mysql_real_escape_string($length_seconds);
$external_video_library_id = mysql_real_escape_string($_POST['external_video_library_id']);
$external_video_provider_id = mysql_real_escape_string($_POST['external_video_provider_id']);
$providers_internal_id = mysql_real_escape_string($_POST['providers_internal_id']);
$status = mysql_real_escape_string($_POST['status']);
$added_by = mysql_real_escape_string(VideoLibrary_AdminHelper::get_logged_in_admin_user_name());
$tags = VideoLibrary_TagsHelper::get_tags_array_for_admin_post_input($_POST['tags']);
//print_r($tags);exit;
$stmt = <<<SQL
INSERT
INTO
hpi_video_library_external_videos
SET
name = '{$name}',
length_seconds = '{$length_seconds}',
external_video_provider_id = '{$external_video_provider_id}',
providers_internal_id = '{$providers_internal_id}',
status = '{$status}',
date_added = NOW(),
added_by = '{$added_by}'
SQL;
//print_r($stmt);exit;
$result = mysql_query($stmt, $dbh);
$id = mysql_insert_id($dbh);
$stmt_2 = <<<SQL
INSERT
INTO
hpi_video_library_ext_vid_to_ext_vid_lib_links
SET
external_video_id = '{$id}',
external_video_library_id = '{$external_video_library_id}'
SQL;
//print_r($stmt);exit;
$result = mysql_query($stmt_2, $dbh);
foreach ($tags as $tag) {
$tag = mysql_real_escape_string($tag);
$tag_query_1 = <<<SQL
INSERT
INTO
hpi_video_library_tags
SET
tag = '{$tag}',
principal = 'no'
SQL;
$result = mysql_query($tag_query_1, $dbh);
if ($result) {
$tag_id = mysql_insert_id($dbh);
} else {
if (mysql_errno() == 1062) {
#duplicate
$tag_id = VideoLibrary_DatabaseHelper::get_tag_id_for_tag_string($tag);
}
}
$tag_query_2 = <<<SQL
INSERT
INTO
hpi_video_library_tags_to_ext_vid_links
SET
tag_id = '{$tag_id}',
external_video_id = '{$id}'
SQL;
$result = mysql_query($tag_query_2, $dbh);
if (!$result) {
if (mysql_errno() == 1062) {
#duplicate
# Do nothing, link already exists
}
}
}
$this->add_video_to_thumbnail_queue($id);
} else {
throw new VideoLibrary_AddVideoDataNotSetException();
}
} catch (VideoLibrary_Exception $e) {
$return_url->set_get_variable('error', urlencode($e->getMessage()));
}
$return_url->set_get_variable('edited', '1');
$return_url->set_get_variable('message', 'Added Video ' . urlencode('#') . $id);
}
$this->set_return_to_url($return_url);
}
public static function get_thumbnail_div_for_video($video_data, $options = array('admin' => FALSE))
{
$div = new HTMLTags_Div();
$div->set_attribute_str('class', 'video');
$url = VideoLibrary_URLHelper::get_video_page_url($video_data['id'], $video_data['name']);
$img_a = new HTMLTags_A();
$img_a->set_href($url);
$img_a->append(self::get_thumbnail_img($video_data['thumbnail_url']));
$details_ul = new HTMLTags_UL();
$details_ul->set_attribute_str('class', 'details');
$name_a = new HTMLTags_A();
$name_a->set_attribute_str('class', 'text');
$name_a->set_href($url);
$name_a->set_attribute_str('title', stripslashes($video_data['name']));
$name_a->append(self::truncate_video_name(stripslashes($video_data['name']), 50));
$name_li = new HTMLTags_LI();
$name_li->set_attribute_str('class', 'name');
$name_li->append($name_a);
$details_ul->append($name_li);
$length_min = self::get_minutes_from_seconds($video_data['length_seconds']);
$details_ul->append('<li class="length">' . $length_min . ' min</li>');
$details_ul->append('<li class="views">' . $video_data['views'] . ' views</li>');
$provider_img = self::get_img_for_external_provider_name($video_data['external_video_provider_name'], 16);
$provider_img->set_attribute_str('class', 'provider');
$div->append($img_a);
$div->append($details_ul);
$div->append($provider_img);
if ($options['admin'] && Admin_LogInHelper::is_logged_id()) {
$links_ul = new HTMLTags_UL();
$links_ul->set_attribute_str('class', 'options');
$edit_li = '<li>' . VideoLibrary_AdminHelper::get_link_to_edit_video_admin_page_div($video_data['id'])->get_as_string() . '</li>';
$links_ul->append($edit_li);
$div->append($links_ul);
$div->append('<hr />');
}
return $div;
}
