/** * Basic insert * * @access public * @since unknown * @param array $values * @return boolean */ function insert($values) { if (!$this->checkFieldKeys(array_keys($values))) { return false; } $this->dao->from($this->getTableName()); $this->dao->set($values); return $this->dao->insert(); }
$aAlerts = Alerts::newInstance()->findByType('DAILY'); foreach ($aAlerts as $daily) { convertAlert($daily); } unset($aAlerts); $aAlerts = Alerts::newInstance()->findByType('WEEKLY'); foreach ($aAlerts as $weekly) { convertAlert($weekly); } unset($aAlerts); // UPDATE COUNTRY PROCESS (remove fk_c_locale) $comm->query("CREATE TABLE " . DB_TABLE_PREFIX . "t_country_aux (\n pk_c_code CHAR(2) NOT NULL,\n s_name VARCHAR(80) NOT NULL,\n\n PRIMARY KEY (pk_c_code),\n INDEX idx_s_name (s_name)\n) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';"); $rs = $comm->query("SELECT * FROM " . DB_TABLE_PREFIX . "t_country GROUP BY pk_c_code"); $countries = $rs->result(); foreach ($countries as $c) { $comm->insert(DB_TABLE_PREFIX . "t_country_aux", array('pk_c_code' => $c['pk_c_code'], 's_name' => $c['s_name'])); } $rs = $comm->query("SHOW CREATE TABLE " . DB_TABLE_PREFIX . "t_city"); $rs = $rs->result(); foreach ($rs[0] as $r) { if (preg_match_all('|CONSTRAINT `([^`]+)` FOREIGN KEY \\(`fk_c_country_code`\\) REFERENCES `' . DB_TABLE_PREFIX . 't_country` \\(`pk_c_code`\\)|', $r, $matches)) { foreach ($matches[1] as $m) { $comm->query("ALTER TABLE `" . DB_TABLE_PREFIX . "t_city` DROP FOREIGN KEY `" . $m . "`"); } } } $rs = $comm->query("SHOW CREATE TABLE " . DB_TABLE_PREFIX . "t_region"); $rs = $rs->result(); foreach ($rs[0] as $r) { if (preg_match_all('|CONSTRAINT `([^`]+)` FOREIGN KEY \\(`fk_c_country_code`\\) REFERENCES `' . DB_TABLE_PREFIX . 't_country` \\(`pk_c_code`\\)|', $r, $matches)) { foreach ($matches[1] as $m) {
function seo_edited_item($item) { $itemID = $item['pk_i_id']; $item_meta_title = Params::getParam('seo_item_meta_title'); $item_meta_title_format = json_encode(Params::getParam('seo_item_meta_title_format')); $item_meta_description = Params::getParam('seo_item_meta_description'); $item_meta_keywords = Params::getParam('seo_item_meta_keywords'); $conn = DBConnectionClass::newInstance(); $c_db = $conn->getOsclassDb(); $comm = new DBCommandClass($c_db); $values = array('fk_i_item_id' => $itemID, 'seo_item_meta_title' => $item_meta_title, 'seo_item_meta_title_format' => $item_meta_title_format, 'seo_item_meta_description' => $item_meta_description, 'seo_item_meta_keywords' => $item_meta_keywords); $run = $comm->replace(SEO_PLUGIN_ITEM_META_TABLE, $values); if ($run == false) { $comm->insert(SEO_PLUGIN_ITEM_META_TABLE, $values); } }
function youtube_form_post($item) { $catID = $item['fk_i_category_id']; $itemID = $item['pk_i_id']; $youtube_video = Params::getParam('s_youtube'); $youtube_id = youtube_get_code_from_url($youtube_video); $youtube_video = convert_youtube_url($youtube_video); if (empty($youtube_video)) { return false; } $conn = DBConnectionClass::newInstance(); $c_db = $conn->getOsclassDb(); $comm = new DBCommandClass($c_db); $values = array('fk_i_item_id' => $itemID, 's_youtube' => $youtube_video, 's_id' => $youtube_id); $comm->insert(YOUTUBE_TABLE, $values); }