Changeset 11 for guildy.php

Timestamp:

Aug 11, 2007, 12:04:22 AM (17 years ago)

Author:

george

Message:

Sjednocení parametrů připojení k databázi do jednoho souboru config.php.
Přepsání všech cest na relativní.
Přidání parametru BaseUrl do souboru config.php.

File:

• guildy.php (modified) (3 diffs)

guildy.php

@@ -19 +19 @@
 if(!array_key_exists('guild', $_GET))
 {
-  echo('<h3>Seznam guild:</h3>');
-  echo('<div align="center"><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>');
+  echo('<div align="center"><strong>Seznam guild:</strong>');
+  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');
@@ -30 +30 @@
 } else {
   $_GET['guild'] = addslashes($_GET['guild']);
-  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` WHERE guild.guildid='.$_GET['guild'].' GROUP BY guild.name');
+  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)
   {
@@ -36 +36 @@
     //  if($Guild['homepage'] != '') $Guild['name'] = $Guild['name'].' <a href="'.$Guild['homepage'].'">WWW</a>';
     //if($Guild['info'] != '') $Guild['info'] = ''.$Guild['info'].'</i>';
-    echo('<h3>Seznam èlenù guildy '.$Guild['name'].':</h3>');
-    echo('<div align="center"><table class="TableGuilda" border="1" cellpadding="1" cellspacing="0">');
+    echo('<div align="center"><strong>Seznam èlenù guildy '.$Guild['name'].'</strong><br>');
+    DB_Select('`character`', 'name', $Guild['leaderguid'].'=guid');
+    $GuildMaster = DB_Row();
+    echo('Vedoucí guildy: '.$GuildMaster['name'].'<br>');
+    echo('<table class="TableGuilda" border="1" cellpadding="1" cellspacing="0">');
     echo('<tr><th>Jméno</th><th>Level</th><th>Hodnost</th><th>Body cti</th></tr>');
     //echo('<tr><td colspan="2" Class="TdGuilda">Informace: '.$Guild['public_info'].'</td></tr>');