mysql_server,$classpage->mysql_login,$classpage->mysql_pass); @ $vyberdb = mysql_select_db($classpage->mysql_db); $title = "Napsali o nás"; if( ($id = $_GET["id"]) && ($id > 0) ) { $query_title = "SELECT nazev, DATE_FORMAT(datum, '%e.%c.%Y') as datumx, DATE_FORMAT(datum, '%Y') as datumrok FROM dpmz_napsali WHERE id = ".$id; if($get_title = mysql_query($query_title)) { if( ($number_title = mysql_num_rows($get_title)) && ($number_title > 0) ) { $row_title = mysql_fetch_array($get_title); $nazev_title = $row_title["nazev"]; $datum_title = $row_title["datumx"]; $datum_rok = $row_title["datumrok"]; if($datum_rok < 2018) $title = "Napsali o nás: ".$nazev_title." (".$datum_title.")"; else $title = "Napsali o nás"; } // end num } // end res } // end id $classpage->displayTop(6,0, "", $title,1); echo "

"; if( ($id = $_GET["id"]) && ($id > 0) ) { echo "Napsali o nás / "; if($datum_rok < 2018) echo $nazev_title.", ".$datum_title; } else echo "Napsali o nás"; echo "

\n"; if( ($id = $_GET["id"]) && ($id > 0) ) { // zobrazeni konretniho clanku $query_clanek = "SELECT imgname, width, height FROM dpmz_napsali WHERE id = ".$id; if($get_clanek = mysql_query($query_clanek)) { if( ($number_clanek = mysql_num_rows($get_clanek)) && ($number_clanek > 0) ) { $row_clanek = mysql_fetch_array($get_clanek); $imgname = $row_clanek["imgname"]; $width = $row_clanek["width"]; $height = $row_clanek["height"]; echo "\"\""; // log hit $query_hit = "UPDATE dpmz_napsali SET hits = hits + 1 WHERE id = ".$id; @ mysql_query($query_hit); } // end num else echo "

Momentálně nemohu zobrazit detaily článku.

\n"; } // end res else echo "

Momentálně nemohu zobrazit detaily článku.

\n"; } // end id else { $query = "SELECT id, DATE_FORMAT(datum, '%e.%c.%Y') as datumx, DATE_FORMAT(datum, '%Y') as datumrok, nazev, imgname FROM dpmz_napsali ORDER BY datum DESC"; if($get_napsali = mysql_query($query)) { if( ($number = mysql_num_rows($get_napsali)) && ($number > 0) ) { $citac = 0; echo ""; echo ""; for($i = 0; $i < $number; $i++) { if($citac > 3) { echo "\n"; echo "\n"; $citac = 1; } else $citac++; if($citac > 1) echo ""; $row = mysql_fetch_array($get_napsali); $id_box = $row["id"]; $datumx = $row["datumx"]; $datumrok = $row["datumrok"]; $nazev = $row["nazev"]; $imgname = $row["imgname"]; $titleimg = ""; if($datumrok < 2018) $titleimg = $datumx; if(($datumrok < 2018) && !empty($nazev)) $titleimg .= " / ".$nazev; echo "\n"; } // end for echo "\n
\"\"
\"\""; if($datumrok < 2018) echo "

".$datumx."

"; // echo ""; echo ""; if($datumrok < 2018) echo $nazev; echo "\"\""; echo "
\n"; } // end number else echo "

Žádný článek.

\n"; } // end res else echo "

Momentálně nemohu zobrazit přehled článků.

\n"; } // end else - bez ID @ mysql_close($pripojit); $classpage -> displayBottom(); ?>