$darr[] = cleanInput($row['datetime']); } echo "<tbody>"; for ($i = $from1; $i < $from2; $i++) { $id = $idarr[$i]; $ip = $iparr[$i]; $uid = $uarr[$i]; $date = $darr[$i]; /* fetching the user's name from the database */ $name = get_username($uid); /* fetching country name for the specific ip address */ $country = $ip2country->get_country_name($ip); echo "<tr>"; echo "<td>{$id}</td>"; echo "<td>{$ip}</td>"; echo "<td><a href=\"{$website}/" . ADMIN_DIRECTORY . "/manageuser/{$uid}#/logs\">{$name}</a></td>"; echo "<td>{$country}</td>"; echo "<td><abbr class=\"micro\" title=\"{$date}\"></abbr></td>"; echo "</tr>"; } echo "</tbody>"; echo "</table>"; /* displaying pagination below the table. */ if ($number > $max_show) { $p->show();
function admin_edit_user($id) { global $db, $err, $log, $website; $current_url = current_url(); try { $sql = "SELECT * FROM `members` WHERE `id` = :id"; $sql_do = $db->prepare($sql); $sql_do->bindParam(':id', $id, PDO::PARAM_INT); $sql_do->execute(); $number = $db->query("SELECT FOUND_ROWS()")->fetchColumn(); } catch (PDOException $e) { $log->logError($e . " - " . basename(__FILE__)); } if (!empty($number)) { $f = $sql_do->fetch(PDO::FETCH_ASSOC); $verified = intval($f['verified']); $email_user = cleanInput($f['email']); $first_name = cleanInput($f['first_name']); $last_name = cleanInput($f['last_name']); $banned = intval($f['banned']); $joined_on = cleanInput($f['join']); $last_access = cleanInput($f['access']); $user_bio = cleanInput($f['bio']); /* displaying gravatar photo over here if email is associated with a gravatar account. */ $default = $website . "/images/anonuser_50px.gif"; $gravatar = new Gravatar($email_user, $default); $gravatar->size = 50; ?> <div class="page-header no-border"> <h1><img class="profilephoto thumbnail" src="<?php echo $gravatar->getSrc(); ?> " /> <?php echo $first_name . " " . $last_name; ?> </h1> </div> <?php echo "<ul class=\"breadcrumb\">\n<li><a href=\"{$website}/" . ADMIN_DIRECTORY . "/settings\">" . _("Home") . "</a> <span class=\"divider\">/</span></li>\n<li><a href=\"{$website}/" . ADMIN_DIRECTORY . "/users\">" . _("Users") . "</a> <span class=\"divider\">/</span></li>\n<li class=\"active\">{$first_name} {$last_name}</li>\n</ul>"; ?> <div class="tabs-left"> <ul class="nav nav-tabs" id="usermanage"> <li class="active"><a href="#general" data-toggle="tab"><i class="icon-cog"></i> <?php echo _("General"); ?> </a></li> <li><a href="#profile" data-toggle="tab"><i class="icon-user"></i> <?php echo _("Profile"); ?> </a></li> <li><a href="#logs" data-toggle="tab"><i class="icon-list-alt"></i> <?php echo _("Access Logs"); ?> </a></li> </ul> <form class="form-horizontal" method="POST" action="<?php echo $current_url; ?> "> <div class="tab-content"> <div class="tab-pane active" id="general"> <fieldset> <legend><?php echo _("General"); ?> </legend> <?php echo $err; ?> <div class="control-group"> <label class="control-label" for="first_name"><?php echo _("First Name"); ?> </label> <div class="controls"> <input type="text" class="input-xlarge" id="first_name" name="first_name" value="<?php echo $first_name; ?> "> </div> </div> <div class="control-group"> <label class="control-label" for="last_name"><?php echo _("Last Name"); ?> </label> <div class="controls"> <input type="text" class="input-xlarge" id="last_name" name="last_name" value="<?php echo $last_name; ?> "> </div> </div> <div class="control-group"> <label class="control-label" for="email"><?php echo _("Email"); ?> </label> <div class="controls"> <input type="text" class="input-xlarge disabled" id="email" name="email" value="<?php echo $email_user; ?> " disabled> </div> </div> <div class="control-group"> <label class="control-label" for="pass"><?php echo _("Password"); ?> </label> <div class="controls"> <input type="text" class="input-xlarge disabled" id="pass" name="pass" value="<?php echo $f['password']; ?> " disabled> </div> </div> <div class="control-group"> <label class="control-label" for="verified"><?php echo _("Verified"); ?> </label> <div class="controls"> <select name="verified" id="verified"> <option value="1"<?php if ($verified == 1) { echo " selected=\"selected\""; } ?> ><?php echo _("Yes"); ?> </option> <option value="0"<?php if ($verified == 0) { echo " selected=\"selected\""; } ?> ><?php echo _("No"); ?> </option> </select> </div> </div> <div class="control-group"> <label class="control-label" for="join"><?php echo _("Joined On"); ?> </label> <div class="controls"> <input type="text" class="input-xlarge disabled" id="join" name="join" value="<?php echo $joined_on; ?> " disabled> </div> </div> <div class="control-group"> <label class="control-label" for="access"><?php echo _("Last Access"); ?> </label> <div class="controls"> <input type="text" class="input-xlarge disabled" id="access" name="access" value="<?php echo $last_access; ?> " disabled> </div> </div> <div class="control-group"> <label class="control-label" for="ban"><?php echo _("Banned"); ?> </label> <div class="controls"> <select name="ban" id="ban"> <option value="1"<?php if ($banned == 1) { echo " selected=\"selected\""; } ?> ><?php echo _("Yes"); ?> </option> <option value="0"<?php if ($banned == 0) { echo " selected=\"selected\""; } ?> ><?php echo _("No"); ?> </option> </select> </div> </div> </fieldset> </div> <div class="tab-pane" id="profile"> <fieldset> <legend><?php echo _("Profile"); ?> </legend> <?php echo $err; ?> <div class="control-group"> <label class="control-label" for="bio"><?php echo _("Bio"); ?> </label> <div class="controls"> <textarea class="input-xxlarge" id="bio" name="bio" rows="8"><?php echo $user_bio; ?> </textarea> </div> </div> </fieldset> </div> <div class="tab-pane" id="logs"> <fieldset> <legend><?php echo _("Access Logs"); ?> </legend> <?php try { $q = "SELECT * FROM `access` WHERE `userid` = :userid ORDER BY `id` DESC"; $q_do = $db->prepare($q); $q_do->bindParam(':userid', $id, PDO::PARAM_INT); $q_do->execute(); $number = $db->query("SELECT FOUND_ROWS()")->fetchColumn(); } catch (PDOException $e) { $log->logError($e . " - " . basename(__FILE__)); } if (!empty($number)) { echo "<table class=\"table table-condensed\">\n\t\t\t<thead>\n\t\t\t<tr>\n\t\t\t<th>" . _("IP Address") . "</th>\n\t\t\t<th>" . _("Country") . "</th>\n\t\t\t<th>" . _("Access") . "</th>\n\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t<tbody>"; /* initializing the ip2country class for converting ip address to country. */ $ip2country = new ip2country($db); /* displaying the information in a while loop. */ while ($row = $q_do->fetch(PDO::FETCH_ASSOC)) { $ip = cleanInput($row['ip_address']); $date = cleanInput($row['datetime']); /* fetching country name for the specific ip address */ $country = $ip2country->get_country_name($ip); echo "<tr>"; echo "<td>{$ip}</td>"; echo "<td>{$country}</td>"; echo "<td><abbr class=\"micro\" title=\"{$date}\"></abbr></td>"; echo "</tr>"; } echo "</tbody>\n\t\t\t</table>"; } else { echo "<div class=\"alert\"><strong>" . _("No Access Records.") . "</strong><br/>" . _("There are no access records for this user in the database.") . "</div>"; } ?> </fieldset> </div> <div class="form-actions"> <input type="submit" class="btn btn-primary" name="edituser" value="<?php echo _("Update User"); ?> "> </div> </div> </form> </div> <?php } else { echo "<div class=\"alert alert-error\"><strong>" . _("Not Found.") . "</strong><br/>" . _("User does not exist in the database. There are no records matching the user ID specified.") . "</div>"; } }