苹果cms一键创建影视分类文件解放双手

前言：

苹果CMS程序是一套采用PHP+MYSQL环境下运行的完善而强大的快速建站系统。 经过近多年的开发经验和技术积累，苹果CMS程序已逐步走向成熟，在易用性和功能上已经成为同行中的佼佼者。 如果新手刚刚开始接触苹果cms，视频分类绑定自己动手会非常麻烦 如果选择创建分类进行采集，嫌手工添加及捆绑分类麻烦。

文章源自百科情报站-https://www.bkqbz.com/2400.html

可以下载文件下面代码保存为bang：然后修改文件中的采集接口地址，然后上传到网站根目录下并访问执行(访问地址为:网站域名/bang.php)，即可解封双手一键自动绑定！文章源自百科情报站-https://www.bkqbz.com/2400.html

<?php
/*
一、如果采用本站提供的视频分类和采集接口，以下代码除分类的地区和年代可做修改外，其他均不要做任何改动。
二、重要说明说三遍：
除填入采集接口、分类的地区和年代外，其他均不要做任何改动，以免出错！！！
除填入采集接口、分类的地区和年代外，其他均不要做任何改动，以免出错！！！
除填入采集接口、分类的地区和年代外，其他均不要做任何改动，以免出错！！！
*/

declare (strict_types = 1);
const BF = __DIR__ . '/application/extra/bind.php';

//此处填入采集接口的名称和地址，如:接口名#接口地址
$jiekouarray=[
    "接口1#接口地址",
    "接口2#接口地址",
    ];
//此处填入分类的地区和年代
$diqu='中国大陆,中国香港,中国台湾,美国,韩国,日本,法国,英国,德国,泰国,印度,其他';
$niandai='2022,2021,2020,2019,2018,2017,2016,2015,2014,2013,2012,2011,2010,2009,2008,2007,2006,2005,2004,2003,2002,2001,2000';

//以下代码不要做任何修改，以免出错！
$bind = include BF;
$type=[
    "电影"=>["动作","喜剧","爱情","科幻","剧情","悬疑","惊悚","恐怖","犯罪","谍战","冒险","奇幻","灾难","战争","动画","歌舞","历史","传记","纪录","其他"],
    "电视剧"=>["武侠","喜剧","爱情","剧情","青春","悬疑","科幻","军事","警匪","谍战","奇幻","偶像","年代","乡村","都市","家庭","古装","历史","神话","其他"],
    "综艺"=>["脱口秀","真人秀","搞笑","访谈","生活","晚会","美食","游戏","亲子","旅游","文化","体育","时尚","纪实","益智","演艺","歌舞","音乐","播报","其他"],
    "动漫"=>["热血","格斗","恋爱","美少女","校园","搞笑","LOLI","神魔","机战","科幻","真人","青春","魔法","神话","冒险","运动","竞技","童话","亲子","教育","励志","剧情","社会","历史","战争","其他"],
    "纪录"=>["人物","军事","历史","自然","探险","科技","文化","刑侦","社会","旅游","其他"]
   ];
   
db::exec('DELETE FROM mac_type');
$dalei='{\"class\":\"\",\"area\":\"'.$diqu.'\",\"lang\":\"\",\"year\":\"'.$niandai.'\",\"star\":\"\",\"director\":\"\",\"state\":\"\",\"version\":\"\"}';
foreach (array_keys($type) as $k => $type_name) {
	$type_id= $k + 1;
	$sql = 'INSERT INTO mac_type (`type_id`,`type_name`,`type_en`,`type_pid`, `type_tpl`,`type_tpl_list`,`type_tpl_detail`,`type_tpl_play`,`type_tpl_down`,`type_extend`) VALUES ('.$type_id.',"'.$type_name.'","'.Pinyin::get($type_name).'",0,"type.html","show.html","detail.html","play.html","down.html","'.$dalei.'" );';
	db::exec($sql);
	foreach ($type[$type_name] as $id => $name) {
		$tid= $type_id . sprintf("%02d", $id + 1);
		$sql= 'INSERT INTO mac_type (`type_id`,`type_name`,`type_en`,`type_pid`, `type_tpl`,`type_tpl_list`,`type_tpl_detail`,`type_tpl_play`,`type_tpl_down`,`type_extend`) VALUES ( '. $tid.',"'.$name.'","'.Pinyin::get($name).'",'.$type_id.',"type.html","show.html","detail.html","play.html","down.html","'.$dalei.'");';
		db::exec($sql);
	}
}
$arr = [];
foreach ($jiekouarray as $k => $jiekou) {
    $name=explode('#',$jiekou)[0];
    $api=explode('#',$jiekou)[1];
    $sql = 'DELETE FROM mac_collect WHERE collect_url="'.$api.'"';
    db::exec($sql);
    if(substr_count($api,'xml')){
        $sql = 'INSERT INTO mac_collect (`collect_name`,`collect_url`,`collect_type`,`collect_mid`, `collect_filter`,`collect_opt`) VALUES ( "'.$name .'","'.$api.'",1,1,0,0);';
    }else{
        $sql = 'INSERT INTO mac_collect (`collect_name`,`collect_url`,`collect_type`,`collect_mid`, `collect_filter`,`collect_opt`) VALUES ( "'.$name .'","'.$api.'",2,1,0,0);';
    }
    db::exec($sql);
    $arr1=[];
    foreach (array_keys($type) as $k1 => $type_name) {
        $type_id= $k1 + 1;
        $arr1[md5($api).'_' . $type_id] = $type_id;
        foreach ($type[$type_name] as $id => $name) {
            $tid= $type_id . sprintf("%02d", $id + 1);
		    $arr1[md5($api).'_' . $tid] = (int) $tid;
        }
    }
    $arr=array_merge($arr, $arr1);
}
$bind=[];
$bind = array_merge($bind, $arr);
$con  = var_export($bind, true);
file_put_contents(BF, "<?php\nreturn $con;");
echo "自动建立并绑定分类成功";

class db
{
    protected static $pdo = null;
    public static function exec($sql = '')
    {
        if (!isset(self::$pdo)) {
            $c         = include __DIR__.'/application/database.php';
            self::$pdo = new PDO("mysql:host={$c['hostname']};dbname={$c['database']};port={$c['hostport']}", $c['username'], $c['password'], [\PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC]);
        }
        try {
            return self::$pdo->exec($sql);
        } catch (Throwable $e) {
            print_r($e);
        }
    }
}
class Pinyin
{
    private static $pinyins = null;

    public function __construct() {

    }

    public static function get($str, $ret_format = 'all', $placeholder = '', $allow_chars = '/[a-zA-Z\d ]/') {

        if (null === self::$pinyins) {
            $data = file_get_contents('./static/data/pinyin.dat');

            $rows = explode('|', $data);

            self::$pinyins = array();
            foreach($rows as $v) {
                list($py, $vals) = explode(':', $v);
                $chars = explode(',', $vals);

                foreach ($chars as $char) {
                    self::$pinyins[$char] = $py;
                }
            }
        }

        $str = trim($str);
        $len = mb_strlen($str, 'UTF-8');
        $rs = '';
        for ($i = 0; $i < $len; $i++) {
            $chr = mb_substr($str, $i, 1, 'UTF-8');
            $asc = ord($chr);
            if ($asc < 0x80) { // 0-127
                if (preg_match($allow_chars, $chr)) { // 用参数控制正则
                    $rs .= $chr; // 0-9 a-z A-Z 空格
                } else { // 其他字符用填充符代替
                    $rs .= $placeholder;
                }
            } else { // 128-255
                if (isset(self::$pinyins[$chr])) {
                    $rs .= 'first' === $ret_format ? self::$pinyins[$chr][0] : (self::$pinyins[$chr] . '');
                } else {
                    $rs .= $placeholder;
                }
            }

            if ('one' === $ret_format && '' !== $rs) {
                return $rs[0];
            }
        }
        $rs = str_replace([' ','+','/','\\','|','\'','?','%','#','&','=','!','(',')',';',':','<','>'],'',$rs);
        return $rs;
    }

}
?>