function sys_ReturnBqQuery($classid, $line, $enews = 0, $do = 0, $ewhere = '', $eorder = '') { global $empire, $public_r, $class_r, $class_zr, $navclassid, $do_openbqquery, $dbtbpre, $fun_r, $class_tr, $emod_r, $etable_r, $eyh_r; if ($enews == 24 && $do_openbqquery == 1) { $query_first = substr($classid, 0, 7); if (!($query_first == 'select ' || $query_first == 'SELECT ')) { return ""; } $classid = RepSqlTbpre($classid); $sql = $empire->query1($classid); if (!$sql) { echo "SQL Error: " . ReRepSqlTbpre($classid); } return $sql; } if ($enews == 0 || $enews == 1 || $enews == 2 || $enews == 9 || $enews == 12 || $enews == 15) { if (strstr($classid, ',')) { $son_r = sys_ReturnMoreClass($classid, 1); $classid = $son_r[0]; $where = $son_r[1]; } else { if ($classid == 'selfinfo') { $classid = $navclassid; } if ($class_r[$classid][islast]) { $where = "classid='{$classid}'"; } else { $where = ReturnClass($class_r[$classid][sonclass]); } } $tbname = $class_r[$classid][tbname]; $mid = $class_r[$classid][modid]; $yhid = $class_r[$classid][yhid]; } elseif ($enews == 6 || $enews == 7 || $enews == 8 || $enews == 11 || $enews == 14 || $enews == 17) { if (strstr($classid, ',')) { $son_r = sys_ReturnMoreZt($classid); $classid = $son_r[0]; $where = $son_r[1]; } else { if ($classid == 'selfinfo') { $classid = $navclassid; } $where = "ztid like '%|" . $classid . "|%'"; } $tbname = $class_zr[$classid][tbname]; $mid = $etable_r[$tbname][mid]; $yhid = $class_zr[$classid][yhid]; } elseif ($enews == 25 || $enews == 26 || $enews == 27 || $enews == 28 || $enews == 29 || $enews == 30) { if (strstr($classid, ',')) { $son_r = sys_ReturnMoreTT($classid); $classid = $son_r[0]; $where = $son_r[1]; } else { $where = "ttid='{$classid}'"; } $mid = $class_tr[$classid][mid]; $tbname = $emod_r[$mid][tbname]; $yhid = $class_tr[$classid][yhid]; } if ($enews == 0) { $query = '(' . $where . ') and checked=1'; $order = 'newstime'; $yhvar = 'bqnew'; } elseif ($enews == 1) { $query = '(' . $where . ') and checked=1'; $order = 'onclick'; $yhvar = 'bqhot'; } elseif ($enews == 2) { $query = '(' . $where . ') and isgood>0 and checked=1'; $order = 'newstime'; $yhvar = 'bqgood'; } elseif ($enews == 9) { $query = '(' . $where . ') and checked=1'; $order = 'plnum'; $yhvar = 'bqpl'; } elseif ($enews == 12) { $query = '(' . $where . ') and firsttitle>0 and checked=1'; $order = 'newstime'; $yhvar = 'bqfirst'; } elseif ($enews == 15) { $query = '(' . $where . ') and checked=1'; $order = 'totaldown'; $yhvar = 'bqdown'; } elseif ($enews == 3) { $query = 'checked=1'; $order = 'newstime'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqnew'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 4) { $query = 'checked=1'; $order = 'onclick'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqhot'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 5) { $query = 'isgood>0 and checked=1'; $order = 'newstime'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqgood'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 10) { $query = 'checked=1'; $order = 'plnum'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqpl'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 13) { $query = 'firsttitle>0 and checked=1'; $order = 'newstime'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqfirst'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 16) { $query = 'checked=1'; $order = 'totaldown'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqdown'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 6) { $query = '(' . $where . ') and checked=1'; $order = 'newstime'; $yhvar = 'bqnew'; } elseif ($enews == 7) { $query = '(' . $where . ') and checked=1'; $order = 'onclick'; $yhvar = 'bqhot'; } elseif ($enews == 8) { $query = '(' . $where . ') and isgood>0 and checked=1'; $order = 'newstime'; $yhvar = 'bqgood'; } elseif ($enews == 11) { $query = '(' . $where . ') and checked=1'; $order = 'plnum'; $yhvar = 'bqpl'; } elseif ($enews == 14) { $query = '(' . $where . ') and firsttitle>0 and checked=1'; $order = 'newstime'; $yhvar = 'bqfirst'; } elseif ($enews == 17) { $query = '(' . $where . ') and checked=1'; $order = 'totaldown'; $yhvar = 'bqdown'; } elseif ($enews == 18) { $query = 'checked=1'; $order = 'newstime'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqnew'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 19) { $query = 'checked=1'; $order = 'onclick'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqhot'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 20) { $query = 'isgood>0 and checked=1'; $order = 'newstime'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqgood'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 21) { $query = 'checked=1'; $order = 'plnum'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqpl'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 22) { $query = 'firsttitle>0 and checked=1'; $order = "newstime"; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqfirst'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 23) { $query = 'checked=1'; $order = 'totaldown'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqdown'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 25) { $query = '(' . $where . ') and checked=1'; $order = 'newstime'; $yhvar = 'bqnew'; } elseif ($enews == 26) { $query = '(' . $where . ') and checked=1'; $order = 'onclick'; $yhvar = 'bqhot'; } elseif ($enews == 27) { $query = '(' . $where . ') and isgood>0 and checked=1'; $order = 'newstime'; $yhvar = 'bqgood'; } elseif ($enews == 28) { $query = '(' . $where . ') and checked=1'; $order = 'plnum'; $yhvar = 'bqpl'; } elseif ($enews == 29) { $query = '(' . $where . ') and firsttitle>0 and checked=1'; $order = 'newstime'; $yhvar = 'bqfirst'; } elseif ($enews == 30) { $query = '(' . $where . ') and checked=1'; $order = 'totaldown'; $yhvar = 'bqdown'; } //不调用 if (!strstr($public_r['nottobq'], ',' . $classid . ',')) { $query .= ReturnNottoBqWhere(); } //附加条件 if (!empty($ewhere)) { $query .= ' and (' . $ewhere . ')'; } //图片信息 if (!empty($do)) { $query .= ' and ispic=1'; } //中止 if (empty($tbname)) { echo $fun_r['BqErrorCid'] . "=<b>" . $classid . "</b>" . $fun_r['BqErrorNtb'] . "(" . $fun_r['BqErrorDo'] . "=" . $enews . ")"; return false; } //排序 $addorder = empty($eorder) ? $order . ' desc' : $eorder; //优化 $yhadd = ''; if (!empty($eyh_r[$yhid]['dobq'])) { $yhadd = ReturnYhSql($yhid, $yhvar); } $query = 'select ' . ReturnSqlListF($mid) . ' from ' . $dbtbpre . 'ecms_' . $tbname . ' where ' . $yhadd . $query . ' order by ' . ReturnSetTopSql('bq') . $addorder . ' limit ' . $line; $sql = $empire->query1($query); if (!$sql) { echo "SQL Error: " . ReRepSqlTbpre($query); } return $sql; }
function espace_ReturnBqQuery($classid, $line, $enews = 0, $do = 0, $ewhere = '', $eorder = '') { global $empire, $dbtbpre, $public_r, $class_r, $class_zr, $fun_r, $class_tr, $emod_r, $etable_r, $userid, $eyh_r; $userid = (int) $userid; if ($enews == 24) { $query_first = substr($classid, 0, 7); if (!($query_first == 'select ' || $query_first == 'SELECT ')) { return ""; } $classid = RepSqlTbpre($classid); $sql = $empire->query1($classid); if (!$sql) { echo "SQL Error: " . ReRepSqlTbpre($classid); } return $sql; } if ($enews == 0 || $enews == 1 || $enews == 2 || $enews == 9 || $enews == 12 || $enews == 15) { if (strstr($classid, ',')) { $son_r = sys_ReturnMoreClass($classid, 1); $classid = $son_r[0]; $where = $son_r[1]; } else { if ($class_r[$classid][islast]) { $where = "classid='{$classid}'"; } else { $where = ReturnClass($class_r[$classid][sonclass]); } } $tbname = $class_r[$classid][tbname]; $mid = $class_r[$classid][modid]; $yhid = $class_r[$classid][yhid]; } elseif ($enews == 6 || $enews == 7 || $enews == 8 || $enews == 11 || $enews == 14 || $enews == 17) { echo "Error:Change to use e:indexloop"; return false; } elseif ($enews == 25 || $enews == 26 || $enews == 27 || $enews == 28 || $enews == 29 || $enews == 30) { if (strstr($classid, ',')) { $son_r = sys_ReturnMoreTT($classid); $classid = $son_r[0]; $where = $son_r[1]; } else { $where = "ttid='{$classid}'"; } $mid = $class_tr[$classid][mid]; $tbname = $emod_r[$mid][tbname]; $yhid = $class_tr[$classid][yhid]; } $query = " where userid='{$userid}' and ismember=1"; if ($enews == 0) { $query .= ' and (' . $where . ')'; $order = 'newstime'; $yhvar = 'bqnew'; } elseif ($enews == 1) { $query .= ' and (' . $where . ')'; $order = 'onclick'; $yhvar = 'bqhot'; } elseif ($enews == 2) { $query .= ' and (' . $where . ') and isgood>0'; $order = 'newstime'; $yhvar = 'bqgood'; } elseif ($enews == 9) { $query .= ' and (' . $where . ')'; $order = 'plnum'; $yhvar = 'bqpl'; } elseif ($enews == 12) { $query .= ' and (' . $where . ') and firsttitle>0'; $order = 'newstime'; $yhvar = 'bqfirst'; } elseif ($enews == 15) { $query .= ' and (' . $where . ')'; $order = 'totaldown'; $yhvar = 'bqdown'; } elseif ($enews == 3) { $order = 'newstime'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqnew'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 4) { $order = 'onclick'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqhot'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 5) { $query .= ' and isgood>0'; $order = 'newstime'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqgood'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 10) { $order = 'plnum'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqpl'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 13) { $query .= ' and firsttitle>0'; $order = 'newstime'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqfirst'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 16) { $order = 'totaldown'; $tbname = $public_r[tbname]; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqdown'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 18) { $order = 'newstime'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqnew'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 19) { $order = 'onclick'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqhot'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 20) { $query .= ' and isgood>0'; $order = 'newstime'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqgood'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 21) { $order = 'plnum'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqpl'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 22) { $query .= ' and firsttitle>0'; $order = "newstime"; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqfirst'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 23) { $order = 'totaldown'; $tbname = $classid; $mid = $etable_r[$tbname][mid]; $yhvar = 'bqdown'; $yhid = $etable_r[$tbname][yhid]; } elseif ($enews == 25) { $query .= ' and (' . $where . ')'; $order = 'newstime'; $yhvar = 'bqnew'; } elseif ($enews == 26) { $query .= ' and (' . $where . ')'; $order = 'onclick'; $yhvar = 'bqhot'; } elseif ($enews == 27) { $query .= ' and (' . $where . ') and isgood>0'; $order = 'newstime'; $yhvar = 'bqgood'; } elseif ($enews == 28) { $query .= ' and (' . $where . ')'; $order = 'plnum'; $yhvar = 'bqpl'; } elseif ($enews == 29) { $query .= ' and (' . $where . ') and firsttitle>0'; $order = 'newstime'; $yhvar = 'bqfirst'; } elseif ($enews == 30) { $query .= ' and (' . $where . ')'; $order = 'totaldown'; $yhvar = 'bqdown'; } //优化 $yhadd = ''; if (!empty($eyh_r[$yhid]['dosbq'])) { $yhadd = ReturnYhSql($yhid, $yhvar); if (!empty($yhadd)) { $query .= ' and ' . $yhadd; } } //不调用 if (!strstr($public_r['nottobq'], ',' . $classid . ',')) { $notbqwhere = ReturnNottoBqWhere(); if (!empty($notbqwhere)) { $query .= ' and ' . $notbqwhere; } } //图片信息 if (!empty($do)) { $query .= " and ispic=1"; } //附加条件 if (!empty($ewhere)) { $query .= ' and (' . $ewhere . ')'; } //中止 if (empty($tbname)) { echo "ClassID=<b>" . $classid . "</b> Table not exists.(DoType=" . $enews . ")"; return false; } //排序 $addorder = empty($eorder) ? $order . ' desc' : $eorder; $query = 'select ' . ReturnSqlListF($mid) . ' from ' . $dbtbpre . 'ecms_' . $tbname . $query . ' order by ' . $addorder . ' limit ' . $line; $sql = $empire->query1($query); if (!$sql) { echo "SQL Error: " . ReRepSqlTbpre($query); } return $sql; }
function sys_ReturnTogQuery($type,$id,$line,$classid='',$mid='',$ewhere='',$eorder='',$selectf=''){ global $empire,$public_r,$class_r,$class_zr,$navclassid,$dbtbpre,$class_tr,$emod_r; if($type=='tags')//TAGS { $idf='tagid'; $orderf='newstime desc'; $table=$dbtbpre.'enewstagsdata'; } elseif($type=='zt')//专题 { $idf='ztid'; $orderf='newstime desc'; $table=$dbtbpre.'enewsztinfo'; } elseif($type=='ztc')//专题子类 { $idf='cid'; $orderf='newstime desc'; $table=$dbtbpre.'enewsztinfo'; } elseif($type=='sql')//SQL查询 { $query_first=substr($id,0,7); if(!($query_first=='select '||$query_first=='SELECT ')) { return ''; } $id=RepSqlTbpre($id); $sql=$empire->query1($id); if(!$sql) { echo'SQL Error: '.ReRepSqlTbpre($id); } return $sql; } else//碎片 { $idf='spid'; $orderf='newstime desc'; $table=$dbtbpre.'enewssp_2'; } $where=strstr($id,',')?"$idf in ($id)":"$idf='$id'"; //栏目 if($classid) { if(strstr($classid,','))//多栏目 { $son_r=sys_ReturnMoreClass($classid,1); $classid=$son_r[0]; $add=$son_r[1]; } else { if($classid=='selfinfo')//显示当前栏目信息 { $classid=$navclassid; } if($class_r[$classid][islast]) { $add="classid='$classid'"; } else { $add=ReturnClass($class_r[$classid][sonclass]); } } $where.=' and ('.$add.')'; } //模型 if($mid) { $where.=strstr($mid,',')?" and mid in ($mid)":" and mid='$mid'"; } //附加sql条件 if(!empty($ewhere)) { $where.=' and ('.$ewhere.')'; } //排序 if(!empty($eorder)) { $orderf=$eorder; } $query='select classid,id'.$selectf.' from '.$table.' where '.$where.' order by '.$orderf.' limit '.$line; $sql=$empire->query1($query); if(!$sql) { echo'SQL Error: '.ReRepSqlTbpre($query); } return $sql; }
function ReUserjs($jsr, $addpath) { global $empire, $public_r; DoFileMkDir($addpath . $jsr['jsfilename']); //建目录 //取得js模板 $jstemptext = GetTheJstemp($jsr[jstempid]); $ret_r = ReturnReplaceListF($jstemptext[modid]); //字段 $jstemptext[temptext] = str_replace('[!--news.url--]', $public_r[newsurl], $jstemptext[temptext]); $temp_r = explode("[!--empirenews.listtemp--]", $jstemptext[temptext]); $query = stripSlashes($jsr[jssql]); $query = RepSqlTbpre($query); $sql = $empire->query($query); $no = 1; while ($r = $empire->fetch($sql)) { $r[oldtitle] = $r[title]; //替换列表变量 $repvar = ReplaceListVars($no, $temp_r[1], $jstemptext[subnews], $jstemptext[subtitle], $jstemptext[showdate], $url, 0, $r, $ret_r); $allnew .= $repvar; $no++; } $allnew = "document.write(\"" . addslashes(stripSlashes(str_replace("\r\n", "", $temp_r[0] . $allnew . $temp_r[2]))) . "\");"; WriteFiletext_n($addpath . $jsr['jsfilename'], $allnew); }
function ExecSql($id, $userid, $username) { global $empire, $dbtbpre; $id = (int) $id; if (empty($id)) { printerror('EmptyExecSqlid', ''); } $r = $empire->fetch1("select sqltext from {$dbtbpre}enewssql where id='{$id}'"); if (!$r['sqltext']) { printerror('EmptyExecSqlid', ''); } $query = stripSlashes(RepSqlTbpre($r['sqltext'])); DoRunQuery($query); //操作日志 insert_dolog("query=" . $query); printerror("DoExecSqlSuccess", "ListSql.php"); }