where("ip='$ip'")->getField("id");
}
//封装返回的数据
/**
* 视频列表相关 视频列表
*首页视频列表
* @param type [zuixin 最新,remen 热门,tuijian 推荐,resou 热搜,]
* @param page [页数]
* @return $type 消息类型
*/
public function video_info_list()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Contr-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jiben = $_POST['jiben_type'];
switch ($jiben) {
case 'zuixin':
$jiben_sql = 'id desc';
break;
case 'remen':
$jiben_sql = 'views desc';
break;
case 'guankan':
$jiben_sql = 'views desc';
break;
case 'dianzan':
$jiben_sql = 'thumbs_up desc';
break;
case 'shichang':
$jiben_sql = 'time_chuo desc';
break;
default:
$jiben_sql = '';
break;
}
switch ($type) {
//热门
case 'remen':
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("time='$jintian'")->LIMIT($page_one, $one_size)->order('rand()')->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("time='$jintian'")->count();
$data['code'] = '200';
//推荐1
case 'tuijian':
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='tuijian' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='tuijian' and time='$jintian'")->count();
$data['code'] = '200';
break;
//动漫1列表
case 'Anime':
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='Anime' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='Anime' and time='$jintian'")->count();
$data['code'] = '200';
break;
//热搜亚洲1
case 'Asian':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='Asian' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='Asian' and time='$jintian'")->count();
$data['code'] = '200';
break;
//黑料
case 'HL':
$seven_day = $_POST['seven_day'];
if ($seven_day) {
$seven_time_chuo = time() - (30 * 24 * 3600);
$id_list = M('video_list_test')->where("uploader='黑料吃瓜' and add_time>$seven_time_chuo")->order("id desc")->LIMIT($page_one, $one_size)->select();
$data['all_num'] = M('video_list_test')->where("uploader='黑料吃瓜' and add_time>$seven_time_chuo")->order("id desc")->count();
$data['code'] = '200';
}else{
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='黑料吃瓜' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='黑料吃瓜' and time='$jintian'")->count();
$data['code'] = '200';
}
break;
//海角
case 'WB':
$seven_day = $_POST['seven_day'];
if ($seven_day){
$seven_time_chuo = time()-(30*24*3600);
$id_list = M('video_list_test')->where("uploader='网曝门' and add_time>$seven_time_chuo")->order("id desc")->LIMIT($page_one, $one_size)->select();
$data['all_num'] =M('video_list_test')->where("uploader='网曝门' and add_time>$seven_time_chuo")->order("id desc")->count();
$data['code'] = '200';
}else{
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='网曝门' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='网曝门' and time='$jintian'")->count();
$data['code'] = '200';
}
break;
//反差0021
case 'FC':
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='素人反差' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='素人反差' and time='$jintian'")->count();
$data['code'] = '200';
break;
//乱伦
case 'luanlun':
$seven_day = $_POST['seven_day'];
if ($seven_day){
$seven_time_chuo = time()-(7*24*3600);
$id_list = M('video_list_test')->where("site='HJ' and add_time>$seven_time_chuo")->order("id desc")->LIMIT($page_one, $one_size)->select();
$data['all_num'] =M('video_list_test')->where("site='HJ' and add_time>$seven_time_chuo")->order("id desc")->count();
$data['code'] = '200';
}else{
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='海角乱伦' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='海角乱伦' and time='$jintian'")->count();
$data['code'] = '200';
}
break;
//麻豆
case 'madou':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='麻豆传媒' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='麻豆传媒' and time='$jintian'")->count();
$data['code'] = '200';
break;
// 探花
case 'tanhua':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='探花大神' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='探花大神' and time='$jintian'")->count();
$data['code'] = '200';
break;
// 换脸
case 'huanlian':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='明星换脸' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='明星换脸' and time='$jintian'")->count();
$data['code'] = '200';
break;
// 猎奇
case 'lieqi':
//lq_type:孕妇:yunfu
// 猎奇:lieqi
// 人兽:renshou
// 人妖:renyao
// 同性:tongxing
// 伪娘:weiniang
//
//孕妇做爱
//另类猎奇
//人兽动物
//性感人妖
//同性做爱
//超级大胆
//
$lq_type = $_POST['lq_type'];
switch ($lq_type) {
case 'yunfu':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='孕妇做爱' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='孕妇做爱' and time='$jintian'")->count();
$data['code'] = '200';break;
case 'lieqi':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='另类猎奇' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='另类猎奇' and time='$jintian'")->count();
$data['code'] = '200';
break;
case 'renshou':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='人兽动物' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='人兽动物' and time='$jintian'")->count();
$data['code'] = '200';
break;
case 'renyao':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='性感人妖' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='性感人妖' and time='$jintian'")->count();
$data['code'] = '200';
break;
case 'tongxing':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='同性做爱' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='同性做爱' and time='$jintian'")->count();
$data['code'] = '200';
break;
case 'weiniang':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='超级大胆' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='超级大胆' and time='$jintian'")->count();
$data['code'] = '200';
break;
default:
echo "type error";
}
$data['code'] = '200';
break;
// 美乳
case 'meiru':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='雪白美乳' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='雪白美乳' and time='$jintian'")->count();
$data['code'] = '200';
break;
// SM
case 'sm':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='SM调教' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='SM调教' and time='$jintian'")->count();
$data['code'] = '200';
break;
// 玩偶
case 'wanou':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='玩偶姐姐' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='玩偶姐姐' and time='$jintian'")->count();
$data['code'] = '200';
break;
// av解说
case 'avjieshuo':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='AV解说' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='AV解说' and time='$jintian'")->count();
$data['code'] = '200';
break;
// 粉嫩少女
case 'luoli':
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='粉嫩少女' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='粉嫩少女' and time='$jintian'")->count();
$data['code'] = '200';
break;
default:
echo "type error";
}
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 6;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
/**
* 推荐第一页
* @param $templateid []
* @return $type 消息类型
*/
public function tuijian_one_page($uid, $page_one)
{
$yn_look_video = M('views_video_type_jilu_test')->where("uid=$uid")->field("video_type_str")->select();
if ($yn_look_video) {
$yan_feng_view_type_str = $yn_look_video[0]['video_type_str'];
$feng_view_type_str = explode(',', $yan_feng_view_type_str);
$new_type_num = array_count_values($feng_view_type_str);
print_r($new_type_num);
arsort($new_type_num);
// var_dump($new_type_num);
$sql_charu = "";
$new_type_num = array_slice($new_type_num, 0, 5);
echo PHP_EOL.'----------';
print_r($new_type_num);
foreach ($new_type_num as $key => $value) {
$type_name = $key;
$xianzhi_one = " or type like '%,$type_name,%' or china_type like '%,$type_name,%' ";
$sql_charu .= $xianzhi_one;
}
$video_list = M('video_list_test')->where("id=0 $sql_charu")->LIMIT($page_one, 60)->order('rand()')->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 5;
$qishi_num = 0;
$data_list_number = count($video_list);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
$charu_array = array($adv_list[$key]);
array_splice($video_list, $jia_num, 0, $charu_array);
$jia_num += 6;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $video_list;
echo json_encode($data);
} else {
$video_list = M('video_list_test')->order("thumbs_up desc")->LIMIT($page_one, 60)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 5;
$qishi_num = 0;
$data_list_number = count($video_list);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
$charu_array = array($adv_list[$key]);
array_splice($video_list, $jia_num, 0, $charu_array);
$jia_num += 6;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $video_list;
echo json_encode($data);
}
}
protected function returnData()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$data['status'] = '0';
$data['code'] = '202';//未携带参数,请求失败
$data['message'] = 'error';
echo json_encode($data);
}
/**
* 视频详情
* @param video_id [video_id]
* @return $type 消息类型
* 1.2更新 进入详情后 将用户观看视频次数加1
*/
public function video_detail()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$LNG = $_POST['LNG'];
$uid = $_POST['uid'];
$video_id = $_POST['video_id'];
$site = $_POST['site'];
$now_url = $_POST['video_detail'];
//判断用户是否是异常用户
//判读是否登录
if ($uid == '0' or $uid == '' or $uid=='undefined') {
$data['message'] = 'error';
echo json_encode($data);
die();
}
$huiyuan_time =M("user_info")->where("id=$uid")->getField("vip_over_time");
$now_time = time();
if ($site!='欧美' and $site!='动漫' and $site!='亚洲'){
// 生成一个随机数,可以使用 rand() 或 mt_rand()
$random_jinbi = rand(0,1);
// $random_jinbi = 1;
switch ($random_jinbi) {
case '0':
$heiliao_list = M("heiliao_haijiao_books")->where("id=$video_id")->field("hj_video_url,head_img")->select()[0];
$video_url = $heiliao_list['hj_video_url'];
$video_head_img= $heiliao_list['head_img'];
break;
case '1':
$heiliao_list = M("heiliao_haijiao_books")->where("id=$video_id")->field("hj_video_url_two,head_img")->select()[0];
$video_url = $heiliao_list['hj_video_url_two'];
$video_head_img= $heiliao_list['head_img'];
break;
default:
$heiliao_list = M("heiliao_haijiao_books")->where("id=$video_id")->field("hj_video_url,head_img")->select()[0];
$video_url = $heiliao_list['hj_video_url'];
$video_head_img= $heiliao_list['head_img'];
}
}else{
// 生成一个随机数,可以使用 rand() 或 mt_rand()
$randomNumber = rand(0, 2);
$randomNumber = rand(0, 2);
// $randomNumber = 2;
switch ($randomNumber) {
case 0:
$video_url = M("video_info_test")->where("video_id=$video_id")->getField("video_url");
break;
case 1:
$video_url = M("video_info_test")->where("video_id=$video_id")->getField("video_url_two");
break;
case 2:
$video_url = M("video_info_test")->where("video_id=$video_id")->getField("video_url_three");
break;
default:
$video_url = M("video_info_test")->where("video_id=$video_id")->getField("video_url");
}
$now_views = M("user_info")->where("id=$uid")->getField("views_num");
//如果用户当日观看超过1000则关进小黑屋 异常处理
$yn_black = M("black_box")->where("uid=$uid")->getField("id");
if ($yn_black) {
$data['message'] = 'error_403';
echo json_encode($data);
die();
}
if ($now_views==3000 or $now_views>3000) {
$data['message'] = 'error_403';
$userip = $this->get_bb_ip();
$ttime = time();
$ddate = date("Y-m-d H:i:s",$ttime);
$last_login_list['time'] = $ttime;
$last_login_list['time_date'] = $ddate;
$last_login_list['uid'] = $uid;
$last_login_list['ip'] = $userip;
M("black_box")->add($last_login_list);
echo json_encode($data);
die();
}
}
switch ($LNG) {
case 'CN':
$now_zan_num_list = M('video_list_test')->where("id=$video_id")->Field("views,thumbs_up,china_type,title,top_img")->select();
$video_type_list_map = $now_zan_num_list[0]['china_type'];
break;
case 'EN':
$now_zan_num_list = M('video_list_test')->where("id=$video_id")->Field("views,thumbs_up,type,title,top_img")->select();
$video_type_list_map = $now_zan_num_list[0]['type'];
break;
default:
$now_zan_num_list = M('video_list_test')->where("id=$video_id")->Field("views,thumbs_up,china_type,title,top_img")->select();
$video_type_list_map = $now_zan_num_list[0]['china_type'];
break;
}
$dianzan_num =$now_zan_num_list[0]['thumbs_up'];
$guankan_num = $now_zan_num_list[0]['views'];
$video_name = $now_zan_num_list[0]['title'];
$video_head_img = $now_zan_num_list[0]['top_img'];
$vidoe_tpe_list = explode(',', $video_type_list_map);
$vidoe_tpe_list = array_filter($vidoe_tpe_list);
$vidoe_tpe_list = array_values($vidoe_tpe_list);
//1.2更新处
//查询当前用户观看次数并加1更新
$now_views = M("user_info")->where("id=$uid")->getField("views_num");
$free_list = M('free_video_zb_test')->where("id=1")->field("free_video,url")->select();
$free_id = $free_list[0]['free_video'];
$new_views_num['views_num'] = $now_views + 1;
$tttime = time();
$ddate = date("Y-m-d H:i:s",$tttime);
$new_views_num['last_login_time'] =$tttime;
$new_views_num['last_login_date'] =$ddate;
$new_views_num['beizhu'] = $now_url;
M("user_info")->where("id=$uid")->save($new_views_num);
$adv_list = M("slgj_advert_list")->where("type='片头广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
$adv_list_two = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
M('video_list_test')->where("id=$video_id")->setInc('v_really',1);
$data['adv'] = $adv_list[0];
$data['adv_two'] = $adv_list_two[0];
$data['head_img'] = $video_head_img;
$data['data'] = $video_url;
$data['views'] = $guankan_num;
$data['thumbs_up'] = $dianzan_num;
$data['video_name'] = $video_name;
$data['type_list'] = $vidoe_tpe_list;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
/**
* 图片列表相关
* @param $templateid []
* @return $type 消息类型
*/
public function imgs_info_list()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$type = $_POST['type'];
$page = $_POST['page'];
$page_one = ($page - 1) * 36;
switch ($type) {
//最新
case 'zuixin':
$video_list = M("imgs_list")->LIMIT($page_one, 36)->order("id desc")->select();
$data['all_num'] = M("imgs_list")->count();
$data['code'] = '200';
$data['data'] = $video_list;
echo json_encode($data);
break;
//热门
case 'remen':
$video_list = M("imgs_list")->LIMIT($page_one, 36)->order("views desc")->select();
$data['all_num'] = M("imgs_list")->count();
$data['code'] = '200';
$data['data'] = $video_list;
echo json_encode($data);
break;
//推荐
case 'tuijian':
$video_list = M("imgs_list")->LIMIT($page_one, 36)->order("thumbs_up desc")->select();
$data['all_num'] = M("imgs_list")->count();
$data['code'] = '200';
$data['data'] = $video_list;
echo json_encode($data);
break;
//热搜
case 'resou':
break;
default:
echo "type error";
}
} else {
echo $this->returnData();
}
}
/**
* 图片详情
* @param imgs_id [图片id]
* @return $type 消息类型
*/
public function img_detail()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$img_id = $_POST['imgs_id'];
$img_list_str = M("imgs_info")->where("imgs_id=$img_id")->getField("imgs_url");
$now_zan_num = M('video_list_test')->where("id=$img_id")->getField("views");
$now_zan_num += 1;
$new_zan['views'] = $now_zan_num;
$yn_save = M("imgs_list")->where("id=$img_id")->save($new_zan);
$img_list = explode(',', $img_list_str);
$data['data'] = $img_list;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
/**
* 发送评论
* @param type [需要评论的类型 video or img]
* @param cid [这个视频或者图片的 id]
* @param uid [用户id]
* @param username [用户名称]
* @param content [评论内容]
* @return $type 消息类型
*/
public function add_comments()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$type = $_POST['type'];
$cid = $_POST['cid'];
$uid = $_POST['uid'];
$username = M("user_info")->where("id=$uid")->getField("name");;
$comment_list['time'] = time();
$comment_list['content'] = $_POST['content'];
$comment_list['uid'] = $uid;
$comment_list['username'] = $username;
switch ($type) {
case 'video':
$comment_list['video_id'] = $cid;
$yn_add = M("video_comments")->add($comment_list);
if ($yn_add) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'error';
echo json_encode($data);
}
break;
case 'img':
$comment_list['img_id'] = $cid;
$yn_add = M("img_comments")->add($comment_list);
if ($yn_add) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'error';
echo json_encode($data);
}
break;
default:
echo "type error";
}
} else {
echo $this->returnData();
}
}
/**
* 评论列表
* @param type [video or img]
* @param cid [这个视频或者图片的 id]
* @return $type 消息类型
*/
public function comments_list()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$type = $_POST['type'];
$cid = $_POST['cid'];
switch ($type) {
case 'video':
$yn_se = M("video_comments")->where("video_id=$cid")->field("id,content,time,username,uid,time")->select();
if ($yn_se) {
$data['message'] = 'ok';
$data['data'] = $yn_se;
echo json_encode($data);
} else {
$data['message'] = 'ok';
$data['data'] = [];
echo json_encode($data);
}
break;
case 'img':
$yn_se = M("img_comment")->where("img_id=$cid")->field("id,content,time,username,uid,time")->select();
if ($yn_se) {
$data['message'] = 'ok';
$data['data'] = $yn_se;
echo json_encode($data);
} else {
$data['message'] = 'ok';
$data['data'] = [];
echo json_encode($data);
}
break;
default:
echo "type error";
}
} else {
echo $this->returnData();
}
}
/**
* 点赞视频或图片
* @param uid [用户id]
* @param type [img or video]
* @param cid [这个视频或者图片的 id]
* @return $type 消息类型
*/
public function dianzan_img_video()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$type = $_POST['type'];
$cid = $_POST['cid'];
switch ($type) {
case 'video':
$now_zan_num = M('video_list_test')->where("id=$cid")->getField("thumbs_up");
$now_zan_num += 1;
$new_zan['thumbs_up'] = $now_zan_num;
$yn_save = M('video_list_test')->where("id=$cid")->save($new_zan);
//添加到点赞表
$dianzan_list['uid'] = $uid;
$dianzan_list['v_id'] = $cid;
if ($uid != 0) {
M("dianzan_video")->add($dianzan_list);
}
if ($yn_save) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'erroe';
echo json_encode($data);
}
break;
case 'img':
$now_zan_num = M("imgs_list")->where("id=$cid")->getField("thumbs_up");
$now_zan_num += 1;
$new_zan['thumbs_up'] = $now_zan_num;
$yn_save = M("imgs_list")->where("id=$cid")->save($new_zan);
if ($yn_save) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'erroe';
echo json_encode($data);
}
break;
default:
echo "type error";
}
} else {
echo $this->returnData();
}
}
/**
* 取消点赞
* @param uid [用户id]
* @param v_id [视频id]
* @return $type 消息类型
*/
public function close_video_up()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$v_id = $_POST['v_id'];
$now_zan_num = M('video_list_test')->where("id=$v_id")->getField("thumbs_up");
$now_zan_num -= 1;
$new_zan['thumbs_up'] = $now_zan_num;
$yn_sa = M('video_list_test')->where("id=$v_id")->save($new_zan);
$yn_de = M("dianzan_video")->where("uid=$uid and v_id=$v_id")->delete();
if ($yn_sa and $yn_de) {
$data['message'] = 'close_yes';
echo json_encode($data);
} else {
$data['message'] = 'close_no';
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 判断是否点赞过
* @param uid [用户id]
* @param v_id [视频id]
* @return $type 消息类型
*/
public function yn_me_up()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$v_id = $_POST['v_id'];
$yn_you = M("dianzan_video")->where("uid=$uid and v_id=$v_id")->getField("id");
if ($yn_you) {
$data['message'] = 'yes_like';
echo json_encode($data);
} else {
$data['message'] = 'no_like';
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function shuzu_last_key()
{
$a = [
'one' => 1,
'two' => 2,
'three' => 3
];
// 拆分数组
$chunkArr = array_chunk($a, 2, true);
// 输出原数组
// var_dump($a);
// 输出拆分后的数组
print_r($chunkArr);
// var_dump($chunkArr);
}
/**
* 更新图片分类数量
* @param $templateid []
* @return $type 消息类型
*/
public function save_img_type_num()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$imgs_type_num = array();
$video_list = M("imgs_list")->field('type')->select();
foreach ($video_list as $key => $value) {
$type2 = $value['type'];
$type2_list = explode(',', $type2);
$type2_list = array_unique($type2_list);
foreach ($type2_list as $key1 => $value1) {
# code...
array_push($imgs_type_num, $value1);
}
}
$count = array_count_values($imgs_type_num);
var_dump($count);
foreach ($count as $key11 => $value11) {
if ($key11 == '') {
continue;
}
$yn_type = M("imgs_type_num")->where("name='$key11'")->getField("name");
if ($yn_type) {
// if ($yn_type == $value11) {
// echo PHP_EOL . '已有不动';
// var_dump($value11);
// continue;
// }
echo PHP_EOL . '已有更新';
$add_video_type['num'] = $value11;
M("imgs_type_num")->where("name='$key11'")->save($add_video_type);
} else {
echo PHP_EOL . '没有新增';
$add_video_type['name'] = $key11;
$add_video_type['num'] = $value11;
M("imgs_type_num")->add($add_video_type);
}
}
}
/**
* 标签详情
* @param type_name [标签名称]
* @param type [img or video]
* @param page [页数]
*
* @return $type 消息类型
*/
public function select_type_detail()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$LNG = $_POST['LNG'];
$type_name = $_POST['type_name'];
$type = $_POST['type'];
$page = $_POST['page'];
$page_one = ($page - 1) * 30;
$jiben = $_POST['jiben_type'];
switch ($jiben) {
case 'zuixin':
$jiben_sql = 'id desc';
break;
case 'remen':
$jiben_sql = 'views desc';
break;
case 'guankan':
$jiben_sql = 'views desc';
break;
case 'dianzan':
$jiben_sql = 'thumbs_up desc';
break;
case 'shichang':
$jiben_sql = 'time_chuo desc';
break;
default:
$jiben_sql = '';
break;
}
switch ($type) {
case 'video':
switch ($LNG) {
case 'EN':
if ($jiben_sql=='') {
$wula = M('video_list_test')->where("type like '%,$type_name,%' and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'")->LIMIT($page_one, 60)->order('rand()')->select();
}else{
$wula = M('video_list_test')->where("type like '%,$type_name,%' and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'")->LIMIT($page_one, 60)->order("$jiben_sql")->select();
}
break;
case 'CN':
if ($jiben_sql=='') {
$wula = M('video_list_test')->where("china_type like '%,$type_name,%' and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'")->LIMIT($page_one, 60)->order('rand()')->select();
}else{
$wula = M('video_list_test')->where("china_type like '%,$type_name,%' and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'")->LIMIT($page_one, 60)->order("$jiben_sql")->select();
}
break;
default:
echo "type error";
}
$data['all_num'] = M('video_list_test')->where("type like '%,$type_name,%' and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'")->count();
$data['message'] = 'ok';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 5;
$qishi_num = 0;
$data_list_number = count($wula);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
$charu_array = array($adv_list[$key]);
array_splice($wula, $jia_num, 0, $charu_array);
$jia_num += 6;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $wula;
echo json_encode($data);
break;
case 'img':
$wula = M("imgs_list")->where("type like '%,$type_name,%'")->LIMIT($page_one, 36)->select();
$data['all_num'] = M("imgs_list")->where("type like '%,$type_name%,'")->count();
$data['message'] = 'ok';
$data['data'] = $wula;
echo json_encode($data);
break;
case 'novel':
$wula = M("novel_list")->where("type like '%,$type_name,%'")->LIMIT($page_one, 36)->select();
$data['all_num'] = count($wula);
$data['message'] = 'ok';
$data['data'] = $wula;
echo json_encode($data);
break;
default:
echo "type error";
}
} else {
echo $this->returnData();
}
}
/**
* 推荐视频
* (2+2+1)
* @return $type 消息类型
*/
public function tuijian_shipin()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$oumei_list =M('video_list_test')->where("type not LIKE '%,Asian,%' and type not LIKE '%,Anime,%'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader")->order("rand()")->LIMIT(8)->select();
$yazhou_list =M('video_list_test')->where("type LIKE '%,Asian,%'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader")->order("rand()")->LIMIT(8)->select();
$dongman_list = M('video_list_test')->where("type LIKE '%,Anime,%'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader")->order("rand()")->LIMIT(4)->select();
$tuijian_video_list = array($oumei_list[0], $oumei_list[1], $yazhou_list[0], $yazhou_list[1], $dongman_list[0],
$oumei_list[2],$oumei_list[3],$yazhou_list[2],$yazhou_list[3],$dongman_list[1],
$oumei_list[4],$oumei_list[5],$yazhou_list[4],$yazhou_list[5],$dongman_list[2],
$oumei_list[6],$oumei_list[7],$yazhou_list[6],$yazhou_list[7],$dongman_list[3],);
if (!empty($tuijian_video_list)) {
$data['message'] = 'ok';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 0;
$qishi_num = 0;
$data_list_number = count($tuijian_video_list);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
if ($qishi_num==0) {
$jia_num += 5;
$qishi_num += 1;
}else{
$jia_num += 6;
$qishi_num += 1;
}
$charu_array = array($adv_list[$key]);
array_splice($tuijian_video_list, $jia_num, 0, $charu_array);
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $tuijian_video_list;
echo json_encode($data);
} else {
$data['message'] = 'null';
$data['data'] = [];
echo json_encode($data);
}
}
/**
* 推荐视频
* (2+2+1)
* @return $type 消息类型
*/
public function tuijian_shipin_video_detali()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$oumei_list =M('video_list_test')->where("type not LIKE '%,Asian,%' and type not LIKE '%,Anime,%'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader,site")->order("rand()")->LIMIT(8)->select();
$yazhou_list =M('video_list_test')->where("type LIKE '%,Asian,%'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader,site")->order("rand()")->LIMIT(8)->select();
$dongman_list = M('video_list_test')->where("type LIKE '%,Anime,%'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader,site")->order("rand()")->LIMIT(4)->select();
$tuijian_video_list = array($oumei_list[0], $oumei_list[1], $yazhou_list[0], $yazhou_list[1], $dongman_list[0],
$oumei_list[2],$oumei_list[3],$yazhou_list[2],$yazhou_list[3],$dongman_list[1],
$oumei_list[4],$oumei_list[5],$yazhou_list[4],$yazhou_list[5],$dongman_list[2],
$oumei_list[6],$oumei_list[7],$yazhou_list[6],$yazhou_list[7],$dongman_list[3],);
if (!empty($tuijian_video_list)) {
$data['message'] = 'ok';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 0;
$qishi_num = 0;
$data_list_number = count($tuijian_video_list);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
$charu_array = array($adv_list[$key]);
array_splice($tuijian_video_list, $jia_num, 0, $charu_array);
$jia_num += 6;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $tuijian_video_list;
echo json_encode($data);
} else {
$data['message'] = 'null';
$data['data'] = [];
echo json_encode($data);
}
}
/**
* 黑料海角反差视频详情推荐
* @param $templateid []
* @return $type 消息类型
*/
public function new_tuijian_shipin_video_detali(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$video_type = $_POST['type'];
switch ($video_type) {
case 'HL':
$tuijian_video_list = M('video_list_test')->where("site='HL'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader,site")->order("rand()")->LIMIT(36)->select();
break;
case 'WB':
$tuijian_video_list = M('video_list_test')->where("site='WB'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader,site")->order("rand()")->LIMIT(36)->select();
break;
case 'FC':
$tuijian_video_list = M('video_list_test')->where("site='FC'")->field("id,title,top_img,views,thumbs_up,favorite,time_chuo,uploader,site,coins")->order("rand()")->LIMIT(8)->select();
break;
default:
echo "type error";
}
$tttime = time();
$ddate = date("Y-m-d H:i:s",$tttime);
$new_views_num['last_login_time'] =$tttime;
$new_views_num['last_login_date'] =$ddate;
M("user_info")->where("id=$uid")->save($new_views_num);
if (!empty($tuijian_video_list)) {
$data['message'] = 'ok';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 0;
$qishi_num = 0;
$data_list_number = count($tuijian_video_list);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array($adv_list[$key]);
array_splice($tuijian_video_list, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $tuijian_video_list;
echo json_encode($data);
} else {
$data['message'] = 'null';
$data['data'] = [];
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 收藏列表
* @param uid [用户id]
* @param type [img or video]
* @return $type 消息类型
*/
public function shoucang_list()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$page = $_POST['page'];
$page_one = ($page - 1) * 30;
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid")->count();
//插入sql语句 的限制条件
$new_array = array();
//视频
$duifang_id_list = M("video_shoucang")->where("uid=$uid")->order("id desc")->LIMIT($page_one, 30)->select();
//插入sql语句 的限制条件
foreach ($duifang_id_list as $key => $value) {
# code...
$duifang_id = $value['vid'];
$m_type = $value['video_type'];
$duifang_id_list[$key]['uploader'] = $m_type;
if ($m_type=='色情小说'){
$duifang_id_list = M("novel_list")->where("id=$duifang_id")->select()[0];
array_push($new_array, $duifang_id_list);
}else{
$duifang_id_list = M('video_list_test')->where("id=$duifang_id")->select()[0];
array_push($new_array, $duifang_id_list);
}
}
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$c = $new_array;
$jia_num = 5;
$qishi_num = 0;
$data_list_number = count($c);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($c, $jia_num, 0, $charu_array);
$jia_num += 6;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['message'] = 'ok';
$data['data'] = $c;
$data['all_num'] = $duifang_id_list_num;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
/**
* 取消收藏
* @param $templateid []
* @return $type 消息类型
*/
public function quxiao_shoucang()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$cid = $_POST['cid'];
$uid = $_POST['uid'];
$type = $_POST['type'];
switch ($type) {
case 'video':
$yn_de = M("video_shoucang")->where("uid='$uid' and vid='$cid'")->delete();
$now_zan_num = M('video_list_test')->where("id=$cid")->getField("favorite");
$now_zan_num -= 1;
$new_zan['favorite'] = $now_zan_num;
$yn_save = M('video_list_test')->where("id=$cid")->save($new_zan);
break;
default:
echo "type error";
}
if ($yn_de) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'erroe';
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 同步视频标签
* @param $templateid []
* @return $type 消息类型
*/
public function tongbu_video_biaoqian()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$video_list = M('video_list_test')->Field("title,type")->select();
foreach ($video_list as $key => $value) {
# code...
$video_type = $value['type'];
if (!$video_type == '') {
echo PHP_EOL . '已有';
continue;
}
$name_video = $value['title'];
$wula = M("slgj_videos")->where("title='$name_video'")->Field("type,type1,type2")->select();
$type_str = '';
foreach ($wula as $key => $value) {
# code...
$type = $value['type'];
$type1 = $value['type1'];
$type2 = $value['type2'];
$type_str = ",$type,$type1,$type2,";
$video_listp['type'] = $type_str;
M('video_list_test')->where("title='$name_video'")->save($video_listp);
}
}
}
/**
* 同步图片标签
* @param $templateid []
* @return $type 消息类型
*/
public function tongbu_img_biaoqian()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$video_list = M("imgs_list")->where("id>16380")->Field("title,type")->select();
foreach ($video_list as $key => $value) {
# code...
$img_type = $value['type'];
if (!$img_type == '') {
echo PHP_EOL . '已有';
continue;
}
$name_video = $value['title'];
$wula = M("slgj_imgs")->where("title='$name_video'")->Field("type,type1,type2")->select();
$type_str = '';
foreach ($wula as $key => $value) {
# code...
$type = $value['type'];
$type1 = $value['type1'];
$type2 = $value['type2'];
$type_str = ",$type,$type1,$type2,";
$video_listp['type'] = $type_str;
M("imgs_list")->where("title='$name_video'")->save($video_listp);
echo PHP_EOL . M("imgs_list")->_sql();
}
}
}
/**
* 筛选
* id desc
* views desc
* thumbs_up desc
* $video_list = M('video_list_test')->order("thumbs_up desc")->LIMIT($page_one, 36)->select();
* @param page [页数]
* @param jiben_type [最新zuixin,热门remen,观看次数guankan,点赞数量dianzan,时长shichang]
* @param time_kaishi [时间筛选开始;例: 0就传0 10就传600 ]
* @param time_jeishu [时间筛选结束;例: 30就传1800 40+就传99999999 ]
* @param leixing_shaixuan [类型名称 ]
* @return $type 消息类型
*/
public function video_shaixuan()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$LNG = $_POST['LNG'];
$page = $_POST['page'];
$page_one = ($page - 1) * 36;
//基本 最新,热门,观看次数,点赞数量,时长
$jiben = $_POST['jiben_type'];
switch ($jiben) {
case 'zuixin':
$jiben_sql = 'id desc';
break;
case 'remen':
$jiben_sql = 'views desc';
break;
case 'guankan':
$jiben_sql = 'views desc';
break;
case 'dianzan':
$jiben_sql = 'thumbs_up desc';
break;
case 'shichang':
$jiben_sql = 'time_chuo desc';
break;
default:
$jiben_sql = '';
break;
}
//时长筛选
$time_kaishi = $_POST['time_kaishi'];
$time_shaixuan = $_POST['time_jeishu'];
if ($time_kaishi == '') {
$time_kaishi = 0;
$time_shaixuan = 9999999999999;
}
//包含类型
$leixing_type = $_POST['leixing_shaixuan'];
if ($leixing_type != '') {
switch ($LNG) {
case '':
$sql_qujian = "(time_chuo between $time_kaishi and $time_shaixuan) and (type like '%,$leixing_type,%') and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'";
break;
case '':
$sql_qujian = "(time_chuo between $time_kaishi and $time_shaixuan) and (china_type like '%,$leixing_type,%') and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'";
break;
default:
echo "type error";
}
} else {
// echo PHP_EOL.'kkkk';
$sql_qujian = "(time_chuo between $time_kaishi and $time_shaixuan) and top_img!='https://www.bibidd.com/bibidd_testtest/A.jpg'";
}
$video_list = M('video_list_test')->where($sql_qujian)->order("$jiben_sql")->LIMIT($page_one, 36)->select();
$data['all_num'] = M('video_list_test')->where($sql_qujian)->order("$jiben_sql")->count();
$data['code'] = '200';
$data['data'] = $video_list;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
//再次排序
/**
* 搜索
* @param $templateid []
* @return $type 消息类型
*/
public function sousuo_img_video()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$type_name = $_POST['type_name'];
$type = $_POST['type'];
$page = $_POST['page'];
$uid = $_POST['uid'];
$page_one = ($page - 1) * 36;
if (!empty($_POST)) {
switch ($type) {
case 'video':
$wula = M('video_list_test')->where("title like '%$type_name%' ")->Field("id,title,top_img,views,thumbs_up,favorite,time_chuo")->LIMIT($page_one, 36)->select();
$data['all_num'] = M('video_list_test')->where("title like '%$type_name%' ")->count();
break;
case 'img':
$wula = M("imgs_list")->where("title like '%$type_name%' ")->Field("id,title,top_img,views,thumbs_up,favorite,time_chuo")->LIMIT($page_one, 36)->select();
$data['all_num'] = M("imgs_list")->where("title like '%$type_name%'")->count();
break;
default:
echo "type error";
}
// 添加到用户搜索历史表
// $sousuo_jilu['uid'] =$uid ;
// $sousuo_jilu['title'] =$type_name ;
// M("sousuo_jilu")->add($sousuo_jilu);
if ($wula) {
$data['message'] = 'ok';
$data['data'] = $wula;
echo json_encode($data);
} else {
$data['message'] = 'null';
$data['data'] = array();
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
function list_sort_by($list, $field, $sortby = 'desc')
{
if (is_array($list)) {
$refer = $resultSet = array();
foreach ($list as $i => $data)
$refer[$i] = &$data[$field];
switch ($sortby) {
case 'asc': // 正向排序
asort($refer);
break;
case 'desc':// 逆向排序
arsort($refer);
break;
case 'nat': // 自然排序
natcasesort($refer);
break;
}
foreach ($refer as $key => $val)
$resultSet[] = &$list[$key];
return $resultSet;
}
return false;
}
/**
* 同步视频
* @param $templateid []
* @return $type 消息类型
*/
public function tongbu_vidoe()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
// $select_slgj_video = M("slgj_videos")->where(" (site='P站' and m3u8 like '%slgj688.com/%') or (site='黄色仓库' and m3u8!='')")->Field('title,time2,one_img,m3u8')->select();
// $select_slgj_video = M("slgj_videos")->where("m3u8 like '%.html'")->Field('title,time2,one_img,m3u8')->select();
// $select_slgj_video = M("slgj_videos")->where("video_watch!='' and m3u8 like '%slgj688.com/%' and one_img like '%750_400%' and is_gengxin=''")->Field('title,time2,one_img,m3u8')->select();
// $select_slgj_video = M("slgj_videos")->where("video_watch!='' and m3u8 like '%slgj688.com/%' and one_img like '%750_400%' and is_gengxin='' and type like '%Anime%'")->Field('title,time2,one_img,m3u8')->select();
$select_slgj_video = M("slgj_videos")->where("m3u8 like '%slgj688.com/%' and site!='XVIDEOS'")->Field('title,time2,one_img,m3u8')->select();
print_r(count($select_slgj_video));
foreach ($select_slgj_video as $key => $value) {
//判断 video_list 和 video_info 是否已已有跳过
//标题
$sl_title = $value['title'];
$sl_title = str_replace("'", "", $sl_title);
//视频时长
$video_time = $value['time2'];
$video_time = '00:00';
if ($video_time == '') {
continue;
}
//头图片
$top_img = $value['one_img'];
if ($top_img == '') {
$top_img = 'https://www.bibidd.com/bibidd_testtest/A.jpg';
}
// $top_img = $value['one_img_yun'];
//m3u8
$video_m3u8 = $value['m3u8'];
// $video_m3u8 = $value['video_watch'];
#bibidd
$domain = strstr($sl_title, "'");
if ($domain) {
echo PHP_EOL . $sl_title;
continue;
}
// $where_id1 = sprintf('title="%d"', $sl_title);
// try {
$yn_yiyou = M('video_list_test')->where("title='$sl_title'")->getField("id");
// } catch (Exception $e) {
// echo PHP_EOL . $sl_title;
// continue;
// }
if ($yn_yiyou) {
// echo PHP_EOL . '有了';
} else {
echo PHP_EOL . '没有asdasdasdasd';
//观看点赞(1-999)
$video_list_addp['views'] = rand(200, 9999);
$video_list_addp['thumbs_up'] = rand(50, 9999);
$video_list_addp['title'] = $sl_title;
$video_list_addp['top_img'] = $top_img;
$video_list_addp['video_time'] = $video_time;
$add_list = M('video_list_test')->add($video_list_addp);
$video_info_addp['video_url'] = $video_m3u8;
$video_info_addp['video_id'] = $add_list;
$add_info = M('video_info_test')->add($video_info_addp);
}
}
}
/**
* 同步图片
* @param $templateid []
* @return $type 消息类型
*/
public function tongbu_img()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$select_slgj_video = M("slgj_imgs")->where("title!=''")->Field('title,num,one_img,imgs')->select();
foreach ($select_slgj_video as $key => $value) {
//判断 video_list 和 video_info 是否已已有跳过
//标题
$sl_title = $value['title'];
//图片数量
$img_num = $value['num'];
//头图片
$top_img = $value['one_img'];
//m3u8
$imgs_imgs = $value['imgs'];
// $where_id1 = sprintf('title="%d"', $sl_title);
$domain = strstr($sl_title, "'");
if ($domain) {
echo PHP_EOL . $sl_title;
continue;
}
try {
$yn_yiyou = M("imgs_list")->where("title='$sl_title'")->getField("id");
} catch (Exception $e) {
echo PHP_EOL . $sl_title;
continue;
}
if ($yn_yiyou) {
echo PHP_EOL . '有了';
} else {
echo PHP_EOL . '没有';
$video_list_addp['views'] = rand(1, 999);
$video_list_addp['thumbs_up'] = rand(1, 999);
$video_list_addp['title'] = $sl_title;
$video_list_addp['top_img'] = $top_img;
$video_list_addp['imgs_num'] = $img_num;
$add_list = M("imgs_list")->add($video_list_addp);
$video_info_addp['imgs_url'] = $imgs_imgs;
$video_info_addp['imgs_id'] = $add_list;
$add_info = M("imgs_info")->add($video_info_addp);
}
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function test_zhongwen()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$str = "原字符串:";
$pattern = "/[^\x{4E00}-\x{9FFF}]+/u";
$newStr = preg_replace($pattern, '', $str);
if ($newStr === '') {
echo "字符串中不包含中文
";
} else {
echo "字符串中包含中文
";
}
}
/**
* 首页符合要求视频(封面完好 ,时长20+)
* @param $templateid []
* @return $type 消息类型
*/
public function home_video_good()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$video_list = M('video_list_test')->where("time=")->select();
} else {
echo $this->returnData();
}
}
function randFloat($min, $max)
{
if ($min >= $max) {
throw new \Exception('最大值必须大于最小值', 501);
}
$rand = $min + mt_rand() / mt_getrandmax() * ($max - $min);
return floatval(sprintf('%.1f', $rand));
}
/**
* 所有视频随机(浏览,点赞1-999)
* @param $templateid []
* @return $type 消息类型
*/
public function rangd_suijione()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$user_list = M('video_list_test')->where("id!='' and views=0 and site='FC'")->Field("id")->select();
// $user_list = M("novel_list")->where("id!=''")->Field("id")->select();
// $user_list = M("imgs_list")->where("id!='' and biaoqian_yn=0")->Field("id")->select();
foreach ($user_list as $key => $value) {
echo PHP_EOL . '1';
$iid = $value['id'];
echo PHP_EOL . $iid;
//观看点赞(1-999)
echo PHP_EOL;
$video_list_addp['biaoqian_yn'] = 1;
$video_list_addp['views'] = $this->randFloat(10.1,99);
$video_list_addp['thumbs_up'] = $this->randFloat(3.1, 9);
M('video_list_test')->where("id=$iid")->save($video_list_addp);
// M("novel_list")->where("id=$iid")->save($video_list_addp);
// M("imgs_list")->where("id=$iid")->save($video_list_addp);
}
}
function randFloat11($min = 1, $max = 9) {
$wula = $this->randFloat(10, 99);
echo PHP_EOL.$wula;}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function shijian_zhuanghuan_new()
{
print_r('可恶');
$user_list = M('video_list_test')->where("id!='' and time_chuo=0")->Field("id,video_time")->select();
print_r(count($user_list));
// $user_list = M('video_list_test')->where("id='80970'")->Field("id,video_time")->select();
foreach ($user_list as $key => $value) {
# code...
$id = $value['id'];
print_r($id);
$time = $value['video_time'];
$is_fuhao = strstr($time, ':');
if ($is_fuhao) {
$time_list = explode(':', $time);
$time_list_count = count($time_list);
if ($time_list_count == 2) {
$one = $time_list[0];
$two = $time_list[1];
$time_all = ($one * 60) + $two;
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
} elseif ($time_list_count == 3) {
$one = $time_list[0];
$two = $time_list[1];
$three = $time_list[2];
$time_all = ($one * 3600) + ($two * 60) + $three;
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
}
} else {
//带h
$is_fuhao = strstr($time, 'h');
if ($is_fuhao) {
$time_one = substr($time, 0, 1);
$time_two_mei = substr($time, 4, 9);
$time_two = str_replace("min", '', $time_two_mei);
$time_all = ($time_one * 3600) + ($time_two * 60);
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
} else {
//min的
$time_one = substr($time, 0, 2);
$time_all = ($time_one * 60);
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
}
}
}
}
/**
* 视频转时间
* @param $templateid []
* @return $type 消息类型
*/
public function time_zhuanhuan()
{
print_r('可恶');
$user_list = M('video_list_test')->where("id!='' and time_chuo=0 or time_chuo is null")->Field("id,video_time")->select();
foreach ($user_list as $key => $value) {
# code...
$id = $value['id'];
$time = $value['video_time'];
$is_fuhao = strstr($time, ':');
if ($is_fuhao) {
$time_list = explode(':', $time);
$time_list_count = count($time_list);
if ($time_list_count == 2) {
$one = $time_list[0];
$two = $time_list[1];
$time_all = ($one * 60) + $two;
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
} elseif ($time_list_count == 3) {
$one = $time_list[0];
$two = $time_list[1];
$three = $time_list[2];
$time_all = ($one * 3600) + ($two * 60) + $three;
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
}
} else {
//带h
$is_fuhao = strstr($time, 'h');
if ($is_fuhao) {
$time_one = substr($time, 0, 1);
$time_two_mei = substr($time, 4, 9);
$time_two = str_replace("min", '', $time_two_mei);
$time_all = ($time_one * 3600) + ($time_two * 60);
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
} else {
//min的
$time_one = substr($time, 0, 2);
$time_all = ($time_one * 60);
$time_chuo['time_chuo'] = $time_all;
M('video_list_test')->where("id=$id")->save($time_chuo);
}
}
}
}
/**
* 取出今天 随机的视频 并记录 ip
* @param $templateid []
* @return $type 消息类型
*/
public function load_videos()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$ip = get_client_ip();
$user_list['time'] = time();
$yn_ip_yiyou = M("ip_jilu")->where("ip='$ip'")->getField("id");
if ($yn_ip_yiyou) {
M("ip_jilu")->where("ip='$ip'")->save($user_list);
} else {
$user_list['add_time'] = time();
M("ip_jilu")->add($user_list);
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function all_chinese_type_ec()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$user_list = M("")->where("")->field("name,num")->select();
foreach ($user_list as $key => $value) {
# code...
$str = $value['name'];
$pattern = "/[^\x{4E00}-\x{9FFF}]+/u";
$newStr = preg_replace($pattern, '', $str);
if ($newStr === '') {
echo "字符串中不包含中文
";
} else {
echo "字符串中包含中文
";
}
$user_list[$key] = $value['id'];
}
}
/**
* 搜索历史
* @param uid [用户id]
* @return $type 消息类型
*/
public function search_history()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$sousuo_lishi_list = M("sousuo_jilu")->where("uid=$uid")->field("title,id")->select();
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'yes';
$data['data'] = $sousuo_lishi_list;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
/**
* 删除搜索
* @param $templateid []
* @return $type 消息类型
*/
public function delete_search_history()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$sousuo_id = $_POST['id'];
$yn_shanchu = M("sousuo_jilu")->where("id=$sousuo_id")->delete();
if ($yn_shanchu) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'no';
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 同步视频 第二链接
* @param $templateid []
* @return $type 消息类型
*/
public function tongbu_two_video_url()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$bbvideo_titi = M('video_list_test')->field("title,id")->select();
foreach ($bbvideo_titi as $key => $value) {
# code...
$vtit = $value['title'];
$vid = $value['id'];
$sl_url = M("slgj_videos")->where("title='$vtit'")->getField("video_watch");
$wula_two['video_url_two'] = $sl_url;
$yn_sa = M('video_info_test')->where("video_id=$vid")->save($wula_two);
if ($yn_sa) {
echo PHP_EOL . '修改成功' . $sl_url;
} else {
echo PHP_EOL . '修改失败';
}
}
}
/**
* 将国产内容 同步标签
* @param $templateid []
* @return $type 消息类型
*/
public function update_guochan()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
// SELECT * FROM `bb_slgj_videos` WHERE site='含羞草研究所' and m3u8 like '%slgj688.com/%' and is_gengxin='' and video_watch!=''
$select_slgj_video = M("slgj_videos")->where("site='含羞草研究所' and m3u8 like '%slgj688.com/%'")->Field('title')->order("id desc")->select();
print_r(count($select_slgj_video));
foreach ($select_slgj_video as $key => $value) {
$sl_tit = $value['title'];
$sl_tit = str_replace("'", "", $sl_tit);
$now_type_bb = M('video_list_test')->where("title='$sl_tit' and type not like '%Asian,Chinese%'")->getField("type");
if ($now_type_bb) {
print_r($now_type_bb);
echo PHP_EOL . $now_type_bb;
$new_type = $now_type_bb . ",Asian,Chinese,";
$update_type['type'] = $new_type;
M('video_list_test')->where("title='$sl_tit'")->save($update_type);
} else {
print_r('youle');
}
}
}
/**
* 将当前用户观看的视频类型 记录
* @param $templateid []
* @return $type 消息类型
*/
public function add_user_views()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
if ($uid == 0) {
exit();
}
$video_type = $_POST['video_type'];
//获取当前用户观看视频类型集合,观看视频数量
$now_views_jilu_lsit = M('views_video_type_jilu_test')->where("uid=$uid")->field("views_video_num")->select();
//已有记录更新 没有新增
if ($now_views_jilu_lsit) {
// $now_video_type_str = $now_views_jilu_lsit[0]['video_type_str'];
$now_views_video_num = $now_views_jilu_lsit[0]['views_video_num'];
//将当前用户观看的视频 类型 更新
// $new_video_type_str = $now_video_type_str . ',' . $video_type;
$new_views_video_num = $now_views_video_num + 1;
// $update_views_jilu['video_type_str'] = $new_video_type_str;
$update_views_jilu['views_video_num'] = $new_views_video_num;
$save_yn = M('views_video_type_jilu_test')->where("uid=$uid")->save($update_views_jilu);
if ($save_yn) {
$data['message'] = 'save_ok';
echo json_encode($data);
} else {
$data['message'] = 'save_no';
echo json_encode($data);
}
} else {
$update_views_jilu['uid'] = $uid;
$update_views_jilu['video_type_str'] = "";
$update_views_jilu['views_video_num'] = 1;
$add_yn = M('views_video_type_jilu_test')->add($update_views_jilu);
if ($add_yn) {
$data['message'] = 'add_ok';
echo json_encode($data);
} else {
$data['message'] = 'add_no';
echo json_encode($data);
}
}
} else {
echo $this->returnData();
}
}
//封装返回的数据
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function tuijian_duanhou(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Contr-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$type = $_POST['type'];
$page = $_POST['page'];
$page_one = ($page - 1) * 60;
}
/**
* 同步time2
* @param $templateid []
* @return $type 消息类型
*/
public function tongbushipin_shijian_time()
{
$video_list = M('video_list_test')->where("time_chuo=0")->Field("title")->select();
echo PHP_EOL . M('video_list_test')->_sql();
foreach ($video_list as $key => $value) {
# code...
$name_video = $value['title'];
// $wula = M("slgj_videos")->where("title='$name_video'")->Field("time2")->select();
$ttime = M("slgj_videos")->where("title='$name_video'")->getField("time2");
$update_time['video_time'] = $ttime;
M('video_list_test')->where("title='$name_video'")->save($update_time);
echo PHP_EOL . M('video_list_test')->_sql();
}
}
/**
* 同步预热
* 将预热成功的数据同步到 video_list,video_list_test表中
* @param $templateid []
* @return $type 消息类型
*/
public function yure_tongbu_bibidd()
{
//首先获取所有 预热成功的视频的id
// $yure_yes = M("slgj_videos")->where("yure=1")->field("id")->order("id desc")->select();
$yure_yes = M("slgj_videos")->where("yure=1")->field("id")->order("id asc")->select();
//
foreach ($yure_yes as $key => $value) {
$id = $value['id'];
//查询这个id是否已经更新
$yngengxin_wula = M('video_list_test')->where("sl_id=$id and yure=1")->getField("id");
if ($yngengxin_wula) {
echo PHP_EOL.'过了';
continue;
} else {
$yes_yure['yure'] = 1;
$a = M('video_list_test')->where("sl_id=$id and yure=0")->save($yes_yure);
echo PHP_EOL.'更新';
}
}
}
/**
* 将没有预热的数据进行处理
* @param $templateid []
* @return $type 消息类型
*/
public function no_yure_chuli(){
$select_no_yure = M('video_list_test')->where("yure=0")->field("title,yure,sl_id")->select();
foreach ($select_no_yure as $key => $value) {
$sl_id = $value['sl_id'];
$bb_titile = $value['title'];
$slgj_id_yure = M("slgj_videos")->where("id=$sl_id")->field("title,one_img,yure")->select();
$sl_img = $slgj_id_yure[0]['one_img'];
$sl_yure = $slgj_id_yure[0]['yure'];
$sl_title = $slgj_id_yure[0]['title'];
if ($sl_yure == 0) {
echo PHP_EOL.$sl_yure;
M('video_list_test')->where("sl_id=$sl_id")->delete();
}
}
}
/**
* jiang video_info qu chu mei yong de
* @param $templateid []
* @return $type 消息类型
*/
public function shanchu_video_info_feiwu(){
echo PHP_EOL."你妈死了?";
$info_list = M('video_info_test')->where("video_id!=0")->field("video_id")->select();
foreach ($info_list as $key => $value) {
$info_id = $value['video_id'];
$yn_yiyou = M('video_list_test')->where("id=$info_id")->getField("id");
if ($yn_yiyou){
echo PHP_EOL.$yn_yiyou;
}else{
echo PHP_EOL.'没有';
M('video_info_test')->where("video_id=$info_id")->delete();
// die();
}
}
}
/**
* 将slgj表id 同步到 video_list 表中
* @param $templateid []
* @return $type 消息类型
*/
public function slgj_tongbu_bibidd_id()
{
$video_list_bibidd = M('video_list_test')->where("id!='' and sl_id is null")->field("title")->select();
foreach ($video_list_bibidd as $key => $value) {
$bb_title = $value['title'];
$slgj_id = M("slgj_videos")->where("title='$bb_title'")->getField("id");
$bb_sl_id_list['sl_id'] = $slgj_id;
M('video_list_test')->where("title='$bb_title'")->save($bb_sl_id_list);
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function test_tuiji_dmemo()
{
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='tuijian' and time='$jintian'")->LIMIT(0, 60)->Field('v_id')->select();
if (count($video_list_suiji_list)<5){
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['num'] = count($video_list_suiji_list);
echo json_encode($data);
die();
}
// print_r($video_list_suiji_list);
$id_list = array_column($video_list_suiji_list, 'v_id');
// print_r($id_list);
$sql_charu = "";
foreach ($video_list_suiji_list as $key1 => $value1) {
$duifang_id = $value1['v_id'];;
$xianzhi_one = " or id='$duifang_id'";
$sql_charu .= $xianzhi_one;
}
// 首先判断用户是否登录 没登录
$all_suiji_list = array();
$video_list = M('video_list_test')->where("id=0 $sql_charu")->LIMIT(0, 60)->select();
// echo PHP_EOL.M('video_list_test')->_sql();
foreach ($video_list as $key => $value) {
$id = $value['id'];
$suozai_num = array_search("$id", $id_list);
$id_list[$suozai_num] = $value;
}
print_r($id_list);
// 131530
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function array_test_demo()
{
$key_lsit = array('A', 'B');
$demo = array('A' => array("a" => '11'), 'B' => array("b" => '22'));
array_search(array("b" => '2'), $demo);
}
/**
* 版本:1,8
* 新增/更新:updata
* 简述:首页弹窗链接
* @param $templateid []
* @return $type 消息类型
*/
public function shouye_lianjei(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$now_time =time();
$user_views =M("user_info")->where("id=$uid")->field("add_date,vip_money")->select();
$zhuce_time = $user_views[0]['add_date'];
$vip = $user_views[0]['vip_money'];
$cha_time = $now_time-$zhuce_time;
if ($uid==0){
$data['message'] = 'not_login';
}else{
if ($cha_time>86400 and $vip==0){
$data['message'] = 'not_pay';
}else{
$data['message'] = 'ok';
}
}
$url_list = M("shouye_url")->where("type='yj'")->field("url")->limit(3)->select();
$apple_url = M("shouye_url")->where("id in (8,9,10) and url!=''")->order("rand()")->getField("url");
$gonggao = M("shouye_url")->where("id in (11)")->getField("url");
// echo PHP_EOL.$apple_url;
$url_list[3]["url"] =$apple_url;
$url_list[4]["url"] =$gonggao;
if ($url_list) {
$data['data'] = $url_list;
echo json_encode($data);
} else {
$data['data'] = 'no';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 返回广告方法
* @param $templateid []
* @return $type 消息类型
*/
public function Return_to_ads()
{
if (!empty($_POST)) {
$avd_type = $_POST['adv_type'];
switch ($avd_type) {
case 'list_detail':
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
break;
case 'video_beg':
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
break;
default:
echo "type error";
}
if ($adv_list) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = '';
$data['data'] = $adv_list;
echo json_encode($data);
} else {
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'no';
$data['data'] = array();
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 将A.jpg 的图片换成处理好的图片
* @param $templateid []
* @return $type 消息类型
*/
public function tihuan_ajpg_()
{
//先找出所有A。jpg
$all_a_jpg = M('video_list_test')->limit(11000, 12000)->field("sl_id,id")->select();
foreach ($all_a_jpg as $key => $value) {
$bb_id = $value['id'];
$sl_id = $value['sl_id'];
$newnew_img = M("slgj_videos")->where("id=$sl_id")->getField("one_img");
if ($newnew_img == null) {
$newnew_img = 'https://www.bibidd.com/bibidd_testtest/A.jpg';
}
$now_update_list['top_img'] = $newnew_img;
$yn_chenggong = M('video_list_test')->where("id=$bb_id")->save($now_update_list);
echo PHP_EOL . M('video_list_test')->_sql();
if ($yn_chenggong) {
echo PHP_EOL . '成功';
} else {
echo PHP_EOL . '失败了!!!';
}
}
}
/**
* 将a.jpg图片替换
* @param $templateid []
* @return $type 消息类型
*/
public function ajpg_tiuan_yes(){
$ajpg_list_map = M('video_list_test')->where("top_img='https://www.bibidd.com/bibidd_testtest/A.jpg'")->field("id,sl_id,title")->select();
foreach ($ajpg_list_map as $key => $value) {
$bb_id =$value['id'];
$slgj_id = $value['sl_id'];
$slgj_title = $value['title'];
$yn_youshuju = M("slgj_videos")->where("id=$slgj_id")->getField("one_img");
if ($yn_youshuju) {
$gegxin_list['top_img'] =$yn_youshuju;
M('video_list_test')->where("id=$bb_id")->save($gegxin_list);
echo PHP_EOL.$yn_youshuju;
echo PHP_EOL.'有数据';
}else{
M('video_list_test')->where("id=$bb_id")->delete();
echo PHP_EOL.$yn_youshuju;
echo PHP_EOL.'无数据';
}
}
}
/**
* 查询用户是否是会员
* @param $templateid []
* @return $type 消息类型
*/
public function panduan_huiyuan(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Contr-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$huiyuan_time_list =M("user_info")->where("id=$uid")->field("vip_over_time,vip_yn,gold_coins_number")->select();
$huiyuan_time = $huiyuan_time_list[0]['vip_over_time'];
$huiyuan_type= $huiyuan_time_list[0]['vip_yn'];
$user_gold_coins= $huiyuan_time_list[0]['gold_coins_number'];
$now_time = time();
if ($huiyuan_time>$now_time) {
$data['code'] = '200';
$data['status'] = '1';
$data['type'] = $huiyuan_type;
$data['message'] = 'is_vip';
echo json_encode($data);
} else {
//不是会员判断是否有足够余额来
if ($user_gold_coins>=48){
$data['code'] = '200';
$data['status'] = '2';
$data['coins'] = 'yes_coins';
$data['message'] = 'no_vip';
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '3';
$data['coins'] = 'no_coins';
$data['message'] = 'no_vip';
echo json_encode($data);
}
}
}else{
echo $this->returnData();
}
}
/**
*获取用户IP地址
* @param int $type
* @return mixed
*/
private function get_bb_ip($type = 0)
{
$type = $type ? 1 : 0;
static $ip = NULL;
if ($ip !== NULL) return $ip[$type];
if ($_SERVER['HTTP_X_REAL_IP']) {//nginx 代理模式下,获取客户端真实IP
$ip = $_SERVER['HTTP_X_REAL_IP'];
} elseif (isset($_SERVER['HTTP_CLIENT_IP'])) {//客户端的ip
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {//浏览当前页面的用户计算机的网关
$arr = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);
$pos = array_search('unknown', $arr);
if (false !== $pos) unset($arr[$pos]);
$ip = trim($arr[0]);
} elseif (isset($_SERVER['REMOTE_ADDR'])) {
$ip = $_SERVER['REMOTE_ADDR'];//浏览当前页面的用户计算机的ip地址
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
// IP地址合法验证
$long = sprintf("%u", ip2long($ip));
$ip = $long ? array($ip, $long) : array('0.0.0.0', 0);
return $ip[$type];
}
/**
* 非会员 观看视频
* @param $templateid []
* @return $type 消息类型
*/
public function no_vip_views(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Contr-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$now_views = M("user_info")->where("id=$uid")->getField("views_num");
if ($now_views==5 or $now_views>5) {
$data['message'] = 'no';
echo json_encode($data);
}else{
$data['message'] = 'yes';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 添加至收藏视频
* @param cid [这个视频或者图片的 id]
* @param type [video or img]
* @param uid [用户id]
* @return $type 消息类型
*/
public function add_to_shoucang()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
$type = $_POST['type'];
$cid = $_POST['cid'];
switch ($type) {
case 'video':
$video_info_list = M('video_list_test')->where("id=$cid")->field("time_chuo,site,uploader")->select();
$video_time_chuo = $video_info_list[0]['time_chuo'];
$video_type= $video_info_list[0]['uploader'];
$video_list['uid'] = $uid;
$video_list['vid'] = $cid;
$video_list['time'] = time();
$video_list['video_type'] = $video_type;
$video_list['time_chuo'] = $video_time_chuo;
$yn_add = M("video_shoucang")->add($video_list);
break;
case 'xiaoshuo':
$video_list['uid'] = $uid;
$video_list['vid'] = $cid;
$video_list['time'] = time();
$video_list['video_type'] = '色情小说';
$yn_add = M("video_shoucang")->add($video_list);
break;
default:
echo "type error";
}
if ($yn_add) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'error';
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 判断是否收藏
* @param cid [这个视频或者图片的 id]
* @param type [video or img]
* @param uid [用户id]
* @return $type 消息类型
*/
public function yn_shoucang()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$cid = $_POST['cid'];
$uid = $_POST['uid'];
$type = $_POST['type'];
switch ($type) {
case 'video':
$yn_se = M("video_shoucang")->where("uid=$uid and vid=$cid")->getField("id");
break;
default:
echo "type error";
}
if ($yn_se) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'no';
echo json_encode($data);
}
} else {
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function last_login_jilu(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$ttime = time();
$ddate = date("Y-m-d H:i:s",$ttime);
$last_login_list['last_login_time'] = $ttime;
$last_login_list['last_login_date'] = $ddate;
$save_yn = M("user_info")->where("id=$uid")->save($last_login_list);
$jintian_riqi = date("Y-m-d");
//判断今天表中是是否存在
$yn_yiyou = M("huoyue_list")->where("uid=$uid and today='$jintian_riqi'")->getField("id");
if ($yn_yiyou) {
}else{
$add_list['today'] = $jintian_riqi;
$add_list['time'] = $ttime;
$add_list['uid'] = $uid;
$add_list['device_type'] = $_POST['deviceType'];
M("huoyue_list")->add($add_list);
}
if ($save_yn) {
$data['message'] = 'ok';
echo json_encode($data);
} else {
$data['message'] = 'no';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 是否三十天
* @param $templateid []
* @return $type 消息类型
*/
public function threty_dayyn(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$login_time = M("user_info")->where("id=$uid")->getField("add_time");
$now_time = time();
$cha_time = 3600 * 24 * 30;
$jisuan_time = $now_time - $login_time;
if ($jisuan_time>$cha_time) {
//chao
$data['message'] = 'ok';
echo json_encode($data);
} else {
//
$data['message'] = 'no';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 智博地址 和 免费视频
* 1.4修改
* 免费用户推荐1视频
* 付费用户推荐3视频
* @param $templateid []
* @return $type 消息类型
*/
public function free_video_adv(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$user_type = $_POST['type'];
if ($user_type=='0') {
$free_list = M('free_video_zb_test')->where("id=1")->field("free_video,url")->select();
$free_id = $free_list[0]['free_video'];
$adv_url = $free_list[0]['url'];
$video_list = M('video_list_test')->where("id=$free_id")->select();
$data['code'] = '200';
$data['status'] = '1';
$data['data'] = array($video_list);
$data['data']['adv_url'] =$adv_url ;
echo json_encode($data);
} else {
$free_list = M('free_video_zb_test')->where("id is not null")->field("free_video,url")->select();
$free_id = $free_list[0]['free_video'];
$adv_url = $free_list[0]['url'];
$free_two_id =$free_list[1]['free_video'];
$free_three_id =$free_list[2]['free_video'];
$video_list_one = M('video_list_test')->where("id=$free_id")->select();
$video_list = M('video_list_test')->where("id=$free_two_id or id=$free_three_id")->select();
$video_list_list = array_merge($video_list_one,$video_list);
$data['code'] = '200';
$data['status'] = '1';
$data['data'] = array($video_list_list);
$data['data']['adv_url'] =$adv_url ;
echo json_encode($data);
}
}else{
$free_list = M('free_video_zb_test')->where("id=1")->field("free_video,url")->select();
$free_id = $free_list[0]['free_video'];
$adv_url = $free_list[0]['url'];
$video_list = M('video_list_test')->where("id=$free_id")->select();
$data['code'] = '200';
$data['status'] = '1';
$data['data'] = $video_list[0];
$data['data']['adv_url'] =$adv_url ;
echo json_encode($data);
}
}
/**
* 代理详情
* 一页50
* 本月代理
* 积累代理
* @param $templateid []
* @return $type 消息类型
*/
public function agentlist(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$yue_start_time = strtotime('first day of this month midnight');;
$yue_end_time = strtotime('first day of next month midnight') - 1;
$uid = $_POST['uid'];
$page = $_POST['page'];
$page_one = ($page - 1) * 50;
$data_type = $_POST['data_type'];
switch ($data_type) {
case 'month':
// ->order("id desc")
$list_agent = M("pop_user")->where("uid=$uid and add_time BETWEEN $yue_start_time and $yue_end_time or uid=$uid and agent_money_time BETWEEN $yue_start_time and $yue_end_time")->order("id desc")->field("get_name,pay_brokerage,pay_money,add_date")->LIMIT($page_one, 50)->select();
$list_agent_num = M("pop_user")->where("uid=$uid and add_time BETWEEN $yue_start_time and $yue_end_time or uid=$uid and agent_money_time BETWEEN $yue_start_time and $yue_end_time")->count();
break;
case 'accumulate':
// ->order("id desc")
$list_agent = M("pop_user")->where("uid=$uid")->field("get_name,pay_brokerage,pay_money,add_date")->order("id desc")->LIMIT($page_one, 50)->select();
$list_agent_num = M("pop_user")->where("uid=$uid")->count();
break;
default:
$data['message'] = 'type_error';
echo json_encode($data);
die();
}
if (!empty($list_agent)) {
$data['code'] = '200';
$data['status'] = '1';
$data['status'] = 'ok';
$data['data'] = $list_agent;
$data['data_num'] = $list_agent_num;
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'null';
$data['data'] = array();
$data['data_num'] = 0;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 积累 or 月 代理数量
* @param $templateid []
* @return $type 消息类型
*/
public function accumulate_month_agent(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$yue_start_time = strtotime('first day of this month midnight');;
$yue_end_time = strtotime('first day of next month midnight') - 1;
$uid = $_POST['uid'];
$data_type = $_POST['data_type'];
switch ($data_type) {
case 'month':
//佣金
$agent_money_sum = M("user_info")->where("id=$uid")->getField('agent_money');
//用户数量
$agent_people_num = M("pop_user")->where("uid=$uid and add_time BETWEEN $yue_start_time and $yue_end_time")->count();
//会员数量
$agent_people_vip_num = M("pop_user")->where("uid=$uid and agent_money_time BETWEEN $yue_start_time and $yue_end_time and pay_money>0")->count();
break;
case 'accumulate':
//佣金
$agent_money_sum = M("agent_money")->where("uid=$uid")->sum('agent_money');
//用户数量
$agent_people_num = M("pop_user")->where("uid=$uid")->count();
//会员数量
$agent_people_vip_num = M("pop_user")->where("uid=$uid and pay_money>0")->count();
break;
default:
$data['message'] = 'type_error';
echo json_encode($data);
die();
}
if (empty($agent_money_sum)) {
$agent_money_sum=0;
}
if (empty($agent_people_num)) {
$agent_people_num=0;
}
if (empty($agent_people_vip_num)) {
$agent_people_vip_num=0;
}
$agent_list['agent_money'] =$agent_money_sum ;
$agent_list['agent_people_num'] = $agent_people_num;
$agent_list['agent_vip_num'] =$agent_people_vip_num ;
if (!empty($agent_list)) {
$data['code'] = '200';
$data['status'] = '1';
$data['status'] = 'ok';
$data['data'] = $agent_list;
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'null';
$data['data'] = array();
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 提现佣金数
* @param $templateid []
* @return $type 消息类型
*/
public function withdrawamount(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
}else{
echo $this->returnData();
}
}
/**
* 提现支付宝
* @param $templateid []
* @return $type 消息类型
*/
public function seting_withdrawal_alipay(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$realname = $_POST['realname'];
$alipayuser = $_POST['alipayuser'];
$save_time = time();
//15天后
$cha_time = 3600 * 24 * 15;
$save_list['uid'] = $uid;
$save_list['real_name'] =$realname ;
$save_list['alipay_user'] =$alipayuser ;
$save_list['save_time'] = $save_time+$cha_time;
$last_save_time = M("alipay_user")->where("uid=$uid")->getField("save_time");
if (empty($last_save_time)) {
//没有数据能添加
M("alipay_user")->add($save_list);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'save_yes';
echo json_encode($data);
}else{
$now_time = time();
if ($now_time>$last_save_time) {
//chao
$yn_save = M("alipay_user")->where("uid=$uid")->save($save_list);
if ($yn_save) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'save_yes';
echo json_encode($data);
} else {
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'save_no';
echo json_encode($data);
}
}else{
$userip = $this->get_bb_ip();
$ttime = time();
$ddate = date("Y-m-d H:i:s",$ttime);
$last_login_list['time'] = $ttime;
$last_login_list['time_date'] = $ddate;
$last_login_list['uid'] = $uid;
$last_login_list['ip'] = $userip;
M("black_box")->add($last_login_list);
die();
}
}
}else{
echo $this->returnData();
}
}
/**
* 判断是否能修改 支付宝账号
* @param $templateid []
* @return $type 消息类型
*/
public function judgmentsavealipay(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$last_save_time_list = M("alipay_user")->where("uid=$uid")->Field('real_name,alipay_user,save_time')->select();
$last_save_time = $last_save_time_list[0]['save_time'];
$r_name = $last_save_time_list[0]['save_time'];
$r_name = $last_save_time_list[0]['save_time'];
$today = time();
if (empty($last_save_time_list)) {
$last_save_time_list[0]['real_name'] ='';
$last_save_time_list[0]['alipay_user'] ='';
$last_save_time_list[0]['save_time'] ='0';
}
if (empty($last_save_time)) {
//没有数据能添加
$data['message'] = 'okay';
$data['data'] = $last_save_time_list;
echo json_encode($data);
}else{
$now_time = time();
if ($now_time>$last_save_time) {
//chao
$data['message'] = 'okay';
$data['data'] = $last_save_time_list;
echo json_encode($data);
} else {
// 计算距离指定时间戳的差值(单位:秒)
$timeDifference = $last_save_time - $today;
// 转换为天数
$daysRemaining = ceil($timeDifference / (60 * 60 * 24));
$data['message'] = 'no';
$data['save_day'] = $daysRemaining;
$data['data'] = $last_save_time_list;
echo json_encode($data);
}
}
}else{
echo $this->returnData();
}
}
/**
* 用户代理佣金数
* @param $templateid []
* @return $type 消息类型
*/
public function show_agent_user_money(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$user_agent_money_list = M("user_info")->where("id=$uid")->field("last_month_agent_money,payable_one,payable_two")->select();
$user_agent_money = $user_agent_money_list[0]['last_month_agent_money'];
$button_one = $user_agent_money_list[0]['payable_one'];
$button_two = $user_agent_money_list[0]['payable_two'];
// 获取当前月份
$currentMonth = date('n');
// 获取下个月的月份
$nextMonth = date('n', strtotime('+1 month'));
if ($button_one==1 and $button_two==1) {
$data['code'] = '200';
$data['status'] = '4';
$data['message'] = '已打款';
$data['data'] = array("$nextMonth", "$user_agent_money");
echo json_encode($data);
die();
}
if (!empty($user_agent_money)) {
if ($user_agent_money>=200) {
//大于等于200则显示
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'true';
$data['data'] = array("$nextMonth", "$user_agent_money");
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'null';
$data['data'] = $data['data'] = array("$nextMonth", "0");;
echo json_encode($data);
}
} else {
$data['code'] = '200';
$data['status'] = '3';
$data['message'] = 'null';
$data['data'] = $data['data'] = array("$nextMonth", "0");;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function accumulateandmonth(){
// 获取本月起始时间戳(零点)
$firstDayOfMonth = strtotime('first day of this month midnight');
// 获取下个月起始时间戳(零点),并减去1秒
$firstDayOfNextMonth = strtotime('first day of next month midnight') - 1;
// 输出时间戳区间
echo "本月起始时间戳:" . $firstDayOfMonth . "
";
echo "本月结束时间戳:" . $firstDayOfNextMonth . "
";
// 可以将时间戳转换为日期格式进行查看
echo "本月起始日期:" . date('Y-m-d H:i:s', $firstDayOfMonth) . "
";
echo "本月结束日期:" . date('Y-m-d H:i:s', $firstDayOfNextMonth) . "
";
}
/**
*显示支付宝账号
* @param $templateid []
* @return $type 消息类型
*/
public function show_alipay_user(){
$data = $this->returnData();
if (!empty($_POST)){
$uid = $_POST['uid'];
}else{
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function favorite_video_list(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$jintian = M("suiji_num")->where("id=1")->getField("time");
$page = $_POST['page'];
$page_one = ($page - 1) * 30;
//所有视频id
$favorite_video_list = M("shoucang_two_video")->where("time='$jintian'")->field("v_id")->LIMIT($page_one, 30)->select();
$favorite_video_amount = M("shoucang_two_video")->where("time='$jintian'")->field("v_id")->select();
$video_list_count = count($favorite_video_amount);
foreach ($favorite_video_list as $key1 => $value1) {
$duifang_id = $value1['v_id'];
$xianzhi_one = " or id='$duifang_id'";
$sql_charu .= $xianzhi_one;
}
$video_list = M('video_list_test')->where("id=0 $sql_charu")->select();
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 5;
$qishi_num = 0;
$data_list_number = count($video_list);
$quzheng_num = floor($data_list_number / 5);
foreach ($adv_list as $key => $value) {
$charu_array = array($adv_list[$key]);
array_splice($video_list, $jia_num, 0, $charu_array);
$jia_num += 6;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
if (!empty($video_list)) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'yes';
$data['data'] = $video_list;
$data['count'] = $video_list_count;
echo json_encode($data);
} else {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'yes';
$data['data'] = $video_list;
$data['count'] = 0;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
*
* checkbank.php文件
*
* User: jackhhy
* DateTime: 2018/12/1 10:01
*/
public function bankInfo($card,$bankList)
{
header('Content-type:text/html;charset=utf-8');
$card_8 = substr($card, 0, 8);
if (isset($bankList[$card_8])) {
// echo $bankList[$card_8];
return $bankList[$card_8];
}
$card_6 = substr($card, 0, 6);
if (isset($bankList[$card_6])) {
// echo $bankList[$card_6];
return $bankList[$card_6];
}
$card_5 = substr($card, 0, 5);
if (isset($bankList[$card_5])) {
// echo $bankList[$card_5];
return $bankList[$card_5];
}
$card_4 = substr($card, 0, 4);
if (isset($bankList[$card_4])) {
// echo $bankList[$card_4];
return $bankList[$card_4];
}
return '该卡号信息暂未录入';
}
/**
* 判断是否能修改 支付宝账号
* @param $templateid []
* @return $type 消息类型
*/
public function judgmentsave_bank_card(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$last_save_time_list = M("agent_bank_card_info")->where("uid=$uid")->Field('real_name,bank_card_number,bank_name,save_time')->select();
$last_save_time = $last_save_time_list[0]['save_time'];
$today = time();
if (empty($last_save_time_list)) {
$last_save_time_list[0]['real_name'] ='';
$last_save_time_list[0]['bank_card_number'] ='';
$last_save_time_list[0]['bank_name'] ='';
$last_save_time_list[0]['save_time'] ='0';
}
if (empty($last_save_time)) {
//没有数据能添加
$data['message'] = 'okay';
$data['data'] = $last_save_time_list;
echo json_encode($data);
}else{
$now_time = time();
if ($now_time>$last_save_time) {
//chao
$data['message'] = 'okay';
$data['data'] = $last_save_time_list;
echo json_encode($data);
} else {
// 计算距离指定时间戳的差值(单位:秒)
$timeDifference = $last_save_time - $today;
// 转换为天数
$daysRemaining = floor($timeDifference / (60 * 60 * 24));
$data['message'] = 'no';
$data['save_day'] = $daysRemaining;
$data['data'] = $last_save_time_list;
echo json_encode($data);
}
}
}else{
echo $this->returnData();
}
}
/**
* 提现银行卡
* @param $templateid []
* @return $type 消息类型
*/
public function seting_bank_card(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$realname = $_POST['realname'];
$bank_card_number = $_POST['bank_card_number'];
$bank_name = $_POST['bank_name'];
$save_time = time();
//15天后
$cha_time = 3600 * 24 * 15;
$save_list['uid'] = $uid;
$save_list['real_name'] =$realname ;
$save_list['bank_card_number'] =$bank_card_number ;
$save_list['bank_name'] =$bank_name ;
$save_list['save_time'] = $save_time+$cha_time;
$save_list['pay_type'] = 'bank';
$last_save_time = M("agent_bank_card_info")->where("uid=$uid")->getField("save_time");
if (empty($last_save_time)) {
//没有数据能添加
M("agent_bank_card_info")->add($save_list);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'save_yes';
echo json_encode($data);
}else{
$now_time = time();
if ($now_time>$last_save_time) {
//chao
$yn_save = M("agent_bank_card_info")->where("uid=$uid")->save($save_list);
if ($yn_save) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'save_yes';
echo json_encode($data);
} else {
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'save_no';
echo json_encode($data);
}
}else{
$userip = $this->get_bb_ip();
$ttime = time();
$ddate = date("Y-m-d H:i:s",$ttime);
$last_login_list['time'] = $ttime;
$last_login_list['time_date'] = $ddate;
$last_login_list['uid'] = $uid;
$last_login_list['ip'] = $userip;
M("black_box")->add($last_login_list);
die();
}
}
}else{
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function get_bank_name(){
header('Content-type:text/html;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
include 'bankList.php';
if (!empty($_POST)){
$bank_card_number = $_POST['bank_card_number'];
/** @noinspection PhpUndefinedVariableInspection */
$wula = $this->bankInfo("{$bank_card_number}", $bankList);
if ($wula =='该卡号信息暂未录入') {
$data['code'] = '200';
$data['status'] = '2';
$data['data'] = "该卡号信息暂未录入";
echo json_encode($data);
die();
}
$bank_name_list = explode('-',$wula);
$bank_name = $bank_name_list[0];
$data['code'] = '200';
$data['status'] = 1;
$data['data'] = "$bank_name";
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 海角列表
* @param $templateid []
* @return $type 消息类型
*/
public function haijiao_video_list(){
header('Content-type:text/html;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
}else{
echo $this->returnData();
}
}
/**
* 反差列表
* @param $templateid []
* @return $type 消息类型
*/
public function fancha_video_list(){
header('Content-type:text/html;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
}else{
echo $this->returnData();
}
}
/**
* 版本:
* 新增/更新:
* 简述:
* @param $templateid []
* @return $type 消息类型
*/
public function jingping_video_list(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$page = $_POST['page'];
$uid = $_POST['uid'];
//在线
$tttime = time();
$ddate = date("Y-m-d H:i:s",$tttime);
$new_views_num['last_login_time'] =$tttime;
$new_views_num['last_login_date'] =$ddate;
M("user_info")->where("id=$uid")->save($new_views_num);
$page_one = ($page - 1) * 66;
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("two_two_one_video")->where("time='$jintian' and c_type='jing'")->LIMIT($page_one, 66)->Field('v_id')->select();
if (count($video_list_suiji_list)<5){
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['all_num'] = 2400;
echo json_encode($data);
die();
}
$id_list = array_column($video_list_suiji_list, 'v_id');
$sql_charu = "";
foreach ($video_list_suiji_list as $key1 => $value1) {
$duifang_id = $value1['v_id'];;
$xianzhi_one = " or id='$duifang_id'";
$sql_charu .= $xianzhi_one;
}
$video_list = M('video_list_test')->where("id=0 $sql_charu")->select();
// echo PHP_EOL.M('video_list_test')->_sql();
//牛逼
$wula_lsit = array();
$num_fc = 0;
$new_twotwo_list = array();
// print_r($video_list);
// echo PHP_EOL.'1991';
foreach ($video_list as $key => $value) {
$id = $value['id'];
$video_site = $value['site'];
if ($id==''){
$value= M('video_list_test')->where("id=146145")->select();
}
$suozai_num = array_search("$id", $id_list);
$id_list[$suozai_num] = $value;
}
// print_r($id_list);
// die();
foreach ($id_list as $keyn => $valuen) {
$video_site_n = $valuen['uploader'];
//被删数据替换
if (is_string($valuen)){
$valuen = M('video_list_test')->where("site = 'HL'")->order("rand()")->LIMIT(1)->select()[0];
}
// echo PHP_EOL.'-----';
// echo PHP_EOL.$video_site_n;
// echo PHP_EOL.$value;
if ($video_site_n =='素人反差'
or $video_site_n =='制服学妹'
or $video_site_n =='后入嫩穴'
or $video_site_n =='马尾学妹'
or $video_site_n =='美臀翘臀'
or $video_site_n =='超级巨臀'
or $video_site_n =='雪白美乳'
or $video_site_n =='同性做爱'
or $video_site_n =='另类猎奇'
or $video_site_n =='顶臀街射'
or $video_site_n =='粉嫩少女'
) {
$now_vid = $valuen['id'];
$needle = ",$now_vid,";
$num_fc++;
array_push($wula_lsit, $valuen);
if ($num_fc==2) {
array_push($new_twotwo_list,$wula_lsit);
$num_fc = 0;
$wula_lsit = array();
}
}else{
array_push($new_twotwo_list,$valuen);
}
}
$data['all_num'] = 10624;
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(6)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5]);
$jia_num = 8;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 8);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($new_twotwo_list, $jia_num, 0, $charu_array);
$jia_num += 9;
$qishi_num += 1;
}
$data['data'] = $new_twotwo_list;
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 首页视频列表112
* @param $templateid []
* @return $type 消息类型
*/
public function twotwoone_list(){
header('Content-type:text/html;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$page = $_POST['page'];
$uid = $_POST['uid'];
$page_one = ($page - 1) * 60;
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("two_two_one_video")->where("time='$jintian' and c_type is null")->LIMIT($page_one, 60)->Field('v_id')->select();
// echo PHP_EOL.count($video_list_suiji_list);
if (count($video_list_suiji_list)<5){
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['all_num'] = 48;
echo json_encode($data);
die();
}
$id_list = array_column($video_list_suiji_list, 'v_id');
$sql_charu = "";
foreach ($video_list_suiji_list as $key1 => $value1) {
$duifang_id = $value1['v_id'];;
$xianzhi_one = " or id='$duifang_id'";
$sql_charu .= $xianzhi_one;
}
$video_list = M('video_list_test')->where("id=0 $sql_charu")->select();
$wula_lsit = array();
$num_fc = 0;
$new_twotwo_list = array();
foreach ($video_list as $key => $value) {
$id = $value['id'];
$video_site = $value['site'];
if ($id==''){
$value= M('video_list_test')->where("id=146145")->select();
}
$suozai_num = array_search("$id", $id_list);
$id_list[$suozai_num] = $value;
}
foreach ($id_list as $keyn => $valuen) {
$video_site_n = $valuen['uploader'];
//被删数据替换
if (is_string($valuen)){
$valuen = M('video_list_test')->where("site = 'HL'")->order("rand()")->LIMIT(1)->select()[0];
}
// echo PHP_EOL.'-----';
// echo PHP_EOL.$video_site_n;
// echo PHP_EOL.$value;
if ($video_site_n =='素人反差'
or $video_site_n =='制服学妹'
or $video_site_n =='后入嫩穴'
or $video_site_n =='马尾学妹'
or $video_site_n =='美臀翘臀'
or $video_site_n =='超级巨臀'
or $video_site_n =='雪白美乳'
or $video_site_n =='同性做爱'
or $video_site_n =='另类猎奇'
or $video_site_n =='顶臀街射'
or $video_site_n =='粉嫩少女'
) {
$now_vid = $valuen['id'];
$needle = ",$now_vid,";
$num_fc++;
array_push($wula_lsit, $valuen);
if ($num_fc==2) {
array_push($new_twotwo_list,$wula_lsit);
$num_fc = 0;
$wula_lsit = array();
}
}else{
array_push($new_twotwo_list,$valuen);
}
}
$data['all_num'] = 10624;
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(6)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 8;
$qishi_num = 0;
$data_list_number = count($new_twotwo_list);
$quzheng_num = floor($data_list_number / 8);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($new_twotwo_list, $jia_num, 0, $charu_array);
$jia_num += 9;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $new_twotwo_list;
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 查询判断是否能修改USDT
* 返回已有
* @param $templateid []
* @return $type 消息类型
*/
public function judgmentsave_usdt(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$last_save_time_list = M("agent_bank_card_info")->where("uid=$uid")->Field('usdt_string,save_time')->select();
$last_save_time = $last_save_time_list[0]['save_time'];
$today = time();
if (empty($last_save_time_list)) {
$last_save_time_list[0]['usdt_string'] ='';
$last_save_time_list[0]['save_time'] ='0';
}
if (empty($last_save_time)) {
//没有数据能添加
$data['message'] = 'okay';
$data['data'] = $last_save_time_list;
echo json_encode($data);
}else{
$now_time = time();
if ($now_time>$last_save_time) {
//chao
$data['message'] = 'okay';
$data['data'] = $last_save_time_list;
echo json_encode($data);
} else {
// 计算距离指定时间戳的差值(单位:秒)
$timeDifference = $last_save_time - $today;
// 转换为天数
$daysRemaining = floor($timeDifference / (60 * 60 * 24));
$data['message'] = 'no';
$data['save_day'] = $daysRemaining;
$data['data'] = $last_save_time_list;
echo json_encode($data);
}
}
}else{
echo $this->returnData();
}
}
/**
* 提现银行卡
* @param $templateid []
* @return $type 消息类型
*/
public function seting_usdt(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$usdt_string = $_POST['usdt_string'];
$save_time = time();
//15天后
$cha_time = 3600 * 24 * 15;
$save_list['uid'] = $uid;
$save_list['usdt_string'] =$usdt_string ;
$save_list['save_time'] = $save_time+$cha_time;
$save_list['pay_type'] = 'usdt';
$last_save_time = M("agent_bank_card_info")->where("uid=$uid")->getField("save_time");
if (empty($last_save_time)) {
//没有数据能添加
M("agent_bank_card_info")->add($save_list);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'save_yes';
echo json_encode($data);
}else{
$now_time = time();
if ($now_time>$last_save_time) {
//chao
$yn_save = M("agent_bank_card_info")->where("uid=$uid")->save($save_list);
if ($yn_save) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'save_yes';
echo json_encode($data);
} else {
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'save_no';
echo json_encode($data);
}
}else{
$userip = $this->get_bb_ip();
$ttime = time();
$ddate = date("Y-m-d H:i:s",$ttime);
$last_login_list['time'] = $ttime;
$last_login_list['time_date'] = $ddate;
$last_login_list['uid'] = $uid;
$last_login_list['ip'] = $userip;
M("black_box")->add($last_login_list);
die();
}
}
}else{
echo $this->returnData();
}
}
/**
* c
* @param $templateid []
* @return $type 消息类型
*/
public function get_user_payment(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$bank_info = M("agent_bank_card_info")->where("uid=$uid")->getField("pay_type");
if (empty($bank_info)) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'no_set';
echo json_encode($data);
} else{
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = $bank_info;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function get_agent_user(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$agent_user_list = M("agent_money")->where("uid=$uid")->field("get_uid")->order("id asc")->LIMIT(2)->select();
foreach ($agent_user_list as $key => $value) {
$get_uid = $value['get_uid'];
$user_info[$key]['name'] = M("pop_user")->where("get_uid=$get_uid")->getField("get_name");
}
if (empty($user_info)) {
$data['code'] = '200';
$data['message'] = '0';
$data['data'] = [];
echo json_encode($data);
}else{
$data['code'] = '200';
$data['message'] = '1';
$data['data'] = $user_info;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 代理 统计固定增加
* @param $templateid []
* @return $type 消息类型
*/
public function get_agent_record(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$agent_list = M("add_agent_record")->where("id=1")->field('agent_people_number,agent_money_acount')->select();
$data['code'] = '200';
$data['message'] = '1';
$data['data'] = $agent_list;
echo json_encode($data);
}
/**
* 是否在新注册两小时内
* @param $templateid []
* @return $type 消息类型
*/
public function newusertwoh(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid =$_POST['uid'];
//用户注册时间
$zhuce_time = M("user_info")->where("id=$uid")->getField("add_time");
//now time
$now_time = time();
$time_cha = $now_time - $zhuce_time;
$two_h =1800;
$time_now_cha = $two_h - $time_cha;
if ($two_h<$time_cha) {
$wula = array('time'=>$time_now_cha,'pay'=>'0');
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'no';
$data['data'] = $wula;
echo json_encode($data);
}else{
$use_first_pay_type = M("user_first_pay")->where("uid=$uid")->field('thirty,uid')->select();
if (!$use_first_pay_type){
$user_info['uid'] =$uid;
M("user_first_pay")->add($user_info);
}
$use_first_pay_type = M("user_first_pay")->where("uid=$uid")->getField("thirty");;
if ($use_first_pay_type==0){
$wula = array('time'=>$time_now_cha,'pay'=>'0');
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'no';
$data['data'] =$wula;
echo json_encode($data);
}else{
$wula = array('time'=>$time_now_cha,'pay'=>'1');
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'yes';
$data['data'] = $wula;
echo json_encode($data);
}
}
}else{
echo $this->returnData();
}
}
/**
* 黑料详情
* @param $templateid []
* @return $type 消息类型
*/
public function heiliao_detail(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$video_id = $_POST['video_id'];
$uid = $_POST['uid'];
//判读是否登录
if ($uid == '0' or $uid == '' or $uid=='undefined') {
$data['message'] = 'error';
echo json_encode($data);
die();
}
//内容攒数 观看数
$now_zan_num_list = M('video_list_test')->where("id=$video_id")->Field("views,thumbs_up,site")->select();
$video_site = $now_zan_num_list[0]['site'];
if($video_site =='HL'){
$heiliao_list = M("heiliao_haijiao_books")->where("id=$video_id")->field("book,site,hj_video_url")->select()[0];
$heiliao_list['views'] = $now_zan_num_list[0]['views'];
$heiliao_list['thumbs_up'] = $now_zan_num_list[0]['thumbs_up'];
$heiliao_list['hj_video_url'] = explode(",", $heiliao_list['hj_video_url']);
}elseif ($video_site =='WB'){
$heiliao_list = M("heiliao_haijiao_books")->where("id=$video_id")->field("book,site,hj_video_url")->select()[0];
$heiliao_list['views'] = $now_zan_num_list[0]['views'];
$heiliao_list['thumbs_up'] = $now_zan_num_list[0]['thumbs_up'];
}else{
$heiliao_list = M("heiliao_haijiao_books")->where("id=$video_id")->field("book,site")->select()[0];
$heiliao_list['views'] = $now_zan_num_list[0]['views'];
$heiliao_list['thumbs_up'] = $now_zan_num_list[0]['thumbs_up'];
}
if ( $heiliao_list['hj_video_url'][0]=="") {
$heiliao_list['hj_video_url'] = array();
}
$tttime = time();
$ddate = date("Y-m-d H:i:s",$tttime);
$new_views_num['last_login_time'] =$tttime;
$new_views_num['last_login_date'] =$ddate;
M("user_info")->where("id=$uid")->save($new_views_num);
if($heiliao_list){
M('video_list_test')->where("id=$video_id")->setInc('v_really',1);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $heiliao_list;
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = '';
$data['data'] = "";
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 用户金币数量
* @param $templateid []
* @return $type 消息类型
*/
public function user_gold_coins_amount(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$user_gold_coins_number = M("user_info")->where("id=$uid")->getField("gold_coins_number");
if ($user_gold_coins_number) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $user_gold_coins_number;
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'ok';
$data['data'] = 0;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 判断海角详情里是否有视频,反差详情
* @param $templateid []
* @return $type 消息类型
*/
public function haijiao_video_yn(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$video_id = $_POST['video_id'];
$yn_video_list =M("heiliao_haijiao_books")->where("id=$video_id")->field("hj_video_url,book_type,book,site,book_str,book_str_log")->select()[0];
$video_list['book'] =$yn_video_list['book_str_log'] ;
$video_list['hj_video_url'] = array();
$video_list['title'] = $yn_video_list['site'] ;
M('video_list_test')->where("id=$video_id")->setInc('v_really',1);
$adv_list = M("slgj_advert_list")->where("type='片头广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
$adv_list_two = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
$data['adv'] = $adv_list[0];
$data['adv_two'] = $adv_list_two[0];
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'yes';
$data['buy'] = '1';
$data['data'] = $video_list;
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 购买海角视频
* @param $templateid []
* @return $type 消息类型
*/
public function haijiao_video_detail_buy(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$video_id = $_POST['video_id'];
$user_gold_coins = M("user_info")->where("id=$uid")->getField("gold_coins_number");
$video_coins = M('video_list_test')->where("id=$video_id")->getField("coins");
if ($user_gold_coins>=$video_coins){
//给用户扣费
$koufei_hj = M("user_info")->where("id=$uid")->setDec('gold_coins_number',$video_coins); // 用户的积分减5
if ($koufei_hj) {
$buy_hj_record['uid'] = $uid;
$buy_hj_record['v_id'] = $video_id;
$buy_hj_record['time'] = time();
$buy_hj_record['date'] = date("Y-m-d H:i:s",$buy_hj_record['time']);;
$buy_hj_record['coins'] =$video_coins;
$buy_hj_record['type'] ="FC";
M("hj_fc_buy_record")->add($buy_hj_record);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'success';
echo json_encode($data);
}else{
//没有足够金币
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'error';
echo json_encode($data);
}
}else{
//没有足够金币
$data['code'] = '200';
$data['status'] = '3';
$data['message'] = 'no_coins';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 临时
* @param $templateid []
* @return $type 消息类型
*/
public function save_fancha_str(){
if (!empty($_POST)){
$fancha_list = M("heiliao_haijiao_books")->where("book_type='FC'")->field("id,book,book_str")->select();
echo PHP_EOL.M("heiliao_haijiao_books")->_sql();
foreach ($fancha_list as $key => $value) {
$img_str = $value['book'];
$img_id = $value['id'];
$topimg_list = explode(',', $img_str);
echo PHP_EOL.$img_id;
$book_str = '';
foreach ($topimg_list as $key1 => $value1) {
echo PHP_EOL.$value1.'*';
$book_str .= "
" ;
}
$fancha_list['book_str'] = $book_str;
M("heiliao_haijiao_books")->where("id=$img_id")->save($fancha_list);
}
}else{
echo $this->returnData();
}
}
/**
* 临时
* @param $templateid []
* @return $type 消息类型
*/
public function save_fc_coins(){
$data = $this->returnData();
if (!empty($_POST)){
$fancha_list = M('video_list_test')->where("site='FC'")->field("id")->select();
foreach ($fancha_list as $key => $value) {
$img_str = $value['book'];
$img_id = $value['id'];
$video_list_detail['coins'] = '2';;
// $video_list_detail['views'] = $this->randFloat(10.1,99);
// $video_list_detail['thumbs_up'] = $this->randFloat(3.1, 9);
M('video_list_test')->where("id=$img_id")->save($video_list_detail);
echo PHP_EOL.'6';
}
}else{
echo $this->returnData();
}
}
/**
* 三大类推荐底部推荐
* 1个欧美+1个日韩+1个动画+1个黑料专区+1个海角社区+2个反差福利+1个信息流广告——如此循环5次结束
* @param $templateid []
* @return $type 消息类型
*/
public function three_type_tuijian(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$oumei_list =M('video_list_test')->where("uploader = '欧美'")->order("rand()")->LIMIT(6)->select();
$yazhou_list =M('video_list_test')->where("uploader = '亚洲'")->order("rand()")->LIMIT(12)->select();
$dongman_list = M('video_list_test')->where("uploader = '动漫' ")->order("rand()")->LIMIT(6)->select();
//$heiliao_list = M('video_list_test')->where("uploader in('户外车震','SWAG','玩偶姐姐','大尺度综艺','SM调教','福利姬','明星换脸','探花大神','麻豆传媒','海角乱伦','黑料吃瓜','厕所偷拍','AV解说','网曝门')")->order("rand()")->LIMIT(6)->select();
//$wangbao_list = M('video_list_test')->where("uploader in('户外车震','SWAG','玩偶姐姐','大尺度综艺','SM调教','福利姬','明星换脸','探花大神','麻豆传媒','海角乱伦','黑料吃瓜','厕所偷拍','AV解说','网曝门')")->order("rand()")->LIMIT(6)->select();
//2024-3-6 修改
$heiliao_type_arr=array('户外车震','SWAG','玩偶姐姐','大尺度综艺','SM调教','福利姬','明星换脸','探花大神','麻豆传媒','海角乱伦','黑料吃瓜','厕所偷拍','AV解说','网曝门');
$heiliao_list = $this->majorCategories($heiliao_type_arr,6);
$wangbao_list = $this->majorCategories($heiliao_type_arr,6);
//反 差
$fancha_list = M('video_list_test')->where("uploader='素人反差'")->order("rand()")->LIMIT(6)->select();
//甜 美萝莉
$tianmei = M('video_list_test')->where("uploader='粉嫩少女'")->order("rand()")->LIMIT(10)->select();
//另 类猎奇
$lieqi = M('video_list_test')->where("uploader='另类猎奇'")->order("rand()")->LIMIT(10)->select();
//雪 白美乳
$xuebai = M('video_list_test')->where("uploader='雪白美乳'")->order("rand()")->LIMIT(4)->select();
//顶臀街射
$dingtun = M("video_list_test")->where("uploader='顶臀街射'")->order("rand()")->LIMIT(4)->select();
$suiji_list = array(
array($fancha_list[0],$fancha_list[1]),
array($tianmei[0],$tianmei[1]),
array($lieqi[0],$lieqi[1]),
array($fancha_list[2],$fancha_list[3]),
array($xuebai[0],$xuebai[1]),
array($lieqi[2],$fancha_list[3]),
array($tianmei[2],$fancha_list[3]),
);
$randomValues = array_rand($suiji_list, 6);
// print_r($randomValues);
$tuijian_video_list = array(
$yazhou_list[0], $yazhou_list[1],$oumei_list[0], $dongman_list[0], $heiliao_list[0], $wangbao_list[0],$suiji_list[$randomValues[0]],$suiji_list[$randomValues[3]],
$yazhou_list[2],$yazhou_list[3], $oumei_list[1], $dongman_list[1], $heiliao_list[1], $wangbao_list[1],$suiji_list[$randomValues[1]],$suiji_list[$randomValues[4]],
$yazhou_list[4],$yazhou_list[5], $oumei_list[2], $dongman_list[2], $heiliao_list[2], $wangbao_list[2], $suiji_list[$randomValues[2]],$suiji_list[$randomValues[5]],
);
if (!empty($tuijian_video_list)) {
$data['message'] = 'ok';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 8;
$qishi_num = 0;
$data_list_number = count($tuijian_video_list);
$quzheng_num = floor($data_list_number / 8);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($tuijian_video_list, $jia_num, 0, $charu_array);
$jia_num += 9;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
return $tuijian_video_list;
}else{
echo $this->returnData();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function sanday_test(){
$todayTimestamp = time(); // 获取当前时间戳
$threeDaysAgoTimestamp = strtotime('-3 days', $todayTimestamp); // 获取三天前的时间戳
$startDate = strtotime('midnight', strtotime('-3 days', $todayTimestamp)); // 获取三天前的0点时间戳
$endDate = strtotime('23:59:59', strtotime('-1 day', $todayTimestamp)); // 获取前天的23:59:59时间戳
echo "起始时间戳: $startDate\n";
echo "结束时间戳: $endDate\n";
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function save_info_test_new(){
$eua_list = M('video_info_test')->where("video_url like '%https://msp.slgj688.com%' and uploader='亚洲'")->field("video_id,site,video_url")->select();
foreach ($eua_list as $key => $value) {
$video_url = $value['video_url'];
$site = $value['site'];
$vid = $value['video_id'];
$fenge_list = array_slice(explode('/',$video_url),-2);
if ($site == 'Anime') {
$new_url = 'https://www.w29oeq2xltw5evwp5e4.vip/Anime/'.$fenge_list[0].'/'.$fenge_list[1];
} elseif ($site == 'EUA') {
$new_url = 'https://www.w29oeq2xltw5evwp5e4.vip/EUA/'.$fenge_list[0].'/'.$fenge_list[1];
}elseif ($site == 'Asian') {
//https://look.slgj688.com/videos/hanxiucao/23088/23088.m3u8
$new_video_url = str_replace("https://msp.slgj688.com", "https://home.bxdva5aa9xlbuvm863.top/msp", $video_url);
echo PHP_EOL.$new_video_url;
// exit;
}
echo PHP_EOL.$new_url;
$new_list_url['video_url'] =$new_video_url ;
$new_list_url['url'] ='1' ;
M('video_info_test')->where("video_id=$vid")->save($new_list_url);
// exit();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function save_look_url(){
$select_heiliao_list = M("heiliao_haijiao_books")->where("hj_video_url like '%look%' or head_img like '%look%' or book like '%look%'")->field("id,hj_video_url,head_img")->select();
// echo PHP_EOL.M("heiliao_haijiao_books")->_sql();
foreach ($select_heiliao_list as $key => $value) {
$hj_video_url = $value['hj_video_url'];
$head_img = $value['head_img'];
$book = $value['book'];
$id= $value['id'];
$new_hj_video_url = str_replace("https://look.slgj688.com", "https://www.5uafocvs4xlibumya2.xyz", $hj_video_url);
$new_head_img = str_replace("https://look.slgj688.com", 'https://www.5uafocvs4xlibumya2.xyz' , $head_img);
$new_book = str_replace("https://look.slgj688.com", 'https://www.5uafocvs4xlibumya2.xyz', $book);
echo PHP_EOL.$id;
echo PHP_EOL.$new_hj_video_url;
echo PHP_EOL.$new_head_img;
echo PHP_EOL.$new_book;
$new_url_look_list['hj_video_url'] = $new_hj_video_url;
$new_url_look_list['head_img'] = $new_head_img;
$new_url_look_list['book'] = $new_book;
M("heiliao_haijiao_books")->where("id=$id")->save($new_url_look_list);
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function save_book_str_url(){
$select_heiliao_list = M("heiliao_haijiao_books")->where("book_str like '%look%' ")->field("id,hj_video_url,book_str")->select();
// echo PHP_EOL.M("heiliao_haijiao_books")->_sql();
foreach ($select_heiliao_list as $key => $value) {
$book_str = $value['book_str'];
$id= $value['id'];
$new_hj_video_url = str_replace("https://look.slgj688.com", "https://www.5uafocvs4xlibumya2.xyz", $book_str);
echo PHP_EOL.$id;
echo PHP_EOL.$new_hj_video_url;
$new_url_look_list['book_str'] = $new_hj_video_url;
M("heiliao_haijiao_books")->where("id=$id")->save($new_url_look_list);
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function savevideo_list_img_look(){
$select_heiliao_list = M('video_list_test')->where("top_img like '%www.slgj688.com%'")->field("id,top_img")->select();
foreach ($select_heiliao_list as $key => $value) {
$id= $value['id'];
$top_img= $value['top_img'];
// /home2/imgs/www
$new_top_img = str_replace("https://www.slgj688.com/imgs", "https://www.5uafocvs4xlibumya2.xyz/imgs/www", $top_img);
$new_url_look_list['top_img'] = $new_top_img;
M('video_list_test')->where("id=$id")->save($new_url_look_list);
echo PHP_EOL.M('video_list_test')->_sql();
// exit();
}
}
/**
* 测试功能
* @param $templateid []
* @return $type 消息类型
*/
public function testbaohan(){
$string = "Hello, World!";
$find = "World1";
$position = strpos($string, $find);
if ($position !== false) {
echo "有";
} else {
echo "没有";
}
}
/**
* 1.7 新增意见反馈
* @param $templateid []
* @return $type 消息类型
*/
public function add_user_yijianfankui(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$content = $_POST['content'];
$time_chuo = time();
$time_data= date("Y-m-d H:i",$time_chuo);
$time_date = $time_data;
$add_list['uid'] =$uid;
$add_list['user_content'] =$content;
$add_list['user_time'] =$time_chuo;
$add_list['user_date'] =$time_date;
$add_time_chuo = M("user_info")->where("id=$uid")->getField("add_time");;
$add_list['zhuce_time'] = date("Y-m-d H:i:s",$add_time_chuo);
$add_list['user_name'] =M("user_info")->where("id=$uid")->getField("name");;
$add_list['type'] ='1';
$yn_add = M("user_fankui")->add($add_list);
if ($yn_add) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'error';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 1.7 反馈列表
* @param $templateid []
* @return $type 消息类型
*/
public function user_yijianfankui_list(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$fankui_list = M("user_fankui")->where("uid=$uid")->field("user_content,user_date,type,admin_content,admin_date")->group("user_time desc")->select();
foreach ($fankui_list as $key => $value) {
$fankui_type = $value['type'];
$user_content = $value['user_content'];
$user_date = $value['user_date'];
$admin_content = $value['admin_content'];
$admin_date= $value['admin_date'];
switch ($fankui_type) {
case '1':
$fankui_type_str = '待回复';
break;
case '2':
$fankui_show_list[$key]['admin_content'] =$admin_content;
$fankui_show_list[$key]['admin_date'] = $admin_date;
$fankui_type_str = '已回复';
break;
default:
$fankui_type_str = '异常';
break;
}
$fankui_show_list[$key]['user_content'] =$user_content;
$fankui_show_list[$key]['user_date'] = $user_date;
$fankui_show_list[$key]['fankui_type'] = $fankui_type_str;
}
if ($fankui_show_list) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = '';
$data['data'] = $fankui_show_list;
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'null';
$data['data'] = "";
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 1.7新增
* 收藏页各个类型数量
* @param $templateid []
* @return $type 消息类型
*/
public function shoucang_type_number(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$anytype_count = M("video_shoucang")->where("uid=$uid")->field("video_type,count(*) as count")->group('vid')->group('video_type')->ORDER('count DESC')->select();
$free_number = 0;
$wb_number = 0;
$hl_number = 0;
$fc_number = 0;
$hj_number = 0;
$madou_number = 0;
$tanhua_number=0;
$ai_number=0;
$linglei_number=0;
$meiru_number=0;
$sm_number=0;
$wanou_number=0;
$avjieshuo_number=0;
$luoli_number=0;
foreach ($anytype_count as $key => $value) {
$vtype = $value['video_type'];
$vconunt = $value['count'];
switch ($vtype) {
case '动漫':
$free_number += $vconunt;
break;
case '亚洲':
$free_number += $vconunt;
break;
case '欧美':
$free_number += $vconunt;
break;
case '网曝门':
$wb_number += $vconunt;
break;
case '黑料吃瓜':
$hl_number += $vconunt;
break;
case '素人反差':
$fc_number += $vconunt;
break;
case '海角乱伦':
//海角乱伦
$hj_number+= $vconunt;
break;
case '麻豆传媒':
//麻豆传媒
$madou_number+= $vconunt;
break;
case '国产探花':
//探花大神
$tanhua_number+= $vconunt;
break;
case '探花大神':
//探花大神
$tanhua_number+= $vconunt;
break;
case 'AI':
//明星换脸
$ai_number+= $vconunt;
break;
case '孕妇做爱':
//另类猎奇 孕妇
$linglei_number+= $vconunt;
break;
case '另类猎奇':
//另类猎奇 猎奇
$linglei_number+= $vconunt;
break;
case '人兽动物':
//另类猎奇 人兽
$linglei_number+= $vconunt;
break;
case '性感人妖':
//另类猎奇 人妖
$linglei_number+= $vconunt;
break;
case '同性做爱':
//另类猎奇 同性
$linglei_number+= $vconunt;
break;
case '超级大胆':
//另类猎奇 超级大胆
$linglei_number+= $vconunt;
break;
case '雪白美乳':
$meiru_number+= $vconunt;
//雪白美乳
break;
case 'SM调教':
$sm_number+= $vconunt;
//SM调教
break;
case '玩偶姐姐':
$wanou_number+= $vconunt;
//玩偶姐姐
break;
case 'AV解说':
$avjieshuo_number+= $vconunt;
//av解说
break;
case '制服学妹':
$luoli_number+= $vconunt;
//超级大胆
break;
case '马尾学妹':
$luoli_number+= $vconunt;
//超级大胆
break;
case '后入嫩穴':
$luoli_number+= $vconunt;
//超级大胆
break;
case '超级巨臀':
$luoli_number+= $vconunt;
//超级大胆
break;
case '美臀翘臀':
$luoli_number+= $vconunt;
//超级大胆
break;
case '粉嫩少女':
$luoli_number+= $vconunt;
//超级大胆
break;
case '明星换脸':
$ai_number+= $vconunt;
//超级大胆
break;
default:
}
}
$all_type_number['免费专区'] ="$free_number";
$all_type_number['网曝门'] = "$wb_number";
$all_type_number['素人反差']= "$fc_number";
$all_type_number['黑料吃瓜']="$hl_number";
$all_type_number['海角乱伦']="$hj_number";
$all_type_number['麻豆传媒']="$madou_number";
$all_type_number['探花大神']="$tanhua_number";
$all_type_number['明星换脸']="$ai_number";
$all_type_number['另类猎奇']="$linglei_number";
$all_type_number['雪白美乳']="$meiru_number";
$all_type_number['SM调教']="$sm_number";
$all_type_number['玩偶姐姐']="$wanou_number";
$all_type_number['AV解说']="$avjieshuo_number";
$all_type_number['粉嫩少女']="$luoli_number";
//排序
//asort($all_type_number);
arsort($all_type_number);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $all_type_number;
echo json_encode($data);
}else{
echo PHP_EOL.'122';
echo $this->returnData();
}
}
/**
* 1.7新增 收藏详情-
* @param $templateid []
* @return $type 消息类型
*/
public function shoucang_type_list(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$vtype = $_POST['v_type'];
$uid = $_POST['uid'];
$page = $_POST['page'];
$size = 30;
switch ($vtype) {
case '免费专区':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type in ('动漫','欧美','亚洲')")->Field("vid,time")->group('vid')->order("id desc")->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type in ('动漫','欧美','亚洲')")->count();
break;
case '黑料吃瓜':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='黑料吃瓜'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='黑料吃瓜'")->count();
break;
case '网曝门':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='网曝门'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='网曝门'")->count();
break;
case '素人反差':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='素人反差'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='素人反差'")->count();
break;
case '海角乱伦':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='海角乱伦'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='海角乱伦'")->count();
break;
case '麻豆传媒':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='麻豆传媒'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='麻豆传媒'")->count();
break;
case '探花大神':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='探花大神'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='探花大神'")->count();
break;
//ai换脸
case '明星换脸':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='明星换脸'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='明星换脸'")->count();
break;
case '另类猎奇':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type in ('另类猎奇')")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type in ('另类猎奇')")->count();
break;
case '雪白美乳':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='雪白美乳'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='雪白美乳'")->count();
break;
case 'SM调教':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='SM调教'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='SM调教'")->count();
break;
case '玩偶姐姐':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='玩偶姐姐'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='玩偶姐姐'")->count();
break;
case 'AV解说':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type='AV解说'")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type='AV解说'")->count();
break;
case '粉嫩少女':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type in ('粉嫩少女')")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type in ('粉嫩少女')")->count();
break;
case '素人反差':
$duifang_id_list = M("video_shoucang")->where("uid=$uid and video_type in ('素人反差')")->Field("vid,time")->group('vid')->order("id desc")->page($page, $size)->select();
$duifang_id_list_num = M("video_shoucang")->where("uid=$uid and video_type in ('素人反差')")->count();
break;
default:
echo "type error";
}
//插入sql语句 的限制条件
//视频
//插入sql语句 的限制条件
if (!$duifang_id_list_num) {
$duifang_id_list_num = 0;
}
foreach ($duifang_id_list as $key => $value) {
# code...
$duifang_id = $value['vid'];
if (!$duifang_id) {
$duifang_id = 0;
}
$xianzhi_one = " or id=$duifang_id";
$sql_charu .= $xianzhi_one;
}
$wula_video = M('video_list_test')->where("id='' $sql_charu")->select();
foreach ($wula_video as $key1 => $value1) {
$id = $value1['id'];
$suozai_num = array_search($id, $duifang_id_list);
$wula_video[$key1]['time'] = $duifang_id_list[array_search("$id",array_column($duifang_id_list, 'vid'))]['time'];
}
array_multisort(array_column($wula_video, 'time'), SORT_DESC, $wula_video);
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$c = $wula_video;
$jia_num = 6;
$qishi_num = 0;
$data_list_number = count($c);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($c, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['message'] = 'ok';
$data['data'] = $c;
$data['all_num'] = $duifang_id_list_num;
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 金币专区
* @param $templateid []
* @return $type 消息类型
*/
public function jinbi_zhuanqu_list(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$yn_jinbi_list =M("jinbi_list_yn")->where("uid=$uid")->select();
if ($yn_jinbi_list) {
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $yn_jinbi_list;
echo json_encode($data);
}else{
$user_jinbi_yn['fancha'] = 0;
$user_jinbi_yn['sm'] =0;
$user_jinbi_yn['wanou'] = 0;
$user_jinbi_yn['av'] = 0;
$user_jinbi_yn['louli'] = 0;
$user_jinbi_yn['uid'] = $uid;
M("jinbi_list_yn")->add($user_jinbi_yn);
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $user_jinbi_yn;
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 金币专区项目开通
* 购买后修改 bb_jinbi_list_yn 表
* 添加购买记录
* @param $templateid []
* @return $type 消息类型
* //素人反差——18
* //SM调教——18
* //玩偶姐姐——22
* //AV解说——22
* //粉嫩少女——28
*/
public function jinbi_list_kaitong(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid =$_POST['uid'];
$type = $_POST['type'];
$yn_jinbi_list =M("jinbi_list_yn")->where("uid=$uid")->field("fancha,sm,wanou,av,luoli")->select();
if (!$yn_jinbi_list) {
$user_jinbi_yn['fancha'] = 0;
$user_jinbi_yn['sm'] = 0;
$user_jinbi_yn['wanou'] = 0;
$user_jinbi_yn['av'] = 0;
$user_jinbi_yn['louli'] = 0;
//抄底偷拍——28 新
$user_jinbi_yn['chaodi'] = 0;
//顶臀街射——28 新
$user_jinbi_yn['dingtun'] = 0;
//另类猎奇——28 新
$user_jinbi_yn['lieqi'] = 0;
//色情小说——22 新
$user_jinbi_yn['xiaoshuo'] = 0;
//——28. 新
$user_jinbi_yn['cesuo'] = 0;
//网爆——28. 新
$user_jinbi_yn['wangbao'] = 0;
$user_jinbi_yn['uid'] = $uid;
M("jinbi_list_yn")->add($user_jinbi_yn);
}
switch ($type) {
// 网爆门——25
// AV解说——25
// 抄底偷拍——28 新
// 粉嫩少女——25
// 顶臀街射——28 新
// 另类猎奇——28 新
// 素人反差——28
// 色情小说——22 新
// 厕所偷拍——28. 新
case '素人反差':
$type_name = 'fancha';
$gold=28;
break;
case '网曝门':
$type_name = 'wangbao';
$gold=25;
break;
case '粉嫩少女':
$type_name= 'luoli';
$gold=25;
break;
case 'AV解说':
$type_name= 'av';
$gold=25;
break;
case '抄底偷拍':
$type_name= 'chaodi';
$gold=28;
break;
case '顶臀街射':
$type_name= 'dingtun';
$gold=28;
break;
case '另类猎奇':
$type_name= 'lieqi';
$gold=28;
break;
case '色情小说':
$type_name= 'xiaoshuo';
$gold=22;
break;
case '厕所偷拍':
$type_name= 'cesuo';
$gold=28;
break;
default:
echo "type error";
}
$huiyuan_time_list =M("user_info")->where("id=$uid")->field("vip_over_time,vip_yn,gold_coins_number")->select();
$user_gold_coins= $huiyuan_time_list[0]['gold_coins_number'];
$now_time = time();
//不是会员判断是否有足够余额来
if ($user_gold_coins>=$gold){
$user_vip_fufei = M('user_info')->where("id=$uid")->setDec('gold_coins_number', $gold);
if (!$user_vip_fufei) {
$data['message'] = '付费失败结束';
echo json_encode($data);
die();
}else{
$time_chuo = time();
$time_data= date("Y-m-d H:i",$time_chuo);
$time_date = $time_data;
$buy_record_goldvideo['uid'] = $uid;
$buy_record_goldvideo['time'] =$time_chuo ;
$buy_record_goldvideo['date'] = $time_date;
$buy_record_goldvideo['coins'] = $gold;
$buy_record_goldvideo['type'] = $type_name;
$save_gold_type_yn["$type_name"] = '1';
M("hj_fc_buy_record")->add($buy_record_goldvideo);
M("jinbi_list_yn")->where("uid=$uid")->save($save_gold_type_yn);
$data['code'] = '200';
$data['status'] = '2';
$data['message'] = 'ok';
echo json_encode($data);
}
}else{
$data['code'] = '200';
$data['status'] = '3';
$data['coins'] = 'no_coins';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 版本:
* 新增/更新:
* 简述:
* @param $templateid []
* @return $type 消息类型
*/
public function get_user_acount_password(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$user_info_list = M("user_info")->where("id=$uid")->field("name,password")->select();
if ($user_info_list){
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $user_info_list;
echo json_encode($data);
}else{
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'error';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 版本:
* 新增/更新:
* 简述:
* @param $templateid []
* @return $type 消息类型
*/
public function rand_three_type(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uploader= $_POST['uploader'];
$all_typearray = array(
//uploader!
"黑料吃瓜"=>"HL",
"海角乱伦"=>"HJ",
"麻豆传媒"=>"麻豆传媒",
"探花大神"=>"国产探花",
"网曝门"=>"WB",
"明星换脸"=>"AI",
"另类猎奇"=>"另类猎奇",
"雪白美乳"=>"雪白美乳",
"素人反差"=>"FC",
"SM调教"=>"SM调教",
"玩偶姐姐"=>"玩偶姐姐",
"AV解说"=>"AV解说",
"厕所偷拍"=>"超级大胆",
"抄底偷拍"=>"超级大胆",
"顶臀街射"=>"超级大胆",
"福利姬"=>"超级大胆",
"大尺度综艺"=>"超级大胆",
"SWAG"=>"超级大胆",
"户外车震"=>"超级大胆",
"粉嫩少女"=>"粉嫩少女",
);
//麻豆传媒
$all_typearray=array_diff_key($all_typearray,["$uploader"=>'1']);
// 从数组中随机取3个键
$randomKeys = array_rand($all_typearray, 3);
// 通过随机键获取相应的键值对
$randomKeyValuePairs = array();
foreach ($randomKeys as $key) {
$randomKeyValuePairs[$key] = $all_typearray[$key];
}
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $randomKeyValuePairs;
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.7
* 新增/更新:公告展示
* 简述:
* @param $templateid []
* @return $type 消息类型
*/
public function show_gonggao(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
$gonggao_show = M("gonggao")->where("id>0")->order("rand()")->select();
$data['code'] = '200';
$data['status'] = '1';
$data['message'] = 'ok';
$data['data'] = $gonggao_show;
echo json_encode($data);
}
/**
* 版本:
* 新增/更新:
* 简述:
* @param $templateid []
* @return $type 消息类型
*/
public function rand_three_type_video_list()
{
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Contr-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)) {
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = 1;
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jiben = $_POST['jiben_type'];
switch ($type) {
// 美乳
case '福利姬':
$id_list = M('video_list_test')->where("uploader='福利姬'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 美乳
case '大尺度综艺':
$id_list = M('video_list_test')->where("uploader='大尺度综艺'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 美乳
case 'SWAG':
$id_list = M('video_list_test')->where("uploader='SWAG'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 美乳
case '户外车震':
$id_list = M('video_list_test')->where("uploader='户外车震'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
case '厕所偷拍':
$one_size = 60;
$six = 0;
$id_list = M('video_list_test')->where("uploader='厕所偷拍'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 6;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
die();
break;
case '抄底偷拍':
$one_size = 60;
$six = 0;
$id_list = M('video_list_test')->where("uploader='抄底偷拍'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 6;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
die();
break;
case '顶臀街射':
$one_size = 60;
$six = 0;
$id_list = M('video_list_test')->where("uploader='顶臀街射'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 6;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
die();
break;
case '厕所偷拍':
$one_size = 60;
$six = 0;
$id_list = M('video_list_test')->where("uploader='厕所偷拍'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 12;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 12);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 13;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
die();
break;
//乱伦
case '色情小说':
$id_list = M('novel_list')->where("id>0")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
case 'remen':
//获取该获取那天的数据
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("time='$jintian'")->LIMIT($page_one, $one_size)->order('rand()')->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("time='$jintian'")->count();
$data['code'] = '200';
break;
//推荐1
case '欧美':
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['num'] = count($new_twotwo_list);
echo json_encode($data);
die();
//动漫1列表
case '动漫':
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['num'] = count($new_twotwo_list);
echo json_encode($data);
die();
break;
//热搜亚洲1
case '亚洲':
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['num'] = count($new_twotwo_list);
echo json_encode($data);
die();
break;
//黑料
case '黑料吃瓜':
$id_list = M('video_list_test')->where("site='HL'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['all_num'] =0;
$data['code'] = '200';
break;
// //海角
// case '海角乱伦':
//
// $id_list = M('video_list_test')->where("uploader='海角乱伦'")->order("rand()")->LIMIT($page_one, $one_size)->select();
// $data['all_num'] =0;
// $data['code'] = '200';
// break;
//反差
case '素人反差':
$one_size = 60;
$six = 0;
$id_list = M('video_list_test')->where("uploader='素人反差'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 12;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 12);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 13;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
die();
break;
//乱伦
case '海角乱伦':
$id_list = M('video_list_test')->where("uploader='海角乱伦'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
//乱伦
case '网曝门':
$id_list = M('video_list_test')->where("uploader='网曝门'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
//麻豆
case '麻豆传媒':
$id_list = M('video_list_test')->where("uploader='麻豆传媒'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 探花
case '探花大神':
$id_list = M('video_list_test')->where("uploader='探花大神'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 换脸
case '明星换脸':
$id_list = M('video_list_test')->where("uploader='明星换脸'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 猎奇
case '另类猎奇':
//lq_type:孕妇:yunfu
// 猎奇:lieqi
// 人兽:renshou
// 人妖:renyao
// 同性:tongxing
// 伪娘:weiniang
//
//孕妇做爱
//另类猎奇
//人兽动物
//性感人妖
//同性做爱
//超级大胆
//
$id_list = M('video_list_test')->where("uploader='另类猎奇'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 美乳
case '雪白美乳':
$id_list = M('video_list_test')->where("uploader='雪白美乳'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// SM
case 'SM调教':
$id_list = M('video_list_test')->where("uploader='SM调教'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 玩偶
case '玩偶姐姐':
$id_list = M('video_list_test')->where("uploader='玩偶姐姐'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// av解说
case 'AV解说':
$id_list = M('video_list_test')->where("uploader='AV解说'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
break;
// 粉嫩少女
case '粉嫩少女':
$one_size = 60;
$id_list = M('video_list_test')->where("uploader='粉嫩少女'")->order("rand()")->LIMIT($page_one, $one_size)->select();
$data['code'] = '200';
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 12;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 12);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 13;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
die();
break;
break;
default:
echo "type error";
}
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = 6;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / 6);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += 7;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
$data['data'] = $id_list;
echo json_encode($data);
} else {
echo $this->returnData();
}
}
/**
* 版本:
* 新增/更新:
* 简述:
* @param $templateid []
* @return $type 消息类型
*/
public function watch_goldvideo_yn(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid=$_POST['uid'];
$site = $_POST['type'];
switch ($site) {
case '粉嫩少女':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("luoli");
break;
case '马尾学妹':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("luoli");
break;
case '后入嫩穴':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("luoli");
break;
case '美臀翘臀':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("luoli");
break;
case '超级巨臀':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("luoli");
break;
case 'AV解说':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("av");
break;
case '玩偶姐姐':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("wanou");
break;
case 'SM调教':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("sm");
break;
case '素人反差':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("fancha");
break;
case '抄底偷拍':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("chaodi");
break;
case '顶臀街射':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("dingtun");
break;
case '另类猎奇':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("lieqi");
break;
case '色情小说':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("xiaoshuo");
break;
case '厕所偷拍':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("cesuo");
break;
case '网曝门':
$watch = M("jinbi_list_yn")->where("uid=$uid")->getField("wangbao");
break;
default:
echo "type error";
}
if ($watch==1){
$data['message'] = 'ok';
echo json_encode($data);
}else{
$data['message'] = 'no';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:view_video_two
* 观看第二个视频
* @param $templateid []
* @return $type 消息类型
*/
public function new_user_view_two(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
//now_time
$now_time = time();
$user_views =M("user_info")->where("id=$uid")->field("views_num,vip_money")->select();
$view_num = $user_views[0]['views_num'];
$vip = $user_views[0]['vip_money'];
if ($view_num==2 and $vip==0){
$data['message'] = 'ok';
echo json_encode($data);
}else{
$data['message'] = 'nothing';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:小说列表
* @param $templateid []
* @return $type 消息类型
*/
public function xiaoshuo_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 100;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='色情小说' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'xiaoshuo');
$id_list =$this->adv_in_video_list($id_list,'xiaoshuo');
$data['all_num'] = M("video_twelve_suiji")->where("type='色情小说' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:福利姬列表
* @param $templateid []
* @return $type 消息类型
*/
public function fuliji_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='福利姬' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='福利姬' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:户外车震列表
* @param $templateid []
* @return $type 消息类型
*/
public function chezhen_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='户外车震' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='户外车震' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:SWAG列表
* @param $templateid []
* @return $type 消息类型
*/
public function swag_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='SWAG' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='SWAG' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:列表必须
* @param $templateid []
* @return $type 消息类型
*/
public function list_must_function($video_list_suiji_list,$list_type){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (count($video_list_suiji_list)<5){
$new_twotwo_list= $this-> three_type_tuijian();
$data['data'] = $new_twotwo_list;
$data['num'] = count($video_list_suiji_list);
echo json_encode($data);
die();
}
$id_list = array_column($video_list_suiji_list, 'v_id');
$sql_charu = "";
foreach ($video_list_suiji_list as $key1 => $value1) {
$duifang_id = $value1['v_id'];;
$xianzhi_one = " or id='$duifang_id'";
$sql_charu .= $xianzhi_one;
}
switch ($list_type) {
case 'default':
$video_list = M('video_list_test')->where("id=0 $sql_charu")->select();
break;
case 'xiaoshuo':
$video_list = M('novel_list')->where("id=0 $sql_charu")->select();
break;
default:
echo "type error";
}
//牛逼
foreach ($video_list as $key => $value) {
$id = $value['id'];
$suozai_num = array_search("$id", $id_list);
$id_list[$suozai_num] = $value;
}
return $id_list;
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:分配广告
* @param $templateid []
* @return $type 消息类型
*/
public function adv_in_video_list($id_list,$adv_show_type){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
switch ($adv_show_type) {
case 'default':
$start_number = 6;
$adv_number = 7;
break;
case 'xiaoshuo':
$start_number = 20;
$adv_number = 21;
break;
case 'tuijian':
break;
case 'other':
break;
case 'jing':
$start_number = 8;
$adv_number = 9;
break;
default:
$start_number = 6;
$adv_number = 7;
break;
}
//获取广告列表
$adv_list = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(12)->select();
$adv_list = array($adv_list[0],$adv_list[1],$adv_list[2],$adv_list[3],$adv_list[4],$adv_list[5],$adv_list[6],$adv_list[7],$adv_list[8],$adv_list[9],$adv_list[10],$adv_list[11]);
$jia_num = $start_number;
$qishi_num = 0;
$data_list_number = count($id_list);
$quzheng_num = floor($data_list_number / $start_number);
foreach ($adv_list as $key => $value) {
$charu_array = array();
$charu_array = array($adv_list[$key]);
array_splice($id_list, $jia_num, 0, $charu_array);
$jia_num += $adv_number;
$qishi_num += 1;
if ($qishi_num >= $quzheng_num) {
break;
}
}
return $id_list;
}
/**
* 版本:
* 新增/更新:
* 简述:小说详情
* @param $templateid []
* @return $type 消息类型
*/
public function xiaoshuo_detail(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
$n_id = $_POST['n_id'];
$site = $_POST['site'];
//判断用户是否是异常用户
//判读是否登录
if ($uid == '0' or $uid == '' or $uid=='undefined') {
$data['message'] = 'error';
echo json_encode($data);
die();
}
//在线
$tttime = time();
$ddate = date("Y-m-d H:i:s",$tttime);
$new_views_num['last_login_time'] =$tttime;
$new_views_num['last_login_date'] =$ddate;
M("user_info")->where("id=$uid")->save($new_views_num);
$xiaoshuo_content = M("novel_info")->where("n_id=$n_id")->getField("content");
$now_zan_num_list = M('novel_list')->where("id=$n_id")->Field("views,thumbs_up")->select();
$dianzan_num =$now_zan_num_list[0]['thumbs_up'];
$guankan_num = $now_zan_num_list[0]['views'];
$adv_list = M("slgj_advert_list")->where("type='片头广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
$adv_list_two = M("slgj_advert_list")->where("type='视频列表广告'")->Field("img,jump_link,number")->order("rand()")->LIMIT(1)->select();
$data['adv'] = $adv_list[0];
$data['adv_two'] = $adv_list_two[0];
$data['views'] = $guankan_num;
$data['thumbs_up'] = $dianzan_num;
$data['data'] = $xiaoshuo_content;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:add
* 简述:资源报错
* @param $templateid []
* @return $type 消息类型
*/
public function error_video_add(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$video_id = $_POST['v_id'];
$uid = $_POST['uid'];
$type = $_POST['uploader'];
$type = $_POST['now_url'];
$ttime = time();
$ddate = date("Y-m-d H:i:s",$ttime);
$yn_yiyou = M("error_videos_list")->where("v_id=$video_id and uid=$uid")->getField("id");
if($yn_yiyou){
$data['message'] = 'error';
echo json_encode($data);
}else{
$_POST['time'] = $ttime;
$_POST['time_date'] = $ddate;
M("error_videos_list")->add($_POST);
$data['message'] = 'ok';
echo json_encode($data);
}
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:抄底偷拍列表
* @param $templateid []
* @return $type 消息类型
*/
public function chaoditoupai_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='抄底偷拍' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='抄底偷拍' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:厕所偷拍列表
* @param $templateid []
* @return $type 消息类型
*/
public function cesuotoupai_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='厕所偷拍' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='厕所偷拍' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:顶臀街射列表
* @param $templateid []
* @return $type 消息类型
*/
public function dingtunjieshe_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='顶臀街射' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='顶臀街射' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 版本:1.8
* 新增/更新:新增
* 简述:顶臀街射列表
* @param $templateid []
* @return $type 消息类型
*/
public function zongyi_list_show(){
header('Content-Type:text/json;charset=utf-8');
header('Access-Control-Allow-Origin:*');
header("Access-Control-Allow-Headers:token,Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods:POST');
header('Access-Control-Expose-Headers:*');
if (!empty($_POST)){
$uid = $_POST['uid'];
if ($uid == '') {
$uid = 0;
}
$type = $_POST['type'];
$page = $_POST['page'];
$one_size = 30;
$page_one = ($page - 1) * $one_size;
$jintian = M("suiji_num")->where("id=1")->getField("time");
//获取今日页数
$video_list_suiji_list = M("video_twelve_suiji")->where("type='大尺度综艺' and time='$jintian'")->LIMIT($page_one, $one_size)->Field('v_id')->select();
$id_list =$this->list_must_function($video_list_suiji_list,'default');
$id_list =$this->adv_in_video_list($id_list,'default');
$data['all_num'] = M("video_twelve_suiji")->where("type='大尺度综艺' and time='$jintian'")->count();
$data['code'] = '200';
$data['data'] = $id_list;
$data['message'] = 'ok';
echo json_encode($data);
}else{
echo $this->returnData();
}
}
/**
* 重构获取书接口
* @param $type_arr
* @param $number
* @return mixed
*/
private function majorCategories($type_arr,$number){
$sql = '';
$len=count($type_arr);
$count=0;
foreach ($type_arr as $k=>$v)
{
$count++;
$sql .= "SELECT * FROM bb_video_list_test WHERE uploader = '$v'";
if($count != $len)
{
$sql .= ' union ';
}
}//end for
if($number>0)
{
$sql .= " ORDER BY rand() LIMIT $number";
}
return M('video_list_test')->query($sql);
}
#end
}
?>