$nazwaboxika

"); echo"

"; /* print("

»	$nazwaboxika
"); */ } // end func function stopkaboxika() { print ("

"); } // end func function pobierztlumaczenie($ID, $ISO_LNG, $ID_JOUR) { global $mysql_link; if ($ID_JOUR == 206) { $ID_JOUR = 206; } elseif ($ISO_LNG == "EN") { $sql1 = "Select NAZWA from `JOUR_WWW_TRANSLATE` WHERE ID = $ID AND LANG_ISO = 'EN' AND ID_JOUR = $ID_JOUR"; $result = mysql_query($sql1, $mysql_link); if (mysql_num_rows($result) == 0) { $ID_JOUR = 0; } } $sql1 = "Select NAZWA from `JOUR_WWW_TRANSLATE` WHERE ID = $ID AND LANG_ISO = '$ISO_LNG' AND ID_JOUR = $ID_JOUR"; //echo "
$sql1

\n"; $result = mysql_query($sql1, $mysql_link) or die ("$sql1
\n" . mysql_error()); while($row=mysql_fetch_row($result)) { $text=stripslashes($row[0]); } if (mysql_num_rows($result) == 0 or $text == "") { $sql1 = "Select NAZWA from `JOUR_WWW_TRANSLATE` WHERE ID = $ID AND LANG_ISO = '$ISO_LNG' AND ID_JOUR = 0"; $result1 = mysql_query($sql1, $mysql_link) or die ("$sql1
\n" . mysql_error()); if (mysql_num_rows($result1) == 0) { $sql1 = "Select NAZWA from `JOUR_WWW_TRANSLATE` WHERE ID = $ID AND LANG_ISO = 'EN' AND ID_JOUR = 0"; $result1 = mysql_query($sql1, $mysql_link) or die ("$sql1
\n" . mysql_error()); } while($row1=mysql_fetch_row($result1)) { $text=stripslashes($row1[0]); } } return $text; } // end func function pobierzIDstrony($IDSYSTEM, $ISO_LNG, $ID_JOUR) { global $mysql_link; $result = mysql_query(" SELECT PAGE_ID, PAGE_ACTIVE FROM `JOUR_PAGES` WHERE IDSYSTEM = $IDSYSTEM AND LANG_ISO = '$ISO_LNG' AND ID_JOUR = $ID_JOUR "); if( $result === FALSE ) return ''; while( $row = mysql_fetch_row($result) ) { if( $row[1] != '0' ) { $PAGE_ID=$row[0]; } else { $PAGE_ID = null; } } return $PAGE_ID; } function pobierzTYTstrony($IDSTRONY, $NAZWA) { global $mysql_link, $LANG, $ID_JOUR; if( !empty($NAZWA) ) return $NAZWA; if( is_null($IDSTRONY) ) return 'Page not found'; $resource = mysql_query(' SELECT PAGE_TITLE, IDSYSTEM FROM `JOUR_PAGES` WHERE PAGE_ID = ' . $IDSTRONY ); while( $row = mysql_fetch_row($resource) ) { $PAGE_TITLE = stripslashes($row[0]); $IDSYSTEM = $row[1]; } if( $IDSYSTEM > 0 ) { $resource = mysql_query(' SELECT IDTRANSLATE FROM JOUR_PAGE_SYSTEM WHERE ID_SYSTEM_PAGE = "' . $IDSYSTEM . '" '); while( $row11 = mysql_fetch_row($resource) ) $PAGE_TITLE = pobierztlumaczenie($row11[0], $LANG, $ID_JOUR); } return $PAGE_TITLE; } function pobierzTRESCstrony($IDSTRONY) { global $mysql_link; $result = mysql_query(" SELECT PAGE_TEXT FROM `JOUR_PAGES` WHERE PAGE_ID = $IDSTRONY LIMIT 1 "); if( $result === FALSE ) return 'Error Page not found.'; $row = mysql_fetch_row($result); $PAGE_TEXT = stripslashes($row[0]); return $PAGE_TEXT; } function displayboxik($dzial, $stronawww = "") { global $LANG, $ID_JOUR, $mysql_link; $dostepnejezyki = checklangWWW($ID_JOUR); //echo "test: $dzial == $stronawww
\n"; if ($dzial == $stronawww || $ID_JOUR == 5896 || $ID_JOUR == 9723 || $ID_JOUR == 8689 || $ID_JOUR == 9765 ) { $display = "block"; } else { $display = "none"; } if ($dzial == "s5") { $tytul = pobierztlumaczenie(5, $LANG, $ID_JOUR); displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); $sql = "SELECT `JOUR_NEWS_CATEGORIES`.NEWS_CAT_NAME, COUNT(`JOUR_NEWS`.NEWS_ID) AS FIELD_1, `JOUR_NEWS`.NEWS_CAT_ID FROM `JOUR_NEWS_CATEGORIES` INNER JOIN `JOUR_NEWS` ON (`JOUR_NEWS_CATEGORIES`.NEWS_CAT_ID = `JOUR_NEWS`.NEWS_CAT_ID) WHERE (`JOUR_NEWS_CATEGORIES`.ID_JOUR = $ID_JOUR) AND (`JOUR_NEWS_CATEGORIES`.NEWS_CAT_VISIBLE = 1) AND (`JOUR_NEWS_CATEGORIES`.LANG_ISO = '$LANG') AND (`JOUR_NEWS`.NEWS_DATE <= CURRENT_DATE()) AND (`JOUR_NEWS`.NEWS_DATE_NOT_PUB >= CURRENT_DATE()) GROUP BY NEWS_CAT_NAME ORDER BY `JOUR_NEWS_CATEGORIES`.NEWS_CAT_NAME"; $result = mysql_query($sql, $mysql_link) or die ("$sql
\n" . mysql_error()); if ($ID_JOUR == 8723) { $style_link = "style='font-size:13px;'"; } while($row=mysql_fetch_row($result)) { print ("
".stripslashes($row[0])." ($row[1])
"); } stopkaboxika(); } elseif ($dzial == "s6") { $sql = "SELECT JOUR_ISSUE.ID_ISSUE, JOUR_ISSUE.VOLUME, JOUR_ISSUE.ISSUE, JOUR_ISSUE.YEAR, JOUR_ISSUE.ID_ISSUE_TYPE FROM JOUR_ISSUE WHERE (JOUR_ISSUE.ID_JOUR = '$ID_JOUR') ORDER BY JOUR_ISSUE.`YEAR` DESC, JOUR_ISSUE.SORT DESC LIMIT 0,1"; $sql = "SELECT IF( LENGTH(JOUR_ISSUE.ISSUE) < 2, CONCAT( '0', JOUR_ISSUE.ISSUE ) , JOUR_ISSUE.ISSUE ) AS F1, JOUR_ISSUE.VOLUME, JOUR_ISSUE.ISSUE, JOUR_ISSUE.YEAR, JOUR_ISSUE.ID_ISSUE_TYPE, JOUR_ISSUE.ID_ISSUE FROM JOUR_ISSUES_DISPLAY INNER JOIN JOUR_ISSUE ON (JOUR_ISSUES_DISPLAY.ID_ISSUE = JOUR_ISSUE.ID_ISSUE) WHERE (JOUR_ISSUE.ID_JOUR = '$ID_JOUR') AND (JOUR_ISSUES_DISPLAY.`SHOW` = 1) ORDER BY JOUR_ISSUE.`YEAR` DESC, F1 DESC LIMIT 0,1"; //echo "$sql\n"; $result = mysql_query($sql, $mysql_link) or die ("$sql
\n" . mysql_error()); while($row=mysql_fetch_row($result)) { $issue = ""; $idssuenew=$row[5]; //echo "issue: $row[2]\n";; if ($row[4] == 2 and $row[2] != "" and $row[2] != 0) { $issue = " " . pobierztlumaczenie(29, $LANG, $ID_JOUR) . " " . $row[2] . ""; } elseif ($row[4] == 1 and $row[2] != "" and $row[2] != 0) { $issue = " " . pobierztlumaczenie(9, $LANG, $ID_JOUR) . " ".$row[2].""; } elseif ($row[4] == 3 and $row[2] != "" and $row[2] != 0) { $issue = " " . pobierztlumaczenie(30, $LANG, $ID_JOUR) . " ".$row[2].""; } if ($ID_JOUR=="23" or $vol=="0"){ if ($row[1]=="2013"){ $opisostatniego = "Special Issue, $row[3]$issue"; } else{ $opisostatniego = "".pobierztlumaczenie(8, $LANG, $ID_JOUR)." $row[1], $row[3]$issue"; } } else { $opisostatniego = "".pobierztlumaczenie(8, $LANG, $ID_JOUR)." $row[1], $row[3]$issue"; } //echo "idssuenew: $idssuenew
\n"; } $tytul = pobierztlumaczenie(6, $LANG, $ID_JOUR); displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); if ($ID_JOUR == 8723) { $style_link = "style='font-size:13px;'"; } print ("

"); if($ID_JOUR<>2669) { display_okladkaJOUR($ID_JOUR, "float:none; border-style:solid; border-color:#000000; border-width:1px;"); } print (""); print ("

$\"\"$

"); if ($ID_JOUR == 9480) { } stopkaboxika(); } elseif ($dzial == "s8") { $tytul = pobierztlumaczenie(10, $LANG, $ID_JOUR); displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); if ($ID_JOUR == 8723) { $style_link = "font-size:13px;"; } print ("

"); stopkaboxika(); } elseif ($dzial=='s9') { $tytul = pobierztlumaczenie(36, $LANG, $ID_JOUR); displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); if ($ID_JOUR == 8723) { $style_link = "style='font-size:13px;'"; } print ("

"); stopkaboxika(); } elseif ($dzial=='s10') { /** * Jesli nie aktywne nie wyswietla */ $Check = mysql_query("SELECT * FROM `JOUR_EXTENDED_PANEL` WHERE `ID_JOUR` =".$ID_JOUR); $Check = mysql_fetch_assoc($Check); $Show = ( $Check['EXTENDED'] == 0 ) ? false : true; if ( $Show ) { //authors pathways $tytul = pobierztlumaczenie(55, $LANG, $ID_JOUR); displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); if ($ID_JOUR == 8723) { $style_link = "style='font-size:13px;'"; } print ("

"); echo ""; echo ""; $a = mysql_query("SELECT FEE FROM PUBL_PREFERENCES_PAYMENT WHERE ID_JOUR='$ID_JOUR'"); $aw = mysql_fetch_row($a); include("/home/copernicus/docs/publisher_panel/imw.php"); if ($aw[0] == '2' || $aw[0] == '3' ) { if ($dumb) { } else { echo""; } } echo"

	"; if ($ID_JOUR==68){ echo "".pobierztlumaczenie(183, $LANG, $ID_JOUR).""; } else { echo "".pobierztlumaczenie(183, $LANG, $ID_JOUR).""; } echo "
	"; if ($ID_JOUR==68){ echo "".pobierztlumaczenie(184, $LANG, $ID_JOUR)." (".pobierztlumaczenie(354, $LANG, $ID_JOUR)." 28.08.2014)"; echo "
	".pobierztlumaczenie(184, $LANG, $ID_JOUR)." (".pobierztlumaczenie(353, $LANG, $ID_JOUR)." 28.08.2014)"; } else { echo "".pobierztlumaczenie(184, $LANG, $ID_JOUR).""; } echo "
	".pobierztlumaczenie(121, $LANG, $ID_JOUR)."

"; /* print("

".pobierztlumaczenie(57, $LANG, $ID_JOUR).":

".pobierztlumaczenie(58, $LANG, $ID_JOUR).":

"); */ stopkaboxika(); } } elseif($dzial=='s12' AND count($dostepnejezyki) > 1) { //languages $tytul = pobierztlumaczenie(34, $LANG, $ID_JOUR); displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); echo " "); stopkaboxika(); } elseif ($dzial == "s7") { //$tytul = ; //displaynaglboxika($tytul); displaynaglboxika(pobierztlumaczenie(7, $LANG, $ID_JOUR), "left", $dzial, $display); $content = "

"; //$q = mysql_query("SELECT // JOUR_ISSUE.ID_JOUR, // JOUR_ISSUE.VOLUME, // JOUR_ISSUE.`YEAR`, // JOUR_ISSUE.ID_ISSUE //FROM // JOUR_ISSUES_DISPLAY // INNER JOIN JOUR_ISSUE ON (JOUR_ISSUES_DISPLAY.ID_ISSUE = JOUR_ISSUE.ID_ISSUE) //WHERE // (JOUR_ISSUE.ID_JOUR = '$ID_JOUR') //GROUP BY // VOLUME, // YEAR //ORDER BY // JOUR_ISSUE.`YEAR` DESC, // JOUR_ISSUE.VOLUME DESC LIMIT 0,1"); //$re = mysql_fetch_row($q); //$ostatni_issue = $re[3]; $q = mysql_query("SELECT JOUR_ISSUE.ID_ISSUE, JOUR_ISSUE.VOLUME, JOUR_ISSUE.ISSUE, JOUR_ISSUE.YEAR, JOUR_ISSUE.ID_ISSUE_TYPE FROM JOUR_ISSUES_DISPLAY INNER JOIN JOUR_ISSUE ON (JOUR_ISSUES_DISPLAY.ID_ISSUE = JOUR_ISSUE.ID_ISSUE) WHERE (JOUR_ISSUE.ID_JOUR = '$ID_JOUR') AND (JOUR_ISSUES_DISPLAY.`SHOW` = 1) ORDER BY JOUR_ISSUE.`YEAR` DESC, JOUR_ISSUE.ISSUE DESC LIMIT 0,1"); $re = mysql_fetch_row($q); $ostatni_issue = $re[0]; if($cur==0 && $ostatni_issue > 0) { $q = "SELECT JOUR_ISSUE.ID_JOUR, JOUR_ISSUE.VOLUME, JOUR_ISSUE.`YEAR`, JOUR_ISSUE.ID_ISSUE FROM JOUR_ISSUES_DISPLAY INNER JOIN JOUR_ISSUE ON (JOUR_ISSUES_DISPLAY.ID_ISSUE = JOUR_ISSUE.ID_ISSUE) WHERE (JOUR_ISSUE.ID_JOUR = '$ID_JOUR' AND JOUR_ISSUE.ID_ISSUE <> ".$ostatni_issue.") GROUP BY VOLUME, YEAR ORDER BY JOUR_ISSUE.`YEAR` DESC, JOUR_ISSUE.VOLUME DESC"; //echo $q; } else { $q = "SELECT JOUR_ISSUE.ID_JOUR, JOUR_ISSUE.VOLUME, JOUR_ISSUE.`YEAR`, JOUR_ISSUE.ID_ISSUE FROM JOUR_ISSUES_DISPLAY INNER JOIN JOUR_ISSUE ON (JOUR_ISSUES_DISPLAY.ID_ISSUE = JOUR_ISSUE.ID_ISSUE) WHERE (JOUR_ISSUE.ID_JOUR = '$ID_JOUR') GROUP BY VOLUME, YEAR ORDER BY JOUR_ISSUE.`YEAR` DESC, JOUR_ISSUE.VOLUME DESC"; } $wers1 = 1; $mysql_result = mysql_query($q, $mysql_link) or die ("$q
\n" . mysql_error()); while($row=mysql_fetch_row($mysql_result)) { $vol = $row[1]; $rok = $row[2]; if (strlen($wers1)==1) $print_wers1 = "00" . $wers1; elseif (strlen($wers1)==2) $print_wers1 = "0" . $wers1; $q2 = "SELECT JOUR_ISSUE.ISSUE, ISSUE_TYPE.ID_ISSUE_TYPE, JOUR_ISSUE.COVER_ISSUE, JOUR_ISSUE.ID_ISSUE FROM ISSUE_TYPE INNER JOIN JOUR_ISSUE ON (ISSUE_TYPE.ID_ISSUE_TYPE = JOUR_ISSUE.ID_ISSUE_TYPE) INNER JOIN JOUR_ISSUES_DISPLAY ON (JOUR_ISSUE.ID_ISSUE = JOUR_ISSUES_DISPLAY.ID_ISSUE) WHERE (JOUR_ISSUES_DISPLAY.ID_JOUR = '$ID_JOUR') AND (JOUR_ISSUE.`YEAR` = '$rok') AND (JOUR_ISSUE.VOLUME = '$vol') AND (ISSUE_TYPE.ID_LANG = 3) ORDER BY JOUR_ISSUE.SORT DESC"; $wers2 = 1; $mysql_result2 = mysql_query($q2, $mysql_link) or die ("$q2
\n" . mysql_error()); $row2=mysql_fetch_row($mysql_result2); if ($ID_JOUR == 8723) { $style_link = "style='font-size:13px;line-height: 14px;'"; } //echo "test: '$row2[0]' -> \n " . mysql_num_rows($mysql_result2) . "
"; if (mysql_num_rows($mysql_result2) == 1 and ($row2[0] == 0 or $row2[0] == null)) { if ($wers1 != 1) $content .= "
"; $content .= ""; if ($ID_JOUR=="23" or $vol=="0"){ if ($vol=="2013"){ $content .= "Special Issue, $rok\n"; } else{ $content .= "".pobierztlumaczenie(8, $LANG, $ID_JOUR)." $vol, $rok\n"; } } else { $content .= "".pobierztlumaczenie(8, $LANG, $ID_JOUR)." $vol, $rok\n"; } } else { if ($wers1 != 1) $content .= "
"; $content .= ""; if ($ID_JOUR=="23"){ if ($vol=="2013" or $vol=="0"){ $content .= "Special Issue, $rok\n"; } else{ $content .= "".pobierztlumaczenie(8, $LANG, $ID_JOUR)." $vol, $rok\n"; } } else { $content .= "".pobierztlumaczenie(8, $LANG, $ID_JOUR)." $vol, $rok\n"; } $content .= "\n"; if($cur==0 && $ostatni_issue > 0) { $q2 = "SELECT JOUR_ISSUE.ISSUE, ISSUE_TYPE.ID_ISSUE_TYPE, JOUR_ISSUE.COVER_ISSUE, JOUR_ISSUE.ID_ISSUE FROM ISSUE_TYPE INNER JOIN JOUR_ISSUE ON (ISSUE_TYPE.ID_ISSUE_TYPE = JOUR_ISSUE.ID_ISSUE_TYPE) INNER JOIN JOUR_ISSUES_DISPLAY ON (JOUR_ISSUE.ID_ISSUE = JOUR_ISSUES_DISPLAY.ID_ISSUE) WHERE (JOUR_ISSUES_DISPLAY.ID_JOUR = '$ID_JOUR') AND (JOUR_ISSUE.`YEAR` = '$rok') AND (JOUR_ISSUE.VOLUME = '$vol') AND (ISSUE_TYPE.ID_LANG = 3) AND JOUR_ISSUE.ID_ISSUE <> ".$ostatni_issue." ORDER BY JOUR_ISSUE.SORT DESC"; //echo $q2; } else { $q2 = "SELECT JOUR_ISSUE.ISSUE, ISSUE_TYPE.ID_ISSUE_TYPE, JOUR_ISSUE.COVER_ISSUE, JOUR_ISSUE.ID_ISSUE FROM ISSUE_TYPE INNER JOIN JOUR_ISSUE ON (ISSUE_TYPE.ID_ISSUE_TYPE = JOUR_ISSUE.ID_ISSUE_TYPE) INNER JOIN JOUR_ISSUES_DISPLAY ON (JOUR_ISSUE.ID_ISSUE = JOUR_ISSUES_DISPLAY.ID_ISSUE) WHERE (JOUR_ISSUES_DISPLAY.ID_JOUR = '$ID_JOUR') AND (JOUR_ISSUE.`YEAR` = '$rok') AND (JOUR_ISSUE.VOLUME = '$vol') AND (ISSUE_TYPE.ID_LANG = 3) ORDER BY JOUR_ISSUE.SORT DESC"; } $mysql_result2 = mysql_query($q2, $mysql_link) or die ("$q2
\n" . mysql_error()); while($row2=mysql_fetch_row($mysql_result2)) { $nr = $row2[0]; $idissue = $row2[1]; $miesiac = stripslashes($row2[2]); if ($nr == 0) { $nr = ""; } $dostepny = 1; //to tzreba bedzie zmienic i zrobic ready caly issue if (strlen($wers2)==1) $print_wers2 = "00" . $wers2; elseif (strlen($wers2)==2) $print_wers2 = "0" . $wers2; $content .= "
"; if ($dostepny == 1) $content .= ""; else $content .= " "; if ($idissue == 2) { $content .= pobierztlumaczenie(29, $LANG, $ID_JOUR) . " " . $nr . ""; } elseif ($idissue == 1) { $content .= pobierztlumaczenie(9, $LANG, $ID_JOUR) . " $nr"; } elseif ($idissue == 3) { $content .= pobierztlumaczenie(30, $LANG, $ID_JOUR) . " $nr"; } if ($miesiac) $content .= " ($miesiac)"; if ($dostepny == 1) $content .= "\n"; else $content .= "\n"; $wers2++; } } $content .= "\n"; $wers1++; } $content .= "

\n"; $content .= " "; print ("$content"); $kk = "SELECT `PUBL_PREFERENCES_EXTENDED`.SELL FROM `PUBL_PREFERENCES_EXTENDED` WHERE (`PUBL_PREFERENCES_EXTENDED`.ID_JOUR = ".$ID_JOUR.")"; $mkkk = mysql_query($kk); $ile_el = mysql_fetch_row($mkkk); if($ile_el[0] == 1) { echo"

Buy archival issues »

"; } stopkaboxika(); } elseif (is_numeric($dzial) == true) { $a = mysql_query("SELECT * FROM JOUR_PAGE_CATEGORIES WHERE ID_JOUR='$ID_JOUR' AND PAGE_CAT_VISIBLE='1' AND PAGE_CAT_ID = $dzial AND LANG_ISO='$LANG' ORDER BY PAGE_CAT_ID"); while($aw = mysql_fetch_row($a)) { $tytul = stripslashes($aw[3]); $contentboxika = stripslashes($aw[5]); } //echo"tt $dzial"; displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); if ($contentboxika != '') { print ("

".$contentboxika."

"); } $b = mysql_query("SELECT * FROM JOUR_PAGES WHERE ID_JOUR='$ID_JOUR' AND PAGE_ACTIVE='1' AND LANG_ISO='$LANG' AND PAGE_CAT_ID='$dzial' ORDER BY KOLEJ"); if (mysql_num_rows($b) > 0) { print ("

"); } if ($ID_JOUR == 8723) { $style_link = "style='font-size:13px;'"; } while($bw = mysql_fetch_row($b)) { echo""; } if (mysql_num_rows($b) > 0) { print ("

"); } stopkaboxika(); } } // end func function impactfactor() { $tytul = "Impact Factor"; displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); print ("

Now: 1.595

"); stopkaboxika(); } function banneryMSM() { $tytul = "Journals Databases"; displaynaglboxika($tytul, $aligntextu = "center", $dzial, $display); print ("

"); stopkaboxika(); } ?>