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

$cs_lang = cs_translate('squads');

$data = array();
$op_squads = cs_sql_option(__FILE__,'squads');
$op_members = cs_sql_option(__FILE__,'members');
include_once 'lang/' . $account['users_lang'] . '/countries.php';

$squads_id = $_GET['id'];
settype($squads_id,'integer');

$data['lang']['mod_name'] = $cs_lang[$op_squads['label'].'s'];

$select = 'sqd.games_id AS games_id, sqd.squads_name AS squads_name, cln.clans_name AS ';
$select .= 'clans_name, cln.clans_tag AS clans_tag, cln.clans_tagpos AS clans_tagpos, ';
$select .= 'cln.clans_id AS clans_id, sqd.squads_picture AS squads_picture, sqd.squads_text AS squads_text ';
$from = 'squads sqd INNER JOIN {pre}_clans cln ON sqd.clans_id = cln.clans_id ';
$where = "sqd.squads_id = '" . $squads_id . "'";
$data['squad'] = cs_sql_select(__FILE__,$from,$select,$where);

$data['lang']['members'] = $cs_lang[$op_members['label']];

$clans_name = cs_secure($data['squad']['clans_name']);
$clan_link = cs_link($clans_name,'clans','view','id=' . $data['squad']['clans_id']);
$data['lang']['part_of'] = sprintf($cs_lang['body_list'], $clan_link);

$icon = 'uploads/games/' . $data['squad']['games_id'] . '.gif';
$data['game']['icon'] = (empty($data['squad']['games_id']) OR !file_exists($icon)) ? '' : cs_html_img($icon);

if(!empty($data['squad']['games_id'])) {
$where = "games_id = '" . $data['squad']['games_id'] . "'";
$cs_game = cs_sql_select(__FILE__,'games','games_name, games_id',$where);
$id_game = 'id=' . $cs_game['games_id'];
$data['squad']['game'] = ' ' . cs_link($cs_game['games_name'],'games','view',$id_game);
}
else {
$data['squad']['game'] = ' - ';
}

$data['squad']['squads_name'] = cs_secure($data['squad']['squads_name']);

$data['squad']['squads_text'] = !empty($data['squad']['squads_text']) ? cs_secure($data['squad']['squads_text'],1,1) : $cs_lang['no_desc'];

if(empty($data['squad']['squads_picture'])) {
$data['squad']['squads_pic'] = $cs_lang['nopic'];
} else {
$place = 'uploads/squads/' . $data['squad']['squads_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
$data['squad']['squads_pic'] = cs_html_img($place,$size[1],$size[0]);
}


//members
$select = 'mem.members_admin AS members_admin, mem.members_task AS members_task, mem.members_since AS members_since, ';
$select .= 'mem.users_id AS users_id, usr.users_nick AS users_nick, usr.users_country AS users_country, ';
$select .= 'usr.users_name AS users_name, usr.users_surname AS users_surname, usr.users_sex AS users_sex, ';
$select .= 'usr.users_picture AS users_picture, usr.users_active AS users_active, usr.users_delete AS users_delete, usr.users_hidden AS users_hidden, ';
$select .= 'usr.users_laston AS users_laston, usr.users_invisible AS users_invisible';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id ';
$where = "mem.squads_id='" . $squads_id . "'";
$order = 'mem.members_order ASC, usr.users_nick ASC';
$data['members'] = cs_sql_select(__FILE__,$from,$select,$where,$order,0,0,0);
$data['squad']['members'] = count($data['members']);


for($run = 0; $run < $data['squad']['members']; $run++) {
$data['members'][$run]['countrypath'] = 'symbols/countries/' . $data['members'][$run]['users_country'] . '.png';
$data['members'][$run]['country'] = $cs_country[$data['members'][$run]['users_country']];
if(empty($cs_user['users_picture'])) {
$data['users']['picture'] = $cs_lang['nopic'];
} else {
$place = 'uploads/users/' . $cs_user['users_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
$data['users']['picture'] = cs_html_img($place,$size[1],$size[0]);
}
$data['members'][$run]['members_since'] = empty($data['members'][$run]['members_since']) ?
'-' : cs_date('date',$data['members'][$run]['members_since']);
$data['members'][$run]['page'] = cs_userstatus($data['members'][$run]['users_laston'],$data[' members'][$run]['users_invisible']);


$users_nick = empty($data['members'][$run]['members_admin']) ? cs_secure($data['members'][$run]['users_nick']) :
cs_html_big(1) . cs_secure($data['members'][$run]['users_nick']) . cs_html_big(0);
$nick = $data['squad']['clans_tagpos'] == 1 ? $data['squad']['clans_tag'] . ' ' . $users_nick :
$users_nick . ' ' . $data['squad']['clans_tag'];

$data['members'][$run]['users_url'] = cs_user($data['members'][$run]['users_id'], $data['members'][$run]['users_nick'], $data['members'][$run]['users_active'], $data['members'][$run]['users_delete']);
if(empty($cs_user['users_picture'])) {
$data['users']['picture'] = $cs_lang['nopic'];
} else {
$place = 'uploads/users/' . $cs_user['users_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
$data['users']['picture'] = cs_html_img($place,$size[1],$size[0]);
}
}


//ranks
$cells = 'ranks_id, ranks_name, ranks_url, ranks_img, ranks_code';
$ranks = cs_sql_select(__FILE__,'ranks',$cells, "squads_id = '" . $squads_id . "'", 'ranks_name', 0, 5);
$ranks_loop = count($ranks);
$data['if']['rank'] = empty($ranks_loop) ? FALSE : TRUE;

for($run=0; $run<$ranks_loop; $run++) {

$ranks[$run]['name'] = cs_secure($ranks[$run]['ranks_name']);

$ranks[$run]['picture'] = '';
if(!empty($ranks[$run]['ranks_url']) AND ($ranks[$run]['ranks_img'] != 'http://')) {
$picture = cs_html_img($ranks[$run]['ranks_img']);
$ranks[$run]['picture'] = cs_html_link('http://' . $ranks[$run]['ranks_url'],$picture);
}
else {
$ranks[$run]['picture'] = $ranks[$run]['ranks_code'];
}
}
$data['ranks'] = !empty($ranks) ? $ranks : array(0 => '');


//awards
$from = 'awards aws INNER JOIN {pre}_games gms ON aws.games_id = gms.games_id';
$select = 'aws.awards_id AS awards_id, aws.awards_time AS awards_time, aws.awards_event AS awards_event, aws.awards_event_url AS awards_event_url, aws.awards_rank AS awards_rank';
$awards = cs_sql_select(__FILE__,$from,$select,"squads_id = '" . $squads_id . "'",'awards_time DESC',0,5);
$awards_loop = count($awards);
$data['if']['award'] = empty($awards_loop) ? FALSE : TRUE;

$medals = array(1 => 'gold', 2 => 'silber', 3 => 'bronze');

for($run=0; $run < $awards_loop; $run++) {

$awards[$run]['awards_time'] = cs_date('date',$awards[$run]['awards_time']);
$awards[$run]['awards_event'] = cs_secure($awards[$run]['awards_event']);
$awards[$run]['awards_place'] = $awards[$run]['awards_rank'] < 4 ? cs_html_img("symbols/awards/pokal_" . $medals[$awards[$run]['awards_rank']] . ".png") : cs_secure($awards[$run]['awards_rank']);

}
$data['awards'] = !empty($awards) ? $awards : array(0 => '');


// wars
$select = 'war.games_id AS games_id, war.wars_date AS wars_date, war.clans_id AS clans_id, cln.clans_short AS clans_short, cat.categories_name AS categories_name, war.categories_id AS categories_id, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id';
$from = 'wars war INNER JOIN {pre}_categories cat ON war.categories_id = cat.categories_id ';
$from .= 'INNER JOIN {pre}_clans cln ON war.clans_id = cln.clans_id ';
$wars = cs_sql_select(__FILE__,$from,$select,"squads_id = '" . $squads_id . "'",'wars_date DESC',0,5);
$count_wars = count($wars);
$data['if']['war'] = empty($count_wars) ? FALSE : TRUE;

for ($run = 0; $run < $count_wars; $run++) {
$wars[$run]['gameicon'] = cs_html_img('uploads/games/' . $wars[$run]['games_id'] . '.gif');
$wars[$run]['date'] = cs_date('unix',$wars[$run]['wars_date']);
$wars[$run]['enemyurl'] = cs_url('clans','view','id=' . $wars[$run]['clans_id']);
$wars[$run]['enemy'] = cs_secure($wars[$run]['clans_short']);
$wars[$run]['caturl'] = cs_url('categories','view','id=' . $wars[$run]['categories_id']);
$wars[$run]['category'] = cs_secure($wars[$run]['categories_name']);
$wars[$run]['url'] = cs_url('wars','view','id=' . $wars[$run]['wars_id']);
$wars[$run]['result'] = $wars[$run]['wars_score1'] . ' : ' . $wars[$run]['wars_score2'];
$result = $wars[$run]['wars_score1'] - $wars[$run]['wars_score2'];
$icon = $result >= 1 ? 'green' : 'red';
$icon = !empty($result) ? $icon : 'grey';
$wars[$run]['resulticon'] = cs_html_img('symbols/clansphere/' . $icon . '.gif');

}
$data['wars'] = !empty($wars) ? $wars : array(0 => '');


echo cs_subtemplate(__FILE__,$data,'squads','view');

<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
<td class="headb">Forum - Liste</td>
</tr>
<tr>
<td class="leftb">{lang:part_of}</td>
</tr>
</table>
<br />

<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
<td class="leftb">{squad:squads_pic}</td>
<td class="leftb">{squad:squads_text}</td>
</tr>
</table>
<br />

<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
<td class="headb" colspan="5">
{lang:members}
</td>
</tr>
<tr>
<td class="leftc" style="width:40px">Userpicture</td>
<td class="leftc" style="margin-left:25px;">Nick</td>
<td class="leftc">{lang:task}</td>
<td class="leftc" style="width:80px">{lang:since}</td>
<td class="leftc" style="width:40px">Seite</td>
</tr>
{loop:members}
<tr>
<td class="leftb">{users:picture}</td>
<td class="leftb" style="margin-left:25px;">{members:users_url}</td>
<td class="leftb">{members:members_task}</td>
<td class="leftb">{members:members_since}</td>
<td class="leftb">{members:page}</td>
</tr>
{stop:members}
</table>
<br />
...

|

Bei Problemen mit Code von mir bitte eine Private Nachricht an mich

|

|