Changeset 304 for minimanager/honor.php
- Timestamp:
- Mar 13, 2008, 7:39:11 PM (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
minimanager/honor.php
r178 r304 30 30 guid,name,race,class, 31 31 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS honor , 32 CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1)AS UNSIGNED) AS level, 33 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME 32 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1)AS UNSIGNED) AS level, 33 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME, 34 mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender 34 35 FROM `character` 35 36 where race in (1,3,4,7,11) … … 44 45 </script> 45 46 <center> 46 <fieldset style=\"width: 950px;\">47 <fieldset style=\"width: 776px;\"> 47 48 <legend><img src='img/alliance.gif' /></legend> 48 49 49 <table class=\"lined\" style=\"width: 910px;\">50 <table class=\"lined\" style=\"width: 705px;\"> 50 51 51 52 <tr class=\"bold\"> … … 112 113 $output .= " <tr> 113 114 <td><a href=\"char.php?id=$char[0]\">$char[1]</a></td> 114 <td><img src='img/c_icons/{$char[2]}- 0.gif' onmousemove='toolTip(\"".get_player_race($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>115 <td><img src='img/c_icons/{$char[2]}-{$char[7]}.gif' onmousemove='toolTip(\"".get_player_race($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td> 115 116 <td><img src='img/c_icons/{$char[3]}.gif' onmousemove='toolTip(\"".get_player_class($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td> 116 117 <td>$lev</td> 117 118 <td>$char[4]</td> 118 119 <td><span onmouseover='toolTip(\"".$CHAR_RANK[$CHAR_RACE[$char[2]][1]][pvp_ranks($char[4])]."\",\"item_tooltip\")' onmouseout='toolTip()' style='color: white;'><img src='img/ranks/rank".pvp_ranks($char[4],$CHAR_RACE[$char[2]][1]).".gif'></span></td> 119 <td><a href=\"guild.php? id=$char[6]\">$guild_name[0]</a></td>120 120 <td><a href=\"guild.php?action=view_guild&error=3&id=$char[6]\">$guild_name[0]</a></td> 121 </tr>"; 121 122 } 122 123 … … 127 128 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank , 128 129 CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1)AS UNSIGNED) AS level, 129 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME 130 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME, 131 mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender 130 132 FROM `character` 131 133 where race not in (1,3,4,7,11) … … 141 143 </script> 142 144 <center> 143 <fieldset style=\"width: 950px;\">145 <fieldset style=\"width: 776px;\"> 144 146 <legend><img src='img/horde.gif' /></legend> 145 <table class=\"lined\" style=\"width: 910px;\">147 <table class=\"lined\" style=\"width: 705px;\"> 146 148 <tr class=\"bold\"> 147 149 <td colspan=\"11\">{$lang_honor['horde']} {$lang_honor ['browse_honor']}</td> … … 204 206 $output .= " <tr> 205 207 <td><a href=\"char.php?id=$char[0]\">$char[1]</a></td> 206 <td><img src='img/c_icons/{$char[2]}- 0.gif' onmousemove='toolTip(\"".get_player_race($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>208 <td><img src='img/c_icons/{$char[2]}-{$char[7]}.gif' onmousemove='toolTip(\"".get_player_race($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td> 207 209 <td><img src='img/c_icons/{$char[3]}.gif' onmousemove='toolTip(\"".get_player_class($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td> 208 210 <td>$lev</td> 209 211 <td>$char[4]</td> 210 212 <td><span onmouseover='toolTip(\"".$CHAR_RANK[$CHAR_RACE[$char[2]][1]][pvp_ranks($char[4])]."\",\"item_tooltip\")' onmouseout='toolTip()' style='color: white;'><img src='img/ranks/rank".pvp_ranks($char[4],$CHAR_RACE[$char[2]][1]).".gif'></span></td> 211 <td><a href=\"guild.php? id=$char[6]\">$guild_name[0]</a></td>212 213 <td><a href=\"guild.php?action=view_guild&error=3&id=$char[6]\">$guild_name[0]</a></td> 214 </tr>"; 213 215 } 214 216
Note:
See TracChangeset
for help on using the changeset viewer.