 |
 |
 |
|
|
 |
adres e-mail:
[email protected] |
| |
| |
| |
| |
| |
*/
require('inc/config.php');
require('inc/mysql.class.php');
$db=new sql($db_host,$db_user,$db_pass,$db_name);
if($db)
{
$link=$_GET['link'];
if(empty($link)||$link<1) $link=18;
$id=$_GET["id"];
if(empty($id)||$id<1) $id="";
$page=$_GET["page"];
if(empty($page)||$page<1) $page=1;
switch($link)
{
case 1:
echo '
REZULTATY |
';
if($id)
{
$result=$db->query("select * from news where id='$id'");
$object=$db->fetch_object($result);
$data=stripslashes($object->data);
$news=stripslashes($object->news);
$tytul=stripslashes($object->tytul);
$tresc=stripslashes($object->tresc);
$db->free_result($result);
echo '
'.$data.' '.$tytul.'
'.$news.'
'.$tresc.' |
| |
| wr�� | ';
} else
{
$result=$db->query("select count(*) as ile from news");
$object=$db->fetch_object($result);
$ile=$object->ile;
$db->free_result($result);
$strony=ceil($ile/$howmany);
$ile2=0;
if($strony>1)
{
$od=($page-1)*$howmany;
$result=$db->query("select * from news order by id desc limit $od,$howmany");
} else
$result=$db->query("select * from news order by id desc");
while($object=$db->fetch_object($result))
{
$ile2++;
$idn=$object->id;
$data=stripslashes($object->data);
$news=stripslashes($object->news);
$tytul=stripslashes($object->tytul);
$tresc=stripslashes($object->tresc);
if(strlen($tresc)!=0)
echo '
'.$data.' '.$tytul.'
'.$news.'więcej » | ';
else
echo '
'.$data.' '.$tytul.'
'.$news.' | ';
echo '
 | ';
}
$db->free_result($result);
echo '
|
Strona: ';
if($strony==0) { echo '[1]'; }
if ($page>1) { echo '
« '; }
for($d=0; $d<$strony; $d++)
{
if($d+1==$page)
{
echo '['.($d+1).'] ';
} else {
echo '
'.($d+1).' ';
}
}
if ($page<$strony) { echo '
»'; }
}
echo '
|
';
break;
break;
case 13:
echo '
|
AKTUALNO�CI |
';
if($id)
{
$result=$db->query("select * from aktual where id='$id'");
$object=$db->fetch_object($result);
$data=stripslashes($object->data);
$aktual=stripslashes($object->aktual);
$tytul=stripslashes($object->tytul);
$tresc=stripslashes($object->tresc);
$db->free_result($result);
echo '
'.$data.' '.$tytul.'
'.$aktual.'
'.$tresc.' |
| |
| wr�� | ';
} else
{
$result=$db->query("select count(*) as ile from aktual");
$object=$db->fetch_object($result);
$ile=$object->ile;
$db->free_result($result);
$strony=ceil($ile/$howmany1);
$ile2=0;
if($strony>1)
{
$od=($page-1)*$howmany1;
$result=$db->query("select * from aktual order by id desc limit $od,$howmany1");
} else
$result=$db->query("select * from aktual order by id desc");
while($object=$db->fetch_object($result))
{
$ile2++;
$idn=$object->id;
$data=stripslashes($object->data);
$aktual=stripslashes($object->aktual);
$tytul=stripslashes($object->tytul);
$tresc=stripslashes($object->tresc);
if(strlen($tresc)!=0)
echo '
'.$data.' '.$tytul.'
'.$aktual.'więcej » | ';
else
echo '
'.$data.' '.$tytul.'
'.$aktual.' | ';
echo '
| ';
}
$db->free_result($result);
echo '
|
Strona: ';
if($strony==0) { echo '[1]'; }
if ($page>1) { echo '
« '; }
for($d=0; $d<$strony; $d++)
{
if($d+1==$page)
{
echo '['.($d+1).'] ';
} else {
echo '
'.($d+1).' ';
}
}
if ($page<$strony) { echo '
»'; }
}
echo '
|
';
break;
case 2:
case 3:
case 4:
case 5:
case 6:
case 7:
case 10:
case 12:
case 14:
case 15:
case 16:
case 17:
case 18:
case 19:
case 21:
case 20:
case 22:
case 23:
case 24:
case 25:
case 26:
case 27:
case 28:
case 29:
case 30:
case 31:
case 32:
case 33:
case 34:
case 35:
case 36:
case 37:
case 38:
case 39:
case 40:
case 41:
case 42:
case 43:
case 44:
case 45:
case 46:
case 47:
case 48:
case 49:
case 50:
case 51:
case 52:
case 53:
case 54:
case 55:
case 56:
case 57:
case 58:
case 59:
case 60:
case 61:
case 62:
case 63:
case 64:
case 65:
case 66:
case 67:
case 68:
case 69:
case 70:
case 71:
case 72:
case 73:
case 74:
case 75:
case 76:
case 77:
case 78:
case 79:
case 80:
case 81:
case 82:
case 83:
case 84:
case 85:
case 86:
case 87:
case 88:
case 89:
case 90:
case 91:
case 92:
case 93:
case 94:
case 95:
case 96:
case 97:
case 98:
case 99:
case 100:
case 101:
case 102:
case 103:
case 104:
case 105:
case 106:
case 107:
case 108:
case 109:
case 110:
case 111:
case 112:
case 113:
case 114:
case 115:
case 116:
case 117:
case 118:
case 119:
case 120:
case 121:
case 122:
case 123:
case 124:
case 125:
case 126:
case 127:
case 128:
case 129:
case 130:
case 131:
case 132:
case 133:
case 134:
case 135:
case 136:
case 137:
case 138:
case 139:
case 141:
case 142:
case 143:
case 144:
case 145:
case 146:
case 147:
case 148:
case 149:
case 150:
case 151:
case 152:
case 153:
case 154:
case 155:
case 156:
case 157:
case 158:
case 159:
case 160:
$result=$db->query("select * from links where lid=$link");
$object=$db->fetch_object($result);
$tytul=$object->title;
$tresc=$object->tresc;
$db->free_result($result);
echo '
|
'.$tytul.' |
'
.$tresc;
break;
case 9:
$kategoria=$_GET['kategoria'];
if(empty($kategoria)||$kategoria<1) $kategoria=1;
echo '
|
LINKI |
';
$result=$db->query("select count(*) as ile from linki where id_kat=$kategoria");
$object=$db->fetch_object($result);
$ile_zdjec=$object->ile;
$db->free_result($result);
if($ile_zdjec)
{
$ile_wierszy_pelnych=floor($ile_zdjec/3);
$ile_wierszy_niepelnych=$ile_zdjec-$ile_wierszy_pelnych*3;
$result=$db->query("select * from linki where id_kat=$kategoria");
echo '
';
for($i=0;$i<$ile_wierszy_pelnych;$i++)
{
echo '
';
for($j=0;$j<3;$j++)
{
$object=$db->fetch_object($result);
$idzdj=$object->id_link;
$nazwazdj=$object->zawar_link;
echo '
'.$nazwazdj.' | ';
}
echo '
';
}
echo '
';
if($ile_wierszy_niepelnych)
{
echo '
';
for($i=0;$i<$ile_wierszy_niepelnych;$i++)
{
$object=$db->fetch_object($result);
$idzdj=$object->id_link;
$nazwazdj=$object->zawar_link;
$picmin=$object->pic_min;
$pic=$object->pic;
$size=@getimagesize($photodir.'/'.$pic);
echo '
'.$nazwazdj.' | ';
}
echo '
';
}
$db->free_result($result);
}
break;
case 8:
$kategoria=$_GET['kategoria'];
if(empty($kategoria)||$kategoria<1) $kategoria=1;
echo '
GALERIA |
';
$result=$db->query("select count(*) as ile from zdjecia where id_kat=$kategoria");
$object=$db->fetch_object($result);
$ile_zdjec=$object->ile;
$db->free_result($result);
if($ile_zdjec)
{
$ile_wierszy_pelnych=floor($ile_zdjec/3);
$ile_wierszy_niepelnych=$ile_zdjec-$ile_wierszy_pelnych*3;
$result=$db->query("select * from zdjecia where id_kat=$kategoria");
echo '
';
for($i=0;$i<$ile_wierszy_pelnych;$i++)
{
echo '
';
for($j=0;$j<3;$j++)
{
$object=$db->fetch_object($result);
$idzdj=$object->id_zdj;
$nazwazdj=$object->nazwa_zdj;
$picmin=$object->pic_min;
$pic=$object->pic;
$size=@getimagesize($photodir.'/'.$pic);
echo '
'.$nazwazdj.'';
}
echo '
| ';
}
echo '
';
if($ile_wierszy_niepelnych)
{
echo '
';
for($i=0;$i<$ile_wierszy_niepelnych;$i++)
{
$object=$db->fetch_object($result);
$idzdj=$object->id_zdj;
$nazwazdj=$object->nazwa_zdj;
$picmin=$object->pic_min;
$pic=$object->pic;
$size=@getimagesize($photodir.'/'.$pic);
echo '
'.$nazwazdj.'';
}
echo '
|
';
}
$db->free_result($result);
}
break;
break;
}
$db->close($db);
}
?>
|
|
|
|
|
|
|
|
 |
|
|
