You are not registered.
Registration allows you to subscribe to projects, open projects, and more. Click here to register.Website Source Code
<< Back
media.php
media.php
<?php
function get_media_main($project_row, $id)
{
global $categories, $project_admin;
$media = create_link($project_row[1], $id, $project_row[0]) . 'media/';
if ($project_admin)
{
$upload = '<a href="' . create_link($project_row[1], $id, $project_row[0]) . 'admin/media/" style="font-style: italic; font-size: 10px">[Upload]</a> <a href="' . create_link($project_row[1], $id, $project_row[0]) . 'admin/media/folder/" style="font-style: italic; font-size: 10px">[Create a Folder]</a><br /><br />';
}
else
{
$upload = '';
}
$vars['MEDIA'] = '';
if (isset($_GET['params']))
{
$ex = explode('-', $_GET['params']);
if (!strpos($_GET['params'], '/'))
{
$result = mysql_query('SELECT `id`, `file`, `title`, `description`, `type`, `date`, `folder`, `comments`, `project` FROM `media_entries` WHERE `id` = ' . intval($ex[0]) . ' LIMIT 1;');
return $upload . get_media_show($project_row, $id, $media, mysql_fetch_row($result));
}
else
{
$folder = intval($ex[0]);
$row = mysql_fetch_row(mysql_query('SELECT `title`, `description` FROM `media_folders` WHERE `id` = ' . $folder . ' LIMIT 1;'));
$folder_title = '<div style="font-size: 10px"> > <a href="' . $media . '">Main</a> > <a href="' . $media . $ex[0] . '-' . format_title_address($row[0]) . '/">' . escape_html($row[0]) . '</a></div>';
$folder_title .= '<div style="font-style: italic; font-size: 13px; border: solid 1px #cccccc; background-color: #eeeeee; padding: 5px">' . xss_safe($row[1]);
if ($project_admin)
{
$folder_title .= '<br /><a href="' . create_link($project_row[1], $id, $project_row[0]) . 'admin/media/edit_folder/' . $folder . '" style="font-style: italic; font-size: 10px">[Edit Folder]</a> ';
$folder_title .= '<a href="#" style="font-style: italic; font-size: 10px" onclick="if (confirm(\'Are you sure?\'))
document.location=\'' . create_link($project_row[1], $id, $project_row[0]) . 'admin/media/remove_folder/' . $folder . '\';
return false;">[Remove Folder]</a>';
}
$folder_title .= '</div>';
//$folder_title .= '<div style="font-style: italic; font-size: 13px; border: solid 1px #cccccc; background-color: #eeeeee; padding: 5px">' . nl2br(plain_to_link(escape_html($row[1]))) . '</div>';
}
}
else
{
$result = mysql_query('SELECT `id`, `title` FROM `media_folders` WHERE `project` = ' . $id . ';');
while ($row = mysql_fetch_assoc($result))
{
$folder_vars['TITLE'] = $row['title'];
$folder_vars['LINK'] = $media . $row['id'] . '-' . format_title_address($row['title']) . '/';
$folder_vars['IMAGE'] = 'images/folder.png';
$folder_vars['HEIGHT'] = '53px';
$folder_vars['WIDTH'] = '67px';
$vars['MEDIA'] .= get_template('media_folder', $folder_vars);
}
$folder = 0;
$folder_title = '<div style="font-size: 10px"> > <a href="' . $media . '">Main</a></div>';
}
$result = mysql_query('SELECT `id`, `file`, `title`, `project`, `type` FROM `media_entries` WHERE `project` = ' . $id . ' AND `folder` = ' . $folder . ' ORDER BY `date` DESC;');
if ((mysql_num_rows($result) == 0) && ($vars['MEDIA'] == ''))
$vars['MEDIA'] = '<div style="font-style: italic">Sorry, no media files has been found.</div>';
while ($row = mysql_fetch_assoc($result))
{
$folder_vars['TITLE'] = $row['title'];
$folder_vars['LINK'] = $media . $row['id'] . '-' . format_title_address($row['title']);
$folder_vars['IMAGE'] = 'projects_media/' . $id . '/' . $row['file'];
$icon_size = getimagesize('projects_media/' . $id . '/' . $row['file']);
$size = get_image_size($icon_size[0], $icon_size[1], 67);
$folder_vars['WIDTH'] = $size[0] . 'px';
$folder_vars['HEIGHT'] = $size[1] . 'px';
//$folder_vars['HEIGHT'] = '53px';
//$folder_vars['WIDTH'] = '67px';
$vars['MEDIA'] .= get_template('media_folder', $folder_vars);
}
$vars['FOLDERS'] = $folder_title;
return $upload . get_template('media', $vars);
}
function get_media_show($project_row, $proj_id, $media, $media_row)
{
global $logged_user, $project_admin, $url;
$update = comments_update($media_row[7]);
if ($update != null)
{
mysql_query('UPDATE `media_entries` SET `comments` = \'' . db_escape($update) . '\' WHERE `id` = ' . $media_row[0] . ' LIMIT 1;');
$media_row[7] = $update;
tell_users(4, $proj_id, 'A new comment had been posted in ' . $project_row[0], "Read more:\n" . $url . $media . $media_row[0] . '-' . format_title_address($media_row[2]));
}
if ($media_row[6] == 0)
{
$vars['FOLDERS'] = '<div style="font-size: 10px"> > <a href="' . $media . '">Main</a> > <a href="' . $media . $media_row[0] . '-' . format_title_address($media_row[2]) . '/">' . escape_html($media_row[2]) . '</a></div>';
}
else
{
$folder = mysql_fetch_row(mysql_query('SELECT `title` FROM `media_folders` WHERE `id` = ' . $media_row[6] . ' LIMIT 1;'));
$folder = $folder[0];
$vars['FOLDERS'] = '<div style="font-size: 10px"> > <a href="' . $media . '">Main</a> > <a href="' . $media . $media_row[6] . '-' . format_title_address($folder) . '/">' . escape_html($folder) . '</a> > <a href="' . $media . $media_row[0] . '-' . format_title_address($media_row[2]) . '/">' . escape_html($media_row[2]) . '</a></div>';
}
$vars['TITLE'] = escape_html($media_row[2]);
//$vars['DESC'] = nl2br(plain_to_link(escape_html($media_row[3])));
$vars['DESC'] = xss_safe($media_row[3]);
if ($project_admin)
{
$vars['DESC'] .= '<br />';
$vars['DESC'] .= '<a href="' . create_link($project_row[1], $proj_id, $project_row[0]) . 'admin/media/edit/' . $media_row[0] . '" style="font-style: italic; font-size: 10px">[Edit]</a> ';
$vars['DESC'] .= '<a href="#" style="font-style: italic; font-size: 10px" onclick="if (confirm(\'Are you sure?\'))
document.location=\'' . create_link($project_row[1], $proj_id, $project_row[0]) . 'admin/media/delete/' . $media_row[0] . '\';
return false;">[Delete]</a>';
}
switch ($media_row[4])
{
case 0:
$vars['MEDIA'] = '<img src="projects_media/' . $media_row[8] . '/' . escape_html($media_row[1]) . '" alt="' . escape_html($media_row[2]) . '" />';
break;
case 1:
$vars['MEDIA'] = '<i>Video: Not yet.</i>';
break;
}
$vars['COMMENTS'] = comments_process($media_row[7]);
if ($logged_user == -1)
{
$vars['SEND_COMMENT'] = '<div style="font-style: italic">You have to be registered to post comments.</div>';
}
else
{
$send_vars['NOTHING'] = 'nothing';
$vars['SEND_COMMENT'] = get_template('send_comment', $send_vars);
}
return get_template('show_media', $vars);
}
?>
