forked from Amit86/minimanager
/
honor.php
109 lines (101 loc) · 7.69 KB
/
honor.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php
require_once("header.php");
require_once("libs/char_lib.php");
valid_login($action_permission['read']);
//global $lang_honor, $lang_global, $output, $characters_db, $realm_id, $itemperpage, $realm_db;
$sql = new SQL;
$sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
$start = (isset($_GET['start'])) ? $sql->quote_smart($_GET['start']) : 0;
$order_by = (isset($_GET['order_by'])) ? $sql->quote_smart($_GET['order_by']) :"honor";
$query = $sql->query("SELECT C.guid, C.name, C.race, C.class, C.totalHonorPoints AS honor , C.totalKills AS kills, C.level, C.arenaPoints AS arena, COALESCE(guild_member.guildid,0) as GNAME, C.gender FROM characters C LEFT JOIN guild_member ON C.guid = guild_member.guid WHERE race in (1,3,4,7,11) ORDER BY $order_by DESC LIMIT 25;");
$this_page = $sql->num_rows($query);
$output .= "
<script type=\"text/javascript\">
answerbox.btn_ok='{$lang_global['yes_low']}';
answerbox.btn_cancel='{$lang_global['no']}';
</script>
<center>
<fieldset style=\"width: 776px;\">
<legend><img src='img/alliance.gif' /></legend>
<table class=\"lined\" style=\"width: 705px;\">
<tr class=\"bold\">
<td colspan=\"11\">{$lang_honor['allied']} {$lang_honor ['browse_honor']}</td>
</tr>
<tr>
<th width=\"30%\">{$lang_honor['guid']}</th>
<th width=\"7%\">{$lang_honor['race']}</th>
<th width=\"7%\">{$lang_honor['class']}</th>
<th width=\"7%\">{$lang_honor['level']}</th>
<th width=\"5%\"><a href=\"honor.php?order_by=honor\"".($order_by=='honor' ? " class=DESC" : "").">{$lang_honor['honor']}</a></th>
<th width=\"5%\"><a href=\"honor.php?order_by=honor\"".($order_by=='honor' ? " class=DESC" : "").">{$lang_honor['honor points']}</a></th>
<th width=\"5%\"><a href=\"honor.php?order_by=kills\"".($order_by=='kills' ? " class=DESC" : "").">Kills</a></th>
<th width=\"5%\"><a href=\"honor.php?order_by=arena\"".($order_by=='arena' ? " class=DESC" : "").">AP</a></th>
<th width=\"30%\">{$lang_honor['guild']}</th>
</tr>";
while ($char = $sql->fetch_row($query))
{
$guild_name = $sql->fetch_row($sql->query("SELECT `name` FROM `guild` WHERE `guildid`=".$char[8].";"));
$output .= "
<tr>
<td><a href=\"char.php?id=$char[0]\">".htmlentities($char[1])."</a></td>
<td><img src='img/c_icons/{$char[2]}-{$char[9]}.gif' onmousemove='toolTip(\"".char_get_race_name($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()'></td>
<td><img src='img/c_icons/{$char[3]}.gif' onmousemove='toolTip(\"".char_get_class_name($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()'></td>
<td>".char_get_level_color($char[6])."</td>
<td><span onmouseover='toolTip(\"".char_get_pvp_rank_name($char[4], char_get_side_id($char[2]))."\",\"item_tooltip\")' onmouseout='toolTip()' style='color: white;'><img src='img/ranks/rank".char_get_pvp_rank_id($char[4], char_get_side_id($char[2])).".gif'></span></td>
<td>$char[4]</td>
<td>$char[5]</td>
<td>$char[7]</td>
<td><a href=\"guild.php?action=view_guild&error=3&id=$char[8]\">".htmlentities($guild_name[0])."</a></td>
</tr>";
}
$output .= "
</table>
<br />
</fieldset>";
$query = $sql->query("SELECT C.guid, C.name, C.race, C.class, C.todayHonorPoints AS honor , C.totalKills AS kills, C.level, C.arenaPoints AS arena, COALESCE(guild_member.guildid,0) as GNAME, C.gender FROM characters C LEFT JOIN guild_member ON C.guid = guild_member.guid WHERE race not in (1,3,4,7,11) ORDER BY $order_by DESC LIMIT 25;");
$this_page = $sql->num_rows($query);
$output .= "
<script type=\"text/javascript\">
answerbox.btn_ok='{$lang_global['yes_low']}';
answerbox.btn_cancel='{$lang_global['no']}';
</script>
<center>
<fieldset style=\"width: 776px;\">
<legend><img src='img/horde.gif' /></legend>
<table class=\"lined\" style=\"width: 705px;\">
<tr class=\"bold\">
<td colspan=\"11\">{$lang_honor['horde']} {$lang_honor ['browse_honor']}</td>
</tr>
<tr>
<th width=\"30%\">{$lang_honor['guid']}</th>
<th width=\"7%\">{$lang_honor['race']}</th>
<th width=\"7%\">{$lang_honor['class']}</th>
<th width=\"7%\">{$lang_honor['level']}</th>
<th width=\"5%\"><a href=\"honor.php?order_by=honor\"".($order_by=='honor' ? " class=DESC" : "").">{$lang_honor['honor']}</a></th>
<th width=\"5%\"><a href=\"honor.php?order_by=honor\"".($order_by=='honor' ? " class=DESC" : "").">{$lang_honor['honor points']}</a></th>
<th width=\"5%\"><a href=\"honor.php?order_by=kills\"".($order_by=='kills' ? " class=DESC" : "").">Kills</a></th>
<th width=\"5%\"><a href=\"honor.php?order_by=arena\"".($order_by=='arena' ? " class=DESC" : "").">AP</a></th>
<th width=\"30%\">{$lang_honor['guild']}</th>
</tr>";
while ($char = $sql->fetch_row($query))
{
$guild_name = $sql->fetch_row($sql->query("SELECT `name` FROM `guild` WHERE `guildid`=".$char[8].";"));
$output .= "
<tr>
<td><a href=\"char.php?id=$char[0]\">".htmlentities($char[1])."</a></td>
<td><img src='img/c_icons/{$char[2]}-{$char[9]}.gif' onmousemove='toolTip(\"".char_get_race_name($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()'></td>
<td><img src='img/c_icons/{$char[3]}.gif' onmousemove='toolTip(\"".char_get_class_name($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()'></td>
<td>".char_get_level_color($char[6])."</td>
<td><span onmouseover='toolTip(\"".char_get_pvp_rank_name($char[4], char_get_side_id($char[2]))."\",\"item_tooltip\")' onmouseout='toolTip()' style='color: white;'><img src='img/ranks/rank".char_get_pvp_rank_id($char[4], char_get_side_id($char[2])).".gif'></span></td>
<td>$char[4]</td>
<td>$char[5]</td>
<td>$char[7]</td>
<td><a href=\"guild.php?action=view_guild&error=3&id=$char[8]\">".htmlentities($guild_name[0])."</a></td>
</tr>";
}
$output .= "
</table>
<br />
</fieldset>";
require_once("footer.php");
?>