·设为首页收藏本站📧邮箱修改🎁免费下载专区💎积分✅卡密📒收藏夹👽聊天室
🔄最新发布📃文档资料库🆔加群看共享切换到窄版
立即注册
DZ插件网»🏠首页 › Discuz!交流与探讨 › Discuz!运营教程 › 飞鸟 › 飞鸟直播演示实时聊天直播打赏等演示效果基础数据导入 ...
返回列表 发布新帖

飞鸟直播演示实时聊天直播打赏等演示效果基础数据导入

916 0
发表于 2020-12-7 23:20:09 | 查看全部 阅读模式

马上注册，免费下载更多dz插件网资源。

您需要 登录 才可以下载或查看，没有账号？立即注册

×
【飞鸟】直播演示飞鸟直播实时聊天直播打赏历史直播电视直播跟演示站一样的效果的参照设置基础数据一键导入：

演示实测效果：
https://demo.dz-x.net/plugin.php?id=fn_live&m=list_view&nid=1


适用版本：【飞鸟】直播 独享版 2.0.4 前后

操作方法：

后台 —— 站长 —— 数据库 ——升级：
[如果没有看到输入框，需要将 config/config_global.php 当中的 $_config[admincp][runquery] 设置修改为 1


提交执行语句：【请确认你是新安装！否则请谨慎操作！】
  1. DROP TABLE `pre_fn_live`, `pre_fn_live_comment`, `pre_fn_live_gift`, `pre_fn_live_gift_log`, `pre_fn_live_info`, `pre_fn_live_invite_log`, `pre_fn_live_number`, `pre_fn_live_participant`, `pre_fn_live_pass_log`, `pre_fn_live_pay_log`, `pre_fn_live_redpacket_log`, `pre_fn_live_visit_log`;
复制代码
然后再次提交执行：
  1. CREATE TABLE `pre_fn_live` (
  2.   `id` int(11) UNSIGNED NOT NULL,
  3.   `class_id` int(11) UNSIGNED NOT NULL,
  4.   `number_id` int(11) UNSIGNED NOT NULL,
  5.   `title` varchar(255) NOT NULL,
  6.   `content` text NOT NULL,
  7.   `thumb` varchar(255) NOT NULL,
  8.   `param` mediumtext NOT NULL,
  9.   `state` tinyint(1) UNSIGNED NOT NULL,
  10.   `display` tinyint(1) UNSIGNED NOT NULL,
  11.   `start_dateline` int(11) UNSIGNED NOT NULL,
  12.   `end_dateline` int(11) UNSIGNED NOT NULL,
  13.   `dateline` int(11) UNSIGNED NOT NULL,
  14.   `updateline` int(11) UNSIGNED NOT NULL,
  15.   `topdateline` int(11) UNSIGNED NOT NULL,
  16.   `click` int(11) UNSIGNED NOT NULL
  17. ) ENGINE=MyISAM;
  18. 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
  19. (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:"http://dev.yili6.com/source/plugin/fn_live/static/images/gift.png";s:12:"gift_list_bg";s:70:"http://dev.yili6.com/source/plugin/fn_live/static/images/gift_bg.jpg";s:15:"gift_list_money";s:73:"http://dev.yili6.com/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:"http://dev.yili6.com/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:"http://dev.yili6.com/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:"http://dev.yili6.com/source/plugin/fn_live/static/images/poster_ico.png";s:9:"poster_bg";s:72:"http://dev.yili6.com/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:"http://dev.yili6.com/source/plugin/fn_assembly/attachment/fn_admin/fn_15676901575d710dadea81b.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:"http://www.guiigo.com/data/attachment/common/a5/common_37_icon.jpg";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),
  20. (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:"http://dev.yili6.com/source/plugin/fn_live/static/images/gift.png";s:12:"gift_list_bg";s:70:"http://dev.yili6.com/source/plugin/fn_live/static/images/gift_bg.jpg";s:15:"gift_list_money";s:73:"http://dev.yili6.com/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:"http://dev.yili6.com/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:"http://dev.yili6.com/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:"http://dev.yili6.com/source/plugin/fn_live/static/images/poster_ico.png";s:9:"poster_bg";s:72:"http://dev.yili6.com/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);
  21. CREATE TABLE `pre_fn_live_comment` (
  22.   `id` int(11) UNSIGNED NOT NULL,
  23.   `rid` int(11) UNSIGNED NOT NULL,
  24.   `lid` int(11) UNSIGNED NOT NULL,
  25.   `uid` int(11) UNSIGNED NOT NULL,
  26.   `username` varchar(255) NOT NULL,
  27.   `content` text NOT NULL,
  28.   `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  29.   `redpacket_number` int(11) UNSIGNED NOT NULL,
  30.   `redpacket_type` tinyint(1) UNSIGNED NOT NULL,
  31.   `redpacket_list` mediumtext NOT NULL,
  32.   `money` decimal(11,2) UNSIGNED NOT NULL,
  33.   `count_money` decimal(11,2) UNSIGNED NOT NULL,
  34.   `param` mediumtext NOT NULL,
  35.   `display` tinyint(1) UNSIGNED NOT NULL,
  36.   `dateline` int(11) UNSIGNED NOT NULL,
  37.   `updateline` int(11) UNSIGNED NOT NULL,
  38.   `topdateline` int(11) UNSIGNED NOT NULL
  39. ) ENGINE=MyISAM;
  40. CREATE TABLE `pre_fn_live_gift` (
  41.   `id` int(11) UNSIGNED NOT NULL,
  42.   `title` varchar(255) NOT NULL,
  43.   `ico` varchar(255) NOT NULL,
  44.   `money` decimal(11,2) UNSIGNED NOT NULL,
  45.   `display` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  46.   `displayorder` int(11) UNSIGNED NOT NULL
  47. ) ENGINE=MyISAM;
  48. INSERT INTO `pre_fn_live_gift` (`id`, `title`, `ico`, `money`, `display`, `displayorder`) VALUES
  49. (1, '加油', 'http://dev.yili6.com/data/attachment/forum/201909/30/122920s8iii6939isq59qt.png', '0.01', 0, 1),
  50. (2, '笔', 'http://dev.yili6.com/data/attachment/forum/201909/30/122932ezs0ypdla0lfy00p.png', '0.02', 0, 2),
  51. (3, '本子', 'http://dev.yili6.com/data/attachment/forum/201909/30/122945npej00v0jj96ui80.png', '0.03', 0, 3),
  52. (4, '书包', 'http://dev.yili6.com/data/attachment/forum/201909/30/123001m664bn6a5zp5717f.png', '0.04', 0, 4),
  53. (5, '火箭', 'http://dev.yili6.com/data/attachment/forum/201909/30/124703cjrmzj912rsrmapm.png', '0.05', 0, 5),
  54. (6, '跑车', 'http://dev.yili6.com/data/attachment/forum/201909/30/124302teequq1gg11vbfml.png', '0.06', 0, 6),
  55. (7, '轮船', 'http://dev.yili6.com/data/attachment/forum/201909/30/124315gq8vavgaqvdbwdwa.png', '0.07', 0, 7),
  56. (8, '洋酒', 'http://dev.yili6.com/data/attachment/forum/201909/30/124327knkjiwmjoje4ngon.png', '0.08', 0, 8);
  57. CREATE TABLE `pre_fn_live_gift_log` (
  58.   `id` int(11) UNSIGNED NOT NULL,
  59.   `uid` int(11) UNSIGNED NOT NULL,
  60.   `username` varchar(255) NOT NULL,
  61.   `be_reward_id` int(11) UNSIGNED NOT NULL,
  62.   `lid` int(11) UNSIGNED NOT NULL,
  63.   `gift_id` int(11) UNSIGNED NOT NULL,
  64.   `father_cid` int(11) UNSIGNED NOT NULL,
  65.   `money` decimal(11,2) NOT NULL,
  66.   `branch_money` decimal(11,2) UNSIGNED NOT NULL,
  67.   `branch_state` tinyint(1) UNSIGNED NOT NULL,
  68.   `dateline` int(11) UNSIGNED NOT NULL
  69. ) ENGINE=MyISAM;
  70. CREATE TABLE `pre_fn_live_info` (
  71.   `id` int(11) UNSIGNED NOT NULL,
  72.   `uid` int(11) UNSIGNED NOT NULL,
  73.   `username` varchar(255) NOT NULL,
  74.   `lid` int(11) UNSIGNED NOT NULL,
  75.   `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  76.   `live_name_id` int(11) UNSIGNED NOT NULL,
  77.   `content` text NOT NULL,
  78.   `video_url` varchar(255) NOT NULL,
  79.   `param` mediumtext NOT NULL,
  80.   `display` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  81.   `dateline` int(11) UNSIGNED NOT NULL,
  82.   `updateline` int(11) UNSIGNED NOT NULL
  83. ) ENGINE=MyISAM;
  84. CREATE TABLE `pre_fn_live_invite_log` (
  85.   `id` int(11) UNSIGNED NOT NULL,
  86.   `lid` int(11) UNSIGNED NOT NULL,
  87.   `uid` int(11) UNSIGNED NOT NULL,
  88.   `invite_uid` int(11) UNSIGNED NOT NULL,
  89.   `invite_ip` varchar(20) NOT NULL,
  90.   `count` int(10) UNSIGNED NOT NULL,
  91.   `dateline` int(11) UNSIGNED NOT NULL
  92. ) ENGINE=MyISAM;
  93. CREATE TABLE `pre_fn_live_number` (
  94.   `id` int(11) UNSIGNED NOT NULL,
  95.   `title` varchar(255) NOT NULL,
  96.   `logo` varchar(255) NOT NULL,
  97.   `content` text NOT NULL,
  98.   `param` mediumtext NOT NULL,
  99.   `click` int(11) UNSIGNED NOT NULL,
  100.   `display` tinyint(1) UNSIGNED NOT NULL,
  101.   `dateline` int(11) UNSIGNED NOT NULL,
  102.   `updateline` int(11) UNSIGNED NOT NULL,
  103.   `topdateline` int(11) UNSIGNED NOT NULL
  104. ) ENGINE=MyISAM;
  105. INSERT INTO `pre_fn_live_number` (`id`, `title`, `logo`, `content`, `param`, `click`, `display`, `dateline`, `updateline`, `topdateline`) VALUES
  106. (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:"http://dev.yili6.com/source/plugin/fn_assembly/attachment/fn_admin/fn_15899434515ec49c9b1c30d.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);
  107. CREATE TABLE `pre_fn_live_participant` (
  108.   `id` int(11) UNSIGNED NOT NULL,
  109.   `lid` int(11) UNSIGNED NOT NULL,
  110.   `uid` int(11) UNSIGNED NOT NULL,
  111.   `username` varchar(255) NOT NULL,
  112.   `name` varchar(255) NOT NULL,
  113.   `number` varchar(255) NOT NULL,
  114.   `thumbnail` varchar(255) NOT NULL,
  115.   `mobile` varchar(30) NOT NULL,
  116.   `param` mediumtext NOT NULL,
  117.   `ticket` int(11) UNSIGNED NOT NULL,
  118.   `display` tinyint(1) UNSIGNED NOT NULL,
  119.   `dateline` int(11) UNSIGNED NOT NULL,
  120.   `updateline` int(11) UNSIGNED NOT NULL
  121. ) ENGINE=MyISAM;
  122. INSERT INTO `pre_fn_live_participant` (`id`, `lid`, `uid`, `username`, `name`, `number`, `thumbnail`, `mobile`, `param`, `ticket`, `display`, `dateline`, `updateline`) VALUES
  123. (1, 1, 1, 'admin', '测试选手', '1', 'https://uc.discuz.net/data/avatar/002/75/92/80_avatar_middle.jpg', '13012345678', '', 0, 1, 1607349668, 1607349668);
  124. CREATE TABLE `pre_fn_live_pass_log` (
  125.   `id` int(11) UNSIGNED NOT NULL,
  126.   `lid` int(11) UNSIGNED NOT NULL,
  127.   `uid` int(11) UNSIGNED NOT NULL,
  128.   `pass` varchar(50) NOT NULL,
  129.   `username` varchar(50) NOT NULL,
  130.   `dateline` int(11) UNSIGNED NOT NULL,
  131.   `updateline` int(11) UNSIGNED NOT NULL
  132. ) ENGINE=MyISAM;
  133. CREATE TABLE `pre_fn_live_pay_log` (
  134.   `id` int(11) UNSIGNED NOT NULL,
  135.   `class_id` int(11) UNSIGNED NOT NULL,
  136.   `number_id` int(11) UNSIGNED NOT NULL,
  137.   `lid` int(11) UNSIGNED NOT NULL,
  138.   `uid` int(11) UNSIGNED NOT NULL,
  139.   `username` varchar(255) NOT NULL,
  140.   `money` decimal(11,2) UNSIGNED NOT NULL,
  141.   `dateline` int(11) NOT NULL
  142. ) ENGINE=MyISAM;
  143. CREATE TABLE `pre_fn_live_redpacket_log` (
  144.   `id` int(11) UNSIGNED NOT NULL,
  145.   `uid` int(11) UNSIGNED NOT NULL,
  146.   `username` varchar(255) NOT NULL,
  147.   `lid` int(11) UNSIGNED NOT NULL,
  148.   `cid` int(11) UNSIGNED NOT NULL,
  149.   `father_cid` int(11) UNSIGNED NOT NULL,
  150.   `money` decimal(11,2) NOT NULL,
  151.   `redpacket_type` tinyint(2) UNSIGNED NOT NULL,
  152.   `state` tinyint(1) UNSIGNED NOT NULL,
  153.   `dateline` int(11) UNSIGNED NOT NULL
  154. ) ENGINE=MyISAM;
  155. CREATE TABLE `pre_fn_live_visit_log` (
  156.   `id` int(11) UNSIGNED NOT NULL,
  157.   `lid` int(11) UNSIGNED NOT NULL,
  158.   `uid` int(11) UNSIGNED NOT NULL,
  159.   `ip` varchar(20) NOT NULL,
  160.   `count` int(10) UNSIGNED NOT NULL,
  161.   `dateline` int(11) UNSIGNED NOT NULL,
  162.   `updateline` int(11) UNSIGNED NOT NULL
  163. ) ENGINE=MyISAM;
  164. ALTER TABLE `pre_fn_live`
  165.   ADD PRIMARY KEY (`id`);
  166. ALTER TABLE `pre_fn_live_comment`
  167.   ADD PRIMARY KEY (`id`);
  168. ALTER TABLE `pre_fn_live_gift`
  169.   ADD PRIMARY KEY (`id`);
  170. ALTER TABLE `pre_fn_live_gift_log`
  171.   ADD PRIMARY KEY (`id`);
  172. ALTER TABLE `pre_fn_live_info`
  173.   ADD PRIMARY KEY (`id`);
  174. ALTER TABLE `pre_fn_live_invite_log`
  175.   ADD PRIMARY KEY (`id`);
  176. ALTER TABLE `pre_fn_live_number`
  177.   ADD PRIMARY KEY (`id`);
  178. ALTER TABLE `pre_fn_live_participant`
  179.   ADD PRIMARY KEY (`id`);
  180. ALTER TABLE `pre_fn_live_pass_log`
  181.   ADD PRIMARY KEY (`id`);
  182. ALTER TABLE `pre_fn_live_pay_log`
  183.   ADD PRIMARY KEY (`id`);
  184. ALTER TABLE `pre_fn_live_redpacket_log`
  185.   ADD PRIMARY KEY (`id`);
  186. ALTER TABLE `pre_fn_live_visit_log`
  187.   ADD PRIMARY KEY (`id`);
  188. ALTER TABLE `pre_fn_live`
  189.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  190. ALTER TABLE `pre_fn_live_comment`
  191.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  192. ALTER TABLE `pre_fn_live_gift`
  193.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  194. ALTER TABLE `pre_fn_live_gift_log`
  195.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  196. ALTER TABLE `pre_fn_live_info`
  197.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  198. ALTER TABLE `pre_fn_live_invite_log`
  199.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  200. ALTER TABLE `pre_fn_live_number`
  201.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  202. ALTER TABLE `pre_fn_live_participant`
  203.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  204. ALTER TABLE `pre_fn_live_pass_log`
  205.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  206. ALTER TABLE `pre_fn_live_pay_log`
  207.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  208. ALTER TABLE `pre_fn_live_redpacket_log`
  209.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  210. ALTER TABLE `pre_fn_live_visit_log`
  211.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
复制代码


即可实现如作者演示站演示效果：
http://dev.yili6.com/plugin.php?id=fn_live&m=list_view&nid=1

飞鸟, 直播, 演示, 实时, 聊天
我要说一句 收起回复
赞赏
一花一世界，一叶一追寻。一曲一场叹，一生为一人。
回复

使用道具 举报

相关帖子
返回列表 发布新帖

回复
 懒得打字嘛，点击右侧快捷回复【查看最新发布】   【应用商城享更多资源】
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

创宇盾启航版免费网站防御网站加速服务

关于我们

关于我们 免责声明 应用市场 下载中心

服务支持

有问必答 优秀站点 常见问题 建站必看
投诉/建议联系

discuzaddons@vip.qq.com

未经授权禁止转载，复制和建立镜像，
如有违反，按照公告处理!!!
  • 联系QQ客服
  • 添加微信客服

联系DZ插件网微信客服|最近更新|Archiver|手机版|小黑屋|DZ插件网! ( 鄂ICP备20010621号-1 )|网站地图 知道创宇云防御

您的IP:3.15.225.164,GMT+8, 2024-12-22 18:54 , Processed in 0.228884 second(s), 78 queries , Gzip On, Redis On.

Powered by Discuz! X5.0 Licensed

© 2001-2024 Discuz! Team.

关灯 在本版发帖
扫一扫添加微信客服
 QQ客服返回顶部
快速回复 返回顶部 返回列表