0"; if ($v_commend=="ok") $whereStr.=" and d.v_commend>0"; if ($v_recycled=="ok") $whereStr.=" and d.v_recycled=1"; if ($repeat=="ok") { if($allrepeat=="ok") { $dsql->SetQuery("select v_name from pi_data where v_recycled=0 group by v_name having count(*)>1"); $dsql->Execute('video_have'); $repeatsql=""; while($rowh=$dsql->GetObject('video_have')) { if(!empty($rowh->v_name)) { $repeatsql.="'".$rowh->v_name."',"; } } if(empty($repeatsql)) { showMsg('恭喜,无重复数据','admin_datarelate.php?action=repeat'); exit(); }else { $whereStr .= " and d.v_name in (".rtrim($repeatsql,',').")"; } }else { $dsql->SetQuery("select substring(v_name,1,$rlen) as v_name from pi_data where v_recycled=0 group by substring(v_name,1,$rlen) having count(*)>1"); $dsql->Execute('video_have'); $repeatsql=""; while($rowh=$dsql->GetObject('video_have')) { if(!empty($rowh->v_name)) { $repeatsql.="or d.v_name like '$rowh->v_name%' "; } } $whereStr.=rtrim(" and 1=2 or ".ltrim($repeatsql,"or"),"or "); } } if ($empty=="ok") { $whereStr.=" and p.body =''"; } if (!empty($type)) $whereStr.=" and d.tid in (".getTypeId($type).")"; if (!empty($etype)) $whereStr.=" and d.tid in (".getTypeId($etype).")"; if (!empty($topic)) $whereStr.=" and d.v_topic =".$topic; if (!empty($keyword)) $whereStr.=" and d.v_name like '%".$keyword."%' or d.v_actor like '%".$keyword."%' "; if (!empty($playfrom)) $whereStr.=" and p.body like '%".$playfrom."$$%' "; if (!empty($etype)) $whereStr.=" or FIND_IN_SET('".getTypeId($etype)."',d.v_extratype)<>0"; $whereorder = str_replace("where order","order",str_replace("where and","and",$whereStr.$orderStr)); //计算有多少条数据 $csqlStr="select count(*) as dd from `pi_data` d left join `pi_playdata` p on p.v_id=d.v_id where d.v_recycled=0 ".$whereorder; if ($v_recycled=="ok")$csqlStr="select count(*) as dd from `pi_data` d left join `pi_playdata` p on p.v_id=d.v_id where d.v_recycled=1 ".$whereorder; $row = $dsql->GetOne($csqlStr); if(is_array($row)){ $TotalResult = $row['dd']; }else{ $TotalResult = 0; } $TotalPage = ceil($TotalResult/$numPerPage); if ($page>$TotalPage) $page=$TotalPage; $limitstart = ($page-1) * $numPerPage; if($limitstart<0) $limitstart=0; $sqlStr="select d.v_pic,d.v_isunion,d.v_id,d.v_name,d.v_hit,0,d.v_state,d.tid,d.v_topic,d.v_addtime,d.v_enname,d.v_commend,p.body as v_playdata,t.tname from pi_data d left join `pi_type` t on t.tid=d.tid left join `pi_playdata` p on p.v_id=d.v_id where d.v_recycled=0 ".$whereorder." limit $limitstart,$numPerPage"; if ($v_recycled=="ok") $sqlStr="select d.v_pic,d.v_isunion,d.v_id,d.v_name,d.v_enname,d.v_hit,0,d.v_state,d.tid,d.v_topic,d.v_addtime,d.v_commend,p.body as v_playdata,t.tname from pi_data d left join `pi_type` t on t.tid=d.tid left join `pi_playdata` p on p.v_id=d.v_id where 1=1 ".$whereorder." limit $limitstart,$numPerPage"; $jumpurl = "&order=$order&type=$type&etype=$etype&keyword=$keyword&v_state=$v_state&v_commend=$v_commend&repeat=$repeat&allrepeat=$allrepeat&topic=$topic&playfrom=$playfrom&empty=$empty&rlen=$rlen"; ?>
"; } }else{ if(!empty($keyword)){ ?> SetQuery($sqlStr); $dsql->Execute('video_list'); while($row=$dsql->GetObject('video_list')) { $v_id=$row->v_id; $contentUrl=getContentLink($row->tid,$v_id,"",date('Y-n',$row->v_addtime),$row->v_enname); $fromstr=getFromStr($row->v_playdata); ?>
 数据管理 -回收站 (下载所有资源站图片到本地)*请注意水印开关,下载后无法返回 图片管理
 关键字   
关键字 \"".$keyword."\" 没有记录
关键字 的记录如下
 ID 标题 图片位置 人气 来源 数据类别 专题 推荐星级 时间 生成 操作
v_name;?> v_state; if($vstate==0){echo "";}else{echo "($vstate)";}?> v_pic,'uploads/')===0)echo "本地";elseif(strpos($row->v_pic,$app_ftpurl)!==false)echo "FTP服务器";elseif(strpos($row->v_pic,'#err')!==false)echo "下载图片时发生错误";elseif(empty($row->v_pic) )echo "空";else echo "资源站"; ?> v_hit;?> tname){echo $row->tname;}else{echo "数据分类错误";}?> v_topic; if($v_topic==0){ echo "";}else{ echo "";}?> v_addtime);?> 编辑 删除 v_isunion=='0'?'锁定':'解锁' ?>
 全选 反选
 页次:/ 每页 总收录数据首页 上一页 下一页 尾页  跳转   
 页次:/ 每页 总收录数据首页 上一页 下一页 尾页  跳转