/** * Adds banner into DB * * @param PluginBanneroid_ModuleBanner_EntityBanner $oBanner * @return boolean */ public function AddBanner(PluginBanneroid_ModuleBanner_EntityBanner $oBanner) { $sql = "INSERT INTO " . Config::Get('db.table.banneroid.banner') . "\r\n (?#)\r\n\t\tVALUES\r\n (?a)\r\n\t\t"; $aData['banner_name'] = $oBanner->getName(); $aData['banner_html'] = $oBanner->getBannerHtml(); $aData['banner_url'] = $oBanner->getBannerUrl(); $aData['banner_image'] = $oBanner->getBannerImage(); $aData['banner_start_date'] = $oBanner->getBannerStartDate(); $aData['banner_end_date'] = $oBanner->getBannerEndDate(); $aData['banner_is_active'] = $oBanner->getBannerIsActive(); $aData['banner_type'] = $oBanner->getBannerType(); $aData['banner_add_date'] = date("Y-m-d H:i:s"); $aData['banner_edit_date'] = date("Y-m-d H:i:s"); return $this->oDb->query($sql, array_keys($aData), array_values($aData)); }