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; }