const{createApp}=Vue const{createVuetify,useGoTo,useDisplay}=Vuetify var data={alert:{show:false,color:'success',text:'',timeout:0,},theme:{dark:false,},nav:{showDrawer:false,showTOC:true,tocPanel:0,tab:'account',post:{discussionId:3552,currentPage:1,targetPage:1,total:11,anchor:0,goToOptions:{container:null,duration:0,easing:'easeInOutCubic',offset:-100,},worker:null,task:[],active:[],apiLock:[],originLike:new Map([]),},related:{block:1,}},search:{width:80,text:null,loading:false,},tags:[{id:22,url:'/t/007065096a045c7562772a2e4e13',name:'Mysql',color:'#66BB6A',icon:'mdi-tag-heart',},],posts:[{id:41526,num:0,uid:9146,content:'\u003Cp\u003E感谢大家! 腾讯云轻量的内网大概是没办法互通了。我们原来的2c4g服务器性能不够,想使用不同腾讯云账号下的两个2c4g的服务器,分别运行web服务器和MySQL。我们目前是一个约4k主题贴,55k回复的中小型论坛,想寻求各位的经验,30M的外网带宽是否足够使用?\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:36:44',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41527,num:1,uid:1541,content:'\u003Cp\u003Ebd 关注一下\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:37:29',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41528,num:2,uid:3521,content:'\u003Cp\u003E目前是够的\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:38:42',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41529,num:3,uid:9722,content:'\u003Cp\u003E你都用轻量了 为啥不直接用4c8g的轻量\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:41:27',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[4,],mentionUsers:[],likeUsers:[],},{id:41530,num:4,uid:9146,content:'\u003Cblockquote\u003E\u003Cp\u003E你都用轻量了 为啥不直接用4c8g的轻量\u003C/p\u003E\u003C/blockquote\u003E\u003Cp\u003E4c8g的轻量没有优惠,而且4c8g的价格远高于2c4g x2😫\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:42:28',updatedAt:'2025-03-17 14:37:11',mentionNum:3,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41531,num:5,uid:7746,content:'\u003Cp\u003E如果不走内网的话反而会增加宽带占用吧\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:45:39',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[7,],mentionUsers:[],likeUsers:[],},{id:41532,num:6,uid:3504,content:'\u003Cp\u003E 你可以模拟一下\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:46:49',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41533,num:7,uid:9146,content:'\u003Cblockquote\u003E\u003Cp\u003E如果不走内网的话反而会增加宽带占用吧\u003C/p\u003E\u003C/blockquote\u003E\u003Cp\u003E当然是想走内网的,目前的情况是走不了\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:48:05',updatedAt:'2025-03-17 14:37:11',mentionNum:5,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41534,num:8,uid:9725,content:'\u003Cp\u003E应该够了的\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:52:05',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41535,num:9,uid:1986,content:'\u003Cp\u003E如果是我就上杜甫,够不行,得富裕一些。。。这样发挥最大性能而且还可以满足后续扩展。\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 10:53:44',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},{id:41536,num:10,uid:9722,content:'\u003Cp\u003E 有的,年抛号 4c8g12mb这个配置五百多就能拿下一年的\u003C/p\u003E',ipRegion:'',updatedByUid:0,createdAt:'2025-03-14 11:01:38',updatedAt:'2025-03-17 14:37:11',mentionNum:0,mentionedBy:[],mentionUsers:[],likeUsers:[],},],usersMap:new Map([[3504,{uid:3504,url:'/u/0e7800006a045c74656a526f210d242f',avatar:'/a/0e7800006a045c74656a526f210d242f',username:'Enetso🤖',}],[3521,{uid:3521,url:'/u/6321030f6a045c746568576f1b2b6212',avatar:'/a/6321030f6a045c746568576f1b2b6212',username:'cabbage🤖',}],[9146,{uid:9146,url:'/u/6b30441f6a045c7e616e506f3f33340f',avatar:'/a/6b30441f6a045c7e616e506f3f33340f',username:'AkiraSalvare🤖',}],[7746,{uid:7746,url:'/u/3f270a296a045c70676e506f125b1774',avatar:'/a/3f270a296a045c70676e506f125b1774',username:'bobyasasas🤖',}],[1986,{uid:1986,url:'/u/230044006a045c766962506f13586030',avatar:'/a/230044006a045c766962506f13586030',username:'tdy0923🤖',}],[9722,{uid:9722,url:'/u/112406096a045c7e6768546f352a3b3e',avatar:'/a/112406096a045c7e6768546f352a3b3e',username:'windson🤖',}],[9725,{uid:9725,url:'/u/107c7c196a045c7e6768536f4f502a3d',avatar:'/a/107c7c196a045c7e6768536f4f502a3d',username:'戴红帽的皮卡丘🤖',}],[1541,{uid:1541,url:'/u/690b79036a045c76656e576f4f3f3e76',avatar:'/a/690b79036a045c76656e576f4f3f3e76',username:'yedhi🤖',}],]),related:[{title:'你们会在数据库字段里存 json 字符串吗',url:'/d/173f54286a045c77606a56754f50626a2b01620a',},{title:'数据库小白咨询一个 MySQL 数据表的设计问题',url:'/d/38390b196a045c77606a5675435c606a1a391e35',},{title:'求一个mysql转SQLite的工具',url:'/d/0b395f376a045c77606a56744150656a54772313',},{title:'天塌了',url:'/d/69394a1d6a045c77606a56714558606a5e39093d',},],} const App={setup(){const goTo=useGoTo() const{mdAndUp}=useDisplay() return{goTo,mdAndUp}},data(){return data;},mounted(){const themeDark=localStorage.getItem("themeDark") if(themeDark!==null){this.theme.dark=JSON.parse(themeDark)} if(this.nav.post.total>(this.nav.post.currentPage-1)*100+20){let moreLen=100 if(this.nav.post.total({id:null,num:(this.nav.post.currentPage-1)*100+v,uid:null,content:null,ipRegion:null,updatedByUid:null,createdAt:null,updatedAt:null,mentionNum:null,mentionedBy:null,mentionUsers:null,likeUsers:null,})) this.posts.push(...morePosts.slice(20))} this.workerStart() const hash=window.location.hash const match=hash.match(/#(\d+)/) if(match){const n=parseInt(match[1],10) if(n>=(this.nav.post.currentPage-1)*100&&n{this.jumpTo(n)})}} this.$nextTick(()=>{this.addHeadingIds() tocbot.init({tocSelector:'.toc',contentSelector:'#post-content-0',headingSelector:'h2, h3, h4',headingsOffset:100,scrollSmoothOffset:-100,scrollSmooth:true,collapseDepth:6,onClick:function(e){setTimeout(()=>{history.replaceState(null,'',window.location.pathname+window.location.search)},0)},}) tocbot.refresh()});},beforeUnmount(){this.workerStop() if(this.quill){this.quill.destroy() this.quill=null}},computed:{dposts(){return this.posts.slice(20);},},created(){},methods:{successAlert(msg){this.alert={show:true,color:'success',text:msg,timeout:1500,}},failureAlert(msg){this.alert={show:true,color:'error',text:msg,timeout:5000,}},flipThemeDark(){this.theme.dark=!this.theme.dark localStorage.setItem("themeDark",JSON.stringify(this.theme.dark))},toSearch(){if(!this.search.text){this.failureAlert('搜索词不能为空') return} let keywords=this.search.text.trim() if(keywords.length<1){this.failureAlert('搜索词不能为空') return} if(keywords.length>100){this.failureAlert('搜索词过长') return} this.doSearch(keywords)},toReg(){window.location.href="/reg"},toLogin(){window.location.href="/login"},toPage(){let url=window.location.href url=url.replace(/(\/\d+)?(#[0-9]+)?$/,this.nav.post.targetPage>1?`/${this.nav.post.targetPage}`:'') window.location.href=url},toLoadRelated({done}){if(this.my&&this.my.uid){this.apiLoadRelated({done})}else{done('ok')}},workerStart(){this.nav.post.worker=setInterval(()=>{this.workerLoad()},500);},workerStop(){if(this.nav.post.worker){clearInterval(this.nav.post.worker);this.nav.post.worker=null;}},async jumpTo(num){const page=Math.floor(num/100)+1 const i=num-(page-1)*100 if(page===this.nav.post.currentPage){this.goTo("#post-"+num,this.nav.post.goToOptions) if(!this.posts[i].id){const block=Math.floor(num/20)+1 this.nav.post.apiLock[block]=true await this.apiLoadPosts(block) this.$nextTick(()=>{this.goTo("#post-"+num,this.nav.post.goToOptions)})}}else{let url=window.location.href url=url.replace(/(\/\d+)?(#[0-9]+)?$/,page>1?`/${page}`:'') url=url+"#"+num window.location.href=url}},postIntersect(num){return(isIntersecting,entries,observer)=>{if(isIntersecting){this.nav.post.task.push(num) this.nav.post.active.push(num) this.nav.post.active=this.nav.post.active.filter(item=>Math.abs(item-num)<=5) this.nav.post.active.sort((a,b)=>a-b)}else{this.nav.post.active=this.nav.post.active.filter(item=>item!==num)} if(this.nav.post.active[0]){this.nav.post.anchor=this.nav.post.active[0]}else{this.nav.post.anchor=0}}},async apiLoadPosts(block){try{const response=await axios.post('/fapi/v1/post/block/'+block,{discussionId:this.nav.post.discussionId,}) if(response.data.code===0){response.data.data.posts.forEach(post=>{const i=post.num%100 Object.assign(this.posts[i],post)}) response.data.data.users.forEach(user=>{this.usersMap.set(user.uid,user)})}else{this.failureAlert('回帖数据加载失败: '+response.data.msg)}}catch(error){this.failureAlert('回帖数据加载失败: '+error)} this.nav.post.apiLock[block]=false},workerLoad(){while(this.nav.post.task.length){const num=this.nav.post.task.pop() const i=num-(this.nav.post.currentPage-1)*100 if(!this.posts[i].id){const block=Math.floor(num/20)+1 if(!this.nav.post.apiLock[block]){this.nav.post.apiLock[block]=true this.apiLoadPosts(block)}}}},getTimeInfo(t){if(!t){return ""} const now=new Date();const then=new Date(t);const diff=now-then;const minute=60*1000;const hour=minute*60;const day=hour*24;const month=day*30;const year=month*12;if(diffpost.num===num) if(!post){return "#"+num} const uid=post.uid const username=this.usersMap.get(uid)?.username if(!username){return "#"+num} return username},getUsernameByPostId(id){const post=this.posts.find(post=>post.id===id) if(!post){return "#"+this.getPostNumByPostId(id)} const uid=post.uid const username=this.usersMap.get(uid).username if(!username){return "#"+this.getPostNumByPostId(id)} return username},getPostNumByPostId(id){const post=this.posts.find(post=>post.id===id) return post.num},getPostById(id){const post=this.posts.find(post=>post.id===id) return post},getPostByNum(num){const post=this.posts.find(post=>post.num===num) return post},getAvatarByUid(uid){const avatar=this.usersMap.get(uid)?.avatar if(!avatar){return this.getRandomAvatar()} return avatar},getAvatarByPostNum(num){const post=this.posts.find(post=>post.num===num) if(!post){return this.getRandomAvatar()} const uid=post.uid return this.getAvatarByUid(uid)},getRandomAvatar(){const num=Math.floor(Math.random()*100) return "https://randomuser.me/api/portraits/men/"+num+".jpg"},getUrlByUid(uid){const url=this.usersMap.get(uid)?.url if(!url){return ""} return url},getTextByPostNum(num){const post=this.posts.find(post=>post.num===num) if(!post||!post.content){return '点击跳转到#'+num+'查看'} const parser=new DOMParser() const doc=parser.parseFromString(post.content,'text/html') const text=doc.body.textContent||'' return text.slice(0,100)},addHeadingIds(){const content=document.getElementById('post-content-0') if(!content){this.nav.showTOC=false return} const headings=content.querySelectorAll('h2, h3, h4') headings.forEach((heading,index)=>{if(!heading.id){heading.id=`toc-nav-${index}`}}) if(headings.length==0){this.nav.showTOC=false}},async doSearch(keywords){this.search.loading=true try{const response=await axios.post('/fapi/v1/search',{keywords:keywords,}) if(response.data.code===0){if(response.data.data.hash&&response.data.data.hash.length===32){window.location.href="/s/"+response.data.data.hash}else{this.failureAlert('搜索失败: 搜索服务异常')}}else{this.failureAlert('搜索失败: '+response.data.msg)}}catch(error){this.failureAlert('搜索失败: '+error)} this.search.loading=false},debounce(fn,delay){let timer=null return function(...args){if(timer)clearTimeout(timer) timer=setTimeout(()=>{fn.apply(this,args)},delay);};},},watch:{'nav.post.targetPage':{handler:async function(newV,oldV){this.toPage()},immediate:false},},} const vuetify=createVuetify({defaults:{global:{ripple:true,},},}) const app=createApp(App) app.use(vuetify).mount("#app")