/** * 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; }