';
}
function display_selectusers() {
global $galleryaction,$gmember;
$result = mysql_query('select a.*, b.mname as membername from '.sql_table('plug_gallery_member').' as a, '.sql_table('member').' as b where mnumber=memberid');
if(!$result) {
echo mysql_error();
return;
}
echo '
';
//query for list of users not already assigned in plug_gallery_member and not site admins (they can always add)
$result = mysql_query('select * from '.sql_table('member').' as a left join '.sql_table('plug_gallery_member').' as b on mnumber=memberid where madmin=0 and memberid is NULL');
if(!$result) {
echo mysql_error();
return;
}
if(mysql_num_rows($result)) {
?>
'.$galleryconfig['message'].'';
}
else setNPGoption('configured', true);
$NPG_CONF = getNPGConfig();
if(!$NPG_CONF['configured']) echo '
';
}
function display_comments() {
global $gmember,$galleryaction,$NPG_CONF,$CONF,$NP_BASE_DIR;
$amount = requestvar('amount');
$page = requestvar('page');
if($amount) $NPG_CONF['AdminCommentsPerPage'] = intval($amount);
if (!$NPG_CONF['AdminCommentsPerPage']) {
setNPGOption('AdminCommentsPerPage',25);
$NPG_CONF['AdminCommentsPerPage'] = 25;
}
$offset = intval($page - 1) * $NPG_CONF['AdminCommentsPerPage'];
if ($offset <= 0) $offset = '0';
if(!$page) $page='1';
$query = 'select * from '.sql_table('plug_gallery_comment').' as a left join '.sql_table('member').' as b on a.cmemberid=b.mnumber left join '.sql_table('plug_gallery_picture').' as c on a.cpictureid=c.pictureid limit '.$offset.', '.($NPG_CONF['AdminCommentsPerPage']+1);
$res = sql_query($query);
$nrows = mysql_num_rows($res);
//navigation
echo "\n".'
';
echo ' '.__NPG_ADMIN_RETURN.'';
echo '';
}
}
function action_addtemplate() {
global $gmember;
$name = addslashes(postvar('tname'));
$desc = addslashes(postvar('tdesc'));
if($gmember->isAdmin() && $name && $desc) {
$query = 'insert into '.sql_table('plug_gallery_template_desc')." (tdid, tdname, tddesc) values (NULL,'$name','$desc')";
sql_query($query);
}
$this->action_templates();
}
function action_clonetemplate() {
global $gmember;
//get postvars: templateid from template to clone
$id = requestvar('id');
if($id && $gmember->isAdmin()) {
//get template data from plg_gallery_template_desc and plug_gallery_template
$origtemplate = new NPG_TEMPLATE($id);
//write data to database tables, generating a new tdid for the same data
$newtemplate = new NPG_TEMPLATE(NPG_TEMPLATE::createnew('cln_'.$origtemplate->getname(), 'Clone of '.$origtemplate->getdesc()));
foreach($origtemplate->section as $name => $content)
$newtemplate->settemplate($name,$content);
}
$this->action_templates();
}
function action_deletetemplate() {
global $gmember;
$id = requestvar('id');
//don't delete if it's the only template in the database -- you need at least one
$query = 'select count(*) from '.sql_table('plug_gallery_template_desc');
$res = sql_query($query);
$nr = mysql_fetch_row($res);
if ($nr[0] > 1 && $id && NPG_TEMPLATE::existsID($id) && $gmember->isAdmin()) {
$query = 'delete from '.sql_table('plug_gallery_template_desc').' where tdid='.$id;
sql_query($query);
$query = 'delete from '.sql_table('plug_gallery_template').' where tdesc='.$id;
sql_query($query);
}
$this->action_templates();
}
function action_edittemplate() {
global $gmember;
$id = $_POST['id'];
if($gmember->isAdmin() && $id) {
$t = new NPG_TEMPLATE($id);
if(isset($_POST['tname']) && isset($_POST['tdesc'])) {
$t->updategeneralinfo($_POST['tname'],$_POST['tdesc']);
}
$vars = array('LIST_HEADER','LIST_BODY','LIST_THUM','LIST_FOOTER','ALBUM_HEADER','ALBUM_BODY','ALBUM_SETDISPLAY','ALBUM_FOOTER','ITEM_HEADER','ITEM_TOOLTIPSHEADER','ITEM_BODY','ITEM_SLIDESHOWT','ITEM_SLIDESHOWC','ITEM_FOOTER','ITEM_TOOLTIPSFOOTER','ITEM_NEXTPREVTHUMBS','COMMENT_HEADER','COMMENT_BODY','COMMENT_FOOTER','PROMO_TITLE','PROMO_BODY','PROMO_IMAGES');
foreach($vars as $j) {
if(isset($_POST[$j])) {
$t->update($j,$_POST[$j]);
}
}
//if($success) echo __NPG_ADMIN_UPDATE_TEMPLATE.' '; else echo __NPG_ERR_NO_UPD_TEMPLATE.' ';
//else echo _ERROR_DISALLOWED;
}
$this->action_templates();
}
function action_comments() {
global $gmember;
$this->display_tabs('comments');
$this->display_comments();
}
function action_editcommentF() {
global $galleryaction;
$id = intval(requestvar('id'));
$query = 'select * from '.sql_table('plug_gallery_comment').' as a left join '.sql_table('member').' as b on a.cmemberid=b.mnumber where a.commentid='.$id;
$res = sql_query($query);
$row = mysql_fetch_object($res);
?>
';
}
function action_editcomment() {
global $gmember;
$id = intval(requestvar('id'));
$body = addslashes(requestvar('body'));
if( $gmember->canModifyComment($id) ) {
sql_query('update '.sql_table('plug_gallery_comment').' set cbody = "'.$body.'" where commentid='.$id);
}
$this->action_comments();
}
function action_deletecomment() {
global $gmember,$galleryaction;
$id = intval(requestvar('id'));
$query = 'select * from '.sql_table('plug_gallery_comment').' as a left join '.sql_table('member').' as b on a.cmemberid=b.mnumber where a.commentid='.$id;
$res = sql_query($query);
if(mysql_num_rows($res)) {
$row = mysql_fetch_object($res);
} else {
echo __NPG_ADMIN_NO_COMMENT.' ';
return;
}
if($gmember->canModifyComment($id) ) {
echo '