COMENIUS PROJECT
PROJECT DESCRIPTION partners news products and teaching materials blog photos login

New theme:

"; if($novetema) { $autor = $_SESSION['minuid']; $datum = getdate(); $datum = "$datum[year]-$datum[mon]-$datum[mday] $datum[hours]:$datum[minutes]:$datum[seconds]"; $set = array(); $set["kapitola"] = "'$novetema'"; $set["autor"] = "'$autor'"; $set["datum"] = "'$datum'"; mysql_query("INSERT INTO minblog (" . implode(", ", array_keys($set)) . ") VALUES (" . implode(", ", $set) . ")"); } // end if($novetema) if($edituloz=="NEW") { $autor = $_SESSION['minuid']; $datum = getdate(); $datum = "$datum[year]-$datum[mon]-$datum[mday] $datum[hours]:$datum[minutes]:$datum[seconds]"; if(!$edittextp){$edittextp="...";} $set = array(); $set["kapitola"] = "'$showbl'"; $set["nazevclanku"] = "'$editnazevclankup'"; $set["text"] = "'$edittextp'"; $set["autor"] = "'$autor'"; $set["datum"] = "'$datum'"; mysql_query("INSERT INTO minblog (" . implode(", ", array_keys($set)) . ") VALUES (" . implode(", ", $set) . ")"); } // end if($edituloz=="NEW") }// end if(strstr($_SESSION['minuprava'],"mini")) // end------novy-------- // vypis temat $query = 'SELECT * ' . ' FROM `minblog`' . ' WHERE ( `minblog`.`text` = "" )' . ' ORDER BY `minblog`.`datum` '; $result = mysql_query($query); $num_results = mysql_num_rows($result); $i =0; while($i<$num_results) { $row = mysql_fetch_array($result); $idblog = $row["idblog"]; $kapitola = $row["kapitola"]; $autor = $row["autor"]; $datum = $row["datum"]; // najit prispevky $query = 'SELECT * ' . ' FROM `minblog`' . ' WHERE ( `minblog`.`kapitola` = "'.$idblog.'" )'; $resultp = mysql_query($query); $num_resultsp = mysql_num_rows($resultp); // konec najit prispevky //$sezbamtemat = $sezbamtemat."
  • $kapitola ($num_resultsp)"; $sezbamtemat = "
  • $kapitola ($num_resultsp)".$sezbamtemat; $prispevek = ""; $i++; } // end while($i<$num_results) // najit prispevky II if(!$showbl){$showbl = $idblog;} // echo $showbl; $query = 'SELECT * ' . ' FROM `minblog`' . ' WHERE ( `minblog`.`kapitola` = "'.$showbl.'" )' . ' ORDER BY `minblog`.`datum` DESC'; $resultp = mysql_query($query); $num_resultsp = mysql_num_rows($resultp); $ip =0; while($ip<$num_resultsp) { $rowp = mysql_fetch_array($resultp); $idblogp = $rowp["idblog"]; $kapitolap = $rowp["kapitola"]; $autorp = $rowp["autor"]; $datump = $rowp["datum"]; $nazevclankup = $rowp["nazevclanku"]; $textp = nl2br($rowp["text"]); // najit autora $querya = 'SELECT * ' . ' FROM `minhsl`' . ' WHERE ( `minhsl`.`id` ' . ' = ("'.$autorp.'"))'; $resulta = mysql_query($querya); $rowa = mysql_fetch_array($resulta); $autor_jmeno = htmlspecialchars(stripslashes($rowa["jmeno"])); $autor_prijmeni = htmlspecialchars(stripslashes($rowa["prijmeni"])); $autor_sex = htmlspecialchars(stripslashes($rowa["sex"])); $autor_titulpred = htmlspecialchars(stripslashes($rowa["titulpred"])); $autor_titulza = htmlspecialchars(stripslashes($rowa["titulza"])); $autor_partner = htmlspecialchars(stripslashes($rowa["partner"])); if($autor_titulza){$autor_titulza=", ".$autor_titulza;} $queryc = 'SELECT * ' . ' FROM `minpartners`' . ' WHERE ( `minpartners`.`partner_id` ' . ' = ("'.$autor_partner.'"))'; $resultc = mysql_query($queryc); $rowc = mysql_fetch_array($resultc); $autor_city = htmlspecialchars(stripslashes($rowc["city"])); $partner_id = htmlspecialchars(stripslashes($rowc["partner_id"])); $autor = " $autor_titulpred $autor_jmeno $autor_prijmeni"."$autor_titulza
    $autor_city
    $datump
    "; // konec najit autora if(strstr($_SESSION['minuprava'],"administr") OR (strstr($_SESSION['minuprava'],"mini") AND $_SESSION['minuid']==$autorp) OR (strstr($_SESSION['minuprava'],"ministr") AND $_SESSION['minpartner'] ==$partner_id) ) {$editovat=" ";}else{$editovat="";} // EDITACE blog if((strstr($_SESSION['minuprava'],"administr") OR (strstr($_SESSION['minuprava'],"mini") AND $_SESSION['minuid']==$autorp) OR (strstr($_SESSION['minuprava'],"ministr") AND $_SESSION['minpartner'] ==$partner_id) ) AND $blogtoedit == $idblogp) { $vypisblogu = $vypisblogu."
    $autorTitle:

    Text:

    "; } else { $vypisblogu = $vypisblogu."
    $autor$nazevclankup $textp $editovat
    "; } // end if editace $ip++; } // end while($ip<$num_resultsp) // najít název kapitoly blogu $query = 'SELECT * ' . ' FROM `minblog`' . ' WHERE ( `minblog`.`idblog` = "'.$showbl.'" )'; $result = mysql_query($query); $row = mysql_fetch_array($result); $kapitola = trim($row["kapitola"]); $autorkap = trim($row["autor"]); $datumkap = trim($row["datum"]); // najit autora nadpisu $querya = 'SELECT * ' . ' FROM `minhsl`' . ' WHERE ( `minhsl`.`id` ' . ' = ("'.$autorkap.'"))'; $resulta = mysql_query($querya); $rowa = mysql_fetch_array($resulta); $autor_jmeno = htmlspecialchars(stripslashes($rowa["jmeno"])); $autor_prijmeni = htmlspecialchars(stripslashes($rowa["prijmeni"])); $autor_sex = htmlspecialchars(stripslashes($rowa["sex"])); $autor_titulpred = htmlspecialchars(stripslashes($rowa["titulpred"])); $autor_titulza = htmlspecialchars(stripslashes($rowa["titulza"])); $autor_partner = htmlspecialchars(stripslashes($rowa["partner"])); if($autor_titulza){$autor_titulza=", ".$autor_titulza;} $queryq = 'SELECT * ' . ' FROM `minpartners`' . ' WHERE ( `minpartners`.`partner_id` ' . ' = ("'.$autor_partner.'"))'; $resultq = mysql_query($queryq); $rowq = mysql_fetch_array($resultq); $autor_city = htmlspecialchars(stripslashes($rowq["city"])); $partner_id = htmlspecialchars(stripslashes($rowq["partner_id"])); $autorkaptext = "$autor_titulpred $autor_jmeno $autor_prijmeni$autor_titulza $autor_city"; // konec najit autora // konec najít název kapitoly blogu // konec najit prispevky II // editace nazvu kapitol if(strstr($_SESSION['minuprava'],"administr") OR (strstr($_SESSION['minuprava'],"mini") AND $_SESSION['minuid']==$autorkap) OR (strstr($_SESSION['minuprava'],"ministr") AND $_SESSION['minpartner'] ==$partner_id) ) {$editovatnadpis="";}else{$editovatnadpis="";} if((strstr($_SESSION['minuprava'],"administr") OR (strstr($_SESSION['minuprava'],"mini") AND $_SESSION['minuid']==$autorkap) OR (strstr($_SESSION['minuprava'],"ministr") AND $_SESSION['minpartner'] ==$partner_id) ) AND $kaptoedit) { $kapitola = "
  • "; } if(strstr($_SESSION['minuprava'],"mini")) { $vypisblogu = $vypisblogu."
    ".$_SESSION['minujmeno']." ".$_SESSION['minuprijmeni']."Title:

    Text:

    "; } // end if(strstr($_SESSION['minuprava'],"mini")) // ECHOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOs echo "

    BLOG

    $formnovetema

    $sezbamtemat
    $kapitola $autorkaptext $editovatnadpis $vypisblogu
    "; ?>