public static function get($query, $get = 'all', $outputType = ARRAY_A) { global $wpdb; $get = strtolower($get); $res = NULL; $query = self::prepareQuery($query); self::$query = $query; switch ($get) { case 'one': $res = $wpdb->get_var($query); break; case 'row': $res = $wpdb->get_row($query, $outputType); break; case 'col': $res = $wpdb->get_col($query); break; case 'all': default: $res = $wpdb->get_results($query, $outputType); break; } return $res; }
/** * Create pages for plugin usage */ public static function createPages() { global $wpdb; $wpPrefix = $wpdb->prefix; /* add to 0.0.3 Versiom */ // for now return; $defaultPagesData = array(); $toePages = @json_decode(get_option($wpPrefix . 'pagesCsp')); if (empty($toePages) || !is_array($toePages)) { $toePages = array(); foreach ($defaultPagesData as $p) { $pageData = $p; if (isset($p['parentTitle']) && ($parentPage = self::_getPageByTitle($p['parentTitle'], $toePages))) { $pageData['page_id'] = self::_addPageToWP($p['title'], $parentPage->page_id); } else { $pageData['page_id'] = self::_addPageToWP($p['title']); } $toePages[] = (object) $pageData; } } else { $existsTitles = array(); foreach ($toePages as $i => $p) { if (!isset($p->page_id)) { continue; } $existsTitles[] = $p->title; $page = get_page($p->page_id); if (empty($page)) { if (isset($p->parentTitle) && ($parentPage = self::_getPageByTitle($p->parentTitle, $toePages))) { $toePages[$i]->page_id = self::_addPageToWP($p->title, $parentPage->page_id); } else { $toePages[$i]->page_id = self::_addPageToWP($p->title); } } } // Create new added after update pages if (count($existsTitles) != count($defaultPagesData)) { foreach ($defaultPagesData as $p) { if (!in_array($p['title'], $existsTitles)) { $pageData = $p; if (isset($p['parentTitle']) && ($parentPage = self::_getPageByTitle($p['parentTitle'], $toePages))) { $pageData['page_id'] = self::_addPageToWP($p['title'], $parentPage['page_id']); } else { $pageData['page_id'] = self::_addPageToWP($p['title']); } $toePages[] = (object) $pageData; } } } } dbCsp::query("UPDATE `" . $wpPrefix . CSP_DB_PREF . "modules` SET params = '" . json_encode($toePages) . "' WHERE code = 'pagesCsp' LIMIT 1"); update_option($wpPrefix . 'pagesCsp', json_encode($toePages)); }
public static function update_027() { dbCsp::query("INSERT INTO `@__modules_type` VALUES (8,'subscribe');"); dbCsp::query("INSERT INTO `@__options` (`id`,`code`,`value`,`label`,`description`,`htmltype_id`,`params`,`cat_id`,`sort_order`) VALUES \n\t\t\t\t\t(NULL,'sub_synchronize_system','','Choose synchronize system','Choose synchronize system',1,'',2,0);"); }
public function changeStatus($d = array()) { $d['id'] = isset($d['id']) ? (int) $d['id'] : 0; if ($d['id']) { if (dbCsp::query('UPDATE @__subscribers SET active = IF(active, 0, 1) WHERE id = "' . $d['id'] . '"')) { return true; } else { $this->pushError(langCsp::_('Database error were occured')); } return true; } else { $this->pushError(langCsp::_('Invalid ID')); } return false; }
public function getLastInsertID() { return dbCsp::get('SELECT MAX(' . $this->_id . ') FROM ' . $this->_table, 'one'); }