📄 search.php
字号:
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE text LIKE '%".$stext."%' AND touid='".$myid."'"));
}else if($sin==2)
{
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE text LIKE '%".$stext."%' AND byuid='".$myid."'"));
}else{
$stext = getuid_nick($stext);
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE byuid ='".$stext."' AND touid='".$myid."'"));
}
$num_items = $noi[0];
$items_per_page = 10;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
if($sin=="1")
{
/*
$where_table = "ibwf_blogs";
$cond = "btext";
$select_fields = "id, bname";*/
if($sor=="1")
{
//$ord_fields = "bname";
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.text like '%".$stext."%'
ORDER BY b.timesent DESC
LIMIT $limit_start, $items_per_page";
//echo $sql;
}else if($sor=="2"){
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.text like '%".$stext."%'
ORDER BY b.timesent
LIMIT $limit_start, $items_per_page";
}else{
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.text like '%".$stext."%'
ORDER BY a.name
LIMIT $limit_start, $items_per_page";
}
}
else if($sin=="2")
{
if($sor=="1")
{
//$ord_fields = "bname";
$sql = "SELECT
a.name, b.id, b.touid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.byuid='".$myid."' AND b.text like '%".$stext."%'
ORDER BY b.timesent DESC
LIMIT $limit_start, $items_per_page";
//echo $sql;
}else if($sor=="2"){
$sql = "SELECT
a.name, b.id, b.touid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.byuid='".$myid."' AND b.text like '%".$stext."%'
ORDER BY b.timesent
LIMIT $limit_start, $items_per_page";
}else{
$sql = "SELECT
a.name, b.id, b.touid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.touid
WHERE b.byuid='".$myid."' AND b.text like '%".$stext."%'
ORDER BY a.name
LIMIT $limit_start, $items_per_page";
}
}
else if($sin=="3")
{
if($sor=="1")
{
//$ord_fields = "bname";
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.byuid ='".$stext."'
ORDER BY b.timesent DESC
LIMIT $limit_start, $items_per_page";
}else if($sor=="2"){
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.byuid ='".$stext."'
ORDER BY b.timesent
LIMIT $limit_start, $items_per_page";
}else{
$sql = "SELECT
a.name, b.id, b.byuid, b.unread, b.starred FROM ibwf_users a
INNER JOIN ibwf_private b ON a.id = b.byuid
WHERE b.touid='".$myid."' AND b.byuid ='".$stext."'
ORDER BY a.name
LIMIT $limit_start, $items_per_page";
}
}
$items = mysql_query($sql);
echo mysql_error();
while($item=mysql_fetch_array($items))
{
if($item[3]=="1")
{
$iml = "<img src=\"images/npm.gif\" alt=\"+\"/>";
}else{
if($item[4]=="1")
{
$iml = "<img src=\"images/spm.gif\" alt=\"*\"/>";
}else{
$iml = "<img src=\"images/opm.gif\" alt=\"-\"/>";
}
}
$lnk = "<a href=\"inbox.php?action=readpm&pmid=$item[1]&sid=$sid\">$iml ".getnick_uid($item[2])."</a>";
echo "$lnk<br/>";
}
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
$rets = "<anchor>«Prev";
$rets .= "<go href=\"search.php?action=$action&sid=$sid&page=$ppage\" method=\"post\">";
$rets .= "<postfield name=\"stext\" value=\"$stext\"/>";
$rets .= "<postfield name=\"sin\" value=\"$sin\"/>";
$rets .= "<postfield name=\"sor\" value=\"$sor\"/>";
$rets .= "</go></anchor> ";
echo $rets;
}
if($page<$num_pages)
{
$npage = $page+1;
$rets = "<anchor>Next»";
$rets .= "<go href=\"search.php?action=$action&sid=$sid&page=$npage\" method=\"post\">";
$rets .= "<postfield name=\"stext\" value=\"$stext\"/>";
$rets .= "<postfield name=\"sin\" value=\"$sin\"/>";
$rets .= "<postfield name=\"sor\" value=\"$sor\"/>";
$rets .= "</go></anchor> ";
echo $rets;
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "Jump to page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor>[GO]";
$rets .= "<go href=\"search.php?action=$action&sid=$sid&page=$(pg)\" method=\"post\">";
$rets .= "<postfield name=\"stext\" value=\"$stext\"/>";
$rets .= "<postfield name=\"sin\" value=\"$sin\"/>";
$rets .= "<postfield name=\"sor\" value=\"$sor\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
echo "</p>";
}
echo "</p>";
echo "<p align=\"center\">";
echo "<a href=\"index.php?action=search&sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";
echo "Search Menu</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p></card>";
}
else if($action=="smbr")
{
$stext = $_POST["stext"];
$sin = $_POST["sin"];
$sor = $_POST["sor"];
addonline(getuid_sid($sid),"Club search","");
echo "<card id=\"main\" title=\"Search\">";
echo "<p>";
if(trim($stext)=="")
{
echo "<br/>Failed to search for club";
}else{
//begin search
if($page=="" || $page<1)$page=1;
$where_table = "ibwf_users";
$cond = "name";
$select_fields = "id, name";
if($sor=="1")
{
$ord_fields = "name";
}else if($sor=="2"){
$ord_fields = "lastact DESC";
}else if($sor=="3"){
$ord_fields = "regdate";
}
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ".$where_table." WHERE ".$cond." LIKE '%".$stext."%'"));
$num_items = $noi[0];
$items_per_page = 10;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
$sql = "SELECT ".$select_fields." FROM ".$where_table." WHERE ".$cond." LIKE '%".$stext."%' ORDER BY ".$ord_fields." LIMIT $limit_start, $items_per_page";
$items = mysql_query($sql);
while($item=mysql_fetch_array($items))
{
$tlink = "<a href=\"index.php?action=viewuser&sid=$sid&who=$item[0]\">".htmlspecialchars($item[1])."</a><br/>";
echo $tlink;
}
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
$rets = "<anchor>«Prev";
$rets .= "<go href=\"search.php?action=$action&sid=$sid&page=$ppage\" method=\"post\">";
$rets .= "<postfield name=\"stext\" value=\"$stext\"/>";
$rets .= "<postfield name=\"sin\" value=\"$sin\"/>";
$rets .= "<postfield name=\"sor\" value=\"$sor\"/>";
$rets .= "</go></anchor> ";
echo $rets;
}
if($page<$num_pages)
{
$npage = $page+1;
$rets = "<anchor>Next»";
$rets .= "<go href=\"search.php?action=$action&sid=$sid&page=$npage\" method=\"post\">";
$rets .= "<postfield name=\"stext\" value=\"$stext\"/>";
$rets .= "<postfield name=\"sin\" value=\"$sin\"/>";
$rets .= "<postfield name=\"sor\" value=\"$sor\"/>";
$rets .= "</go></anchor> ";
echo $rets;
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "Jump to page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor>[GO]";
$rets .= "<go href=\"search.php?action=$action&sid=$sid&page=$(pg)\" method=\"post\">";
$rets .= "<postfield name=\"stext\" value=\"$stext\"/>";
$rets .= "<postfield name=\"sin\" value=\"$sin\"/>";
$rets .= "<postfield name=\"sor\" value=\"$sor\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
echo "</p>";
}
echo "</p>";
echo "<p align=\"center\">";
echo "<a href=\"index.php?action=search&sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";
echo "Search Menu</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p></card>";
}
else{
addonline(getuid_sid($sid),"Lost in search lol","");
echo "<card id=\"main\" title=\"Search\">";
echo "<p align=\"center\">";
echo "I don't know how did you get into here, but there's nothing to show<br/><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p></card>";
}
?>
</wml>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -