if (dbrows($result)) {
while ($data = dbarray($result)) {
$options .= "<option " . ($select == $data['field_name'] ? "selected='selected'" : "") . ">" . $data['field_name'] . "</option>\n";
}
}
return $options;
}
opentable($locale['100']);
echo "<form action='" . FUSION_SELF . "' method='get'>\n";
echo "<input type='hidden' name='aid' value='" . iAUTH . "' />\n";
echo "<table cellpadding='0' cellspacing='1' class='tbl-border center' style='width:400px;'>\n";
echo "<tr>\n";
echo "<td class='tbl1' align='left'>" . $locale['107'] . "</td>\n";
echo "<td class='tbl1' align='right'>\n";
echo "<select name='orderby' size='1' class='textbox' style='width:150px;'>" . orderbyOptions($orderby) . "</select>\n";
echo " <select name='expr' size='1' class='textbox' style='width:100px;'>" . exprOptions($expr) . "</select>\n";
echo "</td>\n</tr>\n<tr>\n";
echo "<td class='tbl1' align='left'>" . $locale['108'] . "</td>\n";
echo "<td class='tbl1' align='right'><input type='text' name='user' value='" . $user . "' class='textbox' style='width:252px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl1'>" . $locale['115'] . "</td>";
echo "<td class='tbl1' align='right'><select name='userField' size='1' class='textbox' style='width:254px;'>" . userFieldOptions($userField) . "</select></td>";
echo "</tr>\n<tr>\n";
echo "<td class='tbl' align='left'></td>\n<td class='tbl' align='right'><input type='submit' value=' " . $locale['109'] . "' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
echo "<br />";
$result = dbquery("SELECT SQL_CALC_FOUND_ROWS userlog_id, userlog_user_id, userlog_field, userlog_value_old, userlog_value_new, userlog_timestamp, user_name, user_status\n\t\t\t\t FROM " . DB_USER_LOG . "\n\t\t\t\t LEFT JOIN " . DB_USERS . " ON userlog_user_id=user_id\n\t\t\t\t " . $dbWhere . "\n\t\t\t\t " . $dbOrder . "\n\t\t\t\t LIMIT " . $_GET['rowstart'] . ",20");
$rows = dbresult(dbquery("SELECT FOUND_ROWS()"), 0);
if (dbrows($result)) {
echo "<table cellpadding='0' cellspacing='1' class='tbl-border center' style='width: 700px;'>\n";
echo "<tr>\n";
while ($data = dbarray($result)) {
$options[$data['field_name']] = $data['field_name'];
}
}
return $options;
}
opentable($locale['100']);
// change to post.
echo openform('userlog_search', 'userlog_search', 'post', FUSION_SELF . $aidlink, array('downtime' => 0));
echo form_hidden('', 'aid', 'aid', iAUTH);
echo "<table cellpadding='0' cellspacing='1' class='table table-responsive tbl-border center'>\n<tbody>\n";
echo "<tr>\n";
echo "<td class='tbl1' align='left'><label for='orderby'>" . $locale['107'] . "</label></td>\n";
echo "<td class='tbl1' style='align:right;'>\n";
echo form_select('', 'orderby', 'orderby', orderbyOptions(), $orderby, array('placholder' => $locale['choose'], 'class' => 'pull-right m-r-10'));
echo form_select('', 'expr', 'expr', exprOptions(), $orderby, array('placholder' => $locale['choose']));
echo "</td>\n</tr>\n<tr>\n";
echo "<td class='tbl1' align='left'><label for='user'>" . $locale['108'] . "</label></td>\n";
echo "<td class='tbl1' align='right'>\n";
echo form_text('', 'user', 'user', $user);
echo "</td>\n</tr>\n<tr>\n";
echo "<td class='tbl1'><label for='userField'>" . $locale['115'] . "</label></td>";
echo "<td class='tbl1'>\n";
echo form_select('', 'userField', 'userField', userFieldOptions(), $userField, array('placeholder' => $locale['choose'], 'allowclear' => 1));
echo "</tr>\n<tr>\n";
echo "<td class='tbl' align='left'></td>\n<td class='tbl' align='right'>\n";
echo form_button($locale['109'], 'submit', 'submit', $locale['109'], array('class' => 'btn-primary'));
echo "</td>\n</tr>\n</tbody>\n</table>\n</form>\n";
echo "<br />";
// at least validate token.
if (!defined('FUSION_NULL')) {
