nestedSetsInit('cms_photo_albums');
$album_id = $ns->AddRootNode($differ);
$sql = "UPDATE cms_photo_albums
SET user_id = '$user_id',
title = '-Корневой альбом клуба $title-',
orderform=0
WHERE id = '$album_id'";
$inDB->query($sql);
return $album_id;
}
function albumCreate($differ='', $parent_id, $title, $description, $user_id){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
$ns = $inCore->nestedSetsInit('cms_photo_albums');
$album_id = $ns->AddNode($parent_id, -1, $differ);
$sql = "UPDATE cms_photo_albums
SET title='$title',
description='$description',
published=1,
showdate=1,
iconurl='',
pubdate=NOW(),
orderby='pubdate',
orderto='desc',
public=1,
perpage=16,
cssprefix='',
thumb1=96,
thumb2=600,
thumbsqr=1,
showtype='lightbox',
nav=1,
uplimit=100,
maxcols=4,
orderform=1,
showtags=1,
bbcode=1,
user_id=$user_id
WHERE id = $album_id";
$inDB->query($sql);
return ($inDB->errno()) ? false: true;
}
function albumEdit($album_id, $parent_id, $title, $description, $differ=''){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
$old_parent = dbGetField('cms_photo_albums', 'id='.$album_id, 'parent_id');
if ($old_parent!=$parent_id){
$ns = $inCore->nestedSetsInit('cms_photo_albums');
$ns->MoveNode($album_id, $parent_id, -1, $differ);
}
$sql = "UPDATE cms_photo_albums
SET title='$title',
description='$description'
WHERE id = $album_id";
$inDB->query($sql);
return ($inDB->errno()) ? false: true;
}
function albumDelete($album_id, $differ=''){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
$inCore->loadLib('tags');
$sql = "SELECT id, file FROM cms_photo_files WHERE album_id = $album_id";
$result = $inDB->query($sql) ;
//DELETE ALL PHOTOS IN ALBUM
if ($inDB->num_rows($result)){
while($photo = $inDB->fetch_assoc($result)){
cmsClearTags('photo', $photo['id']);
$inDB->query("DELETE FROM cms_photo_files WHERE id = ".$photo['id']) ;
$inCore->deleteComments('photo', $photo['id']);
$inCore->deleteRatings('photo', $photo['id']);
@unlink($_SERVER['DOCUMENT_ROOT'].'/images/photos/'.$photo['file']);
@unlink($_SERVER['DOCUMENT_ROOT'].'/images/photos/thumb/'.$photo['file'].'.jpg');
}
}
//DELETE ALBUM
$ns = $inCore->nestedSetsInit('cms_photo_albums');
$inCore->deleteComments('palbum', $album_id);
return $ns->DeleteNode($album_id, $differ);
}
function cmsPhotoList($album){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
ob_start();
//SHOW ALBUM CONTENT
$sql = "SELECT * FROM cms_photo_albums WHERE id = '{$album['id']}' LIMIT 1";
$result = $inDB->query($sql) ;
if ($inDB->num_rows($result)==1){
$album_row = $inDB->fetch_assoc($result);
//SQL BUILD
$sql = "SELECT f.*, IFNULL(r.total_rating, 0) as rating
FROM cms_photo_files f
LEFT JOIN cms_ratings_total r ON r.item_id=f.id AND r.target='photo'
WHERE f.album_id = '{$album['id']}' AND f.published = 1
";
//ORDERING
if (isset($album['orderby'])) {
$orderby = $album['orderby'];
} else {
$orderby = 'pubdate';
}
if (isset($album['orderto'])) {
$orderto = $album['orderto'];
} else {
$orderto = 'desc';
}
$sql .= " ORDER BY ".$orderby." ".$orderto." \n";
if ($album['max']){
$sql .= "LIMIT ".$album['max'];
}
$result = $inDB->query($sql) ;
$col = 1; $maxcols = $album['maxcols'];
if ($inDB->num_rows($result)){
if ($album['header']){
echo '';
}
//VIEW AS GALLERY (SIMPLE)
echo '';
while($con = $inDB->fetch_assoc($result)){
$photolink = '/photos/photo'.$con['id'].'.html';
$photolink2 = '/photos/photo'.$con['id'].'.html';
if ($col==1) { echo ''; } echo '| ';
echo '';
echo ' | '; if ($col==$maxcols) { echo '
'; $col=1; } else { $col++; }
}
if ($col>1) { echo ' | '; }
echo '
';
} else {
if($id != $root['id']) { echo 'Нет фотографий в этом альбоме.
'; }
}
}//END - ALBUM CONTENT
return ob_get_clean();
}
?>
!['.$con['title'].'](/images/photos/small/'.$con['file'].')
';
echo '';
echo '