";
$sql_add_a ="";
$sql_add_b ="";
$sql_add ="";
for($i=0;$idbprefix."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 "
".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 "
".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 "
".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 "";
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
*/
?>