View file o5on.ru/html/charts/hours.php

File size: 3.33Kb
<?php
include '../../inc/config.inc.php';
include '../../inc/wap_tags.inc.php';
include '../../inc/functions.inc.php';

connect_to_db();
$today = date("Ymd");
print "<chart>\n";
print "	<axis_category size=\"10\" color=\"000000\" alpha=\"50\" skip=\"0\" />\n";
print "	<axis_value size=\"10\" color=\"000000\" alpha=\"50\" steps=\"6\" prefix=\"\" suffix=\"\" decimals=\"0\" separator=\"\" show_min=\"\" />\n";
print "	<axis_ticks category_ticks=\"\" />\n";
print "	<chart_border color=\"999999\" top_thickness=\"0\" bottom_thickness=\"0\" left_thickness=\"0\" right_thickness=\"0\" />\n";
print "	<chart_grid_h alpha=\"10\" color=\"000000\" thickness=\"1\" type=\"solid\" />\n";
print "	<chart_grid_v alpha=\"10\" color=\"000000\" thickness=\"1\" type=\"solid\" />\n";
print "	\n";
print "	<chart_data>\n";
print "		<row>\n";
print "			<string></string>\n";
print "			<string>00</string>\n";
print "			<string>01</string>\n";
print "			<string>02</string>\n";
print "			<string>03</string>\n";
print "			<string>04</string>\n";
print "			<string>05</string>\n";
print "			<string>06</string>\n";
print "			<string>07</string>\n";
print "			<string>08</string>\n";
print "			<string>09</string>\n";
print "			<string>10</string>\n";
print "			<string>11</string>\n";
print "			<string>12</string>\n";
print "			<string>13</string>\n";
print "			<string>14</string>\n";
print "			<string>15</string>\n";
print "			<string>16</string>\n";
print "			<string>17</string>\n";
print "			<string>18</string>\n";
print "			<string>19</string>\n";
print "			<string>20</string>\n";
print "			<string>21</string>\n";
print "			<string>22</string>\n";
print "			<string>23</string>\n";
print "		</row>\n";
print "		<row>\n";
print "			<string>Hosts</string>\n";


for($i=0; $i < 24; $i++){
$result = mysql_query("SELECT sum(`host`) FROM `count_24` where `uid`!='1' and `date`=".$today." and `hour`='".$i."'");
$fetch = mysql_fetch_row($result);
echo "			<number>".(isset($fetch[0])?$fetch[0]:'0')."</number>\n";
}

print "		</row>\n";
print "		<row>\n";
print "			<string>Hits</string>\n";

for($i=0; $i < 24; $i++){
$result = mysql_query("SELECT sum(`count`) FROM `count_24` where `uid`!='1' and `date`=".$today." and `hour`='".$i."'");
$fetch = mysql_fetch_row($result);
echo "			<number>".(isset($fetch[0])?$fetch[0]:'0')."</number>\n";
}

print "		</row>\n";
print "	</chart_data>\n";
print "	\n";

print "	<chart_rect x=\"-120\" y=\"47\" width=\"650\" height=\"180\" line_thickness=\"5\" />\n";
print "	<chart_type>stacked column</chart_type>\n";
print "	<chart_value prefix=\"\" suffix=\"\" decimals=\"0\" separator=\"\" position=\"cursor\" hide_zero=\"1\" as_percentage=\"\" font=\"arial\" bold=\"1\" size=\"12\" color=\"333333\" alpha=\"75\" />\n";

print "	<draw>\n";
print "		<text color=\"333333\" alpha=\"75\" font=\"arial\" rotation=\"0\" bold=\"1\" size=\"12\" x=\"50\" y=\"47\" width=\"480\" height=\"160\" h_align=\"right\" v_align=\"top\">". date('j.m.Y') ."</text>\n";
print "	</draw>\n";
print "	<legend_rect x=\"-100\" y=\"-100\" width=\"10\" height=\"10\" margin=\"0\" />\n";
print "	<series_color>\n";
print "		<value>ff6600</value>\n";
print "		<value>224499</value>\n";
print "		<value>000000</value>\n";
print "	</series_color>\n";
print "	<series_gap set_gap=\"10\" bar_gap=\"0\" />\n";
print "</chart>\n";


?>