function Menu_Szint4($OID)
{
global $Aktoldal, $SzuloOldal, $NagyszuloOldal, $MySqliLink, $DedSzuloId;
$HTMLkod = '';
//Negyedik szint
$SelectStr = "SELECT * FROM Oldalak WHERE OSzuloId={$OID} order by OPrioritas DESC, ONev ";
$result = mysqli_query($MySqliLink, $SelectStr) or die("Hiba OM 41 ");
$rowDB = mysqli_num_rows($result);
if ($rowDB > 0) {
while ($row = mysqli_fetch_array($result)) {
$ONev = $row['ONev'];
$OURL = $row['OUrl'];
$OID = $row['id'];
$OSzulo = $row['OSzuloId'];
if (getOMenuLathatosagTeszt($OID) > 0) {
//Ha az adott oldal aktív, akkor az 'AktLink' osztályba kerül
if ($OID == $Aktoldal['id'] || $OID == $SzuloOldal['id'] || $OID == $NagyszuloOldal['id'] || $OID == $DedSzuloId) {
$AktLink = "class='AktLink'";
} else {
$AktLink = "";
}
$HTMLkod .= "<li class='M4'><a href='?f0={$OURL}' {$AktLink}>{$ONev}</a>";
$HTMLkod .= "</li>\n";
}
}
mysqli_free_result($result);
}
if ($HTMLkod > '') {
$HTMLkod = "<ul class='Ul4'>\n {$HTMLkod} </ul>\n";
}
return $HTMLkod;
}
function getCikkElozetesLapinfo($MaxDBperOldal, $Tipus)
{
global $MySqliLink, $Aktoldal, $oURL, $oLap, $CCim;
$AktLap = 1;
$LapozHTML = '';
if ($_SESSION['LapozCikk' . 'OUrl'] == $Aktoldal['OUrl']) {
$AktLap = $_SESSION['LapozCikk' . 'CT'];
}
if ($AktLap > 0) {
$AktLap = $oLap;
}
$arrGyermekek = array();
$arrLapinfo = array();
$arrLapinfo['SelectStr'] = '';
$arrLapinfo['OsszDB'] = 0;
$arrLapinfo['LapozHTML'] = '';
$arrLapinfo['OImgDir'] = '';
$AktCCimURL = trim(getTXTtoURL($CCim));
$FSzint = $_SESSION['AktFelhasznalo' . 'FSzint'];
if ($FSzint > 3) {
if ($Tipus == 0) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE C.KoElozetes>0 \n ORDER BY C.KoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
if ($Tipus == 1) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE O.OSzuloId=" . $Aktoldal['id'] . " AND C.SZoElozetes>0 \n ORDER BY C.SZoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
}
if ($FSzint == 3) {
if ($Tipus == 0) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE C.KoElozetes>0 AND\n (C.CSzerzo=" . $_SESSION['AktFelhasznalo' . 'id'] . " OR \n C.CLathatosag>0 )\n ORDER BY C.KoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
if ($Tipus == 1) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE O.OSzuloId=" . $Aktoldal['id'] . " AND C.SZoElozetes>0 AND\n (C.CSzerzo=" . $_SESSION['AktFelhasznalo' . 'id'] . " OR \n C.CLathatosag>0 )\n ORDER BY C.SZoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
}
if ($FSzint == 2) {
if ($Tipus == 0) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE C.KoElozetes>0 AND\n C.CLathatosag>0 \n ORDER BY C.KoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
if ($Tipus == 1) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE O.OSzuloId=" . $Aktoldal['id'] . " AND C.SZoElozetes>0 AND\n C.CLathatosag>0 \n ORDER BY C.SZoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
}
if ($FSzint == 1) {
if ($Tipus == 0) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE C.KoElozetes>0 AND\n C.CLathatosag>2 \n ORDER BY C.KoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
if ($Tipus == 1) {
$SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas, OC.Oid\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE O.OSzuloId=" . $Aktoldal['id'] . " AND C.SZoElozetes>0 AND\n C.CLathatosag>2 \n ORDER BY C.SZoElozetes DESC, OC.CPrioritas DESC, C.CModositasTime DESC";
}
}
$result = mysqli_query($MySqliLink, $SelectStr) or die("Hiba CLInf 01a ");
$MaxCikk = mysqli_num_rows($result);
if ($MaxCikk > 0) {
$CikkCT = 0;
$AktCikkCT = 0;
$AktCikkCT = -1;
while ($row = mysqli_fetch_array($result)) {
if ($FSzint > 4 || getOMenuLathatosagTeszt($row['Oid']) > 0) {
$arrGyermekek[] = $row['id'];
// Az aktuális cikk sorszámának meghatározása
$AktCikkURL = trim(getTXTtoURL($row['CNev']));
if (strcmp($AktCikkURL, $AktCCimURL) == 0) {
$AktCikkCT = $CikkCT;
}
$CikkCT++;
}
}
$MaxCikk = count($arrGyermekek);
if ($MaxCikk > 0) {
$strIdLista = '';
if ($MaxCikk > $MaxDBperOldal) {
$MaxLap = ($MaxCikk - 1) / $MaxDBperOldal;
settype($MaxLap, "integer");
$MaxLap++;
if ($AktLap > $MaxLap) {
$AktLap = $MaxLap;
}
if ($AktLap < 1) {
$AktLap = 1;
}
$AktElsoCikk = ($AktLap - 1) * $MaxDBperOldal;
$AktUtolsoCikk = $AktLap * $MaxDBperOldal;
if ($AktUtolsoCikk > $MaxCikk) {
$AktUtolsoCikk = $MaxCikk;
}
$CikkAktDBSzam = $AktUtolsoCikk - $AktElsoCikk;
$arrIdLista = array_slice($arrGyermekek, $AktElsoCikk, $CikkAktDBSzam);
$strIdLista = implode(",", $arrIdLista);
} else {
$strIdLista = implode(",", $arrGyermekek);
}
// A SelectStr összeállítása
if ($strIdLista != '') {
$arrLapinfo['SelectStr'] = "\n SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime, O.OUrl, OC.CPrioritas\n FROM Cikkek AS C\n LEFT JOIN OldalCikkei AS OC \n ON OC.Cid = C.id\n LEFT JOIN Oldalak AS O\n ON OC.Oid = O.id\n WHERE C.id IN ({$strIdLista}) ORDER BY FIELD(C.id, {$strIdLista}) ";
} else {
$arrLapinfo['SelectStr'] = "";
}
//Lapozó sávok összeállítása
if (count($arrGyermekek) > $MaxDBperOldal) {
$EllsoLap = $AktLap - 5;
if ($EllsoLap < 1) {
$EllsoLap = 1;
}
$UtolsoLap = $EllsoLap + 10;
if ($UtolsoLap > $MaxLap) {
$UtolsoLap = $MaxLap;
}
$_SESSION['LapozCikk' . 'OUrl'] = $Aktoldal['OUrl'];
$_SESSION['LapozCikk' . 'CT'] = $AktLap;
// Gyors vissza
$LapozHTML = '';
if ($AktLap > 5) {
$AktLap1 = $AktLap - 5;
if ($AktLap1 > 1) {
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "&lap={$AktLap1}'> << </a></li>";
} else {
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "'> << </a></li>";
}
}
// Vissza
if ($AktLap > 2) {
$AktLap1 = $AktLap - 1;
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "&lap={$AktLap1}'> < </a></li>";
}
if ($AktLap == 2) {
$AktLap1 = $AktLap - 1;
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "'> < </a></li>";
}
// Számozott
if ($AktLap == 1) {
$AktLink = " class='AktLink' ";
} else {
$AktLink = "";
}
if ($EllsoLap < 2) {
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "' {$AktLink}> 1 </a></li>";
}
for ($i = $EllsoLap + 1; $i <= $UtolsoLap; $i++) {
if ($AktLap == $i) {
$AktLink = " class='AktLink' ";
} else {
$AktLink = "";
}
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "&lap={$i}' {$AktLink}> {$i} </a></li>";
}
// Előre
if ($AktLap < $MaxLap) {
$AktLap1 = $AktLap + 1;
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "&lap={$AktLap1}'> > </a></li>";
}
// Gyors előre
if ($AktLap + 5 < $MaxLap) {
$AktLap1 = $AktLap + 5;
$LapozHTML .= "<li><a href='?f0=" . $Aktoldal['OUrl'] . "&lap={$AktLap1}'> >> </a></li>";
}
$LapozHTML = "<div class='divOLapozas'>{$LapozHTML} </div>";
}
} else {
$arrLapinfo['SelectStr'] = '';
}
}
if ($MaxCikk > 0) {
mysqli_free_result($result);
}
$arrLapinfo['LapozHTML'] = $LapozHTML;
return $arrLapinfo;
}
