include('include/common.inc.php');
include('nb_specific/common.inc.php');
include('nb_specific/security.inc.php');
include('modules/list/list.class.php');
include('modules/article/article.class.php');
include('include/library/edatabase.inc.php');
global $lang;
$lang = GetLanguage();
$type = $_GET['mag'];
$pos = strpos($type,"e_");
$is_e_printed = 0;
if ($pos !== false)
{
$type = substr($type,$pos+2);
$is_e_printed = 1;
}
ShowTopPart();
//if ($is_e_printed)
{
$isIssue = false;
$isRubric = false;
EDBConnect();
$mag_info = GetRecordSet('emag_mags', array('*'), "str_id = '".$type."'");
EDBDisconnect();
if(!isset($mag_info))
{
EDBConnect();
$mag_info = GetRecordSet('emag_mags', array('*'), "str_id_eng_nb = '".$type."'");
EDBDisconnect();
}
$mag_info = $mag_info[0];
$id_mag = $mag_info['id_mag'];
$side_menu = new CList('enotabene.emag_pages', 'id_lang='.$lang.' AND (id_mag='.$id_mag.' OR id_mag = -3) ORDER BY order_value DESC, id_page ASC', array("id_page", "title"), "side_menu_e_mag/");
$side_menu->AddConst('view_content_link','1');
$side_menu->AddConst('current_authors_info','1');
$side_menu->AddConst('phrase_authors_info',$lang == 2? "About authors" :" ");
$side_menu->SetRecordCountInPage(100);
DBConnect();
$rubrics =GetRecordSet('enotabene.emag_rubrics', array("title","title_eng", "id_rubric", "is_active"), "id_mag = '".$id_mag."' ORDER BY order_value ASC, id_rubric ASC");
DBDisconnect();
$side_menu->AddConst('rubrics', $rubrics);
$side_menu->AddConst('mag',$type);
$side_menu->AddConst('mag_info', $mag_info);
$side_menu_html = $side_menu->Show(true);
EDBConnect();
$articles = GetRecordSet('emag_articles', array('id_user', 'id_article', 'exclude_author'), '((status = 7) OR (status = 10)) AND id_mag = '.$id_mag);
$userIDs = array();
$articleIDs = array();
for ($i = 0; $i < count($articles); $i++)
{
if ($articles[$i]['exclude_author'] != 1)
{
$userIDs[] = $articles[$i]['id_user'];
}
$articleIDs[] = $articles[$i]['id_article'];
}
$articleIDsStr = implode(',', $articleIDs);
$userIDsStr = implode(',', $userIDs);
$authors = GetRecordSet('emag_users', array('*'), 'id_user IN ('.$userIDsStr.')');
$coauthorsIDs_ = GetRecordSet('emag_coauthors_by_article', array('*'), 'id_article IN ('.$articleIDsStr.')');
$coauthorsIDs = array();
for ($i = 0; $i < count($coauthorsIDs_); $i++)
{
$coauthorsIDs[] = $coauthorsIDs_[$i]['id_coauthor'];
}
$coauthorsIDsStr = implode(',', $coauthorsIDs);
$coauthors = GetRecordSet('emag_coauthors', array('*'), 'id_coauthor IN ('.$coauthorsIDsStr.')');
EDBDisconnect();
for ($i = 0; $i < count($coauthors); $i++)
{
$authors[] = $coauthors[$i];
}
for ($i = 0; $i < count($authors); $i++)
{
$authors[$i]['contact_address'] = str_replace('
', ' ', $authors[$i]['contact_address']);
$authors[$i]['contact_address_eng'] = str_replace('
', ' ', $authors[$i]['contact_address_eng']);
}
$sortIndices = array();
// сортировка по алфавиту
for ($i = 0; $i < count($authors); $i++)
{
$sortIndices[$i] = trim($authors[$i]['surname'].' '.$authors[$i]['name'].' '.$authors[$i]['middlename']);
}
asort($sortIndices, SORT_STRING);
$authorsOld = $authors;
$authors = array();
$oldValue = "";
foreach ($sortIndices as $key => $value)
{
if ($value != $oldValue)
{
$authors[] = $authorsOld[$key];
$oldValue = $value;
}
}
$page = new CSimplePage('e_authors.tpl');
$page->AddVar("items", $authors);
$page->AddVar('side_menu', $side_menu_html);
$page->AddVar('mag_info', $mag_info);
$page->AddVar('lang', $lang);
$page->Show();
ShowBottomPart();
}
?>