Changeset 626

Timestamp:

Aug 18, 2009, 1:35:36 PM (15 years ago)

Author:

george

Message:

• Odebráno: Stará verze minimanageru.
• Odebráno: Styrý neudržovaný systém správy domků spolků.
• Opraveno: Zobrazení domků spolků.

Location:

trunk

Files:

• . (modified) (1 prop)
• bug_tracker (modified) (1 prop)
• export (deleted)
• favicon.ico (modified) (1 prop) ( previous)
• gh_system (deleted)
• imgs/coins (added)
• imgs/coins/bg.png (added)
• imgs/coins/copper.gif (added)
• imgs/coins/gold.gif (added)
• imgs/coins/silver.gif (added)
• index.php (modified) (1 diff)
• mmadmin (deleted)
• pages/gh.php (modified) (1 diff)
• sql/updates/626.sql (added)

trunk

@@ -1 +1 @@
 gallery
 test
+armory

@@ -1 +1 @@
 gallery
 test
+armory

trunk/index.php

@@ -73 +73 @@
   array('link' => '?page=arena', 'Text' => 'Arény'),
   array('link' => '?page=events', 'Text' => 'Události'),
-  array('link' => '?page=gmlog', 'Text' => 'GM log'),
+  //array('link' => '?page=gmlog', 'Text' => 'GM log'),
   array('link' => '?page=commands', 'Text' => 'Příkazy'),
 );

trunk/pages/gh.php

@@ -1 @@
-<script>
-function zobrazSkryj(idecko){
-el=document.getElementById(idecko).style; 
-el.display=(el.display == 'block')?'none':'block';
+<?php
+
+$Output = $server->RealmSelection().
+
+'<h3 class="PageTitle">Seznam spolků, které mají a platí GH:</h3>
+<table class="BaseTable"><tr><th>Vedoucí spolku</th><th>Jméno spolku</th><th>Typ domu</th><th>Týdenní poplatek</th><th>Další platba</th></tr>';
+
+$DbResult = $db->query('SELECT GuildHouse.Id, GuildHouse.NextPayment, guild.name AS Name, GuildHouseType.Name AS TypeName, GuildHouseType.Tax AS Tax, guild.BankMoney, characters.name AS LeaderName FROM GuildHouse LEFT JOIN GuildHouseType ON GuildHouseType.Id = GuildHouse.Type LEFT JOIN '.$Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters'].'.guild ON guildid = GuildHouse.Id LEFT JOIN '.$Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters'].'.characters ON characters.guid = guild.leaderguid');
+while($Guild = $DbResult->fetch_assoc())
+{      
+  if(($Guild['BankMoney'] - ($Guild['Tax'] * 10000)) <= 0) $BackgroundColor = 'style="backgroundcolor: #FF0000"';
+    else $BackgroundColor = 'style="backgroundcolor: #00FF00"';
+     
+  $Output .= '<tr><td>'.$Guild['LeaderName'].'</td><td>'.$Guild['Name'].'</td><td>'.$Guild['TypeName'].'</td><td>'.$Guild['Tax'].' <img src="gh_system/img/gold.gif"></td><td '.$BackgroundColor.'>'.$Guild['NextPayment'].'</td></tr>'; 
+      
 }
-</script>
-<style>
-h3 {cursor: pointer; cursor: hand; text-decoration: underline}
-.skryvany {display: none}
-</style>
+$Output .= '</table><br />'.
+'<p>Jak si postavit domek pro guildu a ostatní odpovědi na otázky získáte zde: 
+<a href="http://wow.zdechov.net/forum/viewtopic.php?f=9&t=2143">/forum/viewtopic.php?f=9&t=2143</a></p>';
 
+echo($Output);
 
-<p align=center>
-
-<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 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>
-
-<br>
-<br>
-
-<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>Týdenní poplatek</strong><td align=center><strong>Mají na další splátku?</strong><td align=center><strong>Další platba</strong>
-
-<? 
-
-
-mysql_connect($db_server, $db_user, $db_pass);
-  mysql_select_db($db_webu);
-    mysql_query("SET NAMES 'utf8'");
-         $pocet = mysql_num_rows(mysql_query("SELECT id FROM guildy"));
-         
-         if($pocet==0):
-         echo"</table><br>
-<font color=red><b>Zatím není žádná Guilda v seznamu</font></b>";
-         else:
-         
-  $query = mysql_query("SELECT * FROM guildy");
-  
-       while ($zaznam = mysql_fetch_array($query) ) {
-           $id = $zaznam['id'];
-           $typgh = $zaznam['typgh'];
-            if($typgh==1):
-           $typgh_slovne = "Horďácká strážní věž";
-           $prachy_mesicne = "40";
-           elseif($typgh==2):
-           $typgh_slovne = "Masivní alianční věž";
-           $prachy_mesicne = "50";
-            elseif($typgh==3):
-           $typgh_slovne = "Elfský strom";
-           $prachy_mesicne = "70";
-            elseif($typgh==4):
-           $typgh_slovne = "Dům nemrtvých";
-           $prachy_mesicne = "60";
-            elseif($typgh==5):
-           $typgh_slovne = "Zeppelin (vzducholoď)";
-           $prachy_mesicne = "80";
-            elseif($typgh==6):
-           $typgh_slovne = "Loď";
-           $prachy_mesicne = "90";
-           endif;
-           
-           mysql_select_db($db_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):
-           $pozadí = "bgcolor='#FF0000'";
-           else:
-           $pozadí = "bgcolor='#00FF00'";
-           endif;
-           
-            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]"; 
-                        
-                }
-                echo"</table>";
-        endif;
-                ?>
+?>

@@ -1 +1 @@
 gallery
 test
+armory