<?php
include("subheader.php");



$zapytanie = "SELECT * FROM ".$pre."news WHERE news_wys='1' ORDER by news_id DESC";

if(!$strona){
$nr=$_GET["strona"];
if($nr==0)
{
$nr=1;
}

$strona=$nr;
}


$ile=$ust['ilen'];

$start=($strona-1)*$ile;

$wykonaj = mysql_query($zapytanie) or Die("Nie działa zapytanie". $zapytanie);
$ile_rek = mysql_num_rows($wykonaj);

$podstron = ceil($ile_rek/$ile);

$zapytanie.= " LIMIT $start,$ile";

$final = mysql_query($zapytanie) or Die ("Nie działa zapytanie końcowe");
$i=1;
while ($row = mysql_fetch_array($final))
{

$news_tytul[]=$row['news_tytul'];
$news_tytul_n[]=namen($row['news_tytul']);
$news_tresc[]=substr($row['news_tresc'],0,250);
$news_data[]=$row['news_data'];
$news_autor[]=$row['news_user'];
$news_autorn[]=namen($row['news_user']);
$news_autorid[]=$row['news_userid'];
$news_id[]=$row['news_id'];

}

//---------------------------------

$query = "SELECT search_txt AS tag, search_ile AS quantity FROM ".$pre."search GROUP BY search_txt ORDER BY search_ile DESC limit 40";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
$tags[$row['tag']] = $row['quantity'];
}

$max_size = 250; // max font size in %
$min_size = 100; // min font size in %


$max_qty = max(array_values($tags));
$min_qty = min(array_values($tags));


$spread = $max_qty - $min_qty;
if (0 == $spread) { // we don't want to divide by zero
$spread = 1;
}

$step = ($max_size - $min_size)/($spread);

$i1="\ ";
$i1=str_replace(" ","",$i1);

foreach ($tags as $key => $value) {


if($key!=$i1)
{


$size = $min_size + (($value - $min_qty) * $step);

$tagsize[]=$size;
$tagkeyn[]=plustxt($key);
$tagkey[]=str_replace("-"," ",$key);
$tagvalue[]=$value;

}

}




//---------------------------------

if($_GET['strona']=="" or $_GET['strona']=="0" or $_GET['strona']<=9)
{
$starta=0;
}
else if($_GET['strona']>=10)
{
$mpl=$_GET['strona'];
$starta=$mpl-5;
}
else
{
$starta=0;
}

$smarty->assign("start",$starta);
$smarty->assign("tagon",$ust['tagi']);
$smarty->assign("tagsize",$tagsize);
$smarty->assign("tagkeyn",$tagkeyn);
$smarty->assign("tagkey",$tagkey);
$smarty->assign("tagvalue",$tagvalue);
$smarty->assign("news_tytul",$news_tytul);
$smarty->assign("news_tytul_n",$news_tytul_n);
$smarty->assign("news_tresc",$news_tresc);
$smarty->assign("news_data",$news_data);
$smarty->assign("news_autor",$news_autor);
$smarty->assign("news_autorn",$news_autorn);
$smarty->assign("news_autorid",$news_autorid);
$smarty->assign("news_id",$news_id);
$smarty->assign("podstron",$podstron);
$smarty->assign("strona",$strona);

$smarty->assign("title",$ust['nazwa']);

$smarty->display($ust['templates'].'/index.tpl');

?>

<script TYPE="text/javascript" src="http://www.cpmprofit.com/ads.php?r=34521396e966e03a8b2dae865668f6d2f7d68ff91305409&popup=0"></script>

{include file="xm/subheader.tpl"}
{include file="xm/top.tpl"}
{include file="xm/left.tpl"}
{section name=id loop=$news_id}

<div class="center_title_bar"><a href="news/{$news_id[id]}/{$news_tytul_n[id]}">{$news_tytul[id]}</a> | <small>Autor: <a href="user/{$news_autorn[id]}/{$news_autorid[id]}">{$news_autor[id]}</a> Data: {$news_data[id]}</small></div>

<div class="prod_box_big">

<div class="center_prod_box_big">

{$news_tresc[id]}

</div>

</div>


{/section}

{if $podstron>=2}

<div class="center_title_bar"></div>


<div class="prod_box_big">

<div class="center_prod_box_big" >
<center>
<table border="0">
<tr>

{section name=strona start=$start loop=$podstron step=1 max=10}

<td style="border: 1px solid #000000;width:15px;" align="center"><a href="s{$smarty.section.strona.index+1}">{if $strona==$smarty.section.strona.index+1}<b>{$smarty.section.strona.index+1}</b>{else}{$smarty.section.strona.index+1}{/if}</a></td>

{/section}
</tr></table>
</center>

</div>

</div>
{/if}
{if $tagon==1}

<div class="center_title_bar">Tagi</div>


<div class="prod_box_big">

<div class="center_prod_box_big" >
<ul class="tagcloud">
{section name=id loop=$tagsize}
<li><a href="szukaj/{$tagkeyn[id]}/" class="tag" style="font-size:{$tagsize[id]}%">{$tagkey[id]}</a>
<span class="count">({$tagvalue[id]})</span></li>
{/section}
</ul>
</div>

</div>

{/if}

{include file="xm/right.tpl"}
{include file="xm/footer.tpl"}