$result = dbquery("SELECT field_name FROM " . DB_USER_FIELDS . " WHERE field_log='1'"); 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";
if (dbrows($result)) { 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.