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();
}
?>