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='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 && $i1) $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 && $i0) { $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 && $i0) $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 && $i0) { $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 && $idb_qry("select * from snip_se_keyphrase where target='' order by lastdate desc limit 10"); $keyph = $db->get_assoc_data(); $db->db_qry("select * from snip_se_keyword where target='' 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)." ".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".$word."", $t); $t = str_replace($uword,"".$uword."", $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"; ?>

Tipps und Tricks bei alleworte.de

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.

 

Finden


Beliebte Suchwörter: