<?   require_once "db.php";
   $db = new mysql_db_connect();

   $meta_title = "Tipps und Tricks zu Alltagsthemen";
   $meta_descr = "Tipps und Tricks kurz und knapp erläutert. Mit ausgefeilter Suchfunktion.";
   $meta_keys = "Tipps,Tricks,Hinweise,Hilfe,Frage,Antworten";
   $meta_follow = "index,follow";
   $tops = array();

   $db->db_qry("select * from snip_text where iscat=1 and cat_id=0 order by title");
   $maincats = $db->get_assoc_data();

   $dummy=0;
   $perpage=15;
   $numpage=0;
   $maxpage=10;
   $id="";
   $page=0;
   $state = "HOME";
   $maincat=null;
   $subcat=null;
   $txt=null;
   $kwtxt = "ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ";

   if (isset($_REQUEST['q']))
   {
      $state = "SEARCH";
      $q = urldecode($_REQUEST['q']);
      if (isUTF8($q))
        $q = utf8_decode($q);
   }
   if (isset($_REQUEST['pg']))
   {
      $page = $_REQUEST['pg'];
   }

   if (isset($_REQUEST['z']))
   {
      $state = "KEYWO";
      $l = $_REQUEST['z'];
   }


   if (isset($_REQUEST['rrid']))
   {
      $idents = explode("/", $_REQUEST['rrid']);
	  foreach ($idents as $i)
	  {
		  /*$tmp = strstr($i, "-p");
		  if (!($tmp === false))
		  {
			 $pg = substr($tmp, 2);
			 if (strlen($page)>0 && strlen($page)<3)
			 {
				if ($page[0]>='0' && $page[0]<='9')
				{
				  $page = $pg;
				  $pos = strlen($i);
				  for ($j=0; $j<strlen($i); $j++)
				  {
					 if ($i[$j] == '-' && $i[$j+1]=='p'&& $i[$j+2]>='0' && $i[$j+2]<='9')
					 {
						$pos = $j;
						break;
					 }
				  }
				  $i = substr($i, 0, $pos);
				}
			 }
		  }*/

		  if ($state == "SEARCH" || $state == "KEYWO")
		  {
		     break;
		  }

		  $db->db_qry("select * from snip_text where ident='".$i."' limit 1");
		  $tmp = $db->get_data();
		  if (is_array($tmp))
		  {
		     if ($tmp['iscat'] == 0)
		     {
		        $state = "TEXT";
		        $txt = $tmp;
		     }
		     else
		     {
		        if ($tmp['cat_id'] != 0)
		        {
		           $state = "CAT";
		           $subcat = $tmp;
		        }
		        else
		        {
		           $state = "CAT";
		           $maincat = $tmp;
		        }
		     }
		  }
		  else
		  {
		     if ($i == "haftung")
		     {
		        $state = "HAFTUNG";
		        $meta_follow = "noindex,nofollow";
		        break;
		     }
		     else if ($i == "datenschutz-il")
		     {
		        $state = "DATENSCHUTZ";
		        $meta_follow = "noindex,nofollow";
		        break;
		     }
		     if ($i == "impressum")
		     {
		        $state = "IMPRESSUM";
		        $meta_follow = "noindex,nofollow";
		        break;
		     }
		     if ($i == "interessant")
		     {
		        $state = "LINKS";
		        $meta_follow = "index,follow";
		        break;
		     }
		  }
	   }
   }


   if ($state == "SEARCH")
   {
      $tmp = strtolower($q);
      $target = "q=".addslashes($tmp);
      $targetnopage = $target;
      if ($page>0)
        $target .= "pg=".$page;

      $keys = explode_and_trim(" ", text_to_keywords($q));
      $qstr = "";
      $ksim = array();
      $qarr = array();
      foreach($keys as $k)
      {
         if (strlen($k)>3)
         {
             $db->db_qry("select * from snip_stopword where word='".addslashes($k)."' limit 1");
             if ($db->row_count() == 0)
             {
				 $db->db_qry("select * from snip_keyword where word='".addslashes($k)."' limit 1");
				 if ($db->row_count() > 0)
				 {
					$tmp = $db->get_data();
					$kwid = $tmp['id'];
					if (strlen($qstr) > 0)
					  $qstr .= " or keyword_id=";
					$qstr .= $kwid;
			     }
			     array_push($qarr, $k);
			 }
			 $db->db_qry("select * from snip_keyword where word like '".$k."%'");
			 $tmp = $db->get_assoc_data();
			 if (is_array($tmp))
			 {
			    foreach ($tmp as $t)
			    {
			       if ($t['word'] != $k)
			       {
			          array_push($ksim, $t['word']);
			       }
			    }
			 }
         }
      }

      if (strlen($qstr)>0)
      {
        $sql = "select distinct snip_text.* from snip_text,snip_text_keyword where text_id=snip_text.id and (keyword_id=".$qstr.") limit ";
          $sql2 = "select count(distinct snip_text.id) from snip_text,snip_text_keyword where text_id=snip_text.id and (keyword_id=".$qstr.")";
          $db->db_qry($sql2);
          $ccc = $db->get_data();
          $ccc = $ccc[0];
          $numpage = $ccc / $perpage;
        if ($page>0)
        {

          $sql .= $page*$perpage.",";
        }
        $sql .= $perpage;

        $db->db_qry($sql);
        $txts = $db->get_assoc_data();
      }

      $db->db_qry("select * from snip_se_keyphrase where target='".$target."' order by lastdate desc limit 15");
      $keyph = $db->get_assoc_data();

      $db->db_qry("select * from snip_se_keyword where target='".$target."' order by num desc limit 15");
      $keywo = $db->get_assoc_data();

      if (is_array($keywo))
      {
         foreach ($keywo as $k)
         {
            $db->db_qry("select * from snip_keyword where status=1 and word='".$k['word']."' limit 12");
            if ($db->row_count() > 0)
               array_push($tops, $k);
         }
      }

      if (sizeof($tops)<12 && is_array($txts))
      {
         $txt = $txts[0];
         $db->db_qry("select * from snip_text_keyword,snip_keyword where text_id=".$txt['id']." and status=1 and keyword_id=snip_keyword.id order by word limit 12");
         $ks = $db->get_assoc_data();
         if (is_array($ks))
         {
            $cnt = sizeof($tops);
            foreach ($ks as $kkks)
            {
               array_push($tops, $kkks);
               $cnt++;
               if ($cnt > 15)
                  break;
            }
         }
      }

      $meta_title = "";
      foreach ($qarr as $qq)
        $meta_title .= upperword($qq)." ";
	  if (is_array($tops))
	  {
		 $i = 0;
		 while (strlen($meta_title)<70 && $i<sizeof($tops))
		 {
			$meta_title .= " ".upperword(stripslashes($tops[$i]['word']));
			$i++;
		 }
	  }
	  $meta_title = urldecode($meta_title);

      if (!is_array($txts))
      {
         $meta_descr = "Kein Suchergebnis für ".stripslashes($txt['title']).". Keine Tipps gefunden";
      }
      else
      {
         $meta_descr = "Tipps und Tricks zu ".stripslashes($txt['title']);
      }
      $meta_keys = "Tipps";
	  if (is_array($tops))
	  {
		 $i = 0;
		 while (strlen($meta_descr)<200 && $i<sizeof($tops))
		 {
			$meta_descr .= " ".upperword(stripslashes($tops[$i]['word']));
			$meta_keys .= ",".stripslashes($tops[$i]['word']);
			$i++;
		 }
	  }
   }

   if ($state == "KEYWO")
   {
      if (strlen($l)>1)
         $l = $l[0];
      $l = strtolower($l);
         $db->db_qry("select * from snip_keyword where status=1 and word like '".$l."%' order by word");
      $kws = $db->get_assoc_data();

      $meta_title = "Suchbegriffe mit Anfangsbuchstaben ".$l;
	  $meta_descr = "";
	  $meta_keys = "Tipps";
      if (is_array($kws))
      {
          $i=0;
	      while (strlen($meta_descr) < 200 && sizeof($kws)>$i)
	      {
	         $meta_descr .= upperword(stripslashes($kws[$i]['word']))." ";
	         $meta_keys .= ",".stripslashes($kws[$i]['word']);
	         $i++;
	      }

      }
      else
         $meta_descr = $meta_title;
   }

   if ($state == "CAT")
   {
      if ($subcat != null)
      {
	      $db->db_qry("select * from snip_text where iscat=0 and cat_id=".$subcat['id']." order by id limit 100");
	      $txts = $db->get_assoc_data();

          $db->db_qry("select * from snip_se_keyphrase where target='".$subcat['ident']."' order by lastdate desc limit 20");
          $keyph = $db->get_assoc_data();

          $db->db_qry("select * from snip_se_keyword where target='".$subcat['ident']."' order by num desc limit 20");
          $keywo = $db->get_assoc_data();
	  }
	  else if ($maincat != null)
	  {
		  $db->db_qry("select * from snip_text where iscat=1 and cat_id=".$maincat['id']." order by title");
		  $subcats = $db->get_assoc_data();
		  if (is_array($subcats))
		  {
		     $s = "";
		     foreach ($subcats as $sc) {
		        if (strlen($s)>0)
		           $s .= ',';
		        $s .= $sc['id'];
		     }
		     $db->db_qry("select * from snip_text where iscat=0 and cat_id in (".$s.") order by id limit ".$maxpage);
		     $txts = $db->get_assoc_data();
		  }
		  else
		  {
		     $db->db_qry("select * from snip_text where iscat=0 and cat_id=".$maincat['id']." order by id limit 10");
		     $txts = $db->get_assoc_data();
		  }

		  $db->db_qry("select * from snip_se_keyphrase where target='".$maincat['ident']."' order by lastdate desc limit 20");
		  $keyph = $db->get_assoc_data();

		  $db->db_qry("select * from snip_se_keyword where target='".$maincat['ident']."' order by num desc limit 20");
		  $keywo = $db->get_assoc_data();

		  $subcat = null;
	  }

      if (is_array($keywo))
      {
         foreach ($keywo as $k)
         {
            $db->db_qry("select * from snip_keyword where status=1 and word='".$k['word']."' limit 12");
            if ($db->row_count() > 0)
               array_push($tops, $k);
         }
      }

      $id = 0;
      if ($subcat != null)
         $id = $subcat['id'];
      else
         $id = $maincat['id'];

      if (sizeof($tops)<12 && is_array($txts))
      {
         $txt = $txts[0];
         $db->db_qry("select * from snip_text_keyword,snip_keyword where text_id=".$txt['id']." and status=1 and keyword_id=snip_keyword.id order by word limit 12");
         $ks = $db->get_assoc_data();
         if (is_array($ks))
         {
            $cnt = sizeof($tops);
            foreach ($ks as $kkks)
            {
               array_push($tops, $kkks);
               $cnt++;
               if ($cnt > 15)
                  break;
            }
         }
      }

      if ( (!is_array($tops)) || (sizeof($tops)<2) )
      {
		   $db->db_qry("select * from snip_keyword where status=1 order by num desc limit 12");
		   $ks = $db->get_assoc_data();
		   foreach ($ks as $k)
		   {
			  array_push($tops, $k);
		   }
      }

       if ($txt['meta_title'] != null && strlen($txt['meta_title'])>0)
       {
          $meta_title = stripslashes($txt['meta_title']);
       }
       else
       {
          $meta_title = stripslashes($txt['title']);
          if (is_array($tops))
          {
             $i = 0;
             while (strlen($meta_title)<70 && $i<sizeof($tops))
             {
                $meta_title .= " ".upperword(stripslashes($tops[$i]['word']));
                $i++;
             }
          }
       }

       if ($txt['meta_descr'] != null && strlen($txt['meta_descr'])>0)
       {
          $meta_descr = stripslashes($txt['meta_descr']);
       }
       else
       {
          $meta_descr = "Informationen zu ".stripslashes($txt['title'])." sowie alle zu den Themen";
          if (is_array($tops))
          {
             $i = 0;
             while (strlen($meta_descr)<200 && $i<sizeof($tops))
             {
                $meta_descr .= " ".upperword(stripslashes($tops[$i]['word']));
                $i++;
             }
          }
       }

	   $meta_keys = "Tipps";
	   if (is_array($tops))
	   {
		 $i = 0;
		 while (strlen($meta_keys)<120 && $i<sizeof($tops))
		 {
			$meta_keys .= ",".stripslashes($tops[$i]['word']);
			$i++;
		 }
	   }

   }

   if (is_own_referrer())
   {
     if ($state == "SEARCH")
     {
        $ref = array();
        $ref['Query'] = $q;
     }
     else
        $ref = false;
   }
   else
   {
      $ref = seReferer(false);
   }

   if (!($ref===false))
   {
      $target = "<home>";
      if ($state == "TEXT")
      {
       	 $target = $txt['ident'];
      }
      else if ($state == "CAT")
      {
         if ($subcat != null)
         {
            $target = $subcat['ident'];
         }
         else
         {
            $target = $maincat['ident'];
         }
      }
      else if ($state == "SEARCH")
      {
         $target = "q=".addslashes($q);
         if ($page>0)
            $target .= "pg=".$page;
      }

	  $ip = $_SERVER['REMOTE_ADDR'];
      $q = strtolower(trim($ref['Query']));
      if (validQ($q)==1)
      {
      $db->db_qry("select * from snip_se_keyphrase where phrase='".addslashes($q)."' and target='".$target."' limit 1");
	  $currdate = date("YmdHis");
	  if ($db->row_count() == 0)
      {
         $db->db_qry("insert into snip_se_keyphrase(phrase,num,firstdate,lastdate,target,lastip) values ('".addslashes($q)."',1,'".$currdate."','".$currdate."','".$target."','".addslashes($ip)."')");
      }
      else
      {
         $tmp = $db->get_data();
         if (stripslashes($tmp['lastip']) != $ip)
		 {
            $db->db_qry("update snip_se_keyphrase set num=num+1,lastdate='".$currdate."',lastip='".addslashes($ip)."' where id=".$tmp['id']);
         }
      }

      $keys = explode_and_trim(" ", text_to_keywords(utf8_decode($q)));
      $kkk="";
      foreach($keys as $k)
      {
         if (strlen($k)>3)
         {
             $kkk .= $k."--";
             $db->db_qry("select * from snip_stopword where word='".addslashes($k)."' limit 1");
             if ($db->row_count() == 0)
             {
				 $db->db_qry("select * from snip_se_keyword where word='".addslashes($k)."' and target='".$target."' limit 1");
				 if ($db->row_count() == 0)
				 {
					$db->db_qry("insert into snip_se_keyword(word,target,num,firstdate,lastdate,lastip) values ('".addslashes($k)."','".$target."',1,'".$currdate."','".$currdate."','".addslashes($ip)."')");
					/*$db->db_qry("select last_insert_id() from snip_se_keyword");*/
					$tmp = $db->get_data();
					$kwid = $tmp[0];
				 }
				 else
				 {
					$tmp = $db->get_data();
					if (stripslashes($tmp['lastip']) != $ip)
					{
					   $db->db_qry("update snip_se_keyword set num=num+1,lastdate='".$currdate."',lastip='".addslashes($ip)."' where id=".$tmp['id']." limit 1");
					}
					$kwid = $tmp['id'];
				 }
			 }
         }
      }
      }
   }

   if ($state == "TEXT")
   {
       $db->db_qry("select * from snip_text where id=".$txt['cat_id']." limit 1");
       $cat = $db->get_data();
       if ($cat['cat_id']==0)
       {
          $maincat = $cat;
       }
       else
       {
          $subcat = $cat;
          $db->db_qry("select * from snip_text where id=".$subcat['cat_id']." limit 1");
          $maincat = $db->get_data();
       }

       $db->db_qry("select snip_text.* from snip_text_assoc,snip_text where from_text_id=".$txt['id']." and to_text_id=snip_text.id");
       $assoc = $db->get_assoc_data();

       $db->db_qry("select * from snip_text_ext where text_id=".$txt['id']." order by id");
       $exts = $db->get_assoc_data();

       $db->db_qry("select * from snip_se_keyphrase where target='".$txt['ident']."' order by lastdate desc limit 15");
       $keyph = $db->get_assoc_data();

       $db->db_qry("select * from snip_se_keyword where target='".$txt['ident']."' order by num desc limit 15");
       $keywo = $db->get_assoc_data();

       $ip = $_SERVER['REMOTE_ADDR'];
	   if (stripslashes($txt['lastip']) != $ip)
	   {
	      $db->db_qry("update snip_text set hitcount=hitcount+1,lastip='".addslashes($ip)."' where id=".$txt['id']." limit 1");
	   }

       if (is_array($keywo))
       {
          foreach ($keywo as $k)
          {
             $db->db_qry("select * from snip_keyword where status=1 and word='".$k['word']."' limit 12");
             if ($db->row_count() > 0)
                array_push($tops, $k);
          }
       }

       if (sizeof($tops) < 12)
       {
          $db->db_qry("select * from snip_text_keyword,snip_keyword where text_id=".$txt['id']." and status=1 and keyword_id=snip_keyword.id order by word limit 12");
          $ks = $db->get_assoc_data();
          if (is_array($ks))
          {
            $cnt = sizeof($tops);
            foreach ($ks as $kkks)
            {
               array_push($tops, $kkks);
               $cnt++;
               if ($cnt > 15)
                  break;
            }
          }
       }

       if ($txt['meta_title'] != null && strlen($txt['meta_title'])>0)
       {
          $meta_title = stripslashes($txt['meta_title']);
       }
       else
       {
          $meta_title = stripslashes($txt['title']);
          if (is_array($tops))
          {
             $i = 0;
             while (strlen($meta_title)<70 && $i<sizeof($tops))
             {
                $meta_title .= " ".upperword(stripslashes($tops[$i]['word']));
                $i++;
             }
          }
       }

       if ($txt['meta_descr'] != null && strlen($txt['meta_descr'])>0)
       {
          $meta_descr = stripslashes($txt['meta_descr']);
       }
       else
       {
          $meta_descr = "Sie interessieren sich für ".stripslashes($txt['title'])."? Dann sind sie hier richtig. Wir liefern Informationen rund um das Thema ";
          if (is_array($tops))
          {
             $i = 0;
             while (strlen($meta_descr)<120 && $i<sizeof($tops))
             {
                $meta_descr .= " ".upperword(stripslashes($tops[$i]['word']));
                $i++;
             }
          }
       }

	   $meta_keys = "Informationen";
	   if (is_array($tops))
	   {
		 $i = 0;
		 while (strlen($meta_keys)<120 && $i<sizeof($tops))
		 {
			$meta_keys .= ",".stripslashes($tops[$i]['word']);
			$i++;
		 }
	   }
   }

   if ($state == "HOME")
   {
       $db->db_qry("select * from snip_se_keyphrase where target='<home>' order by lastdate desc limit 10");
       $keyph = $db->get_assoc_data();

       $db->db_qry("select * from snip_se_keyword where target='<home>' order by num desc limit 10");
       $keywo = $db->get_assoc_data();

       /*$db->db_qry("select distinct * from snip_se_keyword order by num desc limit 50");*/
       $db->db_qry("select distinct * from snip_top_keyword order by num desc limit 50");
       $ks = $db->get_assoc_data();
       $cnt = 0;
       foreach ($ks as $k)
       {
          $found = 0;
          foreach($tops as $tt)
          {
             if ($tt['word'] == $k['word'])
             {
                $found = 1;
                break;
             }
          }
          if ($found == 0)
          {
             array_push($tops, $k);
             $cnt++;
          }

          if ($cnt > 25)
             break;
       }

       $db->db_qry("select * from snip_text where iscat=0 order by id desc limit 8");
       $txts = $db->get_assoc_data();

       $subcat = null;
   }


   function validQ($q)
   {
      if (!(strpos($q,".de")===false))
         return 0;
      if (!(strpos($q,"www")===false))
         return 0;
      if (!(strpos($q,"fick")===false))
         return 0;
      if (!(strpos($q,"solino")===false))
         return 0;
      if (!(strpos($q,"nackt")===false))
         return 0;
      if (!(strpos($q,"sex")===false))
         return 0;
      if (!(strpos($q,"porn")===false))
         return 0;
      if (!(strpos($q,"schamlippe")===false))
         return 0;
      if (!(strpos($q,"nackig")===false))
         return 0;
      if (!(strpos($q,"tangas")===false))
         return 0;
      if (!(strpos($q,"in tanga")===false))
         return 0;
      if (!(strpos($q,"wkw")===false))
         return 0;
      return 1;
   }

   function fmtdate($d)
   {
      return substr($d,6,2).".".substr($d,4,2).".".substr($d,0,4);
   }
   function fmtdatetime($d)
   {
      return substr($d,6,2).".".substr($d,4,2).".".substr($d,0,4)."&nbsp;".substr($d,8,2).":".substr($d,10,2).":".substr($d,12,2);
   }


   function seReferer($ref = false)
   {
    $SeReferer = (is_string($ref) ? $ref : $_SERVER['HTTP_REFERER']);
    if( //Check against Google, Yahoo, MSN, Ask and others
        preg_match(
        "/[&\?](q|p|w|searchfor|as_q|as_epq|s|query)=([^&]+)/i",
        $SeReferer,$pcs)
    ){
        if(preg_match("/https?:\/\/([^\/]+)\//i",$SeReferer,$SeDomain)){
            $SeDomain    = trim(strtolower($SeDomain[1]));
            $SeQuery    = $pcs[2];
            if(preg_match("/[&\?](start|b|first|stq)=([0-9]*)/i",$SeReferer,$pcs)){
                $SePos    = (int)trim($pcs[2]);
            }
        }
    }
    if(!isset($SeQuery)){
        if( //Check against DogPile
            preg_match(
            "/\/search\/web\/([^\/]+)\//i",
            $SeReferer,$pcs)
        ){
            if(preg_match("/https?:\/\/([^\/]+)\//i",$SeReferer,$SeDomain)){
                $SeDomain    = trim(strtolower($SeDomain[1]));
                $SeQuery    = $pcs[1];
            }
        }
    }
    if(!isset($SeQuery)){ return false; }
    $OldQ=$SeQuery;
    $SeQuery=urldecode($SeQuery);
    // The Multiple URLDecode Trick to fix DogPile %XXXX Encodes
    while($SeQuery != $OldQ){
        $OldQ=$SeQuery; $SeQuery=urldecode($SeQuery);
    }
    return array(
        "Se"=>$SeDomain,
        "Query"=>$SeQuery,
        "Pos"=>(int)$SePos,
        "Referer"=>$SeReferer
    );
   }

   function text_to_keywords($s)
   {
      $str = $s;
      $res = "";
      for ($i=0; $i<strlen($str); $i++)
      {
        switch($str[$i]) {
         case 'A': case 'B': case 'C': case 'D': case 'E':
         case 'F': case 'G': case 'H': case 'I': case 'J':
         case 'K': case 'L': case 'M': case 'N': case 'O':
         case 'P': case 'Q': case 'R': case 'S': case 'T':
         case 'U': case 'V': case 'W': case 'X': case 'Y':
         case 'Z':
            $res .= strtolower($str[$i]);
		    break;
         case 'a': case 'b': case 'c': case 'd': case 'e':
         case 'f': case 'g': case 'h': case 'i': case 'j':
         case 'k': case 'l': case 'm': case 'n': case 'o':
         case 'p': case 'q': case 'r': case 's': case 't':
         case 'u': case 'v': case 'w': case 'x': case 'y':
         case 'z': case '-': case '_':
         case '0': case '1': case '2': case '3': case '4':
         case '5': case '6': case '7': case '8': case '9':
            $res .= $str[$i];
            break;
         case 'ä':case'Ä':
            $res .= "ä";
            break;
         case 'ö':case 'Ö':
            $res .= "ö";
            break;
         case 'ü':case 'Ü':
            $res .= "ü";
            break;
         case 'ß':
            $res .= "ß";
            break;
         case ' ': case '-': case ',' : case '/' : case '.':
         case '\r': case '\n': case '\t': case '?': case '!':
            $res .= ' ';
            break;
        }
      }
      return $res;
   }

function explode_and_trim($separator, $text, $trim_chars = false, $limit = false)
{
    if ($limit === false)
        $arr = explode($separator, $text);
    else
        $arr = explode($separator, $text, $limit);

    $ret = array();
    foreach($arr as $e)
    {
        if ($trim_chars === false)
            $ret[] = trim($e);
        else
            $ret[] = trim($e, $trim_chars);
    }
    return $ret;
}

function is_own_referrer()
{
   global $home;
   if (isset($_SERVER['HTTP_REFERER']))
   {
     if (!(strpos($_SERVER['HTTP_REFERER'],$home)===false))
        return true;
   }
   return false;
}

function upperchar($c)
{
    $res = $c;
	switch($c) {
	 case 'a': case 'b': case 'c': case 'd': case 'e':
	 case 'f': case 'g': case 'h': case 'i': case 'j':
	 case 'k': case 'l': case 'm': case 'n': case 'o':
	 case 'p': case 'q': case 'r': case 's': case 't':
	 case 'u': case 'v': case 'w': case 'x': case 'y':
	 case 'z': case '-': case '_':
	 case '0': case '1': case '2': case '3': case '4':
	 case '5': case '6': case '7': case '8': case '9':
		$res = strtoupper($c);
		break;
	 case 'ä':
		$res = "Ä";
		break;
	 case 'ö':
		$res = "Ö";
		break;
	 case 'ü':
		$res = "Ü";
		break;
	}
    return $res;
}


function upperword($w)
{
   if (strlen($w) < 1)
      return $w;

   $x = upperchar($w[0]);
   $x .= substr($w,1);
   return $x;
}

function isUTF8($string)
{
    return (utf8_encode(utf8_decode($string)) == $string);
}

function decodeUTF8($str)
{
  if (isUTF8($str))
     return utf8_decode($str);
  return $str;
}

function emtext($txt,$qword)
{
   if (!is_array($qword))
      return $txt;
   $t = $txt;
   foreach ($qword as $word)
   {
     $uword = upperword($word);
     $t = str_replace($word,"<u><strong>".$word."</strong></u>", $t);
     $t = str_replace($uword,"<u><strong>".$uword."</strong></u>", $t);
   }
   return $t;
}

function kwinfo($t)
{
   if ($t['info'] == null || strlen($t['info'])==0 )
      return stripslashes($t['word']);
   return stripslashes($t['info']);
}

include "browser.php";
$br = browser_detection('full');

$datenschutz = $home."/datenschutz-il";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="de" lang="de">
<head>
<meta name="Description" content="" />
<meta name="Keywords" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Robots" content="" />
<link rel="stylesheet" href="/images/styles.css" type="text/css" />
<title></title>
<link rel="stylesheet" href="/cc.css" type="text/css" />
<script type="text/javascript">
    window.cookieconsent_options = {"message":"Diese Website verwendet Cookies. Wenn Sie diese Website weiterhin nutzen, stimmen Sie der Verwendung von Cookies zu.","dismiss":"Meldung ausblenden","learnMore":"Weitere Informationen","link":""};
</script>
<script type="text/javascript" src="/cc.js"></script>
</head>
<body>
<div id="wrap">
<div id="header-logo">
	<div id="logo">ALLE<span class="red">WORTE</span></div>
	<div style="float:right"><? include "ga468x60.inc"; ?></div>
</div>

<? if ($br[0]=='ie'&&$br[1]<'8.0') { ?>
<div id="right"><? echo $br[1];?>
<h1>Werbung</h1>
<? include "ga160x600.inc"; ?>
<? if ($state == "HOME"||($state=="CAT" && $subcat==null)) { ?>
<br><br><? include "ga160x600.inc"; ?>
<? } ?>
</div>
<? } ?>
<div id="main">
	<? if ($state == "HOME") { ?>
	<h3>Tipps und Tricks bei alleworte.de</h3>
	<p><img src="/images/keyb.jpg" class="float-left">
	Bei alleworte findet man Tipps und Tricks für den Alltag. Dabei legen wir nicht auf eine möglichst ausführliche Darstellung eines Tipps wert, sondern möchten in so wenig Worten wie möglich alltägliche Dinge kurz und knapp erläutern. Neben den Kategorien kann man eine ausgefeilte Suchfunktion verwenden. Zusätzlich werden häufig gesuchte Tipps angezeigt, so dass man mit einigen Mausklicks zum Ziel kommen kann. Tipps gibt es viele, wichtig ist vor allem, dass man sie schnell finden kann.<br><br>&nbsp;
	<h3>Finden</h3>
	<p>
	<form name="search" method="GET" class="search" action="">
	<input name="q" class="textbox" type="text" />
	<input class="searchbutton" value="Suchen" type="submit" />
	</form>
	<? if (is_array($tops)) { ?>
	<br><strong>Beliebte Suchwörter:</strong>&nbsp;
	<? foreach ($tops as $t) { ?>
	<a href="/?q=" title="