Exemple #1
0
function getArchivHTML()
{
    global $MySqliLink;
    $HTMLkod = '';
    $SelectStr = "SELECT C.id, C.CNev, O.OImgDir, C.CTartalom, C.CLeiras, OC.Cid, C.CSzerzoNev, C.CModositasTime\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.CLathatosag='-1'";
    $result = mysqli_query($MySqliLink, $SelectStr) or die("Hiba sMC 01 ");
    $rowDB = mysqli_num_rows($result);
    if ($rowDB > 0) {
        while ($row = mysqli_fetch_array($result)) {
            $Cid = $row['Cid'];
            $CNev = $row['CNev'];
            $OImgDir = $row['OImgDir'];
            $CTartalom = $row['CTartalom'];
            $CLeiras = $row['CLeiras'];
            if ($OImgDir != '') {
                $KepUtvonal = "img/oldalak/" . $OImgDir . "/";
            } else {
                $KepUtvonal = "img/oldalak/";
            }
            $HTMLimg = getElsoKepHTML($Cid, $KepUtvonal);
            /*        
                 $HTMLkod   .= "<div class ='divOElozetesKulso'>\n";          
                 $HTMLkod   .= "<div class = 'divOElozetesKep'>$HTMLimg</div>\n";   
                 $HTMLkod   .= "<div class='divOElozetesTartalom'>\n";
                 $HTMLkod   .= "<h3>".$CNev."</h3>\n";
                 if ($CLeiras!='') {$HTMLkod .= "<div class = 'divOElozetesLeir'>".$CLeiras."</div>\n";}    
                 $HTMLkod .= "</div>\n";
                 $HTMLkod .= "</div>\n";
            */
            $CTartalom = getCikkepCsereL($Cid, $CTartalom, $KepUtvonal);
            // Képek beillesztése #0, #1,.. helyére
            $CTartalom = SzintaxisCsere($CTartalom);
            $HTMLkod .= "<div class ='divCikkKulso'><h2>" . $CNev . "</h2>\n";
            $HTMLkod .= "<div class = 'divCikkTartalom'>\n";
            $HTMLkod .= $CTartalom . "\n";
            $HTMLkod .= "</div>\n";
            $HTMLkod .= "<p class='pCszerzoNev'> Szerző: " . $row['CSzerzoNev'] . "</p><p class='pCModTime'>Közzétéve: " . $row['CModositasTime'] . "</p></div>\n";
        }
        mysqli_free_result($result);
    } else {
        $HTMLkod = U_ARCH_URES;
    }
    return $HTMLkod;
}
Exemple #2
0
function getSzulooldalCikkelozetesekHTML($SelStr)
{
    global $MySqliLink, $Aktoldal, $AlapAdatok, $CCim;
    $Oid = $Aktoldal['id'];
    $HTMLkod = '';
    $SelectStr = $SelStr;
    $result = mysqli_query($MySqliLink, $SelectStr) or die("Hiba sMC 01 ");
    $rowDB = mysqli_num_rows($result);
    if ($rowDB > 0) {
        $AlapKep = 'img/ikonok/HeaderImg/' . $AlapAdatok['HeaderImg'];
        while ($row = mysqli_fetch_array($result)) {
            $Cid = $row['Cid'];
            $CNev = $row['CNev'];
            $OImgDir = $row['OImgDir'];
            $CTartalom = $row['CTartalom'];
            $CLeiras = $row['CLeiras'];
            $Horgony = "#" . getTXTtoURL($row['CNev']);
            $CCim = "&amp;cim=" . getTXTtoURL($row['CNev']);
            $CikkLink = "<a class='OElink CikkelozetesLink' href='?f0=" . $row['OUrl'] . $CCim . $Horgony . "'>" . $row['CNev'] . " " . U_RESZLETESEN . "...</a>";
            if ($OImgDir != '') {
                $KepUtvonal = "img/oldalak/" . $OImgDir . "/";
            } else {
                $KepUtvonal = "img/oldalak/";
            }
            $HTMLimg = getElsoKepHTML($Cid, $KepUtvonal);
            if ($HTMLimg == '') {
                $HTMLimg = "<img src='{$AlapKep}'  class = 'imgOE' alt=''>";
            }
            $HTMLkod .= "<div class ='divOElozetesKulso'>\n";
            $HTMLkod .= "<div class = 'divOElozetesKep'>{$HTMLimg}</div>\n";
            $HTMLkod .= "<div class='divOElozetesTartalom'>\n";
            $HTMLkod .= "<h3>" . $CNev . "</h3>\n";
            if ($CLeiras != '') {
                $HTMLkod .= "<div class = 'divOElozetesLeir'>" . $CLeiras . "</div>\n";
            }
            $HTMLkod .= "</div>\n";
            $HTMLkod .= $CikkLink;
            $HTMLkod .= "<p class='pCszerzoNev'>" . U_SZERZO . ": " . $row['CSzerzoNev'] . "</p>\n";
            $HTMLkod .= "<p class='pCModTime'>" . U_KOZZETEVE . ": " . $row['CModositasTime'] . " </p>\n";
            $HTMLkod .= "</div>\n";
        }
        mysqli_free_result($result);
    }
    if ($HTMLkod != '') {
        $HTMLkod = "<div class ='divCElozetesKulso'>\n <h2>" . U_HIRELOZETESEK . "</h2> {$HTMLkod}</div>";
    }
    return $HTMLkod;
}