Changeset 307 for minimanager/guild.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/guild.php (modified) (8 diffs)

minimanager/guild.php

@@ -32 +32 @@
 
  $query = $sql->query("SELECT guild.guildid AS gid, guild.name AS name,guild.leaderguid AS lguid,SUBSTRING_INDEX(guild.MOTD,' ',6), guild.createdate,
-                                                (SELECT name FROM `character` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM guild_member WHERE guildid = gid) AS tot_chars
+                                                (SELECT name FROM `characters` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM guild_member WHERE guildid = gid) AS tot_chars
                                                 FROM guild ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");
  $this_page = $sql->num_rows($query);
@@ -71 +71 @@
 while ($data = $sql->fetch_row($query)) {
 
- $gonline = $sql->query("SELECT count(*) AS GCNT  FROM `guild_member`, `character`, `guild` WHERE guild.guildid = ".$data[0]." AND guild_member.guildid = guild.guildid AND guild_member.guid = character.guid AND character.online = 1;");
+ $gonline = $sql->query("SELECT count(*) AS GCNT  FROM `guild_member`, `characters`, `guild` WHERE guild.guildid = ".$data[0]." AND guild_member.guildid = guild.guildid AND guild_member.guid = characters.guid AND characters.online = 1;");
   $guild_online = $sql->result($gonline,"GCNT");
 
@@ -114 +114 @@
 
 if ($search_by == "leaderguid"){
-        $temp = $sql->query("SELECT guid FROM `character` WHERE name ='$search_value'");
+        $temp = $sql->query("SELECT guid FROM `characters` WHERE name ='$search_value'");
         $search_value = $sql->result($temp, 0, 'guid');
 }
 
  $query = $sql->query("SELECT guild.guildid AS gid, guild.name AS name,guild.leaderguid AS lguid,SUBSTRING_INDEX(guild.MOTD,' ',6), guild.createdate,
-                                                (SELECT name FROM `character` WHERE guid = lguid) AS l_name, (SELECT COUNT(*) FROM guild_member WHERE guildid = gid) AS tot_chars
+                                                (SELECT name FROM `characters` WHERE guid = lguid) AS l_name, (SELECT COUNT(*) FROM guild_member WHERE guildid = gid) AS tot_chars
                                                 FROM guild WHERE $search_by LIKE '%$search_value%' ORDER BY $order_by $order_dir LIMIT $sql_search_limit");
  $total_found = $sql->num_rows($query);
@@ -197 +197 @@
 
  $members = $sql->query("SELECT guild_member.guid, guild_member.rank AS mrank,
-                                                `character`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', 35), ' ', -1) AS level,
-                                                (SELECT rname FROM guild_rank WHERE guildid ='$guild_id' AND rid = mrank) AS rname,
+                                                `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,`character`
-                                                LEFT JOIN guild_member k1 ON k1.`guid`=`character`.`guid`
-                                                WHERE guild_member.guildid = '$guild_id' AND guild_member.guid=`character`.guid
+                                                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");
 
@@ -252 +252 @@
  while ($member = $sql->fetch_row($members)){
 
-        $query = $sql->query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', 35), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `character` WHERE `name` = '$member[2]';");
+        $query = $sql->query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 35), ' ', -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 `name` = '$member[2]';");
 
         $online = $sql->fetch_row($query);
@@ -335 +335 @@
         <td><img src='img/c_icons/{$online[1]}.gif' onmousemove='toolTip(\"".get_player_class($online[1])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
         <td>$lev</td>
-        <td>".($member[4]?$member[4]:$lang_guild['guild_leader'])." ($member[1])</td>
+        <td>$member[4] ($member[1])</td>
         <td>$member[5]</td>
         <td>$member[6]</td>
@@ -405 +405 @@
         $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
-        $char_data = $sql->query("SELECT data FROM `character` WHERE guid = '$guid' LIMIT 1");
+        $char_data = $sql->query("SELECT data FROM `characters` WHERE guid = '$guid' LIMIT 1");
         $data = $sql->result($char_data, 0, 'data');
         $data = explode(' ',$data);
@@ -411 +411 @@
         $data[CHAR_DATA_OFFSET_GUILD_RANK] = 0;
         $data = implode(' ',$data);
-        $sql->query("UPDATE `character` SET data = '$data' WHERE guid = '$guid'");
+        $sql->query("UPDATE `characters` SET data = '$data' WHERE guid = '$guid'");
         $sql->query("DELETE FROM guild_member WHERE guid = '$guid'");