Модернизируем баннеролисталку

if ($opt == 'submit'){
 
			if (!empty($_REQUEST['title'])) { $title = $_REQUEST['title']; } else { error("Укажите название баннера!"); }
			$link = $_REQUEST['link'];
 
			$typeimg = $_REQUEST['typeimg'];
			$maxhits = $_REQUEST['maxhits'];
			$maxuser = 0;
 
			$published = $_REQUEST['published'];
 
			$position = $_REQUEST['position'];

$maxday =  date('Y-m-d H-i',mktime(23, 59, 59, date('m'), date('d')+$_REQUEST['maxday'], date('Y')));
 
			$html = $_REQUEST['html'];

if ($opt == 'update'){
		if(isset($_REQUEST['item_id'])) {
			$id = $_REQUEST['item_id'];
 
			if (!empty($_REQUEST['title'])) { $title = $_REQUEST['title']; } else { error("Укажите название баннера!"); }
			$link = $_REQUEST['link'];
 
			$typeimg = $_REQUEST['typeimg'];
			$maxhits = $_REQUEST['maxhits'];
			$maxuser = 0;
 
			$published = $_REQUEST['published'];
 
			$position = $_REQUEST['position'];

$maxday =  date('Y-m-d H-i',mktime(23, 59, 59, date('m'), date('d')+$_REQUEST['maxday'], date('Y')));
 
			$html = $_REQUEST['html'];

$sql = "UPDATE cms_banners
					SET position = '$position',
						title = '$title',
						published = '$published',
						maxhits = '$maxhits',
						maxuser = '$maxuser',
						typeimg = '$typeimg',
						link = '$link'
					WHERE id = '$id'";

$sql = "UPDATE cms_banners
					SET position = '$position',
						title = '$title',
						published = '$published',
						maxhits = '$maxhits',
						maxuser = '$maxuser',
						typeimg = '$typeimg',
						link = '$link',
						maxday = '$maxday',
						html = '$html'
					WHERE id = '$id'";

 <td><strong>Ссылка баннера: </strong><br />
						<span class="hinttext">Не забывайте "http://" для внешних ссылок!</span>					</td>
				    <td><input name="link" type="text" id="link" size="45" value="<?php echo @$mod['link'];?>"/></td>
 

 <td><strong>Тип баннера: </strong></td>
				    <td><select name="typeimg" id="typeimg" onchange="chantype(this.value);">
                      <option value="image" <?php if(@$mod['typeimg']=='image') { echo 'selected'; } ?>>Изображение (gif, jpg)</option>
                      <option value="swf" <?php if(@$mod['typeimg']=='swf') { echo 'selected'; } ?>>Flash (swf) (468x60)</option>
                      <option value="html" <?php if(@$mod['typeimg']=='html') { echo 'selected'; } ?>>HTML текст</option>
                      <option value="code" <?php if(@$mod['typeimg']=='code') { echo 'selected'; } ?>>Баннер-код</option>
                    </select></td>
 
                    <script type="text/javascript">
 
					function chantype (type) {
						if (type=='image'||type=='swf')
						{
							htmlval = $('#html').val();
							$('#html').attr('disabled','disabled').val('');
							$('#link').attr('disabled','').val(linkval);
							$('#picture').attr('disabled','').val();
						} else {
							linkval = $('#link').val();
							$('#link').attr('disabled','disabled').val('');
							$('#picture').attr('disabled','disabled').val('');
							$('#html').attr('disabled','').val(htmlval);
						};
					}
                    </script>
 
 
 

 <td><strong>Тип баннера: </strong></td>
				    <td><select name="typeimg" id="typeimg">
                      <option value="image" <?php if(@$mod['typeimg']=='image') { echo 'selected'; } ?>>Изображение (gif, jpg)</option>
                      <option value="swf">Flash (swf) (468x60)</option>
                    </select></td>

 <td><strong>Ссылка баннера: </strong><br />
						<span class=" <td><strong>hinttext">Не забывайте "http://" для внешних ссылок!</span>					</td>
				    <td><input name="link" type="text" id="link" size="45" value="<?php echo @$mod['link'];?>" <? if(@$mod['typeimg']=='html'||@$mod['typeimg']=='code') { echo 'disabled="disabled"'; } ?>/></td>

 <td><strong>Максимум показов: </strong><br />
						<span class="hinttext">Установите "0" для бесконечного количества</span>					</td>
				    <td><input name="maxhits" type="text" id="maxhits" size="5" value="<?php echo @$mod['maxhits'];?>"/>  раз.</td>

 <td><strong>HTML код: </strong><br />
						<span class="hinttext">Впишите свой код или код баннерной сети</span>					</td>
				    <td><textarea name="html" id="html" cols="30" rows="4" <?php if(@$mod['typeimg']=='html'||@$mod['typeimg']=='code') { echo ' '; } else { echo 'disabled="disabled"'; } ?>><?php echo @$mod['html'];?></textarea></td>
			      </tr>
				  <tr>

  <td><strong>Максимум показов: </strong><br />
						<span class="hinttext">Установите "0" для бесконечного количества</span>					</td>
				    <td><input name="maxhits" type="text" id="maxhits" size="5" value="<?php echo @$mod['maxhits'];?>"/>  раз.</td>
			      </tr>
				  <tr>

<td><strong>Дней показов: </strong><br />
						<span class="hinttext">Установите "0" для бесконечного количества</span>					</td>
				    <td><input name="maxday" type="text" id="maxday" size="5" value="<?php
					@$days = abs(gregorianToJD(date('m',strtotime(@$mod['maxday'])), date('d',strtotime(@$mod['maxday'])), date( 'Y',strtotime(@$mod['maxday']))) - gregorianToJD(date('m'), date('d'), date( 'Y')));
					echo @$days;?>"/>  дней.</td>
			      </tr>
				  <tr>

 /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    /**
     * Возвращает код баннера с минимальный количеством показов для указанной позиции
     * @param string $position
     * @return html
     */
    public function getBanner($position){
        $inDB = cmsDatabase::getInstance();
        $html = '';
 
        //get active banners with enough hits
        // Текущяя дата и время
		$nowdate = date('Y-m-d H-i');
        $sql = "SELECT *
                FROM cms_banners
                WHERE position = '$position' AND published = 1 AND ((maxday > '$nowdate') OR (maxday = '0000-00-00 00:00')) AND ((maxhits > hits) OR (maxhits = 0))
                ORDER BY hits ASC
                LIMIT 1";
        $rs = $inDB->query($sql);
 
        if (mysql_num_rows($rs)==1){
            $banner = mysql_fetch_assoc($rs);
            if ($banner['typeimg']=='image'){
                $html = '<a href="/gobanner'.$banner['id'].'" title="'.$banner['title'].'" target="_blank"><img src="/images/banners/'.$banner['fileurl'].'"  alt="'.$banner['title'].'"/></a>';
            }
            if ($banner['typeimg']=='swf'){
                $html = '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="468" height="60">'."\n".
                            '<param name="movie" value="/images/banners/'.$banner['fileurl'].'?banner_id='.$banner['id'].'" />'."\n".
                            '<param name="quality" value="high" />'."\n".
                            '<param name="FlashVars" value="banner_id='.$banner['id'].'" />'."\n".
                            '<embed src="/images/banners/'.$banner['fileurl'].'?banner_id='.$banner['id'].'" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="468" height="60">'."\n".
                            '</embed>'."\n".
                        '</object>';
            }
			if ($banner['typeimg']=='html'||$banner['typeimg']=='code'){
                $html = '<div id="bannerclick" onmouseover="banclk();" rel="'.$banner['id'].'">'.$banner['html'].'</div>';
            }
            if ($html) { $inDB->query("UPDATE cms_banners SET hits = hits + 1 WHERE id=".$banner['id']);	}
        }
        return $html;
    }
 
    /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    /**
     * Возвращает код баннера по ID
     * @param int $id
     * @return html
     */
    public function getBannerById($id){
        $inDB = cmsDatabase::getInstance();
        $html = '';
 
        $sql = "SELECT *
                FROM cms_banners
                WHERE id = $id
                LIMIT 1";
        $rs = $inDB->query($sql);
 
        if (mysql_num_rows($rs)==1){
            $banner = mysql_fetch_assoc($rs);
            if ($banner['typeimg']=='image'){
                $html = '<a href="/gobanner'.$banner['id'].'" title="'.$banner['title'].'"><img src="/images/banners/'.$banner['fileurl'].'"  alt="'.$banner['title'].'"/></a>';
            }
            if ($banner['typeimg']=='swf'){
                $html = '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="468" height="60">'."\n".
                            '<param name="movie" value="/images/banners/'.$banner['fileurl'].'?banner_id='.$banner['id'].'" />'."\n".
                            '<param name="quality" value="high" />'."\n".
                            '<param name="FlashVars" value="banner_id='.$banner['id'].'" />'."\n".
                            '<embed src="/images/banners/'.$banner['fileurl'].'?banner_id='.$banner['id'].'" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="468" height="60">'."\n".
                            '</embed>'."\n".
                        '</object>';
            }
			if ($banner['typeimg']=='html'||$banner['typeimg']=='code'){
                $html = $banner['html'];
            }
        }
        return $html;
    }
 
    /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

oneclc = 0;
function banclk() {
	$('#bannerclick	> *').click( function() {
          if (oneclc==0)
          {
          var id = $('#bannerclick').attr('rel');
 
          $.get('/modules/banner/banner.php',{ id:id });
          };
          oneclc = 1;
          });
}

ALTER TABLE `cms_banners` ADD `maxday` DATETIME NOT NULL ,
ADD `html` TEXT NOT NULL ;