function passiveField($name = false, $caption = false, $subtable = false, $subtable_fields = false, $link_url = false, $concat_char = false, $f_id_field = false, $order_by = false, $order_asc = false, $link_is_tab = false, $limit_is_curdate = false, $create_db_field = false, $default_value = false, $dont_fill_automatically = false)
{
global $CFG;
$HTML = '';
if ($this->table && $create_db_field) {
$type = $create_db_field == 'datetime' ? 'date' : $create_db_field;
$this->db_fields[$name] = $type;
$value = empty($this->info[$name]) && $default_value !== false ? $default_value : $this->info[$name];
$value1 = $value;
if ($create_db_field == 'date' || $create_db_field == 'datetime') {
$time = $create_db_field == 'datetime' ? ' ' . $CFG->default_time_format : '';
if (!$dont_fill_automatically) {
$value = !empty($value) ? $value : date($CFG->default_date_format . $time);
$value1 = date('Y-m-d H:i:s', strtotime($value));
}
}
$HTML .= "<input type=\"hidden\" name=\"{$this->name}[{$name}]\" value=\"{$value1}\" id=\"{$this->name}_{$name}\"/>";
}
$CFG->o_method_id = $CFG->method_id;
$CFG->o_method_name = 'passiveField';
$record = new Record($this->table, $this->record_id);
$HTML .= '<div id="passive_' . $this->name . '_' . $name . '">' . $record->field($name, $caption, $subtable, $subtable_fields, $link_url, $concat_char, true, $f_id_field, $order_by, $order_asc, $this->record_id, $link_is_tab, $limit_is_curdate, $value) . '</div>';
if ($f_id_field) {
if (stristr($f_id_field, ',')) {
$f_parts = explode(',', $f_id_field);
$f_id_field1 = $f_parts[0];
} else {
$f_id_field1 = $f_id_field;
}
if (strstr($f_id_field1, '.')) {
$f_parts1 = explode('.', $f_id_field1);
$get_field = $f_parts1[1];
} else {
$get_field = $f_id_field1;
}
if ($get_field && !$CFG->pm_editor) {
$HTML .= '
<script type="text/javascript">
getPassiveValue(\'ajax.passive.php?table=' . $this->table . '&name=' . $name . '&caption=' . $caption . '&subtable=' . $subtable . '&subtable_fields=' . urlencode(serialize($subtable_fields)) . '&link_url=' . $link_url . '&concat_char=' . $concat_char . '&f_id_field=' . $f_id_field . '&order_by=' . $order_by . '&order_asc=' . $order_asc . '&link_is_tab=' . $link_is_tab . '&limit_is_curdate=' . $limit_is_curdate . '&record_id=' . $this->record_id . '\',\'passive_' . $this->name . '_' . $name . '\',\'' . $this->name . '_' . $get_field . '\');
</script>
';
}
}
$this->HTML[] = $HTML;
}
private function show($comments)
{
global $CFG;
if ($comments) {
echo '<ul>';
foreach ($comments as $comment) {
$elapsed = time() + Settings::mysqlTimeDiff() * 3600 - strtotime($comment['date']);
if ($elapsed < 60) {
$time_ago = $CFG->comments_less_than_minute;
} elseif ($elapsed > 60 && $elapsed < 60 * 60) {
$minutes = floor($elapsed / 60);
$time_ago = str_ireplace('[field]', $minutes, $CFG->comments_minutes_ago);
} elseif ($elapsed > 60 * 60 && $elapsed < 60 * 60 * 24) {
$hours = floor($elapsed / 60 / 60);
$time_ago = str_ireplace('[field]', $hours, $CFG->comments_hours_ago);
} elseif ($elapsed > 60 * 60 * 24 && $elapsed < 60 * 60 * 24 * 30.4) {
$days = floor($elapsed / 60 / 60 / 24);
$time_ago = str_ireplace('[field]', $days, $CFG->comments_days_ago);
} else {
$months = floor($elapsed / 60 / 60 / 24 / 30.4);
$time_ago = str_ireplace('[field]', $months, $CFG->comments_months_ago);
}
if ($comment['user_id'] > 0) {
$user = DB::getRecord($this->user_table, $comment['user_id'], false, true);
$name = !empty($comment['website']) ? Link::url($comment['website'], $user['user']) : $user['user'];
} else {
$name = !empty($comment['website']) ? Link::url($comment['website'], $comment['name']) : $comment['name'];
}
$short = $this->short_version ? '_short' : '';
$icon = $comment['type'] ? eval('return $CFG->comment_type_' . $comment['type'] . ';') : $CFG->comment_type_1;
$action = $comment['type'] ? eval('return $CFG->comments_action_' . $comment['type'] . $short . ';') : $CFG->comments_wrote_label;
$action = String::doFormulaReplacements($action, unserialize($comment['f_table_row']), 1, 1);
echo '
<li id="comment_' . $comment['id'] . '" class="level_' . $comment['type'] . '">
<div class="c_head">';
if ($this->fields) {
foreach ($this->fields as $f_name => $field) {
$CFG->o_method_id = $field['method_id'];
$CFG->o_method_name = 'field';
$record = new Record($field['table'], $comment['record_id']);
echo '<div class="added_field">' . $record->field($field['name'], $field['caption'], $field['subtable'], $field['subtable_fields'], $field['link_url'], $field['concat_char'], true, $field['f_id_field'], $field['order_by'], $field['order_asc'], $comment['record_id'], $field['link_is_tab'], $field['limit_is_curdate'], false, $field['link_id_field']) . '</div>';
}
}
echo '
' . $icon . ' ' . $name . ' (' . $time_ago . ') ' . $action . '
</div>';
if (!$this->short_version) {
echo '
<div class="c_comment">
' . (strlen($comment['comments']) != strlen(strip_tags($comment['comments'])) ? $comment['comments'] : nl2br($comment['comments'])) . '
</div>';
}
echo '
' . ($comment['type'] <= 1 && !$this->short_version ? '<div class="c_reply"><a href="#" onclick="showReplyBox(' . $comment['id'] . ',' . $this->i . ');return false;">' . $CFG->comments_reply_label . '</a></div>' : '') . '
<div class="c_form"></div>
</li>';
if (is_array($comment['children'])) {
Comments::show($comment['children']);
}
}
echo '<div style="clear:both;height:0;"></div></ul>';
}
}
function passiveField($name = false, $caption = false, $subtable = false, $subtable_fields = false, $link_url = false, $concat_char = false, $f_id_field = false, $order_by = false, $order_asc = false, $link_is_tab = false, $limit_is_curdate = false, $create_db_field = false, $default_value = false, $dont_fill_automatically = false)
{
global $CFG;
$HTML = '';
$record = new Record($this->table, $this->record_id);
$HTML .= '<div id="passive_' . $this->name . '_' . $name . '">' . $record->field($name, $caption, $subtable, $subtable_fields, $link_url, $concat_char, true, $f_id_field, $order_by, $order_asc, $this->record_id, $link_is_tab, $limit_is_curdate, $value) . '</div>';
if ($f_id_field) {
if (stristr($f_id_field, ',')) {
$f_parts = explode(',', $f_id_field);
$f_id_field1 = $f_parts[0];
} else {
$f_id_field1 = $f_id_field;
}
if (strstr($f_id_field1, '.')) {
$f_parts1 = explode('.', $f_id_field1);
$get_field = $f_parts1[1];
} else {
$get_field = $f_id_field1;
}
if ($get_field) {
$HTML .= '
<script type="text/javascript">
getPassiveValue(\'ajax.passive.php?table=' . $this->table . '&name=' . $name . '&caption=' . $caption . '&subtable=' . $subtable . '&subtable_fields=' . urlencode(serialize($subtable_fields)) . '&link_url=' . $link_url . '&concat_char=' . $concat_char . '&f_id_field=' . $f_id_field . '&order_by=' . $order_by . '&order_asc=' . $order_asc . '&link_is_tab=' . $link_is_tab . '&limit_is_curdate=' . $limit_is_curdate . '&record_id=' . $this->record_id . '\',\'passive_' . $this->name . '_' . $name . '\',\'' . $this->name . '_' . $get_field . '\');
</script>
';
}
}
$this->HTML[] = $HTML;
}
if ($_REQUEST['table'] == 'admin_tabs') {
if (!in_array('hidden', $table_fields)) {
$sql = "ALTER TABLE admin_tabs ADD admin_tabs.hidden ENUM( 'Y', 'N' ) NOT NULL";
db_query($sql);
}
if (!in_array('is_ctrl_panel', $table_fields)) {
$sql = "ALTER TABLE admin_tabs ADD admin_tabs.is_ctrl_panel ENUM( 'Y', 'N' ) NOT NULL";
db_query($sql);
}
if (!in_array('for_group', $table_fields)) {
$sql = "ALTER TABLE admin_tabs ADD admin_tabs.for_group INT( 10 ) UNSIGNED NOT NULL";
db_query($sql);
}
}
$record = new Record($_REQUEST['table'], $_REQUEST['id']);
$record->field('name', 'Name:');
$record->field('url', 'Url');
$record->field('order', 'Order');
if ($_REQUEST['table'] == 'admin_tabs') {
$record->field('hidden', 'Hidden?');
$record->field('is_ctrl_panel', 'Is Control Panel?');
$record->field('for_group', 'For Group', 'admin_groups', array('name'));
} elseif ($_REQUEST['table'] == 'admin_pages') {
if (in_array('icon', $table_fields)) {
$record->field('icon', 'Icon');
}
}
$record->display();
$form = new Form('dummy');
$form->button(false, $CFG->ok_button, false, false, false, false, 'onclick="closePopup(this);"');
$form->display();
<?php
include 'lib/common.php';
$CFG->passive_override_id = $_REQUEST['get_id'];
$record = new Record($_REQUEST['table'], $_REQUEST['record_id']);
if ($_REQUEST['action'] == 'indicator') {
echo $record->indicator($_REQUEST['name'], $_REQUEST['formula'], $_REQUEST['caption'], $_REQUEST['subtable'], @unserialize($_REQUEST['subtable_fields']), $_REQUEST['concat_char'], $_REQUEST['formula_id_field'], $_REQUEST['f_id_field'], $_REQUEST['link_url'], $_REQUEST['link_is_tab'], $_REQUEST['run_in_sql'], 1);
} else {
echo $record->field($_REQUEST['name'], $_REQUEST['caption'], $_REQUEST['subtable'], @unserialize($_REQUEST['subtable_fields']), $_REQUEST['link_url'], $_REQUEST['concat_char'], true, $_REQUEST['f_id_field'], $_REQUEST['order_by'], $_REQUEST['order_asc'], 1, $_REQUEST['link_is_tab'], $_REQUEST['limit_is_curdate'], $_REQUEST['get_id']);
}
unset($record);
date_default_timezone_set($CFG->default_timezone);
String::magicQuotesOff();
if ($_REQUEST['users_form']) {
$form = new Form('users_form', false, false, false, $_REQUEST['table']);
$form->verify();
$form->save();
$form->get($_REQUEST['id']);
$form->show_errors();
$form->show_messages();
PermissionEditor::save();
}
if ($CFG->action == 'record') {
$view = new Record($_REQUEST['table'], $_REQUEST['id']);
if ($_REQUEST['table'] == 'admin_groups') {
$view->field('name', $CFG->user_group_name);
} else {
$view->field('id', 'ID');
$view->field('first_name', $CFG->user_first_name);
$view->field('last_name', $CFG->user_last_name);
$view->field('phone', $CFG->user_phone);
$view->field('email', $CFG->user_email);
$view->field('f_id', $CFG->user_group, 'admin_groups', array('name'));
$view->field('is_admin', $CFG->user_is_admin);
}
$view->display();
if ($_REQUEST['table'] == 'admin_groups') {
$pe = new PermissionEditor('admin', $_REQUEST['id']);
}
$form = new Form('dummy');
//$form->button(false,$CFG->ok_button,false,false,false,false,'onclick="closePopup(this);"');
