<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: $

$cs_lang = cs_translate('members');
$data = array();

$cells = 'mm.members_task AS members_task, mm.members_since AS members_since, ';
$cells .= 'usr.users_picture AS users_picture, usr.users_country AS users_country, ';
$cells .= 'usr.users_nick AS users_nick, usr.users_name AS users_name, usr.users_surname AS users_surname';
$tables = 'members mm INNER JOIN {pre}_users usr ON mm.users_id = usr.users_id';

$data['members'] = cs_sql_select(__FILE__,$tables,$cells,0,'RAND()',0,1);

$data['members']['picture'] = empty($data['members']['users_picture']) ? $cs_lang['nopic'] :
cs_html_img('uploads/users/' . $data['members']['users_picture']);
$data['members']['since'] = empty($data['members']['members_since']) ? '-' :
cs_date('date',$data['members']['members_since']);

$data['members']['flag'] = cs_html_img('symbols/countries/' . $data['members']['users_country'] . '.png',11,16);

if(empty($data['members']['users_name']) && empty($data['members']['users_surname'])) {
$data['members']['users_name'] = $cs_lang['noname'];
$data['members']['users_surname'] = '';
}

echo cs_subtemplate(__FILE__,$data,'members','navrand');

?>

|

|

|