category_get_wheresql PHP Code Examples

Example #1

0

Show file

File: 1_diy_portal_list.tpl.php Project: renning/html

<?php

if (!defined('IN_DISCUZ')) {
    exit('Access Denied');
}
hookscriptoutput('list');
include template('common/header');
?>
<!--[name]!portalcategory_listtplname![/name]--><?php 
$list = array();
$wheresql = category_get_wheresql($cat);
$list = category_get_list($cat, $wheresql, $page);
?>
<div id="pt" class="bm cl">
<div class="z">
<a href="./" class="nvhm" title="首页"><?php 
echo $_G['setting']['bbname'];
?>
</a> <em>&rsaquo;</em>
<a href="<?php 
echo $_G['setting']['navs']['1']['filename'];
?>
"><?php 
echo $_G['setting']['navs']['1']['navname'];
?>
</a> <em>&rsaquo;</em><?php 
if (is_array($cat['ups'])) {
    foreach ($cat['ups'] as $value) {
        ?>
 <a href="<?php 
        echo $portalcategory[$value['catid']]['caturl'];

Example #2

0

Show file

File: 2_diy_portal_list_2.tpl.php Project: noikiy/ejia

<?php if(!defined('IN_DISCUZ')) exit('Access Denied'); hookscriptoutput('list_2');
block_get('85,86,87,88,89');?><?php include template('common/header'); $list = array();?><?php $wheresql = category_get_wheresql($cat);?><?php $list = category_get_list($cat, $wheresql, $page);?><link rel="stylesheet" type="text/css" href="template/xinglan_c3/common/index.css">

<style id="diy_style" type="text/css"></style>
<div class="wp">

<div id="pt" class="bm cl">
<div class="z">
<a href="./" class="nvhm" title="首页"><?php echo $_G['setting']['bbname'];?></a> <a href="portal.php">&nbsp;首页</a>
<em>&rsaquo;</em><?php if(is_array($cat['ups'])) foreach($cat['ups'] as $value) { ?> <a href="<?php echo $portalcategory[$value['catid']]['caturl'];?>"><?php echo $value['catname'];?></a><em>&rsaquo;</em><?php } ?>
<?php echo $cat['catname'];?> 
</div>

</div>
<!--[diy=diyab]--><div id="diyab" class="area"><div id="frameSUWef7" class="frame move-span cl frame-1"><div id="frameSUWef7_left" class="column frame-1-c"><div id="frameSUWef7_left_temp" class="move-span temp"></div><?php block_display('85');?></div></div></div><!--[/diy]-->
</div><?php echo adshow("text/wp a_t");?><div id="ct" class="ct2 wp cl">
<div class="mn"><?php echo adshow("articlelist/mbm hm/1");?><?php echo adshow("articlelist/mbm hm/2");?><div class="bm2">
<div class="tttop">
<div class="bm_h cl">
<?php if($_G['setting']['rssstatus'] && !$_GET['archiveid']) { ?><a href="portal.php?mod=rss&amp;catid=<?php echo $cat['catid'];?>" class="y xi2 rss" target="_blank" title="RSS">我要订阅</a><?php } if(($_G['group']['allowpostarticle'] || $_G['group']['allowmanagearticle'] || $categoryperm[$catid]['allowmanage'] || $categoryperm[$catid]['allowpublish']) && empty($cat['disallowpublish'])) { ?>
<a href="portal.php?mod=portalcp&amp;ac=article&amp;catid=<?php echo $cat['catid'];?>" class="y xi2 addnew">发布文章</a>
<?php } ?>
<h1 class="xs2"><?php echo $cat['catname'];?>列表</h1>
</div>
<?php if($cat['subs']) { ?>
<div class="bm_c bbda">
下级分类：&nbsp;&nbsp;<?php $i = 1;?><?php if(is_array($cat['subs'])) foreach($cat['subs'] as $value) { if($i != 1) { ?><span class="pipe">|</span><?php } ?><a href="<?php echo $portalcategory[$value['catid']]['caturl'];?>" class="xi2"><?php echo $value['catname'];?></a><?php $i--;?><?php } ?>
</div>
<?php } ?>
</div>

Example #3

0

Show file

File: 2_diy_touch_portal_list.tpl.php Project: noikiy/ejia

    <li><a href="home.php?mod=space&amp;do=notice"<?php if($_G['member']['newprompt']) { ?> class="xi1"<?php } ?>><?php if($_G['member']['newprompt']) { ?>提醒(<?php echo $_G['member']['newprompt'];?>)<?php } else { ?>提醒<?php } ?></a></li>
<?php if($_G['setting']['version'] != 'X2') { if(helper_access::check_module('feed')) { ?><li><a href="home.php"><?php echo m_lang('mfeed'); ?></a></li><?php } if(helper_access::check_module('doing')) { ?><li><a href="home.php?mod=space&amp;do=doing"><?php echo m_lang('mdoing'); ?></a></li><?php } if(helper_access::check_module('album')) { ?><li><a href="home.php?mod=space&amp;do=album"><?php echo m_lang('photo'); ?></a></li><?php } } ?>
    <li><a href="home.php?mod=space&amp;uid=<?php echo $_G['uid'];?>&amp;do=thread&amp;view=me">我的帖子</a></li>
    <li><a href="home.php?mod=space&amp;uid=<?php echo $_G['uid'];?>&amp;do=favorite&amp;view=me&amp;type=forum"><?php echo m_lang('favorite'); ?></a></li>    
    <li><a href="home.php?mod=space&amp;uid=<?php echo $_G['uid'];?>&amp;do=profile"><?php echo m_lang('profile'); ?></a></li>
    <li style=" border-bottom:none;"><a href="member.php?mod=logging&amp;action=logout&amp;formhash=<?php echo FORMHASH;?>">退出</a></li>
</ul>
<?php } elseif($_G['connectguest']) { ?>
<ul class="p_umu" id="h_umu_menu" style="display:none;"><em></em>
    <li style=" border-bottom:none;"><a href="member.php?mod=logging&amp;action=logout&amp;formhash=<?php echo FORMHASH;?>">退出</a></li>
</ul>
<?php } ?>
</header>

<div class="wp">
<?php echo $imenus;?><?php $list = array();?><?php $wheresql = category_get_wheresql($cat);?><?php $list = category_get_list($cat, $wheresql, $page);?><div class="ct">
<div class="pt"><a href="forum.php" id="sybgbg"><?php echo m_lang('home'); ?></a> <em> &gt; </em> <?php if(is_array($cat['ups'])) foreach($cat['ups'] as $value) { ?><a href="<?php echo getportalcategoryurl($value['catid']); ?>&mobile=2"><?php echo $value['catname'];?></a> <em> &gt; </em> <?php } ?><?php echo $cat['catname'];?></div>

   <?php if($cat['subs'] || $cat['others']) { ?>
   <div class="nmt">
   <?php if($cat['subs']) { ?>
   <a href="javascript:;" id="cats" class="a z f_pst" onclick="dbox('cats','cats');">下级分类</a>
   <?php } ?>   
   <?php if($cat['others']) { ?>  
   <a href="javascript:;" id="cato" class="a z f_pst" onclick="dbox('cato','cato');" >相关分类</a>
   <?php } ?>
   <?php if(!$cat['subs'] && $cat['others']) { ?><a href="javascript:history.back();" class="rb"><?php echo m_lang('back'); ?></a><?php } ?>
   
   </div>
   <?php } ?>            
            <?php if($cat['subs']) { ?>

Example #4

0

Show file

File: myportal.php Project: Mushan3420/BigApp-PHP7

 function output()
 {
     global $_G;
     if (true === BigAppConf::$debug) {
         $_G['trace'][] = __CLASS__ . '::' . __FUNCTION__;
     }
     $variable['data'] = "";
     $formatRec = array('aid', 'catid', 'title', 'summary', 'pic', 'dateline', 'catname', 'content', 'url', 'contents');
     if ('list' == $_GET['mod']) {
         $variable['data'] = array();
         $_G['catid'] = $catid = max(0, intval($_GET['catid']));
         $page = max(1, intval($_GET['page']));
         $cat = category_remake($catid);
         if (!empty($cat)) {
             $wheresql = category_get_wheresql($cat);
             $list = category_get_list($cat, $wheresql, $page);
             if (!empty($list)) {
                 $articleList = array();
                 foreach ($list['list'] as $key => $value) {
                     if (!empty($value['pic'])) {
                         $tmp = parse_url($value['pic']);
                         if (!isset($tmp['scheme'])) {
                             $url = ApiUtils::getDzRoot() . $value['pic'];
                         } else {
                             $url = str_replace('source/plugin/mobile/', '', $attach);
                             $url = str_replace('source/plugin/mobile/', '', $url);
                         }
                         $list['list'][$key]['pic'] = $url;
                     }
                     //暂时不支持存在url 跳转的文章
                     if (isset($value['url']) && !empty($value['url'])) {
                         unset($list['list'][$key]);
                         continue;
                     }
                     foreach ($value as $k => $v) {
                         if (!in_array($k, $formatRec)) {
                             unset($list['list'][$key][$k]);
                         }
                     }
                     $articleList[] = $list['list'][$key];
                 }
                 $variable['data'] = $articleList;
                 $variable['perpage'] = $cat['perpage'];
                 $variable['needmore'] = count($articleList) < $cat['perpage'] ? '0' : '1';
             }
         }
     } else {
         $aid = empty($_GET['aid']) ? 0 : intval($_GET['aid']);
         $article = C::t('portal_article_title')->fetch($aid);
         if (!empty($article)) {
             $content = C::t('portal_article_content')->fetch_all($aid);
             if (is_array($content)) {
                 foreach ($content as $i => $c) {
                     if ($i != 0) {
                         $content[0]['content'] .= $c['content'];
                     }
                 }
             }
             $article = array_merge($content[0], $article);
             foreach ($article as $k => $v) {
                 if (!in_array($k, $formatRec)) {
                     unset($article[$k]);
                 }
             }
             $article['content'] = self::filterContent($article['content']);
             $article['dateline'] = date('Y-m-d H:i', $article['dateline']);
             $article['share_url'] = rtrim(ApiUtils::getDzRoot(), '/') . '/portal.php?mod=view&aid=' . $aid;
             $variable['data'] = $article;
         }
     }
     bigapp_core::result(bigapp_core::variable($variable));
 }

Example #5

0

Show file

File: 2_diy_portal_list_3.tpl.php Project: xiao2ww/Bjwlkjc

      <?php echo $subnav;?>
    </ul>
    <?php } ?> 
    <?php } ?> 
    <?php } ?> 
  </div>

  <?php echo adshow("subnavbanner/a_mu");?> 
</div>

<?php if(!empty($_G['setting']['pluginhooks']['global_header'])) echo $_G['setting']['pluginhooks']['global_header'];?> 
<?php } ?>
</div>


<div id="wp" class="wp"><?php $list = array();?><?php $wheresql = category_get_wheresql($cat);?><?php $list = category_get_list($cat, $wheresql, $page);?><div id="pt" class="bm cl">
<div class="z">
<a href="./" class="nvhm" title="首页"><?php echo $_G['setting']['bbname'];?></a> <em>&rsaquo;</em>
<a href="<?php echo $_G['setting']['navs']['1']['filename'];?>"><?php echo $_G['setting']['navs']['1']['navname'];?></a> <em>&rsaquo;</em><?php if(is_array($cat['ups'])) foreach($cat['ups'] as $value) { ?> <a href="<?php echo $portalcategory[$value['catid']]['caturl'];?>"><?php echo $value['catname'];?></a><em>&rsaquo;</em><?php } ?>
<?php echo $cat['catname'];?>
</div>
</div><?php echo adshow("text/wp a_t");?><style id="diy_style" type="text/css"></style>
<div class="wp">
<!--[diy=diy1]--><div id="diy1" class="area"></div><!--[/diy]-->
</div>


<!--
<div id="ct" class="ct2 wp cl">
-->
<div id="ct" class="wp cl vk_simple vk_simple_list vk_tab">

PHP category_get_wheresql Examples