function edit_album($csn) { global $upload_powers; include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php"; $path = get_tadgallery_cate_path($csn, false); $patharr = array_keys($path); $make_option_js = ""; foreach ($patharr as $k => $of_csn) { $j = $k + 1; $make_option_js .= "make_option('of_csn_menu','{$k}','{$of_csn}','{$patharr[$j]}');\n"; } $span = $_SESSION['bootstrap'] == '3' ? 'col-md-' : 'span'; $controls_row = $_SESSION['bootstrap'] == '3' ? 'form-group' : 'control-group'; $album = tadgallery::get_tad_gallery_cate($csn); //可見群組 $SelectGroup_name = new XoopsFormSelectGroup("", "enable_group", false, explode(",", $album['enable_group']), 3, true); $SelectGroup_name->addOption("", _MD_TADGAL_ALL_OK, false); $SelectGroup_name->setExtra("class='{$span}12'"); $enable_group = $SelectGroup_name->render(); //可上傳群組 $SelectGroup_name = new XoopsFormSelectGroup("", "enable_upload_group", false, explode(",", $album['enable_upload_group']), 3, true); $SelectGroup_name->setExtra("class='{$span}12'"); $enable_upload_group = $SelectGroup_name->render(); if ($_SESSION['bootstrap'] == '3') { $form_col = "\n <div class='form-group'>\n <label class='col-md-2 control-label'>" . _MD_TADGAL_ALBUM_TITLE . "</label>\n <div class='col-md-10'>\n <input class='form-control' type='text' name='title' value='{$album['title']}' id='newTitle' placeholder='" . _MD_TADGAL_TITLE . "'>\n </div>\n </div>\n\n\n <div class='form-group'>\n <label class='col-md-2 control-label'>" . _MD_TADGAL_OF_CSN . "</label>\n <div class='col-md-10'>\n <select name='of_csn_menu[0]' id='of_csn_menu0' class='of_csn_menu'><option value=''></option></select>\n <select name='of_csn_menu[1]' id='of_csn_menu1' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[2]' id='of_csn_menu2' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[3]' id='of_csn_menu3' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[4]' id='of_csn_menu4' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[5]' id='of_csn_menu5' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[6]' id='of_csn_menu6' class='of_csn_menu' style='display: none;'></select>\n </div>\n </div>\n\n\n <div class='form-group'>\n <label class='col-md-2 control-label'>" . _MD_TADGAL_CATE_POWER_SETUP . "</label>\n <div class='col-md-5'>\n <label>" . _MD_TADGAL_ENABLE_GROUP . "</label>\n {$enable_group}\n </div>\n <div class='col-md-5'>\n <label>" . _MD_TADGAL_ENABLE_UPLOAD_GROUP . "</label>\n {$enable_upload_group}\n </div>\n </div>\n\n\n <div class='form-group'>\n <label class='col-md-2 control-label'>" . _MD_TADGAL_PASSWD . "</label>\n <div class='col-md-4'>\n <input type='text' name='passwd' class='form-control' value='{$album['passwd']}' placeholder='" . _MD_TADGAL_PASSWD_DESC . "'>\n </div>\n\n <label class='col-md-2 control-label'></label>\n <div class='col-md-4'>\n <input type='hidden' name='csn' value='{$album['csn']}'>\n <input type='hidden' name='show_mode' value='{$album['show_mode']}'>\n <input type='hidden' name='op' value='update_tad_gallery_cate'>\n <button type='submit' class='btn btn-primary' id='sbtn'>" . _TAD_SAVE . "</button>\n </div>\n </div>\n "; } else { $form_col = "\n <div class='control-group'>\n <label class='{$span}2 control-label'>" . _MD_TADGAL_ALBUM_TITLE . "</label>\n <div class='{$span}10 controls controls-row'>\n <input class='span12 form-control' type='text' name='title' value='{$album['title']}' id='newTitle' placeholder='" . _MD_TADGAL_TITLE . "'>\n </div>\n </div>\n\n\n <div class='control-group'>\n <label class='{$span}2 control-label'>" . _MD_TADGAL_OF_CSN . "</label>\n <div class='{$span}10 controls controls-row'>\n <select name='of_csn_menu[0]' id='of_csn_menu0' class='of_csn_menu'><option value=''></option></select>\n <select name='of_csn_menu[1]' id='of_csn_menu1' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[2]' id='of_csn_menu2' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[3]' id='of_csn_menu3' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[4]' id='of_csn_menu4' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[5]' id='of_csn_menu5' class='of_csn_menu' style='display: none;'></select>\n <select name='of_csn_menu[6]' id='of_csn_menu6' class='of_csn_menu' style='display: none;'></select>\n </div>\n </div>\n\n\n <div class='control-group'>\n <label class='{$span}2 control-label'>" . _MD_TADGAL_CATE_POWER_SETUP . "</label>\n <div class='{$span}5 controls controls-row'>\n <label>" . _MD_TADGAL_ENABLE_GROUP . "</label>\n {$enable_group}\n </div>\n <div class='{$span}5 controls controls-row'>\n <label>" . _MD_TADGAL_ENABLE_UPLOAD_GROUP . "</label>\n {$enable_upload_group}\n </div>\n </div>\n\n\n <div class='control-group'>\n <label class='{$span}2 control-label'>" . _MD_TADGAL_PASSWD . "</label>\n <div class='{$span}4 controls controls-row'>\n <input type='text' name='passwd' class='span12 form-control' value='{$album['passwd']}' placeholder='" . _MD_TADGAL_PASSWD_DESC . "'>\n </div>\n\n <label class='{$span}2 control-label'></label>\n <div class='{$span}4 controls controls-row'>\n <input type='hidden' name='csn' value='{$album['csn']}'>\n <input type='hidden' name='op' value='update_tad_gallery_cate'>\n <button type='submit' class='btn btn-primary' id='sbtn'>" . _TAD_SAVE . "</button>\n </div>\n </div>\n "; } $form = "\n <script>\n \$(function(){\n {$make_option_js}\n \$('#myForm').bind('submit', function() {\n \$.ajax({\n type : 'POST',\n cache : false,\n url : 'ajax.php',\n data : \$(this).serializeArray(),\n success: function(data) {\n if(\$('#newTitle').val()!=''){\n \$('#albumTitle{$csn}').parent().addClass('outline');\n \$('#albumTitle{$csn}').text(\$('#newTitle').val());\n }\n\n \$.fancybox.close();\n location.reload();\n }\n });\n return false;\n });\n })\n\n\n function make_option(menu_name , num , of_csn , def_csn){\n \$('#'+menu_name+num).show();\n \$.post('ajax_menu.php', {'of_csn': of_csn , 'def_csn': def_csn} , function(data) {\n \$('#'+menu_name+num).html(\"<option value=''>/</option>\"+data);\n });\n\n \$('.'+menu_name).change(function(){\n var menu_id= \$(this).attr('id');\n var len=menu_id.length-1;\n var next_num = Number(menu_id.charAt(len))+1\n var next_menu = menu_name + next_num;\n \$.post('ajax_menu.php', {'of_csn': \$('#'+menu_id).val()} , function(data) {\n if(data==''){\n \$('#'+next_menu).hide();\n }else{\n \$('#'+next_menu).show();\n \$('#'+next_menu).html(\"<option value=''>/</option>\"+data);\n }\n\n });\n });\n }\n </script>\n\n <form action='' method='post' id='myForm' style='width:600px;' class='form-horizontal' role='form'>\n {$form_col}\n </form>"; return $form; }
function list_tad_gallery($csn = "", $show_function = 1) { global $xoopsDB, $xoopsModule, $xoopsModuleConfig, $xoopsTpl; $tadgallery = new tadgallery(); $xoopsTpl->assign("jquery", get_jquery(true)); $xoopsTpl->assign("csn", $csn); if (isset($_SESSION['gallery_list_mode']) and $_SESSION['gallery_list_mode'] == "good") { $mode_select = "<a href='main.php?op=chg_mode&mode=normal#gallery_top' class='btn btn-warning'>" . _MA_TADGAL_LIST_NORMAL . "</a>"; $tadgallery->set_view_good(true); $cate_options = $cate_option = $link_to_cate = ""; } else { $mode_select = "<a href='main.php?op=chg_mode&mode=good#gallery_top' class='btn btn-warning'>" . _MA_TADGAL_LIST_GOOD . "</a>"; $tadgallery->set_view_good(false); $tadgallery->set_view_csn($csn); list_tad_gallery_cate_tree($csn); $cate = tadgallery::get_tad_gallery_cate($csn); $link_to_cate = !empty($csn) ? "<a href='../index.php?csn={$csn}' class='btn btn-info'>" . sprintf(_MA_TADGAL_LINK_TO_CATE, $cate['title']) . "</a>" : ""; } $tag_select = tag_select("", "add_tag"); $xoopsTpl->assign("cate_option", $cate_option); $xoopsTpl->assign("mode_select", $mode_select); $xoopsTpl->assign("link_to_cate", $link_to_cate); $xoopsTpl->assign("option", $cate_options); $xoopsTpl->assign("tag_select", $tag_select); $tadgallery->set_admin_mode(true); $tadgallery->get_photos(); }
function mk_rss_xml($the_csn = "") { global $xoopsDB, $xoopsModule, $xoopsConfig; $tadgallery = new tadgallery(); $ok_cat = $tadgallery->chk_cate_power(); if (!empty($the_csn)) { if (in_array($the_csn, $ok_cat)) { $where = "and a.csn='{$the_csn}'"; $cate = $tadgallery->get_tad_gallery_cate($the_csn); $rss_title = $cate['title']; $rss_link = XOOPS_URL . "/modules/tadgallery/index.php?csn={$the_csn}"; $rss_filename = _TADGAL_UP_FILE_DIR . "photos{$the_csn}.rss"; } else { return; } } else { $ok_str = implode("','", $ok_cat); $where = "and a.csn in('{$ok_str}') "; $rss_title = $xoopsConfig['sitename']; $rss_link = XOOPS_URL . "/modules/tadgallery"; $rss_filename = _TADGAL_UP_FILE_DIR . "photos.rss"; } $sql = "select a.sn,a.csn,a.title,a.description,a.filename,a.size,a.dir from " . $xoopsDB->prefix("tad_gallery") . " as a , " . $xoopsDB->prefix("tad_gallery_cate") . " as b where a.csn=b.csn {$where} and b.passwd='' and b.enable_group='' order by a.post_date desc"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error() . "<br>{$sql}"); $main = "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"?>\n<rss version=\"2.0\" xmlns:media=\"http://search.yahoo.com/mrss/\" xmlns:atom=\"http://www.w3.org/2005/Atom\">\n <channel>\n <atom:icon>" . XOOPS_URL . "/modules/tadgallery/images/piclen_logo.png</atom:icon>\n <generator>Tad Gallery</generator>\n <title>{$rss_title}</title>\n <link>{$rss_link}</link>\n <description></description>\n"; while (list($sn, $csn, $title, $description, $filename, $size, $dir) = $xoopsDB->fetchRow($result)) { $title = empty($title) ? $filename : $title; $title = htmlspecialchars($title); $description = htmlspecialchars($description); $filename = urlencode(htmlspecialchars($filename)); $pic_url = $tadgallery->get_pic_url($dir, $sn, $filename); $mpic_url = $tadgallery->get_pic_url($dir, $sn, $filename, "m"); $spic_url = $tadgallery->get_pic_url($dir, $sn, $filename, "s"); $main .= " <item>\n <title>{$title}</title>\n <link>" . XOOPS_URL . "/modules/tadgallery/view.php?sn={$sn}</link>\n <guid>{$sn}-{$csn}</guid>\n <media:thumbnail url=\"{$spic_url}\"/>\n <media:content url=\"{$pic_url}\" fileSize=\"{$size}\" />\n <media:title type=\"plain\">{$title}</media:title>\n <media:description type=\"plain\">{$description}</media:description>\n </item>\n"; } $main .= " </channel>\n</rss>\n"; $main = to_utf8($main); if (!($handle = fopen($rss_filename, 'w'))) { redirect_header($_SERVER['PHP_SELF'], 3, sprintf(_MD_TADPLAYER_CANT_OPEN, $rss_filename)); } if (fwrite($handle, $main) === false) { redirect_header($_SERVER['PHP_SELF'], 3, sprintf(_MD_TADPLAYER_CANT_WRITE, $rss_filename)); } fclose($handle); }
<?php /*-----------引入檔案區--------------*/ include_once "header.php"; include_once $GLOBALS['xoops']->path('/modules/system/include/functions.php'); $show_uid = system_CleanVars($_REQUEST, 'show_uid', 0, 'int'); $csn = system_CleanVars($_REQUEST, 'csn', 0, 'int'); $passwd = system_CleanVars($_REQUEST, 'passwd', '', 'string'); $tadgallery = new tadgallery(); if ($show_uid) { $tadgallery->set_show_uid($show_uid); } if (!empty($csn)) { $cate = $tadgallery->get_tad_gallery_cate($csn); if ($cate['show_mode'] == "waterfall") { $xoopsOption['template_main'] = "tadgallery_list_waterfall.html"; } elseif ($cate['show_mode'] == "flickr") { $xoopsOption['template_main'] = "tadgallery_list_flickr.html"; } elseif (isset($_REQUEST['op']) and $_REQUEST['op'] == "passwd_form") { $xoopsOption['template_main'] = "tadgallery_passwd_form.html"; } else { $xoopsOption['template_main'] = "tadgallery_list_normal.html"; } } else { if ($xoopsModuleConfig['index_mode'] == "waterfall") { $xoopsOption['template_main'] = "tadgallery_list_waterfall.html"; } elseif ($xoopsModuleConfig['index_mode'] == "flickr") { $xoopsOption['template_main'] = "tadgallery_list_flickr.html"; } else { $xoopsOption['template_main'] = "tadgallery_list_normal.html"; }
function view_pic($sn = "") { global $xoopsDB, $xoopsUser, $xoopsModule, $xoopsModuleConfig, $xoopsTpl, $xoTheme; $tadgallery = new tadgallery(); //判斷是否對該模組有管理權限, 若空白 if ($xoopsUser) { $nowuid = $xoopsUser->getVar('uid'); $module_id = $xoopsModule->getVar('mid'); $isAdmin = $xoopsUser->isAdmin($module_id); } else { $isAdmin = false; $nowuid = ""; } $sql = "select * from " . $xoopsDB->prefix("tad_gallery") . " where sn='{$sn}'"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $all = $xoopsDB->fetchArray($result); //$csn,$title,$description,$filename,$size,$type,$width,$height,$dir,$uid,$post_date,$counter,$exif,$good,$tag,$photo_sort foreach ($all as $k => $v) { ${$k} = $v; $xoopsTpl->assign($k, $v); } $photo_s = $tadgallery->get_pic_url($dir, $sn, $filename, "s"); $photo_m = $tadgallery->get_pic_url($dir, $sn, $filename, "m"); $photo_l = $tadgallery->get_pic_url($dir, $sn, $filename); $xoopsTpl->assign("photo_s", $photo_s); $xoopsTpl->assign("photo_m", $photo_m); $xoopsTpl->assign("photo_l", $photo_l); if (!empty($csn)) { $ok_cat = $tadgallery->chk_cate_power(); $cate = $tadgallery->get_tad_gallery_cate($csn); if (!in_array($csn, $ok_cat)) { redirect_header("index.php?csn={$csn}&op=passwd_form", 3, sprintf(_TADGAL_NO_PASSWD_CONTENT, $cate['title'])); exit; } $sql = "select * from " . $xoopsDB->prefix("tad_gallery") . " where csn='{$csn}' order by photo_sort , post_date"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $slides1 = $slides2 = ""; $i = 0; $start = false; while ($all = $xoopsDB->fetchArray($result)) { if ($sn == $all['sn']) { $start = true; $i = 0; } if ($start) { $slides1[$i]['sn'] = $all['sn']; $slides1[$i]['photo'] = $tadgallery->get_pic_url($all['dir'], $all['sn'], $all['filename']); $slides1[$i]['description'] = strip_tags($all['description']); $slides1[$i]['thumb'] = $tadgallery->get_pic_url($all['dir'], $all['sn'], $all['filename'], 's'); } else { $slides2[$i]['sn'] = $all['sn']; $slides2[$i]['photo'] = $tadgallery->get_pic_url($all['dir'], $all['sn'], $all['filename']); $slides2[$i]['description'] = strip_tags($all['description']); $slides2[$i]['thumb'] = $tadgallery->get_pic_url($all['dir'], $all['sn'], $all['filename'], 's'); } $i++; } } $xoopsTpl->assign("slides1", $slides1); $xoopsTpl->assign("slides2", $slides2); //找出上一張或下一張 $pnp = get_pre_next($csn, $sn); $xoopsTpl->assign("next", $pnp['next']); $xoopsTpl->assign("back", $pnp['pre']); $arr = get_tadgallery_cate_path($csn); $jBreadCrumbPath = breadcrumb($csn, $arr); $xoopsTpl->assign("path", $jBreadCrumbPath); if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/fancybox.php")) { redirect_header("index.php", 3, _MA_NEED_TADTOOLS); } include_once XOOPS_ROOT_PATH . "/modules/tadtools/fancybox.php"; $fancybox = new fancybox('.fancybox'); $fancybox_code = $fancybox->render(false); $xoopsTpl->assign('fancybox_code', $fancybox_code); $title = empty($title) ? $filename : $title; $div_width = $xoopsModuleConfig['thumbnail_m_width'] + 30; $size_txt = sizef($size); if ($uid == $nowuid or $isAdmin) { $xoopsTpl->assign('show_del', 1); //$del_btn="<a src='javascript:delete_tad_gallery_func($sn)' title='"._TADGAL_DEL_PIC."' class='btn btn-danger'>"._TAD_DEL."</a>"; $xoopsTpl->assign('good', $good); $del_js = "\n <script>\n function delete_tad_gallery_func(sn){\n var sure = window.confirm('" . _TAD_DEL_CONFIRM . "');\n if (!sure) return;\n location.href=\"{$_SERVER['PHP_SELF']}?op=delete_tad_gallery&sn=\" + sn;\n }\n </script>"; } else { $del_btn = $admin_tool = $del_js = ""; } $xoopsTpl->assign('del_btn', $del_btn); //秀出各種尺寸圖示 if ($xoopsModuleConfig['show_copy_pic']) { $xoopsTpl->assign("photo_s", $photo_s); $xoopsTpl->assign("photo_m", $photo_m); $xoopsTpl->assign("photo_l", $photo_l); $xoopsTpl->assign("description", $description); $xoopsTpl->assign("sel_size", 1); } else { $xoopsTpl->assign("sel_size", 0); } //推文工具 $push = push_url($xoopsModuleConfig['use_social_tools']); $xoopsTpl->assign("push", $push); $xoopsTpl->assign("pic_toolbar", $xoopsModuleConfig['pic_toolbar']); $xoopsTpl->assign("thumb_slider", $xoopsModuleConfig['thumb_slider']); //計數器 add_tad_gallery_counter($sn); //地圖部份 $info = explode("||", $exif); foreach ($info as $v) { $exif_arr = explode("=", $v); $exif_arr[1] = str_replace("�", "", $exif_arr[1]); $bb = "\$photoexif{$exif_arr[0]}=\"{$exif_arr[1]}\";"; if (empty($exif_arr[0])) { continue; } @eval($bb); } $latitude = $photoexif['GPS']['latitude']; $longitude = $photoexif['GPS']['longitude']; $xoopsTpl->assign("latitude", $latitude); $xoopsTpl->assign("longitude", $longitude); $jquery_path = get_jquery(true); $xoopsTpl->assign("jquery", $jquery_path); $xoopsTpl->assign("path", $jBreadCrumbPath); $xoopsTpl->assign("del_js", $del_js); $xoopsTpl->assign("div_width", $div_width); $facebook_comments = facebook_comments($xoopsModuleConfig['facebook_comments_width'], 'tadgallery', 'view.php', 'sn', $sn); $xoopsTpl->assign("facebook_comments", $facebook_comments); $fb_tag = "\n <meta property=\"og:title\" content=\"{$title}\" />\n <meta property=\"og:description\" content=\"{$description}\" />\n <meta property=\"og:image\" content=\"" . $tadgallery->get_pic_url($dir, $sn, $filename, "m") . "\" />\n "; $xoopsTpl->assign("xoops_module_header", $fb_tag); $xoopsTpl->assign("xoops_pagetitle", $title); if (is_object($xoTheme)) { $xoTheme->addMeta('meta', 'keywords', $title); $xoTheme->addMeta('meta', 'description', $description); } else { $xoopsTpl->assign('xoops_meta_keywords', 'keywords', $title); $xoopsTpl->assign('xoops_meta_description', $description); } }
function show_cate($csn, $passwd) { global $xoopsDB, $xoopsUser, $xoopsModule, $xoopsModuleConfig, $xoopsTpl, $xoopsOption; $jquery = get_jquery(); //以流水號取得某筆tad_gallery_cate資料 $cate = tadgallery::get_tad_gallery_cate($csn); //可觀看相簿 $ok_cat = tadgallery::chk_cate_power(); //密碼檢查 if (!empty($csn)) { if (empty($passwd) and !empty($_SESSION['tadgallery'][$csn])) { $passwd = $_SESSION['tadgallery'][$csn]; } $sql = "select csn,passwd from " . $xoopsDB->prefix("tad_gallery_cate") . " where csn='{$csn}'"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); list($ok_csn, $ok_passwd) = $xoopsDB->fetchRow($result); if (!empty($ok_csn) and $ok_passwd != $passwd) { redirect_header($_SERVER['PHP_SELF'], 3, sprintf(_TADGAL_NO_PASSWD_CONTENT, $cate['title'])); } if (!empty($ok_passwd) and empty($_SESSION['tadgallery'][$csn])) { $_SESSION['tadgallery'][$csn] = $passwd; } //檢查相簿觀看權限 if (!in_array($csn, $ok_cat)) { redirect_header($_SERVER['PHP_SELF'], 3, _TADGAL_NO_POWER_TITLE, sprintf(_TADGAL_NO_POWER_CONTENT, $cate['title'], $select)); } } //呈現資料預設值 $data = ""; //畫面並不只秀出縮圖,要秀出分類的話。 if ($xoopsModuleConfig['only_thumb'] != '1') { //撈出底下子分類 $sql = "select csn,title,passwd,show_mode,cover from " . $xoopsDB->prefix("tad_gallery_cate") . " where of_csn='{$csn}' order by sort"; //getPageBar_cate $PageBar_cate = getPageBar_mobile($sql, $xoopsModuleConfig['thumbnail_number'], 10); $bar_cate = $PageBar_cate['bar']; $sql = $PageBar_cate['sql']; $total_cate = $PageBar_cate['total']; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); while (list($fcsn, $title, $passwd, $show_mode, $cover) = $xoopsDB->fetchRow($result)) { //無觀看權限則略過 if (!in_array($fcsn, $ok_cat)) { continue; } $url = "pda.php"; $rel = "rel='external'"; $cover_pic = empty($cover) ? "images/folder_picture.png" : XOOPS_URL . "/uploads/tadgallery/{$cover}"; if (empty($passwd) or $passwd == $_SESSION['tadgallery'][$fcsn]) { //不需密碼的分類 $data .= mk_gallery_border_m($rel, "{$url}?csn={$fcsn}", $cover_pic, $title); } else { //有密碼的分類 $data .= mk_gallery_border_m("", "#", $cover_pic, $title, true, $fcsn); } } } //找出分類下所有相片 $sql = "select * from " . $xoopsDB->prefix("tad_gallery") . " where csn='{$csn}' order by photo_sort , post_date"; //getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項); $PageBar = getPageBar_mobile($sql, $xoopsModuleConfig['thumbnail_number'], 10); $bar = $PageBar['bar']; $sql = $PageBar['sql']; $total = $PageBar['total']; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); while (list($sn, $db_csn, $title, $description, $filename, $size, $type, $width, $height, $dir, $uid, $post_date, $counter, $exif) = $xoopsDB->fetchRow($result)) { $data .= "<li class='nofolder'><a href='" . tadgallery::get_pic_url($dir, $sn, $filename, "m") . "' rel='external'><img src='" . tadgallery::get_pic_url($dir, $sn, $filename, "s") . "' alt='{$title}' title='{$title}'></a></li>\n\t"; } $main = "\n <ul class='gallery' style='margin-top:10px;'>\n {$data}\n </ul>\n <p style='clear:both;'></p>"; if ($total > $total_cate) { $main .= "\n <div style='clear:both;text-align:center;padding:8px;' class='navigation'><div data-role='controlgroup' data-type='horizontal'>{$bar}</div></div>"; } else { $main .= "\n <div style='clear:both;text-align:center;padding:8px;' class='navigation'><div data-role='controlgroup' data-type='horizontal'>{$bar_cate}</div></div>"; } return $main; }
function tad_gallery_cate_form($csn = "") { global $xoopsDB, $xoopsModuleConfig, $cate_show_mode_array, $xoopsTpl; include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php"; $xoopsTpl->assign('now_op', 'tad_gallery_cate_form'); //抓取預設值 if (!empty($csn)) { $DBV = tadgallery::get_tad_gallery_cate($csn); } else { $DBV = array(); } $span = $_SESSION['bootstrap'] == '3' ? 'form-control' : 'span12'; //預設值設定 $csn = !isset($DBV['csn']) ? $csn : $DBV['csn']; $of_csn = !isset($DBV['of_csn']) ? "" : $DBV['of_csn']; $title = !isset($DBV['title']) ? "" : $DBV['title']; $enable_group = !isset($DBV['enable_group']) ? "" : explode(",", $DBV['enable_group']); $enable_upload_group = !isset($DBV['enable_upload_group']) ? array('1') : explode(",", $DBV['enable_upload_group']); $sort = !isset($DBV['sort']) ? auto_get_csn_sort() : $DBV['sort']; $passwd = !isset($DBV['passwd']) ? "" : $DBV['passwd']; $mode = !isset($DBV['mode']) ? "" : $DBV['mode']; $show_mode = !isset($DBV['show_mode']) ? $xoopsModuleConfig['index_mode'] : $DBV['show_mode']; $cover = !isset($DBV['cover']) ? "" : $DBV['cover']; $op = empty($csn) ? "insert_tad_gallery_cate" : "update_tad_gallery_cate"; $xoopsTpl->assign('csn', $csn); $xoopsTpl->assign('of_csn', $of_csn); $of_csn_def = ""; if ($of_csn) { $of_cate = tadgallery::get_tad_gallery_cate($of_csn); $of_csn_def = $of_cate['title']; } $xoopsTpl->assign('of_csn_def', $of_csn_def); $xoopsTpl->assign('title', $title); $xoopsTpl->assign('sort', $sort); $xoopsTpl->assign('passwd', $passwd); $xoopsTpl->assign('mode', $mode); $xoopsTpl->assign('show_mode', $show_mode); $xoopsTpl->assign('cover', $cover); $xoopsTpl->assign('op', $op); $cover_select = get_cover($csn, $cover); //$xoopsTpl->assign('cate_select', $cate_select); $xoopsTpl->assign('cover_select', $cover_select); //可見群組 $SelectGroup_name = new XoopsFormSelectGroup("", "enable_group", false, $enable_group, 4, true); $SelectGroup_name->addOption("", _MA_TADGAL_ALL_OK, false); $SelectGroup_name->setExtra("class='{$span}'"); $enable_group = $SelectGroup_name->render(); $xoopsTpl->assign('enable_group', $enable_group); //可上傳群組 $SelectGroup_name = new XoopsFormSelectGroup("", "enable_upload_group", false, $enable_upload_group, 4, true); //$SelectGroup_name->addOption("", _MA_TADGAL_ALL_OK, false); $SelectGroup_name->setExtra("class='{$span}'"); $enable_upload_group = $SelectGroup_name->render(); $xoopsTpl->assign('enable_upload_group', $enable_upload_group); $cate_show_option = ""; foreach ($cate_show_mode_array as $key => $value) { $selected = $show_mode == $key ? "selected='selected'" : ""; $cate_show_option .= "<option value='{$key}' {$selected}>{$value}</option>"; } $xoopsTpl->assign('cate_show_option', $cate_show_option); $cover_default = !empty($cover) ? XOOPS_URL . "/uploads/tadgallery/{$cover}" : "../images/folder_picture.png"; $xoopsTpl->assign('cover_default', $cover_default); $path = get_tadgallery_cate_path($csn, false); $patharr = array_keys($path); $i = 0; foreach ($patharr as $k => $of_csn) { $j = $k + 1; $path_arr[$i]['of_csn'] = $of_csn; $path_arr[$i]['def_csn'] = $patharr[$j]; $i++; } $xoopsTpl->assign('path_arr', $path_arr); }