Changeset 4 for www/index.php


Ignore:
Timestamp:
Jan 14, 2008, 9:48:39 PM (17 years ago)
Author:
george
Message:

Upraveno: Změna přístupu k databázi na třídu rozšířenou mysqli.
Upraveno: Sjednocení
Upraveno: Změna kódování všech stránek na UTF-8.
Odstraňeno: Staré nepotřebné soubory.

Location:
www
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • www

    • Property svn:ignore set to
      config.php
      php_script_error.log

  • www/index.php

    r1 r4  
    11<?php
     2
     3include_once('global.php');
    24include_once('style.php');
    3 ShowHeader('Vítejte na <strong>Centrále!</strong> - serveru komunitní poèítaèové sítì <strong>ZdechovNET</strong>','Rozcestník');
    4 include_once('is/db.php');
    5 //include_once('is/global.php');
    6 DB_Init('localhost','root','','share');
    7 DB_Query('SET CHARACTER SET latin2');
     5ShowHeader('Vítejte na <strong>Centrále!</strong> - serveru komunitní počítačové sítě <strong>ZdechovNET</strong>','Rozcestník');
     6
     7$Database->select_db('share');
    88
    99?>
    … …  
    3939
    4040<table width="100%"><tr><td valign="top">
    41 <?
    42 DB_Init('localhost','root','','is');
     41<?php
     42$Database->select_db('is');
    4343?>
    4444
    4545<table width="100%">
    4646<tr><td width="20%" valign="top">
    47 <strong>Dùle¾ité odkazy:</strong><br>
    48 <img alt="" src="images/favicons/money.gif" width="16" height="16"> <a href="/finance/">Finance</a><br>
    49 <img alt="" src="images/favicons/chart.gif" width="16" height="16"> <a href="/statistic/trafficview2.php">Statistika</a><br>
    50 <img alt="" src="images/favicons/prohledavac_sdileni.gif" width="15" height="15"> <a href="/share">Prohledat sdílení</a><br>
    51 <img alt="" src="images/favicons/comp.gif" width="16" height="16"> <a href="/userlist.php">Seznam u¾ivatelù</a><br>
    52 <img alt="" src="images/favicons/comp.gif" width="16" height="16"> <a href="/hostlist.php">Seznam poèítaèù</a><br>
    53 <img alt="" src="images/favicons/sunrisechat.gif" width="16" height="16"> <a href="/sunrisechat/history.php">Historie SunriseChatu</a><br>
    54 <img alt="" src="images/favicons/sunrisechat.gif" width="16" height="16"> <a href="/sunrisechat/webchat.php">Webový SunriseChatu</a><br>
    55 <img alt="" src="images/favicons/discus.gif" width="16" height="16"> <a href="/forum">Diskusní fórum</a><br>
     47<strong>Důležité odkazy:</strong><br>
     48<img alt="" src="images/favicons/money.gif" width="16" height="16"> <a href="finance/">Finance</a><br>
     49<img alt="" src="images/favicons/chart.gif" width="16" height="16"> <a href="statistic/trafficview2.php">Statistika</a><br>
     50<img alt="" src="images/favicons/prohledavac_sdileni.gif" width="15" height="15"> <a href="share">Prohledat sdílení</a><br>
     51<img alt="" src="images/favicons/comp.gif" width="16" height="16"> <a href="userlist.php">Seznam uživatelů</a><br>
     52<img alt="" src="images/favicons/comp.gif" width="16" height="16"> <a href="hostlist.php">Seznam počítačů</a><br>
     53<img alt="" src="images/favicons/sunrisechat.gif" width="16" height="16"> <a href="sunrisechat/history.php">Historie SunriseChatu</a><br>
     54<img alt="" src="images/favicons/sunrisechat.gif" width="16" height="16"> <a href="sunrisechat/webchat.php">Webový SunriseChatu</a><br>
     55<img alt="" src="images/favicons/discus.gif" width="16" height="16"> <a href="forum">Diskusní fórum</a><br>
    5656<img alt="" src="images/favicons/openwebmail.gif" width="16" height="16"> <a href="https://centrala.zdechov.net/cgi-bin/openwebmail/openwebmail.pl">WebMail</a><br>
    57 <img alt="" src="images/favicons/apple.gif" width="16" height="16"> <a href="/jidelna">Jídelníèek</a><br>
     57<img alt="" src="images/favicons/apple.gif" width="16" height="16"> <a href="jidelna">Jídelníček</a><br>
    5858<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="http://tv.zdechov.net/">Televize</a><br>
    5959<img alt="" src="images/favicons/cube.gif" width="16" height="16"> <a href="http://game-server.zdechov.net/">Herní server</a><br>
    60 <img alt="" src="images/favicons/cfix.gif" width="16" height="16"> <a href="/farnost">Rozpis m¹í</a><br>
    61 <img alt="" src="images/favicons/tel.gif" width="16" height="16"> <a href="/telseznam.php">Telefonní seznam</a><br>
    62 <img alt="" src="images/favicons/pripoj.gif" width="16" height="16"> <a href="/nabidky_pripojeni.php">Nabídky pøipojení</a><br>
    63 <img alt="" src="images/favicons/zapisy.gif" width="16" height="16"> <a href="/docs/zapisy/zapisy.php">Zápisy ze schùzí</a><br>
    64 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="/mapy/mapa.php">Mapa Zdìchova</a><br>
    65 <img alt="" src="images/favicons/otv_doby.gif" width="16" height="16"> <a href="/otevreno.php">Otvírací doby</a><br>
    66 <img alt="" src="images/favicons/topologie.gif" width="16" height="16"> <a href="/is/topologie.php">Topologie sítì</a><br>
    67 <img alt="" src="images/favicons/satellite.gif" width="16" height="16"> <a href="/is/dostupnost.php">Dostupnost sítì</a><br>
    68 <img alt="" src="images/favicons/tech.gif" width="16" height="16"> <a href="/network.php">Technické informace</a><br>
    69 <img alt="" src="images/favicons/socer.gif" width="16" height="16"> <a href="http://fotbal.zdechov.net/">Fotbal Sokol Zdìchov</a><br>
    70 <br>
    71 <strong>Dal¹í odkazy:</strong><br>
    72 <img alt="" src="images/favicons/tv.gif" width="16" height="16"> <a href="/tkr.php">Kanály kabelovky</a><br>
    73 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="/mapy/mapa_nabidka.php">Nabídka mapy</a><br>
    74 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="/history.php">Historie sítì</a><br>
    75 <img alt="" src="images/favicons/electric.gif" width="16" height="16"> <a href="/merak.php">Mìøiè spotøeby</a><br>
    76 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="/sluzby.php">Seznam slu¾eb</a><br>
    77 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="/ukoly.php">Plány do budoucna</a><br>
    78 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="/navody.php">Návody</a><br>
    79 <img alt="" src="images/favicons/info.gif" width="16" height="16"> <a href="/infokanal/index.htm">Infokanál</a><br>
    80 <img alt="" src="images/favicons/progman.gif" width="16" height="16"> <a href="/manualy.php">Programátorské manuály</a><br>
    81 
    82 
    83 <?//<a href="/cgi-bin/openwebmail/openwebmail.pl">Po±tovní schránka</a><br>
    84 //<a href="/download/addfile.php">Stahování souborù</a><br>
     60<img alt="" src="images/favicons/cfix.gif" width="16" height="16"> <a href="farnost">Rozpis mší</a><br>
     61<img alt="" src="images/favicons/tel.gif" width="16" height="16"> <a href="telseznam.php">Telefonní seznam</a><br>
     62<img alt="" src="images/favicons/pripoj.gif" width="16" height="16"> <a href="nabidky_pripojeni.php">Nabídky připojení</a><br>
     63<img alt="" src="images/favicons/zapisy.gif" width="16" height="16"> <a href="docs/zapisy/zapisy.php">Zápisy ze schůzí</a><br>
     64<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="mapy/mapa.php">Mapa Zděchova</a><br>
     65<img alt="" src="images/favicons/otv_doby.gif" width="16" height="16"> <a href="otevreno.php">Otvírací doby</a><br>
     66<img alt="" src="images/favicons/topologie.gif" width="16" height="16"> <a href="is/topologie.php">Topologie sítě</a><br>
     67<img alt="" src="images/favicons/satellite.gif" width="16" height="16"> <a href="is/dostupnost.php">Dostupnost sítě</a><br>
     68<img alt="" src="images/favicons/tech.gif" width="16" height="16"> <a href="network.php">Technické informace</a><br>
     69<img alt="" src="images/favicons/socer.gif" width="16" height="16"> <a href="http://fotbal.zdechov.net/">Fotbal Sokol Zděchov</a><br>
     70<br>
     71<strong>Další odkazy:</strong><br>
     72<img alt="" src="images/favicons/tv.gif" width="16" height="16"> <a href="tkr.php">Kanály kabelovky</a><br>
     73<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="mapy/mapa_nabidka.php">Nabídka mapy</a><br>
     74<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="history.php">Historie sítě</a><br>
     75<img alt="" src="images/favicons/electric.gif" width="16" height="16"> <a href="merak.php">Měřič spotřeby</a><br>
     76<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="ukoly.php">Plány do budoucna</a><br>
     77
     78
     79<?php
     80//<a href="/cgi-bin/openwebmail/openwebmail.pl">Poątovní schránka</a><br>
     81//<a href="/download/addfile.php">Stahování souborů</a><br>
    8582?>
    8683<br>
    … …  
    9491<img alt="" src="images/favicons/www_tiscali_cz.gif" width="16" height="16"> <a href="http://www.tiscali.cz">Tiscali</a><br>
    9592<br>
    96 <strong>U¾iteèné:</strong><br>
    97 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="http://www.zdechov.net">Stránky na¹í sítì</a><br>
     93<strong>Užitečné:</strong><br>
     94<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="http://www.zdechov.net">Stránky naší sítě</a><br>
    9895<img alt="" src="images/favicons/www_tvinfo_cz.gif" width="16" height="16"> <a href="http://www.tvinfo.cz/live/televize/cz">Online TV</a><br>
    99 <img alt="" src="images/favicons/www_idos_cz.gif" width="16" height="16"> <a href="http://www.idos.cz/ConnForm.asp?tt=c">Jízdní øády</a><br>
     96<img alt="" src="images/favicons/www_idos_cz.gif" width="16" height="16"> <a href="http://www.idos.cz/ConnForm.asp?tt=c">Jízdní řády</a><br>
    10097<img alt="" src="images/favicons/www_atlas_cz.gif" width="16" height="16"> <a href="http://tv.atlas.cz">TV programy</a><br>
    10198<img alt="" src="images/favicons/www_icq_com.gif" width="16" height="16"> Web ICQ <a href="javascript:openClient('flash')">Flash</a>&nbsp;<a href="javascript:openClient('java')">Java</a><br>
    10299<img alt="" src="images/favicons/www_centrum_cz.gif" width="16" height="16"> <a href="http://slovniky.centrum.cz">Slovníky</a><br>
    103 <img alt="" src="images/favicons/pocasi.gif" width="16" height="16"> <a href="http://www.meteopress.cz/">Poèasí</a><br>
     100<img alt="" src="images/favicons/pocasi.gif" width="16" height="16"> <a href="http://www.meteopress.cz/">Počasí</a><br>
    104101<img alt="" src="images/favicons/www_tzones_cz.gif" width="16" height="16"> <a href="http://www.tzones.cz/">T-Mobile SMS</a><br>
    105102<img alt="" src="images/favicons/www_mvk_cz.png" width="16" height="16"> <a href="http://www.mvk.cz/">Knihovna&nbsp;Vsetín</a><br>
    106103<br>
    107 <strong>Prodej poèítaèù:</strong><br>
    108 <img alt="" src="images/favicons/www_computershop_cz.png" width="16" height="16"> <a href="http://shop.computershop.cz/eshop/">SOFTCOM</a><br>
     104<strong>Prodej počítačů:</strong><br>
     105<img alt="" src="images/favicons/www_computershop_cz.png" width="16" height="16"> <a href="http://www.softcom.cz/">SOFTCOM</a><br>
    109106<img alt="" src="images/favicons/www_alfacomp_cz.gif" width="16" height="16"> <a href="http://www.alfacomp.cz/php/zbozi.php?akc=2">Alfacomp</a><br>
    110107<img alt="" src="images/favicons/www_petracomp_cz.png" width="16" height="16"> <a href="http://www.petracomp.cz/">Petracomp</a><br>
    111108<img alt="" src="images/favicons/www_tsbohemia_cz.png" width="16" height="16"> <a href="http://interlink.tsbohemia.cz/">TS Bohemia</a><br>
    112109<br>
    113 <?
     110<?php
    114111/*
    115112<strong>Osobní stránky:</strong><br>
    116113<img alt="" src="images/favicons/bomi.gif" width="16" height="16"> <a href="~mirek/">Miroslav Hajda</a><br>
    117 <img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="~george/">Jiøí Hajda</a><br>
     114<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="~george/">Jiří Hajda</a><br>
    118115*/
    119116?>
    120117</td>
    121118<td width="15%" valign="top">
    122 <?
    123 // Zobrazení seznamu online poèítaèù
    124 echo('<strong>Online poèítaèe:</strong><br><span style="font-size: smaller;">');
    125 DB_Query('SELECT * FROM hosts WHERE online=1 AND show_online=1 ORDER BY name');
    126 while($Row  = DB_Row())
     119<?php
     120// Zobrazení seznamu online počítačů
     121echo('<strong>Online počítače:</strong><br><span style="font-size: smaller;">');
     122$DbResult = $Database->select('hosts', '*', 'online=1 AND show_online=1 ORDER BY name');
     123while($Row = $DbResult->fetch_array())
    127124{
    128125  echo($Row['name'].'<br>');
    … …  
    133130
    134131// Zobrazení seznamu neplaticich uzivatelu
    135 echo('<strong>Dlu¾níci:</strong><br><span style="font-size: smaller;">');
    136 DB_Query('SELECT first_name, second_name FROM users WHERE cash<0 ORDER BY cash');
    137 while($Row  = DB_Row())
    138 {
    139   echo($Row['second_name'].' '.$Row['first_name'].'<br>');
     132echo('<strong>Dlužníci:</strong><br><span style="font-size: smaller;">');
     133$DbResult = $Database->select('users', 'CONCAT(second_name, " ", first_name) as fullname', 'cash<0 ORDER BY cash');
     134while($Row = $DbResult->fetch_array())
     135{
     136  echo($Row['fullname'].'<br>');
    140137}
    141138echo('</span>');
    142 ?>
    143 
    144 </td></tr></table>
    145 <?
    146 
    147 // Zobrazení èasu bìhu poèítaèe
     139
     140echo('</td></tr></table>');
     141
     142// Zobrazení času běhu počítače
    148143$Data = explode(' ',exec('uptime'));
    149144$Data = array_slice($Data,3,-8);
    … …  
    160155$Uptime = str_replace('day,','den a',$Uptime);
    161156$Uptime = str_replace('min,','minut',$Uptime);
    162 echo('Server bì¾í '.$Uptime);
    163 
    164 ?>
    165 </td><td width="50%" valign="top" style="font-size: smaller;">
    166 <?
    167 
     157echo('Server běží '.$Uptime);
     158
     159echo('</td><td width="50%" valign="top" style="font-size: smaller;">');
     160
     161/*
    168162$File = fopen('/tmp/temperature2','r');
    169163$Teplota = fgets($File);
    170164$Teplota = round($Teplota*10)/10;
    171165fclose($File);
    172 
    173 
    174 echo('<table width="100%"><tr><td><strong>Aktuálnì:</strong></td><td align="right">
     166*/
     167$Teplota = 0;
     168
     169echo('<table width="100%"><tr><td><strong>Aktuálně:</strong></td><td align="right">
    175170<img alt="Teplomer" width="10" height="18" src="images/teplomer3.png"><a href="statistic/trafficview2.php?type=temp">'.$Teplota
    176171.'°C (mimo provoz)</a></td></tr></table>');
    … …  
    180175
    181176echo('<div onmouseout="skryj(predchozi)">');
     177
    182178function ShowNews($Category)
    183179{
    184   global $NewsCategoryNames, $NewsCountPerCategory, $UploadedFilesFolder;
    185 
    186   DB_Select('news_category', '*', 'id='.$Category);
    187   $Row = DB_Row();
     180  global $Database, $NewsCategoryNames, $NewsCountPerCategory, $UploadedFilesFolder;
     181
     182  $DbResult = $Database->select('news_category', '*', 'id='.$Category);
     183  $Row = $DbResult->fetch_array();
    188184  echo('<table cellspacing="0" cellpadding="0" border="0" width="100%" style="font-size: small; padding-bottom: 5px;"><tr>');
    189185  echo('<td width="40%">'.$Row['caption'].'</td><td width="80%" align="right">');
    190   echo('<a href="aktuality/index.php?category='.$Category.'">Zobrazit v¹echny aktuality</a>&nbsp;');
    191   if($Row['permission'] == 1) echo('<a href="aktuality/index.php?action=add&amp;category='.$Category.'">Pøidat aktualitu</a>&nbsp;');
     186  echo('<a href="aktuality/index.php?category='.$Category.'">Zobrazit všechny aktuality</a>&nbsp;');
     187  if($Row['permission'] == 1) echo('<a href="aktuality/index.php?action=add&amp;category='.$Category.'">Přidat aktualitu</a>&nbsp;');
    192188  echo('</td></tr><tr><td colspan="2">');
    193189  echo('<table cellspacing="0" width="100%" style="padding: 2px 2px 2px 2px; font-size: small; border-style: solid; border-color: red; border-width: 1; background-color: #FFF0F0;">');
    194   DB_Query('SELECT * FROM news WHERE category='.$Category.' ORDER BY date DESC LIMIT 0,'.$NewsCountPerCategory);
     190  $DbResult = $Database->select('news', '*', 'category='.$Category.' ORDER BY date DESC LIMIT 0,'.$NewsCountPerCategory);
    195191//echo('<table cellpadding="0" cellspacing="0" width="100%"><tr><td>');
    196192  $Index = 0;
    197193  $FontSize = 12;
    198   while($Row  = DB_Row())
     194  while($Row = $DbResult->fetch_array())
    199195  {
    200196    echo('<tr><td onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table cellspacing="0" cellpadding="0" style="padding: 0px; margin: 0px; font-size: small; color: red;" width="100%">
    … …  
    205201      if($Row['enclosure'] != '')
    206202      {
    207         echo('<br>Pøílohy: ');
     203        echo('<br>Přílohy: ');
    208204        $Enclosures = explode(';', $Row['enclosure']);
    209205         foreach($Enclosures as $Enclosure)
    … …  
    230226ShowNews(10);
    231227
    232 echo('<a href="aktuality/subscription.php"><img style="margin: 0px 0px 0px 0px;" border="0" src="images/rss20.png" alt="Aktuality pøes RSS"></a>  <a href="aktuality/subscription.php">Automatické sledování novinek</a>');
     228echo('<a href="aktuality/subscription.php"><img style="margin: 0px 0px 0px 0px;" border="0" src="images/rss20.png" alt="Aktuality přes RSS"></a>  <a href="aktuality/subscription.php">Automatické sledování novinek</a>');
    233229
    234230//echo('</td></tr></table>'
    235 ?>
    236 </div></td></tr></table>
    237 <?
     231echo('</div></td></tr></table>');
    238232//if(IsInternetAddr()) echo('Internet'); else echo('LAN');
    239233
Note: See TracChangeset for help on using the changeset viewer.