Changeset 14 for guildy.php

Timestamp:

Aug 12, 2007, 2:13:09 AM (17 years ago)

Author:

george

Message:

• Aktuality na webu byly přesunuty z textového PHP souboru do tabulky news v databázi wow. Za zobrazování aktualit je odpovědný soubor news.php. Nová SQL tabulka je uložena ve složce sql jako 14-news.sql.
• Opravena struktura a HTML validita hlavních stránek.
• Přidán společný skript database.php pro připojování k MySQL databázi. Databáze je inicializována vždy při načítání skriptu global.php. Změněno připojování k databázi na tento systém v několika skriptech.
• Změna struktury souboru config.php.
• Promazání nepotřebných souborů.
• Vytvoření souboru config.sample.php v podsložce scripts minimanageru. Soubor config.php nadále není verzován a je nutné ho vytvořit jako kopii souboru config.sample.php a nastavit potřebné parametry. Uchovány musí být pouze soubory bez hesel nebo s implicitními hesly.
• Byl přidán skript pro obsluhu chyb error.php.

File:

• guildy.php (modified) (5 diffs)

guildy.php

@@ -1 +1 @@
 <?
   include('global.php');
-  $Charset = 'iso-8859-2';
+  $Database->select_db('mangos');
   ShowHeader();
   
@@ -8 +8 @@
 <TD valign="top">
 <div class="DivText">');
-
-include('test/db.php');
-DB_Init($DatabaseHost, $DatabaseUser, $DatabasePassword, 'mangos');
-DB_Query('SET NAMES latin2');
 
 $RanksEN = array('Guildmaster', 'Veteran', 'Intendant', 'Support Officer', 'PR Officer', 'Officer', 'Famed Member', 
@@ -22 +18 @@
   echo('<table class="TableGuilda" style="align: center;" border="1" cellpadding="3" cellspacing="0" ><tr><th>Název</th><th>Poèet èlenù</th><th>Souèet levelù</th><th>Souèet bodù cti</th><th>Webové stránky</th></tr>');
 //  DB_Query(' COUNT(guild_member.guildid) as member_count FROM guild JOIN guild_member ON guild_member.guildid = guild.guildid GROUP BY guild.name ORDER BY member_count DESC');
-  DB_Query('SELECT `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` GROUP BY guild.name ORDER BY guild.name');
-  while($Guild = DB_Row())
+  $Result = $Database->query('SELECT `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` GROUP BY guild.name ORDER BY guild.name');
+  while($Guild = $Result->fetch_array())
   {
     echo('<tr><td><a href="?guild='.$Guild['guildid'].'">'.$Guild['name'].'</a></td><td>'.$Guild['member_count'].'</td><td>'.$Guild['guild_level'].'</td><td>'.$Guild['guild_honor'].'</td><td>&nbsp;</td></tr>');
@@ -30 +26 @@
 } else {
   $_GET['guild'] = addslashes($_GET['guild']);
-  DB_Query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$_GET['guild'].' GROUP BY guild.name');
-  if(DB_NumRows() > 0)
+  $Result = $Database->query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$_GET['guild'].' GROUP BY guild.name');
+  if($Result->num_rows > 0)
   {
-    $Guild = DB_Row();
+    $Guild = $Result->fetch_array();
     //  if($Guild['homepage'] != '') $Guild['name'] = $Guild['name'].' <a href="'.$Guild['homepage'].'">WWW</a>';
     //if($Guild['info'] != '') $Guild['info'] = ''.$Guild['info'].'</i>';
     echo('<div align="center"><strong>Seznam èlenù guildy '.$Guild['name'].'</strong><br>');
-    DB_Select('`character`', 'name', $Guild['leaderguid'].'=guid');
-    $GuildMaster = DB_Row();
+    $Result = $Database->select('character', 'name', $Guild['leaderguid'].'=guid');
+    $GuildMaster = $Result->fetch_array();
     echo('Vedoucí guildy: '.$GuildMaster['name'].'<br>');
     echo('<table class="TableGuilda" border="1" cellpadding="1" cellspacing="0">');
@@ -45 +41 @@
    
     $GuildRanks = array();
-    DB_Select('guild_rank', '*', 'guildid='.$Guild['guildid']);
-    while($GuildRank = DB_Row()) $GuildRanks[$GuildRank['rid']] = $GuildRank;
+    $Result = $Database->select('guild_rank', '*', 'guildid='.$Guild['guildid']);
+    while($GuildRank = $Result->fetch_array()) $GuildRanks[$GuildRank['rid']] = $GuildRank;
   
-    DB_Query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 35), " ", -1)*1 as level, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 1421), " ", -1)*1 as honor, character.name FROM guild_member JOIN `character` ON guild_member.guid = character.guid AND guild_member.guildid='.$Guild['guildid'].' ORDER BY character.name');
-    while($Member = DB_Row())
+    $Result = $Database->query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 35), " ", -1)*1 as level, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 1421), " ", -1)*1 as honor, character.name FROM guild_member JOIN `character` ON guild_member.guid = character.guid AND guild_member.guildid='.$Guild['guildid'].' ORDER BY character.name');
+    while($Member = $Result->fetch_array())
     {
 //    $DataParts = explode(' ', $Member['data']);