1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
| 1. / 2. / ...
<?php
// ClanSphere 2008 - www.clansphere.net
// $Id: pictured.php 185 2006-08-09 21:26:11Z hajo $
$cs_lang = cs_translate('members');
$op_members = cs_sql_option(__FILE__,'members');
$op_squads = cs_sql_option(__FILE__,'squads');
$tables = 'squads sq INNER JOIN {pre}_clans cln ON sq.clans_id = cln.clans_id';
$cells = 'sq.squads_id AS squads_id, sq.games_id AS games_id, sq.squads_name AS squads_name, ';
$cells .= 'sq.clans_id AS clans_id, cln.clans_tagpos AS clans_tagpos, ';
$cells .= 'cln.clans_tag AS clans_tag, sq.squads_picture AS squads_picture';
$cs_squads = cs_sql_select(__FILE__,$tables,$cells,'squads_own = \'1\'','squads_order, squads_name',0,0);
$squads_loop = count($cs_squads);
echo cs_html_table(1,'forum',1);
echo cs_html_roco(1,'headb',0,2);
echo $cs_lang['mod'] . ' - ' . $cs_lang['head_pictured'];
echo cs_html_roco(0);
echo cs_html_roco(1,'leftb');
echo sprintf($cs_lang['body_pictured'], $squads_loop);
echo cs_html_roco(2,'rightb');
echo cs_link($cs_lang['list'],'members','list');
echo cs_html_roco(0);
echo cs_html_table(0);
echo cs_html_br(1);
for($sq_run=0; $sq_run<$squads_loop; $sq_run++) {
$select = 'mem.members_admin AS members_admin, mem.members_task AS members_task, ';
$select .= 'mem.members_since AS members_since, mem.users_id AS users_id, usr.users_nick AS users_nick, ';
$select .= 'usr.users_name AS users_name, usr.users_surname AS users_surname, usr.users_sex AS users_sex, ';
$select .= 'usr.users_age AS users_age, usr.users_postalcode AS users_postalcode, usr.users_place AS users_place, ';
$select .= 'usr.users_country AS users_country, usr.users_picture AS users_picture, usr.users_active AS users_active, usr.users_hidden AS users_hidden';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id ';
$where = "mem.squads_id = '" . $cs_squads[$sq_run]['squads_id'] . "'";
$order = 'mem.members_order ASC, usr.users_nick ASC';
$cs_members = cs_sql_select(__FILE__,$from,$select,$where,$order,0,0);
$members_loop = count($cs_members);
echo cs_html_table(1,'forum',1);
echo cs_html_roco(1,'headb',0,5);
echo cs_html_div(1,'float:left');
echo cs_html_img('uploads/squads/' . $cs_squads[$sq_run]['squads_picture']);
$tr = 1;
for($run=0; $run<$members_loop; $run++) {
$hidden = explode(',',$cs_members[$run]['users_hidden']);
$allow = $cs_members[$run]['users_id'] == $account['users_id'] OR $account['access_users'] > 4 ? 1 : 0;
echo cs_html_roco($tr++,'centerb',0,0,'25%');
echo cs_html_br(1);
if(empty($cs_members[$run]['users_picture'])) {
$place_np = 'uploads/users/nopic.jpg';
echo cs_html_img($place_np);
}
else {
$place = 'uploads/users/' . $cs_members[$run]['users_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
echo cs_html_img($place,$size[1],$size[0]);
}
echo cs_html_roco($tr++,'leftc',0,0,'25%');
echo cs_html_hr('100%');
$url = 'symbols/countries/' . $cs_members[$run]['users_country'] . '.png';
echo cs_html_img($url,11,16) . ' ';
if($cs_squads[$sq_run]['clans_tagpos'] == 1) {
echo $cs_squads[$sq_run]['clans_tag'] . ' ';
}
$users_nick = $cs_members[$run]['users_nick'];
if(!empty($cs_members[$run]['members_admin'])) {
$users_nick = cs_html_big(1) . $users_nick . cs_html_big(0);
}
echo cs_user($cs_members[$run]['users_id'],$users_nick, $cs_members[$run]['users_active']);
if($cs_squads[$sq_run]['clans_tagpos'] == 2) {
echo ' ' . $cs_squads[$sq_run]['clans_tag'];
}
echo cs_html_br(2);
$users_name = !in_array('users_name',$hidden) || !empty($allow) ? $cs_members[$run]['users_name'] : '';
$users_surname = !in_array('users_surname',$hidden) || !empty($allow) ? $cs_members[$run]['users_surname'] : '';
echo empty($users_name) && empty($users_surname) ? ' - ' : $users_name . ' ' . $users_surname;
echo cs_html_br(2);
echo $cs_lang['task'] . ': ' . cs_secure($cs_members[$run]['members_task']);
echo cs_html_br(2);
$since = $cs_members[$run]['members_since'];
empty($since) ? $since2 = '-' : $since2 = cs_date('date',$since);
echo $cs_lang['since'] . ': ' . $since2;
echo cs_html_hr('100%');
if($tr == 5) {
$tr = 1;
echo cs_html_roco(0);
}
}
if($tr != 1) {
echo cs_html_roco(3,'centerb');
echo cs_html_roco(4,'leftc');
echo cs_html_roco(0);
}
echo cs_html_roco(1,'leftc',0,4);
echo cs_html_div(1,'float:right');
echo $members_loop . ' ' . $cs_lang['members'];
echo cs_html_div(0);
echo cs_html_roco(0);
echo cs_html_table(0);
echo cs_html_br(1);
}
?> |