• 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!

support in website

feeniiix

New Member
Joined
Oct 31, 2013
Messages
114
Reaction score
4
need help on my website it dosent work on support list it says in website :
Support in-game
Unknown column 'type' in 'field list'


PHP:
<?php require_once 'engine/init.php'; include 'layout/overall/header.php';
?><h1>Support in-game</h1><?php
$cache = new Cache('engine/cache/support');
if ($cache->hasExpired()) {
    // Fetch all staffs in-game.
    $staffs = support_list();
    // Fetch group ids and names from config.php
    $groups = $config['ingame_positions'];
    // Loops through groups, separating each group element into an ID variable and name variable
    foreach ($groups as $group_id => $group_name) {
        // Loops through list of staffs
        foreach ($staffs as $staff) {
            if ($staff['group_id'] == $group_id) $srtGrp[$group_name][] = $staff;
        }
    }
    if (!empty($srtGrp)) {
        $cache->setContent($srtGrp);
        $cache->save();
    }
} else {
    $srtGrp = $cache->load();
}
$writeHeader = true;
if (!empty($srtGrp)) {
    foreach (array_reverse($srtGrp) as $grpName => $grpList) {
        ?>
        <table>
            <?php if ($writeHeader) {
            $writeHeader = false; ?>
            <tr class="yellow">
                <td width="30%">Group</td>
                <td width="40%">Name</td>
                <td width="30%">Status</td>
            </tr>
            <?php
            }
            foreach ($grpList as $char) {
                if ($char['name'] != $config['website_char']) {
                    echo '<tr>';
                    echo "<td width='30%'>". $grpName ."</td>";
                    echo '<td width="40%"><a href="characterprofile.php?name='. $char['name'] .'">'. $char['name'] .'</a></td>';
                    echo "<td width='30%'>". online_id_to_name($char['online']) ."</td>";
                    echo '</tr>';
                }
            }
            ?>
        </table>
        <?php
    }
}
echo'</table>'; include 'layout/overall/footer.php'; ?>
 
It seems that your "type" column is missing. Go into your database-manager (probably PHPMyAdmin) and find the table according to your error (i'm guessing it is account). Click on "Structure" and add one more column called "type".
 
Back
Top