PHP date_sql函数代码示例

 public function editar($accion, $codigo = "")
 {
     $lista = new stdClass();
     if ($accion == "e") {
         $filter = new stdClass();
         $filter->ciclo = $codigo;
         $ciclos = $this->ciclo_model->obtener($filter);
         $lista->finicio = date_sql(substr($ciclos->CICC_FECHA_INICIO, 0, 10));
         $lista->ffin = date_sql(substr($ciclos->CICC_FECHA_FIN, 0, 10));
         $lista->descripcion = $ciclos->CICC_DESCRIPCION;
         $lista->codigo = $ciclos->CICLOP_Codigo;
         $lista->nombre = $ciclos->COMPC_Nombre;
         $lista->tipociclo = $ciclos->TIPOCICLOP_Codigo;
     } elseif ($accion == "n") {
         $lista->finicio = "";
         $lista->ffin = "";
         $lista->descripcion = "";
         $lista->codigo = "";
         $lista->nombre = "";
         $lista->tipociclo = "";
     }
     $arrTipociclo = array("0" => "::Seleccione::", "1" => "Ciclo 1", "2" => "Ciclo 2");
     $data['titulo'] = $accion == "e" ? "Editar Ciclo" : "Crear Ciclo";
     $data['form_open'] = form_open('', array("name" => "frmPersona", "id" => "frmPersona", "onsubmit" => "return valida_guiain();"));
     $data['form_close'] = form_close();
     $data['lista'] = $lista;
     $data['seltipociclo'] = form_dropdown('tipociclo', $arrTipociclo, $lista->tipociclo, "id='tipociclo' class='comboMedio'");
     $data['oculto'] = form_hidden(array("accion" => $accion, "codigo_padre" => $codigo, "codigo" => $lista->codigo));
     $this->load->view("maestros/ciclo_nuevo", $data);
 }

 protected function main()
 {
     // Si le paramètre ID manque
     if (empty($_GET['id']) || !is_numeric($_GET['id'])) {
         header('Location: news-70.html');
     }
     inc_lib('news/news_exists');
     if (news_exists($_GET['id']) == false) {
         redir(Nw::$lang['news']['news_not_exist'], false, 'news-70.html');
     }
     inc_lib('news/get_info_news');
     $donnees_news = get_info_news($_GET['id']);
     // Ce membre a le droit d'éditer la news ?
     if ($donnees_news['n_etat'] != 3 && !is_logged_in()) {
         redir(Nw::$lang['news']['not_view_news_perm'], false, './');
     }
     $this->set_tpl('mobile/news/view_news.html');
     $this->load_lang_file('news');
     inc_lib('news/has_voted_news');
     Nw::$tpl->set(array('ID' => $_GET['id'], 'ETAT' => $donnees_news['n_etat'], 'CAT_ID' => $donnees_news['c_id'], 'CAT_TITRE' => $donnees_news['c_nom'], 'AUTEUR' => $donnees_news['u_pseudo'], 'AUTEUR_ALIAS' => $donnees_news['u_alias'], 'AUTEUR_AVATAR' => $donnees_news['u_avatar'], 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'COMS' => $donnees_news['n_nbr_coms'], 'NB_VOT_VALID' => Nw::$pref['nb_votes_valid_news'], 'VOTES' => $donnees_news['n_nb_votes'], 'VOTES_NEG' => $donnees_news['n_nb_votes_neg'], 'IMAGE_ID' => $donnees_news['i_id'], 'IMAGE_NOM' => $donnees_news['i_nom'], 'SOURCE' => !empty($donnees_news['n_src_url']) ? $donnees_news['n_src_url'] : '', 'SOURCE_NOM' => !empty($donnees_news['n_src_nom']) ? $donnees_news['n_src_nom'] : '', 'TITRE' => $donnees_news['n_titre'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'CONTENU' => $donnees_news['v_texte'], 'HAS_VOTED' => is_logged_in() ? $donnees_news['v_id_membre'] : 0));
     // Màj du nombre de visualisations
     inc_lib('news/update_pg_vues');
     update_pg_vues($_GET['id']);
     Nw::$tpl->set('INC_HEAD', empty($_SERVER['HTTP_AJAX']));
 }

 protected function main()
 {
     if (!is_logged_in() && !check_auth('view_histo_all_news')) {
         header('Location: ./');
     }
     $this->set_title(Nw::$lang['news']['historiques_news']);
     $this->set_tpl('news/log_admin.html');
     $this->add_css('code.css');
     $this->set_filAriane(array(Nw::$lang['news']['news_section'] => array('news-70.html'), Nw::$lang['news']['historiques_news'] => array('')));
     $get_param = '';
     $param_tpl = '';
     if (!empty($_GET['t'])) {
         $get_param = 'l_titre LIKE "%' . insertBD(urldecode($_GET['t'])) . '%" OR l_texte LIKE "%' . insertBD(urldecode($_GET['t'])) . '%"';
         $param_tpl = htmlspecialchars($_GET['t']);
     }
     inc_lib('news/count_news_logs');
     $nombre_logs = count_news_logs($get_param);
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_logs / Nw::$pref['nb_logs_admin']);
     // On vérifie que la page existe bien
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, 'news-21.html?t=' . $param_tpl);
     }
     /**
      *   Affichage du logo
      **/
     inc_lib('news/get_news_logs');
     $donnees_logs = get_news_logs($get_param, 'l_date DESC', $page, Nw::$pref['nb_logs_admin']);
     foreach ($donnees_logs as $donnees) {
         Nw::$tpl->setBlock('log', array('ACTION' => $donnees['l_action'], 'ACTION_LOG' => isset(Nw::$lang['news']['log_news_' . $donnees['l_action']]) ? Nw::$lang['news']['log_news_' . $donnees['l_action']] : '', 'TEXTE' => nl2br($donnees['l_texte']), 'DATE' => date_sql($donnees['date'], $donnees['heures_date'], $donnees['jours_date']), 'AUTEUR' => $donnees['u_pseudo'], 'AUTEUR_ID' => $donnees['u_id'], 'AUTEUR_AVATAR' => $donnees['u_avatar'], 'AUTEUR_ALIAS' => $donnees['u_alias'], 'NEWS_ID' => $donnees['l_id_news'], 'NEWS_TITRE' => $donnees['n_titre'], 'TITRE_ACTU' => $donnees['l_titre'], 'IP' => long2ip($donnees['l_ip'])));
     }
     Nw::$tpl->set(array('TITRE' => urldecode($param_tpl), 'LIST_PG' => list_pg($nombreDePages, $page, 'news-21%s.html?t=' . $param_tpl)));
 }

 protected function main()
 {
     $this->set_tpl('mobile/news/une.html');
     $this->load_lang_file('news');
     // On compte le nbr de news publiées
     inc_lib('news/count_news');
     $nombre_news = count_news('n_etat = 3');
     $ids_all_news = array();
     // Pagination
     $page = !empty($_GET['page']) ? (int) $_GET['page'] : 1;
     $nombreDePages = ceil($nombre_news / Nw::$pref['nb_news_homepage']);
     // On vérifie que la page existe bien
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     // On recherche toutes les news publiées
     inc_lib('news/get_list_news');
     $list_dn_news = get_list_news('n_etat = 3', 'n_date DESC', $page, Nw::$pref['nb_news_homepage']);
     $cours_news = 0;
     foreach ($list_dn_news as $donnees_news) {
         Nw::$tpl->setBlock('news', array('ID' => $donnees_news['n_id'], 'CAT_ID' => $donnees_news['c_id'], 'CAT_TITRE' => $donnees_news['c_nom'], 'CAT_REWRITE' => rewrite($donnees_news['c_nom']), 'IMAGE_ID' => $donnees_news['i_id'], 'IMAGE_NOM' => $donnees_news['i_nom'], 'TITRE' => $donnees_news['n_titre'], 'RESUME' => $donnees_news['n_resume'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'AUTEUR' => $donnees_news['u_pseudo'], 'AUTEUR_ID' => $donnees_news['u_id'], 'AUTEUR_ALIAS' => $donnees_news['u_alias'], 'AUTEUR_AVATAR' => $donnees_news['u_avatar'], 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'NBR_VOTES' => $donnees_news['n_nb_votes'], 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : '')));
         ++$cours_news;
     }
     Nw::$tpl->set(array('LIST_PG' => list_pg($nombreDePages, $page, 'mobile-2%s.html'), 'NB_NEWS' => $cours_news, 'INC_HEAD' => empty($_SERVER['HTTP_AJAX'])));
 }

 protected function main()
 {
     inc_lib('news/news_exists');
     $count_news_existe = news_exists($_GET['id']);
     if ($count_news_existe == false && (is_logged_in() && !check_auth('view_histo_all_news'))) {
         redir(Nw::$lang['news']['news_not_exist'], false, './');
     }
     inc_lib('news/get_info_news');
     $donnees_news = get_info_news($_GET['id']);
     $this->set_title(Nw::$lang['news']['historique_news'] . ' | ' . $donnees_news['n_titre']);
     $this->set_tpl('news/log_news.html');
     $this->add_css('code.css');
     // Fil ariane
     if ($count_news_existe) {
         $this->set_filAriane(array(Nw::$lang['news']['news_section'] => array('news-70.html'), $donnees_news['c_nom'] => array($donnees_news['c_rewrite'] . '/'), $donnees_news['n_titre'] => array($donnees_news['c_rewrite'] . '/' . rewrite($donnees_news['n_titre']) . '-' . $_GET['id'] . '/'), Nw::$lang['news']['historique_news'] => array('')));
     } else {
         $this->set_filAriane(array(Nw::$lang['news']['news_section'] => array('news-70.html'), Nw::$lang['news']['historique_news'] => array('')));
     }
     /**
      *   Affichage du logo
      **/
     inc_lib('news/get_news_logs');
     $donnees_logs = get_news_logs('l_id_news = ' . intval($_GET['id']), 'l_date DESC');
     foreach ($donnees_logs as $donnees) {
         Nw::$tpl->setBlock('log', array('ACTION' => $donnees['l_action'], 'ACTION_LOG' => isset(Nw::$lang['news']['log_news_' . $donnees['l_action']]) ? Nw::$lang['news']['log_news_' . $donnees['l_action']] : '', 'TEXTE' => nl2br($donnees['l_texte']), 'TITRE' => $donnees['l_titre'], 'DATE' => date_sql($donnees['date'], $donnees['heures_date'], $donnees['jours_date']), 'AUTEUR' => $donnees['u_pseudo'], 'AUTEUR_ID' => $donnees['u_id'], 'AUTEUR_AVATAR' => $donnees['u_avatar'], 'AUTEUR_ALIAS' => $donnees['u_alias'], 'IP' => long2ip($donnees['l_ip'])));
     }
     Nw::$tpl->set(array('ID' => $_GET['id'], 'TITRE' => $donnees_news['n_titre']));
 }

 protected function main()
 {
     if (!is_logged_in()) {
         header('Location: mobile.html');
     }
     $this->set_tpl('mobile/categories/list_news.html');
     $this->load_lang_file('news');
     // On compte le nbr de news en rédaction
     inc_lib('news/count_news');
     $nombre_news = count_news('n_etat = 1');
     // Pagination
     $page = (!empty($_GET['page']) and is_numeric($_GET['page']) and $_GET['page'] > 0) ? (int) $_GET['page'] : 1;
     $nombreDePages = ceil($nombre_news / Nw::$pref['nb_news_redac']);
     // On vérifie bien que la page existe
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './mobile.html');
     }
     // On recherche toutes les news en rédaction
     inc_lib('news/get_list_news');
     $list_dn_news = get_list_news('n_etat = 1', 'n_date DESC', $page, Nw::$pref['nb_news_redac']);
     // On affiche toutes les news en rédaction
     foreach ($list_dn_news as $donnees_news) {
         Nw::$tpl->setBlock('news', array('ID' => $donnees_news['n_id'], 'CAT_ID' => $donnees_news['c_id'], 'CAT_TITRE' => $donnees_news['c_nom'], 'IMAGE_ID' => $donnees_news['i_id'], 'IMAGE_NOM' => $donnees_news['i_nom'], 'TITRE' => $donnees_news['n_titre'], 'RESUME' => $donnees_news['n_resume'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'AUTEUR' => $donnees_news['u_pseudo'], 'AUTEUR_ID' => $donnees_news['u_id'], 'AUTEUR_ALIAS' => $donnees_news['u_alias'], 'AUTEUR_AVATAR' => $donnees_news['u_avatar'], 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'VOTES' => $donnees_news['n_nb_votes'], 'VOTES_NEG' => $donnees_news['n_nb_votes_neg'], 'HAS_VOTED' => is_logged_in() ? $donnees_news['v_id_membre'] : 0));
     }
     Nw::$tpl->set(array('LIST_PG' => list_pg($nombreDePages, $page, 'mobile-2%s.html'), 'NB_NEWS' => $nombre_news, 'TITLE' => Nw::$lang['news']['en_attente_title'], 'TITLE_REWRITE' => 'news_en_attente', 'INC_HEAD' => empty($_SERVER['HTTP_AJAX'])));
 }

 protected function main()
 {
     // Si le paramètre ID manque
     if (empty($_GET['id'])) {
         header('Location: ./');
     }
     inc_lib('users/mbr_exists');
     if (mbr_exists($_GET['id']) == false) {
         redir(Nw::$lang['users']['mbr_dont_exist'], false, 'users.html');
     }
     inc_lib('users/get_info_mbr');
     $donnees_profile = get_info_mbr($_GET['id']);
     $this->load_lang_file('users');
     $this->load_lang_file('news');
     $this->add_wid_in_content('view_profile.' . $donnees_profile['u_id']);
     $this->set_tpl('profile/list_comments.html');
     $this->set_title(sprintf(Nw::$lang['profile']['profile_title'], $donnees_profile['u_pseudo']));
     $this->add_css('code.css');
     $this->add_js('profil.js');
     $this->set_filAriane(array(Nw::$lang['users']['members_section'] => array('users.html'), $donnees_profile['u_pseudo'] => array('./profile/' . $donnees_profile['u_alias'] . '/'), Nw::$lang['profile']['title_cmts_author'] => array('')));
     $params_contrib = array();
     $params_contrib[] = 'c_id_membre = ' . intval($_GET['id']);
     if (!is_logged_in()) {
         $params_contrib[] = 'n_etat = 3';
     }
     inc_lib('profile/count_comments_mbr');
     $nombre_cmts = count_comments_mbr(implode(' AND ', $params_contrib));
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_cmts / Nw::$pref['ppl_nb_comments']);
     // On vérifie bien que la page existe
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     inc_lib('profile/get_comments_mbr');
     $com_cours = 0;
     $list_cmts = get_comments_mbr(implode(' AND ', $params_contrib), 'c_date DESC', $page, Nw::$pref['ppl_nb_comments']);
     foreach ($list_cmts as $donnees_cmts) {
         ++$com_cours;
         $droit_edit = false;
         $droit_delete = false;
         if (is_logged_in()) {
             $droit_edit = (bool) (Nw::$droits['can_edit_my_comments'] && $donnees_cmts['u_id'] == Nw::$dn_mbr['u_id']) || Nw::$droits['can_edit_all_comments'];
             $droit_delete = (bool) (Nw::$droits['can_del_my_comments'] && $donnees_cmts['u_id'] == Nw::$dn_mbr['u_id']) || Nw::$droits['can_del_all_comments'];
         }
         $date_cmt = date_sql($donnees_cmts['date'], $donnees_cmts['heures_date'], $donnees_cmts['jours_date']);
         $masque_motif = '';
         if ($donnees_cmts['c_masque']) {
             $date_cmt = sprintf(Nw::$lang['news']['del_cmt_with_reason'], strtolower(date_sql($donnees_cmts['date'], $donnees_cmts['heures_date'], $donnees_cmts['jours_date'])));
             if (!empty($donnees_cmts['c_masque_raison'])) {
                 $masque_motif = ' (' . sprintf(Nw::$lang['news']['motif_delete_cmt'], $donnees_cmts['c_masque_raison']) . ')';
             }
         }
         Nw::$tpl->setBlock('cmt', array('ID' => $donnees_cmts['c_id'], 'ID_NEWS' => $donnees_cmts['c_id_news'], 'REWRITE' => rewrite($donnees_cmts['n_titre']), 'CAT_REWRITE' => $donnees_cmts['c_rewrite'], 'NUM' => ($page - 1) * Nw::$pref['nb_cmts_page'] + $com_cours, 'DATE' => $date_cmt, 'AVATAR' => $donnees_cmts['u_avatar'], 'LANG_AVATAR' => sprintf(Nw::$lang['news']['lang_avatar'], $donnees_cmts['u_pseudo']), 'AUTEUR' => $donnees_cmts['u_pseudo'], 'AUTEUR_ID' => $donnees_cmts['u_id'], 'AUTEUR_ALIAS' => $donnees_cmts['u_alias'], 'TEXTE' => $donnees_cmts['c_texte'], 'PLUSSOIE' => $donnees_cmts['c_plussoie'], 'GRP_TITRE' => $donnees_cmts['g_titre'], 'GRP_ICON' => $donnees_cmts['g_icone'], 'IP' => long2ip($donnees_cmts['c_ip']), 'MASQUE' => $donnees_cmts['c_masque'], 'MASQUE_MOTIF' => $masque_motif, 'EDIT' => $droit_edit, 'DELETE' => $droit_delete));
     }
     Nw::$tpl->set(array('NOMBRE_CMTS' => $nombre_cmts, 'LIST_PG' => list_pg($nombreDePages, $page, 'profile-135-' . $_GET['id'] . '%s.html')));
     inc_lib('profile/assign_required_vars_profile');
     assign_required_vars_profile($donnees_profile);
 }

 protected function main()
 {
     $this->set_title(Nw::$site_slogan);
     $this->set_tpl('news/homepage.html');
     $this->add_css('code.css');
     $this->set_filAriane(Nw::$site_slogan);
     $this->add_wid_in_content('homepage');
     // On compte le nbr de news publiées
     inc_lib('news/count_news');
     $nombre_news = count_news('n_etat = 3');
     $ids_all_news = array();
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_news / Nw::$pref['nb_news_homepage']);
     // On vérifie que la page existe bien
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     // On recherche toutes les news publiées
     inc_lib('news/get_list_news');
     inc_lib('news/can_edit_news');
     $list_dn_news = get_list_news('n_etat = 3', 'n_date DESC', $page, Nw::$pref['nb_news_homepage']);
     $cours_news = 0;
     $cours_news2 = 0;
     foreach ($list_dn_news as $donnees_news) {
         $ids_all_news[] = $donnees_news['n_id'];
         Nw::$tpl->setBlock('news', array('ID' => $donnees_news['n_id'], 'COURS' => $cours_news % 2, 'COURS2' => $cours_news2 % 2, 'CAT_ID' => $donnees_news['c_id'], 'CAT_TITRE' => $donnees_news['c_nom'], 'CAT_REWRITE' => $donnees_news['c_rewrite'], 'IMAGE_ID' => $donnees_news['i_id'], 'IMAGE_NOM' => $donnees_news['i_nom'], 'TITRE' => $donnees_news['n_titre'], 'RESUME' => $donnees_news['n_resume'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'AUTEUR' => $donnees_news['u_pseudo'], 'AUTEUR_ID' => $donnees_news['u_id'], 'AUTEUR_ALIAS' => $donnees_news['u_alias'], 'AUTEUR_AVATAR' => $donnees_news['u_avatar'], 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'HAS_VOTED' => is_logged_in() ? $donnees_news['v_id_membre'] : 0, 'NBR_VOTES' => $donnees_news['n_nb_votes'], 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'MORE_NEWS' => isset($donnees_news['first_tag']) ? sprintf(Nw::$lang['news']['more_news_sujet'], urlencode($donnees_news['first_tag']), ucfirst($donnees_news['first_tag'])) : '', 'DRT_EDIT' => is_logged_in() ? can_edit_news($donnees_news['n_id_auteur'], $donnees_news['n_etat']) : false, 'DRT_DELETE' => is_logged_in() && ($donnees_news['n_id_auteur'] == Nw::$dn_mbr['u_id'] && Nw::$droits['can_delete_mynews'] || Nw::$droits['can_delete_news']) ? true : false));
         if ($donnees_news['i_id'] != 0) {
             ++$cours_news;
         }
         ++$cours_news2;
     }
     $news_related = array();
     if (count($ids_all_news) > 0) {
         inc_lib('news/get_list_news_related');
         $news_related = get_list_news_related($ids_all_news);
     }
     /**
      *   Actus populaires
      **/
     inc_lib('news/get_list_top_actu');
     $hot_actu = get_list_top_actu(4);
     foreach ($hot_actu as $donnees) {
         Nw::$tpl->setBlock('top', array('ID' => $donnees['n_id'], 'TITRE' => $donnees['n_titre'], 'CAT_REWRITE' => $donnees['c_rewrite'], 'REWRITE' => rewrite($donnees['n_titre']), 'DATE' => date_sql($donnees['date_news'], $donnees['heures_date_news'], $donnees['jours_date_news']), 'AUTEUR_ID' => $donnees['n_id_auteur'], 'NBR_VOTES' => $donnees['n_nb_votes'], 'HAS_VOTED' => is_logged_in() ? $donnees['v_id_membre'] : 0, 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees['n_nbr_coms'], $donnees['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'IMAGE_ID' => $donnees['i_id'], 'IMAGE_NOM' => $donnees['i_nom']));
     }
     /**
      *   Nuage de tags
      **/
     inc_lib('news/nuage_tags');
     $tags_a_afficher = 30;
     $nuage_tags = nuage_tags($tags_a_afficher);
     foreach ($nuage_tags as $donnees_tags) {
         Nw::$tpl->setBlock('nuage', array('INT' => $donnees_tags['t_tag'], 'REWRITE' => urlencode($donnees_tags['t_tag']), 'SIZE' => $donnees_tags['size'], 'COLOR' => $donnees_tags['c_couleur']));
     }
     Nw::$tpl->set(array('LIST_PG' => list_pg($nombreDePages, $page, 'news%s.html'), 'RELATED' => $news_related, 'FIRST_VISIT' => (bool) (!is_logged_in() && !isset($_COOKIE['nw_fv']))));
 }

 public function editar($accion, $codigo = "")
 {
     $filter = new stdClass();
     $filter->codigo = 1;
     $filter->rol = 4;
     $filter->order_by = array("p.MENU_Codigo" => "asc");
     $menu_padre = $this->permiso_model->listar($filter);
     $lista = new stdClass();
     if ($accion == "e") {
         $filter = new stdClass();
         $filter->cliente = $codigo;
         $clientes = $this->alumno_model->obtener($filter);
         $lista->numerodoc = $clientes->PERSC_NumeroDocIdentidad;
         $lista->sexo = $clientes->PERSC_Sexo;
         $lista->direccion = $clientes->PERSC_Direccion;
         $lista->telefono = $clientes->PERSC_Telefono;
         $lista->email = $clientes->PERSC_Email;
         $lista->movil = $clientes->PERSC_Movil;
         $lista->fax = $clientes->PERSC_Fax;
         $lista->web = $clientes->PERSC_Web;
         $lista->fnac = date_sql($clientes->PERSC_FechaNacimiento);
         $lista->paterno = $clientes->PERSC_ApellidoPaterno;
         $lista->materno = $clientes->PERSC_ApellidoMaterno;
         $lista->nombres = $clientes->PERSC_Nombre;
         $lista->codigo = $clientes->PERSP_Codigo;
         $lista->estado = $clientes->CLIC_FlagEstado;
     } elseif ($accion == "n") {
         $lista->numerodoc = "";
         $lista->sexo = "";
         $lista->direccion = "";
         $lista->telefono = "";
         $lista->email = "";
         $lista->movil = "";
         $lista->fax = "";
         $lista->web = "";
         $lista->ecivil = 0;
         $lista->fnac = "";
         $lista->paterno = "";
         $lista->materno = "";
         $lista->nombres = "";
         $lista->sexo = 0;
         $lista->codigo = "";
         $lista->estado = 1;
     }
     $arrSexo = array("0" => "::Seleccione::", "1" => "MASCULINO", "2" => "FEMENINO");
     $arrEstado = array("0" => "::Seleccione::", "1" => "ACTIVO", "2" => "INACTIVO");
     $data['titulo'] = $accion == "e" ? "Editar Alumno" : "Crear Alumno";
     $data['menu'] = $menu_padre;
     $data['form_open'] = form_open('', array("name" => "frmPersona", "id" => "frmPersona", "onsubmit" => "return valida_guiain();"));
     $data['form_close'] = form_close();
     $data['lista'] = $lista;
     $data['selsexo'] = form_dropdown('sexo', $arrSexo, $lista->sexo, "id='sexo' class='comboMedio'");
     $data['selestado'] = form_dropdown('estado', $arrEstado, $lista->estado, "id='estado' class='comboMedio'");
     $data['oculto'] = form_hidden(array("accion" => $accion, "codigo_padre" => $codigo, "codigo" => $lista->codigo));
     $this->load->view("ventas/cliente_nuevo", $data);
 }

 protected function main()
 {
     if (empty($_GET['s']) or strlen(trim($_GET['s'])) < 2) {
         header('Location: ./');
     }
     $title_recherche = htmlspecialchars($_GET['s']);
     $this->set_title(sprintf(Nw::$lang['search']['titre_recherche'], $title_recherche));
     $this->set_tpl('search/results.html');
     $this->load_lang_file('news');
     // Fil ariane
     $this->set_filAriane(array(Nw::$lang['search']['fa_recherche'] => './', $title_recherche => ''));
     $etat_news_afficher = is_logged_in() ? 0 : 3;
     // On compte le nbr de news publiées
     inc_lib('search/count_search_results');
     $nombre_news = count_search_results($_GET['s'], $etat_news_afficher);
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_news / Nw::$pref['nb_news_homepage']);
     // On vérifie bien que la page existe
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     // On recherche toutes les news en rédaction
     inc_lib('search/search_news_bytag');
     inc_lib('news/can_edit_news');
     $list_dn_news = search_news_bytag($_GET['s'], $etat_news_afficher, $page, Nw::$pref['nb_news_homepage']);
     $cours_news = 0;
     $cours_news2 = 0;
     foreach ($list_dn_news as $donnees_news) {
         $ids_all_news[] = $donnees_news['n_id'];
         Nw::$tpl->setBlock('news', array('ID' => $donnees_news['n_id'], 'COURS' => $cours_news % 2, 'COURS2' => $cours_news2 % 2, 'CAT_ID' => $donnees_news['c_id'], 'CAT_TITRE' => $donnees_news['c_nom'], 'CAT_REWRITE' => $donnees_news['c_rewrite'], 'TITRE' => $donnees_news['n_titre'], 'RESUME' => $donnees_news['n_resume'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'AUTEUR' => $donnees_news['u_pseudo'], 'AUTEUR_ID' => $donnees_news['u_id'], 'AUTEUR_ALIAS' => $donnees_news['u_alias'], 'AUTEUR_AVATAR' => $donnees_news['u_avatar'], 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'HAS_VOTED' => is_logged_in() ? $donnees_news['v_id_membre'] : 0, 'NBR_VOTES' => $donnees_news['n_nb_votes'], 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'DRT_EDIT' => is_logged_in() ? can_edit_news($donnees_news['n_id_auteur'], $donnees_news['n_etat']) : false, 'DRT_DELETE' => is_logged_in() && ($donnees_news['n_id_auteur'] == Nw::$dn_mbr['u_id'] && Nw::$droits['can_delete_mynews'] || Nw::$droits['can_delete_news']) ? true : false));
         ++$cours_news2;
     }
     // Historique des recherches
     if ($nombre_news > 0) {
         inc_lib('search/add_search_log');
         inc_lib('admin/gen_cachefile_top_search');
         add_search_log(urldecode($_GET['s']), $cours_news2);
         inc_lib('admin/gen_cachefile_top_search');
         gen_cachefile_top_search();
     }
     /**
      *   Nuage de tags
      **/
     inc_lib('news/nuage_tags');
     $tags_a_afficher = 30;
     $nuage_tags = nuage_tags($tags_a_afficher);
     foreach ($nuage_tags as $donnees_tags) {
         Nw::$tpl->setBlock('nuage', array('INT' => $donnees_tags['t_tag'], 'REWRITE' => urlencode($donnees_tags['t_tag']), 'SIZE' => $donnees_tags['size'], 'COLOR' => $donnees_tags['c_couleur']));
     }
     inc_lib('search/get_tags_search');
     Nw::$tpl->set(array('LIST_PG' => list_pg($nombreDePages, $page, 'search%s.html?s=' . $_GET['s']), 'SEARCH' => $title_recherche, 'SUGGEST' => get_tags_search($_GET['s'], 0, $etat_news_afficher, 1)));
 }

 protected function main()
 {
     // Si le paramètre ID manque
     if (empty($_GET['id'])) {
         header('Location: ./');
     }
     inc_lib('users/mbr_exists');
     if (mbr_exists($_GET['id']) == false) {
         redir(Nw::$lang['users']['mbr_dont_exist'], false, 'users.html');
     }
     inc_lib('users/get_info_mbr');
     $donnees_profile = get_info_mbr($_GET['id']);
     $this->load_lang_file('users');
     $this->load_lang_file('news');
     $this->add_wid_in_content('view_profile.' . $donnees_profile['u_id']);
     $this->set_tpl('profile/list_contribs.html');
     $this->set_title(sprintf(Nw::$lang['profile']['profile_title'], $donnees_profile['u_pseudo']));
     $this->add_css('code.css');
     $this->add_js('profil.js');
     $this->set_filAriane(array(Nw::$lang['users']['members_section'] => array('users.html'), $donnees_profile['u_pseudo'] => array('./profile/' . $donnees_profile['u_alias'] . '/'), Nw::$lang['profile']['title_news_contrib'] => array()));
     $params_contrib = array();
     $params_contrib[] = 'v_id_membre = ' . intval($_GET['id']);
     if (!is_logged_in()) {
         $params_contrib[] = 'n_etat = 3';
     }
     inc_lib('profile/count_news_contrib');
     $nombre_contrib = count_news_contrib(implode(' AND ', $params_contrib));
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_contrib / Nw::$pref['ppl_nb_contribs']);
     // On vérifie bien que la page existe
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     inc_lib('profile/get_news_contrib');
     $cours_news = 0;
     $contrib_cours = '';
     $count_section = 0;
     $list_contrib = get_news_contrib(implode(' AND ', $params_contrib), 'v_date DESC, n_date DESC', $page, Nw::$pref['ppl_nb_contribs']);
     foreach ($list_contrib as $donnees_contrib) {
         Nw::$tpl->setBlock('contrib', array('ID' => $donnees_contrib['v_id'], 'ID_NEWS' => $donnees_contrib['v_id_news'], 'MOTIF' => $donnees_contrib['v_raison'], 'NB_MOTS' => sprintf(Nw::$lang['news']['nbr_caract'], $donnees_contrib['v_nb_mots']), 'DIFF_MOTS' => $donnees_contrib['v_diff_mots'], 'IP' => long2ip($donnees_contrib['v_ip']), 'COURS' => $cours_news % 2, 'DATE' => date_sql($donnees_contrib['date'], $donnees_contrib['heures_date'], $donnees_contrib['jours_date'])));
         ++$cours_news;
         if ($contrib_cours != $donnees_contrib['v_id_news']) {
             Nw::$tpl->setBlock('contrib.news', array('ID' => $donnees_contrib['n_id'], 'TITRE' => $donnees_contrib['n_titre'], 'REWRITE' => rewrite($donnees_contrib['n_titre']), 'CAT_REWRITE' => $donnees_contrib['c_rewrite'], 'ETAT' => $donnees_contrib['n_etat'], 'ETAT_LANG' => Nw::$lang['news']['etat_news_' . $donnees_contrib['n_etat']], 'ETAT_ACT' => $donnees_contrib['n_etat'] == 1 ? 70 : 80, 'IMAGE_ID' => $donnees_contrib['i_id'], 'IMAGE_NOM' => $donnees_contrib['i_nom'], 'END' => $count_section > 0 ? '</div></div>' : ''));
             $contrib_cours = $donnees_contrib['v_id_news'];
             ++$count_section;
         }
     }
     Nw::$tpl->set(array('END_DIV' => $count_section > 0 ? '</div></div>' : '', 'NOMBRE_CONTRIB' => $nombre_contrib, 'LIST_PG' => list_pg($nombreDePages, $page, 'profile-130-' . $_GET['id'] . '%s.html')));
     inc_lib('profile/assign_required_vars_profile');
     assign_required_vars_profile($donnees_profile);
 }

 protected function main()
 {
     inc_lib('news/get_info_cat');
     $donnees_cat_news = get_info_cat($_GET['ct'], 'rewrite');
     if (count($donnees_cat_news) == 0 || empty($donnees_cat_news) || empty($_GET['ct'])) {
         header('Location: ./');
     }
     $this->set_title($donnees_cat_news['c_nom']);
     $this->set_tpl('news/cat_news.html');
     $this->add_css('code.css');
     $this->base_enabled(true);
     $this->add_wid_in_content('view_cat.' . $donnees_cat_news['c_id']);
     // On compte le nbr de news publiées
     inc_lib('news/count_news');
     $nombre_news = count_news('n_etat = 3 AND n_id_cat = ' . $donnees_cat_news['c_id']);
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_news / Nw::$pref['nb_news_homepage']);
     // On vérifie bien que la page existe
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     // On recherche toutes les news en rédaction
     inc_lib('news/get_list_news');
     inc_lib('news/can_edit_news');
     $list_dn_news = get_list_news('n_etat = 3 AND n_id_cat = ' . $donnees_cat_news['c_id'], 'n_date DESC', $page, Nw::$pref['nb_news_homepage']);
     $cours_news = 0;
     $cours_news2 = 0;
     foreach ($list_dn_news as $donnees_news) {
         Nw::$tpl->setBlock('news', array('ID' => $donnees_news['n_id'], 'COURS' => $cours_news % 2, 'COURS2' => $cours_news2 % 2, 'CAT_ID' => $donnees_news['c_id'], 'CAT_TITRE' => $donnees_news['c_nom'], 'CAT_REWRITE' => $donnees_news['c_rewrite'], 'IMAGE_ID' => $donnees_news['i_id'], 'IMAGE_NOM' => $donnees_news['i_nom'], 'TITRE' => $donnees_news['n_titre'], 'RESUME' => $donnees_news['n_resume'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'AUTEUR' => $donnees_news['u_pseudo'], 'AUTEUR_ID' => $donnees_news['u_id'], 'AUTEUR_ALIAS' => $donnees_news['u_alias'], 'AUTEUR_AVATAR' => $donnees_news['u_avatar'], 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'HAS_VOTED' => is_logged_in() ? $donnees_news['v_id_membre'] : 0, 'NBR_VOTES' => $donnees_news['n_nb_votes'], 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'DRT_EDIT' => is_logged_in() ? can_edit_news($donnees_news['n_id_auteur'], $donnees_news['n_etat']) : false, 'DRT_DELETE' => is_logged_in() && ($donnees_news['n_id_auteur'] == Nw::$dn_mbr['u_id'] && Nw::$droits['can_delete_mynews'] || Nw::$droits['can_delete_news']) ? true : false));
         if ($donnees_news['i_id'] != 0) {
             ++$cours_news;
         }
         ++$cours_news2;
     }
     /**
      *   Nuage de tags
      **/
     inc_lib('news/nuage_tags');
     $tags_a_afficher = 30;
     $list_tags_metas = array();
     $nuage_tags = nuage_tags($tags_a_afficher, $donnees_cat_news['c_id']);
     foreach ($nuage_tags as $donnees_tags) {
         $list_tags_metas[] = $donnees_tags['t_tag'];
         Nw::$tpl->setBlock('nuage', array('INT' => $donnees_tags['t_tag'], 'REWRITE' => urlencode($donnees_tags['t_tag']), 'SIZE' => $donnees_tags['size'], 'COLOR' => $donnees_tags['c_couleur']));
     }
     $this->set_filAriane(array(Nw::$lang['news']['news_section'] => array('news-70.html'), $donnees_cat_news['c_nom'] => array($donnees_cat_news['c_rewrite'] . '/')));
     $this->metas(array('desc' => $donnees_cat_news['c_desc'], 'tags' => implode(', ', $list_tags_metas)));
     Nw::$tpl->set(array('LIST_PG' => list_pg($nombreDePages, $page, $donnees_cat_news['c_rewrite'] . '/%s', ''), 'TITRE' => $donnees_cat_news['c_nom']));
 }

 protected function main()
 {
     // Si le paramètre ID manque
     if (empty($_GET['id'])) {
         header('Location: ./');
     }
     inc_lib('users/mbr_exists');
     if (mbr_exists($_GET['id']) == false) {
         redir(Nw::$lang['users']['mbr_dont_exist'], false, 'users.html');
     }
     inc_lib('users/get_info_mbr');
     $donnees_profile = get_info_mbr($_GET['id']);
     $this->load_lang_file('users');
     $this->load_lang_file('news');
     $this->add_wid_in_content('view_profile.' . $donnees_profile['u_id']);
     $this->set_tpl('profile/list_news.html');
     $this->set_title(sprintf(Nw::$lang['profile']['profile_title'], $donnees_profile['u_pseudo']));
     $this->add_css('code.css');
     $this->add_js('profil.js');
     $this->base_enabled(true);
     $this->set_filAriane(array(Nw::$lang['users']['members_section'] => array('users.html'), $donnees_profile['u_pseudo'] => array('./profile/' . $donnees_profile['u_alias'] . '/'), Nw::$lang['profile']['title_news_author'] => array()));
     $params_news = array();
     $params_news[] = 'n_id_auteur = ' . intval($donnees_profile['u_id']);
     if (!is_logged_in()) {
         $params_news[] = 'n_etat = 3';
     }
     inc_lib('profile/count_news_author');
     $nombre_news = count_news_author(implode(' AND ', $params_news));
     // Pagination
     $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
     $nombreDePages = ceil($nombre_news / Nw::$pref['ppl_nb_news']);
     // On vérifie bien que la page existe
     if ($nombreDePages > 0 && $page > $nombreDePages) {
         redir(Nw::$lang['common']['pg_not_exist'], false, './');
     }
     inc_lib('profile/get_news_author');
     $cours_news = 0;
     $list_news = get_news_author(implode(' AND ', $params_news), 'n_date DESC', $page, Nw::$pref['ppl_nb_news']);
     foreach ($list_news as $donnees_news) {
         ++$cours_news;
         Nw::$tpl->setBlock('news', array('ID' => $donnees_news['n_id'], 'TITRE' => $donnees_news['n_titre'], 'CAT_REWRITE' => $donnees_news['c_rewrite'], 'REWRITE' => rewrite($donnees_news['n_titre']), 'RESUME' => $donnees_news['n_resume'], 'ETAT' => $donnees_news['n_etat'], 'ETAT_LANG' => Nw::$lang['news']['etat_news_' . $donnees_news['n_etat']], 'ETAT_ACT' => $donnees_news['n_etat'] == 1 ? 70 : 80, 'NBR_VOTES' => $donnees_news['n_nb_votes'], 'HAS_VOTED' => is_logged_in() ? $donnees_news['v_id_membre'] : 0, 'NBR_COMS' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'DATE' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'IMAGE_ID' => $donnees_news['i_id'], 'IMAGE_NOM' => $donnees_news['i_nom'], 'COURS' => $cours_news % 2));
     }
     Nw::$tpl->set(array('NOMBRE_NEWS' => $nombre_news, 'LIST_PG' => list_pg($nombreDePages, $page, 'profile/%s.html')));
     inc_lib('profile/assign_required_vars_profile');
     assign_required_vars_profile($donnees_profile);
 }

 protected function main()
 {
     // Si le paramètre ID manque
     if (empty($_GET['id']) || !is_numeric($_GET['id'])) {
         header('Location: news-70.html');
     }
     inc_lib('news/news_exists');
     if (news_exists($_GET['id']) == false) {
         redir(Nw::$lang['news']['news_not_exist'], false, 'news-70.html');
     }
     inc_lib('news/get_info_news');
     $donnees_news = get_info_news($_GET['id'], $id_version_load);
     $this->set_tpl('mobile/news/view_coms.html');
     $this->load_lang_file('news');
     /**
      *   Liste des commentaires
      **/
     if ($donnees_news['n_nbr_coms'] > 0) {
         // Pagination
         $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
         $nombreDePages = ceil($donnees_news['n_nbr_coms'] / Nw::$pref['nb_cmts_page']);
         // On vérifie bien que la page existe
         if ($nombreDePages > 0 && $page > $nombreDePages) {
             redir(Nw::$lang['common']['pg_not_exist'], false, $donnees_news['c_rewrite'] . '/' . rewrite($donnees_news['n_titre']) . '-' . $_GET['id'] . '/');
         }
         // L'utilisateur demande un commentaire particulier, on le redirige sur la bonne page
         if (!empty($_GET['id2']) && is_numeric($_GET['id2'])) {
             inc_lib('news/count_cmt_before_idc');
             $nbr_cmts_before = count_cmt_before_idc($_GET['id'], $_GET['id2']);
             $page = ceil($nbr_cmts_before / Nw::$pref['nb_cmts_page']);
         }
         inc_lib('news/get_list_cmt_news');
         $list_cmts = get_list_cmt_news($_GET['id'], 'c_date ASC', $page, Nw::$pref['nb_cmts_page']);
         $com_cours = 0;
         // Affichage de tous les commentaires de la page
         foreach ($list_cmts as $donnees_cmts) {
             ++$com_cours;
             $date_cmt = date_sql($donnees_cmts['date'], $donnees_cmts['heures_date'], $donnees_cmts['jours_date']);
             Nw::$tpl->setBlock('cmt', array('ID' => $donnees_cmts['c_id'], 'NUM' => ($page - 1) * Nw::$pref['nb_cmts_page'] + $com_cours, 'DATE' => $date_cmt, 'AVATAR' => $donnees_cmts['u_avatar'], 'LANG_AVATAR' => sprintf(Nw::$lang['news']['lang_avatar'], $donnees_cmts['u_pseudo']), 'AUTEUR' => $donnees_cmts['u_pseudo'], 'AUTEUR_ID' => $donnees_cmts['u_id'], 'AUTEUR_ALIAS' => $donnees_cmts['u_alias'], 'TEXTE' => $donnees_cmts['c_texte']));
         }
     }
     Nw::$tpl->set(array('ID' => $_GET['id'], 'ETAT' => $donnees_news['n_etat'], 'TITRE' => $donnees_news['n_titre'], 'TITRE_REWRITE' => rewrite($donnees_news['n_titre']), 'LIST_PG' => $donnees_news['n_nbr_coms'] > 0 ? list_pg($nombreDePages, $page, 'news-10-' . $_GET['id'] . '%s.html#c') : ''));
     Nw::$tpl->set('INC_HEAD', empty($_SERVER['HTTP_AJAX']));
 }

function get_list_news_related($ids_news = array(), $limit = 3, $etat = 3)
{
    $news_related = array();
    $count_nb_related_bynews = array();
    $ids_related_passed = array();
    $add_champs_sql = '';
    $add_jointure_sql = '';
    if (is_array($ids_news)) {
        $rqt_sql = ' IN (' . implode(', ', $ids_news) . ')';
    } else {
        $rqt_sql = ' = ' . intval($ids_news);
    }
    // Si l'utilisateur est connecté
    if (is_logged_in()) {
        $add_champs_sql = ', v_id_membre';
        $add_jointure_sql = ' LEFT JOIN ' . Nw::$prefix_table . 'news_vote
            ON (n_id = v_id_news AND v_id_membre = ' . intval(Nw::$dn_mbr['u_id']) . ')';
    }
    $rqt_list_news = Nw::$DB->query('SELECT t1.t_id_news AS old_news, t1.t_tag,
        n_id, n_titre, n_nb_votes, n_nbr_coms, i_id, i_nom, c_id, c_nom, c_rewrite,
        ' . decalageh('n_date', 'date_news') . $add_champs_sql . '
        FROM ' . Nw::$prefix_table . 'tags t1
            LEFT JOIN ' . Nw::$prefix_table . 'tags t2 ON (t2.t_tag = t1.t_tag)
            LEFT JOIN ' . Nw::$prefix_table . 'news ON t2.t_id_news = n_id
            LEFT JOIN ' . Nw::$prefix_table . 'categories ON n_id_cat = c_id
            LEFT JOIN ' . Nw::$prefix_table . 'news_images ON i_id = n_id_image' . $add_jointure_sql . '
        WHERE n_etat = ' . $etat . ' AND t1.t_id_news' . $rqt_sql . ' AND t1.t_position = 1
        ORDER BY t1.t_id_news, n_date DESC') or Nw::$DB->trigger(__LINE__, __FILE__);
    while ($donnees_news = $rqt_list_news->fetch_assoc()) {
        if ($donnees_news['old_news'] != $donnees_news['n_id']) {
            $count_nb_related_bynews[$donnees_news['old_news']] = isset($count_nb_related_bynews[$donnees_news['old_news']]) ? $count_nb_related_bynews[$donnees_news['old_news']] + 1 : 1;
            if ($count_nb_related_bynews[$donnees_news['old_news']] <= $limit && !in_array($donnees_news['n_id'], $ids_related_passed)) {
                $vars_imp = array('id' => $donnees_news['n_id'], 'titre' => $donnees_news['n_titre'], 'cat_rewrite' => $donnees_news['c_rewrite'], 'rewrite' => rewrite($donnees_news['n_titre']), 'date' => date_sql($donnees_news['date_news'], $donnees_news['heures_date_news'], $donnees_news['jours_date_news']), 'nbr_votes' => $donnees_news['n_nb_votes'], 'nbr_coms' => sprintf(Nw::$lang['news']['nbr_comments_news'], $donnees_news['n_nbr_coms'], $donnees_news['n_nbr_coms'] > 1 ? Nw::$lang['news']['add_s_comments'] : ''), 'has_voted' => is_logged_in() ? $donnees_news['v_id_membre'] : 0, 'image_id' => $donnees_news['i_id'], 'image_nom' => $donnees_news['i_nom']);
                if (is_array($ids_news)) {
                    $news_related[$donnees_news['old_news']][] = $vars_imp;
                } else {
                    $news_related[] = $vars_imp;
                }
                $ids_related_passed[] = $donnees_news['n_id'];
            }
        }
    }
    return $news_related;
}