root/form/list_fields.php

<?php
/*
 * Elgg Forms
 * Kevin Jardine
 * Radagast Solutions
 * http://radagast.biz
 *
 * Displays existing fields
 *
 */
 
// Load Elgg framework
@require_once("../../includes.php");
    
// Define context
define("context","form");

$title = __gettext('Fields');

if (isloggedin() && run("users:flags:get", array("admin", $_SESSION['userid']))) {
    
    $type = optional_param('type','');
    
    if ($type == 'delete_orphans') {
        delete_records_select('form_fields', $select='ident NOT IN (SELECT field_id FROM '.$CFG->prefix.'form_fields_map)');
        $type = 'orphan';
    }
    
    $edit_msg = __gettext('Edit');
    $delete_msg = __gettext('Delete');
    $delete_orphans_confirm_msg = __gettext("Are you sure that you want to delete all the orphan field definitions?");
    if ($type == 'orphan') {
        $delete_confirm_msg = __gettext("Are you sure that you want to delete this field definition?");
    } else {
        $delete_confirm_msg = __gettext("Are you sure that you want to delete this field definition and erase it from all forms?");
    }
    
    $img_template = '<img border="0" width="16" height="16" alt="%s" title="%s" src="'.$CFG->wwwroot.'mod/widget/images/%s" />';
    $edit_img = sprintf($img_template,$edit_msg,$edit_msg,"16-em-pencil.png");
    $delete_img = sprintf($img_template,$delete_msg,$delete_msg,"16-em-cross.png");
    
    $field_template = <<<END
    <a href="{$CFG->wwwroot}mod/form/manage_field.php?action=edit_with_field_id&id=%s&type=%s">$edit_img</a> |
    <a onclick="return confirm('$delete_confirm_msg')" href="{$CFG->wwwroot}mod/form/manage_field.php?action=delete&id=%s&type=%s">$delete_img</a>
    &nbsp;&nbsp;&nbsp;%s
    <br />
END;
    if ($type == 'orphan') {
        $body = '<p><a href="'.$CFG->wwwroot.'mod/form/list_fields.php?type=all">'.__gettext("List all fields").'</a> | '."\n";
        $body .= '<a onclick="return confirm(\''.$delete_orphans_confirm_msg.'\')" href="'.$CFG->wwwroot.'mod/form/list_fields.php?type=delete_orphans">'.__gettext("Delete all orphan fields").'</a> | '."\n";
        $body .= '<a href="'.$CFG->wwwroot.'mod/form/index.php">'.__gettext("List all forms").'</a></p>'."\n";
        $body .= '<p>'.__gettext("This page lists all the fields not currently associated with a form.").'</p>'."\n";
        $fields = get_records_sql("SELECT * FROM {$CFG->prefix}form_fields "
            ."WHERE ident NOT IN (SELECT field_id FROM {$CFG->prefix}form_fields_map) ORDER BY internal_name ASC");
    } else {
        $body = '<p><a href="'.$CFG->wwwroot.'mod/form/list_fields.php?type=orphan">'.__gettext("List orphan fields").'</a> | '."\n";
        $body .= '<a href="'.$CFG->wwwroot.'mod/form/index.php">'.__gettext("List all forms").'</a></p>'."\n";
        $body .= '<p>'.__gettext("This page lists all the currently defined fields.").'</p>'."\n";
        $fields = get_records_sql("SELECT * FROM {$CFG->prefix}form_fields ORDER BY internal_name ASC"); 
    }

    if ($fields) {
        foreach ($fields as $field) {
            $body .= sprintf(
                $field_template,
                $field->ident,
                $type,
                $field->ident,
                $type,
                $field->title . ' ('.$field->internal_name.': '.$field->field_type.')');
        }
    } else {
        $body .= '<p>'.__gettext("There are no fields.").'</p>';
    }
} else {
    $body = __gettext("You must be logged in as a site administrator to view this page.");
}

// Output to the screen
$body = templates_draw(array(
                'context' => 'contentholder',
                'title' => $title,
                'body' => $body
            )
);

echo templates_page_draw( array(
                $title, $body
            )
);
    
    
?>