} 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)) . '