Forum

$id_get = !empty($_GET['id']) ? numeric($_GET['id']) : '';
if (empty($id_get))
{
    $login = !empty($_GET['login']) ? securit($_GET['login']) : '';
    if (!empty($login)
    {
         $id_get = (int)$sql->query("SELECT id FROM ".PREFIX."member WHERE login = '" . $login . "'", __LINE__, __FILE__);
    }
}

<?php
/*##################################################
 *                                member.php
 *                            -------------------
 *   begin                : August 04 2005
 *   copyright          : (C) 2005 Viarre Régis
 *   email                : crowkait@phpboost.com
 *
 *   
 ###################################################
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
###################################################*/
 
include_once('../includes/begin.php'); 
define('TITLE', $LANG['member_area']);
 
$edit_get = !empty($_GET['edit']) ? trim($_GET['edit']) : '';
$id_get = !empty($_GET['id']) ? numeric($_GET['id']) : '';
if (empty($id_get))
{
    $login = !empty($_GET['login']) ? securit($_GET['login']) : '';
    if (!empty($login)
    {
         $id_get = (int)$sql->query("SELECT id FROM ".PREFIX."member WHERE login = '" . $login . "'", __LINE__, __FILE__);
    }
}
$title_mbr = !empty($id_get) ? (!empty($edit_get) ? $LANG['profil_edit'] : $LANG['index']) : $LANG['member_s'];
$speed_bar = array(
$LANG['member_area'] => transid('member.php?id=' . $session->data['user_id'] . '&view=1', 'member-' . $session->data['user_id'] . '.php?view=1'), $title_mbr => ''
);
include_once('../includes/header.php'); 
 
$view_get = !empty($_GET['view']) ? trim($_GET['view']) : '';
$view_msg = !empty($_GET['msg']) ? numeric($_GET['msg']) : '';
$show_group = !empty($_GET['g']) ? numeric($_GET['g']) : '';
$post_group = !empty($_POST['show_group']) ? numeric($_POST['show_group']) : '';
$get_error = !empty($_GET['error']) ? trim($_GET['error']) : '';
$get_l_error = !empty($_GET['erroru']) ? trim($_GET['erroru']) : '';
 
if( !empty($id_get) ) //Espace membre
{
$template->set_filenames(array(
'member' => '../templates/' . $CONFIG['theme'] . '/member.tpl'
));
if( !empty($edit_get) && $session->data['user_id'] === $id_get && ($session->check_auth($session->data, 0)) ) //Edition du profil
{
//Update profil
$row = $sql->query_array('member', 'user_lang', 'user_theme', 'user_mail', 'user_local', 'user_web', 'user_occupation', 'user_hobbies', 'user_avatar', 'user_show_mail', 'user_sex', 'user_born', 'user_sign', 'user_desc', 'user_msn', 'user_yahoo', "WHERE user_id = '" . $session->data['user_id'] . "'", __LINE__, __FILE__);
 
$user_born = '';
$array_user_born = explode('-', $row['user_born']);
$date_birth = explode('/', $LANG['date_birth_parse']);
for($i = 0; $i < 3; $i++)
{
if( $date_birth[$i] == 'DD' )
{
$user_born .= $array_user_born[2 - $i];
$born_day = $array_user_born[2 - $i];
}
elseif( $date_birth[$i] == 'MM' )
{
$user_born .= $array_user_born[2 - $i];
$born_month = $array_user_born[2 - $i];
}
elseif( $date_birth[$i] == 'YYYY' )
{
$user_born .= $array_user_born[2 - $i];
$born_year = $array_user_born[2 - $i];
}
$user_born .= ($i != 2) ? '/' : '';
}
 
$user_sex = '';
if( !empty($row['user_sex']) )
$user_sex = ($row['user_sex']

$id_get = !empty($_GET['id']) ? numeric($_GET['id']) : '';
if (empty($id_get))
{
    $login = !empty($_GET['login']) ? securit($_GET['login']) : '';
    if (!empty($login))
    {
         $id_get = (int)$sql->query("SELECT id FROM ".PREFIX."member WHERE login = '" . $login . "'", __LINE__, __FILE__);
    }
}

$mode = ($get_mode == 'asc' || $get_mode == 'desc') ? strtoupper(trim($_GET['mode'])) : '';

$mode = ($get_mode == 'asc' || $get_mode == 'desc') ? strtoupper(trim($_GET['mode'])) : 'DESC';