function get_record($table_name, $var_name, $reqd_admin_level = 0, $must_be_logged_id = false)
{
global $registry;
// start fresh
$this->data = array();
$this->data['status'] = AJAX_NO_ERROR;
$this->data['message'] = '';
if (isset($this->record) == true) {
unset($this->record);
}
$mgr = new v6_manager();
$mgr->UserIsLoggedIn(false);
if (isset($must_be_logged_id) && $must_be_logged_id == true && $mgr->IsLoggedIn == false) {
$this->data['status'] = AJAX_ACCESS_DENIED;
$this->data['message'] = 'Access Denied (AGR-1)';
return $this->data['status'];
}
if ($reqd_admin_level == 2 && $mgr->is_almighty == false) {
$this->data['status'] = AJAX_ACCESS_DENIED;
$this->data['message'] = 'Access Denied (AGR-2)';
return $this->data['status'];
}
if ($reqd_admin_level == 1 && ($mgr->is_almighty == false && $mgr->is_admin == false)) {
$this->data['status'] = AJAX_ACCESS_DENIED;
$this->data['message'] = 'Access Denied (AGR-3)';
return $this->data['status'];
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$this->data['status'] = AJAX_ACCESS_DENIED;
$this->data['message'] = 'Access Denied (AGR-4)';
return $this->data['status'];
}
$registry->helper->load('v6_validator');
$validator = new v6_validator($_GET);
// make sure the querystring is a valid number...
$validator->CheckNumber($var_name, 'Id', 0, 999999);
$message = $validator->message;
if (empty($message) == false) {
$this->data['status'] = AJAX_VALIDATION_FAILURE;
$this->data['message'] = $message;
return $this->data['status'];
}
$this->record = new v6_table($table_name);
$this->record->load_by_id($_GET[$var_name]);
$this->data['status'] = AJAX_RECORD_DATA;
$this->data['message'] = 'Record Data';
return $this->data['status'];
}
/**
* perform the actual read from the database and populate this instance of the list. select statement MUST have a
* field called "id" as a column name in the result set!
* @param $sql select statement to grab rows from the database
*/
function read_from_db($sql)
{
global $registry;
$this->the_list = array();
// start fresh with an empty list
try {
foreach ($registry->db->query($sql) as $row) {
$tbl = new v6_table($this->table_name);
$tbl->load_by_id($row['id']);
$this->the_list[] = $tbl;
}
} catch (PDOException $e) {
/**
* @todo clean up error catch exposure
*/
echo $e->getMessage() . '<br>' . $sql . '<br><hr>';
}
}