/**
* function getGuideDetails returns the array of guide details of given id
* @param $id |md5()
* @return success/error
**/
function getGuideDetails($id)
{
$cols = " *,guides_tbl.type as category,guides_tbl.guide_group as subcategory";
$whr = "blocked='false' AND md5(id)='" . $id . "'";
$sql = _db()->_selectQ('guides_tbl', $cols, $whr);
$res = _dbQuery($sql);
$data = _dbFetch($res);
if (isset($data['author'])) {
$data['authorid'] = extractUserID($data['author']);
} else {
$data['authorid'] = "";
}
if (isset($data['creator'])) {
$data['creatorid'] = extractUserID($data['creator']);
} else {
$data['creatorid'] = "";
}
if ($data['authorid'] == $_SESSION['SESS_USER_ID'] || $data['creatorid'] == $_SESSION['SESS_USER_ID']) {
$data['editable'] = "true";
$data['edit_url'] = _link("guides") . "/edit/" . md5($data['id']);
} elseif (checkUserRoles("guides", "Allow Editing All Guides")) {
$data['editable'] = "true";
$data['edit_url'] = _link("guides") . "/edit/" . md5($data['id']);
} else {
$data['editable'] = "false";
}
if (checkUserRoles("guides", "Allow Editing All Guides")) {
$data['viewable'] = true;
} elseif ($data['status'] == "draft") {
if ($data['authorid'] == $_SESSION['SESS_USER_ID'] || $data['creatorid'] == $_SESSION['SESS_USER_ID']) {
$data['viewable'] = true;
} else {
$data['viewable'] = false;
}
} else {
$data['viewable'] = true;
}
return $data;
}
/**
* function getExampleDetails returns details of given example id
* @param $id
* @return example|array
**/
function getExampleDetails($id)
{
$cols = " id,api_id,eg_descs,tags,eg_php,eg_author,dtoe";
$whr = "md5(id)='" . $id . "' AND locked='true'";
$sql = _db()->_selectQ('api_examples', $cols, $whr);
$res = _dbQuery($sql);
$example = _dbFetch($res);
$eg_php = str_replace('<br>', PHP_EOL, $example['eg_php']);
$eg_php = stripslashes($eg_php);
$example['eg_php'] = $eg_php;
if (isset($example['eg_author'])) {
$example['eg_authorid'] = extractUserID($example['eg_author']);
} else {
$example['eg_authorid'] = "";
}
if ($example['eg_authorid'] == $_SESSION['SESS_USER_ID']) {
$example['editable'] = 'true';
} else {
$example['editable'] = 'false';
}
return $example;
}
