Changeset 577 for trunk/pages/guilda.php

Timestamp:

Apr 29, 2009, 9:04:21 PM (16 years ago)

Author:

george

Message:

• Opraveno: Vyčítání položek ze sloupce Data u postav je nyní nastavování přes konfigurační soubor. Nutno synchronizovat např. dle minimanageru souboru scripts/defines.php při každé změně verze herního klienta.

File:

• trunk/pages/guilda.php (modified) (2 diffs)

trunk/pages/guilda.php

@@ -1 +1 @@
 <?php
-$id = (isset($_GET["id"])) ? $db->real_escape_string($_GET["id"]) : 0;
-function count_days( $a, $b ) 
+
+function count_days($a, $b) 
 {
-        $gd_a = getdate( $a );
-        $gd_b = getdate( $b );
-        $a_new = mktime( 12, 0, 0, $gd_a['mon'], $gd_a['mday'], $gd_a['year'] );
-        $b_new = mktime( 12, 0, 0, $gd_b['mon'], $gd_b['mday'], $gd_b['year'] );
-        return round( abs( $a_new - $b_new ) / 86400 );
+        $gd_a = getdate($a);
+        $gd_b = getdate($b);
+        $a_new = mktime(12, 0, 0, $gd_a['mon'], $gd_a['mday'], $gd_a['year']);
+        $b_new = mktime(12, 0, 0, $gd_b['mon'], $gd_b['mday'], $gd_b['year']);
+        return round(abs($a_new - $b_new) / 86400);
 }
-if ($id != 0)
+
+$db->select_db($Config['Mangos']['DatabaseCharacters']);
+$id = (isset($_GET['id'])) ? $_GET['id'] : 0;
+if($id != 0)
 {
-  $db -> select_db($db_characters);
   $guild_id = $id;
   $guild_data = $db -> query("SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = ".$guild_id." LIMIT 1;") -> fetch_array();
-  $members = $db -> query("SELECT guild_member.guid, guild_member.rank AS mrank, `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 35), ' ', -1) AS level, (SELECT rname FROM guild_rank WHERE guildid =".$guild_id." AND rid = mrank+1) AS rname, guild_member.pnote, guild_member.offnote FROM guild_member,`characters` LEFT JOIN guild_member k1 ON k1.`guid`=`characters`.`guid` WHERE guild_member.guildid = ".$guild_id." AND guild_member.guid=`characters`.guid ORDER BY mrank");
+  $members = $db -> query("SELECT guild_member.guid, guild_member.rank AS mrank, `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".$Config['Mangos']['CharacterDataOffset']['Level']." + 1), ' ', -1) AS level, (SELECT rname FROM guild_rank WHERE guildid =".$guild_id." AND rid = mrank+1) AS rname, guild_member.pnote, guild_member.offnote FROM guild_member,`characters` LEFT JOIN guild_member k1 ON k1.`guid`=`characters`.`guid` WHERE guild_member.guildid = ".$guild_id." AND guild_member.guid=`characters`.guid ORDER BY mrank");
   $total_members = $members -> num_rows;
   $members_data = $members -> fetch_array();
   $online_mem = $db -> query("SELECT count(*) AS online_mem  FROM `guild_member`, `characters`, `guild` WHERE guild.guildid = ".$guild_id." AND guild_member.guildid = guild.guildid AND guild_member.guid = characters.guid AND characters.online = 1;") -> fetch_array();;
   // guild info
-  $date_arr = explode(" ",$guild_data["createdate"]);
-  $date = explode("-",$date_arr[0]);
-  $time_stp = explode(":",$date_arr[1]);
-  $time = mktime($time_stp[0],$time_stp[1],$time_stp[2],$date[1],$date[2],$date[0]);
-  $human_date = date ("d.m.Y H:i:s",$time);
-  echo "<a href=\"?page=guildy\">&lt;- Zpět na výpis</a><br />";
-  echo "
-  <table border=\"1\">
+  $date_arr = explode(' ', $guild_data['createdate']);
+  $date = explode('-', $date_arr[0]);
+  $time_stp = explode(':', $date_arr[1]);
+  $time = mktime($time_stp[0], $time_stp[1], $time_stp[2], $date[1], $date[2], $date[0]);
+  $human_date = date('d.m.Y H:i:s', $time);
+  echo('<a href="?page=guildy">&lt;- Zpět na výpis</a><br />');
+  echo('<table border="1">
     <tr>
-      <td colspan=\"2\"><font size=\"5\">Guilda : ".$guild_data["name"]."</font></td>
+      <td colspan="2"><font size="5">Guilda : '.$guild_data['name'].'</font></td>
     </tr>
     <tr>
       <th>Datum založení: </th>
-      <td>".$human_date."</td>
+      <td>'.$human_date.'</td>
     </tr>
     <tr>
       <th>Celkem členů: </th>
-      <td>".$total_members." (Online : ".$online_mem["online_mem"].")</td>
+      <td>'.$total_members.' (Online : '.$online_mem['online_mem'].')</td>
     </tr>
-  </table>
-  ";
+  </table>');
+  
   // members info
-  echo "
-  <table border=\"1\">
+  echo('<table border="1">
     <tr>
-      <th align=\"center\">Jméno</th>
-      <th align=\"center\">Rasa</th>
-      <th align=\"center\">Class</th>
-      <th align=\"center\">Úroveň</th>
-      <th align=\"center\">Rank</th>
-      <th align=\"center\">Poslední přihlášení (Dny)</th>
-      <th align=\"center\">Online</th>     
-    </tr>
-  ";
-  while ($member = $members -> fetch_row())
-  {
-    
-    $query = $db -> query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 53+1), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `guid` = '".$member[0]."' LIMIT 1;");
+      <th align="center">Jméno</th>
+      <th align="center">Rasa</th>
+      <th align="center">Class</th>
+      <th align="center">Úroveň</th>
+      <th align="center">Rank</th>
+      <th align="center">Poslední přihlášení (Dny)</th>
+      <th align="center">Online</th>     
+    </tr>');
+  while($member = $members->fetch_row())
+  {    
+    $query = $db->query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".$Config['Mangos']['CharacterDataOffset']['Level']."+1), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".($Config['Mangos']['CharacterDataOffset']['Gender'] + 1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `guid` = '".$member[0]."' LIMIT 1;");
     $online = $query -> fetch_array();
           $accid = $online["account"];
@@ -145 +143 @@
     ";
   }
-echo "</table>";
-
-
-
-
-
-
-}
-else
-{echo "<meta http-equiv=\"refresh\" content=\"0;url=?page=guildy\">";}
+  echo('</table>');
+} else echo('<meta http-equiv="refresh" content="0;url=?page=guildy">');
  
- 
- 
-  
-
-
-
-
 ?>