Skip to content

Instantly share code, notes, and snippets.

@medico-jobs

medico-jobs/IndexHandler.inc.php

Created September 16, 2015 13:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save medico-jobs/2a44fad1d0edb326aa1a to your computer and use it in GitHub Desktop.
Save medico-jobs/2a44fad1d0edb326aa1a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IndexHandler.inc.php
<?php
/**
* @file pages/index/IndexHandler.inc.php
*
* Copyright (c) 2013-2015 Simon Fraser University Library
* Copyright (c) 2003-2015 John Willinsky
* Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
*
* @class IndexHandler
* @ingroup pages_index
*
* @brief Handle site index requests.
*/
import('classes.handler.Handler');
class IndexHandler extends Handler {
/**
* Constructor
**/
function IndexHandler() {
parent::Handler();
}
/**
* If no journal is selected, display list of journals.
* Otherwise, display the index page for the selected journal.
* @param $args array
* @param $request Request
*/
function index($args, &$request) {
//ini_set('display_errors', false);
//error_reporting(0);
include "pages/dbconfig.php"; // Db connections
$rs1 = $mysqli->query("SELECT * FROM base_url");
//$row = $rs2->fetch_array();
//echo '<pre>';print_r($_REQUEST);die;
if($_REQUEST['contact'])
{
//$roleDao =& DAORegistry::getDAO('RoleDAO');
$q='SELECT user_id FROM roles WHERE role_id='.ROLE_ID_SITE_ADMIN.' AND journal_id=0';
$rs = $mysqli->query($q);
$row = $rs->fetch_array();
$q2='SELECT email FROM users WHERE user_id='.$row[0];
$rs2 = $mysqli->query($q2);
$row2 = $rs2->fetch_array();
$admin_email=$row2[0];
$admin_email='office@oajpc.com';
$error='Please fill in your';
$c='';
if(!$_REQUEST['name'] && $_REQUEST['name'] == '')
{
$error.=' Name';
$c=',';
}
if(!$_REQUEST['email'] && $_REQUEST['email'] == '')
{
$error.=$c.' Email';
$c=',';
}
else{
if(!filter_var($_REQUEST['email'], FILTER_VALIDATE_EMAIL))
{
echo "Invalid Email";
die;
}
}
if(!$_REQUEST['phone'] && $_REQUEST['phone'] == '')
{
$error.=$c.' Phone Number';
$c=',';
}
else{
if (!preg_match("/^[\+0-9\-\(\)\s]*$/", $_REQUEST['phone'])) {
echo "Invalid phone number";
die;
}
}
if(!$_REQUEST['message'] && $_REQUEST['message'] == '')
{
$error.=$c.' Message';
}
if($_REQUEST['journal_id'] && $_REQUEST['journal_id'] != '')
{
//include './pages/dbconfig.php'; // Db connections
$q='SELECT setting_value FROM journal_settings WHERE setting_name="contactEmail" AND journal_id='.$_REQUEST['journal_id'];
$rs = $mysqli->query($q);
$row=$rs->fetch_array();
if(!empty($row))
$admin_email=$row[0];
//echo '<pre>';print_r($admin_email);die;
if($_REQUEST['email'] != '' && $_REQUEST['message'] != '' && $_REQUEST['name'] != '' && $_REQUEST['phone'] != ''){
$subject = $_REQUEST['email'].' wants to contact on oajpc';
$message = '';
$message .= 'Dear Editor,<br/><br/>';
$message .= $_REQUEST['name']." wants to contact you<br/><br/>";
$message .= "email: ".$_REQUEST['email']."<br/><br/>";
$message .= "phone: ".$_REQUEST['phone']."<br/><br/>";
$message .= $_REQUEST['message'];
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'To: oajcp <'.$admin_email.'>' . "\r\n";
$headers .= 'From: oajcp' . "\r\n";
mail($admin_email, $subject, $message, $headers);
echo 'success';die;
}else{
echo $error;die;
}
//$success='Thank You for contacting us. We will reply you as soon as possible';
}
else{
//include './pages/dbconfig.php'; // Db connections
//echo '<pre>';print_r($admin_email);die;
if($_REQUEST['email'] != '' && $_REQUEST['message'] != '' && $_REQUEST['name'] != '' && $_REQUEST['phone'] != ''){
$subject = $_REQUEST['email'].' wants to contact on oajpc';
$message = '';
$message .= 'Dear Admin,<br/><br/>';
$message .= $_REQUEST['name']." wants to contact Admin<br/><br/>";
$message .= "email: ".$_REQUEST['email']."<br/><br/>";
$message .= "phone: ".$_REQUEST['phone']."<br/><br/>";
$message .= $_REQUEST['message'];
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'To: oajcp <'.$admin_email.'>' . "\r\n";
$headers .= 'From: oajcp' . "\r\n";
mail($admin_email, $subject, $message, $headers);
echo 'success';die;
}else{
echo $error;die;
}
//$success='Thank You for contacting us. We will reply you as soon as possible';
}
}
elseif($_REQUEST['staticContactForm'])
{
$q='SELECT user_id FROM roles WHERE role_id='.ROLE_ID_SITE_ADMIN.' AND journal_id=0';
$rs = $mysqli->query($q);
$row = $rs->fetch_array();
$q2='SELECT email FROM users WHERE user_id='.$row[0];
$rs2 = $mysqli->query($q2);
$row2 = $rs2->fetch_array();
$admin_email=$row2[0];
$admin_email='office@oajpc.com';
$error='Please fill in your';
$c='';
if(!$_REQUEST['subject'] && $_REQUEST['subject'] == '')
{
$error.=' subject';
$c=',';
}
if(!$_REQUEST['name'] && $_REQUEST['name'] == '')
{
$error.=' Name';
$c=',';
}
if(!$_REQUEST['email'] && $_REQUEST['email'] == '')
{
$error.=$c.' Email';
$c=',';
}
if(!$_REQUEST['comment'] && $_REQUEST['comment'] == '')
{
$error.=$c.' comment';
}
if($_REQUEST['phone'] && $_REQUEST['phone'] != ''){
if (!preg_match("/^[\+0-9\-\(\)\s]*$/", $_REQUEST['phone'])) {
echo "Invalid phone number";
die;
}
}
if($_REQUEST['subject'] && $_REQUEST['subject'] != '')
{
switch($_REQUEST['subject']){
case 5:
$jr=1;
break;
case 6:
$jr=2;
break;
case 7:
$jr=3;
break;
}
if($_REQUEST['subject']>4)
{
$q='SELECT setting_value FROM journal_settings WHERE setting_name="contactEmail" AND journal_id='.$jr;
$rs = $mysqli->query($q);
$row=$rs->fetch_array();
if(!empty($row))
$admin_email=$row[0];
}
if($_REQUEST['email'] != '' && $_REQUEST['name'] != '' && $_REQUEST['comment'] != ''){
$subject = $_REQUEST['email'].' wants to contact on oajpc';
$message = '';
$message .= 'Dear Admin,<br/><br/>';
$message .= $_REQUEST['name']." wants to contact Admin<br/><br/>";
$message .= "email: ".$_REQUEST['email']."<br/><br/>";
$message .= "phone: ".$_REQUEST['phone']."<br/><br/>";
$message .= $_REQUEST['message'];
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'To: oajcp <'.$admin_email.'>' . "\r\n";
$headers .= 'From: oajcp' . "\r\n";
mail($admin_email, $subject, $message, $headers);
echo 'success';die;
}else{
echo $error;die;
}
}
else{
echo "subject";die;
}
}
if($rs1->num_rows > 0 && $rs1->num_rows != null){
$q1 = sprintf('UPDATE base_url SET url ="%s"', $request->getBaseUrl());
$mysqli->query($q1);
}
else{
$q1 = sprintf('INSERT INTO base_url(url) VALUES("%s")', $request->getBaseUrl());
$mysqli->query($q1);
}
$this->validate();
$this->setupTemplate();
$router =& $request->getRouter();
$templateMgr =& TemplateManager::getManager();
$journalDao =& DAORegistry::getDAO('JournalDAO');
$journalPath = $router->getRequestedContextPath($request);
$templateMgr->assign('helpTopicId', 'user.home');
$journal =& $router->getContext($request);
/* Added BY Starts*/
//$journalOptions =& $journalDao->getJournalTitlesWithPaths(false);
//$templateMgr->assign('journalOptions', array('' => AppLocale::Translate('search.selectAJournal')) + $journalOptions);
/* editted */
//$sql='SELECT * FROM journals ORDER BY seq ASC';
//$result = $mysqli->query($sql);
//$j=array();
//$j['']='Select a journal';
//while($results = $result->fetch_array() )
//{
// $sqlj='SELECT setting_value FROM journal_settings WHERE journal_id = '.$results[0].' AND setting_name = "title"';
//
// $resultj = $mysqli->query($sqlj);
// while($resultsj = $resultj->fetch_array() )
// {
// $j[$results[1]]=$resultsj[0];
// }
//}
//
//$templateMgr->assign_by_ref('journalOptions', $j);
/* Added BY ends */
//----- Start :vkhan
$url = $_SERVER['PHP_SELF']; // get url
$index_url_param = substr($url, strripos($url, '/')+1); // find url param
//----- End :vkhan
if ($journal) {
//Get Current Issue articles-------------------
$j_id= $journal->getId();
$is_q='SELECT issue_id FROM issues WHERE current=1 AND journal_id='.$j_id;
$is_result = $mysqli->query($is_q);
$issue_id = $is_result->fetch_array();
//echo '<pre>';print_r($issue_id);die;
if(!empty($issue_id[0]))
{
$issueDao =& DAORegistry::getDAO('IssueDAO');
$issue =& $issueDao->getCurrentIssue($issue_id[0], true);
//$issueID=$issue->getId();
$article=array();
$author=array();
$articleName=array();
$i=0;
$sql='SELECT article_id FROM published_articles WHERE issue_id='.$issue_id[0];
$result = $mysqli->query($sql);
if($result != null){
while($results = $result->fetch_array() )
{
$article[]=$results[0];
//echo '<pre>';print_r($results);die;
$sql1='SELECT journal_id FROM articles WHERE article_id ='.$results[0];
$jour1 = $mysqli->query($sql1);
$jours = $jour1->fetch_array();
$jrnlId=$jours[0];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$jrnlId;
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$j_path=$jourqs[0];
$sql2='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$results[0];
$auth = $mysqli->query($sql2);
//echo '<pre>';print_r($auth);die;
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$author[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$author[$i][]=$authors[0].' '.$authors[2];
}
$sql3='SELECT setting_value FROM article_settings WHERE article_id = '.$results[0].' AND setting_name = "title" ORDER BY article_id ASC';
$artName= $mysqli->query($sql3);
while($names = $artName->fetch_array() )
{
$articleName[$i][]=$names[0];
}
$sql4='SELECT setting_value FROM article_settings WHERE article_id = '.$results[0].' AND setting_name="abstract" ORDER BY article_id ASC';
$artName2= $mysqli->query($sql4);
while($names2 = $artName2->fetch_array() )
{
//echo '<pre>';print_r($names2);die;
$articleAbs[]=$names2[0];
}
$sql5='SELECT view_count FROM articles WHERE article_id = '.$results[0];
$view= $mysqli->query($sql5);
$views = $view->fetch_array();
//echo '<pre>';print_r($views);die;
$view_cnt[$i]=$views[0];
$sql6="SELECT galley_id FROM article_galleys WHERE article_id = ".$results[0]." AND label = 'HTML'";
$html= $mysqli->query($sql6);
$htmls = $html->fetch_array();
//echo '<pre>';print_r($htmls);die;
$html_id[$i]=$htmls[0];
$sql7="SELECT galley_id FROM article_galleys WHERE article_id = ".$results[0]." AND label = 'PDF'";
$pdf= $mysqli->query($sql7);
$pdfs = $pdf->fetch_array();
//echo '<pre>';print_r($htmls);die;
$pdf_id[$i]=$pdfs[0];
$sql8="SELECT galley_id FROM article_galleys WHERE article_id = ".$results[0]." AND label = 'Abstract'";
$abstract= $mysqli->query($sql8);
$abs = $abstract->fetch_array();
//echo '<pre>';print_r($htmls);die;
$abs_id[$i]=$abs[0];
$i++;
}
}
}
//echo '<pre>';print_r($view_cnt);die;
//------------------------------END
//HOME PAGE TAB NAMES----------
$qu="SELECT * FROM home_tab_titles WHERE journal_id=".$j_id." AND form_locale='".AppLocale::getLocale()."'";
$resu=$mysqli->query($qu);
if($resu->num_rows > 0 && $resu->num_rows != null)
{
$result=$resu->fetch_array();
$tabName[1]=$result['overview'];
$tabName[2]=$result['indexing'];
$tabName[3]=$result['guidelines'];
$tabName[4]=$result['editors'];
$tabName[5]=$result['contactus'];
}
$templateMgr->assign_by_ref('tabName', $tabName);
// Assign header and content for home page
$templateMgr->assign('displayPageHeaderTitle', $journal->getLocalizedPageHeaderTitle(true));
$templateMgr->assign('displayPageHeaderLogo', $journal->getLocalizedPageHeaderLogo(true));
$templateMgr->assign('displayPageHeaderTitleAltText', $journal->getLocalizedSetting('homeHeaderTitleImageAltText'));
$templateMgr->assign('displayPageHeaderLogoAltText', $journal->getLocalizedSetting('homeHeaderLogoImageAltText'));
$templateMgr->assign('additionalHomeContent', $journal->getLocalizedSetting('additionalHomeContent'));
$templateMgr->assign('homepageImage', $journal->getLocalizedSetting('homepageImage'));
$templateMgr->assign('homepageImageAltText', $journal->getLocalizedSetting('homepageImageAltText'));
$templateMgr->assign('journalDescription', $journal->getLocalizedSetting('description'));
$displayCurrentIssue = $journal->getSetting('displayCurrentIssue');
$issueDao =& DAORegistry::getDAO('IssueDAO');
$issue =& $issueDao->getCurrentIssue($journal->getId(), true);
if ($displayCurrentIssue && isset($issue)) {
import('pages.issue.IssueHandler');
// The current issue TOC/cover page should be displayed below the custom home page.
IssueHandler::_setupIssueTemplate($request, $issue);
}
// Display creative commons logo/licence if enabled
$templateMgr->assign('displayCreativeCommons', $journal->getSetting('includeCreativeCommons'));
$enableAnnouncements = $journal->getSetting('enableAnnouncements');
if ($enableAnnouncements) {
$enableAnnouncementsHomepage = $journal->getSetting('enableAnnouncementsHomepage');
if ($enableAnnouncementsHomepage) {
$numAnnouncementsHomepage = $journal->getSetting('numAnnouncementsHomepage');
$announcementDao =& DAORegistry::getDAO('AnnouncementDAO');
$announcements =& $announcementDao->getNumAnnouncementsNotExpiredByAssocId(ASSOC_TYPE_JOURNAL, $journal->getId(), $numAnnouncementsHomepage);
$templateMgr->assign('announcements', $announcements);
$templateMgr->assign('enableAnnouncementsHomepage', $enableAnnouncementsHomepage);
}
}
//------------Archive-------------------------------------------------
$rangeInfo = $this->getRangeInfo('issues');
$publishedIssuesIterator = $issueDao->getPublishedIssues($journal->getId(), $rangeInfo);
import('classes.file.PublicFileManager');
$publicFileManager = new PublicFileManager();
$coverPagePath = $request->getBaseUrl() . '/';
$coverPagePath .= $publicFileManager->getJournalFilesPath($journal->getId()) . '/';
$templateMgr =& TemplateManager::getManager();
$templateMgr->assign('coverPagePath', $coverPagePath);
$templateMgr->assign('locale', AppLocale::getLocale());
$templateMgr->assign_by_ref('issues', $publishedIssuesIterator);
$templateMgr->assign('helpTopicId', 'user.currentAndArchives');
$isq2='SELECT year FROM issues ORDER BY year DESC';
$isr2= $mysqli->query($isq2);
$temp='';
while($res=$isr2->fetch_assoc())
{
if($temp!=$res['year'])
{
$temp=$res['year'];
$yer[]=$res['year'];
}
}
$templateMgr->assign_by_ref('yer', $yer);
//echo '<pre>';print_r($yer);die;
//--------------------------------------------------------------------
//---------------------Journal Page Tabs Articles------------------------------------------
$qj = 'SELECT * FROM articles WHERE journal_id='.$j_id.' AND at_journal=1 LIMIT 10';
$res = $mysqli->query($qj);
$i=0;
//echo '<pre>';print_r($res);die;
if($res->num_rows>0)
{
while($result = $res->fetch_array()){
//echo '<pre>';print_r($result);die;
// -----early release--------------------------
if($result['early_view']==1)
{
$ER[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$ERauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$ERauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$ER[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$ER[$i][]=$jnames[0];
$ER[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$ER[$i][]=$jourqs[0];
}
if($result['recommend']==1)
{
$RC[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$RCauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$RCauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$RC[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$RC[$i][]=$jnames[0];
$RC[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$RC[$i][]=$jourqs[0];
}
$i++;
}
$templateMgr->assign_by_ref('ER', $ER);
$templateMgr->assign_by_ref('ERauthor', $ERauthor);
$templateMgr->assign_by_ref('RC', $RC);
$templateMgr->assign_by_ref('RCauthor', $RCauthor);
}
else{
$templateMgr->assign('ER', null);
$templateMgr->assign('RC', null);
}
$q1 = 'SELECT * FROM articles WHERE journal_id='.$j_id.' AND at_journal=1 AND recently_published=1 ORDER BY date_submitted DESC LIMIT 10';
$res1 = $mysqli->query($q1);
$i=0;
while($result = $res1->fetch_array())
{
//echo '<pre>';print_r($result);die;
$RA[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$RAauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$RAauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$RA[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$RA[$i][]=$jnames[0];
$RA[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$RA[$i][]=$jourqs[0];
$i++;
}
$q2 = 'SELECT * FROM articles WHERE journal_id='.$j_id.' AND at_journal=1 AND most_viewed=1 ORDER BY view_count DESC LIMIT 10';
$res2 = $mysqli->query($q2);
$i=0;
while($result = $res2->fetch_array())
{
//echo '<pre>';print_r($result);die;
$VI[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$VIauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$VIauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$VI[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$VI[$i][]=$jnames[0];
$VI[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$VI[$i][]=$jourqs[0];
$i++;
}
//echo '<pre>';print_r($VI);die;
//--------Additional Tabs---------------------
$sql10="SELECT * FROM home_custom_tab WHERE journal_id=".$j_id." AND tab_name='additional_tabs' AND form_locale='".AppLocale::getLocale()."'";
$tab= $mysqli->query($sql10);
$tabs = $tab->fetch_array();
if($tab->num_rows > 0 && $tab->num_rows != null)
$tabValue=$tabs['content'];
else
$tabValue='';
//-----------------------------
$templateMgr->assign_by_ref('RA', $RA);
$templateMgr->assign_by_ref('RAauthor', $RAauthor);
$templateMgr->assign_by_ref('VI', $VI);
$templateMgr->assign_by_ref('VIauthor', $VIauthor);
//---------------------------------------------------------------
$templateMgr->assign_by_ref('articleName', $articleName);
$templateMgr->assign_by_ref('articleAbs', $articleAbs);
$templateMgr->assign_by_ref('author', $author);
$templateMgr->assign_by_ref('article', $article);
$templateMgr->assign('j_path', $j_path);
$templateMgr->assign('tabValue', $tabValue);
$templateMgr->assign_by_ref('view_count', $view_cnt);
$templateMgr->assign_by_ref('html_galley', $html_id);
$templateMgr->assign_by_ref('abs_galley', $abs_id);
$templateMgr->assign_by_ref('pdf_galley', $pdf_id);
$templateMgr->assign('is_journal', true);
$templateMgr->display('index/journal.tpl');
}
else if($index_url_param == 'journalList'){
$site =& Request::getSite();
if ($site->getRedirect() && ($journal = $journalDao->getById($site->getRedirect())) != null) {
$request->redirect($journal->getPath());
}
$templateMgr->assign('intro', $site->getLocalizedIntro());
$templateMgr->assign('journalFilesPath', $request->getBaseUrl() . '/' . Config::getVar('files', 'public_files_dir') . '/journals/');
$journalImageBasePath = $request->getBaseUrl() . '/' . Config::getVar('files', 'public_files_dir') . '/journals/';
// If we're using paging, fetch the parameters
$usePaging = $site->getSetting('usePaging');
if ($usePaging) $rangeInfo =& $this->getRangeInfo('journals');
else $rangeInfo = null;
$templateMgr->assign('usePaging', $usePaging);
// Fetch the alpha list parameters
$searchInitial = Request::getUserVar('searchInitial');
$templateMgr->assign('searchInitial', $searchInitial);
$templateMgr->assign('useAlphalist', $site->getSetting('useAlphalist'));
$journals =& $journalDao->getJournals(
true,
$rangeInfo,
$searchInitial?JOURNAL_FIELD_TITLE:JOURNAL_FIELD_SEQUENCE,
$searchInitial?JOURNAL_FIELD_TITLE:null,
$searchInitial?'startsWith':null,
$searchInitial
);
$journals2 =& $journalDao->getJournals(
true,
$rangeInfo,
$searchInitial?JOURNAL_FIELD_TITLE:JOURNAL_FIELD_SEQUENCE,
$searchInitial?JOURNAL_FIELD_TITLE:null,
$searchInitial?'startsWith':null,
$searchInitial
);
// Get images for slider ___vkhan
include_once './pages/dbconfig.php'; // Db connections
$q = 'SELECT * FROM journal_settings t JOIN journals j ON j.journal_id=t.journal_id WHERE t.setting_name = "journalThumbnail" group by t.journal_id ORDER BY j.seq ASC';
$rs = $mysqli->query($q);
//$row = $rs->fetch_array();
$slider_img = '';
$j_img ="";
while ($row = $rs->fetch_array()){
$q2 = 'SELECT show_in_slider,id, rollover_text, url FROM journal_custom WHERE journal_id='.$row[0];
$slider_rs = $mysqli->query($q2);
$slider_row = $slider_rs->fetch_array();
//echo '<pre>';print_r($slider_row);die;
$q3 = 'SELECT path FROM journals WHERE journal_id='.$row[0];
$path_rs = $mysqli->query($q3);
$path_row = $path_rs->fetch_array();
if(strtolower($slider_row[0]) == "no")
continue;
$pos1 = strpos($row[3],'journalThumbnail_en_US');
$pos2 = strpos($row[3],'"', $pos1);
$img = substr($row[3], $pos1, $pos2-$pos1);
$img_url = $journalImageBasePath.$row[0].'/'.$img.'?'.time().'"';
$slider_img .= sprintf('<li class="j_slide_li">
<a href="%s" class="tooltip"> <span>%s</span>
<img src="%s" /></a></li>'
,$slider_row[3], $slider_row[2], $img_url);
// $q2 = 'SELECT show_in_slider,id, rollover_text FROM journal_custom WHERE id='.$row[0];
// $slider_rs = $mysqli->query($q2);
// $slider_row = $slider_rs->fetch_array();
// //echo '<pre>';print_r($slider_row);
//
// $q3 = 'SELECT path FROM journals WHERE journal_id='.$row[0];
// $path_rs = $mysqli->query($q3);
// $path_row = $path_rs->fetch_array();
//
// if(strtolower($slider_row[0]) == "no")
// continue;
////echo 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa';
//
// $pos1 = strpos($row[3],'journalThumbnail_en_US');
// $pos2 = strpos($row[3],'"', $pos1);
// $img = substr($row[3], $pos1, $pos2-$pos1);
// $img_url = $journalImageBasePath.$row[0].'/'.$img.'?'.time().'"';
//
// $slider_img .= sprintf('<li class="j_slide_li">
// <a href="%s" class="tooltip"> <span>%s</span>
// <img src="%s" /></a></li>'
// ,$request->getBaseUrl().'/index.php/'.$path_row[0], $slider_row[2], $img_url);
}//die;
//echo '<pre>';print_r($slider_img);die;
$templateMgr->assign('slider_img', $slider_img);
$templateMgr->assign('baseUrl', $request->getBaseUrl());
$templateMgr->assign_by_ref('journals', $journals);
// $templateMgr->assign_by_ref('tabContent', $j_img);
$templateMgr->assign_by_ref('site', $site);
$templateMgr->assign('alphaList', explode(' ', __('common.alphaList')));
$templateMgr->setCacheability(CACHEABILITY_PUBLIC);
$templateMgr->assign('is_home', true);
$templateMgr->display('index/journalList.tpl');
}
else {
$site =& Request::getSite();
if ($site->getRedirect() && ($journal = $journalDao->getById($site->getRedirect())) != null) {
$request->redirect($journal->getPath());
}
$templateMgr->assign('intro', $site->getLocalizedIntro());
$templateMgr->assign('journalFilesPath', $request->getBaseUrl() . '/' . Config::getVar('files', 'public_files_dir') . '/journals/');
$journalImageBasePath = $request->getBaseUrl() . '/' . Config::getVar('files', 'public_files_dir') . '/journals/';
// If we're using paging, fetch the parameters
$usePaging = $site->getSetting('usePaging');
if ($usePaging) $rangeInfo =& $this->getRangeInfo('journals');
else $rangeInfo = null;
$templateMgr->assign('usePaging', $usePaging);
// Fetch the alpha list parameters
$searchInitial = Request::getUserVar('searchInitial');
$templateMgr->assign('searchInitial', $searchInitial);
$templateMgr->assign('useAlphalist', $site->getSetting('useAlphalist'));
$journals =& $journalDao->getJournals(
true,
$rangeInfo,
$searchInitial?JOURNAL_FIELD_TITLE:JOURNAL_FIELD_SEQUENCE,
$searchInitial?JOURNAL_FIELD_TITLE:null,
$searchInitial?'startsWith':null,
$searchInitial
);
$journals2 =& $journalDao->getJournals(
true,
$rangeInfo,
$searchInitial?JOURNAL_FIELD_TITLE:JOURNAL_FIELD_SEQUENCE,
$searchInitial?JOURNAL_FIELD_TITLE:null,
$searchInitial?'startsWith':null,
$searchInitial
);
// Get images for slider ___vkhan
//$mysqli = new mysqli('localhost', 'root', '', 'oajpc');
$qu="SELECT * FROM home_tab_titles WHERE journal_id=0 AND form_locale='".AppLocale::getLocale()."'";
$resu=$mysqli->query($qu);
if($resu->num_rows > 0 && $resu->num_rows != null)
{
$result=$resu->fetch_array();
$tabName[1]=$result['overview'];
$tabName[2]=$result['indexing'];
$tabName[3]=$result['guidelines'];
$tabName[4]=$result['editors'];
$tabName[5]=$result['contactus'];
$tabName[6]=$result['newtab1'];
$tabName[7]=$result['newtab2'];
$tabName[8]=$result['newtab3'];
$tabName[9]=$result['newtab4'];
$tabName[10]=$result['newtab5'];
}
$qu2="SELECT * FROM home_tab_content WHERE journal_id=0 AND locale='".AppLocale::getLocale()."'";
$resu2=$mysqli->query($qu2);
if($resu2->num_rows > 0 && $resu2->num_rows != null)
{
$result=$resu2->fetch_array();
$tabContents[1]=$result['newtab1'];
$tabContents[2]=$result['newtab2'];
$tabContents[3]=$result['newtab3'];
$tabContents[4]=$result['newtab4'];
$tabContents[5]=$result['newtab5'];
}
//echo '<pre>';print_r($tabContent[1]);die;
$templateMgr->assign_by_ref('tabName', $tabName);
$templateMgr->assign_by_ref('tabContents', $tabContents);
$q = 'SELECT * FROM journal_settings t JOIN journals j ON j.journal_id=t.journal_id WHERE t.setting_name = "journalThumbnail" group by t.journal_id ORDER BY j.seq ASC';
$rs = $mysqli->query($q);
//$row = $rs->fetch_array();
$slider_img = '';
$j_img ="";
while ($row = $rs->fetch_array()){
//echo $row[0];die;
// SELECT * FROM `journal_custom` t JOIN `journals` j ON j.`journal_id`=t.journal_id WHERE `show_in_slider`='yes'
// ORDER BY j.`seq` ASC
$q2 = 'SELECT show_in_slider,id, rollover_text, url FROM journal_custom WHERE journal_id='.$row[0];
$slider_rs = $mysqli->query($q2);
$slider_row = $slider_rs->fetch_array();
//echo '<pre>';print_r($slider_row);die;
$q3 = 'SELECT path FROM journals WHERE journal_id='.$row[0];
$path_rs = $mysqli->query($q3);
$path_row = $path_rs->fetch_array();
if(strtolower($slider_row[0]) == "no")
continue;
$pos1 = strpos($row[3],'journalThumbnail_en_US');
$pos2 = strpos($row[3],'"', $pos1);
$img = substr($row[3], $pos1, $pos2-$pos1);
$img_url = $journalImageBasePath.$row[0].'/'.$img.'?'.time().'"';
$slider_img .= sprintf('<li class="j_slide_li">
<a href="%s" class="tooltip"> <span>%s</span>
<img src="%s" /></a></li>'
,$slider_row[3], $slider_row[2], $img_url);
}
// ---- Journal tabs
$q4 = 'SELECT journal_id, path FROM journals WHERE at_home=1 ORDER BY seq ASC';
$j_rs = $mysqli->query($q4);
while($j_row = $j_rs->fetch_array()){
// -----Journal Image
$q = 'SELECT * FROM journal_settings WHERE setting_name = "journalThumbnail" && journal_id ='.$j_row['journal_id'];
$rs = $mysqli->query($q);
if($rs->num_rows > 0 && $rs->num_rows != null){
$row = $rs->fetch_array();
$pos1 = strpos($row[3],'journalThumbnail_en_US');
$pos2 = strpos($row[3],'"', $pos1);
$img = substr($row[3], $pos1, $pos2-$pos1);
$img_url = $journalImageBasePath.$row[0].'/'.$img.'?'.time().'"';
}
else{
$img_url = $journalImageBasePath.'noimage.jpg';
}
//echo '<br /><br />';
// -----Journal Titel
$q = 'SELECT * FROM journal_settings WHERE setting_name = "title" && journal_id ='.$j_row['journal_id'];
$rs = $mysqli->query($q);
if($rs->num_rows > 0 && $rs->num_rows != null){
$row = $rs->fetch_array();
$title = $row[3];
$jli[]=$row[3];
}
else{
$title = "No Title";
}
// -----Journal Description
$q = 'SELECT * FROM journal_settings WHERE setting_name = "description" && journal_id ='.$j_row['journal_id'];
$rs = $mysqli->query($q);
if($rs->num_rows > 0 && $rs->num_rows != null){
$row = $rs->fetch_array();
$desc = $row[3];
}
else{
$desc = "No Description";
}
if(Validation::isLoggedIn())
{
$j_img .= sprintf('<div class="tab-content">
<div class="up_tab_div">
<div class="j_tab_img"><a href="%s" class="action"><img src="%s" /></a></div>
<div class="j_tab_content">
<span class="j_tab_title">Title : %s</span>
<span class="j_tab_des">Description : %s</span>
</div>
</div>
<div class="tab_links_div">
<a href="%s" class="action">Journal Home</a>
| <a href="%s" class="action">Current Issue</a>
| <a href="%s" class="action">Archives</a>
| <a href="%s" class="action">Editorial Team</a>
| <a href="%s" class="action">Submit Manuscript</a>
| <a href="%s" class="action">User Home</a>
</div>
</div>',
$request->getBaseUrl().'/index.php/'.$j_row['path'], $img_url,
$title, $desc,
$request->getBaseUrl().'/index.php/'.$j_row['path'],
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/current',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/archive',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/editorialTeam',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/submissions',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/user');
}
else{
$j_img .= sprintf('<div class="tab-content">
<div class="up_tab_div">
<div class="j_tab_img"><a href="%s" class="action"><img src="%s" /></a></div>
<div class="j_tab_content">
<span class="j_tab_title">Title : %s</span>
<span class="j_tab_des">Description : %s</span>
</div>
</div>
<div class="tab_links_div">
<a href="%s" class="action">Journal Home</a>
| <a href="%s" class="action">Current Issue</a>
| <a href="%s" class="action">Archives</a>
| <a href="%s" class="action">Editorial Team</a>
| <a href="%s" class="action">Submit Manuscript</a>
| <a href="%s" class="action">Register</a>
| <a href="%s" class="action">Login</a>
</div>
</div>',
$request->getBaseUrl().'/index.php/'.$j_row['path'], $img_url,
$title, $desc,
$request->getBaseUrl().'/index.php/'.$j_row['path'],
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/current',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/archive',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/editorialTeam',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/submissions',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/user/register',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/login');
}
}
//echo '<pre>';print_r($slider_img);die;
$templateMgr->assign('slider_img', $slider_img);
$templateMgr->assign('baseUrl', $request->getBaseUrl());
$templateMgr->assign_by_ref('journals', $journals);
$templateMgr->assign_by_ref('jli', $jli);
$templateMgr->assign_by_ref('tabContent', $j_img);
//-----------------Home Page Journal List----------------------------------------------
// ---- Journal tabs
$q4 = 'SELECT journal_id, path FROM journals WHERE at_home_jl=1 ORDER BY seq ASC';
$j_rs = $mysqli->query($q4);
while($j_row = $j_rs->fetch_array()){
// -----Journal Image
$q = 'SELECT * FROM journal_settings WHERE setting_name = "journalThumbnail" && journal_id ='.$j_row['journal_id'];
$rs = $mysqli->query($q);
if($rs->num_rows > 0 && $rs->num_rows != null){
$row = $rs->fetch_array();
$pos1 = strpos($row[3],'journalThumbnail_en_US');
$pos2 = strpos($row[3],'"', $pos1);
$img = substr($row[3], $pos1, $pos2-$pos1);
$img_url = $journalImageBasePath.$row[0].'/'.$img.'?'.time().'"';
}
else{
$img_url = $journalImageBasePath.'noimage.jpg';
}
//echo '<br /><br />';
// -----Journal Titel
$q = 'SELECT * FROM journal_settings WHERE setting_name = "title" && journal_id ='.$j_row['journal_id'];
$rs = $mysqli->query($q);
if($rs->num_rows > 0 && $rs->num_rows != null){
$row = $rs->fetch_array();
$title = $row[3];
$jli2[]=$row[3];
}
else{
$title = "No Title";
}
// -----Journal Description
$q = 'SELECT * FROM journal_settings WHERE setting_name = "description" && journal_id ='.$j_row['journal_id'];
$rs = $mysqli->query($q);
if($rs->num_rows > 0 && $rs->num_rows != null){
$row = $rs->fetch_array();
$desc = $row[3];
}
else{
$desc = "No Description";
}
if(Validation::isLoggedIn())
{
$j_img2 .= sprintf('<div class="tab-content">
<div class="up_tab_div">
<div class="j_tab_img"><a href="%s" class="action"><img src="%s" /></a></div>
<div class="j_tab_content">
<span class="j_tab_title">Title : %s</span>
<span class="j_tab_des">Description : %s</span>
</div>
</div>
<div class="tab_links_div">
<a href="%s" class="action">Journal Home</a>
| <a href="%s" class="action">Current Issue</a>
| <a href="%s" class="action">Archives</a>
| <a href="%s" class="action">Editorial Team</a>
| <a href="%s" class="action">Submit Manuscript</a>
| <a href="%s" class="action">User Home</a>
</div>
</div>',
$request->getBaseUrl().'/index.php/'.$j_row['path'], $img_url,
$title, $desc,
$request->getBaseUrl().'/index.php/'.$j_row['path'],
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/current',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/archive',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/editorialTeam',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/submissions',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/user');
}
else{
$j_img2 .= sprintf('<div class="tab-content">
<div class="up_tab_div">
<div class="j_tab_img"><a href="%s" class="action"><img src="%s" /></a></div>
<div class="j_tab_content">
<span class="j_tab_title">Title : %s</span>
<span class="j_tab_des">Description : %s</span>
</div>
</div>
<div class="tab_links_div">
<a href="%s" class="action">Journal Home</a>
| <a href="%s" class="action">Current Issue</a>
| <a href="%s" class="action">Archives</a>
| <a href="%s" class="action">Editorial Team</a>
| <a href="%s" class="action">Submit Manuscript</a>
| <a href="%s" class="action">Register</a>
| <a href="%s" class="action">Login</a>
</div>
</div>',
$request->getBaseUrl().'/index.php/'.$j_row['path'], $img_url,
$title, $desc,
$request->getBaseUrl().'/index.php/'.$j_row['path'],
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/current',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/issue/archive',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/editorialTeam',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/about/submissions',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/user/register',
$request->getBaseUrl().'/index.php/'.$j_row['path'].'/login');
}
}
//echo '<pre>';print_r($slider_img);die;
//$templateMgr->assign('slider_img', $slider_img);
//$templateMgr->assign('baseUrl', $request->getBaseUrl());
//$templateMgr->assign_by_ref('journals2', $journals);
$templateMgr->assign_by_ref('jli2', $jli2);
$templateMgr->assign_by_ref('tabContent2', $j_img2);
//---------------------Home Page Tabs Articles------------------------------------------
$q = 'SELECT * FROM articles WHERE at_home=1 LIMIT 10';
$res = $mysqli->query($q);
$i=0;
while($result = $res->fetch_array()){
//echo '<pre>';print_r($result);die;
// -----early release--------------------------
if($result['early_view']==1)
{
$ER[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$ERauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$ERauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$ER[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$ER[$i][]=$jnames[0];
$ER[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$ER[$i][]=$jourqs[0];
}
if($result['recommend']==1)
{
$RC[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$RCauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$RCauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$RC[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$RC[$i][]=$jnames[0];
$RC[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$RC[$i][]=$jourqs[0];
}
$i++;
}
$q1 = 'SELECT * FROM articles WHERE recently_published=1 AND at_home=1 ORDER BY date_submitted DESC LIMIT 10';
$res1 = $mysqli->query($q1);
$i=0;
while($result = $res1->fetch_array())
{
//echo '<pre>';print_r($result);die;
$RA[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$RAauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$RAauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$RA[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$RA[$i][]=$jnames[0];
$RA[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$RA[$i][]=$jourqs[0];
$i++;
}
$q2 = 'SELECT * FROM articles WHERE most_viewed=1 AND at_home=1 ORDER BY view_count DESC LIMIT 10';
$res2 = $mysqli->query($q2);
$i=0;
while($result = $res2->fetch_array())
{
//echo '<pre>';print_r($result);die;
$VI[$i][]=$result['article_id'];
$sql='SELECT first_name,middle_name,last_name FROM authors WHERE submission_id ='.$result[0];
$auth = $mysqli->query($sql);
while($authors = $auth->fetch_array() )
{
//echo '<pre>';print_r($authors);die;
if(!empty($authors[1]))
$VIauthor[$i][]=$authors[0].' '.$authors[1].' '.$authors[2];
else
$VIauthor[$i][]=$authors[0].' '.$authors[2];
}
$sql1='SELECT setting_value FROM article_settings WHERE article_id = '.$result[0].' AND setting_name = "title"';
$artName= $mysqli->query($sql1);
$names = $artName->fetch_array();
$VI[$i][]=$names[0];
$sql2='SELECT setting_value FROM journal_settings WHERE journal_id = '.$result[3].' AND setting_name = "title"';
$jourName= $mysqli->query($sql2);
$jnames = $jourName->fetch_array();
$VI[$i][]=$jnames[0];
$VI[$i][]=$result['view_count'];
$sqlq='SELECT path FROM journals WHERE journal_id ='.$result[3];
$jourq = $mysqli->query($sqlq);
$jourqs = $jourq->fetch_array();
$VI[$i][]=$jourqs[0];
$i++;
}
$templateMgr->assign_by_ref('ER', $ER);
$templateMgr->assign_by_ref('ERauthor', $ERauthor);
$templateMgr->assign_by_ref('RC', $RC);
$templateMgr->assign_by_ref('RCauthor', $RCauthor);
$templateMgr->assign_by_ref('RA', $RA);
$templateMgr->assign_by_ref('RAauthor', $RAauthor);
$templateMgr->assign_by_ref('VI', $VI);
$templateMgr->assign_by_ref('VIauthor', $VIauthor);
//---------------------------------------------------------------
//--------Additional Tabs---------------------
$sql10="SELECT * FROM home_custom_tab WHERE journal_id=0 AND tab_name='additional_tabs' AND form_locale='".AppLocale::getLocale()."'";
$tab= $mysqli->query($sql10);
$tabs = $tab->fetch_array();
if($tab->num_rows > 0 && $tab->num_rows != null)
$tabValue=$tabs['content'];
else
$tabValue='';
$templateMgr->assign('tabValue', $tabValue);
//-----------------------------
$templateMgr->assign_by_ref('site', $site);
$templateMgr->assign('alphaList', explode(' ', __('common.alphaList')));
$templateMgr->setCacheability(CACHEABILITY_PUBLIC);
$templateMgr->assign('is_home', true);
$templateMgr->display('index/site.tpl');
}
}
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment