• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Solved Znote ACC - Account Status

Bash

Bash

Member
Joined
Nov 7, 2008
Messages
116
Reaction score
15
Hello! I was looking for a script which shows Free/Premium account on character profile, i found one but it dindt work, always says free account.

All the code in characterprofile.php

PHP: 
          <?php require_once 'engine/init.php'; include 'layout/overall/header.php';
if ($config['log_ip']) {
    znote_visitor_insert_detailed_data(4);
}
if (isset($_GET['name']) === true && empty($_GET['name']) === false) {
    $name = $_GET['name'];

    if (user_character_exist($name)) {
        $user_id = user_character_id($name);
        if ($config['TFSVersion'] == 'TFS_10') {
                $profile_data = user_character_data($user_id, 'name', 'level', 'vocation', 'lastlogin', 'town_id');
                $profile_data['online'] = user_is_online_10($user_id);
        } else $profile_data = user_character_data($user_id, 'name', 'level', 'vocation', 'lastlogin', 'town_id', 'online');
        $profile_znote_data = user_znote_character_data($user_id, 'created', 'hide_char', 'comment');

        $guild_exist = false;
        if (get_character_guild_rank($user_id) > 0) {
                $guild_exist = true;
                $guild = get_player_guild_data($user_id);
                $guild_name = get_guild_name($guild['guild_id']);
        }

        ?>



        <!-- PROFILE MARKUP HERE-->
        <h1>Character Profile:</h1>
        <table>


            <tr class="yellow"><th>Name:</th><th><?php echo $profile_data['name']; ?></th></tr>
            <tr><td>Level:</td><td><?php echo $profile_data['level']; ?></td></tr>
            <tr><td>Vocation:</td><td><?php echo vocation_id_to_name($profile_data['vocation']); ?></td></tr>
            <tr>
                <td>Guild:</td>
                <td><?php
                        if ($guild_exist) {
                        ?>
                        <?php echo $guild['rank_name']; ?> of <a href="guilds.php?name=<?php echo $guild_name; ?>"><?php echo $guild_name; ?></a>
                        <?php
                        }
                        else {
                        echo 'None';
                        }
                ?></td>
            </tr>
            <tr>
                <td>Residence</td>
                <td><?php echo $config['towns'][$profile_data['town_id']]; ?></td>
            </tr>
            <tr>
                <td>Last Login:</td>
                <td><?php
                    if ($profile_data['lastlogin'] != 0) { echo getClock($profile_data['lastlogin'], true, false); } else { echo 'Never.'; }
                ?></td>
            </tr>
            <tr>
                <td>Status:</td>
                <td><?php
                    if ($config['TFSVersion'] == 'TFS_10') {
                        if ($profile_data['online']) {
                            echo '<font class="profile_font" name="profile_font_online" color="green"><b>ONLINE</b></font>';
                        } else {
                            echo '<font class="profile_font" name="profile_font_online" color="red"><b>OFFLINE</b></font>';
                        }
                    } else {
                        if ($profile_data['online'] == 1) {
                            echo '<font class="profile_font" name="profile_font_online" color="green"><b>ONLINE</b></font>';
                        } else {
                            echo '<font class="profile_font" name="profile_font_online" color="red"><b>OFFLINE</b></font>';
                        }
                    }
                ?> </td>
            </tr>

            <tr>
                <td>Created:</td>
                <td><?php echo getClock($profile_znote_data['created'], true); ?></td>
            </tr>
        </table>

        <tr>
        <td>Account Status </td>
        <td><?$account = mysql_select_single("SELECT `premdays` FROM `accounts` WHERE `id` IN (SELECT `account_id` FROM `players` WHERE `name` = '$name')");

<li><font class="profile_font" name="profile_font_pacc"> <?php echo $account['premdays'] > 0 ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; ?></font></li> </td>
   </tr>
 
<?php
/*/
/   Znote AAC 1.4+ detailed character info (HP, MP, lvL, Exp, skills)
/   HTML code based on code from Gesior
/*/
$tableWidth = 540;
if ($config['TFSVersion'] != 'TFS_10') {
    $playerData = mysql_select_multi("SELECT `value` FROM `player_skills` WHERE `player_id`='$user_id' LIMIT 7;");
    $playerData['fist'] = $playerData[0]['value']; unset($playerData[0]);
    $playerData['club'] = $playerData[1]['value']; unset($playerData[1]);
    $playerData['sword'] = $playerData[2]['value']; unset($playerData[2]);
    $playerData['axe'] = $playerData[3]['value']; unset($playerData[3]);
    $playerData['dist'] = $playerData[4]['value']; unset($playerData[4]);
    $playerData['shield'] = $playerData[5]['value']; unset($playerData[5]);
    $playerData['fish'] = $playerData[6]['value']; unset($playerData[6]);

    $player = mysql_select_single("SELECT `health`, `healthmax`, `mana`, `manamax`, `experience`, `maglevel`, `level` FROM `players` WHERE `id`='$user_id' LIMIT 1;");
    $playerData['magic'] = $player['maglevel'];
    $playerData['exp'] = array(
        'now' => $player['experience'],
        'next' => (int)(level_to_experience($player['level']+1) - $player['experience']),
        'percent' => (int)(($player['experience'] - level_to_experience($player['level'])) / (level_to_experience($player['level']+1) - $player['experience']) * 100)
    );
    $playerData['health'] = array(
        'now' => $player['health'],
        'max' => $player['healthmax'],
        'percent' => (int)($player['health'] / $player['healthmax'] * 100),
    );
    $playerData['mana'] = array(
        'now' => $player['mana'],
        'max' => $player['manamax'],
        'percent' => (int)($player['mana'] / $player['manamax'] * 100),
    );
} else {
    $player = mysql_select_single("SELECT `health`, `healthmax`, `mana`, `manamax`, `experience`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`, `maglevel`, `level` FROM `players` WHERE `id`='$user_id' LIMIT 1;");
    $playerData = array(
        'fist' => $player['skill_fist'],
        'club' => $player['skill_club'],
        'sword' => $player['skill_sword'],
        'axe' => $player['skill_axe'],
        'dist' => $player['skill_dist'],
        'shield' => $player['skill_shielding'],
        'fish' => $player['skill_fishing'],
        'magic' => $player['maglevel'],
        'exp' => array(
            'now' => $player['experience'],
            'next' => (int)(level_to_experience($player['level']+1) - $player['experience']),
            'percent' => (int)(($player['experience'] - level_to_experience($player['level'])) / (level_to_experience($player['level']+1) - $player['experience']) * 100)
        ),
        'health' => array(
            'now' => $player['health'],
            'max' => $player['healthmax'],
            'percent' => (int)($player['health'] / $player['healthmax'] * 100),
        ),
        'mana' => array(
            'now' => $player['mana'],
            'max' => $player['manamax'],
            'percent' => (int)($player['mana'] / $player['manamax'] * 100),
        )
    );
}
// Incase they have more health/mana than they should due to equipment bonus etc
if ($playerData['exp']['percent'] > 100) $playerData['exp']['percent'] = 100;
if ($playerData['health']['percent'] > 100) $playerData['health']['percent'] = 100;
if ($playerData['mana']['percent'] > 100) $playerData['mana']['percent'] = 100;
//data_dump($playerData, false, "Player Data");
?>


<!-- END detailed character info -->
<table>
    <tr class="yellow">
        <th><center>Comment:</center></th>
    </tr>
    <tr>
        <td><center><textarea name="profile_comment_textarea" cols="70" rows="10" readonly="readonly" class="span12"><?php echo $profile_znote_data['comment']; ?></textarea></center></td>
    </tr>
</table>

                <!-- Achievements start -->
                <?php if ($config['Ach'])
                { ?>
     <h1>Tasks:</h1><br>
                    <div id="accordion">
                        <div>
                            <table class="table table-striped table-bordered">
                                <tbody>
                                    <style>
                                        #secondD {
                                            margin-left:0px;
                                        }
                                    </style>
                                    <?php
                                    foreach ($config['achievements'] as $key => $achiv)
                                    {
                                        $uery = mysql_select_single("SELECT `player_id`, `value`, `key` FROM `player_storage` WHERE `player_id`='$user_id' AND `key`='$key' LIMIT 1;");
                                        if (!empty($uery) || $uery !== false)
                                        {
                                            foreach ($uery as $luery)
                                            {
                                                if ($luery == $key)
                                                {
                                                    if (!array_key_exists($key, $achiv))
                                                    {
                                                        echo '<tr><td width="17%">' .$achiv[0]. '</td><td>' .$achiv[1]. '</td>';

                                                        if (!isset($achiv['secret']))
                                                        {
                                                            echo '<td><img id="secondD" src="http://img04.imgland.net/PuMz0mVqSG.gif"></td>';
                                                        }

                                                        echo '<td>'. $achiv['points'] .'</td>';
                                                        echo '<tr>';
                                                    }
                                                }
                                            }
                                        }
                                    }
                                    ?>
                                </tbody>
                            </table>
                        </div>
                    </div><br>
                <?php
                }
                ?>
                <!-- Achievements end -->
<!-- DEATH LIST -->
<h1>Death List:</h1><br>
<table id="characterprofileTable" class="table table-striped table-hover">
    <tr class="yellow">
        <th>Date:</th>
        <th>Level:</th>
        <th>Killed by:</th>
    </tr>
    <?php
    if ($config['TFSVersion'] == 'TFS_02' || $config['TFSVersion'] == 'TFS_10') {
        $array = user_fetch_deathlist($user_id);
        if ($array) {

                // Design and present the list
                foreach ($array as $value) {
                    echo '<tr>';
                    // $value[0]
                    $value['time'] = getClock($value['time'], true);
                    if ($value['is_player'] == 1) {
                        $value['killed_by'] = 'player: <a href="characterprofile.php?name='. $value['killed_by'] .'">'. $value['killed_by'] .'</a>';
                    } else {
                        $value['killed_by'] = 'monster: '. $value['killed_by'] .'.';
                    }

                    echo '<td>'. $value['time'] .'</td>
                   <td> Killed at level '. $value['level'] .'</td>
                   <td>'. $value['killed_by'];'</td>
                   </tr>';
                }

            } else {
                echo '<b><font color="green">This player has never died.</font></b>';
            }
            //Done.
        } else if ($config['TFSVersion'] == 'TFS_03') {
            $array = user_fetch_deathlist03($user_id);
            if ($array) {

                // Design and present the list
                foreach ($array as $value) {
                    echo '<tr>';
                    $value[3] = user_get_killer_id(user_get_kid($value['id']));
                    if ($value[3] !== false && $value[3] >= 1) {
                        $namedata = user_character_data((int)$value[3], 'name');
                        if ($namedata !== false) {
                            $value[3] = $namedata['name'];
                            $value[3] = '<a href="characterprofile.php?name='. $value[3] .'">'. $value[3] .'</a>';
                        } else {
                            $value[3] = 'deleted player.';
                        }
                    } else {
                        $value[3] = user_get_killer_m_name(user_get_kid($value['id']));
                        if ($value[3] === false) $value[3] = 'deleted player.';
                    }
                    echo '<td>'. getClock($value['date'], true) .'</td> <td>Killed at level '. $value['level'] .'.</td> <td>'. $value[3];
                    '</td></tr>';
                }

            } else {
                echo '<b><font color="green">This player has never died.</font></b>';
            }
        }
        ?>
</table>
<!-- END DEATH LIST -->
<!-- CHARACTER LIST -->
<?php
if (user_character_hide($profile_data['name']) != 1 && user_character_list_count(user_character_account_id($name)) > 1) {
?>
    <h1>Other visible characters on this account:</h1><br>
    <?php
    $characters = user_character_list(user_character_account_id($profile_data['name']));
    // characters: [0] = name, [1] = level, [2] = vocation, [3] = town_id, [4] = lastlogin, [5] = online
    if ($characters && count($characters) > 1) {
        ?>
        <table id="characterprofileTable" class="table table-striped table-hover">
            <tr class="yellow">
                <th>Name:</th>
                <th>Level:</th>
                <th>Vocation:</th>
                <th>Last login:</th>
                <th>Status:</th>
            </tr>
            <?php
            // Design and present the list
            foreach ($characters as $char) {
                if ($char['name'] != $profile_data['name']) {
                    if (hide_char_to_name(user_character_hide($char['name'])) != 'hidden') {
                        echo '<tr>';
                        echo '<td><a href="characterprofile.php?name='. $char['name'] .'">'. $char['name'] .'</a></td>';
                        echo '<td>'. $char['level'] .'</td>';
                        echo '<td>'. $char['vocation'] .'</td>';
                        echo '<td>'. $char['lastlogin'] .'</td>';
                        echo '<td>'. $char['online'] .'</td>';
                        echo '</tr>';
                    }
                }
            }
            ?>
        </table>
        <?php
    } else {
        echo '<b><font color="green">This player has never died.</font></b>';
    }
    //Done.
}
?>
<!-- END CHARACTER LIST -->
<font class="profile_font" name="profile_font_share_url">Address: <a href="<?php
        if ($config['htwrite']) echo "http://".$_SERVER['HTTP_HOST']."/". $profile_data['name'];
        else echo "http://".$_SERVER['HTTP_HOST']."/characterprofile.php?name=". $profile_data['name'];
?>"><?php
        if ($config['htwrite']) echo "http://".$_SERVER['HTTP_HOST']."/". $profile_data['name'];
        else echo "http://".$_SERVER['HTTP_HOST']."/characterprofile.php?name=". $profile_data['name'];
?></a></font>
<!-- END PROFILE MARKUP HERE-->
<?php
} else {
    echo htmlentities(strip_tags($name, ENT_QUOTES)).' does not exist.';
}
} else {
    header('Location: index.php');
}
include 'layout/overall/footer.php'; ?>

code that i need to insert there without errors
PHP: 
<tr>
        <td>Account Status </td>
        <td><?$account = mysql_select_single("SELECT `premdays` FROM `accounts` WHERE `id` IN (SELECT `account_id` FROM `players` WHERE `name` = '$name')");

<li><font class="profile_font" name="profile_font_pacc"> <?php echo $account['premdays'] > 0 ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; ?></font></li> </td>
   </tr>


THANKS in advance!
 
Last edited by a moderator:
Solution
Znote
Adjusted the SQL query a bit, but the main issue was that you was in the PHP environment and didnt break out to HTML before you added the <li>. (You also didnt start the PHP environment properly, use "<?php", not "<?").
PHP: 
<tr>
    <td>Created:</td>
    <td><?php echo getClock($profile_znote_data['created'], true); ?></td>
</tr>
<tr>
    <td>Account Status</td>
    <td><?php
        $account = mysql_select_single("SELECT `accounts`.`premdays` FROM `players` INNER JOIN `accounts` ON `players`.`account_id` = `accounts`.`id` WHERE `players`.`id` = '$user_id' LIMIT 1;");
        ?>
        <li>
            <font class="profile_font" name="profile_font_pacc"> <?php echo ($account['premdays'] > 0) ? '<b><font color="green">Premium...
Sort by date Sort by votes
In your database, does your accounts table have a column named "premdays"?
 
Upvote 0 Downvote
Adjusted the SQL query a bit, but the main issue was that you was in the PHP environment and didnt break out to HTML before you added the <li>. (You also didnt start the PHP environment properly, use "<?php", not "<?").
PHP: 
<tr>
    <td>Created:</td>
    <td><?php echo getClock($profile_znote_data['created'], true); ?></td>
</tr>
<tr>
    <td>Account Status</td>
    <td><?php
        $account = mysql_select_single("SELECT `accounts`.`premdays` FROM `players` INNER JOIN `accounts` ON `players`.`account_id` = `accounts`.`id` WHERE `players`.`id` = '$user_id' LIMIT 1;");
        ?>
        <li>
            <font class="profile_font" name="profile_font_pacc"> <?php echo ($account['premdays'] > 0) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; ?></font>
        </li>
    </td>
</tr>

Here is the patch:
PHP: 
<?php require_once 'engine/init.php'; include 'layout/overall/header.php';
if ($config['log_ip']) {
    znote_visitor_insert_detailed_data(4);
}
if (isset($_GET['name']) === true && empty($_GET['name']) === false) {
    $name = $_GET['name'];

    if (user_character_exist($name)) {
        $user_id = user_character_id($name);
        if ($config['TFSVersion'] == 'TFS_10') {
                $profile_data = user_character_data($user_id, 'name', 'level', 'vocation', 'lastlogin', 'town_id');
                $profile_data['online'] = user_is_online_10($user_id);
        } else $profile_data = user_character_data($user_id, 'name', 'level', 'vocation', 'lastlogin', 'town_id', 'online');
        $profile_znote_data = user_znote_character_data($user_id, 'created', 'hide_char', 'comment');

        $guild_exist = false;
        if (get_character_guild_rank($user_id) > 0) {
                $guild_exist = true;
                $guild = get_player_guild_data($user_id);
                $guild_name = get_guild_name($guild['guild_id']);
        }

        ?>

        <!-- PROFILE MARKUP HERE-->
        <h1>Character Profile:</h1>
        <table>
            <tr class="yellow"><th>Name:</th><th><?php echo $profile_data['name']; ?></th></tr>
            <tr><td>Level:</td><td><?php echo $profile_data['level']; ?></td></tr>
            <tr><td>Vocation:</td><td><?php echo vocation_id_to_name($profile_data['vocation']); ?></td></tr>
            <tr>
                <td>Guild:</td>
                <td><?php
                        if ($guild_exist) {
                        ?>
                        <?php echo $guild['rank_name']; ?> of <a href="guilds.php?name=<?php echo $guild_name; ?>"><?php echo $guild_name; ?></a>
                        <?php
                        }
                        else {
                        echo 'None';
                        }
                ?></td>
            </tr>
            <tr>
                <td>Residence</td>
                <td><?php echo $config['towns'][$profile_data['town_id']]; ?></td>
            </tr>
            <tr>
                <td>Last Login:</td>
                <td><?php
                    if ($profile_data['lastlogin'] != 0) { echo getClock($profile_data['lastlogin'], true, false); } else { echo 'Never.'; }
                ?></td>
            </tr>
            <tr>
                <td>Status:</td>
                <td><?php
                    if ($config['TFSVersion'] == 'TFS_10') {
                        if ($profile_data['online']) {
                            echo '<font class="profile_font" name="profile_font_online" color="green"><b>ONLINE</b></font>';
                        } else {
                            echo '<font class="profile_font" name="profile_font_online" color="red"><b>OFFLINE</b></font>';
                        }
                    } else {
                        if ($profile_data['online'] == 1) {
                            echo '<font class="profile_font" name="profile_font_online" color="green"><b>ONLINE</b></font>';
                        } else {
                            echo '<font class="profile_font" name="profile_font_online" color="red"><b>OFFLINE</b></font>';
                        }
                    }
                ?> </td>
            </tr>
            <tr>
                <td>Created:</td>
                <td><?php echo getClock($profile_znote_data['created'], true); ?></td>
            </tr>
             <tr>
                 <td>Account Status</td>
                 <td><?php
                    $account = mysql_select_single("SELECT `accounts`.`premdays` FROM `players` INNER JOIN `accounts` ON `players`.`account_id` = `accounts`.`id` WHERE `players`.`id` = '$user_id' LIMIT 1;");
                    ?>
                    <li>
                        <font class="profile_font" name="profile_font_pacc"> <?php echo ($account['premdays'] > 0) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; ?></font>
                    </li>
                 </td>
            </tr>
        </table>

<?php
/*/
/   Znote AAC 1.4+ detailed character info (HP, MP, lvL, Exp, skills)
/   HTML code based on code from Gesior
/*/
$tableWidth = 540;
if ($config['TFSVersion'] != 'TFS_10') {
    $playerData = mysql_select_multi("SELECT `value` FROM `player_skills` WHERE `player_id`='$user_id' LIMIT 7;");
    $playerData['fist'] = $playerData[0]['value']; unset($playerData[0]);
    $playerData['club'] = $playerData[1]['value']; unset($playerData[1]);
    $playerData['sword'] = $playerData[2]['value']; unset($playerData[2]);
    $playerData['axe'] = $playerData[3]['value']; unset($playerData[3]);
    $playerData['dist'] = $playerData[4]['value']; unset($playerData[4]);
    $playerData['shield'] = $playerData[5]['value']; unset($playerData[5]);
    $playerData['fish'] = $playerData[6]['value']; unset($playerData[6]);

    $player = mysql_select_single("SELECT `health`, `healthmax`, `mana`, `manamax`, `experience`, `maglevel`, `level` FROM `players` WHERE `id`='$user_id' LIMIT 1;");
    $playerData['magic'] = $player['maglevel'];
    $playerData['exp'] = array(
        'now' => $player['experience'],
        'next' => (int)(level_to_experience($player['level']+1) - $player['experience']),
        'percent' => (int)(($player['experience'] - level_to_experience($player['level'])) / (level_to_experience($player['level']+1) - $player['experience']) * 100)
    );
    $playerData['health'] = array(
        'now' => $player['health'],
        'max' => $player['healthmax'],
        'percent' => (int)($player['health'] / $player['healthmax'] * 100),
    );
    $playerData['mana'] = array(
        'now' => $player['mana'],
        'max' => $player['manamax'],
        'percent' => (int)($player['mana'] / $player['manamax'] * 100),
    );
} else {
    $player = mysql_select_single("SELECT `health`, `healthmax`, `mana`, `manamax`, `experience`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`, `maglevel`, `level` FROM `players` WHERE `id`='$user_id' LIMIT 1;");
    $playerData = array(
        'fist' => $player['skill_fist'],
        'club' => $player['skill_club'],
        'sword' => $player['skill_sword'],
        'axe' => $player['skill_axe'],
        'dist' => $player['skill_dist'],
        'shield' => $player['skill_shielding'],
        'fish' => $player['skill_fishing'],
        'magic' => $player['maglevel'],
        'exp' => array(
            'now' => $player['experience'],
            'next' => (int)(level_to_experience($player['level']+1) - $player['experience']),
            'percent' => (int)(($player['experience'] - level_to_experience($player['level'])) / (level_to_experience($player['level']+1) - $player['experience']) * 100)
        ),
        'health' => array(
            'now' => $player['health'],
            'max' => $player['healthmax'],
            'percent' => (int)($player['health'] / $player['healthmax'] * 100),
        ),
        'mana' => array(
            'now' => $player['mana'],
            'max' => $player['manamax'],
            'percent' => (int)($player['mana'] / $player['manamax'] * 100),
        )
    );
}
// Incase they have more health/mana than they should due to equipment bonus etc
if ($playerData['exp']['percent'] > 100) $playerData['exp']['percent'] = 100;
if ($playerData['health']['percent'] > 100) $playerData['health']['percent'] = 100;
if ($playerData['mana']['percent'] > 100) $playerData['mana']['percent'] = 100;
//data_dump($playerData, false, "Player Data");
?>


<!-- END detailed character info -->
<table>
    <tr class="yellow">
        <th><center>Comment:</center></th>
    </tr>
    <tr>
        <td><center><textarea name="profile_comment_textarea" cols="70" rows="10" readonly="readonly" class="span12"><?php echo $profile_znote_data['comment']; ?></textarea></center></td>
    </tr>
</table>

                <!-- Achievements start -->
                <?php if ($config['Ach'])
                { ?>
     <h1>Tasks:</h1><br>
                    <div id="accordion">
                        <div>
                            <table class="table table-striped table-bordered">
                                <tbody>
                                    <style>
                                        #secondD {
                                            margin-left:0px;
                                        }
                                    </style>
                                    <?php
                                    foreach ($config['achievements'] as $key => $achiv)
                                    {
                                        $uery = mysql_select_single("SELECT `player_id`, `value`, `key` FROM `player_storage` WHERE `player_id`='$user_id' AND `key`='$key' LIMIT 1;");
                                        if (!empty($uery) || $uery !== false)
                                        {
                                            foreach ($uery as $luery)
                                            {
                                                if ($luery == $key)
                                                {
                                                    if (!array_key_exists($key, $achiv))
                                                    {
                                                        echo '<tr><td width="17%">' .$achiv[0]. '</td><td>' .$achiv[1]. '</td>';

                                                        if (!isset($achiv['secret']))
                                                        {
                                                            echo '<td><img id="secondD" src="http://img04.imgland.net/PuMz0mVqSG.gif"></td>';
                                                        }

                                                        echo '<td>'. $achiv['points'] .'</td>';
                                                        echo '<tr>';
                                                    }
                                                }
                                            }
                                        }
                                    }
                                    ?>
                                </tbody>
                            </table>
                        </div>
                    </div><br>
                <?php
                }
                ?>
                <!-- Achievements end -->
<!-- DEATH LIST -->
<h1>Death List:</h1><br>
<table id="characterprofileTable" class="table table-striped table-hover">
    <tr class="yellow">
        <th>Date:</th>
        <th>Level:</th>
        <th>Killed by:</th>
    </tr>
    <?php
    if ($config['TFSVersion'] == 'TFS_02' || $config['TFSVersion'] == 'TFS_10') {
        $array = user_fetch_deathlist($user_id);
        if ($array) {

                // Design and present the list
                foreach ($array as $value) {
                    echo '<tr>';
                    // $value[0]
                    $value['time'] = getClock($value['time'], true);
                    if ($value['is_player'] == 1) {
                        $value['killed_by'] = 'player: <a href="characterprofile.php?name='. $value['killed_by'] .'">'. $value['killed_by'] .'</a>';
                    } else {
                        $value['killed_by'] = 'monster: '. $value['killed_by'] .'.';
                    }

                    echo '<td>'. $value['time'] .'</td>
                  <td> Killed at level '. $value['level'] .'</td>
                  <td>'. $value['killed_by'];'</td>
                  </tr>';
                }

            } else {
                echo '<b><font color="green">This player has never died.</font></b>';
            }
            //Done.
        } else if ($config['TFSVersion'] == 'TFS_03') {
            $array = user_fetch_deathlist03($user_id);
            if ($array) {

                // Design and present the list
                foreach ($array as $value) {
                    echo '<tr>';
                    $value[3] = user_get_killer_id(user_get_kid($value['id']));
                    if ($value[3] !== false && $value[3] >= 1) {
                        $namedata = user_character_data((int)$value[3], 'name');
                        if ($namedata !== false) {
                            $value[3] = $namedata['name'];
                            $value[3] = '<a href="characterprofile.php?name='. $value[3] .'">'. $value[3] .'</a>';
                        } else {
                            $value[3] = 'deleted player.';
                        }
                    } else {
                        $value[3] = user_get_killer_m_name(user_get_kid($value['id']));
                        if ($value[3] === false) $value[3] = 'deleted player.';
                    }
                    echo '<td>'. getClock($value['date'], true) .'</td> <td>Killed at level '. $value['level'] .'.</td> <td>'. $value[3];
                    '</td></tr>';
                }

            } else {
                echo '<b><font color="green">This player has never died.</font></b>';
            }
        }
        ?>
</table>
<!-- END DEATH LIST -->
<!-- CHARACTER LIST -->
<?php
if (user_character_hide($profile_data['name']) != 1 && user_character_list_count(user_character_account_id($name)) > 1) {
?>
    <h1>Other visible characters on this account:</h1><br>
    <?php
    $characters = user_character_list(user_character_account_id($profile_data['name']));
    // characters: [0] = name, [1] = level, [2] = vocation, [3] = town_id, [4] = lastlogin, [5] = online
    if ($characters && count($characters) > 1) {
        ?>
        <table id="characterprofileTable" class="table table-striped table-hover">
            <tr class="yellow">
                <th>Name:</th>
                <th>Level:</th>
                <th>Vocation:</th>
                <th>Last login:</th>
                <th>Status:</th>
            </tr>
            <?php
            // Design and present the list
            foreach ($characters as $char) {
                if ($char['name'] != $profile_data['name']) {
                    if (hide_char_to_name(user_character_hide($char['name'])) != 'hidden') {
                        echo '<tr>';
                        echo '<td><a href="characterprofile.php?name='. $char['name'] .'">'. $char['name'] .'</a></td>';
                        echo '<td>'. $char['level'] .'</td>';
                        echo '<td>'. $char['vocation'] .'</td>';
                        echo '<td>'. $char['lastlogin'] .'</td>';
                        echo '<td>'. $char['online'] .'</td>';
                        echo '</tr>';
                    }
                }
            }
            ?>
        </table>
        <?php
    } else {
        echo '<b><font color="green">This player has never died.</font></b>';
    }
    //Done.
}
?>
<!-- END CHARACTER LIST -->
<font class="profile_font" name="profile_font_share_url">Address: <a href="<?php
        if ($config['htwrite']) echo "http://".$_SERVER['HTTP_HOST']."/". $profile_data['name'];
        else echo "http://".$_SERVER['HTTP_HOST']."/characterprofile.php?name=". $profile_data['name'];
?>"><?php
        if ($config['htwrite']) echo "http://".$_SERVER['HTTP_HOST']."/". $profile_data['name'];
        else echo "http://".$_SERVER['HTTP_HOST']."/characterprofile.php?name=". $profile_data['name'];
?></a></font>
<!-- END PROFILE MARKUP HERE-->
<?php
} else {
    echo htmlentities(strip_tags($name, ENT_QUOTES)).' does not exist.';
}
} else {
    header('Location: index.php');
}
include 'layout/overall/footer.php'; ?>
 
Upvote 0 Downvote
Solution

Similar threads

ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
168
ralke
ralke
ghunalma
  • Question
AAC [Znote AAC] admin_news dont upload images
Replies
3
Views
316
ghunalma
ghunalma
Czorcik
  • Question
Highscore reborn system in acc maker
Replies
0
Views
260
Czorcik
Czorcik
blokerzinha
  • Question
Problem with the wrong player appearing as top even though he is not. Znote
Replies
1
Views
329
blokerzinha
blokerzinha
O
  • Question
Solved Problem after ssl Myaac
Replies
2
Views
236
slaw
slaw
Shoorkill
  • Question
AAC gesior creates an account, but when selecting a character in the game he receives an account error or wrong password.
Replies
2
Views
270
Shoorkill
Shoorkill
Czorcik
  • Question
Problem with Gesior Acc HIGHSCORE (offline player)
Replies
2
Views
465
Czorcik
Czorcik
3221920
  • Question
AAC [HELP] MyAAC Headline not work
Replies
4
Views
488
3221920
3221920
Back
Top