Changeset 407


Ignore:
Timestamp:
Feb 9, 2009, 6:29:42 PM (16 years ago)
Author:
zork
Message:
 
Location:
beta
Files:
17 edited

Legend:

Unmodified
Added
Removed
  • beta/index.php

    r405 r407  
    4343  echo "<a href=\"?page=links\">Odkazy</a><br />";
    4444  echo "<a href=\"?page=online\">Online hráči</a><br />";
     45  echo "<a href=\"#\" onclick=\"window.open('../minimanager/pomm_public/pomm.php','Mapa online hráčů','width=758,height=525');return false;\">Mapa hráčů</a><br />";
    4546  echo "<a href=\"?page=guildy\">Guildy</a><br />";
    4647  echo "<a href=\"?page=gh\">Domky Guild</a><br />";
     
    9394echo "
    9495  </div>
    95   <div id=\"footer\"></div>
     96  <div id=\"footer\"><p align=center><br /><div id=copyright>Created by <strong>bbtrash</strong></div></div>
     97 
    9698</div>
     99
    97100";
    98101
  • beta/pages/acclog.php

    r405 r407  
    22
    33echo "&nbsp;<a href=\"?page=acc\">&lt;- Zpět do správy účtu</a>";
    4 $db -> select_db("realm1_realmd");
     4$db -> select_db($db_realmd);
    55echo "<center><table border=\"1\" align=\"center\" width=\"540\">
    66  <tr>
  • beta/pages/admin_finance.php

    r405 r407  
    4242if (isset($_POST["add"]) AND $lvl > 0)
    4343{
    44   $db -> select_db("wow_web");
     44  $db -> select_db($db_ghsystem);
    4545  $result =  $db -> query("INSERT INTO `dotation` ( `id` , `time` , `money` , `operation` , `description`) VALUES (NULL, '".$_POST["day"]."', '".$_POST["suma"]."', '".$_POST["kategorie"]."' , '".$_POST["popis"]."' );");
    4646  echo "Přidáno !";
  • beta/pages/admin_novinky.php

    r405 r407  
    4141if (isset($_POST["add"]) AND $lvl > 0)
    4242{
    43   $db -> select_db("wow_web");
     43  $db -> select_db($db_ghsystem);
    4444  $result =  $db -> query("INSERT INTO `articles` ( `id` , `title` , `autor` , `date` , `category` , `text`) VALUES (NULL, '".$_POST["nadpis"]."', '".$_COOKIE["hof-nick"]."', NULL , '".$_POST["kategorie"]."'  , '".$_POST["text"]."');");
    4545  echo "Přidáno !";
  • beta/pages/arena.php

    r405 r407  
    99{
    1010  global $dir , $dir_img;
    11   if (isset($_GET["order"]) AND $_GET["order"] == $sort)2
     11  if (isset($_GET["order"]) AND $_GET["order"] == $sort)
    1212  {
    1313    $arrow = $dir_img."";
     
    1919  return $arrow."<a href=\"?page=arena&amp;order=".$sort."&amp;dir=".$dir."\">".$show."</a>";
    2020}
    21 $db -> select_db("realm1_characters");
     21include("inc/db.php");
     22$db -> select_db("$db_characters");
    2223$count = $db -> query("SELECT count(*) FROM arena_team;") -> fetch_array();
    2324$all_record = $count[0];
  • beta/pages/aukce.php

    r405 r407  
    8686  </tr>
    8787<?php
    88 $db -> select_db("realm1_characters");
     88$db -> select_db($db_characters);
    8989
    9090function AuctionEnd($end_time)
     
    153153
    154154 
    155   $db -> select_db("realm1_mangos");
     155  $db -> select_db($db_mangos);
    156156  $item = $db -> query("SELECT `name` , `RequiredLevel` FROM `item_template` WHERE `entry`='".$row["item_template"]."' LIMIT 1;") -> fetch_array();
    157157  if (LoadCookie("hof-frakce",$row["location"]) == $row["location"] AND LoadCookie("hof-maxgold",10000000000) >= $moneys[0] AND LoadCookie("hof-minlvl",0) <= $item["RequiredLevel"] AND LoadCookie("hof-maxlvl",70) >= $item["RequiredLevel"])
  • beta/pages/dotation.php

    r405 r407  
    1616);
    1717
    18 $db -> select_db("web");
     18$db -> select_db($db_webu);
    1919
    2020$load_money = $db -> query("SELECT SUM(`money`) FROM `dotation`;") -> fetch_array();
  • beta/pages/events.php

    r405 r407  
    22
    33$EventsLinks = array(
    4   1 => array("http://www.wowwiki.com/Midsummer_Fire_Festival", "http://www.worldofwarcraft.com/info/events/midsummer/"),
     4  1 => array("http://wwpw.wowwiki.com/Midsummer_Fire_Festival", "http://www.worldofwarcraft.com/info/events/midsummer/"),
    55  2 => array("http://www.wowwiki.com/Feast_of_Winter_Veil", "http://www.worldofwarcraft.com/info/events/winterveil/"),
    66  3 => array("http://www.wowwiki.com/Darkmoon_Faire", "http://www.worldofwarcraft.com/info/basics/factions/darkmoon/"),
     
    3939function Events()
    4040{
     41include("inc/db.php");
     42
    4143  global $db, $EventsLinks;
    4244  $Events = array("Running" => array(), "Planned" => array());
    43   $db -> select_db("realm1_mangos");
     45  $db -> select_db("$db_mangos");
    4446 
    4547
  • beta/pages/gh.php

    r405 r407  
    1 <?php
    2 include("../gh_system/conn.php"); ?>
    3 <script>
     1<script>
    42function zobrazSkryj(idecko){
    53el=document.getElementById(idecko).style;
     
    1614<BR>
    1715<BR>
    18 <table align=center><tr><td><font size=4><B>Nájemný systém budov cechů a spolků</B></font><br /><br /><td>
     16<table align=center><tr><td><font size=4><B>Jak si zařídit GH pro svou guildu</B></font><br /><br /><td>
    1917
    20 <tr><td>Jak si postavit domek pro svůj spolek, kolik platit, jaký typ domku a ostatní odpovědi na otázky získáte zde:
     18<tr><td>Jak si postavit domek pro guildu a ostatní odpovědi na otázky získáte zde:
    2119<tr><td><a href="http://wow.zdechov.net/forum/viewtopic.php?f=9&t=2143">http://wow.zdechov.net/forum/viewtopic.php?f=9&t=2143 </a>
    2220 <td><td></table>
     
    2624
    2725<font size=5><b>Seznam Guild, které mají a platí GH:</b></font>
    28 <p align=center><table align="center" border="1" bordercolor="#000000"><tr><td align=center><strong>Guild Master</strong><td align=center><strong>Jméno guildy</strong><td align=center><strong>Typ GH</strong><td align=center><strong>Měsíční poplatek</strong><td align=center><strong>Mají na další splátku?</strong><td align=center><strong>Další platba</strong>
     26<p align=center><table align="center" border="1" bordercolor="#000000"><tr><td align=center><strong>Guild Master</strong><td align=center><strong>Jméno guildy</strong><td align=center><strong>Typ GH</strong><td align=center><strong>Týdenní poplatek</strong><td align=center><strong>Mají na další splátku?</strong><td align=center><strong>Další platba</strong>
    2927
    3028<?
     29include("gh_system/conn.php");
    3130
    3231mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
     
    4342 
    4443       while ($zaznam = mysql_fetch_array($query) ) {
    45            $id = $zaznam['id'];;
     44           $id = $zaznam['id'];
    4645           $typgh = $zaznam['typgh'];
    4746            if($typgh==1):
     
    6463           $prachy_mesicne = "90";
    6564           endif;
     65           
    6666           mysql_select_db($Databaze_characters);
    6767           $query2 = mysql_query("SELECT * FROM guild where guildid=$id");
    6868           while ($radek = mysql_fetch_array($query2) ) {
    6969           $prachy = $radek['BankMoney'];
    70            }
     70           $leaderguid = $radek['leaderguid'];
     71            }
     72            $characters_gum = mysql_query("SELECT name FROM characters where guid=$leaderguid");
     73     while ($aa = mysql_fetch_array($characters_gum) ){
     74                 $gum = $aa['name'];
     75                 }
     76                 
     77           
    7178           
    7279            if($prachy-($prachy_mesicne*10000) <= 0):
     
    7683           endif;
    7784           
    78             echo"<tr><td align=center>$zaznam[GuM] <td align=center>$zaznam[jmeno]<td align=center> $typgh_slovne<td align=center>$prachy_mesicne<img src='imgs/gold.gif'><td $pozadí><td align=center>$zaznam[dalsi_platba]";
    79                         echo"</table>";
     85            echo"<tr><td align=center>$gum <td align=center>$zaznam[jmeno]<td align=center> $typgh_slovne<td align=center>$prachy_mesicne<img src='gh_system/img/gold.gif'><td $pozadí><td align=center>$zaznam[dalsi_platba]";
     86                       
    8087                }
    81                 endif;
     88                echo"</table>";
     89        endif;
    8290                ?>
  • beta/pages/gmlog.php

    r405 r407  
     1
     2
    13<?php
    2 // works only on server ! temp way to beta !!
     4$gmlog = "/a/mangos/log/GM_Commands.log"; //CESTA K GM LOGU
     5$config = "../gh_system/conn.php"; //CESTA KE CONN.PHP
     6$pocet_radku = 50; //KOLIK RADKU Z LOGU SE BUDE ZOBRAZOVAT
     7
     8echo"<table align=center bordercolor='black' border=2><tr><td align=center><strong>Cas</strong><td align=center><strong>Príkaz</strong><td align=center><strong>GM</strong><td align=center><strong>Vybrán</strong></tr>";
     9
     10
     11
     12
    313echo "<img src=\"imgs/gm.jpg\">";
    4 exec("tail -30 /a/mangos/log/GM_Commands.log >> /a/www/wow/beta/server/gmlog.txt");
    5     $fp_c = fopen ("server/gmlog.txt", "r");
    6     $load_log = fread($fp_c, filesize("server/gmlog.txt"));
    7     echo "<center>";
    8     $server -> ShowGmLog($load_log);
    9     echo "</center>";
    10 exec("rm /a/www/wow/beta/server/gmlog.txt"); 
     14include($config);
     15$data = file($gmlog);
     16$radku = count($data);
     17$i = 0;
     18
     19
     20while($i < $pocet_radku){
     21$radek = $radku-1;
     22$pole=explode(" ",$data[$radek]);
     23
     24if($pole[3]=="announce"):
     25$prikaz = "announce ...";
     26else:
     27$prikaz=explode("[","$pole[3] $pole[4] $pole[5] $pole[6] $pole[7] $pole[8] $pole[9]");
     28$prikaz = $prikaz[0];
     29endif;
     30
     31$prikaz_pole=explode("[","$pole[3] $pole[4] $pole[5] $pole[6] $pole[7] $pole[8] $pole[9]");
     32$hrac_pole=explode("Player:",$data[$radek]);
     33$hrac=explode(" ",$hrac_pole[1]);
     34$vybran_pole=explode("Selected:",$data[$radek]);
     35$vybran=explode(" ",$vybran_pole[1]);
     36
     37if($vybran[1]=="player"):
     38$guid_pole=explode("GUID:",$vybran_pole[1]);
     39$guid=explode(")]",$guid_pole[1]);
     40
     41mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
     42  mysql_select_db($Databaze_characters);
     43  mysql_query("SET NAMES 'utf8'");
     44   $pocet = mysql_num_rows(mysql_query("SELECT guid FROM characters where guid=$guid[0]"));
     45   if($pocet!=0):
     46  $query = mysql_query("SELECT * FROM characters where guid=$guid[0]");
     47           while ($radek = mysql_fetch_array($query) ) {
     48           $vybran_radek = $radek['name'];
     49           $vybran = "hráč $vybran_radek";
     50           }
     51else:
     52$vybran = "<i>neznámý hrác</i>";
     53endif;
     54else:
     55$vybran = $vybran[1];
     56endif;
     57
     58echo"<tr><td align=center>$pole[0] $pole[1]<td align=center>$prikaz<td align=center>$hrac[1]<td align=center>$vybran</tr>";
     59$i = $i+1;
     60$radku = $radku-1;
     61}
     62echo"</table>";
     63
    1164?>
  • beta/pages/guilda.php

    r405 r407  
    1111if ($id != 0)
    1212{
    13   $db -> select_db("realm1_characters");
     13  $db -> select_db($db_characters);
    1414  $guild_id = $id;
    1515  $guild_data = $db -> query("SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = ".$guild_id." LIMIT 1;") -> fetch_array();
  • beta/pages/guildy.php

    r405 r407  
    6363
    6464
    65 $db -> select_db("realm1_characters");
     65$db -> select_db($db_characters);
    6666
    6767$sql = $db -> query('SELECT `guild`.homepage, `guild`.name, `guild`.guildid, `guild`.createdate, COUNT(`guild_member`.`guildid`) AS member_count ,`leader`.`race` IN (1, 3, 4, 7, 11) AS fraction , `leader`.`guid` AS leader FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` AS `memebers` ON `memebers`.`guid`= `guild_member`.`guid` JOIN `characters` AS `leader` ON `leader`.`guid`= `guild`.`leaderguid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir.';');
  • beta/pages/movechar.php

    r405 r407  
    4545if (isset($_POST["movechar"]) AND $_POST["acc1"] != "" AND $_POST["pass1"] != "" AND $_POST["pass2"] != "" AND $_POST["char"] != "" AND $_POST["acc2"] != "" AND $_POST["pass1"] == $_POST["pass2"])
    4646{
    47   $db -> select_db("realm1_realmd");
     47  $db -> select_db($db_realmd);
    4848  $row = $db -> query("SELECT `locked` FROM `account` WHERE `id` = '".$_SESSION["UserId"]."';") -> fetch_array();
    4949  if ($row["locked"] != 1)
  • beta/pages/online.php

    r405 r407  
    3535  </tr>
    3636";
    37   $db -> select_db("realm1_characters");
     37  $db -> select_db($db_characters);
    3838  $sql = $db -> query("SELECT guid,name,race,class,zone,map,
    3939  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1563), ' ', -1) AS UNSIGNED) AS highest_rank,
  • beta/pages/register.php

    r405 r407  
    2424  <tr>
    2525    <td>Pravidla serveru : </td>
    26     <td><a href=\"http://wow.zdechov.net/forum/viewtopic.php?f=11&t=2066">Pravidla</a></td>
     26    <td><a href=\"http://wow.zdechov.net/forum/viewtopic.php?f=11&t=2066\">Pravidla</a></td>
    2727  </tr>
    2828  <tr>
  • beta/pages/tickets.php

    r405 r407  
    99    </tr> 
    1010";
    11 $db -> select_db("realm1_characters");
     11$db -> select_db($db_characters);
    1212$load_tickets = $db -> query("SELECT * FROM `character_ticket` ORDER BY `ticket_id` ASC;");
    1313  while ($row = $load_tickets -> fetch_array())
  • beta/styles/style.css

    r405 r407  
    3030            background-image: url(../imgs/web/bottom.jpg);
    3131            z-index: 1;
     32            }
     33#copyright    {
     34            margin-left: 140px;
     35                        font-size:12px;
    3236            }
    3337#menu       {
Note: See TracChangeset for help on using the changeset viewer.