Changeset 407 for beta/pages

Timestamp:

Feb 9, 2009, 6:29:42 PM (16 years ago)

Author:

zork

Message:

 

Location:

beta/pages

Files:

• acclog.php (modified) (1 diff)
• admin_finance.php (modified) (1 diff)
• admin_novinky.php (modified) (1 diff)
• arena.php (modified) (2 diffs)
• aukce.php (modified) (2 diffs)
• dotation.php (modified) (1 diff)
• events.php (modified) (2 diffs)
• gh.php (modified) (6 diffs)
• gmlog.php (modified) (1 diff)
• guilda.php (modified) (1 diff)
• guildy.php (modified) (1 diff)
• movechar.php (modified) (1 diff)
• online.php (modified) (1 diff)
• register.php (modified) (1 diff)
• tickets.php (modified) (1 diff)

beta/pages/acclog.php

@@ -2 +2 @@
 
 echo "&nbsp;<a href=\"?page=acc\">&lt;- Zpět do správy účtu</a>";
-$db -> select_db("realm1_realmd");
+$db -> select_db($db_realmd);
 echo "<center><table border=\"1\" align=\"center\" width=\"540\">
   <tr>

beta/pages/admin_finance.php

@@ -42 +42 @@
 if (isset($_POST["add"]) AND $lvl > 0)
 {
-  $db -> select_db("wow_web");
+  $db -> select_db($db_ghsystem);
   $result =  $db -> query("INSERT INTO `dotation` ( `id` , `time` , `money` , `operation` , `description`) VALUES (NULL, '".$_POST["day"]."', '".$_POST["suma"]."', '".$_POST["kategorie"]."' , '".$_POST["popis"]."' );");
   echo "Přidáno !";

beta/pages/admin_novinky.php

@@ -41 +41 @@
 if (isset($_POST["add"]) AND $lvl > 0)
 {
-  $db -> select_db("wow_web");
+  $db -> select_db($db_ghsystem);
   $result =  $db -> query("INSERT INTO `articles` ( `id` , `title` , `autor` , `date` , `category` , `text`) VALUES (NULL, '".$_POST["nadpis"]."', '".$_COOKIE["hof-nick"]."', NULL , '".$_POST["kategorie"]."'  , '".$_POST["text"]."');");
   echo "Přidáno !";

beta/pages/arena.php

@@ -9 +9 @@
 {
   global $dir , $dir_img;
-  if (isset($_GET["order"]) AND $_GET["order"] == $sort)2
+  if (isset($_GET["order"]) AND $_GET["order"] == $sort)
   {
     $arrow = $dir_img."";
@@ -19 +19 @@
   return $arrow."<a href=\"?page=arena&amp;order=".$sort."&amp;dir=".$dir."\">".$show."</a>";
 } 
-$db -> select_db("realm1_characters");
+include("inc/db.php");
+$db -> select_db("$db_characters");
 $count = $db -> query("SELECT count(*) FROM arena_team;") -> fetch_array();
 $all_record = $count[0];

beta/pages/aukce.php

@@ -86 +86 @@
   </tr>
 <?php
-$db -> select_db("realm1_characters");
+$db -> select_db($db_characters);
 
 function AuctionEnd($end_time)
@@ -153 +153 @@
 
   
-  $db -> select_db("realm1_mangos");
+  $db -> select_db($db_mangos);
   $item = $db -> query("SELECT `name` , `RequiredLevel` FROM `item_template` WHERE `entry`='".$row["item_template"]."' LIMIT 1;") -> fetch_array();
   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

@@ -16 +16 @@
 );
 
-$db -> select_db("web");
+$db -> select_db($db_webu);
 
 $load_money = $db -> query("SELECT SUM(`money`) FROM `dotation`;") -> fetch_array();

beta/pages/events.php

@@ -2 +2 @@
 
 $EventsLinks = array(
-  1 => array("http://www.wowwiki.com/Midsummer_Fire_Festival", "http://www.worldofwarcraft.com/info/events/midsummer/"),
+  1 => array("http://wwpw.wowwiki.com/Midsummer_Fire_Festival", "http://www.worldofwarcraft.com/info/events/midsummer/"),
   2 => array("http://www.wowwiki.com/Feast_of_Winter_Veil", "http://www.worldofwarcraft.com/info/events/winterveil/"),
   3 => array("http://www.wowwiki.com/Darkmoon_Faire", "http://www.worldofwarcraft.com/info/basics/factions/darkmoon/"),
@@ -39 +39 @@
 function Events()
 {
+include("inc/db.php");
+
   global $db, $EventsLinks;
   $Events = array("Running" => array(), "Planned" => array());
-  $db -> select_db("realm1_mangos");
+  $db -> select_db("$db_mangos");
   
 

beta/pages/gh.php

@@ -1 @@
-<?php
-include("../gh_system/conn.php"); ?>
-<script>
+<script>
 function zobrazSkryj(idecko){
 el=document.getElementById(idecko).style; 
@@ -16 +14 @@
 <BR>
 <BR>
-<table align=center><tr><td><font size=4><B>Nájemný systém budov cechů a spolků</B></font><br /><br /><td>
+<table align=center><tr><td><font size=4><B>Jak si zařídit GH pro svou guildu</B></font><br /><br /><td>
 
-<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: 
+<tr><td>Jak si postavit domek pro guildu a ostatní odpovědi na otázky získáte zde: 
 <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>
  <td><td></table>
@@ -26 +24 @@
 
 <font size=5><b>Seznam Guild, které mají a platí GH:</b></font>
-<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>
+<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>
 
 <? 
+include("gh_system/conn.php");
 
 mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
@@ -43 +42 @@
   
        while ($zaznam = mysql_fetch_array($query) ) {
-           $id = $zaznam['id'];;
+           $id = $zaznam['id'];
            $typgh = $zaznam['typgh'];
             if($typgh==1):
@@ -64 +63 @@
            $prachy_mesicne = "90";
            endif;
+           
            mysql_select_db($Databaze_characters);
            $query2 = mysql_query("SELECT * FROM guild where guildid=$id");
            while ($radek = mysql_fetch_array($query2) ) {
            $prachy = $radek['BankMoney'];
-           }
+           $leaderguid = $radek['leaderguid'];
+            }
+            $characters_gum = mysql_query("SELECT name FROM characters where guid=$leaderguid");
+     while ($aa = mysql_fetch_array($characters_gum) ){
+                 $gum = $aa['name'];
+                 }
+                 
+           
            
             if($prachy-($prachy_mesicne*10000) <= 0):
@@ -76 +83 @@
            endif;
            
-            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]"; 
-                        echo"</table>";
+            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]"; 
+                        
                 }
-                endif;
+                echo"</table>";
+        endif;
                 ?>

beta/pages/gmlog.php

@@ +1 @@
+
+
 <?php
-// works only on server ! temp way to beta !!
+$gmlog = "/a/mangos/log/GM_Commands.log"; //CESTA K GM LOGU
+$config = "../gh_system/conn.php"; //CESTA KE CONN.PHP
+$pocet_radku = 50; //KOLIK RADKU Z LOGU SE BUDE ZOBRAZOVAT
+
+echo"<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>";
+
+
+
+
 echo "<img src=\"imgs/gm.jpg\">";
-exec("tail -30 /a/mangos/log/GM_Commands.log >> /a/www/wow/beta/server/gmlog.txt");
-    $fp_c = fopen ("server/gmlog.txt", "r");
-    $load_log = fread($fp_c, filesize("server/gmlog.txt"));
-    echo "<center>";
-    $server -> ShowGmLog($load_log);
-    echo "</center>";
-exec("rm /a/www/wow/beta/server/gmlog.txt");  
+include($config);
+$data = file($gmlog);
+$radku = count($data);
+$i = 0;
+
+
+while($i < $pocet_radku){
+$radek = $radku-1;
+$pole=explode(" ",$data[$radek]);
+
+if($pole[3]=="announce"):
+$prikaz = "announce ...";
+else:
+$prikaz=explode("[","$pole[3] $pole[4] $pole[5] $pole[6] $pole[7] $pole[8] $pole[9]");
+$prikaz = $prikaz[0];
+endif;
+
+$prikaz_pole=explode("[","$pole[3] $pole[4] $pole[5] $pole[6] $pole[7] $pole[8] $pole[9]");
+$hrac_pole=explode("Player:",$data[$radek]);
+$hrac=explode(" ",$hrac_pole[1]);
+$vybran_pole=explode("Selected:",$data[$radek]);
+$vybran=explode(" ",$vybran_pole[1]);
+
+if($vybran[1]=="player"):
+$guid_pole=explode("GUID:",$vybran_pole[1]);
+$guid=explode(")]",$guid_pole[1]);
+
+mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
+  mysql_select_db($Databaze_characters);
+  mysql_query("SET NAMES 'utf8'");
+   $pocet = mysql_num_rows(mysql_query("SELECT guid FROM characters where guid=$guid[0]"));
+   if($pocet!=0):
+  $query = mysql_query("SELECT * FROM characters where guid=$guid[0]");
+           while ($radek = mysql_fetch_array($query) ) {
+           $vybran_radek = $radek['name']; 
+           $vybran = "hráč $vybran_radek";
+           }
+else:
+$vybran = "<i>neznámý hrác</i>";
+endif;
+else:
+$vybran = $vybran[1];
+endif;
+
+echo"<tr><td align=center>$pole[0] $pole[1]<td align=center>$prikaz<td align=center>$hrac[1]<td align=center>$vybran</tr>";
+$i = $i+1;
+$radku = $radku-1;
+}
+echo"</table>";
+
 ?>

beta/pages/guilda.php

@@ -11 +11 @@
 if ($id != 0)
 {
-  $db -> select_db("realm1_characters");
+  $db -> select_db($db_characters);
   $guild_id = $id;
   $guild_data = $db -> query("SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = ".$guild_id." LIMIT 1;") -> fetch_array();

beta/pages/guildy.php

@@ -63 +63 @@
 
 
-$db -> select_db("realm1_characters");
+$db -> select_db($db_characters);
 
 $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

@@ -45 +45 @@
 if (isset($_POST["movechar"]) AND $_POST["acc1"] != "" AND $_POST["pass1"] != "" AND $_POST["pass2"] != "" AND $_POST["char"] != "" AND $_POST["acc2"] != "" AND $_POST["pass1"] == $_POST["pass2"])
 {
-  $db -> select_db("realm1_realmd");
+  $db -> select_db($db_realmd);
   $row = $db -> query("SELECT `locked` FROM `account` WHERE `id` = '".$_SESSION["UserId"]."';") -> fetch_array();
   if ($row["locked"] != 1)

beta/pages/online.php

@@ -35 +35 @@
   </tr>
 ";
-  $db -> select_db("realm1_characters");
+  $db -> select_db($db_characters);
   $sql = $db -> query("SELECT guid,name,race,class,zone,map,
   CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1563), ' ', -1) AS UNSIGNED) AS highest_rank,

beta/pages/register.php

@@ -24 +24 @@
   <tr>
     <td>Pravidla serveru : </td>
-    <td><a href=\"http://wow.zdechov.net/forum/viewtopic.php?f=11&t=2066">Pravidla</a></td>
+    <td><a href=\"http://wow.zdechov.net/forum/viewtopic.php?f=11&t=2066\">Pravidla</a></td>
   </tr>
   <tr>

beta/pages/tickets.php

@@ -9 +9 @@
     </tr>  
 "; 
-$db -> select_db("realm1_characters");
+$db -> select_db($db_characters);
 $load_tickets = $db -> query("SELECT * FROM `character_ticket` ORDER BY `ticket_id` ASC;");
   while ($row = $load_tickets -> fetch_array())