View file wapirate/A1/search.php

File size: 56.38Kb
<?php





include("core.php");

include("config.php");





header("Content-type: text/html; charset=ISO-8859-1");

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>";

echo "<!DOCTYPE html PUBLIC \"-//WAPFORUM//DTD XHTML Mobile 1.0//EN\"\"http://www.wapforum.org/DTD/xhtml-mobile10.dtd\">";

echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";





connectdb();

$addy = "wapirate.net";

$page = $_GET["page"];

$sor = $_GET["sor"];

$sin = $_GET["sin"];

$stext = $_GET["stext"];

$action = $_GET["action"];

$sid = $_GET["sid"];

$page = $_POST["page"];

$uid = getuid_sid($sid);

$theme = mysql_fetch_array(mysql_query("SELECT theme FROM ibwf_users WHERE id='".$uid."'"));

    if(islogged($sid)==false)

    {

  echo "<head>";

  echo "<title>Error!!!</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/red_medium.css\">";

  echo "</head>";

  echo "<body>";  

      echo "<div><br/>Doh!<br/></div>";

      echo "<p align=\"center\">";

      echo "You are not logged in<br/>";

      echo "Or Your session has been expired<br/><br/>";

      echo "<a href=\"index.php\">Login</a>";

      echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  echo "</html>";

  exit();

    }



if(isbanned($uid))

    {

  echo "<head>";

  echo "<title>Error!!!</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/red_medium.css\">";

  echo "</head>";

  echo "<body>"; 

    echo "<div><br/>Doh!<br/></div>";

      echo "<p align=\"center\">";

      echo "<img src=\"images/notok.gif\" alt=\"x\"/><br/>";

      echo "You are <b>Banned</b><br/>";

      $banto = mysql_fetch_array(mysql_query("SELECT timeto FROM ibwf_penalties WHERE uid='".$uid."' AND penalty='1'"));

      $remain = $banto[0]- time();

      $rmsg = gettimemsg($remain);

      echo "Time to finish your penalty: $rmsg<br/><br/>";

      //echo "<a href=\"index.php\">Login</a>";

      echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  echo "</html>";

  exit();

    }

/////////////////////////////////////////////////////////////////////////////////

if($action=="tpc")

{

    addonline(getuid_sid($sid),"Topics search","");

     echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";  

      echo "<div><br/>Topics Search<br/></div>";

echo "<form action=\"search.php?action=stpc&amp;sid=$sid\" method=\"post\">";

    echo "Text: <input name=\"stext\" maxlength=\"30\"/><br/>";

    echo "In: <select name=\"sin\">";

    echo "<option value=\"1\">Topic Posts</option>";

    echo "<option value=\"2\">Topic Text</option>";

    echo "<option value=\"3\">Topic Name</option>";

    echo "</select><br/>";

    echo "Order: <select name=\"sor\">";

    echo "<option value=\"1\">Newest First</option>";

    echo "<option value=\"2\">Oldest First</option>";

    echo "</select><br/>";

echo "<input type=\"submit\" value=\"Search\"/>";

  echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

//////////////////////////////////////

else if($action=="blg")

{

    addonline(getuid_sid($sid),"Blogs search","");

   echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";    

      echo "<div><br/>Blog Search<br/></div>";

echo "<form action=\"search.php?action=sblg&amp;sid=$sid\" method=\"post\">";

    echo "Text: <input name=\"stext\" maxlength=\"30\"/><br/>";

    echo "In: <select name=\"sin\">";

    echo "<option value=\"1\">Blog Text</option>";

    echo "<option value=\"2\">Blog Name</option>";

    echo "</select><br/>";

    echo "Order: <select name=\"sor\">";

    echo "<option value=\"1\">Blog Name</option>";

    echo "<option value=\"2\">Time</option>";

    echo "</select><br/>";

echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

/////////////////////////////////////////////////////

else if($action=="clb")

{

    addonline(getuid_sid($sid),"Clubs search","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";     

      echo "<div><br/>Club Search<br/></div>";

echo "<form action=\"search.php?action=sclb&amp;sid=$sid\" method=\"post\">";

    echo "Text: <input name=\"stext\" maxlength=\"30\"/><br/>";

    echo "In: <select name=\"sin\">";

    echo "<option value=\"1\">Club Description</option>";

    echo "<option value=\"2\">Club Name</option>";

    echo "</select><br/>";

    echo "Order: <select name=\"sor\">";

    echo "<option value=\"1\">Club Name</option>";

    echo "<option value=\"2\">Oldest</option>";

    echo "<option value=\"3\">Newest</option>";

    echo "</select><br/>";

    

    

echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";





  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

///////////////////////////////////////////////

else if($action=="nbx")

{

    addonline(getuid_sid($sid),"Inbox search","");

   echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";    

      echo "<div><br/>Inbox Search<br/></div>";

echo "<form action=\"search.php?action=snbx&amp;sid=$sid\" method=\"post\">";

    echo "Text: <input name=\"stext\" maxlength=\"30\"/><br/>";

    echo "In: <select name=\"sin\">";

    echo "<option value=\"1\">Recieved Messages</option>";

	echo "<option value=\"2\">Sent Messages</option>";

    echo "<option value=\"3\">Sender Name</option>";

    echo "</select><br/>";

    echo "Order: <select name=\"sor\">";

    echo "<option value=\"1\">Newest PMs</option>";

    echo "<option value=\"2\">Oldest PMs</option>";

    echo "<option value=\"2\">Sender Name</option>";

    echo "</select><br/>";

    

    

echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

///////////////////////////////////////////////////////

else if($action=="mbrn")

{

    addonline(getuid_sid($sid),"Members search","");

   echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";    

      echo "<div><br/>Member Search<br/></div>";

echo "<form action=\"search.php?action=smbr&amp;sid=$sid\" method=\"post\">";

    echo "Nickname: <input name=\"stext\" maxlength=\"15\"/><br/>";

    echo "Order: <select name=\"sor\">";

    echo "<option value=\"1\">Member Name</option>";

    echo "<option value=\"2\">Last Active</option>";

    echo "<option value=\"3\">Join Date</option>";

    echo "</select><br/>";

    echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

//////////////////////////////////////////////

else if($action=="stpc")

{

  $stext = $_POST["stext"];

  $sin = $_POST["sin"];

  $sor = $_POST["sor"];

    addonline(getuid_sid($sid),"Topics search","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";  

         echo "<div><br/>Topics Search<br/></div>";

    echo "<p>";



        if(trim($stext)=="")

        {

            echo "<br/>Please Specify the text to search for";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          if($sin=="1")

          {

            $where_table = "ibwf_posts";

            $cond = "text";

            $select_fields = "id, tid";

            if($sor=="1")

            {

              $ord_fields = "dtpost DESC";

            }else{

                $ord_fields = "dtpost";

            }

          }else if($sin=="2")

          {

            $where_table = "ibwf_topics";

            $cond = "text";

            $select_fields = "name, id";

            if($sor=="1")

            {

              $ord_fields = "crdate DESC";

            }else{

                $ord_fields = "crdate";

            }

          }else if($sin=="3")

          {

            $where_table = "ibwf_topics";

            $cond = "name";

            $select_fields = "name, id";

            if($sor=="1")

            {

              $ord_fields = "crdate DESC";

            }else{

                $ord_fields = "crdate";

            }

          }

          $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))

          {

            if($sin=="1")

            {

              $tname = htmlspecialchars(gettname($item[1]));

			  

              if($tname=="" || !canaccess(getuid_sid($sid),getfid_tid($item[1]))){

                $tlink = "Unreachable<br/>";

              }else{

              $tlink = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$item[1]&amp;go=$item[0]\">".$tname."</a><br/>";

              }

                echo  $tlink;

            }

            else

            {

              $tname = htmlspecialchars($item[0]);

              if($tname=="" || !canaccess(getuid_sid($sid),getfid_tid($item[1]))){

                $tlink = "Unreachable<br/>";

              }else{

              $tlink = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$item[1]\">".$tname."</a><br/>";

              }

                echo  $tlink;

            }

          }

echo "</p>";

    if($page>1)

    {

      $ppage = $page-1;

 $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

      

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

 $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

      

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {



        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



        echo $rets;

    }

    echo "</p>";

        }

    



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

/////////////////////////////////////

else if($action=="sblg")

{

  $stext = $_POST["stext"];

  $sin = $_POST["sin"];

  $sor = $_POST["sor"];

    addonline(getuid_sid($sid),"Blogs search","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";  

         echo "<div><br/>Blog Search<br/></div>";

    echo "<p>";



    

    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search for blogs";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          if($sin=="1")

          {

            $where_table = "ibwf_blogs";

            $cond = "btext";

            $select_fields = "id, bname";

            if($sor=="1")

            {

              $ord_fields = "bname";

            }else{

                $ord_fields = "bgdate DESC";

            }

          }else if($sin=="2")

          {

            $where_table = "ibwf_blogs";

            $cond = "bname";

            $select_fields = "id, bname";

            if($sor=="1")

            {

              $ord_fields = "bname";

            }else{

                $ord_fields = "bgdate DESC";

            }

          }

          $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=viewblog&amp;sid=$sid&amp;bid=$item[0]&amp;go=$item[0]\">".htmlspecialchars($item[1])."</a><br/>";



                echo  $tlink;

            

          }

echo "</p>";

    if($page>1)

    {

      $ppage = $page-1;

 $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

 $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {



        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



        echo $rets;

    }



        }

    



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

//////////////////////////////////////////

else if($action=="sclb")

{

  $stext = $_POST["stext"];

  $sin = $_POST["sin"];

  $sor = $_POST["sor"];

    addonline(getuid_sid($sid),"Club search","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>"; 

          echo "<div><br/>Club Search<br/></div>";

    echo "<p>";



    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search for club";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          if($sin=="1")

          {

            $where_table = "ibwf_clubs";

            $cond = "description";

            $select_fields = "id, name";

            if($sor=="1")

            {

              $ord_fields = "name";

            }else if($sor=="2"){

                $ord_fields = "created";

            }else if($sor=="3"){

                $ord_fields = "created DESC";

            }

          }else if($sin=="2")

          {

            $where_table = "ibwf_clubs";

            $cond = "name";

            $select_fields = "id, name";

            if($sor=="1")

            {

              $ord_fields = "name";

            }else if($sor=="2"){

                $ord_fields = "created";

            }else if($sor=="3"){

                $ord_fields = "created DESC";

            }

          }

          $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=gocl&amp;sid=$sid&amp;clid=$item[0]&amp;go=$item[0]\">".htmlspecialchars($item[1])."</a><br/>";



                echo  $tlink;



          }

echo "</p>";

		  if($page>1)

    {

      $ppage = $page-1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

 $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {



        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump to page<input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



        echo $rets;

    }



        }

    



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

////////////////////////////////////////////

else if($action=="snbx")

{

  $stext = $_POST["stext"];

  $sin = $_POST["sin"];

  $sor = $_POST["sor"];

    addonline(getuid_sid($sid),"Inbox search","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";  

         echo "<div><br/>Inbox Search<br/></div>";

    echo "<p>";



        $myid = getuid_sid($sid);

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search for message";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          if($sin==1)

          {

          $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&amp;pmid=$item[1]&amp;sid=$sid\">$iml ".getnick_uid($item[2])."</a>";

      echo "$lnk<br/>";



          }

echo "</p>";

    if($page>1)

    {

      $ppage = $page-1;

      $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {

              $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



        echo $rets;

    }



        }

    



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

///////////////////////////////////////

else if($action=="smbr")

{

	$stext = $_POST["stext"];

  $sin = $_POST["sin"];

  $sor = $_POST["sor"];

    addonline(getuid_sid($sid),"Member search","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>Member Search<br/></div>";

    echo "<p>";



    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search for Member";

        }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&amp;sid=$sid&amp;who=$item[0]\">".htmlspecialchars($item[1])."</a><br/>";



                echo  $tlink;



          }

echo "</p>";

		  if($page>1)

    {

      $ppage = $page-1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

      $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



        echo $rets;

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {

        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



        echo $rets;

    }



        }

    

  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}



////////////////////////////////////////ip

  else if($action=="ip")

{

    addonline(getuid_sid($sid),"Main Page","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>IP Search<br/></div>";





    echo "<form action=\"search.php?action=ip2&amp;sid=$sid\" method=\"post\">";

    echo "IP: <input name=\"stext\" maxlength=\"255\"/><br/>";

    echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

/////////////////////////////ip2

else if($action=="ip2")

{

	$stext = $_POST["stext"];

  $sin = 1;

  $sor = 1;

    addonline(getuid_sid($sid),"Main Page","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>IP Search<br/></div>";

    echo "<p>";



    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          

            $where_table = "ibwf_users";

            $cond = "ipadd";

            $select_fields = "id, name, ipadd, browserm";

            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&amp;sid=$sid&amp;who=$item[0]\">".htmlspecialchars($item[1])."</a> $item[2]<br/>$item[3]<br/><br/>";



                echo  $tlink;



          }

          echo "<p align=\"center\">";

		    if($page>1)

    {

      $ppage = $page-1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

      $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {

        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "</p>";

        }

    

echo "</p>";

  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

////////////////////////////////////////browser

  else if($action=="browser")

{

    addonline(getuid_sid($sid),"Main Page","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>Browser Search<br/></div>";



    echo "<form action=\"search.php?action=browser2&amp;sid=$sid\" method=\"post\">";

    echo "Browser: <input name=\"stext\" maxlength=\"255\"/><br/>";

    echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

/////////////////////////////browser2

else if($action=="browser2")

{

	$stext = $_POST["stext"];

  $sin = 1;

  $sor = 1;

    addonline(getuid_sid($sid),"Main Page","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>Browser Search<br/></div>";

    echo "<p>";



    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          

            $where_table = "ibwf_users";

            $cond = "browserm";

            $select_fields = "id, name, ipadd, browserm";

            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&amp;sid=$sid&amp;who=$item[0]\">".htmlspecialchars($item[1])."</a> $item[2]<br/>$item[3]<br/><br/>";



                echo  $tlink;



          }

          echo "<p align=\"center\">";

		    if($page>1)

    {

      $ppage = $page-1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

      $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";       

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {

        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "</p>";

        }

    

echo "</p>";

  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

////////////////////////////////////////both

  else if($action=="both")

{

    addonline(getuid_sid($sid),"Main Page","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>Browser And IP Search<br/></div>";

    echo "<form action=\"search.php?action=both2&amp;sid=$sid\" method=\"post\">";

    echo "ip: <input name=\"ip\" maxlength=\"255\"/><br/>";

    echo "browser: <input name=\"stext\" maxlength=\"255\"/><br/>";

    echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";

  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

/////////////////////////////browser2

else if($action=="both2")

{

	$ip = $_POST["ip"];

	$stext = $_POST["stext"];

  $sin = $_POST["sin"];

  $sor = 1;

    addonline(getuid_sid($sid),"Main Page","");

  echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>";   

      echo "<div><br/>Browser And IP Search<br/></div>";

    echo "<p>";



    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          

            $where_table = "ibwf_users";

            $cond = "browserm";

            $select_fields = "id, name, ipadd, browserm";

            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."%'"));*/





      $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ".$where_table." WHERE ".$cond." LIKE '%".$stext."%' AND ipadd LIKE '%".$ip."%'"));

          $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&amp;sid=$sid&amp;who=$item[0]\">".htmlspecialchars($item[1])."</a> $item[2]<br/>$item[3]<br/><br/>";



                echo  $tlink;



          }

          echo "<p align=\"center\">";

		   if($page>1)

    {

      $ppage = $page-1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

      $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";        

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {

        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "</p>";

        }

    

echo "</p>";

  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

////////////////////////////////////////smiley

  else if($action=="smiley")

{

    addonline(getuid_sid($sid),"Main Page","");

    echo "<head>";

    echo "<title>wapirate</title>";

    echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

    echo "</head>";

    echo "<body>";   

    echo "<div><br/>Smiley<br/></div>";



    echo "<form action=\"search.php?action=smiley2&amp;sid=$sid\" method=\"post\">";

    echo "Smiley Code: <input name=\"stext\" maxlength=\"15\"/><br/>";

    echo "<input type=\"submit\" value=\"Search\"/>";

    echo "</form>";



  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}

/////////////////////////////smiley2

else if($action=="smiley2")

{

	$stext = $_POST["stext"];

  $sin = 1;

  $sor = 1;

    addonline(getuid_sid($sid),"Main Page","");

    echo "<head>";

    echo "<title>wapirate</title>";

    echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

    echo "</head>";

    echo "<body>";   

    echo "<div><br/>Smiley<br/></div>";

    echo "<p>";



    

        if(trim($stext)=="")

        {

            echo "<br/>Failed to search";

        }else{

          //begin search

          if($page=="" || $page<1)$page=1;

          

            $where_table = "ibwf_smilies";

            $cond = "scode";

            $select_fields = "id, imgsrc, scode";

            if($sor=="1")

            {

              $ord_fields = "id";

            }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))

          {

		if(isadmin(getuid_sid($sid)))

		{

			$delsl = "<a href=\"admproc.php?action=delsm&amp;sid=$sid&amp;smid=$item[0]\">[x]</a>";

		}else{

			$delsl = "";

		}



              $tlink = "$item[2] <img src=\"$item[1]\" alt=\"*\"/> $delsl<br/><br/>";



                echo  $tlink;



          }

          echo "<p align=\"center\">";

		    if($page>1)

    {

      $ppage = $page-1;

       $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Prev\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$ppage\"/>";      

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    if($page<$num_pages)

    {

      $npage = $page+1;

      $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$ppage\" method=\"post\">";

        $rets .= "<input type=\"submit\" value=\"Next\"/>";

        $rets .= "<input type=\"hidden\" name=\"page\" value=\"$npage\"/>";       

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form> ";



echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "<br/>$page/$num_pages<br/>";

    if($num_pages>2)

    {

        $rets = "<form action=\"search.php?action=$action&amp;sid=$sid&amp;page=$page\" method=\"post\">";

      $rets .= "Jump To Page: <input name=\"page\" format=\"*N\" size=\"3\"/>";

        $rets .= "<input type=\"submit\" value=\"GO\"/>";

        $rets .= "<input type=\"hidden\" name=\"stext\" value=\"$stext\"/>";

        $rets .= "<input type=\"hidden\" name=\"sin\" value=\"$sin\"/>";

        $rets .= "<input type=\"hidden\" name=\"sor\" value=\"$sor\"/>";

        $rets .= "</form>";

echo "</p>";

        echo $rets;

echo "<p align=\"center\">";

    }

    echo "</p>";

        }

    

echo "</p>";

  echo "<p align=\"center\">";

  echo "<a href=\"index.php?action=search&amp;sid=$sid\"><img src=\"images/search.gif\" alt=\"*\"/>";

echo "Search Menu</a><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}



  

////////////////////////////////////////////////////////////

else{

  addonline(getuid_sid($sid),"Lost in search lol","");

   echo "<head>";

  echo "<title>wapirate</title>";

  echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";

  echo "</head>";

  echo "<body>"; 

    echo "<div><br/>Doh!<br/></div>";   

  echo "<p align=\"center\">";

  echo "I don't know how you got in here, but there's nothing to show<br/><br/>";

  echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";

echo "Home</a>";

  echo "</p>";

    echo "<div>$addy</div>";

  echo "</body>";

  exit();

}



	echo "</html>";

?>