source: trunk/global.php@ 237

Last change on this file since 237 was 237, checked in by george, 16 years ago
  • Přidáno: Třída file pro obsluhu ukládání načtených souborů. Seznam uchovaných souborů je v tabulce File.
  • Opraveno: Zobrazení otvíracích dob včetně zbývajícího času do otevření/zavření.
  • Přidáno: Přímá editace otvíracích dob na webu.
  • Přidáno: Možnost načíst obrázek s otvírací dobou.
  • Property svn:executable set to *
File size: 11.6 KB
Line 
1<?php
2
3$ScriptTimeStart = GetMicrotime();
4
5// SQL injection hack protection
6foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($Item);
7foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($Item);
8
9if(isset($_SERVER['REMOTE_ADDR'])) session_start();
10include('config.php');
11include('database.php');
12include('error.php');
13include_once('code.php');
14$Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password'], $Config['Database']['Database']);
15$Database->Prefix = $Config['Database']['Prefix'];
16$Database->charset($Config['Database']['Charset']);
17include_once('module.php');
18include_once('forms.php');
19include_once('page.php');
20include_once('file.php');
21
22$PrefixMultipliers = array
23(
24 'Binary' => array
25 (
26 'BaseIndex' => 0,
27 'Definition' => array
28 (
29 array('', '', pow(2, 0)),
30 array('Ki', 'kibi', pow(2, 10)),
31 array('Mi', 'mebi', pow(2, 20)),
32 array('Gi', 'gibi', pow(2, 30)),
33 array('Ti', 'tebi', pow(2, 40)),
34 array('Pi', 'pebi', pow(2, 50)),
35 array('Ei', 'exbi', pow(2, 60)),
36 array('Zi', 'zebi', pow(2, 70)),
37 array('Yi', 'yobi', pow(2, 80)),
38 ),
39 ),
40 'Decimal' => array
41 (
42 'BaseIndex' => 8,
43 'Definition' => array
44 (
45 array('y', 'yocto', pow(10, -24)),
46 array('z', 'zepto', pow(10, -21)),
47 array('a', 'atto', pow(10, -18)),
48 array('f', 'femto', pow(10, -15)),
49 array('p', 'piko', pow(10, -12)),
50 array('n', 'nano', pow(10, -9)),
51 array('u', 'mikro', pow(10, -6)),
52 array('m', 'mili', pow(10, -3)),
53 array('', '', pow(10, 0)),
54 array('k', 'kilo', pow(10, 3)),
55 array('M', 'mega', pow(10, 6)),
56 array('G', 'giga', pow(10, 9)),
57 array('T', 'tera', pow(10, 12)),
58 array('P', 'peta', pow(10, 15)),
59 array('E', 'exa', pow(10, 18)),
60 array('Z', 'zetta', pow(10, 21)),
61 array('Y', 'yotta', pow(10, 24)),
62 ),
63 ),
64 'Time' => array
65 (
66 'BaseIndex' => 8,
67 'Definition' => array
68 (
69 array('ys', 'yoctosekunda', pow(10, -24)),
70 array('zs', 'zeptosekunda', pow(10, -21)),
71 array('as', 'attosekunda', pow(10, -18)),
72 array('fs', 'femtosekunda', pow(10, -15)),
73 array('ps', 'pikosekunda', pow(10, -12)),
74 array('ns', 'nanosekunda', pow(10, -9)),
75 array('us', 'mikrosekunda', pow(10, -6)),
76 array('ms', 'milisekunda', pow(10, -3)),
77 array('s', 'sekunda', 1),
78 array('minut', 'minuta', 60),
79 array('hodin', 'hodina', 60 * 60) ,
80 array('dnů', 'den', 24 * 60 * 60),
81 array('týdnů', 'týden', 7 * 24 * 60 * 60),
82 array('měsíců', 'měsíc', 30 * 24 * 60 * 60),
83 array('roků', 'rok', 364 * 24 * 60 * 60),
84 array('desetiletí', 'desetiletí', 10 * 364 * 24 * 60 * 60),
85 array('stalatí', 'staletí', 100 * 364 * 24 * 60 * 60),
86 array('tisíciletí', 'tisiciletí', 10000 * 364 * 24 * 60 * 60),
87 ),
88 ),
89);
90
91class System extends Module
92{
93 var $Modules = array();
94
95 function ModulePresent($Name)
96 {
97 return(array_key_exists($Name, $this->Modules));
98 }
99
100 function AddModule($Module)
101 {
102 global $Database;
103
104 //echo('Přidávám modul '.get_class($Module).'<br />');
105 $Module->System = &$this;
106 $Module->Database = &$Database;
107 $this->Modules[get_class($Module)] = $Module;
108 }
109
110 function AddEmailToQueue($Address, $Subject, $Content, $Headers = '')
111 {
112 $this->Database->insert('EmailQueue', array('Address' => $Address, 'Subject' => $Subject, 'Content' => $Content, 'Time' => 'NOW()', 'Headers' => $Headers));
113 }
114
115 function MailUTF8($To, $Subject = '(No subject)', $Message = '', $Header = '')
116 {
117 $Header = 'MIME-Version: 1.0' . "\r\n" . 'Content-type: text/html; charset=UTF-8' . "\r\n".$Header;
118 mail($To, '=?UTF-8?B?'.base64_encode($Subject).'?=', $Message, $Header);
119 //echo('mail('.$To.', =?UTF-8?B?'.base64_encode($Subject).'?=, '.$Message.', '.$Header.')<br/>');
120 }
121
122 function ProcessEmailQueue()
123 {
124 $Output = '';
125 $DbResult = $this->Database->select('EmailQueue', '*', 'Archive=0');
126 while($DbRow = $DbResult->fetch_assoc())
127 {
128 $this->MailUTF8($DbRow['Address'], $DbRow['Subject'], $DbRow['Content'], $DbRow['Headers']);
129 //echo('mail('.$DbRow['Address'].', '.$DbRow['Subject'].', '.$DbRow['Content'].', FromUTF8('.$DbRow['Headers'].', \'iso2\'));');
130 $this->Database->update('EmailQueue', 'Id='.$DbRow['Id'], array('Archive' => 1));
131 $this->Modules['Log']->NewRecord('System', 'SendEmail', $DbRow['Id']);
132 $Output .= 'To: '.$DbRow['Address'].' Subject: '.$DbRow['Subject'].'<br />';
133 }
134 return($Output);
135 }
136
137 function HumanDate($Time)
138 {
139 return(date('j.n.Y', $Time));
140 }
141
142 function TruncateDigits($Value, $Digits = 4)
143 {
144 for($II = 2; $II > -6; $II--)
145 {
146 if($Value >= pow(10, $II))
147 {
148 if($Digits < ($II + 1)) $RealDigits = $II + 1; else $RealDigits = $Digits;
149 $Value = round($Value / pow(10, $II - $RealDigits + 1)) * pow(10, $II - $RealDigits + 1);
150 break;
151 }
152 }
153 return($Value);
154 }
155
156 function AddPrefixMultipliers($Value, $Unit, $Digits = 4, $PrefixType = 'Decimal')
157 {
158 global $PrefixMultipliers;
159
160 $Negative = ($Value < 0);
161 $Value = abs($Value);
162 if(($Unit == '') and ($PrefixType != 'Time'))
163 return($this->TruncateDigits($Value, $Digits));
164
165 $I = $PrefixMultipliers[$PrefixType]['BaseIndex'];
166 if($Value == 0) return($Value.' '.$PrefixMultipliers[$PrefixType]['Definition'][$I][0].$Unit);
167
168 if($Value > 1)
169 {
170 while((($I + 1) <= count($PrefixMultipliers[$PrefixType]['Definition'])) and (($Value / $PrefixMultipliers[$PrefixType]['Definition'][$I + 1][2]) > 1))
171 $I = $I + 1;
172 } else
173 if($Value < 1)
174 {
175 while((($I - 1) >= 0) and (($Value / $PrefixMultipliers[$PrefixType]['Definition'][$I][2]) < 1))
176 $I = $I - 1;
177 }
178 $Value = $Value / $PrefixMultipliers[$PrefixType]['Definition'][$I][2];
179
180 // Truncate digits count
181 $Value = $this->TruncateDigits($Value, $Digits);
182 if($Negative) $Value = -$Value;
183 return($Value.' '.$PrefixMultipliers[$PrefixType]['Definition'][$I][0].$Unit);
184 }
185}
186
187$System = new System();
188$System->Config = $Config;
189$System->Database = &$Database;
190include_once('log.php');
191$System->AddModule(new Log());
192include_once('user.php');
193$System->AddModule(new User());
194if(isset($_SERVER['REMOTE_ADDR'])) $System->Modules['User']->Check();
195include_once('aktuality/news.php');
196$System->AddModule(new News());
197include_once('webcam/webcam.php');
198$System->AddModule(new Webcam());
199include_once('finance/bills.php');
200$System->AddModule(new Bill());
201include_once('finance/finance.php');
202$System->AddModule(new Finance());
203$System->Modules['Finance']->LoadMonthParameters(0);
204
205$MonthNames = array('', 'Leden', 'Únor', 'Březen', 'Duben', 'Květen', 'Červen', 'Červenec', 'Srpen', 'Září', 'Říjen', 'Listopad', 'Prosinec');
206
207$UnitNames = array('B', 'kB', 'MB', 'GB', 'TB', 'PB', 'EB');
208
209function HumanSize($Value)
210{
211 global $UnitNames;
212
213 $UnitIndex = 0;
214 while($Value > 1024)
215 {
216 $Value = round($Value / 1024, 3);
217 $UnitIndex++;
218 }
219 return($Value.' '.$UnitNames[$UnitIndex]);
220}
221
222function GetMicrotime()
223{
224 list($Usec, $Sec) = explode(' ', microtime());
225 return ((float)$Usec + (float)$Sec);
226}
227
228function ShowArray($Pole)
229{
230 echo('<pre style="font-size: 8pt;">');
231 print_r($Pole);
232 echo('</pre>');
233}
234
235function ToVpnIp($Host)
236{
237 if($Host['external_ip'] == '')
238 {
239 $Parts = explode('.', $Host['IP']);
240 return('172.16.'.$Parts[2].'.'.$Parts[3]);
241 } else
242 {
243 return($Host['external_ip']);
244 }
245}
246
247function TimeToMysqlDateTime($Time)
248{
249 return(date('Y-m-d H:i:s', $Time));
250}
251
252function MysqlDateTimeToTime($Time)
253{
254 $Parts = explode(' ', $Time);
255 $DateParts = explode('-', $Parts[0]);
256 $TimeParts = explode(':', $Parts[1]);
257 $Result = mktime($TimeParts[0], $TimeParts[1], $TimeParts[2], $DateParts[1], $DateParts[2], $DateParts[0]);
258 return($Result);
259}
260
261function MysqlDateToTime($Time)
262{
263 return(MysqlDateTimeToTime($Time.' 0:0:0'));
264}
265
266function ToCzfreeIp($Host)
267{
268 $Parts = explode('.', $Host['external_ip']);
269 if($Host['name'] == 'CENTRALA') return('10.144.1.1');
270 else return('10.144.200.'.$Parts[3]);
271}
272
273function HumanDate($Time)
274{
275 $Date = explode(' ', $Time);
276 $Parts = explode('-', $Date[0]);
277 if($Date != '0000-00-00') return(($Parts[2]*1).'.'.($Parts[1]*1).'.'.$Parts[0]);
278 else return('&nbsp;');
279}
280
281// Zobrazení číselný seznamu stránek
282function PagesList($URL,$Page,$TotalCount,$CountPerPage)
283{
284 $Count = ceil($TotalCount/$CountPerPage);
285 $Around = 10;
286 $Result = '';
287 if($Count>1)
288 {
289 if($Page>0)
290 {
291 $Result.= '<a href="'.$URL.'0">&lt;&lt;</a> ';
292 $Result.= '<a href="'.$URL.($Page-1).'">&lt;</a> ';
293 }
294 $PagesMax = $Count-1;
295 $PagesMin = 0;
296 if($PagesMax>($Page+$Around)) $PagesMax = $Page+$Around;
297 if($PagesMin<($Page-$Around))
298 {
299 $Result.= ' .. ';
300 $PagesMin = $Page-$Around;
301 }
302 for($i=$PagesMin;$i<=$PagesMax;$i++)
303 {
304 if($i==$Page) $Result.= '<strong>';
305 $Result.= '<a href="'.$URL.$i.'">'.($i+1).'</a> ';
306 if($i==$Page) $Result.= '</strong>';
307 }
308 if($PagesMax<($Count-1)) $Result .= ' .. ';
309 if($Page<($Count-1))
310 {
311 $Result.= '<a href="'.$URL.($Page+1).'">&gt;</a> ';
312 $Result.= '<a href="'.$URL.($Count-1).'">&gt;&gt;</a>';
313 }
314 }
315 return($Result);
316}
317
318function GetRemoteAddress()
319{
320 if(array_key_exists('HTTP_X_FORWARDED_FOR',$_SERVER)) $IP = $_SERVER['HTTP_X_FORWARDED_FOR'] ;
321 else if(array_key_exists('REMOTE_ADDR', $_SERVER)) $IP = $_SERVER['REMOTE_ADDR'];
322 else $IP = '0.0.0.0';
323 return($IP);
324}
325
326function IsInternetAddr()
327{
328 $RemoteAddr = GetRemoteAddress();
329 $RemoteAddr = explode('.', $RemoteAddr);
330 return(!(($RemoteAddr[0] == 192) and ($RemoteAddr[1] == 168)));
331}
332
333function GetMemberByIP($IP)
334{
335 global $Database;
336
337 $DbResult = $Database->query('SELECT Id FROM Member WHERE (SELECT Member FROM NetworkDevice WHERE (SELECT Device FROM NetworkInterface WHERE LocalIP = "'.$IP.'") = NetworkDevice.Id) = Member.Id');
338 if($DbResult->num_rows > 0)
339 {
340 $DbRow = $DbResult->fetch_assoc();
341 return($DbRow['Id']);
342 } else return('');
343}
344
345function RemoveDiacritic($Text)
346{
347 return(str_replace(
348 array('á', 'č', 'ď', 'é', 'ě', 'í', 'ľ', 'ň', 'ó', 'ř', 'š', 'ť', 'ú', 'ů', 'ý', 'ž', 'Á', 'Č', 'Ď', 'É', 'Ě', 'Í', 'Ľ', 'Ň', 'Ó', 'Ř', 'Š', 'Ť', 'Ú', 'Ů', 'Ý', 'Ž'),
349 array('a', 'c', 'd', 'e', 'e', 'i', 'l', 'n', 'o', 'r', 's', 't', 'u', 'u', 'y', 'z', 'A', 'C', 'D', 'E', 'E', 'I', 'L', 'N', 'O', 'R', 'S', 'T', 'U', 'U', 'Y', 'Z'),
350 $Text));
351}
352
353function CIDRToAddressRange($Subnet, $Mask)
354{
355 $SubnetParts = explode('.', $Subnet);
356 $SubnetBinary = ($SubnetParts[0] << 24) | ($SubnetParts[1] << 16) | ($SubnetParts[2] << 8) | $SubnetParts[3];
357 $SubnetTopBinary = $SubnetBinary + (1 << (32 - $Mask)) - 1;
358 $SubnetTopParts = array(($SubnetTopBinary >> 24) & 255, ($SubnetTopBinary >> 16) & 255, ($SubnetTopBinary >> 8) & 255, ($SubnetTopBinary & 255));
359 $SubnetTop = implode('.', $SubnetTopParts);
360 return(array('From' => $Subnet, 'To' => $SubnetTop));
361}
362
363function RouterOSIdent($Name)
364{
365 return(strtr(strtolower(trim($Name)), array(' ' => '-', '.' => '', '(' => '-', ')' => '-',
366 'č' => 'c', 'š' => 's', 'ě' => 'e', 'ř' => 'r', 'ž' => 'z', 'ý' => 'y', 'á' => 'a', 'í' => 'i', 'é' => 'e', 'ů' => 'u', 'ú' => 'u', 'ď' => 'd', 'ť' => 't', 'ň' => 'n', 'ó' => 'o',
367 'Č' => 'c', 'Š' => 's', 'Ě' => 'e', 'Ř' => 'r', 'Ž' => 'z', 'Ý' => 'y', 'Á' => 'a', 'Í' => 'i', 'É' => 'e', 'Ů' => 'u', 'Ú' => 'u', 'Ď' => 'd', 'Ť' => 't', 'Ň' => 'n', 'Ó' => 'o',
368)));
369}
370
371function NotBlank($Text)
372{
373 if($Text == '') return('&nbsp'); else return($Text);
374}
375
376?>
Note: See TracBrowser for help on using the repository browser.