<!-- CONTENT START -->
    <div class="grid_16" id="content">
   <!-- CONTENT TITLE -->
    <div class="grid_9">
    <h1 class="content_edit">Database <?php 
if (isset($_GET['realm']) && isset($_GET['name']) && isset(Armory::$realmData[$_GET['realm']])) {
    echo '`' . $_GET['name'] . '` (' . Armory::$realmData[$_GET['realm']]['name'] . ')';
}
?>
</h1>
    <a href="?action=database">Go Back</a>
    </div>
<!--    TEXT CONTENT OR ANY OTHER CONTENT START     -->
    <div class="grid_15" id="textcontent">
    <?php 
$list = Template::GetPageData('tables_list');
if (is_array($list)) {
    foreach ($list as $table) {
        echo sprintf('<a href="?action=database&subaction=open&type=%s&name=%s&realm=%d&table=%s">%s</a><br />', $_GET['type'], $_GET['name'], $_GET['realm'], $table, $table);
    }
}
?>
    <div class="clear"></div><br />
    </div>
    <div class="clear"> </div>
<!-- END CONTENT-->
Example #2
0
        for ($i = 0; $i < $count; ++$i) {
            echo sprintf('<li><a href="?action=news&subaction=edit&itemid=%d">%s</a> (%s)</li>', $armory_news[$i]['id'], $armory_news[$i]['title'], $armory_news[$i]['date']);
        }
        echo '</ul>';
    }
}
?>
    <p></p>
    <?php 
switch (Template::GetPageData('news_result')) {
    case 'error_array':
    case 'error_insert':
        echo 'Unable to update/create news item!';
        break;
}
if (is_array($news_item) && Template::GetPageData('news_result') != 'ok') {
    echo sprintf('<form id="edit" name="edit" action="" method="post">
                <label><span style="color:red;"><strong>*</strong></span> ID:</label>
                <input type="text" class="smallInput wide" value="%d" disabled="true" name="id" />
                <input type="hidden" value="%d" name="newsid" />
                <label><span style="color:red;"><strong>*</strong></span> Date (in day.moth.year hour:minute:second format):</label>
                <input type="text" class="smallInput wide" value="%s" name="date" />
            	<label>Title (deDE):</label>
                <input type="text" class="smallInput wide" value="%s" name="title_de_de" />
            	<label><span style="color:red;"><strong>*</strong></span> Title (enGB):</label>
                <input type="text" class="smallInput wide" value="%s" name="title_en_gb" />
            	<label>Title (esES):</label>
                <input type="text" class="smallInput wide" value="%s" name="title_es_es" />
            	<label>Title (frFR):</label>
                <input type="text" class="smallInput wide" value="%s" name="title_fr_fr" />
            	<label>Title (ruRU):</label>
Example #3
0
                Template::LoadTemplate('content_configuration_addrealm');
                break;
        }
        break;
    case 'accounts':
        switch (Template::GetPageData('subaction')) {
            default:
                Template::LoadTemplate('content_accounts_list');
                break;
            case 'edit':
                Template::LoadTemplate('content_account_edit');
                break;
        }
        break;
    case 'database':
        switch (Template::GetPageData('subaction')) {
            default:
                Template::LoadTemplate('content_database');
                break;
            case 'open':
                if (!isset($_GET['table'])) {
                    Template::LoadTemplate('content_database_opened');
                } else {
                    Template::LoadTemplate('content_table_list');
                }
                break;
        }
        break;
}
?>
   
$key_action = '';
if (is_array($table_data)) {
    echo '<th width="" scope="col">Actions</th>';
    foreach ($table_data as $cell) {
        echo sprintf('<th width="" scope="col">%s</th>', $cell['name']);
        if ($cell['key'] == true) {
            $key_action .= $cell['name'] . ';';
        }
    }
}
?>
              </tr>
            </thead>
            <tbody>
                <?php 
$data = Admin::GetDB()->select("SELECT * FROM `%s` LIMIT %d, 20", $_GET['table'], 20 * (Template::GetPageData('page') - 1));
if (is_array($data)) {
    foreach ($data as $item) {
        $data_item = array_slice($item, 0, 1);
        $keys = array_keys($data_item);
        $values = array_values($data_item);
        echo sprintf('<tr>
                        <td width="90">
                        <a href="?%s&edit=%d&key=%s" class="edit_icon" title="Edit"></a>
                        <a href="?%s&delete=%d&key=%s" class="delete_icon" title="Delete"></a></td>', $str, $values[0], $key_action, $str, $values[0], $key_action);
        foreach ($item as $key => $value) {
            echo sprintf('<td>%s</td>', $value);
        }
        echo '</tr>';
    }
}
?>
">Username</a></th>
                <th width="102" scope="col">Hash</th>
                <th width="109" scope="col"><a href="?action=accounts&sortby=gmlevel&sorttype=<?php 
echo isset($_GET['sorttype']) ? $_GET['sorttype'] == 'ASC' ? 'DESC' : 'ASC' : 'ASC';
?>
">GM Level</a></th>
                <th width="129" scope="col">E-Mail</th>
                <th width="171" scope="col">IP Address</th>
                <th width="123" scope="col">Last Login</th>
                <th width="90" scope="col">Actions</th>
              </tr>
            </thead>
            <tbody>
                <?php 
$accounts_list = Template::GetPageData('accounts_list');
if (is_array($accounts_list)) {
    foreach ($accounts_list as $account) {
        echo sprintf('<tr>
                <td width="34"><label>
                    <input type="checkbox" name="checkbox" id="checkbox" />
                </label></td>
                <td>%s</td>
                <td>%s</td>
                <td>%d</td>
                <td>%s</td>
                <td>%s</td>
                <td>%s</td>
                <td width="90"><a href="?action=accounts&subaction=edit&accountid=%d" class="edit_icon" title="Edit"></a> <a href="?action=accounts&subaction=delete&accountid=%d" class="delete_icon" title="Delete"></a></td>
              </tr>', $account['username'], $account['sha_pass_hash'], $account['gmlevel'], $account['email'], $account['last_ip'], $account['last_login'], $account['id'], $account['id']);
    }
<!-- CONTENT START -->
    <div class="grid_16" id="content">
   <!-- CONTENT TITLE -->
    <div class="grid_9">
    <h1 class="content_edit">Edit Account</h1>
    </div>
<!--    TEXT CONTENT OR ANY OTHER CONTENT START     -->
    <div class="grid_15" id="textcontent">
    <a href="?action=accounts">Go back</a>
    
    <?php 
$account = Admin::GetAccount(Template::GetPageData('accountid'));
if (is_array($account)) {
    $gm_levelInfo = null;
    if (!isset($account['gmlevel'])) {
        // trinity.
        $gmlevels = Armory::$rDB->select("SELECT * FROM `account_access` WHERE `id` = %d", $account['id']);
        if (is_array($gmlevels)) {
            foreach ($gmlevels as $gmlevel) {
                $gm_levelInfo .= sprintf('<label>RealmID: "%d"</label><input type="text" name="gmlevel_%d" value="%d" />', $gmlevel['RealmID'], $gmlevel['RealmID'], $gmlevel['gmlevel']);
            }
        }
    } else {
        $gm_levelInfo = sprintf('<input type="text" name="gmlevel" value="%d" />', $account['gmlevel']);
    }
    echo sprintf('<form id="edit" name="edit" action="?action=accounts&subaction=edit&accountid=%d" method="post">
    <label>User ID (do not change!):</label>
    <input type="text" name="id" value="%d" />
    <label>User Name:</label>
    <input type="text" name="username" value="%s" />
    <label>Sha1 Hash:</label>