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.
115.
116.
117.
| 1. / 2. / ...
<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: list.php 101 2006-07-12 09:36:29Z hajo $
$cs_lang = cs_translate('gbook');
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$id = empty($_REQUEST['id']) ? 0 : $_REQUEST['id'];
settype($id,'integer');
$gbook_count = cs_sql_count(__FILE__,'gbook',"gbook_users_id = '" . $id . "'");
$data['head']['mod'] = $cs_lang['mod_name'];
$data['head']['action'] = $cs_lang['head_list'];
$data['head']['gbook_entry'] = cs_link($cs_lang['submit'],'gbook','entry','id=' . $id);
$data['lang']['all'] = $cs_lang['total'] . ': ';
$data['head']['gbook_count'] = $gbook_count;
$data['head']['pages'] = cs_pages('gbook','list',$gbook_count,$start);
$from = 'gbook gbk LEFT JOIN {pre}_users usr ON gbk.users_id = usr.users_id';
$select = 'gbk.gbook_id AS gbook_id, gbk.users_id AS users_id, gbk.gbook_time AS gbook_time, gbk.gbook_nick AS gbook_nick, ';
$select .= 'gbk.gbook_email AS gbook_email, gbk.gbook_icq AS gbook_icq, gbk.gbook_msn AS gbook_msn, gbk.gbook_skype AS gbook_skype, ';
$select .= 'gbk.gbook_url AS gbook_url, gbk.gbook_town AS gbook_town, gbk.gbook_text AS gbook_text, gbk.gbook_ip AS gbook_ip, ';
$select .= 'usr.users_nick AS users_nick, usr.users_place AS users_place, usr.users_icq AS users_icq, usr.users_msn AS users_msn, ';
$select .= 'usr.users_skype AS users_skype, usr.users_email AS users_email, usr.users_url AS users_url, usr.users_hidden AS users_hidden';
$where = "gbook_users_id = '" . $id . "'";
$order = 'gbk.gbook_id DESC';
$cs_gbook = cs_sql_select(__FILE__,$from,$select,$where,$order,$start,$account['users_limit']);
$gbook_loop = count($cs_gbook);
$c = 0;
for($run=0; $run<$gbook_loop; $run++)
{
$entry_count = $gbook_count - $start - $c;
$c++;
$gbook[$run]['entry_count'] = $entry_count;
if($cs_gbook[$run]['users_id'] == 0) {
$gbook[$run]['users_nick'] = cs_secure($cs_gbook[$run]['gbook_nick']);
$gbook[$run]['town'] = '';
$gbook[$run]['icon_town'] = '';
if (!empty($cs_gbook[$run]['gbook_town'])) {
$gbook[$run]['icon_town'] = cs_icon('gohome');
$gbook[$run]['town'] = cs_secure($cs_gbook[$run]['gbook_town']);
}
$mail = cs_secure($cs_gbook[$run]['gbook_email']);
$gbook[$run]['icon_mail'] = empty($mail) ? '' : cs_html_link("mailto:$mail",cs_icon('mail_generic'));
$icq = cs_secure($cs_gbook[$run]['gbook_icq']);
$url = 'http://wwp.icq.com/' . $icq;
$icqstart = 'http://web.icq.com/whitepages/online?icq=' . $icq . '&img=22';
$gbook[$run]['icon_icq'] = empty($icq) ? '' : cs_html_link($url,cs_html_img($icq_start));
$msn = cs_secure($cs_gbook[$run]['gbook_msn']);
$gbook[$run]['icon_msn'] = empty($msn) ? '' : cs_html_link("http://members.msn.com/$msn",cs_icon('msn_protocol'));
$skype = cs_secure($cs_gbook[$run]['gbook_skype']);
$url = 'http://mystatus.skype.com/smallicon/' . $skype;
$gbook[$run]['icon_skype'] = empty($skype) ? '' : cs_html_link("skype:$skype?userinfo",cs_html_img($url,'16','16','0','Skype'),'0');
$url = cs_secure($cs_gbook[$run]['gbook_url']);
$gbook[$run]['icon_url'] = empty($url) ? '' : cs_html_link("http://$url",cs_icon('gohome'));
} else {
$hidden = explode(',',$cs_gbook[$run]['users_hidden']);
$allow = $cs_gbook[$run]['users_id'] == $account['users_id'] OR $account['access_users'] > 4 ? 1 : 0;
$gbook[$run]['users_nick'] = cs_link($cs_gbook[$run]['users_nick'],'users','view','id=' . $cs_gbook[$run]['users_id']);
$gbook[$run]['town'] = '';
$gbook[$run]['icon_town'] = '';
if (!empty($cs_gbook[$run]['users_place'])) {
$gbook[$run]['icon_town'] = cs_icon('gohome');
$gbook[$run]['town'] = cs_secure($cs_gbook[$run]['users_place']);
}
$mail = cs_html_mail($cs_gbook[$run]['users_email'],cs_icon('mail_generic'));
if(in_array('users_email',$hidden)) {
$mail = empty($allow) ? '' : $mail;
}
$gbook[$run]['icon_mail'] = empty($cs_gbook[$run]['users_email']) ? '' : $mail;
$link = 'http://wwp.icq.com/' . $cs_gbook[$run]['users_icq'];
$icqstart = 'http://web.icq.com/whitepages/online?icq=' . $cs_gbook[$run]['users_icq'] . '&img=22';
$icq = cs_html_link($link,cs_html_img($icqstart,'16','16','0','ICQ'),'0');
if(in_array('users_icq',$hidden)) {
$icq = empty($allow) ? '' : $icq;
}
$gbook[$run]['icon_icq'] = empty($cs_gbook[$run]['users_icq']) ? '' : $icq;
$msn = cs_html_link('http://members.msn.com/' . $cs_gbook[$run]['users_msn'],cs_icon('msn_protocol'));
if(in_array('users_msn',$hidden)) {
$msn = empty($allow) ? '' : $msn;
}
$gbook[$run]['icon_msn'] = empty($cs_gbook[$run]['users_msn']) ? '' : $msn;
$url = 'http://mystatus.skype.com/smallicon/' . $cs_gbook[$run]['users_skype'];
$skype = cs_html_link('skype:' . $cs_gbook[$run]['users_skype'] . '?userinfo',cs_html_img($url,'16','16','0','Skype'),'0');
if(in_array('users_skype',$hidden)) {
$skype = empty($allow) ? '' : $skype;
}
$gbook[$run]['icon_skype'] = empty($cs_gbook[$run]['users_skype']) ? '' : $skype;
$url = cs_html_link('http://' . $cs_gbook[$run]['users_url'],cs_icon('gohome'));
if(in_array('users_url',$hidden)) {
$url = empty($allow) ? '' : $url;
}
$gbook[$run]['icon_url'] = empty($cs_gbook[$run]['users_url']) ? '' : $url;
}
$gbook[$run]['text'] = cs_secure($cs_gbook[$run]['gbook_text'],1,1);
$gbook[$run]['time'] = cs_date('unix',$cs_gbook[$run]['gbook_time'],1);
if($account['access_gbook'] >= 4)
{
$img_edit = cs_icon('edit',16,$cs_lang['edit']);
$gbook[$run]['icon_edit'] = cs_link($img_edit,'gbook','edit','id=' . $cs_gbook[$run]['gbook_id'],0,$cs_lang['edit']);
$img_del = cs_icon('editdelete',16,$cs_lang['remove']);
$gbook[$run]['icon_remove'] = cs_link($img_del,'gbook','remove','id=' . $cs_gbook[$run]['gbook_id'],0,$cs_lang['remove']);
$img_ip = cs_icon('important',16,$cs_lang['ip']);
$more = 'id=' . $cs_gbook[$run]['gbook_id'];
$more .= '&action1=' . $cs_main['action'];
$gbook[$run]['icon_ip'] = cs_link($img_ip,'gbook','ip',$more,0,$cs_lang['ip']);
} else {
$gbook[$run]['icon_edit'] = '';
$gbook[$run]['icon_remove'] = '';
$gbook[$run]['icon_ip'] = '';
}
}
$data['gbook'] = !empty($gbook) ? $gbook : '';
echo cs_subtemplate(__FILE__,$data,'gbook');
?> |