Changeset 588 for trunk/gh_system/admin.php

Timestamp:

May 16, 2009, 3:23:11 PM (16 years ago)

Author:

barny

Message:

*Upraven GH systém a přidán script na tophráče.

Location:

trunk

Files:

• . (modified) (1 prop)
• gh_system/admin.php (modified) (14 diffs)

trunk/gh_system/admin.php

@@ -7 +7 @@
 .nepodtrzene{text-decoration:none};
 </style>
-<? include("conn.php");
+<? include("../inc/db.php");
 $heslo = $_GET['heslo'];
 $q = $_GET['q'];
@@ -41 +41 @@
 <table align="center" border="1"><tr><td align=center><strong>Guild Master</strong><td align=center><strong>Jméno Guildy (ID Guildy)</strong><td align=center><strong>Typ GH (GUID)</strong><td align=center><strong>Mìsíèní platba</strong><td align=center><strong>Další platba</strong><td align=center><strong>Stav úètu</strong><td><strong>Mají na další splátku?</strong></td><td>&nbsp;</td><? 
 
-mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
-  mysql_select_db($Databaze);
+mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_ghsystem);
     mysql_query("SET NAMES 'utf8'");
         $pocet_v_seznamu = mysql_num_rows(mysql_query("SELECT id FROM guildy"));
@@ -76 +76 @@
            
         
-  mysql_select_db($Databaze_characters);
+  mysql_select_db($db_characters);
     mysql_query("SET NAMES 'utf8'");
         $guild_prachy = mysql_query("SELECT BankMoney FROM guild where guildid=$id");
@@ -139 +139 @@
                 endif;
    
-         mysql_select_db($Databaze);
+         mysql_select_db($db_ghsystem);
         $pocet2 = mysql_num_rows(mysql_query("SELECT id FROM guildy where dalsi_platba='".date("Y-m-d")."' OR dalsi_platba<'".date("Y-m-d")."'"));
 if($pocet2!=0):
@@ -180 +180 @@
   else:
  
- mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
-  mysql_select_db($Databaze_characters);
+ mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_characters);
     mysql_query("SET NAMES 'utf8'");
         $existence_guilda = mysql_num_rows(mysql_query("SELECT guildid FROM guild where name='$guilda'"));
@@ -207 +207 @@
   $p = 0;
   else:
- mysql_select_db($Databaze);
+ mysql_select_db($db_ghsystem);
         $guilda_jiz_je = mysql_num_rows(mysql_query("SELECT id FROM guildy where jmeno='$guilda'"));
         if($guilda_jiz_je!=0):
@@ -213 +213 @@
     $p = 0;
   else:
-  mysql_select_db($Databaze);
+  mysql_select_db($db_ghsystem);
     mysql_query("SET NAMES 'utf8'");
   $guilda_do_seznamu = mysql_query("insert into guildy values ('$guildid', '$guilda', '$gum', '$typgh', date_add(now(), INTERVAL 7 day))");
@@ -267 +267 @@
 $id2 = $_POST['id'];
 
-  mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
-  mysql_select_db($Databaze);
+  mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_ghsystem);
     mysql_query("SET NAMES 'utf8'");
   $guilda_info = mysql_query("select * from guildy where id=$id2");
@@ -289 +289 @@
   $dalsi_platba = $radek['dalsi_platba'];
   }
-     mysql_select_db($Databaze_characters);
+     mysql_select_db($db_characters);
          $guild_info = mysql_query("select * from guild where guildid=$id2");
            while ($zaznam = mysql_fetch_array($guild_info) ){
@@ -311 +311 @@
 
 $odebrat_prachy = mysql_query("update guild set BankMoney=$kolik_zbyde where guildid=$id2");
-mysql_select_db($Databaze);
+mysql_select_db($db_ghsystem);
 $upravit_datum_dalsi_platby = mysql_query("update guildy set dalsi_platba=date_add('$dalsi_platba', INTERVAL 7 day) where id=$id2");
 
@@ -334 +334 @@
 if(empty($err)):
 if($sure=="ano"):
-  mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
-  mysql_select_db($Databaze);
+  mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_ghsystem);
     mysql_query("SET NAMES 'utf8'");
   $smazat_ze_seznamu = mysql_query("delete from guildy where id=$id LIMIT 1");
@@ -363 +363 @@
 } elseif($q==5) {
 
-  mysql_connect($SQL_Server, $SQL_Uzivatel, $SQL_Heslo);
-  mysql_select_db($Databaze);
+  mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_ghsystem);
     mysql_query("SET NAMES 'utf8'");
   
@@ -390 +390 @@
 $dalsi_platba = $radek['dalsi_platba'];
 
- mysql_select_db($Databaze_characters);
+ mysql_select_db($db_characters);
          $guild_info = mysql_query("select * from guild where guildid=$id2");
            while ($zaznam = mysql_fetch_array($guild_info) ){
@@ -402 +402 @@
 
 $odebrat_prachy = mysql_query("update guild set BankMoney=$kolik_zbyde where guildid=$id2");
-mysql_select_db($Databaze);
+mysql_select_db($db_ghsystem);
 $upravit_datum_dalsi_platby = mysql_query("update guildy set dalsi_platba=date_add('$dalsi_platba', INTERVAL 7 day) where id=$id2");