Changeset 490 for trunk

Timestamp:

Mar 14, 2009, 2:46:47 AM (16 years ago)

Author:

amun

Message:

Přidána funkce "Odebrat splátku od všech"

File:

• trunk/gh_system/admin.php (modified) (2 diffs)

trunk/gh_system/admin.php

@@ -143 +143 @@
 if($pocet2!=0):
         echo"<p align=center><br><br>
-        <font size=5 color=red><B>Guildy, které by mìly zaplatit další splátku:</B></font><BR>
-<table align=center valign=middle>";
+        <font size=5 color=red><B>Guildy, které by mìly zaplatit další splátku:</B></font><BR>";
+if($pocet2>=2): ?>
+<br><button OnClick="window.location.href='admin.php?heslo=<? echo"$admin"; ?>&q=5';">Odebrat splátku u všech</button><br><br>
+
+<?
+endif;
+
+echo"<table align=center valign=middle>";
 
 
@@ -355 +361 @@
 endif;
 
+} elseif($q==5) {
+
+  mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
+  mysql_select_db($Databaze);
+    mysql_query("SET NAMES 'utf8'");
+  
+  $info_platicu = mysql_query("SELECT * FROM guildy where dalsi_platba='".date("Y-m-d")."' OR dalsi_platba<'".date("Y-m-d")."'");
+  
+  
+  while ($radek = mysql_fetch_array($info_platicu) ){
+  $id2 = $radek['id'];
+  $jmeno = $radek['jmeno'];
+  $gum = $radek['GuM'];
+  $typgh = $radek['typgh'];
+if($typgh==1):
+$prachy_mesic = 40*10000;
+elseif($typgh==2):
+$prachy_mesic = 50*10000;
+elseif($typgh==3):
+$prachy_mesic = 70*10000;
+elseif($typgh==4):
+$prachy_mesic = 60*10000;
+elseif($typgh==5):
+$prachy_mesic = 80*10000;
+elseif($typgh==6):
+$prachy_mesic = 90*10000;
+endif;
+$dalsi_platba = $radek['dalsi_platba'];
+
+ mysql_select_db($Databaze_characters);
+         $guild_info = mysql_query("select * from guild where guildid=$id2");
+           while ($zaznam = mysql_fetch_array($guild_info) ){
+            $prachy_celkem = $zaznam['BankMoney'];
+           }
+          
+
+if($prachy_celkem-$prachy_mesic>=0):
+
+$kolik_zbyde = $prachy_celkem-$prachy_mesic;
+
+$odebrat_prachy = mysql_query("update guild set BankMoney=$kolik_zbyde where guildid=$id2");
+mysql_select_db($Databaze);
+$upravit_datum_dalsi_platby = mysql_query("update guildy set dalsi_platba=date_add('$dalsi_platba', INTERVAL 7 day) where id=$id2");
+
+if($odebrat_prachy and $upravit_datum_dalsi_platby):
+echo"<p align=center><font color=green><strong>Odebírání èastky u Guildy '$jmeno' probìhlo úspìšnì</strong></font>";
+else:
+echo"<p align=center><font color=red><strong>Pøi úpravì dat Guildy '$jmeno' v databázi došlo k chybì!</strong></font></font>";
+endif;
+else:
+echo"<p align=center><font color=red><strong>Guilda '$jmeno' nemá dostateèné finance pro zaplacení èástky!</strong></font></font>";
+endif;
+
 }
-
-
-
-endif;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+?>
+<br><br><button OnClick="window.location.href='admin.php?heslo=<? echo"$admin"; ?>';"><-- Zpìt do administrace</button>
+<?
+}
+
+
+
+endif;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+