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