source: mangos/inc/site.classes.php@ 5

<?php
// ====== HONOR ====== \\
class honor_system
{
        var $realm_db;
        var $mangos_db;
        
        function get_all_honor()
        {
                $q = $this->mangos_db->query("SELECT * FROM `character_kill` ORDER BY `guid`");
                while($res_row = $this->mangos_db->fetch_assoc($q))
                {
                        if($res_row['type']==1){
                                $honor_arr[$res_row['guid']] += $res_row['honor'];
                        }elseif($res_row['type']==2){
                                $honor_arr[$res_row['guid']] -= $res_row['honor'];
                        }
                }
                return $honor_arr;
        }
        
        function get_character_honor($char_id)
        {
                $q = $this->mangos_db->query("SELECT * FROM `character_kill` WHERE `guid`='$char_id'");
                while($res_row = $this->mangos_db->fetch_assoc($q))
                {
                        if($res_row['type']==1){
                                $honor += $res_row['honor'];
                        }elseif($res_row['type']==2){
                                $honor -= $res_row['honor'];
                        }
                }
                return $honor;
        }
        
        function calc_character_rank($honor_points)
        {
                $rank = 0;
                if($honor_points <= 0){
                        $rank = 0; 
                }
                else{
                        if($honor_points < 2000 and $honor_points > 500) $rank = 2;
                        else if($honor_points <= 500 and $honor_points > 0) $rank = 1;
                        else if ($honor_points >= 2000) $rank = round(($honor_points / 5000) + 1,0);
                }
                return $rank;
        }
}

class character_info
{
        var $realm_db;
        var $mangos_db;
        
        function get_character_stat($char_id)
        {
                $res_row = $this->mangos_db->fetch_assoc($this->mangos_db->query("SELECT * FROM `character` WHERE `guid`='$char_id' LIMIT 1"));
                $char_data = explode(' ',$res_row[data]);
                $character = array(
                'name'=>$res_row['name'],
                'race'=>$res_row['race'],
                'class'=>$res_row['class'],
                'position_x'=>$res_row['position_x'],
                'position_y'=>$res_row['position_y'],
                'position_z'=>$res_row['position_z'],
                'map'=>$res_row['map'],
                'orientation'=>$res_row['orientation'],
                'level'=>$char_data[34],
                'gender'=>$char_data[36],
                'lifetime_honorable_kills'=>$char_data[1255], // 1193
                'lifetime_dishonorable_kills'=>$char_data[1256] // 1194
                );
                return $character;
        }
        
        function get_character_guild($char_id)
        {
                $res_row = $this->mangos_db->fetch_assoc($this->mangos_db->query("SELECT * FROM `guild_member` WHERE `guid`='$char_id' LIMIT 1"));
                $guild_id = $res_row['guildid'];
                $res_row2 = $this->mangos_db->fetch_assoc($this->mangos_db->query("SELECT * FROM `guild` WHERE `guildid`='$guild_id' LIMIT 1"));
                return $res_row2['name'];
        }
}

?>