$novetema = trim($_POST["novetema"]);
$editnazevclankup = trim($_POST["editnazevclankup"]);
$edittextp = trim($_POST["edittextp"]);
$edituloz = trim($_POST["edituloz"]);
$kaptoeditsave = trim($_POST["kaptoeditsave"]);
$editulozkap = trim($_POST["editulozkap"]);
$showbl = trim($_GET["showbl"]);
$blogtoedit = trim($_GET["blogtoedit"]);
$blogtodelete = trim($_GET["blogtodelete"]);
$kaptoedit = trim($_GET["kaptoedit"]);
include("data.php");
// ==================================================== UPDATE DELETA
if(strstr($_SESSION['minuprava'],"mini") AND $edituloz)
{
$datum = getdate();
$datum = "$datum[year]-$datum[mon]-$datum[mday] $datum[hours]:$datum[minutes]:$datum[seconds]";
mysql_query("UPDATE minblog SET nazevclanku = '$editnazevclankup', text = '$edittextp', datum = '$datum' WHERE idblog ='$edituloz'");
}
// smaze zaznam
if(strstr($_SESSION['minuprava'],"mini") AND $blogtodelete)
{
$autorpomocny = $_SESSION['minuid'];
mysql_query("DELETE FROM minblog WHERE (idblog='$blogtodelete' AND autor='$autorpomocny')");
}
if(strstr($_SESSION['minuprava'],"mini") AND $kaptoeditsave AND $editulozkap)
{
$datum = getdate();
$datum = "$datum[year]-$datum[mon]-$datum[mday] $datum[hours]:$datum[minutes]:$datum[seconds]";
mysql_query("UPDATE minblog SET kapitola = '$kaptoeditsave', datum = '$datum' WHERE idblog ='$editulozkap'");
}
//======================================end UPDATE
// ------novy--------
if(strstr($_SESSION['minuprava'],"mini"))
{
$formnovetema = "
";
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."
";
}
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."";
} // end if(strstr($_SESSION['minuprava'],"mini"))
// ECHOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOs
echo "BLOG
$formnovetema
$sezbamtemat
|
|
$kapitola $autorkaptext $editovatnadpis $vypisblogu
|
";
?> |