source: test_server/char.php@ 651

Last change on this file since 651 was 651, checked in by aleg, 15 years ago

Změněná cesta k GM a Char logům pro realmy 4 a 7.
File size: 39.6 KB
Line 
1<?php
2
3
4require_once 'header.php';
5require_once 'libs/char_lib.php';
6require_once 'libs/item_lib.php';
7require_once 'libs/spell_lib.php';
8require_once 'libs/map_zone_lib.php';
9valid_login($action_permission['read']);
10
11//########################################################################################################################
12// SHOW GENERAL CHARACTERS INFO
13//########################################################################################################################
14function char_main(&$sqlr, &$sqlc)
15{
16 global $output, $lang_global, $lang_char, $lang_item,
17 $realm_id, $realm_db, $characters_db, $world_db, $server, $mmfpm_db,
18 $action_permission, $user_lvl, $user_name, $user_id,
19 $item_datasite, $spell_datasite , $showcountryflag;
20
21 // this page uses wowhead tooltops
22 wowhead_tt();
23
24 // we need at least an id or we would have nothing to show
25 if (empty($_GET['id']))
26 error($lang_global['empty_fields']);
27
28 // this is multi realm support, as of writing still under development
29 // this page is already implementing it
30 if (empty($_GET['realm']))
31 $realmid = $realm_id;
32 else
33 {
34 $realmid = $sqlr->quote_smart($_GET['realm']);
35 if (is_numeric($realmid))
36 $sqlc->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name']);
37 else
38 $realmid = $realm_id;
39 }
40
41 $id = $sqlc->quote_smart($_GET['id']);
42 if (is_numeric($id));
43 else error($lang_global['empty_fields']);
44
45 $result = $sqlc->query('SELECT account, race FROM characters WHERE guid = '.$id.' LIMIT 1');
46
47 if ($sqlc->num_rows($result))
48 {
49 //resrict by owner's gmlvl
50 $owner_acc_id = $sqlc->result($result, 0, 'account');
51 $query = $sqlr->query('SELECT gmlevel, username FROM account WHERE id = '.$owner_acc_id.'');
52 $owner_gmlvl = $sqlr->result($query, 0, 'gmlevel');
53 $owner_name = $sqlr->result($query, 0, 'username');
54
55 if($user_lvl || $server[$realmid]['both_factions'])
56 {
57 $side_v = 0;
58 $side_p = 0;
59 }
60 else
61 {
62 $side_p = (in_array($sqlc->result($result, 0, 'race'),array(2,5,6,8,10))) ? 1 : 2;
63 $result_1 = $sqlc->query('SELECT race FROM characters WHERE account = '.$user_id.' LIMIT 1');
64 if ($sqlc->num_rows($result))
65 $side_v = (in_array($sqlc->result($result_1, 0, 'race'), array(2,5,6,8,10))) ? 1 : 2;
66 else
67 $side_v = 0;
68 unset($result_1);
69 }
70
71 if ($user_lvl >= $owner_gmlvl && (($side_v === $side_p) || !$side_v))
72 {
73 $result = $sqlc->query('SELECT data, name, race, class, level, zone, map, online, totaltime, gender,
74 account FROM characters WHERE guid = '.$id.'');
75 $char = $sqlc->fetch_assoc($result);
76 $char_data = explode(' ',$char['data']);
77
78 $online = ($char['online']) ? $lang_char['online'] : $lang_char['offline'];
79
80 if($char_data[CHAR_DATA_OFFSET_GUILD_ID])
81 {
82 $guild_name = $sqlc->result($sqlc->query('SELECT name FROM guild WHERE guildid ='.$char_data[CHAR_DATA_OFFSET_GUILD_ID].''), 0, 'name');
83 $guild_name = '<a href="guild.php?action=view_guild&amp;realm='.$realmid.'&amp;error=3&amp;id='.$char_data[CHAR_DATA_OFFSET_GUILD_ID].'" >'.$guild_name.'</a>';
84 $mrank = $char_data[CHAR_DATA_OFFSET_GUILD_RANK] + 1;
85 $guild_rank = $sqlc->result($sqlc->query('SELECT rname FROM guild_rank WHERE guildid ='.$char_data[CHAR_DATA_OFFSET_GUILD_ID].' AND rid='.$mrank.''), 0, 'rname');
86 }
87 else
88 {
89 $guild_name = $lang_global['none'];
90 $guild_rank = $lang_global['none'];
91 }
92
93 $block = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_BLOCK]));
94 $block = round($block[1],2);
95 $dodge = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_DODGE]));
96 $dodge = round($dodge[1],2);
97 $parry = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_PARRY]));
98 $parry = round($parry[1],2);
99 $crit = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_MELEE_CRIT]));
100 $crit = round($crit[1],2);
101 $ranged_crit = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_RANGE_CRIT]));
102 $ranged_crit = round($ranged_crit[1],2);
103 $maxdamage = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_MAXDAMAGE]));
104 $maxdamage = round($maxdamage[1],0);
105 $mindamage = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_MINDAMAGE]));
106 $mindamage = round($mindamage[1],0);
107 $maxrangeddamage = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_MAXRANGEDDAMAGE]));
108 $maxrangeddamage = round($maxrangeddamage[1],0);
109 $minrangeddamage = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_MINRANGEDDAMAGE]));
110 $minrangeddamage = round($minrangeddamage[1],0);
111
112 $spell_crit = 100;
113 for ($i=0; $i<6; ++$i)
114 {
115 $temp = unpack('f', pack('L', $char_data[CHAR_DATA_OFFSET_SPELL_CRIT+1+$i]));
116 if ($temp[1] < $spell_crit)
117 $spell_crit = $temp[1];
118 }
119 $spell_crit = round($spell_crit,2);
120
121 $spell_damage = 9999;
122 for ($i=0; $i<6; ++$i)
123 {
124 if ($char_data[CHAR_DATA_OFFSET_SPELL_DAMAGE+1+$i] < $spell_damage)
125 $spell_damage = $char_data[CHAR_DATA_OFFSET_SPELL_DAMAGE+1+$i];
126 }
127
128 $rage = round($char_data[CHAR_DATA_OFFSET_RAGE] / 10);
129 $maxrage = round($char_data[CHAR_DATA_OFFSET_MAX_RAGE] / 10);
130 $expertise = ''.$char_data[CHAR_DATA_OFFSET_EXPERTISE].' / '.$char_data[CHAR_DATA_OFFSET_OFFHAND_EXPERTISE].'';
131
132 $EQU_HEAD = $char_data[CHAR_DATA_OFFSET_EQU_HEAD];
133 $EQU_NECK = $char_data[CHAR_DATA_OFFSET_EQU_NECK];
134 $EQU_SHOULDER = $char_data[CHAR_DATA_OFFSET_EQU_SHOULDER];
135 $EQU_SHIRT = $char_data[CHAR_DATA_OFFSET_EQU_SHIRT];
136 $EQU_CHEST = $char_data[CHAR_DATA_OFFSET_EQU_CHEST];
137 $EQU_BELT = $char_data[CHAR_DATA_OFFSET_EQU_BELT];
138 $EQU_LEGS = $char_data[CHAR_DATA_OFFSET_EQU_LEGS];
139 $EQU_FEET = $char_data[CHAR_DATA_OFFSET_EQU_FEET];
140 $EQU_WRIST = $char_data[CHAR_DATA_OFFSET_EQU_WRIST];
141 $EQU_GLOVES = $char_data[CHAR_DATA_OFFSET_EQU_GLOVES];
142 $EQU_FINGER1 = $char_data[CHAR_DATA_OFFSET_EQU_FINGER1];
143 $EQU_FINGER2 = $char_data[CHAR_DATA_OFFSET_EQU_FINGER2];
144 $EQU_TRINKET1 = $char_data[CHAR_DATA_OFFSET_EQU_TRINKET1];
145 $EQU_TRINKET2 = $char_data[CHAR_DATA_OFFSET_EQU_TRINKET2];
146 $EQU_BACK = $char_data[CHAR_DATA_OFFSET_EQU_BACK];
147 $EQU_MAIN_HAND = $char_data[CHAR_DATA_OFFSET_EQU_MAIN_HAND];
148 $EQU_OFF_HAND = $char_data[CHAR_DATA_OFFSET_EQU_OFF_HAND];
149 $EQU_RANGED = $char_data[CHAR_DATA_OFFSET_EQU_RANGED];
150 $EQU_TABARD = $char_data[CHAR_DATA_OFFSET_EQU_TABARD];
151/*
152// reserved incase we want to use back minimanagers' built in tooltip, instead of wowheads'
153// minimanagers' item tooltip needs updating, but it can show enchantments and sockets.
154
155 $equiped_items = array
156 (
157 1 => array(($EQU_HEAD ? get_item_tooltip($EQU_HEAD) : 0),($EQU_HEAD ? get_item_icon($EQU_HEAD) : 0),($EQU_HEAD ? get_item_border($EQU_HEAD) : 0)),
158 2 => array(($EQU_NECK ? get_item_tooltip($EQU_NECK) : 0),($EQU_NECK ? get_item_icon($EQU_NECK) : 0),($EQU_NECK ? get_item_border($EQU_NECK) : 0)),
159 3 => array(($EQU_SHOULDER ? get_item_tooltip($EQU_SHOULDER) : 0),($EQU_SHOULDER ? get_item_icon($EQU_SHOULDER) : 0),($EQU_SHOULDER ? get_item_border($EQU_SHOULDER) : 0)),
160 4 => array(($EQU_SHIRT ? get_item_tooltip($EQU_SHIRT) : 0),($EQU_SHIRT ? get_item_icon($EQU_SHIRT) : 0),($EQU_SHIRT ? get_item_border($EQU_SHIRT) : 0)),
161 5 => array(($EQU_CHEST ? get_item_tooltip($EQU_CHEST) : 0),($EQU_CHEST ? get_item_icon($EQU_CHEST) : 0),($EQU_CHEST ? get_item_border($EQU_CHEST) : 0)),
162 6 => array(($EQU_BELT ? get_item_tooltip($EQU_BELT) : 0),($EQU_BELT ? get_item_icon($EQU_BELT) : 0),($EQU_BELT ? get_item_border($EQU_BELT) : 0)),
163 7 => array(($EQU_LEGS ? get_item_tooltip($EQU_LEGS) : 0),($EQU_LEGS ? get_item_icon($EQU_LEGS) : 0),($EQU_LEGS ? get_item_border($EQU_LEGS) : 0)),
164 8 => array(($EQU_FEET ? get_item_tooltip($EQU_FEET) : 0),($EQU_FEET ? get_item_icon($EQU_FEET) : 0),($EQU_FEET ? get_item_border($EQU_FEET) : 0)),
165 9 => array(($EQU_WRIST ? get_item_tooltip($EQU_WRIST) : 0),($EQU_WRIST ? get_item_icon($EQU_WRIST) : 0),($EQU_WRIST ? get_item_border($EQU_WRIST) : 0)),
166 10 => array(($EQU_GLOVES ? get_item_tooltip($EQU_GLOVES) : 0),($EQU_GLOVES ? get_item_icon($EQU_GLOVES) : 0),($EQU_GLOVES ? get_item_border($EQU_GLOVES) : 0)),
167 11 => array(($EQU_FINGER1 ? get_item_tooltip($EQU_FINGER1) : 0),($EQU_FINGER1 ? get_item_icon($EQU_FINGER1) : 0),($EQU_FINGER1 ? get_item_border($EQU_FINGER1) : 0)),
168 12 => array(($EQU_FINGER2 ? get_item_tooltip($EQU_FINGER2) : 0),($EQU_FINGER2 ? get_item_icon($EQU_FINGER2) : 0),($EQU_FINGER2 ? get_item_border($EQU_FINGER2) : 0)),
169 13 => array(($EQU_TRINKET1 ? get_item_tooltip($EQU_TRINKET1) : 0),($EQU_TRINKET1 ? get_item_icon($EQU_TRINKET1) : 0),($EQU_TRINKET1 ? get_item_border($EQU_TRINKET1) : 0)),
170 14 => array(($EQU_TRINKET2 ? get_item_tooltip($EQU_TRINKET2) : 0),($EQU_TRINKET2 ? get_item_icon($EQU_TRINKET2) : 0),($EQU_TRINKET2 ? get_item_border($EQU_TRINKET2) : 0)),
171 15 => array(($EQU_BACK ? get_item_tooltip($EQU_BACK) : 0),($EQU_BACK ? get_item_icon($EQU_BACK) : 0),($EQU_BACK ? get_item_border($EQU_BACK) : 0)),
172 16 => array(($EQU_MAIN_HAND ? get_item_tooltip($EQU_MAIN_HAND) : 0),($EQU_MAIN_HAND ? get_item_icon($EQU_MAIN_HAND) : 0),($EQU_MAIN_HAND ? get_item_border($EQU_MAIN_HAND) : 0)),
173 17 => array(($EQU_OFF_HAND ? get_item_tooltip($EQU_OFF_HAND) : 0),($EQU_OFF_HAND ? get_item_icon($EQU_OFF_HAND) : 0),($EQU_OFF_HAND ? get_item_border($EQU_OFF_HAND) : 0)),
174 18 => array(($EQU_RANGED ? get_item_tooltip($EQU_RANGED) : 0),($EQU_RANGED ? get_item_icon($EQU_RANGED) : 0),($EQU_RANGED ? get_item_border($EQU_RANGED) : 0)),
175 19 => array(($EQU_TABARD ? get_item_tooltip($EQU_TABARD) : 0),($EQU_TABARD ? get_item_icon($EQU_TABARD) : 0),($EQU_TABARD ? get_item_border($EQU_TABARD) : 0))
176 );
177*/
178
179 $sqlm = new SQL;
180 $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
181
182 $sqlw = new SQL;
183 $sqlw->connect($world_db[$realmid]['addr'], $world_db[$realmid]['user'], $world_db[$realmid]['pass'], $world_db[$realmid]['name']);
184
185 $equiped_items = array
186 (
187 1 => array('',($EQU_HEAD ? get_item_icon($EQU_HEAD, $sqlm, $sqlw) : 0),($EQU_HEAD ? get_item_border($EQU_HEAD, $sqlw) : 0)),
188 2 => array('',($EQU_NECK ? get_item_icon($EQU_NECK, $sqlm, $sqlw) : 0),($EQU_NECK ? get_item_border($EQU_NECK, $sqlw) : 0)),
189 3 => array('',($EQU_SHOULDER ? get_item_icon($EQU_SHOULDER, $sqlm, $sqlw) : 0),($EQU_SHOULDER ? get_item_border($EQU_SHOULDER, $sqlw) : 0)),
190 4 => array('',($EQU_SHIRT ? get_item_icon($EQU_SHIRT, $sqlm, $sqlw) : 0),($EQU_SHIRT ? get_item_border($EQU_SHIRT, $sqlw) : 0)),
191 5 => array('',($EQU_CHEST ? get_item_icon($EQU_CHEST, $sqlm, $sqlw) : 0),($EQU_CHEST ? get_item_border($EQU_CHEST, $sqlw) : 0)),
192 6 => array('',($EQU_BELT ? get_item_icon($EQU_BELT, $sqlm, $sqlw) : 0),($EQU_BELT ? get_item_border($EQU_BELT, $sqlw) : 0)),
193 7 => array('',($EQU_LEGS ? get_item_icon($EQU_LEGS, $sqlm, $sqlw) : 0),($EQU_LEGS ? get_item_border($EQU_LEGS, $sqlw) : 0)),
194 8 => array('',($EQU_FEET ? get_item_icon($EQU_FEET, $sqlm, $sqlw) : 0),($EQU_FEET ? get_item_border($EQU_FEET, $sqlw) : 0)),
195 9 => array('',($EQU_WRIST ? get_item_icon($EQU_WRIST, $sqlm, $sqlw) : 0),($EQU_WRIST ? get_item_border($EQU_WRIST, $sqlw) : 0)),
196 10 => array('',($EQU_GLOVES ? get_item_icon($EQU_GLOVES, $sqlm, $sqlw) : 0),($EQU_GLOVES ? get_item_border($EQU_GLOVES, $sqlw) : 0)),
197 11 => array('',($EQU_FINGER1 ? get_item_icon($EQU_FINGER1, $sqlm, $sqlw) : 0),($EQU_FINGER1 ? get_item_border($EQU_FINGER1, $sqlw) : 0)),
198 12 => array('',($EQU_FINGER2 ? get_item_icon($EQU_FINGER2, $sqlm, $sqlw) : 0),($EQU_FINGER2 ? get_item_border($EQU_FINGER2, $sqlw) : 0)),
199 13 => array('',($EQU_TRINKET1 ? get_item_icon($EQU_TRINKET1, $sqlm, $sqlw) : 0),($EQU_TRINKET1 ? get_item_border($EQU_TRINKET1, $sqlw) : 0)),
200 14 => array('',($EQU_TRINKET2 ? get_item_icon($EQU_TRINKET2, $sqlm, $sqlw) : 0),($EQU_TRINKET2 ? get_item_border($EQU_TRINKET2, $sqlw) : 0)),
201 15 => array('',($EQU_BACK ? get_item_icon($EQU_BACK, $sqlm, $sqlw) : 0),($EQU_BACK ? get_item_border($EQU_BACK, $sqlw) : 0)),
202 16 => array('',($EQU_MAIN_HAND ? get_item_icon($EQU_MAIN_HAND, $sqlm, $sqlw) : 0),($EQU_MAIN_HAND ? get_item_border($EQU_MAIN_HAND, $sqlw) : 0)),
203 17 => array('',($EQU_OFF_HAND ? get_item_icon($EQU_OFF_HAND, $sqlm, $sqlw) : 0),($EQU_OFF_HAND ? get_item_border($EQU_OFF_HAND, $sqlw) : 0)),
204 18 => array('',($EQU_RANGED ? get_item_icon($EQU_RANGED, $sqlm, $sqlw) : 0),($EQU_RANGED ? get_item_border($EQU_RANGED, $sqlw) : 0)),
205 19 => array('',($EQU_TABARD ? get_item_icon($EQU_TABARD, $sqlm, $sqlw) : 0),($EQU_TABARD ? get_item_border($EQU_TABARD, $sqlw) : 0))
206 );
207
208 $output .= '
209 <!-- start of char.php -->
210 <center>
211 <div id="tab">
212 <ul>
213 <li id="selected"><a href="char.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['char_sheet'].'</a></li>';
214
215 if (($user_lvl > $owner_gmlvl)||($owner_name === $user_name))
216 {
217 $output .= '
218 <li><a href="char_inv.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['inventory'].'</a></li>
219 '.(($char['level'] < 10) ? '' : '<li><a href="char_talent.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['talents'].'</a></li>').'
220 <li><a href="char_achieve.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['achievements'].'</a></li>
221 <li><a href="char_quest.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['quests'].'</a></li>
222 <li><a href="char_friends.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['friends'].'</a></li>
223 </ul>
224 </div>
225 <div id="tab_content">
226 <div id="tab">
227 <ul>
228 <li id="selected"><a href="char.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['char_sheet'].'</a></li>';
229 if (char_get_class_name($char['class']) === 'Hunter' )
230 $output .= '
231 <li><a href="char_pets.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['pets'].'</a></li>';
232 $output .= '
233 <li><a href="char_rep.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['reputation'].'</a></li>
234 <li><a href="char_skill.php?id='.$id.'&amp;realm='.$realmid.'">'.$lang_char['skills'].'</a></li>';
235 }
236 else
237 $output .='
238 </ul>
239 </div>
240 <div id="tab_content">
241 <div id="tab">
242 <ul>';
243 $output .='
244 </ul>
245 </div>
246 <div id="tab_content2">
247 <table class="lined" style="width: 580px;">
248 <tr>
249 <td colspan="2">
250 <div>
251 <img src="'.char_get_avatar_img($char['level'], $char['gender'], $char['race'], $char['class'], 0).'" alt="avatar" />
252 </div>
253 <div>';
254 $a_results = $sqlc->query('SELECT DISTINCT spell FROM character_aura WHERE guid = '.$id.'');
255 if ($sqlc->num_rows($a_results))
256 {
257 while ($aura = $sqlc->fetch_assoc($a_results))
258 {
259 $output .= '
260 <a style="padding:2px;" href="'.$spell_datasite.$aura['spell'].'" target="_blank">
261 <img src="'.spell_get_icon($aura['spell'], $sqlm).'" alt="'.$aura['spell'].'" width="24" height="24" />
262 </a>';
263 }
264 }
265 $output .= '
266 </div>
267 </td>
268 <td colspan="4">
269 <font class="bold">
270 '.htmlentities($char['name']).' -
271 <img src="img/c_icons/'.$char['race'].'-'.$char['gender'].'.gif" onmousemove="toolTip(\''.char_get_race_name($char['race']).'\', \'item_tooltip\')" onmouseout="toolTip()" alt="" />
272 <img src="img/c_icons/'.$char['class'].'.gif" onmousemove="toolTip(\''.char_get_class_name($char['class']).'\', \'item_tooltip\')" onmouseout="toolTip()" alt="" />
273 - lvl '.char_get_level_color($char['level']).'
274 </font>
275 <br />'.get_map_name($char['map'], $sqlm).' - '.get_zone_name($char['zone'], $sqlm).'
276 <br />'.$lang_char['honor_points'].': '.$char_data[CHAR_DATA_OFFSET_HONOR_POINTS].' / '.$char_data[CHAR_DATA_OFFSET_ARENA_POINTS].' - '.$lang_char['honor_kills'].': '.$char_data[CHAR_DATA_OFFSET_HONOR_KILL].'
277 <br />'.$lang_char['guild'].': '.$guild_name.' | '.$lang_char['rank'].': '.htmlentities($guild_rank).'
278 <br />'.(($char['online']) ? '<img src="img/up.gif" onmousemove="toolTip(\'Online\', \'item_tooltip\')" onmouseout="toolTip()" alt="online" />' : '<img src="img/down.gif" onmousemove="toolTip(\'Offline\', \'item_tooltip\')" onmouseout="toolTip()" alt="offline" />');
279 if ($showcountryflag)
280 {
281 require_once 'libs/misc_lib.php';
282 $country = misc_get_country_by_account($char['account'], $sqlr, $sqlm);
283 $output .= ' - '.(($country['code']) ? '<img src="img/flags/'.$country['code'].'.png" onmousemove="toolTip(\''.($country['country']).'\', \'item_tooltip\')" onmouseout="toolTip()" alt="" />' : '-');
284 unset($country);
285 }
286 $output .= '
287 </td>
288 </tr>
289 <tr>
290 <td width="6%">';
291 if (($equiped_items[1][1]))
292 $output .= '
293 <a style="padding:2px;" href="'.$item_datasite.$EQU_HEAD.'" target="_blank">
294 <img src="'.$equiped_items[1][1].'" class="'.$equiped_items[1][2].'" alt="Head" />
295 </a>';
296 else
297 $output .= '
298 <img src="img/INV/INV_empty_head.png" class="icon_border_0" alt="empty" />';
299 $output .= '
300 </td>
301 <td class="half_line" colspan="2" align="center" width="50%">
302 <div class="gradient_p">'.$lang_item['health'].':</div>
303 <div class="gradient_pp">'.$char_data[CHAR_DATA_OFFSET_MAX_HEALTH].'</div>';
304 if ($char['class'] == 11) //druid
305 $output .= '
306 </br>
307 <div class="gradient_p">'.$lang_item['energy'].':</div>
308 <div class="gradient_pp">'.$char_data[CHAR_DATA_OFFSET_ENERGY].'/'.$char_data[CHAR_DATA_OFFSET_MAX_ENERGY].'</div>';
309 $output .= '
310 </td>
311 <td class="half_line" colspan="2" align="center" width="50%">';
312 if ($char['class'] == 1) // warrior
313 {
314 $output .= '
315 <div class="gradient_p">'.$lang_item['rage'].':</div>
316 <div class="gradient_pp">'.$rage.'/'.$maxrage.'</div>';
317 }
318 elseif ($char['class'] == 4) // rogue
319 {
320 $output .= '
321 <div class="gradient_p">'.$lang_item['energy'].':</div>
322 <div class="gradient_pp">'.$char_data[CHAR_DATA_OFFSET_ENERGY].'/'.$char_data[CHAR_DATA_OFFSET_MAX_ENERGY].'</div>';
323 }
324 elseif ($char['class'] == 6) // death knight
325 {
326 // Don't know if FOCUS is the right one need to verify with Death Knight player.
327 $output .= '
328 <div class="gradient_p">'.$lang_item['runic'].':</div>
329 <div class="gradient_pp">'.$char_data[CHAR_DATA_OFFSET_FOCUS].'/'.$char_data[CHAR_DATA_OFFSET_MAX_FOCUS].'</div>';
330 }
331 elseif ($char['class'] == 11) // druid
332 {
333 $output .= '
334 <div class="gradient_p">'.$lang_item['mana'].':</div>
335 <div class="gradient_pp">'.$char_data[CHAR_DATA_OFFSET_MAX_MANA].'</div>
336 </br>
337 <div class="gradient_p">'.$lang_item['rage'].':</div>
338 <div class="gradient_pp">'.$rage.'/'.$maxrage.'</div>';
339 }
340 elseif ($char['class'] == 2 || // paladin
341 $char['class'] == 3 || // hunter
342 $char['class'] == 5 || // priest
343 $char['class'] == 7 || // shaman
344 $char['class'] == 8 || // mage
345 $char['class'] == 9) // warlock
346 {
347 $output .= '
348 <div class="gradient_p">'.$lang_item['mana'].':</div>
349 <div class="gradient_pp">'.$char_data[CHAR_DATA_OFFSET_MAX_MANA].'</div>';
350 }
351 $output .= '
352 </td>
353 <td width="6%">';
354 if (($equiped_items[10][1]))
355 $output .= '
356 <a style="padding:2px;" href="'.$item_datasite.$EQU_GLOVES.'" target="_blank">
357 <img src="'.$equiped_items[10][1].'" class="'.$equiped_items[10][2].'" alt="Gloves" />
358 </a>';
359 else
360 $output .= '
361 <img src="img/INV/INV_empty_gloves.png" class="icon_border_0" alt="empty" />';
362 $output .= '
363 </td>
364 </tr>
365 <tr>
366 <td width="1%">';
367 if (($equiped_items[2][1]))
368 $output .= '
369 <a style="padding:2px;" href="'.$item_datasite.$EQU_NECK.'" target="_blank">
370 <img src="'.$equiped_items[2][1].'" class="'.$equiped_items[2][2].'" alt="Neck" />
371 </a>';
372 else
373 $output .= '
374 <img src="img/INV/INV_empty_neck.png" class="icon_border_0" alt="empty" />';
375 $output .= '
376 </td>
377 <td class="half_line" colspan="2" rowspan="3" align="center" width="50%">
378 <div class="gradient_p">
379 '.$lang_item['strength'].':<br />
380 '.$lang_item['agility'].':<br />
381 '.$lang_item['stamina'].':<br />
382 '.$lang_item['intellect'].':<br />
383 '.$lang_item['spirit'].':<br />
384 '.$lang_item['armor'].':
385 </div>
386 <div class="gradient_pp">
387 '.$char_data[CHAR_DATA_OFFSET_STR].'<br />
388 '.$char_data[CHAR_DATA_OFFSET_AGI].'<br />
389 '.$char_data[CHAR_DATA_OFFSET_STA].'<br />
390 '.$char_data[CHAR_DATA_OFFSET_INT].'<br />
391 '.$char_data[CHAR_DATA_OFFSET_SPI].'<br />
392 '.$char_data[CHAR_DATA_OFFSET_ARMOR].'
393 </div>
394 </td>
395 <td class="half_line" colspan="2" rowspan="3" align="center" width="50%">
396 <div class="gradient_p">
397 '.$lang_item['res_holy'].':<br />
398 '.$lang_item['res_arcane'].':<br />
399 '.$lang_item['res_fire'].':<br />
400 '.$lang_item['res_nature'].':<br />
401 '.$lang_item['res_frost'].':<br />
402 '.$lang_item['res_shadow'].':
403 </div>
404 <div class="gradient_pp">
405 '.$char_data[CHAR_DATA_OFFSET_RES_HOLY].'<br />
406 '.$char_data[CHAR_DATA_OFFSET_RES_ARCANE].'<br />
407 '.$char_data[CHAR_DATA_OFFSET_RES_FIRE].'<br />
408 '.$char_data[CHAR_DATA_OFFSET_RES_NATURE].'<br />
409 '.$char_data[CHAR_DATA_OFFSET_RES_FROST].'<br />
410 '.$char_data[CHAR_DATA_OFFSET_RES_SHADOW].'
411 </div>
412 </td>
413 <td width="1%">';
414 if (($equiped_items[6][1]))
415 $output .= '
416 <a style="padding:2px;" href="'.$item_datasite.$EQU_BELT.'" target="_blank">
417 <img src="'.$equiped_items[6][1].'" class="'.$equiped_items[6][2].'" alt="Belt" />
418 </a>';
419 else
420 $output .= '
421 <img src="img/INV/INV_empty_waist.png" class="icon_border_0" alt="empty" />';
422 $output .= '
423 </td>
424 </tr>
425 <tr>
426 <td width="1%">';
427 if (($equiped_items[3][1]))
428 $output .= '
429 <a style="padding:2px;" href="'.$item_datasite.$EQU_SHOULDER.'" target="_blank">
430 <img src="'.$equiped_items[3][1].'" class="'.$equiped_items[3][2].'" alt="Shoulder" />
431 </a>';
432 else
433 $output .= '
434 <img src="img/INV/INV_empty_shoulder.png" class="icon_border_0" alt="empty" />';
435 $output .= '
436 </td>
437 <td width="1%">';
438 if (($equiped_items[7][1]))
439 $output .= '
440 <a style="padding:2px;" href="'.$item_datasite.$EQU_LEGS.'" target="_blank">
441 <img src="'.$equiped_items[7][1].'" class="'.$equiped_items[7][2].'" alt="Legs" />
442 </a>';
443 else
444 $output .= '
445 <img src="img/INV/INV_empty_legs.png" class="icon_border_0" alt="empty" />';
446 $output .= '
447 </td>
448 </tr>
449 <tr>
450 <td width="1%">';
451 if (($equiped_items[15][1]))
452 $output .= '
453 <a style="padding:2px;" href="'.$item_datasite.$EQU_BACK.'" target="_blank">
454 <img src="'.$equiped_items[15][1].'" class="'.$equiped_items[15][2].'" alt="Back" />
455 </a>';
456 else
457 $output .= '
458 <img src="img/INV/INV_empty_chest_back.png" class="icon_border_0" alt="empty" />';
459 $output .= '
460 </td>
461 <td width="1%">';
462 if (($equiped_items[8][1]))
463 $output .= '
464 <a style="padding:2px;" href="'.$item_datasite.$EQU_FEET.'" target="_blank">
465 <img src="'.$equiped_items[8][1].'" class="'.$equiped_items[8][2].'" alt="Feet" />
466 </a>';
467 else
468 $output .= '
469 <img src="img/INV/INV_empty_feet.png" class="icon_border_0" alt="empty" />';
470 $output .= '
471 </td>
472 </tr>
473 <tr>
474 <td width="1%">';
475 if (($equiped_items[5][1]))
476 $output .= '
477 <a style="padding:2px;" href="'.$item_datasite.$EQU_CHEST.'" target="_blank">
478 <img src="'.$equiped_items[5][1].'" class="'.$equiped_items[5][2].'" alt="Chest" />
479 </a>';
480 else
481 $output .= '
482 <img src="img/INV/INV_empty_chest_back.png" class="icon_border_0" alt="empty" />';
483 $output .= '
484 </td>
485 <td class="half_line" colspan="2" rowspan="2" align="center" width="50%">
486 <div class="gradient_p">
487 '.$lang_char['melee_d'].':<br />
488 '.$lang_char['melee_ap'].':<br />
489 '.$lang_char['melee_hit'].':<br />
490 '.$lang_char['melee_crit'].':<br />
491 '.$lang_char['expertise'].':<br />
492 </div>
493 <div class="gradient_pp">
494 '.$mindamage.'-'.$maxdamage.'<br />
495 '.($char_data[CHAR_DATA_OFFSET_AP]+$char_data[CHAR_DATA_OFFSET_AP_MOD]).'<br />
496 '.$char_data[CHAR_DATA_OFFSET_MELEE_HIT].'<br />
497 '.$crit.'%<br />
498 '.$expertise.'<br />
499 </div>
500 </td>
501 <td class="half_line" colspan="2" rowspan="2" align="center" width="50%">
502 <div class="gradient_p">
503 '.$lang_char['spell_d'].':<br />
504 '.$lang_char['spell_heal'].':<br />
505 '.$lang_char['spell_hit'].':<br />
506 '.$lang_char['spell_crit'].':<br />
507 '.$lang_char['spell_haste'].'
508 </div>
509 <div class="gradient_pp">
510 '.$spell_damage.'<br />
511 '.$char_data[CHAR_DATA_OFFSET_SPELL_HEAL].'<br />
512 '.$char_data[CHAR_DATA_OFFSET_SPELL_HIT].'<br />
513 '.$spell_crit.'%<br />
514 '.$char_data[CHAR_DATA_OFFSET_SPELL_HASTE_RATING].'
515 </div>
516 </td>
517 <td width="1%">';
518 if (($equiped_items[11][1]))
519 $output .= '
520 <a style="padding:2px;" href="'.$item_datasite.$EQU_FINGER1.'" target="_blank">
521 <img src="'.$equiped_items[11][1].'" class="'.$equiped_items[11][2].'" alt="Finger1" />
522 </a>';
523 else
524 $output .= '
525 <img src="img/INV/INV_empty_finger.png" class="icon_border_0" alt="empty" />';
526 $output .= '
527 </td>
528 </tr>
529 <tr>
530 <td width="1%">';
531 if (($equiped_items[4][1]))
532 $output .= '
533 <a style="padding:2px;" href="'.$item_datasite.$EQU_SHIRT.'" target="_blank">
534 <img src="'.$equiped_items[4][1].'" class="'.$equiped_items[4][2].'" alt="Shirt" />
535 </a>';
536 else
537 $output .= '
538 <img src="img/INV/INV_empty_shirt.png" class="icon_border_0" alt="empty" />';
539 $output .= '
540 </td>
541 <td width="1%">';
542 if (($equiped_items[12][1]))
543 $output .= '
544 <a style="padding:2px;" href="'.$item_datasite.$EQU_FINGER2.'" target="_blank">
545 <img src="'.$equiped_items[12][1].'" class="'.$equiped_items[12][2].'" alt="Finger2" />
546 </a>';
547 else $output .= '
548 <img src="img/INV/INV_empty_finger.png" class="icon_border_0" alt="empty" />';
549 $output .= '
550 </td>
551 </tr>
552 <tr>
553 <td width="1%">';
554 if (($equiped_items[19][1]))
555 $output .= '
556 <a style="padding:2px;" href="'.$item_datasite.$EQU_TABARD.'" target="_blank">
557 <img src="'.$equiped_items[19][1].'" class="'.$equiped_items[19][2].'" alt="Tabard" />
558 </a>';
559 else $output .= '
560 <img src="img/INV/INV_empty_tabard.png" class="icon_border_0" alt="empty" />';
561 $output .= '
562 </td>
563 <td class="half_line" colspan="2" rowspan="2" align="center" width="50%">
564 <div class="gradient_p">
565 '.$lang_char['dodge'].':<br />
566 '.$lang_char['parry'].':<br />
567 '.$lang_char['block'].':
568 </div>
569 <div class="gradient_pp">
570 '.$dodge.'%<br />
571 '.$parry.'%<br />
572 '.$block.'%
573 </div>
574 </td>
575 <td class="half_line" colspan="2" rowspan="2" align="center" width="50%">
576 <div class="gradient_p">
577 '.$lang_char['ranged_d'].':<br />
578 '.$lang_char['ranged_ap'].':<br />
579 '.$lang_char['ranged_hit'].':<br />
580 '.$lang_char['ranged_crit'].':<br />
581 </div>
582 <div class="gradient_pp">
583 '.$minrangeddamage.'-'.$maxrangeddamage.'<br />
584 '.($char_data[CHAR_DATA_OFFSET_RANGED_AP]+$char_data[CHAR_DATA_OFFSET_RANGED_AP_MOD]).'<br />
585 '.$char_data[CHAR_DATA_OFFSET_RANGE_HIT].'<br />
586 '.$ranged_crit.'%<br />
587 </div>
588 </td>
589 <td width="1%">';
590 if (($equiped_items[13][1]))
591 $output .= '
592 <a style="padding:2px;" href="'.$item_datasite.$EQU_TRINKET1.'" target="_blank">
593 <img src="'.$equiped_items[13][1].'" class="'.$equiped_items[13][2].'" alt="Trinket1" />
594 </a>';
595 else
596 $output .= '
597 <img src="img/INV/INV_empty_trinket.png" class="icon_border_0" alt="empty" />';
598 $output .= '
599 </td>
600 </tr>
601 <tr>
602 <td width="1%">';
603 if (($equiped_items[9][1]))
604 $output .= '
605 <a style="padding:2px;" href="'.$item_datasite.$EQU_WRIST.'" target="_blank">
606 <img src="'.$equiped_items[9][1].'" class="'.$equiped_items[9][2].'" alt="Wrist" />
607 </a>';
608 else
609 $output .= '
610 <img src="img/INV/INV_empty_wrist.png" class="icon_border_0" alt="empty" />';
611 $output .= '
612 </td>
613 <td width="1%">';
614 if (($equiped_items[14][1]))
615 $output .= '
616 <a style="padding:2px;" href="'.$item_datasite.$EQU_TRINKET2.'" target="_blank">
617 <img src="'.$equiped_items[14][1].'" class="'.$equiped_items[14][2].'" alt="Trinket2" />
618 </a>';
619 else
620 $output .= '
621 <img src="img/INV/INV_empty_trinket.png" class="icon_border_0" alt="empty" />';
622 $output .= '
623 </td>
624 </tr>
625 <tr>
626 <td></td>
627 <td width="15%">';
628 if (($equiped_items[16][1]))
629 $output .= '
630 <a style="padding:2px;" href="'.$item_datasite.$EQU_MAIN_HAND.'" target="_blank">
631 <img src="'.$equiped_items[16][1].'" class="'.$equiped_items[16][2].'" alt="MainHand" />
632 </a>';
633 else
634 $output .= '
635 <img src="img/INV/INV_empty_main_hand.png" class="icon_border_0" alt="empty" />';
636 $output .= '
637 </td>
638 <td width="15%">';
639 if (($equiped_items[17][1]))
640 $output .= '
641 <a style="padding:2px;" href="'.$item_datasite.$EQU_OFF_HAND.'" target="_blank">
642 <img src="'.$equiped_items[17][1].'" class="'.$equiped_items[17][2].'" alt="OffHand" />
643 </a>';
644 else
645 $output .= '
646 <img src="img/INV/INV_empty_off_hand.png" class="icon_border_0" alt="empty" />';
647 $output .= '
648 </td>
649 <td width="15%">';
650 if (($equiped_items[18][1]))
651 $output .= '
652 <a style="padding:2px;" href="'.$item_datasite.$EQU_RANGED.'" target="_blank">
653 <img src="'.$equiped_items[18][1].'" class="'.$equiped_items[18][2].'" alt="Ranged" />
654 </a>';
655 else
656 $output .= '
657 <img src="img/INV/INV_empty_ranged.png" class="icon_border_0" alt="empty" />';
658 $output .= '
659 </td>
660 <td width="15%"></td>
661 <td></td>
662 </tr>';
663 if (($user_lvl > $owner_gmlvl)||($owner_name === $user_name))
664 {
665 //total time played
666 $tot_time = $char['totaltime'];
667 $tot_days = (int)($tot_time/86400);
668 $tot_time = $tot_time - ($tot_days*86400);
669 $total_hours = (int)($tot_time/3600);
670 $tot_time = $tot_time - ($total_hours*3600);
671 $total_min = (int)($tot_time/60);
672
673 $output .= '
674 <tr>
675 <td colspan="6">
676 '.$lang_char['tot_paly_time'].': '.$tot_days.' '.$lang_char['days'].' '.$total_hours.' '.$lang_char['hours'].' '.$total_min.' '.$lang_char['min'].'
677 </td>
678 </tr>';
679 }
680 $output .= '
681 </table>
682 </div>
683 <br />
684 </div>
685 <br />
686 <table class="hidden">
687 <tr>
688 <td>';
689 // button to user account page, user account page has own security
690 makebutton($lang_char['chars_acc'], 'user.php?action=edit_user&amp;id='.$owner_acc_id.'', 130);
691 $output .= '
692 </td>
693 <td>';
694
695 // only higher level GM with delete access can edit character
696 // character edit allows removal of character items, so delete permission is needed
697 if ( ($user_lvl > $owner_gmlvl) && ($user_lvl >= $action_permission['delete']) )
698 {
699 makebutton($lang_char['edit_button'], 'char_edit.php?id='.$id.'&amp;realm='.$realmid.'', 130);
700 $output .= '
701 </td>
702 <td>';
703 }
704 // only higher level GM with delete access, or character owner can delete character
705 if ( ( ($user_lvl > $owner_gmlvl) && ($user_lvl >= $action_permission['delete']) ) || ($owner_name === $user_name) )
706 {
707 makebutton($lang_char['del_char'], 'char_list.php?action=del_char_form&amp;check%5B%5D='.$id.'" type="wrn', 130);
708 $output .= '
709 </td>
710 <td>';
711 }
712 // only GM with update permission can send mail, mail can send items, so update permission is needed
713 if ($user_lvl >= $action_permission['update'])
714 {
715 makebutton($lang_char['send_mail'], 'mail.php?type=ingame_mail&amp;to='.$char['name'].'', 130);
716 $output .= '
717 </td>
718 <td>';
719 }
720 makebutton($lang_global['back'], 'javascript:window.history.back()" type="def', 130);
721 $output .= '
722 </td>
723 </tr>
724 </table>
725 <br />
726 </center>
727 <!-- end of char.php -->';
728 }
729 else
730 error($lang_char['no_permission']);
731 }
732 else
733 error($lang_char['no_char_found']);
734
735}
736
737
738//########################################################################################################################
739// MAIN
740//########################################################################################################################
741
742//$action = (isset($_GET['action'])) ? $_GET['action'] : NULL;
743
744$lang_char = lang_char();
745
746char_main($sqlr, $sqlc);
747
748//unset($action);
749unset($action_permission);
750unset($lang_char);
751
752require_once 'footer.php';
753
754
755?>
Note: See TracBrowser for help on using the repository browser.