ads.sql

学生选课系统 赶快来下载啊啊好东西 呵呵啊啊 啊啊啊啊啊

INSERT INTO `ef_ads_position` VALUES ('Index_ButtomPopup','首页底部Popup广告','71'),('Index_Float','首页浮动广告','51'),('Index_FloatScrollLeft','首页对联广告左侧','61'),('Index_FloatScrollRight','首页对联广告右侧','61'),('Page_Banner','页面顶端Banner广告','1'),('Page_Header','页面头部位置横幅广告','1,2,3'),('Page_HeaderHalf','页面头部位置横幅广告_半截','1,2,3'),('Page_HeadTop','页面置顶广告','41'),('Page_NewWin','弹出窗口广告','31'),('Post_ContentRight','帖子内容右侧','1'),('Post_ListCenter','帖子楼层中间的广告','1'),('Post_SignedBottom','个人签名下面广告','1,2,3'),('Index_PicsRotate','首页多图轮换广告','1')
;
INSERT INTO `ef_ads_showtype` VALUES ('1','定位广告（非绝对定位）','10,20,30,40,60,70,80','定位广告，在具体页面的具体位置上的广告'),('2','垂直翻滚广告','10,20,30','显示类型2'),('3','水平翻滚广告','20,30','显示类型3'),('31','自动弹出窗口广告','10,20,30,40,50','广告展现以弹出窗口的方式来进行展现'),('41','置顶','40,90','置顶'),('51','浮动广告','20,30','浮动广告'),('61','随屏浮动广告','20,30','随屏浮动广告'),('71','POPUP广告','20,30','POPUP广告')
;
INSERT INTO `ef_ads_group` VALUES ('Index_ButtomPopup','71','首页底部Popup广告POPUP广告','0x0',80,80,1,1,1,1),('Index_Float','51','首页浮动广告浮动广告','0x0',80,100,1,0,1,1),('Index_FloatScrollLeft','61','首页随屏浮动广告_左随屏浮动广告','0x0',120,270,1,0,1,1),('Index_FloatScrollRight','61','对联广告右侧随屏浮动广告','0x0',120,270,1,0,2,1),('Page_Banner','1','页面顶端Banner广告定位广告（非绝对定位）','0x0',600,87,0,1,1,1),('Page_Header','1','页面头部位置横幅广告定位广告（非绝对定位）','0x0',948,90,0,1,1,1),('Page_Header','2','页面头部位置横幅广告垂直翻滚广告','0x0',760,50,0,0,1,1),('Page_Header','3','页面头部位置横幅广告水平翻滚广告','0x0',360,50,0,0,1,1),('Page_HeaderHalf','1','页面头部位置的横幅广告_半截定位广告（非绝对定位）','0x0',760,90,0,1,1,1),('Page_HeaderHalf','2','页面头部位置的横幅广告_半截垂直翻滚广告',NULL,NULL,NULL,0,0,1,1),('Page_HeaderHalf','3','页面头部位置的横幅广告_半截水平翻滚广告',NULL,NULL,NULL,0,0,1,1),('Page_HeadTop','41','页面置顶广告置顶','0x0',960,100,1,1,1,1),('Page_NewWin','31','首页弹出窗口广告','0x0',500,200,1,1,1,1),('Post_ContentRight','1','帖子内容右侧定位广告（非绝对定位）','0x0',120,240,0,1,1,1),('Post_ListCenter','1','帖子楼层中间的广告定位广告（非绝对定位）','0x0',948,90,0,1,1,1),('Post_SignedBottom','1','个人签名下面广告定位广告（非绝对定位）','0x0',460,94,0,1,1,1),('Post_SignedBottom','2','个人签名下面广告垂直翻滚广告','0x0',728,90,0,0,1,1),('Post_SignedBottom','3','个人签名下面广告水平翻滚广告','0x0',728,90,0,0,1,1),('Index_PicsRotate','1','首页多图轮换广告定位广告（非绝对定位）','0x0',328,276,0,0,1,1)
;
INSERT INTO `ef_ads_showtype_fields` VALUES ('cols','41','列数','列数',0,2,NULL,4,'4',200,0),('content_type','41','置顶内容类型','置顶内容类型',0,4,'全局置顶主题,0\r\n论坛最新主题,1\r\n今日热门主题,2\r\n运营商自定义,3',4,'1',300,0),('frequence','2','频率','频率',0,6,'10fps,10\r\n20fps,20\r\n30fps,30',4,'10',100,0),('frequence','3','频率','频率',0,6,'10fps,10\r\n20fps,20\r\n30fps,30',4,'10',100,0),('frequence','51','速度','速度',0,2,NULL,4,'80',100,0),('frequence','61','频率','频率',0,2,NULL,4,'10',100,0),('frequence','71','频率','频率',0,2,NULL,4,'10',100,0),('left','31','屏幕X坐标',NULL,0,2,NULL,4,'0',300,0),('location','31','地址栏','地址栏',0,6,'是,0\r\n否,1',4,'1',100,0),('menubar','31','菜单栏','菜单栏',0,6,'是,0\r\n否,1',4,'1',100,0),('posType','61','位置类型','位置类型',0,4,'左边,0\r\n右边,1',4,'0',100,0),('resizable','31','可变大小','可变大小',0,6,'是,0\r\n否,1',4,'1',100,0),('rows','41','行数','行数',0,2,NULL,4,'2',100,0),('scrollbars','31','滚动条','滚动条',0,6,'是,0\r\n否,1',4,'1',100,0),('status','31','状态栏','状态栏',0,6,'是,0\r\n否,1',4,'1',100,0),('titlebar','31','标题栏','标题栏',0,6,'是,0\r\n否,1',4,'1',100,0),('toolbar','31','工具栏','工具栏',0,6,'是,0\r\n否,1',4,'1',100,0),('top','31','屏幕Y坐标',NULL,0,2,NULL,4,'0',200,0)
;
INSERT INTO `ef_ads_group_set` VALUES ('Index_ButtomPopup','71','frequence','10'),('Index_Float','51','frequence','80'),('Index_FloatScrollLeft','61','frequence','10'),('Index_FloatScrollLeft','61','posType','0'),('Index_FloatScrollRight','61','frequence','10'),('Index_FloatScrollRight','61','posType','1'),('Page_HeadTop','41','cols','4'),('Page_HeadTop','41','content_type','3'),('Page_HeadTop','41','rows','2'),('Page_NewWin','31','left','50'),('Page_NewWin','31','location','0'),('Page_NewWin','31','menubar','0'),('Page_NewWin','31','resizable','0'),('Page_NewWin','31','scrollbars','0'),('Page_NewWin','31','status','0'),('Page_NewWin','31','titlebar','0'),('Page_NewWin','31','toolbar','0'),('Page_NewWin','31','top','50')
;
INSERT INTO `ef_ads_type` VALUES ('10','文字类型','文字类型'),('20','图片类型','图片类型'),('30','Flash类型','Flash类型'),('40','代码方式','支持HTML/JavaScript'),('50','页面','提供页面访问的URL配置'),('60','Flash图片变化类型','Flash图片变化类型'),('70','多图片变化','多图片变化'),('80','多图片循环移动','多图片循环移动'),('90','推荐链接阵列','n*m的链接阵列，比如广告链接或者推荐的帖子链接')
;
INSERT INTO `ef_ads_type_fields` VALUES ('content','10','广告内容','广告内容',0,8,NULL,3000,100,0),('content','40','广告内容','广告内容',0,8,NULL,3000,100,0),('content','90','广告内容','广告内容',0,8,NULL,3000,100,0),('descr','20','广告简介','广告简介',0,8,NULL,3000,50,0),('frequence','70','图片变化速度（秒，建议：5）','图片变化速度（秒）',0,2,NULL,4,100,0),('frequence','80','频率（数值越大越慢，建议：3）','频率',0,2,NULL,4,300,0),('height','20','图片高度','图片高度',0,2,NULL,4,160,0),('height','30','动画高度','动画高度',0,2,NULL,4,160,0),('height','60','高度','高度',0,2,NULL,4,300,0),('link','20','链接目标','链接目标',0,6,'新窗口,_target\r\n原窗口,_self',10,80,0),('path','20','图片地址','图片的本地相对地址',0,99,NULL,100,200,0),('path','30','动画地址','动画本地相对地址',0,99,NULL,100,200,0),('pic_content','60','图片内容','图片内容',0,8,NULL,1000,100,0),('pic_content','70','图片内容','图片内容',0,8,NULL,1000,100,0),('pic_content','80','图片内容','图片内容',0,8,NULL,1000,100,0),('pic_width','80','图片宽度','图片宽度',0,2,NULL,4,200,0),('target','70','链接类型','链接类型',0,6,'本窗口,_self\r\n新窗口,_blank',4,100,0),('target','80','链接类型','链接类型',0,6,'本窗口,_self\r\n新窗口,_blank',4,400,0),('text_height','60','文字高度','文字高度',0,2,NULL,4,90,0),('title','20','链接提示','链接提示',0,2,NULL,200,90,0),('transparent','30','背景透明','背景透明',0,6,'不透明,0\r\n透明,1',4,100,0),('url','20','链接地址','链接地址',0,2,NULL,200,100,0),('url','50','页面链接地址','页面链接地址',0,2,NULL,300,100,0),('width','20','图片宽度','图片宽度',0,2,NULL,4,180,0),('width','30','动画宽度','动画宽度',0,2,NULL,4,180,0),('width','60','宽度','宽度',0,2,NULL,4,200,0)
;
INSERT INTO `ef_ads` VALUES (1,'Page_Banner','1','20',1,'ospod广告','ospod广告',100,UNIX_TIMESTAMP()*1000,NULL,10)
;
INSERT INTO `ef_ads_set` VALUES (1,'descr','20','ospod 官方网站'),(1,'height','20','87'),(1,'link','20','_target'),(1,'path','20','ef/res/images/ospod.gif'),(1,'title','20','ospod 官方网站'),(1,'url','20','http://www.ospod.com'),(1,'width','20','600')
;