} else {
$row = pg_fetch_assoc($rs);
$uid = $row['sec_question'];
echo json_encode(array("status" => 'SUCCESS', "ans_correct" => true));
}
die;
} elseif ($_REQUEST && isset($_REQUEST['inputPassword'])) {
if ($_REQUEST['inputConPassword'] != $_REQUEST['inputPassword']) {
echo json_encode(array("status" => "FAIL", "message" => "Password Don't Match"));
die;
}
$_REQUEST['inputPassword'] = sha1($_REQUEST['inputPassword']);
$sql = "Update wl_users set password = '******'inputPassword']}' where user_id = '{$_REQUEST['uid']}'";
$rs = $db_connection->db_query($sql);
if ($rs === false || pg_affected_rows($rs) == 0) {
echo json_encode(array("status" => "FAIL", "message" => pg_last_error($db_connection->get_pg_resource())));
die;
}
echo json_encode(array("status" => 'SUCCESS', "pass_change" => true));
die;
}
display_html_start();
echo '
</head><body>', get_header_html(), '
<h3>Create user</h3>
</div>
<div class="row" id="message"></div>
<div class="row">
<form class="form-vertical" role="form" id="myfrm">
<input type="hidden" class="form-control" id="uid" name="uid" value="" required>
<div class="row">
function get_active_changlanges()
{
$db_connection = new pg_database_class();
if (false === $db_connection->open_connection(FUNCTION_LIBRARY_POSTGRES_DB_NAME, FUNCTION_LIBRARY_POSTGRES_USER, FUNCTION_LIBRARY_POSTGRESS_PASSWORD)) {
trigger_error('Database DEAD...' . $db_connection->get_last_error_message());
exit;
}
$sql = "SELECT * from wl_challenage where end_date > 'now' order by start_date DESC";
$rs = $db_connection->db_query($sql);
if ($rs === false) {
die("bad sql" . pg_last_error($db_connection->get_pg_resource()));
}
$output = '';
while ($row = pg_fetch_assoc($rs)) {
$output .= "<option value='" . $row['id'] . "'>" . htmlspecialchars($row['name'], ENT_QUOTES) . '</option>';
}
return $output;
}
*
**************************************************************************/
require_once 'libs/common/global_inc.php';
require_once 'libs/classes/pg_database.php';
extract($_REQUEST);
$db_connection = new pg_database_class();
if (false === $db_connection->open_connection(FUNCTION_LIBRARY_POSTGRES_DB_NAME, FUNCTION_LIBRARY_POSTGRES_USER, FUNCTION_LIBRARY_POSTGRESS_PASSWORD)) {
trigger_error('Database DEAD...' . $db_connection->get_last_error_message());
exit;
}
switch (strtolower($action)) {
case 'populate_guestbook':
$sql = 'SELECT msg,date,username from guestbook order by date DESC';
$rs = $db_connection->db_query($sql);
if ($rs === false) {
die("bad sql" . pg_last_error($db_connection->get_pg_resource()));
}
$output = '';
while ($row = pg_fetch_assoc($rs)) {
$output .= '<div class="guestbook_item_container">
<div class="guestbook_userinfo">
<div>
Post by: ' . htmlspecialchars($row['username'], ENT_QUOTES) . '
</div>
<div>
Date Posted: ' . date('m-d-Y g:i:s A', strtotime($row['date'])) . '
</div>
</div>
<div syle="clear:both;"> </div>
<div class="guestbook_msg_area">
' . nl2br(htmlspecialchars($row['msg'], ENT_QUOTES)) . '
