";
$citys=array("Gdańsk","Gdynia","Sopot","Warszawa","Lębork","Kartuzy","Biała Podlaska","Białystok","Bielsko-Biała","Bydgoszcz",
"Chełm","Ciechanów","Częstochowa","Elbląg",
"Gorzów Wielkopolski","Jelenia Góra","Zielona Góra","Piotrków","Wałbrzych","Włoclawek","Wroclaw","Zamość");
$citys_add_size=count($citys);
$words_x=array("Sklepy Internetowe","Sklepy Komputewrowe","Sklep komputerowy","sklep internetowey","sklep spęt AGD",
"sklep sprzęt RTV","telewizory LED","telewizory LCD","telewizory 3D",
"telewizory plazmmowe","lodówki","pralki","lodówka","pralka",
"zmywarki","zmywarka","okapy agd","laptopy","notebooki","komputery","zestawy komputerowe","pasaż sklepy");
$words_x_size=count($words_x);
$city=$citys[rand(0,$citys_add_size)];
$word=$words_x[rand(0,$words_x_size)];
$qtab=str_replace(" ","_",$q);
$qtab=split("_",$qtab);
$q=str_replace("_"," ",$q);
$tagLink="http://".$_SERVER["SERVER_NAME"];
echo "
";
echo " << "._BACK." ".$word.": ".$_SERVER["SERVER_NAME"].", ".$q." ".$city."
";
echo "";
echo "
";
$sql_add_a ="";
$sql_add_b ="";
$sql_add ="";
for($i=0;$i
dbprefix."pages WHERE active='1' AND content LIKE '%".addslashes($q)."%' limit 50";
// $sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."pages WHERE active='1' AND name!='' AND name!=' ' AND content!='' AND content!=' ' ".$sql_add." limit 50";
$is_mod_auction=is_modactive("Auction");
$is_mod_csCommerce=is_modactive("csCommerce");
$result="";
$nums=0;
include_once ("classes/gwpe.class.html2text.inc");
//==============auction
if ($is_mod_auction){
$limit_it=15;
$sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."Auction_products pr
LEFT JOIN ".$GO_CONFIG->dbprefix."Auction_products_add pra ON (pra.id_unique_prod_add=pr.id_unique_prod AND pra.id_owner_add=pr.id_owner)
WHERE pr.active='1' ".$sql_add_a." ORDER BY rand() limit ".$limit_it;
// WHERE pr.active='1' ".$sql_add_a." ORDER BY pr.sdate DESC limit ".$limit_it;
$result = $db->sql_query($sql);
//echo $sql;
while($row=$db->sql_fetchrow($result)){
$htmlToText = new Html2Text (stripslashes($row['prod_desc']), 999915);
$content = $htmlToText->convert();
if ($content){
$city=$citys[rand(0,$citys_add_size)];
$word=$words_x[rand(0,$words_x_size)];
$tagLink="http://".$_SERVER["SERVER_NAME"]."/Auctiontz-".getpost('dz')."-".$row['mid_cat']."-".$row['pid_cat']."-".$row['id_unique_prod'].".html-".str_replace("/","-",str_replace(" ","-",clear_txt(utf8toasci(stripslashes($row['prod_name']),2)))).".html";
echo "";
echo "".timestamp2date($row['lastmodyfied'])."";
echo "
";
$content= str_replace(" a "," ".$word." ".$q." ".$city." ",$content);
$content= str_replace(":"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("–"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("x"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("\/"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace("•"," ".$word." ".$q." ".$city." ",$content);
echo $content;
echo "
";
echo "".$q.":
".date('l jS \of F Y h:i:s A');
echo "
";
$nums=$nums+1;
}
}//while
}
//==============shop
if ($is_mod_csCommerce){
$limit_it=15;
//mod.php?dz=13&op=zoom&pid=18399&cid=2&pcid=1
//csComp-13-18399-2-1.html-title-czajnik-elektryczny-adler-ad-02-mini-760-w-06-l-bialy.html
$sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."csCommerce_products pr
LEFT JOIN ".$GO_CONFIG->dbprefix."csCommerce_products_description pra ON (pra.products_id=pr.products_id )
LEFT JOIN ".$GO_CONFIG->dbprefix."csCommerce_products_to_categories prc ON (prc.products_id=pr.products_id )
WHERE pr.active='1' ".$sql_add_b." ORDER BY rand() limit ".$limit_it;
// WHERE pr.active='1' ".$sql_add_b." ORDER BY pr.products_last_modified DESC limit ".$limit_it;
$result = $db->sql_query($sql);
//echo "
".$sql;
while($row=$db->sql_fetchrow($result)){
$htmlToText = new Html2Text (stripslashes($row['products_description']), 999915);
$content = $htmlToText->convert();
if ($content){
// $tagLink="http://".$_SERVER["SERVER_NAME"]."/?pg=".$row['id'];
$tagLink="http://".$_SERVER["SERVER_NAME"]."/csComp-".getpost('dz')."-".$row['products_id']."-".$row['categories_id']."-0.html-".str_replace("/","-",str_replace(" ","-",clear_txt(utf8toasci(stripslashes($row['prod_name']),2)))).".html";
$city=$citys[rand(0,$citys_add_size)];
$word=$words_x[rand(0,$words_x_size)];
echo "";
echo "".$row['products_last_modified']."";
echo "
";
$content= str_replace(" a "," ".$word." ".$q." ".$city." ",$content);
$content= str_replace(":"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace(";"," ".$q." ",$content);
$content= str_replace("–"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("x"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("\/"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace("•"," ".$word." ".$q." ".$city." ",$content);
echo $content;
echo "
";
echo "".$q.":
".date('l jS \of F Y h:i:s A');
echo "
";
}
$nums=$nums+1;
}//while
}
//==============pages
// if (!$db->sql_numrows($result) || !$is_mod_auction){
$limit_it=50-$nums;
$sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."pages WHERE active='1' ".$sql_add." AND name!='' AND content!='' ORDER BY rand() limit ".$limit_it;
// $sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."pages WHERE active='1' ".$sql_add." AND name!='' AND content!='' ORDER BY lastmodyfi DESC limit ".$limit_it;
//echo $sql;
$result = $db->sql_query($sql);
while($row=$db->sql_fetchrow($result)){
$htmlToText = new Html2Text (stripslashes($row['content']), 999915);
$content = $htmlToText->convert();
if ($content){
// $tagLink="http://".$_SERVER["SERVER_NAME"]."/?pg=".$row['id'];
$tagLink="http://".$_SERVER["SERVER_NAME"]."/pg-".$row['id'].".html-".str_replace("/","-",str_replace(" ","-",clear_txt(utf8toasci(stripslashes($row['name']),2)))).".html";
$city=$citys[rand(0,$citys_add_size)];
$word=$words_x[rand(0,$words_x_size)];
echo "";
echo "".$row['lastmodyfi']."";
echo "
";
$content= str_replace(" a "," ".$word." ".$q." ".$city." ",$content);
$content= str_replace(":"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace(";"," ".$q." ",$content);
$content= str_replace("–"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("x"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("\/"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace("•"," ".$word." ".$q." ".$city." ",$content);
echo $content;
echo "
";
echo "".$q.":
".date('l jS \of F Y h:i:s A');
echo "
";
}
$nums=$nums+1;
}//while
// }//if
//==============pages ather !!!
// if (!$db->sql_numrows($result) || !$is_mod_auction){
$limit_it=50-$nums;
$sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."pages WHERE active='1' AND name!='' AND content!='' ORDER BY rand() limit ".$limit_it;
// $sql = "SELECT * FROM ".$GO_CONFIG->dbprefix."pages WHERE active='1' AND name!='' AND content!='' ORDER BY lastmodyfi DESC limit ".$limit_it;
//echo $sql;
$result = $db->sql_query($sql);
while($row=$db->sql_fetchrow($result)){
$htmlToText = new Html2Text (stripslashes($row['content']), 999915);
$content = $htmlToText->convert();
if ($content){
$tagLink="http://".$_SERVER["SERVER_NAME"]."/?pg=".$row['id'];
$city=$citys[rand(0,$citys_add_size)];
$word=$words_x[rand(0,$words_x_size)];
echo "";
echo "".$row['lastmodyfi']."";
echo "
";
$content= str_replace(" a "," ".$word." ".$q." ".$city." ",$content);
$content= str_replace(":"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace(";"," ".$q." ",$content);
$content= str_replace("–"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("x"," ".$word." ".$q." ".$city." ",$content);
$content= str_replace("\/"," ".$word." ".$q." ".$city." ",$content);
// $content= str_replace("•"," ".$word." ".$q." ".$city." ",$content);
echo $content;
echo "
";
echo "".$q.":
".date('l jS \of F Y h:i:s A');
echo "
";
}
$nums=$nums+1;
}//while
// }//if
if (!$nums){
echo "";
echo "";
echo "".$q.": ".date('l jS \of F Y h:i:s A');
// echo "";
// echo $content;
// echo "";
echo "
";
}
echo " ";
include("stopki/index_bottom.php");
//======================================================================
//--------------------------------------------------------------------------------------query end dla google tagow
//======================================================================
//--------------------------------------------------------MAIN if no uper options
}else{
// if ($GO_CONFIG->statystyka) makestat($_SERVER,0);
define("STATADDFROMFIRSTPAGE","1");
include("mod.php");
}
/*
//tlko w mod.php
//---cache start 2/2
if ($GO_CONFIG->chache_page_php_on){
$file_cache_index->end_cache();
}
//---cache end 2/2
*/
?>