source: index.php@ 141

Last change on this file since 141 was 141, checked in by george, 18 years ago

Opraveno: Výběry oddělené databáze characters

File size: 4.7 KB
Line 
1<?php
2
3function Events()
4{
5 global $Database;
6 $Database->select_db('mangos');
7 $DbResult = $Database->select('game_event', '*,UNIX_TIMESTAMP(start) as start', 'end > NOW() AND start < NOW()');
8 $Result = '<strong>Probíhající události ve høe:</strong><br>';
9 while($Row = $DbResult->fetch_array())
10 {
11 $Start = floor((time() - $Row['start']) / ($Row['occurence'] * 60)) * $Row['occurence'] + $Row['start'];
12 $End = $Start + $Row['length'] * 60;
13 $Result .= $Row['description'].' '.date('H:i:s j.n.Y', $Start).' '.date('H:i:s j.n.Y', $End).'<br>';
14 }
15
16 return($Result);
17}
18
19include('global.php');
20include('news.php');
21ShowHeader();
22echo('<TABLE width="100%" border="0">
23 <TR>
24 <TD id="MainCell" valign="top">
25<div>
26Vítejte na serveru <span class="Nadpis">Heroes of Fantasy</span>, neoficiálním herním serveru hry <a href="http://www.worldofwarcraft.com/">World of Warcraft</a>!<br>
27WoW je <acronym title="Massive Multiplayer Online Role Playing Game">MMORPG</acronym> její¾ tvùrcem je spoleènost <a href="http://www.blizzard.com/">Blizzard Entertainment</a>.
28Existují oficiální servery, na kterých je nutno platit mìsíèní poplatek. Tento server je v¹ak neoficiální a mù¾ete zde hrát zdarma. Pøesto¾e neoficiální servery nikdy nedosáhnou takové kvality jako oficiální, mù¾ete zde za¾ít mnoho pøíjemných chvil a seznámit se zajímavými lidmi.
29Nyní je ji¾ potøeba se jenom zaregistrovat, pøipojit do hry a v¾ít se do role hrdiny, který putuje svìtem fantasie a utkává se v boji s rozliènými stvùrami.
30</div>
31<table id="SplitTable" cellspacing="5" cellpadding="0" width="100%">
32<tr><td width="60%" valign="top">');
33
34
35echo(ShowNews());
36echo('
37</td><td id="EmuInfo" valign="top">');
38
39// Second column
40
41//echo(Events());
42
43echo('<br>
44<div align="center">
45<table class="MiniTable" border="1" cellspacing="0" cellpadding="2">
46<tr><th>Emulátor</th><td>MaNGOS</td></tr>
47<tr><th>Verze hry</th><td>');
48echo($Config['Mangos']['ClientVersion']);
49echo('</td></tr>'.
50'<tr><th>Stav</th><td>');
51if(CheckPortStatus($WoWServer, 8085)) echo('<span style="color: #33ff33;">ONLINE</span>');
52 else echo('<span style="color: red;">OFFLINE</span>');
53echo('</td></tr>
54<tr><th>Online hráèù</th><td><a href="http://'.$WoWServer.'/online_player.php">');
55
56$Database->select_db('realmd');
57$Result = $Database->select('account', 'COUNT(*)', 'online=1');
58$Row = $Result->fetch_array();
59$PlayersOnlineCount = $Row[0];
60echo($PlayersOnlineCount);
61
62echo('</a></td></tr>
63
64<tr><th>Návod</th><td><a href="jak_zacit.php">zde</a></td></tr>
65<tr><th>Stav registrací</th><td>');
66include('registrace/reg_config.php');
67$Database->select_db('realmd');
68$DbResult = $Database->query('SELECT COUNT(*) FROM account');
69$Row = $DbResult->fetch_array();
70$AccountCount = $Row[0];
71$Remain = $MaximumAccountCount-$AccountCount;
72if($Remain <= 0) echo('VYÈERPANÉ'); else echo('VOLNÉ');
73echo('</td></tr>
74<tr><th>Registrace</th><td>');
75echo('<a href="'.$BaseUrl.'registrace/">zde</a>');
76echo('</td></tr>
77<tr><th>Správa úètu</th><td>');
78echo('<a href="'.$BaseUrl.'minimanager/">zde</a>');
79echo('</td></tr>
80<tr><th>Existuje dnù</th><td>');
81echo(round((time()-mktime (0,0,0,4,21,2007))/3600/24));
82echo('</td></tr>
83<tr><th>Úètù</th><td>');
84
85$Database->select_db('realmd');
86$Result = $Database->select('account', 'COUNT(*)');
87$Row = $Result->fetch_array();
88$AccountCount = $Row[0];
89echo($AccountCount);
90
91echo('</td></tr>
92<tr><th>Postav</th><td>');
93
94$Database->select_db('characters');
95$Result = $Database->select('character', 'COUNT(*)');
96$Row = $Result->fetch_array();
97$CharactersCount = $Row[0];
98echo($CharactersCount);
99
100echo('</td></tr>
101</table>
102</div>
103<br>');
104
105echo('<div>
106RSS kanál diskusního fóra: <a href="forum/smartfeed_url.php"><img src="forum/templates/subSilver/images/rss20.png" alt="RSS"></a><br />
107Teamspeek server: ts2.shotzone.cz:9207<br />
108Projekt pøekládání questù: <a href="quests/">Questy</a><br>
109Informace pro zájemce o GM: <a href="http://wow.zdechov.net/forum/viewtopic.php?p=5443">zde</a><br>
110Grafická statistika serveru: <a href="http://game-server.zdechov.net/statistic/">zde</a>
111</div>');
112//Dotazník pro nové Administrátory: <a href="FormGM/">Dotazník</a>
113
114echo('
115<br>
116<a href="gm.php">Administrátoøi</a>
117<div>');
118
119 //include('administrace/SubFiles/DatabaseConection.php');
120 $Database->select_db('wow');
121 $Result = $Database->select('user', '*', 'ban = 0 ORDER BY id');
122 while($Row = $Result->fetch_array())
123 echo($Row['User'].' - '.$Row['Function'].'<br/>');
124
125echo('</div>
126
127</td></tr></table>
128<br>
129<a href="http://www.wowstatus.net/detail.php?server=160156">
130<img alt="wowstatus" src="http://www.wowstatus.net/sbanner.php?server=160156" border="0"></a>
131
132<A HREF="http://www.toplist.cz/" target="_blank"><IMG
133SRC="http://toplist.cz/count.asp?logo=mc&amp;ID=324802"
134border="0" width="88" height="60" alt="counter"></A>
135
136</TABLE>');
137
138 ShowFooter();
139?>
Note: See TracBrowser for help on using the repository browser.