PHP shelter_ad::getInfoList Examples

Example #1

File: index_promotion.php Project: TiMoChao/lc_ad_first

if (is_object($objWebInit)) {
    if (!isset($objshelter_ad)) {
        include_once __WEB_ROOT . "/shelter_ad/class/shelter_ad.class.php";
        include_once __WEB_ROOT . "/shelter_ad/config/var.inc.php";
        $objshelter_ad = new shelter_ad();
        $objshelter_ad->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objshelter_ad->db = $objWebInit->db;
        } else {
            $objshelter_ad->db();
        }
    }
    $arrCommendshelter_ad = array();
    $intMax = $objshelter_ad->getRecordsG($objshelter_ad->tablename2, 'where pass=1 and recommendflag = 1');
    if ($intMax < 1) {
        $intMax = $objshelter_ad->getRecordsG($objshelter_ad->tablename2, 'where pass=1 and recommendflag = 0');
        if ($intMax > 10) {
            $intMax -= 10;
        }
        $arrCommendshelter_ad = $objshelter_ad->getInfoList('where pass=1 and recommendflag = 0', ' order by submit_date desc', rand(0, $intMax), 10);
    } else {
        if ($intMax > 10) {
            $intMax -= 10;
        }
        $arrCommendshelter_ad = $objshelter_ad->getInfoList('where pass=1 and recommendflag = 1', ' order by submit_date desc', rand(0, $intMax), 10);
    }
    unset($intMax);
    unset($arrCommendshelter_ad['COUNT_ROWS']);
    // 输出到模板
    $arrMOutput["smarty_assign"]['arrCommendshelter_ad'] = $arrCommendshelter_ad;
}

Example #2

File: modifyinfo.php Project: TiMoChao/lc_ad_first

if ($arrInfo['user_id'] != $_SESSION['user_id']) {
    check::AlertExit("错误：此信息不是您发布的，您无权修改!", -1);
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (empty($_POST['type_id']) || empty($_POST['title']) || empty($_POST['intro'])) {
        check::AlertExit("错误：有必填选项没填!", -1);
    }
    $arrTemp = explode('|', $_POST['type_id']);
    $_POST['type_id'] = $arrTemp[0];
    $_POST['type_roue_id'] = $arrTemp[1];
    if ($_POST['title'] != '') {
        $_POST['title_md5'] = md5($_POST['title']);
    }
    //判断文章信息
    if ($_POST['title_md5'] != $arrInfo['title_md5']) {
        $arrTemp = $objWebInit->getInfoList("where title_md5='{$_POST['title_md5']}' and user_id = '{$_SESSION['user_id']}' and type_id='{$_POST['type_id']}'", "", 0, 1);
        if ($arrTemp['COUNT_ROWS'] != 0) {
            check::AlertExit("错误：相同的信息请不要重复发布！需要刷新排列的话，请使用列表下方“提前”选项！", -1);
        }
    }
    //还原图片数组
    $_POST['photo'] = array();
    if (!empty($_POST['savephoto'])) {
        foreach ($_POST['savephoto'] as $key => $val) {
            $arrTemp = array();
            $arrTemp['photo'] = $val;
            if (!empty($_POST['photo_narrate' . $key])) {
                $arrTemp['photo_narrate'] = $_POST['photo_narrate' . $key];
            }
            $_POST['photo'][$key] = $arrTemp;
        }

Example #3

File: relative.php Project: TiMoChao/lc_ad_first

if (is_object($objWebInit)) {
    if (!isset($objshelter_ad)) {
        include_once __WEB_ROOT . "/shelter_ad/class/shelter_ad.class.php";
        include_once __WEB_ROOT . "/shelter_ad/config/var.inc.php";
        $objshelter_ad = new shelter_ad();
        $objshelter_ad->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objshelter_ad->db = $objWebInit->db;
        } else {
            $objshelter_ad->db();
        }
    }
    if (isset($arrInfo['tag']) && !empty($arrInfo['tag'])) {
        $arrTag = explode(',', $arrInfo['tag']);
        $where = array();
        foreach ($arrTag as $strTag) {
            $where[] = "'%" . $strTag . "%'";
        }
        //echo $arrInfo['id'];
        //print_r($where);
        $strWhere = implode(" || ", $where);
        $strWhere = 'where (tag like ' . $strWhere . ')';
    }
    //echo $strWhere;
    $arrRelative = array();
    $arrRelative = $objshelter_ad->getInfoList($strWhere . " and pass=1 and id!=" . $arrInfo['id'], " ORDER BY clicktimes DESC,submit_date DESC,recommendflag DESC,clicktimes DESC", 0, 5, true);
    unset($arrRelative['COUNT_ROWS']);
    //print_r($arrRelative);
    // 输出到模板
    $arrMOutput["smarty_assign"]['arrRelative'] = $arrRelative;
}

Example #4

File: search.php Project: TiMoChao/lc_ad_first

        }
        $_SESSION['arrWhere'] = $arrWhere;
        $_SESSION['strKeywords'] = $strKeywords;
    }
    $arrLink[] = 'keywords=' . urlencode($strKeywords);
} else {
    if (empty($_REQUEST['keywords']) && $isGo) {
        check::AlertExit("错误：关键词必须填写!", -1);
    } else {
        $arrWhere = $_SESSION['arrWhere'];
        $strKeywords = $_SESSION['strKeywords'];
    }
}
$strWhere = implode(' AND ', $arrWhere);
$strWhere = 'where ' . $strWhere;
$arrInfoList = $objWebInit->getInfoList($strWhere, '  ORDER BY topflag DESC,submit_date DESC', ($intPage - 1) * $arrGPage['page_size'], $arrGPage['page_size']);
$intRows = $arrInfoList['COUNT_ROWS'];
unset($arrInfoList['COUNT_ROWS']);
//翻页跳转link
$strPage = $objWebInit->makeInfoListPage($intRows, $strLink, $link_type = $arrGWeb['URL_static']);
// 输出到模板
$arrMOutput["smarty_assign"]['FileCallPath'] = $arrGPic['FileCallPath'];
$arrMOutput["smarty_assign"]['arrInfoList'] = $arrInfoList;
$arrMOutput["smarty_assign"]['strPage'] = $strPage;
$arrMOutput["smarty_assign"]['page'] = $intPage;
$arrMOutput["smarty_assign"]['arrMType'] = $arrMType;
$arrMOutput["smarty_assign"]['strKeywords'] = $strKeywords;
$arrMOutput["smarty_assign"]['strSearchTitle'] = $strKeywords . "搜索结果";
$arrMOutput['smarty_assign']['Title'] = $strKeywords . '搜索结果 - ' . $arrGWeb['name'];
$arrMOutput['smarty_assign']['Description'] = $strKeywords . '搜索结果 - ' . $arrGWeb['name'];
$arrMOutput['smarty_assign']['Keywords'] = $strKeywords . '搜索结果 - ' . $arrGWeb['name'];

Example #5

File: index.inc.php Project: TiMoChao/lc_ad_first

 */
require_once 'config/config.inc.php';
require_once "class/shelter_ad.class.php";
$objWebInit = new shelter_ad();
//数据库连接参数
$objWebInit->setDBG($arrGPdoDB);
//smarty参数
$objWebInit->arrGSmarty = $arrGSmarty;
//翻页参数
$objWebInit->arrGPage = $arrGPage;
$objWebInit->db();
if (!is_array($arrMType) || empty($arrMType)) {
    $arrMType = $objWebInit->getTypeList();
    $arrMType = $objWebInit->formatTypeList(0, $arrMType);
}
foreach ($arrMType as $k => $v) {
    $arrTopshelter_ad[$k] = array();
    if (is_array($v)) {
        $arrTopshelter_ad[$k]['type_title'] = $v['type_title'];
        $arrTopshelter_ad[$k]['type_id'] = $v['type_id'];
    } else {
        $arrTopshelter_ad[$k]['type_title'] = $v;
        $arrTopshelter_ad[$k]['type_id'] = $k;
    }
    $arrTopshelter_ad[$k]['datas'] = $objWebInit->getInfoList("where pass=1 and type_id=" . $arrTopshelter_ad[$k]['type_id'], "  ORDER BY recommendflag DESC,clicktimes DESC,submit_date DESC", 0, 12, true, '', false);
}
// 输出到模板
$arrMOutput["smarty_assign"]['arrTopshelter_ad'] = $arrTopshelter_ad;
$arrMOutput["smarty_assign"]['arrMType'] = $arrMType;
$arrMOutput["smarty_assign"]['MAIN'] = $arrGSmarty['main_dir'] . 'index.html';
$objWebInit->output($arrMOutput);

Example #6

File: top_index.php Project: TiMoChao/lc_ad_first

 * @copyright	(c) 2006 by bizeway.com
 * @version		$Id$
 * @package		ArthurXF
 * @subpackage	shelter_ad
 */
if (is_object($objWebInit)) {
    if (!isset($objshelter_ad)) {
        include_once __WEB_ROOT . "/shelter_ad/class/shelter_ad.class.php";
        include_once __WEB_ROOT . "/shelter_ad/config/var.inc.php";
        $objshelter_ad = new shelter_ad();
        $objshelter_ad->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objshelter_ad->db = $objWebInit->db;
        } else {
            $objshelter_ad->db();
        }
    }
    $arrTopshelter_ad1 = array();
    $arrTopshelter_ad1[0] = $objshelter_ad->getInfoList("where type_id=1 and pass=1", "  ORDER BY recommendflag DESC,submit_date DESC", 0, 1);
    unset($arrTopshelter_ad1[0]['COUNT_ROWS']);
    $arrTopshelter_ad1[1] = $objshelter_ad->getInfoList("where type_id=2 and pass=1", "  ORDER BY recommendflag DESC,submit_date DESC", 0, 10);
    unset($arrTopshelter_ad1[1]['COUNT_ROWS']);
    $arrTopshelter_ad1[2] = $objshelter_ad->getInfoList("where type_id=3 and pass=1", "  ORDER BY recommendflag DESC,submit_date DESC", 0, 10);
    unset($arrTopshelter_ad1[2]['COUNT_ROWS']);
    $arrTopshelter_ad1[3] = $objshelter_ad->getInfoList("where type_id=4 and pass=1", "  ORDER BY recommendflag DESC,submit_date DESC", 0, 10);
    unset($arrTopshelter_ad1[3]['COUNT_ROWS']);
    $arrTopshelter_ad1['FileCallPath'] = $arrGPic['FileCallPath'];
    //print_r($arrTopshelter_ad1);
    // 输出到模板
    $arrMOutput["smarty_assign"]['arrTopshelter_ad1'] = $arrTopshelter_ad1;
}

Example #7

File: newest.php Project: TiMoChao/lc_ad_first

<?php

/**
 * 最新新闻 列表文件
 *
 * @author		Arthur(ArthurXF@gmail.com)
 * @copyright	(c) 2006 by bizeway.com
 * @version		$Id$
 * @package		ArthurXF
 * @subpackage	shelter_ad
 */
if (is_object($objWebInit)) {
    if (!isset($objshelter_ad)) {
        include_once __WEB_ROOT . "/shelter_ad/class/shelter_ad.class.php";
        include_once __WEB_ROOT . "/shelter_ad/config/var.inc.php";
        $objshelter_ad = new shelter_ad();
        $objshelter_ad->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objshelter_ad->db = $objWebInit->db;
        } else {
            $objshelter_ad->db();
        }
    }
    $arrNewest = array();
    $arrNewest = $objshelter_ad->getInfoList("where pass=1", " ORDER BY clicktimes DESC,submit_date DESC,recommendflag DESC,clicktimes DESC", 0, 5, true);
    unset($arrNewest['COUNT_ROWS']);
    //print_r($arrNewest);
    // 输出到模板
    $arrMOutput["smarty_assign"]['arrNewest'] = $arrNewest;
}

Example #8

File: index.php Project: TiMoChao/lc_ad_first

        if (is_numeric($strKeywords)) {
            $arrWhere[] = "id = '" . $strKeywords . "'";
        }
    } else {
        $arrWhere[] = "title LIKE '%" . $_GET['title'] . "%'";
    }
    $arrLink[] = 'title=' . $_GET['title'];
}
$strWhere = implode(' AND ', $arrWhere);
if (!empty($strWhere)) {
    $strWhere = ' WHERE ' . $strWhere;
}
if (!isset($_GET['page']) || $_GET['page'] == '') {
    $_GET['page'] = $arrGPage['page'];
}
$arrData = $objWebInit->getInfoList($strWhere, ' ORDER BY submit_date DESC', ($_GET['page'] - 1) * $arrGPage['page_size'], $arrGPage['page_size'], true);
if ($arrData == "") {
    $arrData = null;
}
//翻页跳转link
$strLink = '';
if (!empty($arrLink)) {
    $strLink = implode('&', $arrLink);
}
$strPage = $objWebInit->makeInfoListPage($arrData['COUNT_ROWS'], $strLink);
unset($arrData['COUNT_ROWS']);
// 取类别标题
if (is_array($arrMType) && !empty($arrMType)) {
    foreach ($arrData as $k => $data) {
        foreach ($arrMType as $k1 => $type) {
            if ($data['type_id'] == $k1) {