创意电子 管理员
  • 最佳新人

    注册账号后积极发帖的会员
  • 活跃会员

    经常参与各类话题的讨论,发帖内容较有主见
  • 1366发帖数
  • 1294主题数
  • 2关注数
  • 12粉丝
开启左侧

【飞鸟】直播 独享版 2.0.5

[复制链接]
 楼主| 创意电子 发表于 2022-7-21 22:59:28 | 显示全部楼层 |阅读模式 打印 上一主题 下一主题
【飞鸟】直播
  • 是否开源:是
  • 插件分类:更多独立功能系统
  • 用户评分:
  • 语言编码:多语言编码 
  • 更新时间:2021-03-11
  • 兼容版本:X3.2 X3.3 X3.4 
插件详情
资源名称:fn_live.zip 【飞鸟】直播
下载次数:1  文件大小:1.14 MB  记录
购买VIP 充值创意币 运营教程 免费赚创意币 
安全检测,请放心下载

演示参照用
  1. -- phpMyAdmin SQL Dump
  2. -- version 5.0.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- 主机: localhost
  6. -- 生成日期: 2020-12-07 22:47:49
  7. -- 服务器版本: 5.7.31-log
  8. -- PHP 版本: 7.4.12

  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. START TRANSACTION;
  11. SET time_zone = "+00:00";


  12. /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
  13. /*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
  14. /*!40101 SET @[email protected]@COLLATION_CONNECTION */;
  15. /*!40101 SET NAMES utf8mb4 */;

  16. --
  17. -- 数据库: `fn`
  18. --

  19. -- --------------------------------------------------------

  20. --
  21. -- 表的结构 `pre_fn_live`
  22. --

  23. CREATE TABLE `pre_fn_live` (
  24.   `id` int(11) UNSIGNED NOT NULL,
  25.   `class_id` int(11) UNSIGNED NOT NULL,
  26.   `number_id` int(11) UNSIGNED NOT NULL,
  27.   `title` varchar(255) NOT NULL,
  28.   `content` text NOT NULL,
  29.   `thumb` varchar(255) NOT NULL,
  30.   `param` mediumtext NOT NULL,
  31.   `state` tinyint(1) UNSIGNED NOT NULL,
  32.   `display` tinyint(1) UNSIGNED NOT NULL,
  33.   `start_dateline` int(11) UNSIGNED NOT NULL,
  34.   `end_dateline` int(11) UNSIGNED NOT NULL,
  35.   `dateline` int(11) UNSIGNED NOT NULL,
  36.   `updateline` int(11) UNSIGNED NOT NULL,
  37.   `topdateline` int(11) UNSIGNED NOT NULL,
  38.   `click` int(11) UNSIGNED NOT NULL
  39. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  40. --
  41. -- 转存表中的数据 `pre_fn_live`
  42. --

  43. INSERT INTO `pre_fn_live` (`id`, `class_id`, `number_id`, `title`, `content`, `thumb`, `param`, `state`, `display`, `start_dateline`, `end_dateline`, `dateline`, `updateline`, `topdateline`, `click`) VALUES
  44. (1, 0, 1, '飞鸟直播测试频道', '飞鸟直播测试频道', 'http://dev.yili6.com/source/plugin/fn_assembly/attachment/fn_admin/fn_15676907455d710ff925270.jpg', 'a:121:{s:8:"jump_url";s:0:"";s:4:"gift";i:1;s:9:"gift_list";a:8:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";i:4;s:1:"5";i:5;s:1:"6";i:6;s:1:"7";i:7;s:1:"8";}s:8:"gift_img";s:67:"https://demo.dz-x.net//source/plugin/fn_live/static/images/gift.png";s:12:"gift_list_bg";s:70:"https://demo.dz-x.net//source/plugin/fn_live/static/images/gift_bg.jpg";s:15:"gift_list_money";s:73:"https://demo.dz-x.net//source/plugin/fn_live/static/images/gift_money.jpg";s:10:"gift_title";s:12:"赠送礼物";s:15:"gift_list_title";s:12:"礼物列表";s:12:"gift_comment";s:122:"{username}送出了<span class=ColorRed>{gift_title}</span>礼物{gift_ico},价值<span class=ColorRed>{money}</span>元";s:24:"participant_gift_comment";s:128:"{username}送给了{name}<span class=ColorRed>{gift_title}</span>礼物{gift_ico},价值<span class=ColorRed>{money}</span>元";s:16:"gift_log_content";s:68:"{username}增送了<span class=Color>[{gift_title}]</span>{gift_ico}";s:9:"pedpacket";i:1;s:13:"pedpacket_img";s:72:"https://demo.dz-x.net//source/plugin/fn_live/static/images/redpacket.png";s:13:"pedpacket_app";i:0;s:18:"pedpacket_app_tips";s:24:"App才可以领红包哦";s:11:"visit_limit";i:1;s:14:"no_pay_comment";i:0;s:19:"no_pay_comment_tips";s:48:"您还没有付费观看,暂时不能评论哦";s:5:"money";s:0:"";s:9:"money_app";s:0:"";s:10:"money_time";s:0:"";s:10:"money_tips";s:62:"查看直播需要付费<span class=ColorRed>{money}</span>元";s:14:"money_app_tips";s:95:"查看直播需要付费{money}元{br}下载APP只需<span class=ColorRed>{money_app}</span>元";s:11:"money_title";s:12:"付费观看";s:9:"money_btn";s:12:"马上付费";s:13:"money_app_btn";s:9:"下载APP";s:4:"pass";s:0:"";s:9:"pass_time";i:0;s:8:"password";s:0:"";s:4:"navs";s:85:"1=评论\r\n2=直播介绍\r\n3=商家介绍\r\n4=图文直播\r\n5=排行榜\r\n6=打赏选手";s:10:"navs_array";a:6:{i:1;s:6:"评论";i:2;s:12:"直播介绍";i:3;s:12:"商家介绍";i:4;s:12:"图文直播";i:5;s:9:"排行榜";i:6;s:12:"打赏选手";}s:10:"nav_follow";i:0;s:16:"follow_pop_title";s:39:"添加在线客服,专属为您服务";s:21:"follow_pop_wx_content";s:42:"长按识别二维码,咨询专属客服";s:18:"follow_pop_content";s:64:"长按保存二维码<br>打开微信识别二维码添加客服";s:9:"follow_qr";s:0:"";s:15:"follow_bg_color";s:7:"#20a0ff";s:12:"live_name_id";s:139:"1=飞鸟直播员1号|source/plugin/fn_live/static/images/gift.png\r\n2=飞鸟直播员2号|source/plugin/fn_live/static/images/redpacket.png";s:18:"live_name_id_array";a:2:{i:1;a:2:{s:4:"name";s:19:"飞鸟直播员1号";s:4:"face";s:44:"source/plugin/fn_live/static/images/gift.png";}i:2;a:2:{s:4:"name";s:19:"飞鸟直播员2号";s:4:"face";s:49:"source/plugin/fn_live/static/images/redpacket.png";}}s:14:"info_auto_time";i:120000;s:10:"info_limit";i:15;s:8:"content2";s:31:"<p>飞鸟直播测试频道</p>";s:8:"content3";s:31:"<p>飞鸟直播测试频道</p>";s:16:"comment_prohibit";i:0;s:21:"comment_prohibit_tips";s:21:"该直播禁止评论";s:15:"comment_display";i:0;s:17:"comment_auto_time";i:60000;s:12:"comment_time";i:0;s:17:"comment_time_tips";s:51:"您评论太快了,休息{TIME}秒在来评论吧";s:17:"comment_input_btn";s:6:"发送";s:18:"comment_input_tips";s:15:"说点什么...";s:23:"comment_input_null_tips";s:15:"请输入评论";s:13:"comment_limit";i:30;s:23:"comment_forbidden_words";s:0:"";s:29:"comment_forbidden_words_array";a:0:{}s:28:"comment_forbidden_words_tips";s:15:"您已被禁言";s:12:"comment_roll";s:27:"飞鸟直播测试频道!";s:10:"comment_bg";s:0:"";s:11:"ranking_nav";s:43:"1=礼物榜\r\n2=发红包榜\r\n3=领红包榜";s:17:"ranking_nav_array";a:3:{i:1;s:9:"礼物榜";i:2;s:12:"发红包榜";i:3;s:12:"领红包榜";}s:13:"ranking_limit";i:30;s:29:"participant_reward_percentage";i:0;s:21:"participant_reward_bg";s:84:"https://demo.dz-x.net//source/plugin/fn_live/static/images/participant_reward_bg.jpg";s:22:"participant_reward_top";i:0;s:18:"participant_mobile";i:0;s:21:"participant_mobile_bg";s:7:"#20a0ff";s:27:"participant_mobile_btn_text";s:8:"联系Ta";s:9:"bumber_bg";s:7:"#20a0ff";s:19:"reward_btn_bg_color";s:7:"#20a0ff";s:15:"reward_btn_text";s:11:"给Ta打赏";s:6:"poster";i:1;s:10:"poster_ico";s:73:"https://demo.dz-x.net//source/plugin/fn_live/static/images/poster_ico.png";s:9:"poster_bg";s:72:"https://demo.dz-x.net//source/plugin/fn_live/static/images/poster_bg.jpg";s:18:"poster_title_color";s:7:"#A62417";s:13:"poster_invite";i:0;s:14:"qr_code_switch";i:0;s:12:"player_cover";s:68:"https://cdn.dz-x.net/fn_admin/20201207/fn16073497985fce36269edc5.jpg";s:13:"player_weight";i:0;s:13:"player_height";i:0;s:11:"player_type";s:2:"yy";s:4:"rtmp";s:0:"";s:4:"m3u8";s:0:"";s:8:"app_m3u8";s:0:"";s:13:"app_m3u8_tips";s:24:"下载APP可观看高清";s:16:"player_bottom_ad";s:0:"";s:14:"ad_roll_switch";i:0;s:7:"ad_roll";s:0:"";s:11:"ad_roll_url";s:0:"";s:13:"ad_roll_color";s:7:"#ffffff";s:16:"ad_roll_bg_color";s:7:"#000000";s:16:"ad_roll_bg_cover";s:0:"";s:10:"iframe_url";s:0:"";s:19:"analysis_url_switch";i:0;s:7:"room_id";s:0:"";s:3:"sid";s:8:"16777217";s:4:"ssid";s:8:"16777217";s:7:"temp_id";s:8:"16777217";s:10:"qq_room_id";s:0:"";s:13:"douyu_room_id";s:0:"";s:13:"fixed_nav_app";i:0;s:11:"app_comment";i:0;s:15:"app_commen_tips";s:27:"评论只能在APP评论哦";s:13:"app_play_back";i:0;s:18:"app_play_back_tips";s:27:"直播只能在APP观看哦";s:11:"full_screen";i:0;s:17:"full_screen_cover";s:0:"";s:15:"full_screen_url";s:0:"";s:16:"full_screen_time";i:5;s:29:"admin_participant_reward_uids";s:1:"1";s:15:"admin_info_uids";s:1:"1";s:10:"admin_uids";s:1:"1";s:11:"share_title";s:24:"飞鸟直播测试分享";s:10:"share_desc";s:24:"飞鸟直播测试分享";s:9:"share_img";s:68:"https://cdn.dz-x.net/fn_admin/20201207/fn16073499405fce36b41cd3d.png";s:5:"color";s:7:"#20a0ff";s:6:"fcolor";s:7:"#ff0000";s:5:"visit";i:0;s:10:"PcQrSwitch";i:0;s:8:"PcQrText";s:39:"扫一扫,手机观看直播更方便";s:10:"click_rand";s:3:"1-1";s:7:"app_ico";s:0:"";}', 1, 1, 1607270400, 0, 1607349750, 1607349720, 0, 3),
  45. (2, 0, 1, '【高清】北京卫视直播现场观看', '【高清】北京卫视直播现场观看', 'http://dev.yili6.com/source/plugin/fn_assembly/attachment/fn_admin/fn_15676883065d710672d53e4.jpg', 'a:120:{s:8:"jump_url";s:0:"";s:4:"gift";i:0;s:9:"gift_list";s:0:"";s:8:"gift_img";s:67:"https://demo.dz-x.net//source/plugin/fn_live/static/images/gift.png";s:12:"gift_list_bg";s:70:"https://demo.dz-x.net//source/plugin/fn_live/static/images/gift_bg.jpg";s:15:"gift_list_money";s:73:"https://demo.dz-x.net//source/plugin/fn_live/static/images/gift_money.jpg";s:10:"gift_title";s:12:"赠送礼物";s:15:"gift_list_title";s:12:"礼物列表";s:12:"gift_comment";s:122:"{username}送出了<span class=ColorRed>{gift_title}</span>礼物{gift_ico},价值<span class=ColorRed>{money}</span>元";s:24:"participant_gift_comment";s:128:"{username}送给了{name}<span class=ColorRed>{gift_title}</span>礼物{gift_ico},价值<span class=ColorRed>{money}</span>元";s:16:"gift_log_content";s:68:"{username}增送了<span class=Color>[{gift_title}]</span>{gift_ico}";s:9:"pedpacket";i:0;s:13:"pedpacket_img";s:72:"https://demo.dz-x.net//source/plugin/fn_live/static/images/redpacket.png";s:13:"pedpacket_app";i:0;s:18:"pedpacket_app_tips";s:24:"App才可以领红包哦";s:11:"visit_limit";i:1;s:14:"no_pay_comment";i:0;s:19:"no_pay_comment_tips";s:48:"您还没有付费观看,暂时不能评论哦";s:5:"money";s:0:"";s:9:"money_app";s:0:"";s:10:"money_time";s:0:"";s:10:"money_tips";s:62:"查看直播需要付费<span class=ColorRed>{money}</span>元";s:14:"money_app_tips";s:95:"查看直播需要付费{money}元{br}下载APP只需<span class=ColorRed>{money_app}</span>元";s:11:"money_title";s:12:"付费观看";s:9:"money_btn";s:12:"马上付费";s:13:"money_app_btn";s:9:"下载APP";s:4:"pass";s:0:"";s:9:"pass_time";i:0;s:8:"password";s:0:"";s:4:"navs";s:85:"1=评论\r\n2=直播介绍\r\n3=商家介绍\r\n4=图文直播\r\n5=排行榜\r\n6=打赏选手";s:10:"navs_array";a:6:{i:1;s:6:"评论";i:2;s:12:"直播介绍";i:3;s:12:"商家介绍";i:4;s:12:"图文直播";i:5;s:9:"排行榜";i:6;s:12:"打赏选手";}s:10:"nav_follow";i:0;s:16:"follow_pop_title";s:39:"添加在线客服,专属为您服务";s:21:"follow_pop_wx_content";s:42:"长按识别二维码,咨询专属客服";s:18:"follow_pop_content";s:64:"长按保存二维码<br>打开微信识别二维码添加客服";s:9:"follow_qr";s:0:"";s:15:"follow_bg_color";s:7:"#20a0ff";s:12:"live_name_id";s:0:"";s:14:"info_auto_time";i:120000;s:10:"info_limit";i:15;s:8:"content2";s:49:"<p>【高清】北京卫视直播现场观看</p>";s:8:"content3";s:49:"<p>【高清】北京卫视直播现场观看</p>";s:16:"comment_prohibit";i:0;s:21:"comment_prohibit_tips";s:21:"该直播禁止评论";s:15:"comment_display";i:0;s:17:"comment_auto_time";i:60000;s:12:"comment_time";i:0;s:17:"comment_time_tips";s:51:"您评论太快了,休息{TIME}秒在来评论吧";s:17:"comment_input_btn";s:6:"发送";s:18:"comment_input_tips";s:15:"说点什么...";s:23:"comment_input_null_tips";s:15:"请输入评论";s:13:"comment_limit";i:30;s:23:"comment_forbidden_words";s:0:"";s:29:"comment_forbidden_words_array";a:0:{}s:28:"comment_forbidden_words_tips";s:15:"您已被禁言";s:12:"comment_roll";s:0:"";s:10:"comment_bg";s:0:"";s:11:"ranking_nav";s:43:"1=礼物榜\r\n2=发红包榜\r\n3=领红包榜";s:17:"ranking_nav_array";a:3:{i:1;s:9:"礼物榜";i:2;s:12:"发红包榜";i:3;s:12:"领红包榜";}s:13:"ranking_limit";i:30;s:29:"participant_reward_percentage";i:0;s:21:"participant_reward_bg";s:84:"https://demo.dz-x.net//source/plugin/fn_live/static/images/participant_reward_bg.jpg";s:22:"participant_reward_top";i:0;s:18:"participant_mobile";i:0;s:21:"participant_mobile_bg";s:7:"#20a0ff";s:27:"participant_mobile_btn_text";s:8:"联系Ta";s:9:"bumber_bg";s:7:"#20a0ff";s:19:"reward_btn_bg_color";s:7:"#20a0ff";s:15:"reward_btn_text";s:11:"给Ta打赏";s:6:"poster";i:0;s:10:"poster_ico";s:73:"https://demo.dz-x.net//source/plugin/fn_live/static/images/poster_ico.png";s:9:"poster_bg";s:72:"https://demo.dz-x.net//source/plugin/fn_live/static/images/poster_bg.jpg";s:18:"poster_title_color";s:7:"#A62417";s:13:"poster_invite";i:0;s:14:"qr_code_switch";i:0;s:12:"player_cover";s:0:"";s:13:"player_weight";i:0;s:13:"player_height";i:0;s:11:"player_type";s:4:"m3u8";s:4:"rtmp";s:0:"";s:4:"m3u8";s:0:"";s:8:"app_m3u8";s:0:"";s:13:"app_m3u8_tips";s:24:"下载APP可观看高清";s:16:"player_bottom_ad";s:0:"";s:14:"ad_roll_switch";i:0;s:7:"ad_roll";s:0:"";s:11:"ad_roll_url";s:0:"";s:13:"ad_roll_color";s:7:"#ffffff";s:16:"ad_roll_bg_color";s:7:"#000000";s:16:"ad_roll_bg_cover";s:0:"";s:10:"iframe_url";s:0:"";s:19:"analysis_url_switch";i:0;s:7:"room_id";s:0:"";s:3:"sid";s:0:"";s:4:"ssid";s:0:"";s:7:"temp_id";s:0:"";s:10:"qq_room_id";s:0:"";s:13:"douyu_room_id";s:0:"";s:13:"fixed_nav_app";i:0;s:11:"app_comment";i:0;s:15:"app_commen_tips";s:27:"评论只能在APP评论哦";s:13:"app_play_back";i:0;s:18:"app_play_back_tips";s:27:"直播只能在APP观看哦";s:11:"full_screen";i:0;s:17:"full_screen_cover";s:0:"";s:15:"full_screen_url";s:0:"";s:16:"full_screen_time";i:5;s:29:"admin_participant_reward_uids";s:0:"";s:15:"admin_info_uids";s:0:"";s:10:"admin_uids";s:0:"";s:11:"share_title";s:0:"";s:10:"share_desc";s:0:"";s:9:"share_img";s:0:"";s:5:"color";s:7:"#20a0ff";s:6:"fcolor";s:7:"#ff0000";s:5:"visit";i:0;s:10:"PcQrSwitch";i:0;s:8:"PcQrText";s:39:"扫一扫,手机观看直播更方便";s:10:"click_rand";s:3:"1-1";s:7:"app_ico";s:0:"";}', 1, 1, 1607270400, 0, 1607352385, 1607352385, 0, 0);

  46. -- --------------------------------------------------------

  47. --
  48. -- 表的结构 `pre_fn_live_comment`
  49. --

  50. CREATE TABLE `pre_fn_live_comment` (
  51.   `id` int(11) UNSIGNED NOT NULL,
  52.   `rid` int(11) UNSIGNED NOT NULL,
  53.   `lid` int(11) UNSIGNED NOT NULL,
  54.   `uid` int(11) UNSIGNED NOT NULL,
  55.   `username` varchar(255) NOT NULL,
  56.   `content` text NOT NULL,
  57.   `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  58.   `redpacket_number` int(11) UNSIGNED NOT NULL,
  59.   `redpacket_type` tinyint(1) UNSIGNED NOT NULL,
  60.   `redpacket_list` mediumtext NOT NULL,
  61.   `money` decimal(11,2) UNSIGNED NOT NULL,
  62.   `count_money` decimal(11,2) UNSIGNED NOT NULL,
  63.   `param` mediumtext NOT NULL,
  64.   `display` tinyint(1) UNSIGNED NOT NULL,
  65.   `dateline` int(11) UNSIGNED NOT NULL,
  66.   `updateline` int(11) UNSIGNED NOT NULL,
  67.   `topdateline` int(11) UNSIGNED NOT NULL
  68. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  69. -- --------------------------------------------------------

  70. --
  71. -- 表的结构 `pre_fn_live_gift`
  72. --

  73. CREATE TABLE `pre_fn_live_gift` (
  74.   `id` int(11) UNSIGNED NOT NULL,
  75.   `title` varchar(255) NOT NULL,
  76.   `ico` varchar(255) NOT NULL,
  77.   `money` decimal(11,2) UNSIGNED NOT NULL,
  78.   `display` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  79.   `displayorder` int(11) UNSIGNED NOT NULL
  80. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  81. --
  82. -- 转存表中的数据 `pre_fn_live_gift`
  83. --

  84. INSERT INTO `pre_fn_live_gift` (`id`, `title`, `ico`, `money`, `display`, `displayorder`) VALUES
  85. (1, '加油', 'http://dev.yili6.com/data/attachment/forum/201909/30/122920s8iii6939isq59qt.png', '0.01', 0, 1),
  86. (2, '笔', 'http://dev.yili6.com/data/attachment/forum/201909/30/122932ezs0ypdla0lfy00p.png', '0.02', 0, 2),
  87. (3, '本子', 'http://dev.yili6.com/data/attachment/forum/201909/30/122945npej00v0jj96ui80.png', '0.03', 0, 3),
  88. (4, '书包', 'http://dev.yili6.com/data/attachment/forum/201909/30/123001m664bn6a5zp5717f.png', '0.04', 0, 4),
  89. (5, '火箭', 'http://dev.yili6.com/data/attachment/forum/201909/30/124703cjrmzj912rsrmapm.png', '0.05', 0, 5),
  90. (6, '跑车', 'http://dev.yili6.com/data/attachment/forum/201909/30/124302teequq1gg11vbfml.png', '0.06', 0, 6),
  91. (7, '轮船', 'http://dev.yili6.com/data/attachment/forum/201909/30/124315gq8vavgaqvdbwdwa.png', '0.07', 0, 7),
  92. (8, '洋酒', 'http://dev.yili6.com/data/attachment/forum/201909/30/124327knkjiwmjoje4ngon.png', '0.08', 0, 8);

  93. -- --------------------------------------------------------

  94. --
  95. -- 表的结构 `pre_fn_live_gift_log`
  96. --

  97. CREATE TABLE `pre_fn_live_gift_log` (
  98.   `id` int(11) UNSIGNED NOT NULL,
  99.   `uid` int(11) UNSIGNED NOT NULL,
  100.   `username` varchar(255) NOT NULL,
  101.   `be_reward_id` int(11) UNSIGNED NOT NULL,
  102.   `lid` int(11) UNSIGNED NOT NULL,
  103.   `gift_id` int(11) UNSIGNED NOT NULL,
  104.   `father_cid` int(11) UNSIGNED NOT NULL,
  105.   `money` decimal(11,2) NOT NULL,
  106.   `branch_money` decimal(11,2) UNSIGNED NOT NULL,
  107.   `branch_state` tinyint(1) UNSIGNED NOT NULL,
  108.   `dateline` int(11) UNSIGNED NOT NULL
  109. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  110. -- --------------------------------------------------------

  111. --
  112. -- 表的结构 `pre_fn_live_info`
  113. --

  114. CREATE TABLE `pre_fn_live_info` (
  115.   `id` int(11) UNSIGNED NOT NULL,
  116.   `uid` int(11) UNSIGNED NOT NULL,
  117.   `username` varchar(255) NOT NULL,
  118.   `lid` int(11) UNSIGNED NOT NULL,
  119.   `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  120.   `live_name_id` int(11) UNSIGNED NOT NULL,
  121.   `content` text NOT NULL,
  122.   `video_url` varchar(255) NOT NULL,
  123.   `param` mediumtext NOT NULL,
  124.   `display` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  125.   `dateline` int(11) UNSIGNED NOT NULL,
  126.   `updateline` int(11) UNSIGNED NOT NULL
  127. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  128. -- --------------------------------------------------------

  129. --
  130. -- 表的结构 `pre_fn_live_invite_log`
  131. --

  132. CREATE TABLE `pre_fn_live_invite_log` (
  133.   `id` int(11) UNSIGNED NOT NULL,
  134.   `lid` int(11) UNSIGNED NOT NULL,
  135.   `uid` int(11) UNSIGNED NOT NULL,
  136.   `invite_uid` int(11) UNSIGNED NOT NULL,
  137.   `invite_ip` varchar(20) NOT NULL,
  138.   `count` int(10) UNSIGNED NOT NULL,
  139.   `dateline` int(11) UNSIGNED NOT NULL
  140. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  141. -- --------------------------------------------------------

  142. --
  143. -- 表的结构 `pre_fn_live_number`
  144. --

  145. CREATE TABLE `pre_fn_live_number` (
  146.   `id` int(11) UNSIGNED NOT NULL,
  147.   `title` varchar(255) NOT NULL,
  148.   `logo` varchar(255) NOT NULL,
  149.   `content` text NOT NULL,
  150.   `param` mediumtext NOT NULL,
  151.   `click` int(11) UNSIGNED NOT NULL,
  152.   `display` tinyint(1) UNSIGNED NOT NULL,
  153.   `dateline` int(11) UNSIGNED NOT NULL,
  154.   `updateline` int(11) UNSIGNED NOT NULL,
  155.   `topdateline` int(11) UNSIGNED NOT NULL
  156. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  157. --
  158. -- 转存表中的数据 `pre_fn_live_number`
  159. --

  160. INSERT INTO `pre_fn_live_number` (`id`, `title`, `logo`, `content`, `param`, `click`, `display`, `dateline`, `updateline`, `topdateline`) VALUES
  161. (1, '电视直播频道', 'http://dev.yili6.com/source/plugin/fn_assembly/attachment/fn_admin/fn_15676881705d7105eadf54a.jpg', '电视直播频道电视直播频道电视直播频道电视直播频道电视直播频道电视直播频道\r\n', 'a:5:{s:6:"banner";a:1:{i:0;a:2:{s:3:"img";s:68:"https://cdn.dz-x.net/fn_admin/20201207/fn16073493315fce3453dd7ab.jpg";s:4:"link";s:0:"";}}s:5:"state";s:30:"1=正在直播\r\n2=历史直播";s:4:"navs";s:3:"1,2";s:10:"navs_array";a:2:{i:0;s:1:"1";i:1;s:1:"2";}s:5:"color";s:7:"#20a0ff";}', 115, 1, 1607349356, 1607349356, 0);

  162. -- --------------------------------------------------------

  163. --
  164. -- 表的结构 `pre_fn_live_participant`
  165. --

  166. CREATE TABLE `pre_fn_live_participant` (
  167.   `id` int(11) UNSIGNED NOT NULL,
  168.   `lid` int(11) UNSIGNED NOT NULL,
  169.   `uid` int(11) UNSIGNED NOT NULL,
  170.   `username` varchar(255) NOT NULL,
  171.   `name` varchar(255) NOT NULL,
  172.   `number` varchar(255) NOT NULL,
  173.   `thumbnail` varchar(255) NOT NULL,
  174.   `mobile` varchar(30) NOT NULL,
  175.   `param` mediumtext NOT NULL,
  176.   `ticket` int(11) UNSIGNED NOT NULL,
  177.   `display` tinyint(1) UNSIGNED NOT NULL,
  178.   `dateline` int(11) UNSIGNED NOT NULL,
  179.   `updateline` int(11) UNSIGNED NOT NULL
  180. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  181. --
  182. -- 转存表中的数据 `pre_fn_live_participant`
  183. --

  184. INSERT INTO `pre_fn_live_participant` (`id`, `lid`, `uid`, `username`, `name`, `number`, `thumbnail`, `mobile`, `param`, `ticket`, `display`, `dateline`, `updateline`) VALUES
  185. (1, 1, 1, 'admin', '测试选手', '1', 'https://uc.discuz.net/data/avatar/002/75/92/80_avatar_middle.jpg', '13012345678', '', 0, 1, 1607349668, 1607349668);

  186. -- --------------------------------------------------------

  187. --
  188. -- 表的结构 `pre_fn_live_pass_log`
  189. --

  190. CREATE TABLE `pre_fn_live_pass_log` (
  191.   `id` int(11) UNSIGNED NOT NULL,
  192.   `lid` int(11) UNSIGNED NOT NULL,
  193.   `uid` int(11) UNSIGNED NOT NULL,
  194.   `pass` varchar(50) NOT NULL,
  195.   `username` varchar(50) NOT NULL,
  196.   `dateline` int(11) UNSIGNED NOT NULL,
  197.   `updateline` int(11) UNSIGNED NOT NULL
  198. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  199. -- --------------------------------------------------------

  200. --
  201. -- 表的结构 `pre_fn_live_pay_log`
  202. --

  203. CREATE TABLE `pre_fn_live_pay_log` (
  204.   `id` int(11) UNSIGNED NOT NULL,
  205.   `class_id` int(11) UNSIGNED NOT NULL,
  206.   `number_id` int(11) UNSIGNED NOT NULL,
  207.   `lid` int(11) UNSIGNED NOT NULL,
  208.   `uid` int(11) UNSIGNED NOT NULL,
  209.   `username` varchar(255) NOT NULL,
  210.   `money` decimal(11,2) UNSIGNED NOT NULL,
  211.   `dateline` int(11) NOT NULL
  212. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  213. -- --------------------------------------------------------

  214. --
  215. -- 表的结构 `pre_fn_live_redpacket_log`
  216. --

  217. CREATE TABLE `pre_fn_live_redpacket_log` (
  218.   `id` int(11) UNSIGNED NOT NULL,
  219.   `uid` int(11) UNSIGNED NOT NULL,
  220.   `username` varchar(255) NOT NULL,
  221.   `lid` int(11) UNSIGNED NOT NULL,
  222.   `cid` int(11) UNSIGNED NOT NULL,
  223.   `father_cid` int(11) UNSIGNED NOT NULL,
  224.   `money` decimal(11,2) NOT NULL,
  225.   `redpacket_type` tinyint(2) UNSIGNED NOT NULL,
  226.   `state` tinyint(1) UNSIGNED NOT NULL,
  227.   `dateline` int(11) UNSIGNED NOT NULL
  228. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  229. -- --------------------------------------------------------

  230. --
  231. -- 表的结构 `pre_fn_live_visit_log`
  232. --

  233. CREATE TABLE `pre_fn_live_visit_log` (
  234.   `id` int(11) UNSIGNED NOT NULL,
  235.   `lid` int(11) UNSIGNED NOT NULL,
  236.   `uid` int(11) UNSIGNED NOT NULL,
  237.   `ip` varchar(20) NOT NULL,
  238.   `count` int(10) UNSIGNED NOT NULL,
  239.   `dateline` int(11) UNSIGNED NOT NULL,
  240.   `updateline` int(11) UNSIGNED NOT NULL
  241. ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

  242. --
  243. -- 转储表的索引
  244. --

  245. --
  246. -- 表的索引 `pre_fn_live`
  247. --
  248. ALTER TABLE `pre_fn_live`
  249.   ADD PRIMARY KEY (`id`);

  250. --
  251. -- 表的索引 `pre_fn_live_comment`
  252. --
  253. ALTER TABLE `pre_fn_live_comment`
  254.   ADD PRIMARY KEY (`id`);

  255. --
  256. -- 表的索引 `pre_fn_live_gift`
  257. --
  258. ALTER TABLE `pre_fn_live_gift`
  259.   ADD PRIMARY KEY (`id`);

  260. --
  261. -- 表的索引 `pre_fn_live_gift_log`
  262. --
  263. ALTER TABLE `pre_fn_live_gift_log`
  264.   ADD PRIMARY KEY (`id`);

  265. --
  266. -- 表的索引 `pre_fn_live_info`
  267. --
  268. ALTER TABLE `pre_fn_live_info`
  269.   ADD PRIMARY KEY (`id`);

  270. --
  271. -- 表的索引 `pre_fn_live_invite_log`
  272. --
  273. ALTER TABLE `pre_fn_live_invite_log`
  274.   ADD PRIMARY KEY (`id`);

  275. --
  276. -- 表的索引 `pre_fn_live_number`
  277. --
  278. ALTER TABLE `pre_fn_live_number`
  279.   ADD PRIMARY KEY (`id`);

  280. --
  281. -- 表的索引 `pre_fn_live_participant`
  282. --
  283. ALTER TABLE `pre_fn_live_participant`
  284.   ADD PRIMARY KEY (`id`);

  285. --
  286. -- 表的索引 `pre_fn_live_pass_log`
  287. --
  288. ALTER TABLE `pre_fn_live_pass_log`
  289.   ADD PRIMARY KEY (`id`);

  290. --
  291. -- 表的索引 `pre_fn_live_pay_log`
  292. --
  293. ALTER TABLE `pre_fn_live_pay_log`
  294.   ADD PRIMARY KEY (`id`);

  295. --
  296. -- 表的索引 `pre_fn_live_redpacket_log`
  297. --
  298. ALTER TABLE `pre_fn_live_redpacket_log`
  299.   ADD PRIMARY KEY (`id`);

  300. --
  301. -- 表的索引 `pre_fn_live_visit_log`
  302. --
  303. ALTER TABLE `pre_fn_live_visit_log`
  304.   ADD PRIMARY KEY (`id`);

  305. --
  306. -- 在导出的表使用AUTO_INCREMENT
  307. --

  308. --
  309. -- 使用表AUTO_INCREMENT `pre_fn_live`
  310. --
  311. ALTER TABLE `pre_fn_live`
  312.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

  313. --
  314. -- 使用表AUTO_INCREMENT `pre_fn_live_comment`
  315. --
  316. ALTER TABLE `pre_fn_live_comment`
  317.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  318. --
  319. -- 使用表AUTO_INCREMENT `pre_fn_live_gift`
  320. --
  321. ALTER TABLE `pre_fn_live_gift`
  322.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

  323. --
  324. -- 使用表AUTO_INCREMENT `pre_fn_live_gift_log`
  325. --
  326. ALTER TABLE `pre_fn_live_gift_log`
  327.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  328. --
  329. -- 使用表AUTO_INCREMENT `pre_fn_live_info`
  330. --
  331. ALTER TABLE `pre_fn_live_info`
  332.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  333. --
  334. -- 使用表AUTO_INCREMENT `pre_fn_live_invite_log`
  335. --
  336. ALTER TABLE `pre_fn_live_invite_log`
  337.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  338. --
  339. -- 使用表AUTO_INCREMENT `pre_fn_live_number`
  340. --
  341. ALTER TABLE `pre_fn_live_number`
  342.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

  343. --
  344. -- 使用表AUTO_INCREMENT `pre_fn_live_participant`
  345. --
  346. ALTER TABLE `pre_fn_live_participant`
  347.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

  348. --
  349. -- 使用表AUTO_INCREMENT `pre_fn_live_pass_log`
  350. --
  351. ALTER TABLE `pre_fn_live_pass_log`
  352.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  353. --
  354. -- 使用表AUTO_INCREMENT `pre_fn_live_pay_log`
  355. --
  356. ALTER TABLE `pre_fn_live_pay_log`
  357.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  358. --
  359. -- 使用表AUTO_INCREMENT `pre_fn_live_redpacket_log`
  360. --
  361. ALTER TABLE `pre_fn_live_redpacket_log`
  362.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  363. --
  364. -- 使用表AUTO_INCREMENT `pre_fn_live_visit_log`
  365. --
  366. ALTER TABLE `pre_fn_live_visit_log`
  367.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  368. COMMIT;

  369. /*!40101 SET [email protected]D_CHARACTER_SET_CLIENT */;
  370. /*!40101 SET [email protected]_CHARACTER_SET_RESULTS */;
  371. /*!40101 SET [email protected]_COLLATION_CONNECTION */;
复制代码
注意

此插件需要安装【飞鸟】基础组件
此插件需要安装【飞鸟】前台管理
非马甲App/千帆App需要安装【飞鸟】支付中心

插件特点
支持小云App、马甲App,千帆App
可设置标题
可设置横幅图片
可设置添加直播号
可设置直播导航
可设置直播状态
可设置直播访问限制
可设置直播封面
可设置是否禁止评论
可设置评论是否要审核
可设置评论间隔时间
可设置评论禁言
可设置分享标题/分享描述/分享图片
可设置主题颜色
演示站点
https://dome.cydz.eu.org/
入口地址

http://你的站点/plugin.php?id=fn_live




您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

猜你喜欢
在线客服QQ
2241998733

24x7小时免费咨询

Powered by 创意电子 ©2018-现在 专注资源实战分享源码下载站联盟商城繁体中文