Changeset 307 for minimanager/arenateam.php

Timestamp:

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

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/arenateam.php (modified) (11 diffs)

minimanager/arenateam.php

@@ -32 +32 @@
 
  $query = $sql->query("SELECT arena_team.arenateamid AS atid,  arena_team.name AS atname, arena_team.captainguid AS lguid, arena_team.type AS attype,
-                                        (SELECT name FROM `character` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM  arena_team_member WHERE arenateamid = atid) AS tot_chars,
+                                        (SELECT name FROM `characters` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM  arena_team_member WHERE arenateamid = atid) AS tot_chars,
                                         rating AS atrating, games as atgames, wins as atwins
                                         FROM arena_team, arena_team_stats
@@ -74 +74 @@
 while ($data = $sql->fetch_row($query)) {
 
- $gonline = $sql->query("SELECT count(*) AS GCNT  FROM `arena_team_member`, `character`, `arena_team` WHERE arena_team.arenateamid = ".$data[0]." AND arena_team_member.arenateamid = arena_team.arenateamid AND arena_team_member.guid = character.guid AND character.online = 1;");
+ $gonline = $sql->query("SELECT count(*) AS GCNT  FROM `arena_team_member`, `characters`, `arena_team` WHERE arena_team.arenateamid = ".$data[0]." AND arena_team_member.arenateamid = arena_team.arenateamid AND arena_team_member.guid = characters.guid AND characters.online = 1;");
   $arenateam_online = $sql->result($gonline,"GCNT");
 
@@ -118 +118 @@
 
 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 arena_team.arenateamid AS atid,  arena_team.name AS atname, arena_team.captainguid AS lguid, arena_team.type AS attype,
-                                        (SELECT name FROM `character` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM  arena_team_member WHERE arenateamid = atid) AS tot_chars,
+                                        (SELECT name FROM `characters` WHERE guid = lguid) AS l_name,(SELECT COUNT(*) FROM  arena_team_member WHERE arenateamid = atid) AS tot_chars,
                                         rating AS atrating, games as atgames, wins as atwins
                                         FROM arena_team, arena_team_stats
@@ -164 +164 @@
 while ($data = $sql->fetch_row($query)) {
 
- $gonline = $sql->query("SELECT count(*) AS GCNT  FROM `arena_team_member`, `character`, `arena_team` WHERE arena_team.arenateamid = ".$data[0]." AND arena_team_member.arenateamid = arena_team.arenateamid AND arena_team_member.guid = character.guid AND character.online = 1;");
+ $gonline = $sql->query("SELECT count(*) AS GCNT  FROM `arena_team_member`, `characters`, `arena_team` WHERE arena_team.arenateamid = ".$data[0]." AND arena_team_member.arenateamid = arena_team.arenateamid AND arena_team_member.guid = characters.guid AND characters.online = 1;");
   $arenateam_online = $sql->result($gonline,"GCNT");
 
@@ -215 +215 @@
   $arenateamstats_data = $sql->fetch_row($query);
 
- $members = $sql->query("SELECT arena_team_member.guid,`character`.name,
-                                                `character`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', 35), ' ', -1) AS level,
+ $members = $sql->query("SELECT arena_team_member.guid,`characters`.name,
+                                                `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 35), ' ', -1) AS level,
                                                 arena_team_member.played_week, arena_team_member.wons_week, arena_team_member.played_season, arena_team_member.wons_season
-                                                FROM arena_team_member,`character`
-                                                LEFT JOIN arena_team_member k1 ON k1.`guid`=`character`.`guid`
-                                                WHERE arena_team_member.arenateamid = '$arenateam_id' AND arena_team_member.guid=`character`.guid");
+                                                FROM arena_team_member,`characters`
+                                                LEFT JOIN arena_team_member k1 ON k1.`guid`=`characters`.`guid`
+                                                WHERE arena_team_member.arenateamid = '$arenateam_id' AND arena_team_member.guid=`characters`.guid");
 
  $total_members = $sql->num_rows($members);
@@ -259 +259 @@
      <td colspan=\"11\">{$lang_arenateam['standings']} {$arenateamstats_data[7]} ( {$arenateamstats_data[2]})</td>
   </tr>
-  <tr>
-    <th width=\"3%\">{$lang_arenateam['remove']}</th>
+  <tr>";
+    if ($user_lvl > 2){
+    $output .= " <th width=\"3%\">{$lang_arenateam['remove']}</th>";
+       }
+    $output .= "
         <th width=\"21%\">{$lang_arenateam['name']}</th>
     <th width=\"3%\">Race</th>
@@ -276 +279 @@
  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 FROM `character` WHERE `name` = '$member[1]';");
+        $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[1]';");
 
         $online = $sql->fetch_row($query);
@@ -350 +353 @@
         }
 
-                $output .= " <tr>
-                <td><img src=\"img/aff_cross.png\" alt=\"\" onclick=\"answerBox('{$lang_global['delete']}: <font color=white>{$member[2]}</font><br />{$lang_global['are_you_sure']}', 'arenateam.php?action=rem_char_from_team&amp;id=$member[0]&amp;arenateam_id=$arenateam_id');\" style=\"cursor:pointer;\" /></td>
-                <td><a href=\"char.php?id=$member[0]\">$member[1]</a></td>
-                <td><img src='img/c_icons/{$online[0]}-0.gif' onmousemove='toolTip(\"".get_player_race($online[0])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
+                $output .= " <tr>";
+                if ($user_lvl > 2){
+                $output .= " <td><img src=\"img/aff_cross.png\" alt=\"\" onclick=\"answerBox('{$lang_global['delete']}: <font color=white>{$member[2]}</font><br />{$lang_global['are_you_sure']}', 'arenateam.php?action=rem_char_from_team&amp;id=$member[0]&amp;arenateam_id=$arenateam_id');\" style=\"cursor:pointer;\" /></td>";
+                }
+                $output .= " <td><a href=\"char.php?id=$member[0]\">$member[1]</a></td>
+                <td><img src='img/c_icons/{$online[0]}-{$online[6]}.gif' onmousemove='toolTip(\"".get_player_race($online[0])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                 <td><img src='img/c_icons/{$online[1]}.gif' onmousemove='toolTip(\"".get_player_class($online[1])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                 <td>$lev</td>
@@ -399 +404 @@
                         <font class=\"bold\">{$lang_arenateam['arenateam_id']}: $id {$lang_global['will_be_erased']}</font><br /><br />
                         <form action=\"cleanup.php?action=docleanup\" method=\"post\" name=\"form\">
-                        <input type=\"hidden\" name=\"type\" value=\"guild\" />
+                        <input type=\"hidden\" name=\"type\" value=\"arenateam\" />
                         <input type=\"hidden\" name=\"check\" value=\"-$id\" />
                  <table class=\"hidden\">
@@ -426 +431 @@
         $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);
@@ -432 +437 @@
         //$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 arena_team_member WHERE guid = '$guid'");