" />
<a href="http://dev.mysql.com/doc/refman/5.0/en/data-type-overview.html" target="_blank">MySQL Data Types >></a>
</div>
</td></tr></table>
</div>
<div style="display: none" class="fieldOption indexed clear"><br/>
<div class="label"><?php
echo t('MySQL Indexing');
?>
</div>
<div>
<input type="hidden" name="indexed" value="0"/>
<label>
<input type="checkbox" name="indexed" value="1" <?php
checkedIf(@$field['indexed'], '1');
?>
/>
<?php
$format = t('Create %scolumn index%s - speeds up sorting and some searches but slows down adding and saving records.');
echo sprintf($format, '<a href="http://dev.mysql.com/doc/refman/5.0/en/column-indexes.html" target="_blank">', '</a>');
?>
</label>
</div>
</div>
</div>
</fieldset>
<div style="padding: 10px 0px 10px 0px">
<div class="divider_line"></div>
You can safely ignore these options if you don't need them.<br/><br/><br/>
<h4>Development/Staging Servers</h4>
<table border="0" cellpadding="0" cellspacing="2">
<tr>
<td>Use Custom Settings File</td>
<td>
<input type="hidden" name="useCustomSettingsFile" value="0" />
<label>
<?php
if (file_exists(SETTINGS_DEV_FILEPATH)) {
$_REQUEST['useCustomSettingsFile'] = 1;
}
?>
<input type="checkbox" name="useCustomSettingsFile" value="1" <?php
checkedIf(@$_REQUEST['useCustomSettingsFile'], '1');
?>
/>
For this domain name only (<?php
echo htmlencode(@$_SERVER['HTTP_HOST']);
?>
) use this setting file: <b>/data/<?php
echo htmlencode(SETTINGS_DEV_FILENAME);
?>
</b>.<br/>
Using a separate settings file for development servers ensures you never accidentally overwrite your live server settings
when uploading CMS /data/ files. Always use custom settings files for development servers only, not your live servers.<br/>
</label><br/>
</td>
</tr>
function getTableRow($record, $value, $formType)
{
global $TABLE_PREFIX;
// load access list
$accessList = array();
if (@$_REQUEST['num']) {
$query = "SELECT * FROM `{$TABLE_PREFIX}_accesslist` WHERE userNum = '" . mysql_escape($_REQUEST['num']) . "'";
$result = mysql_query($query) or die("MySQL Error: " . htmlencode(mysql_error()) . "\n");
while ($record = mysql_fetch_assoc($result)) {
$accessList[$record['tableName']] = $record;
}
}
// get section list
$sectionList = array();
foreach (getSchemaTables() as $tableName) {
$schema = loadSchema($tableName);
$allowedMenuTypes = array('single', 'multi', 'category', 'menugroup', 'link', 'custom');
if (!in_array(@$schema['menuType'], $allowedMenuTypes)) {
continue;
}
$thisMenu = array();
$thisMenu['menuName'] = htmlencode($schema['menuName']);
if (@$schema['menuType'] != 'menugroup') {
$thisMenu['menuName'] = ' ' . $thisMenu['menuName'];
}
if (@$schema['_indent']) {
$thisMenu['menuName'] = ' ' . $thisMenu['menuName'];
}
$thisMenu['menuOrder'] = $schema['menuOrder'];
$thisMenu['tableName'] = $tableName;
$thisMenu['menuType'] = $schema['menuType'];
array_push($sectionList, $thisMenu);
}
uasort($sectionList, '_sortMenusByOrder');
// sort menus by order value
// display field
$allAccessLevel = @$accessList['all']['accessLevel'];
$sectionsDivStyle = $allAccessLevel != 1 ? "display: none;" : '';
//
ob_start();
?>
<tr>
<td valign="top" style="padding-top: 2px"><?php
echo $this->label;
?>
</td>
<td>
<table border="0" cellspacing="1" cellpadding="0">
<thead>
<tr>
<th width="305"><?php
et('Section Name');
?>
</th>
<th width="115" style="text-align: center"><?php
et('Access');
?>
</th>
<th width="100" style="text-align: center"><?php
et('Max Records');
?>
</th>
</tr>
</thead>
<tr>
<td class="listRow listRowOdd"><?php
et('All Sections');
?>
</td>
<td class="listRow listRowOdd" style="text-align: center">
<select name="accessList[all][accessLevel]" style="width: 140px" onchange="(this.value=='1') ? $('.sectionAccessList').slideDown() : $('.sectionAccessList').slideUp();">
<option value="0" <?php
selectedIf($allAccessLevel, '0');
?>
><?php
et('None');
?>
</option>
<option value="3" <?php
selectedIf($allAccessLevel, '3');
?>
><?php
et('Viewer');
?>
</option>
<option value="6" <?php
selectedIf($allAccessLevel, '6');
?>
><?php
et('Author');
?>
</option>
<option value="7" <?php
selectedIf($allAccessLevel, '7');
?>
><?php
eht('Author & Viewer');
?>
</option>
<option value="9" <?php
selectedIf($allAccessLevel, '9');
?>
><?php
et('Editor');
?>
</option>
<option value="1" <?php
selectedIf($allAccessLevel, '1');
?>
><?php
et('By Section');
?>
</option>
</select>
</td>
<td class="listRow listRowOdd" style="text-align: center"><?php
et('No Limit');
?>
</td>
</tr>
</table>
<script type="text/javascript">
function toggleDisabledForAccessListMaxRecords(tablename) {
var accessLevel = $("#accesslevel_"+tablename).val();
var disableMaxRecords = (accessLevel == 9 || accessLevel == 3);
if (disableMaxRecords) { $("#maxRecords_"+tablename).attr("disabled", true).css("background-color","#DDD"); }
else { $("#maxRecords_"+tablename).removeAttr("disabled").css("background-color","#FFF"); }
}
</script>
<div class="sectionAccessList" style="<?php
echo $sectionsDivStyle;
?>
">
<div style="width: 0px; height: 0px;"></div><?php
/* fixes IE7 issue which caused table to get no layout space, causing overlap and missing table content. the issue seems to be caused by a div with only a table inside. adding anything else inside the div seems to fix it, including  , but that adds extra whitespace, hence the div with no area */
?>
<table border="0" cellspacing="1" cellpadding="0">
<?php
// list sections
foreach ($sectionList as $section) {
$bgColorClass = @$bgColorClass == "listRowEven" ? 'listRowOdd' : 'listRowEven';
# rotate bgclass
$fieldnamePrefix = "accessList[{$section['tableName']}]";
$accessLevel = @$accessList[$section['tableName']]['accessLevel'];
$maxRecords = @$accessList[$section['tableName']]['maxRecords'];
$disableMaxRecords = $accessLevel == 9 || $accessLevel == 3;
$maxRecordsAttr = $disableMaxRecords ? 'style="text-align: center; background-color: #DDD;" disabled="disabled"' : 'style="text-align: center;"';
?>
<tr>
<td class="listRow <?php
echo $bgColorClass;
?>
" width="305"> <?php
echo $section['menuName'];
?>
</td>
<td class="listRow <?php
echo $bgColorClass;
?>
" width="115" style="text-align: center">
<?php
if ($section['menuType'] == 'single' || $section['tableName'] == 'accounts' || $section['menuType'] == 'menugroup' || $section['menuType'] == 'link') {
?>
<input type="hidden" name="<?php
echo $fieldnamePrefix;
?>
[accessLevel]" value="0" />
<input type="checkbox" name="<?php
echo $fieldnamePrefix;
?>
[accessLevel]" value="9" <?php
checkedIf($accessLevel, '9');
?>
/>
<?php
} elseif ($section['menuType'] == 'multi') {
?>
<select name="<?php
echo $fieldnamePrefix;
?>
[accessLevel]" id="accesslevel_<?php
echo $section['tableName'];
?>
" style="width: 140px" onchange="toggleDisabledForAccessListMaxRecords('<?php
echo $section['tableName'];
?>
')">
<option value="0" <?php
selectedIf($accessLevel, '0');
?>
><?php
et('None');
?>
</option>
<option value="3" <?php
selectedIf($accessLevel, '3');
?>
><?php
et('Viewer');
?>
</option>
<option value="6" <?php
selectedIf($accessLevel, '6');
?>
><?php
et('Author');
?>
</option>
<option value="7" <?php
selectedIf($accessLevel, '7');
?>
><?php
eht('Author & Viewer');
?>
</option>
<option value="9" <?php
selectedIf($accessLevel, '9');
?>
><?php
et('Editor');
?>
</option>
</select>
<?php
} elseif ($section['menuType'] == 'category') {
?>
<select name="<?php
echo $fieldnamePrefix;
?>
[accessLevel]" id="accesslevel_<?php
echo $section['tableName'];
?>
" style="width: 140px" onchange="toggleDisabledForAccessListMaxRecords('<?php
echo $section['tableName'];
?>
')">
<option value="0" <?php
selectedIf($accessLevel, '0');
?>
><?php
et('None');
?>
</option>
<option value="9" <?php
selectedIf($accessLevel, '9');
?>
><?php
et('Editor');
?>
</option>
</select>
<?php
}
?>
</td>
<td class="<?php
echo $bgColorClass;
?>
" width="100" style="text-align: center">
<?php
if ($section['menuType'] == 'single') {
printf(t("Single Page"));
} elseif ($section['tableName'] == 'accounts') {
?>
<?php
} elseif ($section['menuType'] == 'multi') {
?>
<input class="text-input medium-input" type="text" name="<?php
echo $fieldnamePrefix;
?>
[maxRecords]" id="maxRecords_<?php
echo $section['tableName'];
?>
"
value="<?php
echo $maxRecords;
?>
" size="6" maxlength="6"
<?php
echo $maxRecordsAttr;
?>
/>
<?php
}
?>
</td>
</tr>
<?php
}
?>
</table></div>
<br/><div style="font-size: 11px">
<b><?php
et('Access Levels:');
?>
</b><br/>
<div style="padding-left: 20px;">
<?php
et('None - Don\'t allow user to access this section');
?>
<br/>
<?php
et('Viewer - User can view any record in this section (must also be enabled in section editor)');
?>
<br/>
<?php
et('Author - User can only access records they have created');
?>
<br/>
<?php
eht("Author & Viewer - User can view any record and modify records they've created");
?>
<br/>
<?php
et('Editor - User can access any records in this section');
?>
<br/>
</div>
<?php
et('Max Records: Max records user is allowed to create (for regular users only - leave blank for unlimited)');
?>
</div>
</td>
</tr>
<?php
$html = ob_get_clean();
return $html;
}
</label>
</td>
</tr>
<tr>
<td width="200"><?php
et("Restrict IP Access");
?>
</td>
<td height="22">
<input type="hidden" name="restrictByIP" value="0"/>
<label>
<input type="checkbox" name="restrictByIP" value="1" <?php
checkedIf($SETTINGS['advanced']['restrictByIP'], '1');
?>
/>
<?php
echo sprintf("Only allow users to login from these IP addresses. eg: 1.2.3.4, 4.4.4.4 (Your IP is: %s)", $_SERVER['REMOTE_ADDR']);
?>
</label>
<div style="padding-left: 25px">
<input class="text-input wide-input" type="text" name="restrictByIP_allowed" value="<?php
echo htmlencode(@$SETTINGS['advanced']['restrictByIP_allowed']);
?>
" size="30" />
</div>
</td>
</tr>
/>
<label for="hideRecordsFromDisabledAccounts"><?php
echo t('Viewers: Hide records that are "Created By" a user who is: deleted, disabled, or expired');
?>
</label>
</td>
</tr>
<tr>
<td class="labelColumn"><?php
echo t('Hide Menu');
?>
</td>
<td>
<input type="hidden" name="menuHidden" value="0" />
<input type="checkbox" name="menuHidden" id="menuHidden" value="1" <?php
checkedIf(@$schema['menuHidden'], '1');
?>
/>
<label for="menuHidden"><?php
echo t('Don\'t show this section on the menu bar');
?>
</label>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td class="labelColumn"><?php
echo t('Required Plugins');
?>
</td>
function cg2_inputCheckbox($name)
{
$checkedAttr = checkedIf("1", @$_REQUEST[$name], true);
$html = "<input type='hidden' name='{$name}' value='0' />";
$html .= "<input type='checkbox' name='{$name}' id='{$name}' value='1' {$checkedAttr} />";
return $html;
}