require ( 'include/super_main.php' );

$images = new IMAGES($mysql, TABLE_IMAGES);
$images->fpath = '.';
$images->prefix = $prefix.$lang_prefix;

$data = new DATA ( $mysql, TABLE_DATA, $images);
$data->data_per_page = 20;
$data->sort_by = 'data_date';
$data->where .= " AND archive = 0";

$data->prefix = 'rc'.$lang_prefix;
$temp = $data->get_by_where(array('onmain' => '1'));
$next_congr_rus = $temp[0];

$data->prefix = 'rs'.$lang_prefix;
$temp = $data->get_by_where(array('onmain' => '1'));
$next_sem_rus = $temp[0];

$data->prefix = 'wc'.$lang_prefix;
$temp = $data->get_by_where(array('onmain' => '1'));
$next_congr_world = $temp[0];

$data->prefix = 'ws'.$lang_prefix;
$temp = $data->get_by_where(array('onmain' => '1'));
$next_sem_world = $temp[0];

$text = $mysql->select(TABLE_TEXT, 'text', "id = '3' and code = '$code'");
$text = $text[0]['text'];
$smarty->assign('maintext', $text );

$images->prefix = 'banners'.$lang_prefix;
for ($i =0; $i < 7; $i++) {
	$uploaded = $images->get_files_by_parentid($i);
	$files[$i] = $uploaded[0]; 
}

$smarty->assign('files', $files);
$smarty->assign('next_congr_rus', $next_congr_rus);
$smarty->assign('next_sem_rus', $next_sem_rus);
$smarty->assign('next_congr_world', $next_congr_world);
$smarty->assign('next_sem_world', $next_sem_world);

$smarty->display("index.tpl");
?>