Changeset 89 for db

Timestamp:

Sep 30, 2007, 12:28:52 PM (17 years ago)

Author:

hosiplan

Message:

Šmelím config.php takže tu možá teď proběhne pár verzí bez komentáře

Location:

db

Files:

• config.php (deleted)
• config.sample.php (modified) (2 diffs)
• databaze_tabulky (added)
• databaze_tabulky/sql.sql (added)
• include/bug_read.php (added)
• include/bug_report.php (added)
• index.php (modified) (3 diffs)
• obsah.php (modified) (3 diffs)
• post_read.php (modified) (6 diffs)

db/config.sample.php

@@ -4 +4 @@
   'Database' => array(
     'Host' => 'localhost',
-    'User' => 'webdesign',
-    'Password' => '332dbe5e1cc3c4d10712e4e71d99a484'
+    'User' => 'root',
+    'Password' => 'gurubashi'
   ),
   'Style' => 'maron',
@@ -13 +13 @@
     'SilverDBVersion' => '0.7',
     'SilverDBRevision' => '208',
-    'ClientVersion' => '2.1.3',
-    'MaxOnlinePlayers' => 100,
-    'RequiredOnlinePlayers' => 70,
+    'ClientVersion' => '2.1.3'
   ),
   'DB_read' => array(
     'Charset' => 'utf-8',
-    'Database' => 'mangos_test',
+    'Database_mangos' => 'mangos',
+    'Database_realmd' => 'realmd',
+    'Database_web' => 'wow',
     'Description' => 'Neoficiální herní server hry World of Warcraft',
     'Title' => 'Heroes of Fantasy - Databáze',

db/index.php

@@ -12 +12 @@
   @mysql_connect( $Config['DB_read']['Database']['Host'], $Config['DB_read']['Database']['User'], $Config['DB_read']['Database']['Password'] ) 
     OR DIE("<p>Vyskytla se chyba a nelze se připojit k databázi.<br> Zkuste to později.</p>"); 
-  @mysql_select_db($Config['DB_read']['DB_read']['Database'])
-    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database']."!</p>");
+  $DB_mangos = mysql_select_db($Config['DB_read']['DB_read']['Database_mangos']);
+    if( !$DB_mangos ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>"); };
+/*  $DB_realmd = mysql_select_db($Config['DB_read']['DB_read']['Database_realmd']);
+    if( !$DB_realmd ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>"); };
+  $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']);
+    if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; */
   @mysql_query("SET NAMES ".$Config['DB_read']['DB_read']['Charset']); 
 
@@ -29 +33 @@
     };
 
-  function StranovaniVypisu($sql, $limit, $nastranu, $adresa, $SID){ 
-    $pocet_radku = @mysql_num_rows(mysql_query($sql)); 
+  function StranovaniVypisu($sql, $limit, $nastranu, $adresa, $SID ,$DB){ 
+    $pocet_radku = @mysql_num_rows(mysql_query($sql,$DB)); 
     if( $pocet_radku > 0 ) { 
       $listovani = $pocet_radku/10; 
@@ -101 +105 @@
     };
 
-  function SQLselect_Strankovani($dotaz, $limit, $nastranu, $adresa, $SID){ 
-    $navigace = StranovaniVypisu($dotaz, $limit, $nastranu, $adresa, $SID);
-    $dotaz =  @mysql_query($dotaz." LIMIT ".(--$limit*10*($nastranu/10)).", $nastranu "); 
+  function SQLselect_Strankovani($dotaz, $limit, $nastranu, $adresa, $SID, $DB){ 
+    $navigace = StranovaniVypisu($dotaz, $limit, $nastranu, $adresa, $SID, $DB);
+    $dotaz =  @mysql_query($dotaz." LIMIT ".(--$limit*10*($nastranu/10)).", $nastranu ",$DB); 
     $vysledek = array( '1'           => $dotaz, 
                        'strankovani' => $navigace );

db/obsah.php

@@ -5 +5 @@
             if( $id == "uvod" ){ $file = "uvod"; $nadpis = "Úvod"; } 
             elseif( $id == "stats" ){ $file = "stats"; $nadpis = "Statistiky"; } 
+            elseif( $id == "bugreport" ){ $file = "bug_report"; $nadpis = "Systém pro opravu chyb"; } 
             elseif( $id == "races" ){ $file = "races"; $nadpis = "Rasy"; } 
             elseif( $id == "classes" ){ $file = "classes"; $nadpis = "Povolání"; } 
@@ -34 +35 @@
             }
           elseif( !empty($quest) ){ 
-            $quest_dotaz_nadpis =  mysql_query("SELECT `Title` FROM `quest_template` WHERE `entry`='".$quest."' LIMIT 1"); 
+            $quest_dotaz_nadpis =  mysql_query("SELECT `Title` FROM `quest_template` WHERE `entry`='".$quest."' LIMIT 1",$DB_mangos); 
             if( mysql_num_rows($quest_dotaz_nadpis) == "1" ) { $i = "0";
               $result = MySQL_Fetch_Array($quest_dotaz_nadpis);
@@ -43 +44 @@
             } 
           elseif( !empty($creature) ){ 
-            $creature_dotaz_nadpis =  mysql_query("SELECT `name`,`subname` FROM `creature_template` WHERE `entry`='".$creature."' LIMIT 1"); 
+            $creature_dotaz_nadpis =  mysql_query("SELECT `name`,`subname` FROM `creature_template` WHERE `entry`='".$creature."' LIMIT 1",$DB_mangos); 
             if( mysql_num_rows($creature_dotaz_nadpis) == "1" ) { $i = "0";
               $result = @MySQL_Fetch_Array($creature_dotaz_nadpis);

db/post_read.php

@@ -7 +7 @@
 if( !empty($q) AND !empty($id) ){ 
   if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; };
-  $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&amp;q=".$q."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID);
+  $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&amp;q=".$q."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID, $DB_mangos);
   if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 
     $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
@@ -18 +18 @@
       $sql_select['result'] .= "<td>";
 
-        $startovni_creature_dotaz = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$result['entry']." ");
+        $startovni_creature_dotaz = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$result['entry']." ",$DB_mangos);
         while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 
           $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>";
           };
-        $startovni_gameobject_dotaz = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$result['entry']." ");
+        $startovni_gameobject_dotaz = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$result['entry']." ",$DB_mangos);
         while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 
           $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>";
@@ -37 +37 @@
   } 
 elseif( !empty($quest) AND empty($id) ){ 
-  $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;");
+  $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;",$DB_mangos);
   if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 
     $result = MySQL_Fetch_Array($sql_select['sql']);
@@ -43 +43 @@
 
     // Zjištění creatur a gameobjectů kde se Quest dá vzít
-    $startovni_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$sql_select['quest']['entry']." ");
+    $startovni_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$sql_select['quest']['entry']." ",$DB_mangos);
       if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){
         while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 
         $sql_select['other']['StartNPC'] .= "<a href=\"index.php?creature=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n";
         }; }; 
-    $startovni_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$sql_select['quest']['entry']." ");
+    $startovni_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$sql_select['quest']['entry']." ",$DB_mangos);
       if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){
         while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ 
@@ -61 +61 @@
 
     // Důležitá věc 
-    $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;");
+    $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;",$DB_mangos);
     if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){
         $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz);
@@ -107 +107 @@
   }
 elseif( !empty($creature) AND empty($id) ){ 
-  $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;");
+  $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;",$DB_mangos);
   if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 
     $result = MySQL_Fetch_Array($sql_select['sql']);
     $sql_select['creature'] = $result;
 
-    $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$sql_select['creature']['entry']." AND `quest_template`.`PrevQuestId`=0 ) ");
+    $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$sql_select['creature']['entry']." AND `quest_template`.`PrevQuestId`=0 ) ",$DB_mangos);
       if( @mysql_num_rows($questy_dotaz_creature) > 0 ){
         while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){