📄 classgroup.php
字号:
$next="下一页";
//翻页处理结束
$result=mysql_query($query_sel);
$this->set_file(array("so"=>$so_page,"fa"=>$fa_page));
$this->set_var(array("next"=>$next,"mod"=>$mod,"befor"=>$befor));//iferror
while($get=mysql_fetch_array($result))
{
switch ($num)
{
case 0:
$this->set_var(array("0"=>$get[0],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));
case 1:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 2;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 3;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 4:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 5:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"5"=>$get[5],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 8:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"5"=>$get[5],"6"=>$get[6],"7"=>$get[7],"8"=>$get[8],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
}
$this->parse("rw","so",true);
}
$fapage=$this->pq("rw");
$this->set_var("out",$fapage);
$this->parse("outfile","fa");
$this->p("outfile");
@mysql_close();
}
function select_db($name)
{
include('config.php');
$this->dblink=$link;
mysql_select_db($name,$link);
}
function setquery($name)
{
$this->query=$name;
}
function get_term($key_name,$tb_name,$addterm="no") //多项条件匹配
{
include('config.php');
mysql_select_db($dbname);
$query_sel="select ".$key_name." from ".$tb_name;
if ($addterm!="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm;
$result=mysql_query($query_sel);
while($get=mysql_fetch_array($result))
{
return $get[0];
}
@mysql_close();
}
//话题列表
function loaddis($mod,$count,$lim,$key_name,$tb_name,$num,$fa_page,$so_page,$addterm1="no",$addterm2="no")
{
include('config.php');
mysql_select_db($dbname);
//翻页处理开始
mysql_query("select * from $tb_name ".$addterm1);
$allnum=mysql_affected_rows();
if ($addterm1!="no"&&$addterm2=="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1;
elseif($addterm1!="no"&&$addterm2!="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1.$addterm2;
else $query_sel="select ".$key_name." from ".$tb_name;
mysql_query($query_sel);
$afcnum=mysql_affected_rows();
if ($count-$lim>=0)
{
$count_b=$count-$lim;
$befor="<a href='modpage.php?mod=$mod&count=$count_b'>上一页</a>";
}
else
$befor="上一页";
if ($allnum-$count>$lim)
{
$count_n=$count+$lim;
$next="<a href='modpage.php?mod=$mod&count=$count_n'>下一页</a>";
}
else
$next="下一页";
//翻页处理结束
$result=mysql_query($query_sel);
$this->set_file(array("so"=>$so_page,"fa"=>$fa_page));
$this->set_var(array("next"=>$next,"befor"=>$befor,"mod"=>$mod,"count"=>$count));
while($get=mysql_fetch_array($result))
{
$query_last="select * from discuss_text where discuss_time_id=".$get[2]." order by discuss_time desc";
$result_last=mysql_query($query_last);
$hot=mysql_affected_rows($link)-1;
$last=mysql_fetch_object($result_last);
$lastinfo=$last->discuss_ftime." by <BR>".$last->worker_login_name;
switch ($num)
{
case 2;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"hot"=>$hot,"last"=>$lastinfo ,"info"=>$info));break;
case 3;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"hot"=>$hot,"last"=>$lastinfo,"info"=>$info));break;
case 4:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"hot"=>$hot,"last"=>$lastinfo,"info"=>$info));break;
}
$this->parse("rw","so",true);
}
$fapage=$this->pq("rw");
$this->set_var("out",$fapage);
$this->parse("outfile","fa");
$this->p("outfile");
@mysql_close();
}
//显示话题
function loadshowdis($time_id,$mod,$count,$lim,$key_name,$tb_name,$num,$fa_page,$so_page,$addterm1="no",$addterm2="no")
{
include('config.php');
mysql_select_db($dbname);
//翻页处理开始
mysql_query("select * from $tb_name ".$addterm1);
$allnum=mysql_affected_rows();
if ($addterm1!="no"&&$addterm2=="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1;
elseif($addterm1!="no"&&$addterm2!="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1.$addterm2;
else $query_sel="select ".$key_name." from ".$tb_name;
mysql_query($query_sel);
$afcnum=mysql_affected_rows();
if ($count-$lim>=0)
{
$count_b=$count-$lim;
$befor="<a href='modpage.php?mod=$mod&count=$count_b&time_num=$time_id'>上一页</a>";
}
else
$befor="上一页";
if ($allnum-$count>$lim)
{
$count_n=$count+$lim;
$next="<a href='modpage.php?mod=$mod&count=$count_n&time_num=$time_id''>下一页</a>";
}
else
$next="下一页";
//翻页处理结束
$title=mysql_query("select discuss_title from discuss_title ".$addterm1);
$title=mysql_fetch_object($title);
$result=mysql_query($query_sel);
$this->set_file(array("so"=>$so_page,"fa"=>$fa_page));
$this->set_var(array("next"=>$next,"befor"=>$befor,"title"=>$title->discuss_title,"mod"=>$mod,"count"=>$count,"time_num"=>$_GET[time_num]));
while($get=mysql_fetch_array($result))
{
$query_info="select discuss_num from worker where login_name='".$get[0]."'";
$info=mysql_fetch_object(mysql_query($query_info));
$info="讨论热情: ".$info->discuss_num;
switch ($num)
{
case 2;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"info"=>$info));break;
case 3;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"info"=>$info));break;
case 4:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"info"=>$info));break;
case 5:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"5"=>$get[5],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"info"=>$info));break;
}
$this->parse("rw","so",true);
}
$fapage=$this->pq("rw");
$this->set_var("out",$fapage);
$this->parse("outfile","fa");
$this->p("outfile");
@mysql_close();
}
//管理讨论组显示讨论列表
function loadsetdis($mod,$count,$lim,$key_name,$tb_name,$num,$fa_page,$so_page,$addterm1="no",$addterm2="no")
{
include('config.php');
mysql_select_db($dbname);
//翻页处理开始
mysql_query("select * from $tb_name ".$addterm1);
$allnum=mysql_affected_rows();
if ($addterm1!="no"&&$addterm2=="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1;
elseif($addterm1!="no"&&$addterm2!="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1.$addterm2;
else $query_sel="select ".$key_name." from ".$tb_name;
mysql_query($query_sel);
$afcnum=mysql_affected_rows();
if ($count-$lim>=0)
{
$count_b=$count-$lim;
$befor="<a href='setdiscuss.php?mod=$mod&count=$count_b'>上一页</a>";
}
else
$befor="上一页";
if ($allnum-$count>$lim)
{
$count_n=$count+$lim;
$next="<a href='setdiscuss.php?count=$count_n'>下一页</a>";
}
else
$next="下一页";
//翻页处理结束
$result=mysql_query($query_sel);
$this->set_file(array("so"=>$so_page,"fa"=>$fa_page));
$this->set_var(array("next"=>$next,"befor"=>$befor,"mod"=>$mod,"count"=>$count));
while($get=mysql_fetch_array($result))
{
$query_last="select * from discuss_text where discuss_time_id=".$get[2]." order by discuss_time desc";
$result_last=mysql_query($query_last);
$hot=mysql_affected_rows($link)-1;
$last=mysql_fetch_object($result_last);
$lastinfo=$last->discuss_ftime." by <BR>".$last->worker_login_name;
switch ($num)
{
case 2;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"hot"=>$hot,"last"=>$lastinfo ,"info"=>$info));break;
case 3;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"hot"=>$hot,"last"=>$lastinfo,"info"=>$info));break;
case 4:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username'],"hot"=>$hot,"last"=>$lastinfo,"info"=>$info));break;
}
$this->parse("rw","so",true);
}
$fapage=$this->pq("rw");
$this->set_var("out",$fapage);
$this->parse("outfile","fa");
$this->p("outfile");
@mysql_close();
}
function loaddirtemp($login_name,$mod,$count,$lim,$key_name,$tb_name,$num,$fa_page,$so_page,$dir_page,$addterm1="no",$addterm2="no")
{
include('config.php');
mysql_select_db($dbname);
//翻页处理开始
mysql_query("select * from $tb_name ".$addterm1);
$allnum=mysql_affected_rows();
if ($addterm1!="no"&&$addterm2=="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1;
elseif($addterm1!="no"&&$addterm2!="no")
$query_sel="select ".$key_name." from ".$tb_name." ".$addterm1.$addterm2;
else $query_sel="select ".$key_name." from ".$tb_name;
mysql_query($query_sel);
$afcnum=mysql_affected_rows();
if ($count-$lim>=0)
{
$count_b=$count-$lim;
$befor="<a href='modpage.php?mod=$mod&count=$count_b'>上一页</a>";
}
else
$befor="上一页";
if ($allnum-$count>$lim)
{
$count_n=$count+$lim;
$next="<a href='modpage.php?mod=$mod&count=$count_n'>下一页</a>";
}
else
$next="下一页";
//翻页处理结束
$query_dir="select * from worker_dir where worker_login_name='".$login_name."' and dir_mod='$mod'";
$this->set_file(array("so"=>$so_page,"fa"=>$fa_page,"dir"=>$dir_page));
$result_dir=mysql_query($query_dir);
while($dir=mysql_fetch_object($result_dir))
{
$this->set_var(array("dir_name"=>$dir->dir_name,"dir_id"=>$dir->dir_id));
$this->parse("floder","dir",true);
}
$floder=$this->pq("floder");
$result=mysql_query($query_sel);
//echo $query_sel.mysql_error();
$this->set_var(array("next"=>$next,"mod"=>$mod,"befor"=>$befor));//iferror
while($get=mysql_fetch_array($result))
{
switch ($num)
{
case 0:
$this->set_var(array("0"=>$get[0],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));
case 1:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 2;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 3;
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 4:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 5:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"5"=>$get[5],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
case 8:
$this->set_var(array("0"=>$get[0],"1"=>$get[1],"2"=>$get[2],"3"=>$get[3],"4"=>$get[4],"5"=>$get[5],"6"=>$get[6],"7"=>$get[7],"8"=>$get[8],"next"=>$next,"befor"=>$befor,"name"=>$_SESSION['username']));break;
}
$this->parse("rw","so",true);
}
$fapage=$this->pq("rw");
$this->set_var(array("out"=>$fapage,"dir"=>$floder));
$this->parse("outfile","fa");
$this->p("outfile");
@mysql_close();
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -