Clansphere :: FREE Clan Content Management System

Warning: cs_html_vote - Function goes away in next minor release, use themes instead
Warning: cs_html_div - Function goes away in next minor release, use themes instead
Warning: cs_subtemplate - Custom theme file not found: "themes/Bloody Darkness/clansphere/navmeta.tpl"
Warning: cs_html_span - Function goes away in next minor release, use themes instead
Warning: cs_html_table - Function goes away in next minor release, use themes instead
Warning: cs_html_roco - Function goes away in next minor release, use themes instead
Warning: cs_subtemplate - Custom theme file not found: "themes/Bloody Darkness/users/navlogin_2.tpl"
Warning: cs_subtemplate - Custom theme file not found: "themes/Bloody Darkness/votes/navlist_results.tpl"
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime, users_ajax, users_tpl, users_pwd FROM cs_users WHERE users_id = '1' AND users_pwd = 'ea5c5e63330e0a000068b71b970775bf32bed046' LIMIT 0,1
UPDATE cs_users SET users_laston='1237495275' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = 5 LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '217.80.161.252' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1237495275', count_location='news/recent' WHERE count_id='77'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'fckeditor'
SELECT COUNT(*) FROM cs_news WHERE news_publishs_at != 0 AND news_public = 0 AND news_publishs_at < 1237495275
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'news'
SELECT * FROM cs_categories WHERE categories_mod = 'news' AND categories_access <= 5 ORDER BY categories_name
SELECT COUNT(DISTINCT news_id) FROM cs_news nws INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public > 0 AND cat.categories_access <= 5
SELECT nws.news_id AS news_id, nws.news_headline AS news_headline, nws.news_time AS news_time, nws.news_text AS news_text, nws.news_pictures AS news_pictures, nws.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, nws.categories_id AS categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name, nws.news_mirror AS news_mirror, nws.news_mirror_name AS news_mirror_name, nws.news_readmore AS news_readmore, nws.news_readmore_active AS news_readmore_active FROM cs_news nws INNER JOIN cs_users usr ON nws.users_id = usr.users_id INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public > 0 AND cat.categories_access <= 5 ORDER BY news_attached DESC, news_time DESC LIMIT 0,8
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'abcode'
SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 8
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 7
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 6
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 5
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'videoabcode'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 4
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 3
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 2
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT * FROM cs_ticker tck JOIN cs_options opt ON opt.options_mod='ticker' WHERE tck.ticker_id=opt.options_value AND opt.options_name='active_id' LIMIT 0,1
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'ticker'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'events'
SELECT users_age FROM cs_users WHERE users_age LIKE '%-03-%'
SELECT events_time FROM cs_events WHERE events_time >= '1235865600' AND events_time <= '1238543999'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1237494975'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1237413600'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1235858400'
SELECT count_num FROM cs_count_archiv
SELECT COUNT(*) FROM cs_count
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'wars'
SELECT war.games_id AS games_id, cln.clans_short AS clans_short, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id FROM cs_wars war INNER JOIN cs_categories cat ON war.categories_id = cat.categories_id INNER JOIN cs_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_status = 'played' ORDER BY wars_date DESC LIMIT 0,4
SELECT war.games_id AS games_id, war.wars_date AS wars_date, sqd.squads_name AS squads_name, cln.clans_name AS clans_name, war.wars_id AS wars_id FROM cs_wars war INNER JOIN cs_squads sqd ON war.squads_id = sqd.squads_id INNER JOIN cs_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_date > '1237495275' AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,4
SELECT users_readtime FROM cs_users WHERE users_id = '1' LIMIT 0,1
SELECT thr.threads_headline AS threads_headline, thr.threads_id AS threads_id, thr.threads_last_time AS threads_last_time FROM cs_threads thr INNER JOIN cs_board frm ON frm.board_id = thr.board_id LEFT JOIN cs_read red ON thr.threads_id = red.threads_id AND red.users_id = '1' WHERE frm.board_access <= '5' AND frm.board_pwd = '' AND thr.threads_last_time > '1236285675' AND (thr.threads_last_time > red.read_since OR red.threads_id IS NULL) ORDER BY thr.threads_last_time DESC LIMIT 0,4
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0
SELECT ne.news_id AS news_id, ne.news_headline AS news_headline, ne.news_time AS news_time FROM cs_news ne INNER JOIN cs_categories cat ON ne.categories_id = cat.categories_id WHERE ne.news_public > '0' AND cat.categories_access <= '5' ORDER BY ne.news_time DESC LIMIT 0,4
SELECT users_id, users_nick, users_country, users_active, users_invisible FROM cs_users WHERE users_laston > 1237494975 AND users_active = '1' AND users_invisible = '0' ORDER BY users_laston DESC LIMIT 0,8
SELECT banners_picture, banners_alt, banners_url, categories_id FROM cs_banners ORDER BY banners_order ASC
SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1237495275' AND votes_end >= '1237495275' ORDER BY RAND() LIMIT 0,1
SELECT COUNT(*) FROM cs_voted WHERE voted_mod = 'votes' AND voted_fid = '2' AND voted_ip = '217.80.161.252' OR voted_mod = 'votes' AND voted_fid = '2' AND users_id = '1'
SELECT voted_id, users_id, voted_ip, voted_answer FROM cs_voted WHERE voted_fid = '2' AND voted_mod = 'votes'
SELECT COUNT(*) FROM cs_shoutbox
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'shoutbox'
SELECT shoutbox_name, shoutbox_text, shoutbox_date FROM cs_shoutbox ORDER BY shoutbox_date DESC LIMIT 0,10
SELECT gallery_id FROM cs_gallery WHERE gallery_access < '5' AND gallery_status = '1' ORDER BY gallery_id DESC

<table class="forum" style="width:{page:width}">
<tr><td class="headb" colspan="3">
{lang:mod_stats}
</td></tr>
<tr><td class="leftc">
{lang:all}{head:all}</td>
<td class="leftc">
{lang:month}{head:month}</td>
<td class="leftc">
{lang:today}{head:today}
</td></tr>
</table>
<br />

<table class="forum" style="width:{page:width}">
<tr><td class="headb" colspan="4" rowspan="1">
{lang:trend}
</td></tr>
<tr><td class="leftc">
{lang:yearmon}</td>
<td class="leftc">
{lang:average}</td>
<td class="leftc">
{lang:count}</td>
<td class="leftc" style="width:50%">
{lang:barp}
</td></tr>
{loop:count}
<tr><td class="leftb">
{count:year-mon}</td>
<td class="rightb">
{count:day}</td>
<td class="rightb">
{count:count}</td>
<td class="leftb">
{barp:start}{count:size}{barp:end}
{count:diff}
</td></tr>
{stop:count}
</table>

<?php
// ClanSphere 2008 - www.clansphere.net
// $Id: stats.php 2206 2009-03-18 17:04:34Z hajo $

$cs_lang = cs_translate('count');

$op_count = cs_sql_option(__FILE__,'count');

$data = array();
$combine = array();
$archive = 0;
$comnr = 0;

$count_navall = cs_sql_count(__FILE__,'count');
$count_arcall = cs_sql_count(__FILE__,'count_archiv');

if ($op_count['view'] == 'stats'){
$levels = 6;
$count_archive = cs_sql_select(__FILE__,'count_archiv','count_month, count_num',0,'count_id DESC',0,0);
}
if ($op_count['view'] == 'amstats'){
if (empty($count_arcall)){
$levels = 1;
} else {
$levels = $count_arcall + 1;
}

$count_archive = cs_sql_select(__FILE__,'count_archiv','*',0,'count_id ASC',0,0);
}

if(!empty($count_archive)) {
foreach($count_archive AS $value) {
$combine['' . $value['count_month'] . ''] = $value['count_num'];
$archive = $archive + $value['count_num'];
}
}

$tday = cs_datereal('d');
$tmonth = cs_datereal('n');
$tyear = cs_datereal('Y');
$daystart = mktime(0,0,0,$tmonth,$tday,$tyear);
$monthstart = mktime(0,0,0,$tmonth,1,$tyear);
$count_navmon = cs_sql_count(__FILE__,'count','count_time > ' . $monthstart);
$count_navday = cs_sql_count(__FILE__,'count','count_time > ' . $daystart);

$data['head']['all'] = number_format($count_navall + $archive,0,',','.');
$data['head']['month'] = number_format($count_navmon,0,',','.');
$data['head']['today'] = number_format($count_navday,0,',','.');

$mon = array(1 => $cs_lang['jan'], 2 => $cs_lang['feb'], 3 => $cs_lang['mar'], 4 => $cs_lang['apr'],
5 => $cs_lang['mai'], 6 => $cs_lang['jun'], 7 => $cs_lang['jul'], 8 => $cs_lang['aug'], 9 => $cs_lang['sept'],
10 => $cs_lang['okt'], 11 => $cs_lang['nov'], 12 => $cs_lang['dez']);

$comnr_max = 0;
$vyear = cs_datereal('Y');
$loopm = $tmonth - $levels + 1;
for($loopm = $loopm; $loopm < 1; $loopm = $loopm + 12) {
$vyear--;
}

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

if($loopm > 12) {
$loopm = $loopm - 12;
$vyear++;
}
$days = date('t', mktime(0,0,0,$loopm,0,$vyear));
if($loopm == cs_datereal('n') AND $vyear == cs_datereal('Y')) $days = cs_datereal('j');

$mstar = mktime(0,0,0,$loopm,1,$vyear);
$mend = mktime(0,0,0,($loopm + 1),1,$vyear);

$comnr = isset($combine[$loopm . '-' . $vyear]) ? $combine[$loopm . '-' . $vyear] : 0;
$comnr = $comnr + cs_sql_count(__FILE__,'count','count_time > ' . $mstar . ' AND count_time < ' . $mend);
if($comnr > $comnr_max) {
$comnr_max = $comnr;
}

$data['count'][$run]['year-mon'] = $vyear . ' - ' . $mon[$loopm];
$data['count'][$run]['day'] = round($comnr / $days,0);
$data['count'][$run]['count'] = $comnr;
$loopm++;
}
$run = 0;
$count = $data['count'][0]['count'];
foreach($data['count'] AS $dc) {

if ($data['count'][$run]['count'] == 0){
$data['count'][$run]['size'] = '-';
$data['count'][$run]['diff'] = '-';
$data['count'][$run]['barp_start'] = '';
$data['count'][$run]['barp_end'] = '';
}
else {
$data['count'][$run]['barp'] = round($data['count'][$run]['count'] / $comnr_max * 200);
$data['count'][$run]['size'] = cs_html_img('symbols/clansphere/bar2.gif', 12, $data['count'][$run]['barp']);

if ($data['count'][$run-1]['count'] == 0) {
$data['count'][$run]['diff'] = '-';
}
else {
$diff = empty($count) ? ($data['count'][$run]['count'] * 100) . '%' : round($data['count'][$run]['count'] / $count * 100 - 100,2) . '%';
$data['count'][$run]['diff'] = substr($diff,0,1) == '-' ? str_replace('-', '- ', $diff) : '+ ' . $diff;
}

$data['count'][$run]['barp_start'] = cs_html_img('symbols/clansphere/bar1.gif',12,2);
$data['count'][$run]['barp_end'] = cs_html_img('symbols/clansphere/bar3.gif',12,2);
}

$count = $data['count'][$run]['count'];
$run++;
}

if ($op_count['view'] == 'stats'){
echo cs_subtemplate(__FILE__,$data,'count','stats');
}
$run = 0;
if ($op_count['view'] == 'amstats'){
echo cs_subtemplate(__FILE__,$data,'count','statshead');

?>
<script type="text/javascript" src="<?php echo $cs_main['php_self']['dirname']; ?>mods/count/amline/swfobject.js"></script>
<div id="flashcontent">
<?php
echo cs_subtemplate(__FILE__,$data,'count','flash');
?>
</div>
<?php
echo "<script type=\"text/javascript\">\n
//<![CDATA[\n
var so = new SWFObject(\"" . $cs_main['php_self']['dirname'] . "mods/count/amline/amline.swf\", \"amline\", \"" . $op_count['width'] . "%\", \"" . $op_count['height'] . "px\", \"8\", \"#" . $op_count['background'] . "\");\n
so.addVariable(\"path\", \"" . $cs_main['php_self']['dirname'] . "mods/count/amline/\");\n
so.addVariable(\"chart_settings\",\"<settings><text_size >" . $op_count['textsize'] . "</text_size><text_color>" . $op_count['textcolor'] . "</text_color><redraw>true</redraw><background>< color>#" . $op_count['background'] . "</color><alpha>100</alpha></background><scrolle r><enabled>true</enabled></scroller><grid><x>< enabled>true</enabled><color>#" . $op_count['textcolor'] . "</color><dashed>true</dashed><dash_length>3</da sh_length><approx_count>12</approx_count></x><y_left> <enabled>true</enabled><color>#" . $op_count['textcolor'] . "</color></y_left><y_right><enabled>true</enable d><color>#" . $op_count['textcolor'] . "</color></y_right></grid><axes><x><color> " . $op_count['axescolor'] . "</color></x><y_left><color>#" . $op_count['axescolor'] . "</color><tick_length>10</tick_length></y_left>< y_right><color>#" . $op_count['axescolor'] . "</color></y_right></axes><indicator><enabled> true</enabled><color>#" . $op_count['indicatorcolor'] . "</color><selection_color>#3972ad</selection_color><y_ balloon_on_off>true</y_balloon_on_off></indicator><legend>< y>380</y><text_color_hover>#" . $op_count['graphcolor1'] . "</text_color_hover></legend><labels><label><ali gn>left</align><text_size>7</text_size><text></tex t></label></labels><graphs><graph gid='1'><axis>left</axis><title>Nominal</title ><color>#" . $op_count['graphcolor1'] . "</color><color_hover>#" . $op_count['graphcolor1'] . "</color_hover><line_width>4</line_width><fill_alpha> 30</fill_alpha><fill_color>#" . $op_count['graphcolor1'] . "</fill_color><balloon_color>#" . $op_count['graphcolor1'] . "</balloon_color><balloon_text_color>#" . $op_count['textballoncolor'] . "</balloon_text_color><bullet_color>#" . $op_count['graphcolor1'] . "</bullet_color><balloon_text>{value} " . $cs_lang['guest'] . "</balloon_text></graph><graph gid='2'><axis>left</axis><title>Nominal</title ><color>#" . $op_count['graphcolor2'] . "</color><color_hover>#" . $op_count['graphcolor2'] . "</color_hover><line_width>4</line_width><fill_alpha> 30</fill_alpha><fill_color>#" . $op_count['graphcolor2'] . "</fill_color><balloon_color>#" . $op_count['graphcolor2'] . "</balloon_color><balloon_text_color>#" . $op_count['textballoncolor'] . "</balloon_text_color><bullet_color>#" . $op_count['indicatorcolor'] . "</bullet_color><balloon_text>" . $cs_lang['daydif'] . " {value}</balloon_text></graph></graphs></settings >\");\n

so.addVariable(\"chart_data\", \"<chart><series>";
$loop = 1;
for($run=0; $run < $levels; $run++) {
echo "<value xid='" . $loop . "'>" . $data['count'][$run]['year-mon'] . "</value>";
$loop++;
}
echo "</series><graphs><graph gid='1' title='" . $cs_lang['guest'] . "'>";
$loop = 1;
for($run=0; $run < $levels; $run++) {
echo "<value xid='" . $loop . "'>" . $data['count'][$run]['count'] . "</value>";
$loop++;
}
echo "</graph><graph gid='2' title='" . $cs_lang['daydif'] . "'>";
$loop = 1;
for($run=0; $run < $levels; $run++) {
echo "<value xid='" . $loop . "'>" . $data['count'][$run]['day'] . "</value>";
$loop++;
}
echo "</graph></graphs></chart>\");\n
so.addVariable(\"preloader_color\", \"#" . $op_count['textcolor'] . "\");\n
so.write(\"flashcontent\");\n
//]]>\n
</script>\n";
}

?>