';
print '
';
$hirek_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 0,5 ");
while($adat = mysql_fetch_assoc($hirek_select))
{
print '';
/*print '
';*/
$style1='style="width:99%; margin-left: auto; margin-right: auto;" ';
print '
'.$adat['hir_leir_text'].'
';
print '
';
}
print '
';
$hirek_select2 = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 0,5 ");
while($adat2 = mysql_fetch_assoc($hirek_select2))
{
$hir_date = substr($adat2['hir_date'], 0, 10);
print '
';
print '
';
//print '
';
print '
'.$adat2['hir_title'].'
'.$hir_date.' | ';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat2["hir_parent_id"]."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print $adat_kateg["hir_kateg_nev"];
}
if ($adat2['hir_kep'] <> 0)
{
print ' |
';
}
$sql_video_js_ell = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat2['hir_id']." and hir_text LIKE '%".$video_ell_szoveg."%' ") or die(mysql_error());
$res_video_js_ell = mysql_num_rows($sql_video_js_ell);
if ($res_video_js_ell <> 0)
{
print ' |
';
}
print ' |
';
print '
';
}
print '
';
print '
';
print '';
print '
';
//include ("videok.php");
print '
';
/* JS kiválogatás */
$hirek_js1_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 0,1 ");
while($adat_js1 = mysql_fetch_assoc($hirek_js1_select))
{
$hir_js1 = $adat_js1['hir_id'];
}
$hirek_js2_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 1,1 ");
while($adat_js2 = mysql_fetch_assoc($hirek_js2_select))
{
$hir_js2 = $adat_js2['hir_id'];
}
$hirek_js3_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 2,1 ");
while($adat_js3 = mysql_fetch_assoc($hirek_js3_select))
{
$hir_js3 = $adat_js3['hir_id'];
}
$hirek_js4_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 3,1 ");
while($adat_js4 = mysql_fetch_assoc($hirek_js4_select))
{
$hir_js4 = $adat_js4['hir_id'];
}
$hirek_js5_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=1 ORDER BY hir_date desc LIMIT 4,1 ");
while($adat_js5 = mysql_fetch_assoc($hirek_js5_select))
{
$hir_js5 = $adat_js5['hir_id'];
}
/* JS kiválogatás vége */
$hirek_list1_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 0,1 ");
while($adat_list1 = mysql_fetch_assoc($hirek_list1_select))
{
print '
';
print ''.$adat_list1['hir_title'].' ';
print '
';
$hirek_select_kateg_list1 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list1['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list1 = mysql_fetch_assoc($hirek_select_kateg_list1))
{
print ''.$adat_kateg_list1["hir_kateg_nev"].' ';
}
if ($adat_list1['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes1 = 'kepek/'.$adat_list1['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes1)) {
}
else
{
// mod 20171118 árpi
$style1='style="width:100%; margin-left: auto; margin-right: auto;" ';
print '
';
//print ''.$adat_list1['hir_leir_text'].'
';
print '
';
}
$hirek_list2_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 1,1 ");
while($adat_list2 = mysql_fetch_assoc($hirek_list2_select))
{
print '';
print ''.$adat_list2['hir_title'].' ';
print '
';
$hirek_select_kateg_list2 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list2['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list2 = mysql_fetch_assoc($hirek_select_kateg_list2))
{
print ''.$adat_kateg_list2["hir_kateg_nev"].' ';
}
if ($adat_list2['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes2 = 'kepek/'.$adat_list2['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes2)) {
}
else
{
//print '
';
//print ''.$adat_list2['hir_leir_text'].'
';
print '
';
}
$hirek_list3_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 2,1 ");
while($adat_list3 = mysql_fetch_assoc($hirek_list3_select))
{
print '
';
print ''.$adat_list3['hir_title'].' ';
print '
';
$hirek_select_kateg_list3 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list3['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list3 = mysql_fetch_assoc($hirek_select_kateg_list3))
{
print ''.$adat_kateg_list3["hir_kateg_nev"].' ';
}
if ($adat_list3['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes3 = 'kepek/'.$adat_list3['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes3)) {
}
else
{
//print '
';
//print ''.$adat_list3['hir_leir_text'].'
';
print '
';
}
$hirek_list4_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 3,1 ");
while($adat_list4 = mysql_fetch_assoc($hirek_list4_select))
{
print '';
print ''.$adat_list4['hir_title'].' ';
print '
';
$hirek_select_kateg_list4 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list4['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list4 = mysql_fetch_assoc($hirek_select_kateg_list4))
{
print ''.$adat_kateg_list4["hir_kateg_nev"].' ';
}
if ($adat_list4['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes4 = 'kepek/'.$adat_list4['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes4)) {
}
else
{
print '
';
//print ''.$adat_list4['hir_leir_text'].'
';
print '
';
}
print '
';
//include ("hirdetes_fooldal_kozep.php");
print '
';
$hirek_list5_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 4,1 ");
while($adat_list5 = mysql_fetch_assoc($hirek_list5_select))
{
print '
';
print ''.$adat_list5['hir_title'].' ';
print '
';
$hirek_select_kateg_list5 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list5['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list5 = mysql_fetch_assoc($hirek_select_kateg_list5))
{
print ''.$adat_kateg_list5["hir_kateg_nev"].' ';
}
if ($adat_list5['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes5 = 'kepek/'.$adat_list5['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes5)) {
}
else
{
print '
';
//print ''.$adat_list5['hir_leir_text'].'
';
print '
';
}
$hirek_list6_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 5,1 ");
while($adat_list6 = mysql_fetch_assoc($hirek_list6_select))
{
print '';
print ''.$adat_list6['hir_title'].' ';
print '
';
$hirek_select_kateg_list6 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list6['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list6 = mysql_fetch_assoc($hirek_select_kateg_list6))
{
print ''.$adat_kateg_list6["hir_kateg_nev"].' ';
}
if ($adat_list6['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes6 = 'kepek/'.$adat_list6['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes6)) {
}
else
{
print '
';
//print ''.$adat_list6['hir_leir_text'].'
';
print '
';
}
$hirek_list7_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 6,1 ");
while($adat_list7 = mysql_fetch_assoc($hirek_list7_select))
{
print '
';
print ''.$adat_list7['hir_title'].' ';
print '
';
$hirek_select_kateg_list7 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list7['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list7 = mysql_fetch_assoc($hirek_select_kateg_list7))
{
print ''.$adat_kateg_list7["hir_kateg_nev"].' ';
}
if ($adat_list7['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes7 = 'kepek/'.$adat_list7['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes7)) {
}
else
{
print '
';
//print ''.$adat_list7['hir_leir_text'].'
';
print '
';
}
$hirek_list8_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id<>".$hir_js1." and hir_id<>".$hir_js2." and hir_id<>".$hir_js3." and hir_id<>".$hir_js4." and hir_id<>".$hir_js5." ORDER BY hir_date desc LIMIT 7,1 ");
while($adat_list8 = mysql_fetch_assoc($hirek_list8_select))
{
print '';
print ''.$adat_list8['hir_title'].' ';
print '
';
$hirek_select_kateg_list8 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list8['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list8 = mysql_fetch_assoc($hirek_select_kateg_list8))
{
print ''.$adat_kateg_list8["hir_kateg_nev"].' ';
}
if ($adat_list8['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes8 = 'kepek/'.$adat_list8['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes8)) {
}
else
{
print '
';
//print ''.$adat_list8['hir_leir_text'].'
';
print '
';
}
print '
';
//include ("hirdetes_fooldal_also.php");
print '
';
/*print '
';
include ("hirdetes_fooldal_kozep.php");
print '
';*/
/* MÁSODIK CSAPAT! */
/*$hirek_list9_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 8,1 ");
while($adat_list9 = mysql_fetch_assoc($hirek_list9_select))
{
print '
';
print ''.$adat_list9['hir_title'].' ';
print '
';
$hirek_select_kateg_list9 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list9['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list9 = mysql_fetch_assoc($hirek_select_kateg_list9))
{
print ''.$adat_kateg_list9["hir_kateg_nev"].' ';
}
if ($adat_list9['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes9 = 'kepek/'.$adat_list9['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes9)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list10_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 9,1 ");
while($adat_list10 = mysql_fetch_assoc($hirek_list10_select))
{
print '';
print ''.$adat_list10['hir_title'].' ';
print '
';
$hirek_select_kateg_list10 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list10['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list10 = mysql_fetch_assoc($hirek_select_kateg_list10))
{
print ''.$adat_kateg_list10["hir_kateg_nev"].' ';
}
if ($adat_list10['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes10 = 'kepek/'.$adat_list10['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes10)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list11_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 10,1 ");
while($adat_list11 = mysql_fetch_assoc($hirek_list11_select))
{
print '
';
print ''.$adat_list11['hir_title'].' ';
print '
';
$hirek_select_kateg_list11 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list11['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list11 = mysql_fetch_assoc($hirek_select_kateg_list11))
{
print ''.$adat_kateg_list11["hir_kateg_nev"].' ';
}
if ($adat_list11['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes11 = 'kepek/'.$adat_list11['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes11)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list12_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 11,1 ");
while($adat_list12 = mysql_fetch_assoc($hirek_list12_select))
{
print '';
print ''.$adat_list12['hir_title'].' ';
print '
';
$hirek_select_kateg_list12 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list12['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list12 = mysql_fetch_assoc($hirek_select_kateg_list12))
{
print ''.$adat_kateg_list12["hir_kateg_nev"].' ';
}
if ($adat_list12['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes12 = 'kepek/'.$adat_list12['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes12)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list13_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 12,1 ");
while($adat_list13 = mysql_fetch_assoc($hirek_list13_select))
{
print '
';
print ''.$adat_list13['hir_title'].' ';
print '
';
$hirek_select_kateg_list13 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list13['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list13 = mysql_fetch_assoc($hirek_select_kateg_list13))
{
print ''.$adat_kateg_list13["hir_kateg_nev"].' ';
}
if ($adat_list13['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes13 = 'kepek/'.$adat_list13['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes13)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list14_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 13,1 ");
while($adat_list14 = mysql_fetch_assoc($hirek_list14_select))
{
print '';
print ''.$adat_list14['hir_title'].' ';
print '
';
$hirek_select_kateg_list14 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list14['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list14 = mysql_fetch_assoc($hirek_select_kateg_list14))
{
print ''.$adat_kateg_list14["hir_kateg_nev"].' ';
}
if ($adat_list14['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes14 = 'kepek/'.$adat_list14['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes14)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list15_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 14,1 ");
while($adat_list15 = mysql_fetch_assoc($hirek_list15_select))
{
print '
';
print ''.$adat_list15['hir_title'].' ';
print '
';
$hirek_select_kateg_list15 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list15['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list15 = mysql_fetch_assoc($hirek_select_kateg_list15))
{
print ''.$adat_kateg_list15["hir_kateg_nev"].' ';
}
if ($adat_list15['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes15 = 'kepek/'.$adat_list15['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes15)) {
}
else
{
print '
';
//print '
';
print '
';
}
$hirek_list16_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_kiemelt=0 ORDER BY hir_date desc LIMIT 15,1 ");
while($adat_list16 = mysql_fetch_assoc($hirek_list16_select))
{
print '';
print ''.$adat_list16['hir_title'].' ';
print '
';
$hirek_select_kateg_list16 = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat_list16['hir_parent_id']."") or die(mysql_error());
while($adat_kateg_list16 = mysql_fetch_assoc($hirek_select_kateg_list16))
{
print ''.$adat_kateg_list16["hir_kateg_nev"].' ';
}
if ($adat_list16['hir_kep'] <> 0)
{
print ' |
';
$kep_ellenorzes16 = 'kepek/'.$adat_list16['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes16)) {
}
else
{
print '
';
//print '
';
print '
';
}*/
/* MÁSODIK CSAPAT VÉGE! */
print '
';
//include ("hirdetes_fooldal_also.php");
print '
';
print '
';
print '
';
include ("legfrissebb.php");
print '
';
}
else if ($kateg <> '' and $id == '' and $cikk == '' and $cimke == '')
{
?>
';
$sql_hirek_ell = mysql_query("SELECT * FROM hirek WHERE hir_parent_id=".$kateg." ") or die(mysql_error());
$res_hirek_ell = mysql_num_rows($sql_hirek_ell);
if ($res_hirek_ell <> 0)
{
print '
';
$hirek_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_parent_id=".$kateg." ORDER BY hir_date desc LIMIT 0,3 ");
while($adat = mysql_fetch_assoc($hirek_select))
{
print '
'.$adat['hir_leir_text'].'
';
print '
';
}
print '
';
$hirek_select2 = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_parent_id=".$kateg." ORDER BY hir_date desc LIMIT 0,3 ");
while($adat2 = mysql_fetch_assoc($hirek_select2))
{
$hir_date = substr($adat2['hir_date'], 0, 10);
print '
';
print '
';
//print '
';
print '
'.$adat2['hir_title'].'
'.$hir_date.' | ';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat2["hir_parent_id"]."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print $adat_kateg["hir_kateg_nev"];
}
if ($adat2['hir_kep'] <> 0)
{
print ' |
';
}
$sql_video_js_ell = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat2['hir_id']." and hir_text LIKE '%".$video_ell_szoveg."%' ") or die(mysql_error());
$res_video_js_ell = mysql_num_rows($sql_video_js_ell);
if ($res_video_js_ell <> 0)
{
print ' |
';
}
print ' |
';
print '
';
}
print '
';
}
print '
';
//include ("videok.php");
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$kateg."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print $adat['hir_leir_text'];
print '
';
print '
';
}
else
{
print '
';
/*print '
';*/
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$kateg."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print ''.$adat['hir_leir_text'].'
';
/*print '
';*/
print '
';
print '
';*/
print '
';
}
$kozep_hirdetes_fele++;
if ($kozep_hirdetes_fele == $kozep_hirdetes_szamolas_v)
{
include ("hirdetes_kategoria_kozep.php");
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$kateg."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print ''.$adat['hir_leir_text'].'
';
print '
';
print '
';
}
else
{
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$kateg."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print $adat['hir_leir_text'];
print '
';
print '
';
}
}*/
print '';
$oldal_also = $oldal - 8;
$oldal_felso = $oldal + 8;
$hirek_lap = mysql_query("SELECT count(hir_id) as szumma FROM hirek WHERE hir_parent_id=".$kateg." ");
while($adat_lap = mysql_fetch_assoc($hirek_lap))
{
print ' ... ';
$oldalak = ceil($adat_lap['szumma']/$hirek_megjelenitesenek_szama);
for( $i=0; $i<$oldalak; $i++ )
{
/*if ($oldal_felso < $i > $oldal_also)
{*/
$i_kontrol = $i+1;
if ($oldal_felso > $i_kontrol and $oldal_also < $i_kontrol)
{
if( $i+1 != $oldal )
{
print ''.($i+1).' ';
}
else
{
print ($i+1);
print ' ';
}
}
}
print ' ... ';
}
print ' ';
include ("hirdetes_kategoria_also.php");
print '
';
include ("legfrissebb.php");
print '
';
}
else if ($kateg == '' and $id == '' and $cikk == '' and $cimke <> '')
{
?>
';
$sql_hirek_ell = mysql_query("SELECT * FROM hirek WHERE cimke1='".$cimke."' or cimke2='".$cimke."' or cimke3='".$cimke."' or cimke4='".$cimke."' or cimke5='".$cimke."' or cimke6='".$cimke."' or cimke7='".$cimke."' or cimke8='".$cimke."' or cimke9='".$cimke."' or cimke10='".$cimke."' ") or die(mysql_error());
$res_hirek_ell = mysql_num_rows($sql_hirek_ell);
if ($res_hirek_ell <> 0)
{
print '
';
$hirek_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video, cimke1, cimke2, cimke3, cimke4, cimke5, cimke6, cimke7, cimke8, cimke9, cimke10 FROM hirek WHERE cimke1='".$cimke."' or cimke2='".$cimke."' or cimke3='".$cimke."' or cimke4='".$cimke."' or cimke5='".$cimke."' or cimke6='".$cimke."' or cimke7='".$cimke."' or cimke8='".$cimke."' or cimke9='".$cimke."' or cimke10='".$cimke."' ORDER BY hir_date desc LIMIT 0,3 ");
while($adat = mysql_fetch_assoc($hirek_select))
{
print '
'.$adat['hir_leir_text'].'
';
print '
';
}
print '
';
$hirek_select2 = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_kiemelt, hir_kep, hir_video, cimke1, cimke2, cimke3, cimke4, cimke5, cimke6, cimke7, cimke8, cimke9, cimke10 FROM hirek WHERE cimke1='".$cimke."' or cimke2='".$cimke."' or cimke3='".$cimke."' or cimke4='".$cimke."' or cimke5='".$cimke."' or cimke6='".$cimke."' or cimke7='".$cimke."' or cimke8='".$cimke."' or cimke9='".$cimke."' or cimke10='".$cimke."' ORDER BY hir_date desc LIMIT 0,3 ");
while($adat2 = mysql_fetch_assoc($hirek_select2))
{
$hir_date = substr($adat2['hir_date'], 0, 10);
print '
'.$adat2['hir_title'].'
'.$hir_date.' | ';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat2["hir_parent_id"]."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print $adat_kateg["hir_kateg_nev"];
}
if ($adat2['hir_kep'] <> 0)
{
print ' |
';
}
$sql_video_js_ell = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat2['hir_id']." and hir_text LIKE '%".$video_ell_szoveg."%' ") or die(mysql_error());
$res_video_js_ell = mysql_num_rows($sql_video_js_ell);
if ($res_video_js_ell <> 0)
{
print ' |
';
}
print '
';
}
print '
';
}
print '
';
include ("hirdetes_kategoria_fent.php");
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print $adat['hir_leir_text'];
print '
';
print '
';
}
else
{
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print ''.$adat['hir_leir_text'].'
';
print '
';
print '
';
}
}
include ("hirdetes_kategoria_kozep.php");
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print ''.$adat['hir_leir_text'].'
';
print '
';
print '
';
}
else
{
print '
';
print ''.$adat['hir_title'].'
';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print ''.$adat_kateg["hir_kateg_nev"].' ';
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
print $adat['hir_leir_text'];
print '
';
print '
';
}
}
include ("hirdetes_kategoria_also.php");
print '
';
include ("legfrissebb.php");
print '
';
}
else if ($id <> '' and $cikk == '' and $cimke == '')
{
?>
';
$hirek_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_mod_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_id=".$id." ");
while($adat = mysql_fetch_assoc($hirek_select))
{
print ''.$adat['hir_title'].' ';
print '
';
print '';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print '
'.$adat_kateg["hir_kateg_nev"].' ';
}
print '
';
print '';
print $adat['hir_date'];
if ($adat['hir_mod_date'] <> '0000-00-00 00:00:00')
{
print ' | Frissítve: ';
print $adat['hir_mod_date'];
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
}
$sql_video1_ell = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat['hir_id']." and hir_text LIKE '%".$video_ell_szoveg."%' ") or die(mysql_error());
$res_video1_ell = mysql_num_rows($sql_video1_ell);
if ($res_video1_ell <> 0)
{
print ' |
';
}
print '
';
//print '
';
print ''.$adat['hir_leir_text'].'
';
print '
';
/*print 'Hírdetés: ';
print '';*/
include ("hirdetes_hirben_kozte.php");
/*print '
';
print ' ';*/
$kep_ellenorzes = 'kepek/'.$adat['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes)) {
}
else
{
print '
';
}
print '
';
print 'Címkék: ';
$hirek_select_cimke = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat['hir_id']."") or die(mysql_error());
while($adat_cimke = mysql_fetch_assoc($hirek_select_cimke))
{
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
}
print '
';
/*print 'Hírdetés: ';
print '';*/
include ("hirdetes_hirben_also.php");
/*print '
';*/
print ' ';
if ($adat['hir_kep'] <> 0)
{
print '
';
//print '';
print ' ';
print 'Kapcsolódó képgaléria: ';
print ' ';
/*print ' ';
print ' ';*/
print '
';
print '
';
}
print 'Megosztás: ';
print '
';
print '
';
print '
';
}
print '
';
include ("legfrissebb.php");
print '
';
}
else if ($id == '' and $cikk <> '' and $cimke == '')
{
?>
';
$hirek_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_mod_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_gylink='".$cikk."' ");
while($adat = mysql_fetch_assoc($hirek_select))
{
print ''.$adat['hir_title'].' ';
print '
';
print '';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print '
'.$adat_kateg["hir_kateg_nev"].' ';
}
print '
';
print '';
print $adat['hir_date'];
if ($adat['hir_mod_date'] <> '0000-00-00 00:00:00')
{
print ' | Frissítve: ';
print $adat['hir_mod_date'];
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
}
print '
';
//print '
';
print $adat['hir_leir_text'];
print '
';
/*print 'Hírdetés: ';
print '';*/
include ("hirdetes_hirben_kozte.php");
/*print '
';
print ' ';*/
$kep_ellenorzes = 'kepek/'.$adat['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes)) {
}
else
{
print '
';
}
print '
';
print 'Címkék: ';
$hirek_select_cimke = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat['hir_id']."") or die(mysql_error());
while($adat_cimke = mysql_fetch_assoc($hirek_select_cimke))
{
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
}
print '
';
/*print 'Hírdetés: ';
print '';*/
include ("hirdetes_hirben_also.php");
/*print '
';
print ' ';*/
if ($adat['hir_kep'] <> 0)
{
print '
';
print '';
print ' ';
print ' ';
print ' ';
print '
';
print '
';
}
print 'Megosztás: ';
print '
';
print 'Hozzászólás: ';
print '
';
print '
';
}
print '
';
include ("legfrissebb.php");
print '
';
}
else
{
?>
';
$hirek_select = mysql_query("SELECT hir_id, hir_parent_id, hir_title, hir_leir_text, hir_text, hir_bovitet_text, hir_date, hir_mod_date, hir_kiemelt, hir_kep, hir_video FROM hirek WHERE hir_gylink='".$cikk."' ");
while($adat = mysql_fetch_assoc($hirek_select))
{
print ''.$adat['hir_title'].' ';
print '
';
print '';
$hirek_select_kateg = mysql_query("SELECT hir_kateg_id, hir_kateg_nev FROM hirek_kateg WHERE hir_kateg_id=".$adat['hir_parent_id']."") or die(mysql_error());
while($adat_kateg = mysql_fetch_assoc($hirek_select_kateg))
{
print '
'.$adat_kateg["hir_kateg_nev"].' ';
}
print '
';
print '';
print $adat['hir_date'];
if ($adat['hir_mod_date'] <> '0000-00-00 00:00:00')
{
print ' | Frissítve: ';
print $adat['hir_mod_date'];
}
if ($adat['hir_kep'] <> 0)
{
print ' |
';
}
print '
';
//print '
';
print $adat['hir_leir_text'];
print '
';
/*print 'Hírdetés: ';
print '';
include ("hirdetes_hirben_kozte.php");
print '
';
print ' ';*/
$kep_ellenorzes = 'kepek/'.$adat['hir_id'].'.jpg';
if (!file_exists($kep_ellenorzes)) {
}
else
{
print '
';
}
print '
';
print 'Címkék: ';
$hirek_select_cimke = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat['hir_id']."") or die(mysql_error());
while($adat_cimke = mysql_fetch_assoc($hirek_select_cimke))
{
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
print ' ';
}
print '
';
/*print 'Hírdetés: ';
print '';
include ("hirdetes_hirben_also.php");
print '
';
print ' ';*/
if ($adat['hir_kep'] <> 0)
{
print '
';
print '';
print ' ';
print ' ';
print ' ';
print '
';
print '
';
}
print 'Megosztás: ';
print '
';
print '
';
print '
';
}
print '
';
include ("legfrissebb.php");
print '
';
print'HIRDETÉS';
echo'
';
}
megjobb();
alja('no');
print "";
stdfooter();
?>
';
//print ''; //print '
';
print '
';
}
$sql_video1_ell = mysql_query("SELECT * FROM hirek WHERE hir_id=".$adat_list1['hir_id']." and hir_text LIKE '%".$video_ell_szoveg."%' ") or die(mysql_error());
$res_video1_ell = mysql_num_rows($sql_video1_ell);
if ($res_video1_ell <> 0)
{
print ' | 
';
}
print ' | 
';
//print '
';
}
print '
';
}
print '
';
}
print '
';
}
print '
';
}
print '
';
}
print '
';
}
print '
';
print '
