function _database_unescape()
{
static $unescape_data = array('quotes' => array('keys' => array('quote_id'), 'cols' => array('quote_text', 'quote_author')), 'article_contents' => array('keys' => array('article_content_id'), 'cols' => array('article_content_heading', 'article_content_subheading', 'article_content_subtext', 'article_content_blurb')), 'links' => array('keys' => array('link_id'), 'cols' => array('link_url', 'link_name')), 'subscriptions' => array('keys' => array('subscription_organisation_entity_id', 'subscription_user_entity_id'), 'cols' => array('subscription_user_position')), 'users' => array('keys' => array('user_entity_id'), 'cols' => array('user_contact_phone_number')), 'organisations' => array('keys' => array('organisation_entity_id'), 'cols' => array('organisation_name', 'organisation_yorkipedia_entry')), 'organisation_contents' => array('keys' => array('organisation_content_id'), 'cols' => array('organisation_content_description', 'organisation_content_postal_address', 'organisation_content_postcode', 'organisation_content_phone_external', 'organisation_content_phone_internal', 'organisation_content_fax_number', 'organisation_content_email_address', 'organisation_content_url', 'organisation_content_opening_hours')));
if (false !== $this->input->post('go_unescape')) {
$make_changes = false !== $this->input->post('confirm_changes');
echo 'Starting unescaping of database fields<br />';
foreach ($unescape_data as $table => $data) {
list($keys, $cols) = array($data['keys'], $data['cols']);
echo 'Unescaping table `' . xml_escape($table) . '`<br /><ul>';
// Get the rows from the database first
$this->db->select(array_merge($keys, $cols));
$this->db->from($table);
$query = $this->db->get();
$result_data = array();
foreach ($query->result_array() as $row) {
$changes = array();
$key_values = array();
foreach ($keys as $key) {
$key_values[$key] = $row[$key];
}
foreach ($cols as $col) {
if (is_string($row[$col]) && $row[$col] != xml_unescape($row[$col])) {
$need_updating = true;
echo '<li>"' . xml_escape($row[$col]) . '"<ul><li>"' . $row[$col] . '"</li></ul></li>';
$changes[$col] = xml_unescape($row[$col]);
}
}
if (!empty($changes) && $make_changes) {
$this->db->where($key_values);
$this->db->update($table, $changes);
}
}
echo '</ul>';
}
if ($make_changes) {
echo 'Unescaping completed (<a href="' . site_url('admin') . '">Return to admin</a>)<br />';
} else {
echo '<form action="' . site_url($this->uri->uri_string()) . '" method="post"><label><input type="checkbox" name="confirm_changes" />Confirm changes</label><br /><input type="submit" name="go_unescape" value="Unescape now" /></form>';
}
} else {
$update_list = '<ul>';
foreach ($unescape_data as $table => $data) {
$update_list .= '<li>' . xml_escape('table `' . $table . '` (keys: `' . implode('`, `', $data['keys']) . '`).');
$update_list .= '<ul>';
foreach ($data['cols'] as $col) {
$update_list .= '<li>' . xml_escape('`' . $table . '`.`' . $col . '`') . '</li>';
}
$update_list .= '</ul>';
$update_list .= '</li>';
}
$update_list .= '</ul>';
$this->messages->AddMessage('warning', '<p>To unescape the following fields in the database, make sure you are sure and know what you are doing first. The following fields will be unescaped:</p> ' . $update_list . '<p>If you are sure click here:</p><form action="' . site_url($this->uri->uri_string()) . '" method="post"><input type="submit" name="go_unescape" value="Next Stage" /></form>');
$this->main_frame->Load();
}
}
function port()
{
if (!CheckPermissions('admin')) {
return;
}
$this->load->model('permissions_model');
$generateTextRoles = true;
if (isset($_POST['role_permissions']) && is_string($_POST['role_permissions'])) {
$textRoles = $_POST['role_permissions'];
$lines = explode("\n", $textRoles);
$rolePermissions = array();
$fail = false;
foreach ($lines as $count => $line) {
if (strlen($line)) {
if (preg_match('/^\\s*"([^"]+)"\\s*:((\\s*"[^"]+")*)\\s*$/', $line, $matches)) {
$escaped_role = $matches[1];
$role = xml_unescape($escaped_role);
if (!preg_match('/^\\w*$/', $role)) {
$this->messages->AddMessage('error', 'Invalid role: "' . $escaped_role . '" on line ' . ($count + 1) . '.');
$fail = true;
}
$permissionsString = $matches[2];
$permissionsSparse = explode('"', $permissionsString);
$permissions = array();
foreach ($permissionsSparse as $id => $permission) {
if ($id % 2 == 1) {
$unescaped_permission = xml_unescape($permission);
if (!preg_match('/^\\w*$/', $unescaped_permission)) {
$this->messages->AddMessage('error', 'Invalid permission: "' . $permission . '" in role "' . $escaped_role . '" on line ' . ($count + 1) . '.');
$fail = true;
}
$permissions[] = $unescaped_permission;
}
}
$rolePermissions[$role] = $permissions;
} else {
$this->messages->AddMessage('error', 'Syntax error on line ' . ($count + 1) . '.');
$fail = true;
}
}
}
if (!$fail) {
$this->permissions_model->clearRolePermissions();
$this->permissions_model->addRolePermissions($rolePermissions);
$this->messages->AddMessage('success', 'Role permissions replaced');
} else {
$generateTextRoles = false;
}
}
if ($generateTextRoles) {
$rolePermissions = $this->permissions_model->getAllRolePermissions();
$textRoles = '';
foreach ($rolePermissions as $role => $permissions) {
$textRoles .= '"' . xml_escape($role) . '":';
foreach ($permissions as $permission) {
$textRoles .= ' "' . xml_escape($permission) . '"';
}
$textRoles .= "\n";
}
}
$data = array('textRoles' => $textRoles);
$this->pages_model->SetPageCode('admin_permissions_port');
$data['xml_info'] = $this->pages_model->GetPropertyWikitext('info');
$this->main_frame->SetContentSimple('admin/permissions/export_roles', $data);
$this->main_frame->Load();
}
function handle_emphasize($matches)
{
$amount = strlen(xml_unescape($matches[1]));
return $this->emphasize($amount);
}
