Changeset 89
- Timestamp:
- Sep 30, 2007, 12:28:52 PM (17 years ago)
- Location:
- db
- Files:
-
- 4 added
- 1 deleted
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
db/config.sample.php
r84 r89 4 4 'Database' => array( 5 5 'Host' => 'localhost', 6 'User' => ' webdesign',7 'Password' => ' 332dbe5e1cc3c4d10712e4e71d99a484'6 'User' => 'root', 7 'Password' => 'gurubashi' 8 8 ), 9 9 'Style' => 'maron', … … 13 13 'SilverDBVersion' => '0.7', 14 14 'SilverDBRevision' => '208', 15 'ClientVersion' => '2.1.3', 16 'MaxOnlinePlayers' => 100, 17 'RequiredOnlinePlayers' => 70, 15 'ClientVersion' => '2.1.3' 18 16 ), 19 17 'DB_read' => array( 20 18 'Charset' => 'utf-8', 21 'Database' => 'mangos_test', 19 'Database_mangos' => 'mangos', 20 'Database_realmd' => 'realmd', 21 'Database_web' => 'wow', 22 22 'Description' => 'Neoficiální herní server hry World of Warcraft', 23 23 'Title' => 'Heroes of Fantasy - Databáze', -
db/index.php
r82 r89 12 12 @mysql_connect( $Config['DB_read']['Database']['Host'], $Config['DB_read']['Database']['User'], $Config['DB_read']['Database']['Password'] ) 13 13 OR DIE("<p>Vyskytla se chyba a nelze se připojit k databázi.<br> Zkuste to později.</p>"); 14 @mysql_select_db($Config['DB_read']['DB_read']['Database']) 15 OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database']."!</p>"); 14 $DB_mangos = mysql_select_db($Config['DB_read']['DB_read']['Database_mangos']); 15 if( !$DB_mangos ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>"); }; 16 /* $DB_realmd = mysql_select_db($Config['DB_read']['DB_read']['Database_realmd']); 17 if( !$DB_realmd ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>"); }; 18 $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']); 19 if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; */ 16 20 @mysql_query("SET NAMES ".$Config['DB_read']['DB_read']['Charset']); 17 21 … … 29 33 }; 30 34 31 function StranovaniVypisu($sql, $limit, $nastranu, $adresa, $SID ){32 $pocet_radku = @mysql_num_rows(mysql_query($sql ));35 function StranovaniVypisu($sql, $limit, $nastranu, $adresa, $SID ,$DB){ 36 $pocet_radku = @mysql_num_rows(mysql_query($sql,$DB)); 33 37 if( $pocet_radku > 0 ) { 34 38 $listovani = $pocet_radku/10; … … 101 105 }; 102 106 103 function SQLselect_Strankovani($dotaz, $limit, $nastranu, $adresa, $SID ){104 $navigace = StranovaniVypisu($dotaz, $limit, $nastranu, $adresa, $SID );105 $dotaz = @mysql_query($dotaz." LIMIT ".(--$limit*10*($nastranu/10)).", $nastranu " );107 function SQLselect_Strankovani($dotaz, $limit, $nastranu, $adresa, $SID, $DB){ 108 $navigace = StranovaniVypisu($dotaz, $limit, $nastranu, $adresa, $SID, $DB); 109 $dotaz = @mysql_query($dotaz." LIMIT ".(--$limit*10*($nastranu/10)).", $nastranu ",$DB); 106 110 $vysledek = array( '1' => $dotaz, 107 111 'strankovani' => $navigace ); -
db/obsah.php
r84 r89 5 5 if( $id == "uvod" ){ $file = "uvod"; $nadpis = "Úvod"; } 6 6 elseif( $id == "stats" ){ $file = "stats"; $nadpis = "Statistiky"; } 7 elseif( $id == "bugreport" ){ $file = "bug_report"; $nadpis = "Systém pro opravu chyb"; } 7 8 elseif( $id == "races" ){ $file = "races"; $nadpis = "Rasy"; } 8 9 elseif( $id == "classes" ){ $file = "classes"; $nadpis = "Povolání"; } … … 34 35 } 35 36 elseif( !empty($quest) ){ 36 $quest_dotaz_nadpis = mysql_query("SELECT `Title` FROM `quest_template` WHERE `entry`='".$quest."' LIMIT 1" );37 $quest_dotaz_nadpis = mysql_query("SELECT `Title` FROM `quest_template` WHERE `entry`='".$quest."' LIMIT 1",$DB_mangos); 37 38 if( mysql_num_rows($quest_dotaz_nadpis) == "1" ) { $i = "0"; 38 39 $result = MySQL_Fetch_Array($quest_dotaz_nadpis); … … 43 44 } 44 45 elseif( !empty($creature) ){ 45 $creature_dotaz_nadpis = mysql_query("SELECT `name`,`subname` FROM `creature_template` WHERE `entry`='".$creature."' LIMIT 1" );46 $creature_dotaz_nadpis = mysql_query("SELECT `name`,`subname` FROM `creature_template` WHERE `entry`='".$creature."' LIMIT 1",$DB_mangos); 46 47 if( mysql_num_rows($creature_dotaz_nadpis) == "1" ) { $i = "0"; 47 48 $result = @MySQL_Fetch_Array($creature_dotaz_nadpis); -
db/post_read.php
r84 r89 7 7 if( !empty($q) AND !empty($id) ){ 8 8 if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; }; 9 $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&q=".$q."&lvl_d=".$lvl_d."&lvl_h=".$lvl_h, $SID );9 $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&q=".$q."&lvl_d=".$lvl_d."&lvl_h=".$lvl_h, $SID, $DB_mangos); 10 10 if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 11 11 $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n"; … … 18 18 $sql_select['result'] .= "<td>"; 19 19 20 $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']." " );20 $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); 21 21 while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 22 22 $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>"; 23 23 }; 24 $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']." " );24 $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); 25 25 while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 26 26 $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>"; … … 37 37 } 38 38 elseif( !empty($quest) AND empty($id) ){ 39 $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;" );39 $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;",$DB_mangos); 40 40 if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 41 41 $result = MySQL_Fetch_Array($sql_select['sql']); … … 43 43 44 44 // Zjištění creatur a gameobjectů kde se Quest dá vzít 45 $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']." " );45 $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); 46 46 if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){ 47 47 while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 48 48 $sql_select['other']['StartNPC'] .= "<a href=\"index.php?creature=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n"; 49 49 }; }; 50 $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']." " );50 $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); 51 51 if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){ 52 52 while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ … … 61 61 62 62 // Důležitá věc 63 $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;" );63 $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;",$DB_mangos); 64 64 if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){ 65 65 $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz); … … 107 107 } 108 108 elseif( !empty($creature) AND empty($id) ){ 109 $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;" );109 $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;",$DB_mangos); 110 110 if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 111 111 $result = MySQL_Fetch_Array($sql_select['sql']); 112 112 $sql_select['creature'] = $result; 113 113 114 $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 ) " );114 $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); 115 115 if( @mysql_num_rows($questy_dotaz_creature) > 0 ){ 116 116 while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){
Note:
See TracChangeset
for help on using the changeset viewer.