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');
}
