0 && $_REQUEST['action'] == "delete" ) { db_res( "DELETE FROM `sys_banners` WHERE ID = '{$iBannerID}'" ); } $sManageBannersBlock = getManageBannersBlock(); $sExistedBannersBlock = getExistedBannersBlock(); $sPreviewBlock = getPreviewBlock($iBannerID); bx_import('BxTemplFormView'); $iNameIndex = 14; $_page = array( 'name_index' => $iNameIndex, 'css_name' => array('forms_adv.css', /*'plugins/jquery/themes/|ui.datepicker.css',*/ 'plugins/jquery/themes/|calendar-blue.css'), 'js_name' => array(/*'ui.datepicker.js',*/ 'jquery.dynDateTime.js', 'plugins/jquery/langs/|calendar-en.js'), 'header' => _t('_adm_bann_title'), 'header_text' => _t('_adm_bann_title') ); $_page_cont[$iNameIndex]['page_main_code'] = $sPreviewBlock . $sExistedBannersBlock . $sManageBannersBlock; PageCodeAdmin(); // Functions function getPreviewBlock($iBannerID) { $sPreview = MsgBox(_t('_Empty')); if ($_GET['action'] == 'preview' && $iBannerID > 0) { $aBannerInfo = db_arr("SELECT * FROM `sys_banners` WHERE `ID` = '{$iBannerID}'"); $sBannerTitle = process_line_output($aBannerInfo['Title']); $sBannerPut = banner_put($aBannerInfo['ID'], 0); $sPreview = << {$sBannerTitle} {$sBannerPut} EOF; $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('design_box_content.html', array('content' => $sPreview)); return DesignBoxContent(_t('_Preview'), $sResult, 1); } } function getExistedBannersBlock() { $sClicksC = _t('_adm_bann_clicks'); $sImpressionsC = _t('_adm_bann_impressions'); $sPreviewC = _t('_Preview'); $sEditC = _t('_Edit'); $sDeleteC = _t('_Delete'); // Get banner info from database. $banners_res = db_res("SELECT * FROM `sys_banners` ORDER BY `ID` DESC"); $sExistedBanners = MsgBox(_t('_Empty')); if ( mysql_num_rows( $banners_res ) ) { $sExistedBanners = ""; while ( $banns_arr = mysql_fetch_array( $banners_res ) ) { $imp = db_arr("SELECT COUNT(*) FROM `sys_banners_shows` WHERE `ID` = '{$banns_arr['ID']}'"); $clicks = db_arr("SELECT COUNT(*) FROM `sys_banners_clicks` WHERE `ID` = '{$banns_arr['ID']}'"); $class = ( !$banns_arr['Active'] ) ? 'table_err' : 'panel'; $sBannerTitle = process_line_output($banns_arr['Title']); $sExistedBanners .= << EOF; } $sExistedBanners .= "

({$sPreviewC} | {$sEditC} | {$sDeleteC})  {$sBannerTitle}

{$clicks[0]} {$sClicksC}

{$imp[0]} {$sImpressionsC}

"; } $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('design_box_content.html', array('content' => $sExistedBanners)); return DesignBoxContent(_t('_adm_mmi_banners'), $sResult, 1); } function getManageBannersBlock() { $sAsNew = _t('_adm_bann_Insert_as_new'); $sErrorC = _t('_Error Occured'); $sApplyChangesC = _t('_Submit'); $sTopC = _t('_Top'); $sLeftC = _t('_adm_bann_Left'); $sRightC = _t('_adm_bann_Right'); $sBottomC = _t('_Bottom'); $sHShiftC = _t('_adm_bann_HShift'); $sVShiftC = _t('_adm_bann_VShift'); $sTitleC = _t('_Title'); $sUrlC = _t('_URL'); $sActiveC = _t('_Active'); $sTextC = _t('_Text'); $sStartDateC = _t('_Start date'); $sEndDateC = _t('_Expiration date'); $sDefaultC = _t('_adm_bann_default'); $sPositionOnPageC = _t('_adm_bann_Position_on_the_page'); // get start & end dates $start_date_default = "2008-01-01 00:00:00"; $end_date_default = "2015-01-01 00:00:00"; $start_date = $_REQUEST['start_date'] ? $_REQUEST['start_date'] : $start_date_default; $end_date = $_REQUEST['end_date'] ? $_REQUEST['end_date'] : $end_date_default; $Title = $Url = $Active = $Text = $Position = $lhshift = $lvshift = $rhshift = $rvshift = ''; $iBannerID = (int)$_GET['banner_id']; $action = "new"; if ($iBannerID > 0 && ! strlen($_GET['action'])) { //banner edit $banns_arr = db_arr("SELECT * FROM `sys_banners` WHERE `ID`='{$iBannerID}'"); $action = "modify"; $Title = $banns_arr['Title']; $Url = $banns_arr['Url']; $Text = $banns_arr['Text']; $Active = $banns_arr['Active']; $Position = $banns_arr['Position']; $lhshift = $banns_arr['lhshift']; $lvshift = $banns_arr['lvshift']; $rhshift = $banns_arr['rhshift']; $rvshift = $banns_arr['rvshift']; list($iYearStart, $iMonthStart, $iDayStart) = explode( '-', $banns_arr['campaign_start']); //$start_date = "{$iDayStart}/{$iMonthStart}/{$iYearStart}"; $start_date = "{$iYearStart}-{$iMonthStart}-{$iDayStart} 00:00:00"; list($iYearEnd, $iMonthEnd, $iDayEnd) = explode( '-', $banns_arr['campaign_end']); //$end_date = "{$iDayEnd}/{$iMonthEnd}/{$iYearEnd}"; $end_date = "{$iYearEnd}-{$iMonthEnd}-{$iDayEnd} 00:00:00"; } $sFormTitle = htmlspecialchars($Title); $sFormUrl = htmlspecialchars($Url); $sFormActiveState = ($Active) ? 'checked="checked"' : ''; $sFormActiveStateVal = ($Active) ? 'yes' : ''; $sFormActiveStateChk = ($Active) ? true : false; $sFormBannerText = $Text; $sFormStartDate = $start_date; $sFormStartDateDef = $start_date_default; $sFormEndDate = $end_date; $sFormEndDateDef = $end_date_default; $sTopPosState = (substr_count($Position,"1") > 0 ) ? 'checked="checked"' : ''; $sLeftPosState = (substr_count($Position,"2") > 0 ) ? 'checked="checked"' : ''; $sRightPosState = (substr_count($Position,"3") > 0 ) ? 'checked="checked"' : ''; $sBottomPosState = (substr_count($Position,"4") > 0 ) ? 'checked="checked"' : ''; $sTopShift = (substr_count($Position,"2") > 0 ) ? $lhshift : ''; $sLeftShift = (substr_count($Position,"2") > 0 ) ? $lvshift : ''; $sRightShift = (substr_count($Position,"3") > 0 ) ? $rhshift : ''; $sBottomShift = (substr_count($Position,"3") > 0 ) ? $rvshift : ''; $sActionAdd = ($action == "modify") ? $sAsNew . ' ' : ''; $sCustomPositions = << {$sTopC} {$sLeftC}   {$sRightC} {$sHShiftC} {$sVShiftC}   {$sHShiftC} {$sVShiftC}   {$sBottomC} {$sActionAdd} EOF; $aForm = array( 'form_attrs' => array( 'name' => 'apply_ip_list_form', 'action' => $_SERVER['PHP_SELF'], 'method' => 'post', ), 'params' => array ( 'db' => array( 'table' => 'sys_banners', 'key' => 'ID', 'submit_name' => 'add_button', ), ), 'inputs' => array( 'BannerTitle' => array( 'type' => 'text', 'name' => 'Title', 'value' => $sFormTitle, 'caption' => $sTitleC, 'required' => true, 'checker' => array ( 'func' => 'length', 'params' => array(2,128), 'error' => _t('_chars_to_chars', 2, 128), ), 'db' => array ( 'pass' => 'Xss', ), ), 'BannerUrl' => array( 'type' => 'text', 'name' => 'Url', 'value' => $sFormUrl, 'caption' => $sUrlC, 'required' => false, 'db' => array ( 'pass' => 'Xss', ), ), 'BannerActive' => array( 'type' => 'checkbox', 'name' => 'Active', 'caption' => $sActiveC, 'value' => $sFormActiveStateVal, 'checked' => $sFormActiveStateChk, ), 'BannerText' => array( 'type' => 'textarea', 'name' => 'Text', 'value' => $sFormBannerText, 'caption' => $sTextC, 'required' => true, 'checker' => array ( 'func' => 'length', 'params' => array(10,32000), 'error' => _t('_chars_to_chars', 10, 32000), ), 'db' => array ( 'pass' => 'All', ), ), 'StartDate' => array( 'type' => 'datetime', 'name' => 'start_date', 'value' => $sFormStartDate, 'caption' => $sStartDateC, 'label' => "{$sDefaultC}: {$sFormStartDateDef}", 'required' => true, 'checker' => array ( 'func' => 'DateTime', 'error' => $sErrorC, ), 'display' => 'filterDate', ), 'EndDate' => array( 'type' => 'datetime', 'name' => 'end_date', 'value' => $sFormEndDate, 'caption' => $sEndDateC, 'label' => "{$sDefaultC}: {$sFormEndDateDef}", 'required' => true, 'checker' => array ( 'func' => 'DateTime', 'error' => $sErrorC, ), 'display' => 'filterDate', ), 'Positions' => array( 'type' => 'custom', 'name' => 'Position', 'caption' => $sPositionOnPageC, 'content' => $sCustomPositions ), 'ID' => array( 'type' => 'hidden', 'name' => 'banner_id', 'value' => $iBannerID, ), 'Action' => array( 'type' => 'hidden', 'name' => 'action', 'value' => $action, ), 'add_button' => array( 'type' => 'submit', 'name' => 'add_button', 'value' => $sApplyChangesC, ), ), ); $sResult = ''; $oForm = new BxTemplFormView($aForm); $oForm->initChecker(); if ($oForm->isSubmittedAndValid()) { list($iYearStart, $iMonthStart, $iDayStart) = explode( '-', $_REQUEST['start_date']); $sDateStart = "{$iYearStart}-{$iMonthStart}-{$iDayStart}"; list($iYearEnd, $iMonthEnd, $iDayEnd) = explode( '-', $_REQUEST['end_date']); $sDateEnd = "{$iYearEnd}-{$iMonthEnd}-{$iDayEnd}"; $sCurTime = date("Y-m-d");// 2010-12-31 $iLastId = (int)$_REQUEST['banner_id']; $banner_pos = ""; if ( $_REQUEST['pos_top'] == "on" ) $banner_pos .= '1'; if ( $_REQUEST['pos_left'] == "on" ) $banner_pos .= '2'; if ( $_REQUEST['pos_right'] == "on" ) $banner_pos .= '3'; if ( $_REQUEST['pos_bottom'] == "on" ) $banner_pos .= '4'; $banner_pos = (int)$banner_pos; $banner_active = (isset($_REQUEST['Active'])) ? 1 : 0 ; $banner_lhshift = (int)$_REQUEST['lhshift']; $banner_lvshift = (int)$_REQUEST['lvshift']; $banner_rhshift = (int)$_REQUEST['rhshift']; $banner_rvshift = (int)$_REQUEST['rvshift']; $aValsAdd = array ( 'Position' => $banner_pos, 'Active' => $banner_active, 'Created' => $sCurTime, 'campaign_start' => $sDateStart, 'campaign_end' => $sDateEnd, 'lhshift' => $banner_lhshift, 'lvshift' => $banner_lvshift, 'rhshift' => $banner_rhshift, 'rvshift' => $banner_rvshift, ); if ( $_REQUEST['action'] == 'modify' && $_REQUEST['as_new'] != "on" && $iLastId > 0 ) { $oForm->update($iLastId, $aValsAdd); } if ( $_REQUEST['action'] == 'new' || $_REQUEST['as_new'] == "on" && $_REQUEST['action'] == 'modify' ) { $iLastId = $oForm->insert($aValsAdd); } $sResult = ($iLastId > 0) ? MsgBox(_t('_Success'), 3) : MsgBox($sErrorC); } return DesignBoxContent(_t('_adm_bann_title'), $sResult . $oForm->getCode(), 1); } ?>