";
if (IsSet ($_GET["rr"])) {
$rr = $_GET["rr"];
}
if (IsSet ($_GET["cc"])) {
$cc = $_GET["cc"];
}
if (IsSet ($_GET["ss"])) {
$ss = $_GET["ss"];
}
// Odstranenie SQL Injection
settype($rr, 'integer');
settype($cc, 'integer');
settype($ss, 'integer');
$actual = "./issues/" ."ISSUE_". $rr ."_". $cc .".txt";
$article = "./full/" ."KM_". $rr ."_". $cc ."_". $ss .".pdf"; // PDF-ak !!!
//echo $actual, "
";
echo "
| ";
echo "";
echo "VOLUME ", $rr;
echo " (", $rr+1962, "), ";
echo " Issue ", $cc;
$dd = "";
include "dvojcislo.php"; // dvojčíslo
echo $dd;
// echo ", p. ", $ss;
// echo " - ", $db->f(strkon);
echo "";
echo "";
//, Date("F",$cc*2)" ",
echo " "; echo " |
";
$imgartic = "
";
$img_no = "
";
// if ( File_Exists ($actual) )
{
// definicia dB
// definicia dB
// MySQL_Connect("localhost","ummsoldo","kovmat157");
define("DATABASE_NAME","kovmat");
define("DATABASE_USER","ummsoldo");
define("DATABASE_PASSWORD","kovmat157");
define("DATABASE_HOST","");
require('./db_mysql.php');
$db = new DB_Sql();
$db->Database = DATABASE_NAME;
$db->User = DATABASE_USER;
$db->Password = DATABASE_PASSWORD;
$db->Host = DATABASE_HOST;
// koniec definicie
$db2 = new DB_Sql();
$db2->Database = DATABASE_NAME;
$db2->User = DATABASE_USER;
$db2->Password = DATABASE_PASSWORD;
$db2->Host = DATABASE_HOST;
// MySQL_Select_DB("kovmat");
?>
// podmienka $where = "where rocnik=".$rr." and cislo=".$cc." and strana=".$ss; $db->query("select * from clanky ".$where); //for($i=0;$i<$db->nf();$i++) { $db->next_record(); // echo "
| ";
echo "", $db->f('nazov'), " "; echo "", $db->f('autor'), " "; echo "vol. ", $db->f('rocnik'); echo " (", $rr+1962, "), "; $cc = $db->f('cislo'); echo "no. ", $cc; include "dvojcislo.php"; // dvojčíslo echo $dd, ", "; if ( $db->f('strkon') > 0 ) { // zatial neurcena echo "pp. ", $db->f('strana'); echo " - ", $db->f('strkon'); } $ss = $db->f('strana'); echo " "; // vložka DOI 18.11.2021 if ( $db->f('DOI') <> "" ) { // doplnene 4.1.2010 // echo " "; $xDOI = Trim( $db->f('DOI')) ; //vyhodit mezeru na zaciatku // $xDOI = $db->f(DOI); // echo "DOI: ", $xDOI; / upr. 6.12.21 echo "DOI: ", "",$xDOI, "" ; } else { // ak nie je zadany tak ho vygenerujeme if ( $db->f('rocnik') >=48 && $db->f('rocnik') <=59 ) { $xVol = 1962+$db->f('rocnik'); $xDOI = "10.4149/km_". $xVol ."_". $db->f('cislo') ."_". $db->f('strana'); // echo " "; echo "DOI: ", "",$xDOI, "" ; } if ( $db->f('rocnik') > 59 ) { // 10.31577/km.2022.1.1 // include "por_cislo.php"; už neplatí ... $pc = $db->f('strana'); $xVol = 1962+$db->f('rocnik'); $xDOIa = "10.31577/km.". $xVol ."."; $cc = $db->f('cislo'); $xDOIb = $cc; include "dvojcislo.php"; // dvojčíslo // $dd,"."; // .".". $pc; // p.č. // $xDOI = "10.31577/km.". $xVol .".". $db->f('cislo') .".". $pc; // p.č. $xDOI = "10.31577/km.". $xVol .".". $db->f('cislo') . $dd.".". $pc; // p.č. echo "DOI: ", "",$xDOI, "" ; } } // end DOI echo " "; echo " Abstract Key words "; List($aut1, $tmp) = Explode(",", $db->f('autor')); $article = $rr ."_". $cc ."_". $aut1 .".pdf"; // PDF-ak !!! $farticle = "./full/". $article; // echo "### ", $farticle, " ###"; $isize = 0; // vynulované 16.12.2025 if ( ! File_Exists ($farticle) ) // +$ss { $article = $rr ."_". $cc ."_". $aut1 ."_". $ss .".pdf"; // PDF-ak !!! $farticle = "./full/". $article; } if ( File_Exists ($farticle) ) // velkost pdf-clanku { $size = FileSize ( $farticle )/1024; $isize = (int) $size; } if ($isize > 0) { // echo ""; echo ""; echo $imgartic, " Full text "; echo "(", $isize, " KB)"; // $isize = 0; // musim vynulovat } else { echo $img_no, " Full text "; echo "not available";} echo " "; } ?> // echo "Nasiel som ".$db->nf()." zaznam. "; // else {echo " neexistuje ...";} ?> |