не подскажешь как в page_header.tpl скрыть рекламу для VIP пользователей?если в viewtopic.tpl то можно так
HTML:<!-- IF postrow.VIP --> <!-- ELSE --> код рекламы <!-- ENDIF -->
Notice: Undefined index: vip_ballance in Z:\home\test1.ru\www\viewtopic.php on line 947
Notice: Undefined index: vip_tarif in Z:\home\test1.ru\www\viewtopic.php on line 949
Notice: Undefined index: vip_ballance in Z:\home\test1.ru\www\viewtopic.php on line 947
Notice: Undefined index: vip_tarif in Z:\home\test1.ru\www\viewtopic.php on line 949
Notice: Undefined index: vip_ballance in Z:\home\test1.ru\www\viewtopic.php on line 947
Notice: Undefined index: vip_tarif in Z:\home\test1.ru\www\viewtopic.php on line 949
Notice: Undefined index: vip_ballance in Z:\home\test1.ru\www\viewtopic.php on line 947
Notice: Undefined index: vip_tarif in Z:\home\test1.ru\www\viewtopic.php on line 949
Notice: Undefined index: vip_ballance in Z:\home\test1.ru\www\viewtopic.php on line 947
Notice: Undefined index: vip_tarif in Z:\home\test1.ru\www\viewtopic.php on line 949
Notice: Undefined index: vip_ballance in Z:\home\test1.ru\www\viewtopic.php on line 947
Notice: Undefined index: vip_tarif in Z:\home\test1.ru\www\viewtopic.php on line 949
if ($postrow[$i]['vip_ballance'] >= 0 )
{
if ($postrow[$i]['vip_tarif'] > 0 )
запросы не ?
CREATE TABLE IF NOT EXISTS `bb_vip_tarif` (
`vip_tar_id` int(10) unsigned NOT NULL auto_increment,
`vip_tar_name` varchar(120) NOT NULL,
`vip_tar_time` int(11) NOT NULL,
`vip_tar_price` int(11) NOT NULL,
PRIMARY KEY (`vip_tar_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=6 ;
INSERT INTO `bb_vip_tarif` (`vip_tar_id`, `vip_tar_name`, `vip_tar_time`, `vip_tar_price`) VALUES
(1, 'Lite', 2592000, 10),
(2, 'Medium', 5184000, 22),
(3, 'Mega', 15552000, 50);
ALTER TABLE `bb_users` ADD `vip_tarif` MEDIUMINT NOT NULL DEFAULT '0',
ADD `vip_ballance` FLOAT NOT NULL DEFAULT '0',
ADD `vip_start_date` INT NOT NULL DEFAULT '0',
ADD `vip_end_date` INT NOT NULL DEFAULT '0',
ADD `vip_lock` TINYINT NOT NULL DEFAULT '0'