$cells = 'pl.users_id AS users_id, usr.users_nick AS users_nick, usr.users_picture AS users_picture';
$tables = 'players pl INNER JOIN {pre}_users usr ON pl.users_id = usr.users_id';
$cond = 'pl.wars_id = \''.$wars_id.'\' AND pl.players_played = \'1\'';
$players = cs_sql_select(__FILE__,$tables,$cells,$cond,'usr.users_nick',0,0);

if (!empty($players)) {
for ($run = 0; $run < count($players); $run++) {
$wars['players'][$run]['url'] = cs_url('users','view','id='.$players[$run]['u sers_id']);
$wars['players'][$run]['nick'] = cs_secure($players[$run]['users_nick']);
$wars['players'][$run]['picture'] = cs_html_img('uploads/users/' .$players[$run]['users_picture'],'91','70');
}
} else {
$wars['players']= '';
}