public static function getPortfolioWithId($pid) { if (!$pid) { return null; } global $wpdb; $portfolio = null; $query = @$wpdb->prepare("SELECT * FROM " . CRP_TABLE_PORTFOLIOS . " WHERE id='{$pid}'"); $res = $wpdb->get_results($query, OBJECT); if (count($res)) { $portfolio = $res[0]; $query = @$wpdb->prepare("SELECT * FROM " . CRP_TABLE_PROJECTS . " WHERE pid='{$pid}'"); $res = $wpdb->get_results($query, OBJECT); $projects = array(); foreach ($res as $project) { $project->pics = explode(',', $project->pics); $project->categories = explode(',', $project->categories); $projects[$project->id] = $project; } $portfolio->projects = $projects; $portfolio->corder = explode(',', $portfolio->corder); if ($portfolio->options && !empty($portfolio->options)) { $portfolio->options = json_decode(base64_decode($portfolio->options), true); } else { $portfolio->options = json_decode(base64_decode(CRPHelper::getPortfolioDefaultOptions()), true); } } return $portfolio; }
private function initializeTables() { global $wpdb; //Insert demo portfolio $wpdb->insert($this->tablePortfolios, array('title' => '', 'corder' => '', 'options' => CRPHelper::getPortfolioDefaultOptions())); $pid = $wpdb->insert_id; //Add demo project $wpdb->insert($this->tableProjects, array('pid' => $pid, 'title' => '', 'description' => "")); }