Changeset 11


Ignore:
Timestamp:
Aug 11, 2007, 12:04:22 AM (17 years ago)
Author:
george
Message:

Sjednocení parametrů připojení k databázi do jednoho souboru config.php.
Přepsání všech cest na relativní.
Přidání parametru BaseUrl do souboru config.php.

Files:
4 added
2 deleted
19 edited

Legend:

Unmodified
Added
Removed

  • administrace/SubFiles/LoginMaster.php

    r5 r11  
    11<?php
     2
     3require_once('../../config.php');
     4
    25  $User = $_POST['user'];
    36  $Pass = $_POST['pass'];
    47
    58    include 'SubFiles/DatabaseConection.php';
    6     $Database = new Database('localhost','root','gurubashi'); // dodìlat IP
     9    $Database = new Database($DatabaseHost, $DatabaseUser, $DatabasePassword);
    710    $Database->SelectDatabase('wow');
    811   

  • administrace/borec/GMlog.php

    r5 r11  
    11<?php
    2        include '../SubFiles/TestLicence.php';
     2
     3$GmCommandsLogFile = '/a/log/gm_commands.log';
     4include('../SubFiles/TestLicence.php');
    35?>
    46<TABLE width="100%" border="0">
    … …  
    79<TD  width="100%" valign="top">
    810
    9 <?
     11<?php
     12$File = fopen($GmCommandsLogFile, 'r');
     13if($File)
     14{
     15  while(!feof($File)) echo(substr(fgets($File), 0).'<br>');
     16  fclose($File);
     17} 
    1018
    11 $File = fopen('c:\Mangos\Used_GM_Commands.log', 'r');
    12 fgets($File);
    13 while(!feof($File))
    14 echo(substr(fgets($File), 0).'<br>');
    1519?>
     20
    1621</table>

  • administrace/borec/zaznamPovolenychRegistraci.php

    r5 r11  
    11<?php
    2        include '../SubFiles/TestLicence.php';
     2  include '../SubFiles/TestLicence.php';
     3  include('../../config.php');
    34?>
    45<TABLE width="100%" border="0">
    … …  
    78<TD  width="100%" valign="top">
    89
    9 <?
     10<?php
    1011
    11 $File = fopen('c:\www\LockRegistration\záznam.log', 'r');
    12 fgets($File);
    13 while(!feof($File))
    14 echo(substr(fgets($File), 0).'<br>');
     12echo(str_replace("\n", '<br>', (file_get_contents('../../registrace/LockRegistration/záznam.log'))));
     13
    1514?>
    1615</table>

  • administrace/george/gm_news.php

    r5 r11  
    11<?
    22include_once('db.php');
    3 DB_Init('localhost', 'root','gurubashi', 'wow');
     3include('../../config.php');
     4DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'wow');
    45//DB_Query('SET CHARACTER SET cp1250');
    56

  • administrace/george/list_tele.php

    r5 r11  
    11<?
    22include_once('db.php');
    3 DB_Init('localhost', 'root', '', 'mangos');
     3include('../../config.php');
     4DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'mangos');
    45DB_Query('SET CHARACTER SET cp1250');
    56

  • administrace/george/optimalize.php

    r5 r11  
    11<?php
    22include_once('db.php');
     3include_once('../../config.php');
    34
    45function OptimalizeDb($Database, $Op)
    56{
     7  global $DatabaseHost, $DatabaseUser, $DatabasePassword;
    68  echo('Databáze '.$Database.'...<br><table>');
    7   DB_Init('localhost', 'root', 'gurubashi', $Database);
     9  DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, $Database);
    810  DB_Query('SHOW TABLES');
    911  while($Table = DB_Row())

  • administrace/george/restarty.php

    r5 r11  
    22
    33include_once('db.php');
     4include_once('../../config.php');
    45echo('<strong>Posledních 10 restartù MaNGOSu:</strong><br>');
    56echo('<div style="font-size: small;">');
    6 DB_Init('localhost', 'root','gurubashi', 'wow');
     7DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'wow');
    78DB_Select('mangos_restart', '*', '1 ORDER BY time DESC LIMIT 10');
    89while($Row = DB_Row())

  • administrace/george/rss.php

    r5 r11  
    33
    44include_once('db.php');
     5include_once('../../config.php');
    56include_once('rss_generator.php');
    6 DB_Init('localhost', 'root', '', 'wow');
     7DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'wow');
    78DB_Query('SET CHARACTER SET latin2');
    89

  • administrace/listmessage.php

    r5 r11  
    11<?php
    2        include 'SubFiles/TestLicence.php';
    32
    4     include 'SubFiles/DatabaseConection.php';
    5   $Database2 = new Database('localhost','root','gurubashi'); // dodìlat IP
    6   $Database2->SelectDatabase('wow');
     3include 'SubFiles/TestLicence.php';
     4include 'SubFiles/DatabaseConection.php';
     5include('../config.php');
     6
     7$Database2 = new Database($DatabaseHost, $DatabaseUser, $DatabasePassword); // dodìlat IP
     8$Database2->SelectDatabase('wow');
     9
    710?>
     11
    812<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    913<html>

  • administrace/master.php

    r5 r11  
    11<?php
     2include('../config.php');
    23        // Test zda je registrovaný uživatel
    34        session_start();
    … …  
    7273              <A href="borec/cheat.php">cheat</A>
    7374              <br>Návody
    74               <A href="/navody/">zde</A>
     75              <A href="../navody/">zde</A>
    7576              <br>Povolené Registrace:
    7677              <A href="borec/zaznamPovolenychRegistraci.php">zde</A>
    … …  
    9091          <td valign="top">
    9192<?php
    92   $Database2 = new Database('localhost','root','gurubashi'); // dodìlat IP
     93  $Database2 = new Database($DatabaseHost, $DatabaseUser, $DatabasePassword); // dodìlat IP
    9394  $Database2->SelectDatabase('mangos');
    9495
    … …  
    138139        <TD width="100%" valign="top">
    139140          <form action="george/gm_news.php?action=add" method="post">
    140             Jste pøihlá‘en jako:
     141            Jste pøihlášen jako:
    141142            <b>
    142143              <?php echo @$_SESSION['User']; ?></b>

  • config.sample.php

    r10 r11  
    1010$DatabaseHost = 'localhost';
    1111$Charset = 'windows-1250';
     12$BaseUrl = '/';
    1213
    1314?>

  • css/style.css

    r5 r11  
    66  height: 100%;
    77  width: 1005;
    8   background-image: url(/Background.JPG);
     8  background-image: url(images/background.jpg);
    99  background-repeat: no-repeat;
    1010  border= 0;
    … …  
    107107   font-family: Comic Sans MS;
    108108}
    109 .TAbleGuilda{
     109.TableGuilda {
    110110   color: white;
    111111   font-size: small;
     112   text-align: center;
    112113}
    113114.TdGuilda{

  • donate.php

    r5 r11  
    1 <?
     1<?php
    22  include('global.php');
    33  ShowHeader();
    … …  
    2020<br>
    2121       
    22 <?php include('finance/index.php'); ?>
     22<?php
     23include('finance/index.php');
     24?>
    2325
    2426</table>
    2527
    26 <?
     28<?php
    2729  ShowFooter();
    2830?>

  • global.php

    r8 r11  
    1 <?
     1<?php
    22
    33include('config.php');
    … …  
    4141function ShowHeader()
    4242{
    43   global $Charset;
     43  global $Charset, $BaseUrl;
    4444  echo('
    4545<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    … …  
    4949  <META http-equiv="Content-Type" content="text/html; charset='.$Charset.'">
    5050  <META HTTP-EQUIV="Expires" CONTENT="Mon, 06 Jan 1990 00:00:01 GMT">
    51   <link rel="SHORTCUT ICON" href="/images/favicon.ico">
     51  <link rel="SHORTCUT ICON" href="images/favicon.ico">
    5252  <TITLE>WoW server Heroes of Fantasy</TITLE>
    53   <style type="text/css" media="screen">@import url(/css/style.css);</style>
     53  <style type="text/css" media="screen">@import url('.$BaseUrl.'css/style.css);</style>
    5454</HEAD> 
    5555
    … …  
    7373}
    7474imgsrc = new Array();
    75 imgsrc[1] = "/images/home.jpg";
    76 imgsrc[2] = "/images/home2.jpg";
    77 imgsrc[3] = "/images/donate.jpg";
    78 imgsrc[4] = "/images/donate2.jpg";
    79 imgsrc[5] = "/images/download.jpg";
    80 imgsrc[6] = "/images/download2.jpg";
    81 imgsrc[7] = "/images/forum.jpg";
    82 imgsrc[8] = "/images/forum2.jpg";
    83 imgsrc[9] = "/images/guilds.jpg";
    84 imgsrc[10] = "/images/guilds2.jpg";
    85 imgsrc[11] = "/images/honor.jpg";
    86 imgsrc[12] = "/images/honor2.jpg";
    87 imgsrc[13] = "/images/how.jpg";
    88 imgsrc[14] = "/images/how2.jpg";
    89 imgsrc[15] = "/images/link.jpg";
    90 imgsrc[16] = "/images/link2.jpg";
    91 imgsrc[17] = "/images/mapa.jpg";
    92 imgsrc[18] = "/images/mapa2.jpg";
    93 imgsrc[19] = "/images/online_player.jpg";
    94 imgsrc[20] = "/images/online_player2.jpg";
    95 imgsrc[21] = "/images/povolani.jpg";
    96 imgsrc[22] = "/images/povolani2.jpg";
    97 imgsrc[23] = "/images/profese.jpg";
    98 imgsrc[24] = "/images/profese2.jpg";
    99 imgsrc[25] = "/images/rasy.jpg";
    100 imgsrc[26] = "/images/rasy2.jpg";
    101 imgsrc[27] = "/images/registrace.jpg";
    102 imgsrc[28] = "/images/registrace2.jpg";
    103 imgsrc[29] = "/images/server.jpg";
    104 imgsrc[30] = "/images/server2.jpg";
     75imgsrc[1] = "'.$BaseUrl.'images/home.jpg";
     76imgsrc[2] = "'.$BaseUrl.'images/home2.jpg";
     77imgsrc[3] = "'.$BaseUrl.'images/donate.jpg";
     78imgsrc[4] = "'.$BaseUrl.'images/donate2.jpg";
     79imgsrc[5] = "'.$BaseUrl.'images/download.jpg";
     80imgsrc[6] = "'.$BaseUrl.'images/download2.jpg";
     81imgsrc[7] = "'.$BaseUrl.'images/forum.jpg";
     82imgsrc[8] = "'.$BaseUrl.'images/forum2.jpg";
     83imgsrc[9] = "'.$BaseUrl.'images/guilds.jpg";
     84imgsrc[10] = "'.$BaseUrl.'images/guilds2.jpg";
     85imgsrc[11] = "'.$BaseUrl.'images/honor.jpg";
     86imgsrc[12] = "'.$BaseUrl.'images/honor2.jpg";
     87imgsrc[13] = "'.$BaseUrl.'images/how.jpg";
     88imgsrc[14] = "'.$BaseUrl.'images/how2.jpg";
     89imgsrc[15] = "'.$BaseUrl.'images/link.jpg";
     90imgsrc[16] = "'.$BaseUrl.'images/link2.jpg";
     91imgsrc[17] = "'.$BaseUrl.'images/mapa.jpg";
     92imgsrc[18] = "'.$BaseUrl.'images/mapa2.jpg";
     93imgsrc[19] = "'.$BaseUrl.'images/online_player.jpg";
     94imgsrc[20] = "'.$BaseUrl.'images/online_player2.jpg";
     95imgsrc[21] = "'.$BaseUrl.'images/povolani.jpg";
     96imgsrc[22] = "'.$BaseUrl.'images/povolani2.jpg";
     97imgsrc[23] = "'.$BaseUrl.'images/profese.jpg";
     98imgsrc[24] = "'.$BaseUrl.'images/profese2.jpg";
     99imgsrc[25] = "'.$BaseUrl.'images/rasy.jpg";
     100imgsrc[26] = "'.$BaseUrl.'images/rasy2.jpg";
     101imgsrc[27] = "'.$BaseUrl.'images/registrace.jpg";
     102imgsrc[28] = "'.$BaseUrl.'images/registrace2.jpg";
     103imgsrc[29] = "'.$BaseUrl.'images/server.jpg";
     104imgsrc[30] = "'.$BaseUrl.'images/server2.jpg";
    105105if (getAppVersion()) {
    106106img = new Array();
    … …  
    130130function ShowFooter()
    131131{
     132  global $BaseUrl;
    132133  echo('
    133134    </td>
    … …  
    143144echo('
    144145<br>
    145 <a href="/index.php" onMouseOver="swtch(&quot;2&quot;,&quot;home&quot;)" onMouseOut="swtch(&quot;1&quot;,&quot;home&quot;)"><IMG SRC="/images/home.jpg" name="home" alt="Home" border="0"></A><a href="/server.php" onMouseOver="swtch(&quot;30&quot;,&quot;Server&quot;)" onMouseOut="swtch(&quot;29&quot;,&quot;Server&quot;)"><IMG SRC="/images/server.jpg" name="Server" alt="Server" border="0"></A><a href="/donate.php" onMouseOver="swtch(&quot;4&quot;,&quot;donate&quot;)" onMouseOut="swtch(&quot;3&quot;,&quot;donate&quot;)"><IMG SRC="/images/donate.jpg" alt="donate" name="donate" border="0"></A><a href="/download_soubory/" onMouseOver="swtch(&quot;6&quot;,&quot;download&quot;)" onMouseOut="swtch(&quot;5&quot;,&quot;download&quot;)"><IMG SRC="/images/download.jpg" alt="download" name="download" border="0"></A><a href="/jak_zacit.php" onMouseOver="swtch(&quot;14&quot;,&quot;how&quot;)" onMouseOut="swtch(&quot;13&quot;,&quot;how&quot;)"><IMG SRC="/images/how.jpg" alt="how" name="how" border="0"></A><a href="/link.php" onMouseOver="swtch(&quot;16&quot;,&quot;link&quot;)" onMouseOut="swtch(&quot;15&quot;,&quot;link&quot;)"><IMG SRC="/images/link.jpg" alt="link" name="link" border="0"></A><a href="/mapa.php" onMouseOver="swtch(&quot;18&quot;,&quot;mapa&quot;)" onMouseOut="swtch(&quot;17&quot;,&quot;mapa&quot;)"><IMG SRC="/images/mapa.jpg" alt="mapa" name="mapa" border="0"></A><a href="/guildy.php" onMouseOver="swtch(&quot;10&quot;,&quot;guildy&quot;)" onMouseOut="swtch(&quot;9&quot;,&quot;guildy&quot;)"><IMG SRC="/images/guilds.jpg" alt="guildy" name="guildy" border="0"></A><a href="/forum/" onMouseOver="swtch(&quot;8&quot;,&quot;Forum&quot;)" onMouseOut="swtch(&quot;7&quot;,&quot;Forum&quot;)"><IMG SRC="/images/forum.jpg" alt="Forum" name="Forum" border="0"></A><a href="/registrace/" onMouseOver="swtch(&quot;28&quot;,&quot;registrace&quot;)" onMouseOut="swtch(&quot;27&quot;,&quot;registrace&quot;)"><IMG SRC="/images/registrace.jpg" alt="registrace" name="registrace" border="0"></A><a href="/online_player.php" onMouseOver="swtch(&quot;20&quot;,&quot;online_player&quot;)" onMouseOut="swtch(&quot;19&quot;,&quot;online_player&quot;)"><IMG SRC="/images/online_player.jpg" alt="online player" name="online_player" border="0"></A><a href="/honor.php" onMouseOver="swtch(&quot;12&quot;,&quot;honor&quot;)" onMouseOut="swtch(&quot;11&quot;,&quot;honor&quot;)"><IMG SRC="/images/honor.jpg" alt="honor" name="honor" border="0"></A><a href="/Death%20Dealers%20Hratelne%20Rasy.php" onMouseOver="swtch(&quot;26&quot;,&quot;Rasy&quot;)" onMouseOut="swtch(&quot;25&quot;,&quot;Rasy&quot;)"><IMG SRC="/images/rasy.jpg" alt="Rasy" name="Rasy" border="0"></A><a href="/Death%20Dealers%20Povolani.php" onMouseOver="swtch(&quot;22&quot;,&quot;Povolani&quot;)" onMouseOut="swtch(&quot;21&quot;,&quot;Povolani&quot;)"><IMG SRC="/images/povolani.jpg" alt="Povolani" name="Povolani" border="0"></A><a href="/Death%20Dealers%20Profese.php" onMouseOver="swtch(&quot;24&quot;,&quot;profese&quot;)" onMouseOut="swtch(&quot;23&quot;,&quot;profese&quot;)"><IMG SRC="/images/profese.jpg" alt="profese" name="profese" border="0"></A>
     146<a href="'.$BaseUrl.'index.php" onMouseOver="swtch(&quot;2&quot;,&quot;home&quot;)" onMouseOut="swtch(&quot;1&quot;,&quot;home&quot;)"><IMG SRC="'.$BaseUrl.'images/home.jpg" name="home" alt="Home" border="0"></A>
     147<a href="'.$BaseUrl.'server.php" onMouseOver="swtch(&quot;30&quot;,&quot;Server&quot;)" onMouseOut="swtch(&quot;29&quot;,&quot;Server&quot;)"><IMG SRC="'.$BaseUrl.'images/server.jpg" name="Server" alt="Server" border="0"></A>
     148<a href="'.$BaseUrl.'donate.php" onMouseOver="swtch(&quot;4&quot;,&quot;donate&quot;)" onMouseOut="swtch(&quot;3&quot;,&quot;donate&quot;)"><IMG SRC="'.$BaseUrl.'images/donate.jpg" alt="donate" name="donate" border="0"></A>
     149<a href="'.$BaseUrl.'download_soubory/" onMouseOver="swtch(&quot;6&quot;,&quot;download&quot;)" onMouseOut="swtch(&quot;5&quot;,&quot;download&quot;)"><IMG SRC="'.$BaseUrl.'images/download.jpg" alt="download" name="download" border="0"></A>
     150<a href="'.$BaseUrl.'jak_zacit.php" onMouseOver="swtch(&quot;14&quot;,&quot;how&quot;)" onMouseOut="swtch(&quot;13&quot;,&quot;how&quot;)"><IMG SRC="'.$BaseUrl.'images/how.jpg" alt="how" name="how" border="0"></A>
     151<a href="'.$BaseUrl.'link.php" onMouseOver="swtch(&quot;16&quot;,&quot;link&quot;)" onMouseOut="swtch(&quot;15&quot;,&quot;link&quot;)"><IMG SRC="'.$BaseUrl.'images/link.jpg" alt="link" name="link" border="0"></A>
     152<a href="'.$BaseUrl.'mapa.php" onMouseOver="swtch(&quot;18&quot;,&quot;mapa&quot;)" onMouseOut="swtch(&quot;17&quot;,&quot;mapa&quot;)"><IMG SRC="'.$BaseUrl.'images/mapa.jpg" alt="mapa" name="mapa" border="0"></A>
     153<a href="'.$BaseUrl.'guildy.php" onMouseOver="swtch(&quot;10&quot;,&quot;guildy&quot;)" onMouseOut="swtch(&quot;9&quot;,&quot;guildy&quot;)"><IMG SRC="'.$BaseUrl.'images/guilds.jpg" alt="guildy" name="guildy" border="0"></A>
     154<a href="'.$BaseUrl.'forum/" onMouseOver="swtch(&quot;8&quot;,&quot;Forum&quot;)" onMouseOut="swtch(&quot;7&quot;,&quot;Forum&quot;)"><IMG SRC="'.$BaseUrl.'images/forum.jpg" alt="Forum" name="Forum" border="0"></A>
     155<a href="'.$BaseUrl.'registrace/" onMouseOver="swtch(&quot;28&quot;,&quot;registrace&quot;)" onMouseOut="swtch(&quot;27&quot;,&quot;registrace&quot;)"><IMG SRC="'.$BaseUrl.'images/registrace.jpg" alt="registrace" name="registrace" border="0"></A>
     156<a href="'.$BaseUrl.'online_player.php" onMouseOver="swtch(&quot;20&quot;,&quot;online_player&quot;)" onMouseOut="swtch(&quot;19&quot;,&quot;online_player&quot;)"><IMG SRC="'.$BaseUrl.'images/online_player.jpg" alt="online player" name="online_player" border="0"></A>
     157<a href="'.$BaseUrl.'honor.php" onMouseOver="swtch(&quot;12&quot;,&quot;honor&quot;)" onMouseOut="swtch(&quot;11&quot;,&quot;honor&quot;)"><IMG SRC="'.$BaseUrl.'images/honor.jpg" alt="honor" name="honor" border="0"></A>
     158<a href="'.$BaseUrl.'Death%20Dealers%20Hratelne%20Rasy.php" onMouseOver="swtch(&quot;26&quot;,&quot;Rasy&quot;)" onMouseOut="swtch(&quot;25&quot;,&quot;Rasy&quot;)"><IMG SRC="'.$BaseUrl.'images/rasy.jpg" alt="Rasy" name="Rasy" border="0"></A>
     159<a href="'.$BaseUrl.'Death%20Dealers%20Povolani.php" onMouseOver="swtch(&quot;22&quot;,&quot;Povolani&quot;)" onMouseOut="swtch(&quot;21&quot;,&quot;Povolani&quot;)"><IMG SRC="'.$BaseUrl.'images/povolani.jpg" alt="Povolani" name="Povolani" border="0"></A>
     160<a href="'.$BaseUrl.'Death%20Dealers%20Profese.php" onMouseOver="swtch(&quot;24&quot;,&quot;profese&quot;)" onMouseOut="swtch(&quot;23&quot;,&quot;profese&quot;)"><IMG SRC="'.$BaseUrl.'images/profese.jpg" alt="profese" name="profese" border="0"></A>
    146161
    147162
    … …  
    173188      <DIV class="DivPaticka">
    174189       <I class="Paticka">
    175    <A href="/administrace/" class="Paticka">#</A>
    176       | Web designer: maron | e-mail: maron2@centrum.cz |  Poèet pøístupù: <A HREF="http://counter.cnw.cz/" TARGET=_parent>
     190   <A href="administrace/" class="Paticka">#</A>
     191      | Správce server: Chronos |  Poèet pøístupù: <A HREF="http://counter.cnw.cz/" TARGET=_parent>
    177192      <IMG SRC="http://counter.cnw.cz/monika.cgi?wowzdechov&amp;5&amp;000000&amp;FFFFFF&amp;on" BORDER=0 ALT="CNW:Counter"></A><SCRIPT type="JavaScript">
    178193      <!--

  • gm.php

    r5 r11  
    1818<?php
    1919    include 'administrace/SubFiles/DatabaseConection.php';
    20     $Database = new Database('localhost','root','gurubashi');
     20    $Database = new Database($DatabaseHost, $DatabaseUser, $DatabasePassword);
    2121    $Database->SelectDatabase('wow');
    2222

  • guildy.php

    r8 r11  
    1919if(!array_key_exists('guild', $_GET))
    2020{
    21   echo('<h3>Seznam guild:</h3>');
    22   echo('<div align="center"><table class="TableGuilda" style="align: center;" border="1" cellpadding="3" cellspacing="0" ><tr><th>Název</th><th>Poèet èlenù</th><th>Souèet levelù</th><th>Souèet bodù cti</th><th>Webové stránky</th></tr>');
     21  echo('<div align="center"><strong>Seznam guild:</strong>');
     22  echo('<table class="TableGuilda" style="align: center;" border="1" cellpadding="3" cellspacing="0" ><tr><th>Název</th><th>Poèet èlenù</th><th>Souèet levelù</th><th>Souèet bodù cti</th><th>Webové stránky</th></tr>');
    2323//  DB_Query(' COUNT(guild_member.guildid) as member_count FROM guild JOIN guild_member ON guild_member.guildid = guild.guildid GROUP BY guild.name ORDER BY member_count DESC');
    2424  DB_Query('SELECT `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` GROUP BY guild.name ORDER BY guild.name');
    … …  
    3030} else {
    3131  $_GET['guild'] = addslashes($_GET['guild']);
    32   DB_Query('SELECT `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$_GET['guild'].' GROUP BY guild.name');
     32  DB_Query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$_GET['guild'].' GROUP BY guild.name');
    3333  if(DB_NumRows() > 0)
    3434  {
    … …  
    3636    //  if($Guild['homepage'] != '') $Guild['name'] = $Guild['name'].' <a href="'.$Guild['homepage'].'">WWW</a>';
    3737    //if($Guild['info'] != '') $Guild['info'] = ''.$Guild['info'].'</i>';
    38     echo('<h3>Seznam èlenù guildy '.$Guild['name'].':</h3>');
    39     echo('<div align="center"><table class="TableGuilda" border="1" cellpadding="1" cellspacing="0">');
     38    echo('<div align="center"><strong>Seznam èlenù guildy '.$Guild['name'].'</strong><br>');
     39    DB_Select('`character`', 'name', $Guild['leaderguid'].'=guid');
     40    $GuildMaster = DB_Row();
     41    echo('Vedoucí guildy: '.$GuildMaster['name'].'<br>');
     42    echo('<table class="TableGuilda" border="1" cellpadding="1" cellspacing="0">');
    4043    echo('<tr><th>Jméno</th><th>Level</th><th>Hodnost</th><th>Body cti</th></tr>');
    4144    //echo('<tr><td colspan="2" Class="TdGuilda">Informace: '.$Guild['public_info'].'</td></tr>');

  • index.php

    r5 r11  
    3737<tr>
    3838<td>MaNGOS TBC</td>
    39 <td><? if(CheckPortStatus($WoWServer, 8085)) echo('<span style="color: #33ff33;">ONLINE</span>'); else echo('<span style="color: red;">OFFLINE</span>'); ?></td>
     39<td><?php if(CheckPortStatus($WoWServer, 8085)) echo('<span style="color: #33ff33;">ONLINE</span>'); else echo('<span style="color: red;">OFFLINE</span>'); ?></td>
    4040<td><a href="<?php echo('http://'.$WoWServer); ?>/online_player.php"><? echo(file_get_contents('http://'.$WoWServer.'/mangos/players.php')); ?></a></td>
    4141<td><a href="jak_zacit.php">zde</a></td>
    42 <td><?  include('registrace/LockRegistration/script.php');
    43         AdresaRegistrace();
     42<td><?php echo('<a href="'.$BaseUrl.'registrace/">zde</a>');
     43 //include('registrace/LockRegistration/script.php');
     44        //AdresaRegistrace();
    4445       ?></td>
    45 <td><? StafRegistraci(); 
     46<td><?php echo('POVOLENÉ');
     47//StafRegistraci(); 
    4648?></td>
    47 <td><? echo(round((time()-mktime (0,0,0,4,21,2007))/3600/24)); ?></td>
    48 <td><? echo(file_get_contents('http://'.$WoWServer.'/mangos/accounts.php')); ?></td>
    49 <td><? echo(file_get_contents('http://'.$WoWServer.'/mangos/characters.php')); ?></td>
     49<td><?php echo(round((time()-mktime (0,0,0,4,21,2007))/3600/24)); ?></td>
     50<td><?php echo(file_get_contents('http://'.$WoWServer.'/mangos/accounts.php')); ?></td>
     51<td><?php echo(file_get_contents('http://'.$WoWServer.'/mangos/characters.php')); ?></td>
    5052</tr>
    5153</table>
    … …  
    6062<div><?php
    6163    include 'administrace/SubFiles/DatabaseConection.php';
    62     $Database = new Database('localhost','root','gurubashi');
     64    $Database = new Database($DatabaseHost, $DatabaseUser, $DatabasePassword);
    6365    $Database->SelectDatabase('wow');
    6466

  • registrace/LockRegistration/script.php

    r5 r11  
    1 <?
     1<?php
     2require_once('../../config.php');
     3
     4$RegFile = 'NumberRegistration.txt';
     5
    26function StafRegistraci()
    37{
    4 $NumberRegistration = 0;
    5 $File = fopen('c:\www\registrace\LockRegistration\NumberRegistration','r');
    6 $NumberRegistration = fread($File,5);
    7 fclose($File);
     8  global $RegFile, $BaseUrl;
     9  $NumberRegistration = 0;
     10  $File = fopen($RegFile, 'r');
     11  $NumberRegistration = fread($File, 5);
     12  fclose($File);
    813
    9 if ($NumberRegistration == 'close')
    10   echo('<a href="/registrace/">Vyèerpáno</a>');
    11 else
    12   echo('Zbývá registrací: '.$NumberRegistration);
     14  if ($NumberRegistration == 'close')
     15    echo('<a href="'.$BaseUrl.'registrace/">Vyèerpáno</a>');
     16  else
     17    echo('Zbývá registrací: '.$NumberRegistration);
    1318}
    1419
    1520function AdresaRegistrace()
    1621{
    17 $NumberRegistration = 0;
    18 $File = fopen('c:\www\registrace\LockRegistration\NumberRegistration','r');
    19 $NumberRegistration = fread($File,5);
    20 fclose($File);
     22  global $RegFile, $BaseUrl;
     23  $NumberRegistration = 0;
     24  $File = fopen($RegFile, 'r');
     25  $NumberRegistration = fread($File,5);
     26  fclose($File);
    2127
    22 if ($NumberRegistration != 'close')
    23   echo('<a href="/registrace/">zde</a>');
     28  if ($NumberRegistration != 'close') echo('<a href="'.$BaseUrl.'registrace/">zde</a>');
    2429}
    2530
    2631function AdresaRegistraceRegistrace()
    2732{
    28 $NumberRegistration = 0;
    29 $File = fopen('c:\www\registrace\LockRegistration\NumberRegistration','r');
    30 $NumberRegistration = fread($File,5);
    31 fclose($File);
     33  global $RegFile, $BaseUrl;
     34  $NumberRegistration = 0;
     35  $File = fopen($RegFile, 'r');
     36  $NumberRegistration = fread($File,5);
     37  fclose($File);
    3238
    33 if ($NumberRegistration != 'close')
     39  if ($NumberRegistration != 'close')
    3440 // include('c:\www\registrace\LockRegistration\FormularRegistrace.php');
    35   echo('Registrovat se mùžete: <a href="http://wow.zdechov.net/minimanager/register.php">zde</a>');
     41    echo('Registrovat se mùžete: <a href="'.$BaseUrl.'minimanager/register.php">zde</a>');
    3642}
    3743
    3844function PovoleneRegistrace()
    3945{
    40 $NumberRegistration = 0;
    41 $File = fopen('c:\www\registrace\LockRegistration\UnlockRegistration','r');
    42 $NumberRegistration = fread($File,5);
    43 fclose($File);
    44 echo($NumberRegistration);
     46  global $RegFile;
     47  $NumberRegistration = 0;
     48  $File = fopen($RegFile, 'r');
     49  $NumberRegistration = fread($File, 5);
     50  fclose($File);
     51  echo($NumberRegistration);
    4552}
    4653?>

  • registrace/index.php

    r5 r11  
    1 <?
     1<?php
    22  include('../global.php');
    33  ShowHeader();
    … …  
    1313<br><br>
    1414
    15 Poèet povolených registrací na dnešní den: <?
    16   include('LockRegistration/script.php');
    17   PovoleneRegistrace();
     15Poèet povolených registrací na dnešní den:
     16<?php
     17  //include('LockRegistration/script.php');
     18  //PovolenychRegistraci();
     19  echo('Neomezeno');
    1820?>
    1921<br />
    20 Stav Registrací: <?
    21   StafRegistraci();
     22Stav Registrací:
     23<?php
     24  //StafRegistraci();
    2225  echo('</p>');
    23   AdresaRegistraceRegistrace();
     26  echo('Registrovat se mùžete: <a href="'.$BaseUrl.'minimanager/register.php">zde</a>');
     27  //AdresaRegistraceRegistrace();
    2428?>
    2529<P>
    … …  
    3337<br>
    3438<br />Statitiku najdete <a href="http://game-server.zdechov.net/statistic/?Measure=8">zde</a>
    35 <br>Mùžete taky pøispìt na server aby se mohl zlepšit. Stav úètu mùžete sledovat v sekci <A href="/donate.php" target="_parent">Donate</A> 
     39<br>Mùžete taky pøispìt na server aby se mohl zlepšit. Stav úètu mùžete sledovat v sekci <A href="<?php echo($BaseUrl); ?>donate.php" target="_parent">Donate</A> 
    3640<br>
    3741</P>
Note: See TracChangeset for help on using the changeset viewer.