0)) { $fDomain = $list_domains[0]; } } elseif ($_SERVER['REQUEST_METHOD'] == "POST") { if (isset($_POST['fDomain'])) { $fDomain = escape_string($_POST['fDomain']); } } else { die('Unknown request method'); } if (! (check_owner($SESSID_USERNAME, $fDomain) || authentication_has_role('global-admin'))) { $error = 1; flash_error($PALANG['pViewlog_result_error']); } // we need to initialize $tLog as an array! $tLog = array(); if ($error != 1) { $table_log = table_by_key('log'); $page_size = isset($CONF['page_size']) ? intval($CONF['page_size']) : 35; $query = "SELECT timestamp,username,domain,action,data FROM $table_log WHERE domain='$fDomain' ORDER BY timestamp DESC LIMIT $page_size"; if (db_pgsql()) { $query = "SELECT extract(epoch from timestamp) as timestamp,username,domain,action,data FROM $table_log WHERE domain='$fDomain' ORDER BY timestamp DESC LIMIT $page_size"; } $result=db_query($query); if ($result['rows'] > 0) { while ($row = db_assoc($result['result'])) { if (db_pgsql()) { $row['timestamp']=gmstrftime('%c %Z', $row['timestamp']); } $tLog[] = $row; } } } for ($i = 0; $i < count($tLog); $i++) { $tLog[$i]['action'] = $PALANG ['pViewlog_action_'.$tLog [$i]['action']]; } $smarty->assign('domain_list', $list_domains); $smarty->assign('domain_selected', $fDomain); $smarty->assign('tLog', $tLog, false); $smarty->assign('fDomain', $fDomain); $smarty->assign('smarty_template', 'viewlog'); $smarty->display('index.tpl'); /* vim: set expandtab softtabstop=3 tabstop=3 shiftwidth=3: */