<% Dim P_TAGS_SYSURL,P_TAGS_DESC P_TAGS_SYSURL = "tags.asp" P_TAGS_DESC = "日志标签" Sub Tags_UserAdd(byval sTags,byval sUserId,byval slogId) If sTags="" Then Exit Sub Dim i,j,iCount,aTags,TagId,sTag,sTagsId Dim rst Set rst=Server.CreateObject("ADODB.RECORDSET") sTags = TagsFilter (sTags) aTags=Split(sTags,P_TAGS_SPLIT) j=0 For i=0 To UBound(aTags) sTag = aTags(i) sTag=oblog.filt_badword(EncodeJP(ProtectSql(sTag))) 'Must >=2 And Not bad One If Tags_CheckTag(sTag)=1 Then '如果发了关键字则直接跳出函数 If oblog.chk_badword(sTag) > 0 Then Exit Sub 'For System rst.Open "select * From oblog_Tags Where Name='" & Trim(aTags(i)) & "'",conn,1,3 If rst.RecordCount=0 Then rst.AddNew rst("Name")=sTag rst("iNum")=1 rst("LastUpdate")=oblog.ServerDate(Now) rst.Update rst.close rst.Open "select * From oblog_Tags Where Name='" & Trim(aTags(i)) & "'",conn,1,3 if rst.eof then TagId=0 else TagId=rst("TagId") end if Else TagId=rst("TagId") rst("iNum")= rst("iNum")+1 rst("LastUpdate")=oblog.ServerDate(Now) rst.Update End If rst.close 'For Users rst.Open "select * From oblog_UserTags Where UserId=" & sUserId &" And logid= " & slogId &" And TagId=" & TagId ,conn,1,3 If rst.RecordCount=0 Then rst.AddNew rst("userid")=sUserId rst("logid")=slogId rst("tagid")=TagId rst("iNum")=1 rst.Update End If rst.close j=j+1 If j=1 Then sTags=sTag sTagsId=TagId Else sTags=sTags & P_TAGS_SPLIT & sTag sTagsId= sTagsId & P_TAGS_SPLIT & TagId End If End If Next 'Update two fields Call conn.Execute("Update oblog_log Set logtags='" & sTags &"',logtagsid='" & sTagsId &"' Where logid=" & slogId) Set rst=Nothing End Sub Sub Tags_UserEdit(byval sTags,byval sUserId,byval slogId) 'Delete all first Call Tags_UserDelete(slogId) 'Re-Add Call Tags_UserAdd(sTags,sUserId,slogId) End Sub Sub Tags_UserDelete(byval slogId) Dim i,j,iCount,sTags,TagId Dim rst Set rst=Server.CreateObject("ADODB.RECORDSET") 'Get All tags from this blog rst.Open "select tagid From oblog_UserTags Where logid In (" & slogId & ")" ,conn,1,1 If rst.Eof Then rst.Close Set rst=Nothing Exit Sub End If Do While Not rst.Eof 'update number Call conn.Execute("Update oblog_Tags Set iNum=INum-1 Where TagId=" & rst("tagId")) rst.Movenext Loop rst.Close Set rst = Nothing Call conn.Execute("Delete From oblog_UserTags Where logid In (" & slogId & ")" ) Call conn.Execute("Update oblog_log Set logtags='',logtagsid='' Where logid In (" & slogId & ")") End Sub 'tag infomation for blog Function Tags_ShowForBlog(byval sBlogid,utruepath) Dim i,aTags,aTagsId,sContent,sTags,sTagsId,sUserId Dim rst Set rst=conn.Execute("select logtags,logtagsid,userid From oblog_log Where logid=" & sBlogid ) If rst.Eof Then Set rst=Nothing Exit Function End If If IsNull(rst(0)) Then Exit Function If IsNull(rst(1)) Then Exit Function sTags=Trim(rst(0)) sTagsId=Trim(rst(1)) sUserId=rst(2) Set rst=Nothing If sTags="" OR sTagsId="" Then Tags_ShowForBlog="" Exit Function End If aTags=Split(sTags,P_TAGS_SPLIT) aTagsId=Split(sTagsId,P_TAGS_SPLIT) For i=0 To UBound(aTags) sContent = sContent&"" & aTags(i) & " " Next Tags_ShowForBlog = "

标签："&sContent&"

" End Function 'user tag list Function Tags_UserTags(byval sUserId) Dim sContent,sSql,rst Set rst=Server.CreateObject("ADODB.RECORDSET") sSql = "select top 10 a.TagId,a.Name,b.TagNum From oblog_tags a," sSql = sSql & "(select Count(*) as TagNum,TagId From oblog_UserTags Where userid=" & sUserId & " Group By TagId ) b Where " sSql = sSql & "a.tagid=b.tagid And a.iState=1 Order By b.TagNum Desc" rst.Open sSql,conn,1,1 If rst.Eof Then sContent="" Else Do While Not rst.Eof sContent=sContent & "" & rst("Name") & "(" & rst("TagNum") & ")
" & VBCRLF rst.MoveNext Loop End If rst.Close Set rst=Nothing Tags_UserTags=sContent sContent="" End Function 'user blog list with tag keyword Function Tags_TagBlogs(byval sUserId,byval sTagId) Dim sContent,sSql,rst sSql="select a.userid,b.* From " If sUserId<>"" Then sSql=sSql & " (select logid,userid From oblog_usertags Where userid=" & sUserId & " and tagid=" & sTagId &") a ," sSql=sSql & " (select topic,addtime,logid,author,logfile From oblog_log where userid=" & suserId & ") b Where a.logid=b.logid " Else sSql=sSql & " (select top 100 logid,userid From oblog_usertags Where tagid=" & sTagId &") a ," sSql=sSql & " (select topic,addtime,logid,author,logfile From oblog_log ) b Where a.logid=b.logid " End If sSql=sSql & " order By b.logid Desc" Set rst=conn.Execute(sSql) If rst.Eof Then sContent="" Else Do While Not rst.Eof sContent=sContent&"

   " & rst("author") & "      "& rst("topic")&"    "&rst("addtime")&"

"& VBCRLF rst.movenext Loop If sContent="" Then sContent="

" & VBCRLF & sContent & "

" & VBCRLF End If Set rst=Nothing Tags_TagBlogs=sContent sContent="" End Function Function Tags_HotTags() Dim sContent,rst,sSql,i Set rst=Server.CreateObject("ADODB.RECORDSET") sContent = vbcrlf & "" & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sSql="select a.*,b.UserNum From (select top 100 tagId,Name,iNum,LastUpdate From oblog_Tags Where iNum>0 And iState=1 Order By iNum Desc) a," sSql=sSql & " (select Count(*)as UserNum ,tagid From oblog_UserTags Group By tagid) b Where a.TagId = b.TagId Order By a.iNum Desc" rst.Open sSql,conn,1,1 i=0 Do While Not rst.Eof If i Mod 2 =0 Then sContent = sContent & " " & VBCRLF Else sContent = sContent & " " & VBCRLF End If sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf sContent = sContent & " " & vbcrlf i=i+1 rst.movenext Loop rst.close Set rst=Nothing sContent = sContent & " " & vbcrlf sContent = sContent& "

" & P_TAGS_DESC & "	引用数	人气	最后更新时间
" & rst("Name") & "	" & rst("iNum") & "	" & rst("UserNum") & "	" & mid(formatdatetime(rst("LastUpdate"),2),1) & "

" & vbcrlf Tags_HotTags=sContent sContent="" End Function Function Tags_SearchTag(byval sTagName) Dim sSql,rst,sContent,i sTagName=EncodeJP(sTagName) sSql="select * From (select top 100 * From oblog_tags Where name Like '%" & sTagName & "%' And iState=1) a Order By a.iNum Desc" Set rst=conn.Execute(sSql) If rst.Eof Then sContent="没有查询到包含" & sTagName & "" & P_TAGS_DESC Else i=1 Do While Not rst.Eof sContent= sContent & i & ":  " & Replace(rst("name"),sTagName,"" & sTagName & "") & "(" & rst("iNum") & ")
" & VBCRLF rst.Movenext Loop End If Set rst=Nothing Tags_SearchTag=sContent sContent="" End Function Function Tags_TagName(byval sTagId,byref o_TagName,byref o_Num,byref o_LastUpdate) Dim rst Set rst=conn.Execute("select top 1 * From oblog_Tags Where tagid=" & sTagid & " And iState=1") If rst.Eof Then Tags_TagName=-1 Else o_TagName=rst("Name") o_Num=rst("iNum") o_LastUpdate=rst("LastUpdate") Tags_TagName=0 End IF Set rst=Nothing End Function 'Tag Cloud '1:Cloud;0:List Function Tags_SystemTags(byval t) Dim sContent,sSql,rst,iFont,iFontSize,i Dim sSplit sSplit="    " & VBCRLF sSql="select top 100 * From oblog_Tags Where iNum>0 And iState=1 " If t=0 Then sSql= sSql & " Order By iNum Desc" Else If Is_Sqldata = 1 Then sSql= sSql & " Order By Newid()" Else Randomize sSql= sSql & " Order By Rnd(-(TagID+"&Rnd()&"))" End If End if Set rst=conn.Execute(sSql) If rst.Eof Then sContent="" Else Do While Not rst.Eof If t=0 Then sContent= sContent & "" & rst("Name")& "(" & rst("iNum") & ")" & sSPlit Else iFont=rst("iNum") Mod 100 If iFont=0 Then iFontSize=10 If iFont>-1 And iFont<40 Then iFontSize=12 + iFont If iFont >40 Then iFontSize=42 sContent= sContent & "" & rst("Name")& "" & sSPlit End If i=i+1 'If i Mod P_TAGS_PerLine = 0 Then 'sContent = sContent & "
" 'End If rst.Movenext Loop End If rst.Close Set rst=Nothing Tags_SystemTags=sContent sContent="" End Function 'Forbid Tag For Admin Function Tags_SystemForbid(byval sTagId) conn.Execute("Update oblog_Tags Set iState=0 Where TagId=" & sTagId) End Function 'Check Bad tags Function Tags_CheckTag(byval sTag) Dim aBadTags,i,lNumber '进行过滤 'aBadTags=Split(oblog.setup(80,0),vbcrlf) 'Tags_CheckTag =1 'Bad Tag is shortter than True Tag 'For i=0 To Ubound(aBadTags) ' If Instr(sTag,aBadTags(i)) Then ' Tags_CheckTag= 0 ' Exit Function ' End If 'Next '进行特殊字符的保护 For i=1 To Len(sTag) lNumber=ASC(Mid(sTag,i,1)) If lNumber<0 OR (lNumber>=45 And lNumber<=90) OR (lNumber>=97 And lNumber<=122) Then Else Tags_CheckTag= 0 Exit Function End If Next Tags_CheckTag =1 End Function Function GetUsersByTag(byval sTagId) Dim rst,sSql,sContent Set rst = Server.CreateObject("Adodb.Recordset") sSql = "select Top 100 b.userName,b.user_dir,b.user_folder From (select Userid From oblog_usertags Where Tagid=" &CLng ( sTagId ) & " Group By UserId) a,oblog_user b Where a.Userid=b.UserId" rst.Open sSql,conn,1,1 If rst.Eof Then sContent="没有符合条件的用户" rst.Close Set rst = Nothing End If i=0 Do While Not rst.Eof sContent=sContent & "" & rst("userName") & "
" rst.movenext Loop rst.Close Set rst = Nothing GetUsersByTag=sContent End Function Function GetUserInfo(byval sUserId) Dim rst,sUserPath Set rst = Server.CreateObject("Adodb.Recordset") rst.Open "select * From oblog_User Where Userid=" & sUserId,conn,1,1 If rst.Eof Then GetUserInfo="错误的用户信息" Else sUserPath= blogurl & rst("user_dir") & "/" & rst("user_folder") & "/index." & f_ext sUserPath=Replace(sUserPath,"//","/") GetUserInfo="" & rst("blogname") & "" End If rst.Close Set rst = Nothing End Function Function TagsFilter(ByVal sTags) Dim aTags , i ,strTemp aTags=Split(sTags,P_TAGS_SPLIT) For i = 0 To UBound (aTags) If Len(aTags(i)) > 1 Then strTemp=strTemp & "," & aTags(i) End if Next If Left(strTemp,1)="," Then strTemp=Right(strTemp,Len(strTemp)-1) TagsFilter = Replace(strTemp,"," ,P_TAGS_SPLIT ) End Function %>臸�l�-棒�
蒟h眃Q拤洓t ;�v瞅幷仉�
粞暢7;F&幯%D哨_v.r狅礒�-\鯝鮽{聯▄Vds�8L枨鳑鈎藮扻rs-擝趘SM脫E�3詣俀^骝t3e�*s囍� 擇绎n[o$�祮P\皭a蝰d@<萯﹨升瀓)5皯=V針i稷�耱�-篰謰�3W佷萟
�鲘_涎'��8嵔Q瓐�3z4蔳�)\宙鳦�缧&�鸡~� U 缲剸@8㈦BTMu扊хA~х�
� s暞G礩7K靍秃�'渠d郡t� `(銈�諘敝�-*堦mL恨��獊�!ю�拁Q係^躬G腹柂|7詗�洚鞗鐃鋖�3i媷薵iXtF��9趸熟髙AX,1��!呵L�Y<毰a跾%In閁鸫幰v�(櫏娤q廩岊匄M� T�嚀聀(Rj�#佐)y�欜�k� 鯔樭Cb,柰罭�^k颎+卨]肰Q嘘:�陡J墴創響Y,狨#阈U4�#肧坟[�+n貑#諳趒皮駲極w�5鯣�%皃2莎4滖甗鷞齄5X[[望籾7島炚礹孡渁５}濅胾�Y熺EK~絸�銬(]鉈[螦蕹_厚�疪滘V逯�7汘�部腛J?Г�3屘�3遏挜煒鄞鄾褞Ec嵗额擑薔眑��耆��輹輼缯比o裡[Q巬fo箴毸源镾gO�聒�u/2;n4ù褃]x�(鵲Q�8揁萝組�&� 鑿/瑞鐦宴寿=�<庞]鵯
乣u{頮���
� 5卧琑 /貄fGF镂磻V愒摮虦@飛��D宖霴湒�4�鋔漀巑魄y篴C烛��HA幫7顤M鵛k躺颟祮儀->/䶮萦�8E唋篁�阓鄩迌瓵途=m坳h豘C\2瑮F�7犏~q3坝s馕W偏0b� 惺2�瓬贷aA�鱄}�\氅鋮Q��!嶡螒(&r枳邹蔨龙A#jIZ絺U�嫇fv;&$l.c疪{鑠�娜gqt�0;X鞰麧え窇璼绸Pk壍⿷�1�?� ┝�j硁櫀W�(�5K�.U4尖蕭意3蔒��鮶F签Jcg�󚙯�;u�畟 ;偗瞋 c绲:zㄣ舙�/603v�.�9^?x9�;苓�稑+O]m赠襩"冖缔j荢7�9萌�瓕Q~d�齝_Q1嬜鰼(氉繂P俣爻�>}�#衭)《b弳溭颰�y莄瞲禯傿唪(O e電�)朊n bF��%O顿,a)3%毘Ul楏︳+唕g-觴g2-�3_l� m父汲ZN驋ㄝ哔O)銡�#敷B+h诤4特�[]科鷐a婖ㄊ邽攸@彔E葯繊肆n齯'O蜖�=诊补u毡礳名0$_ 塪蜝啲s,(�-[5EBE單\嘂曇邫�+TュL傩垮;rz娤釅穌 揬屗� �d$&0畕>k{-蛍雌�&]e�qv閟洃偟e�.t璐R⒂硴�-势以锵琏9渑薦�例iJ�/t鄮� qL g躑绑鏓ゎ扲�w�-(gB�V�2斓sぇ唴xGy�7&�&�4q{�<~嫵�-擎h6k�W?~zQ+/1wt顡禡�
嘪灳�7斃翚�<]Kb.g`绯妷聘�&暏i裿锓6SL桻刁�>栊'q�,覵I�8Ml崅�+$�陞Lw>覈题~,︾j釢U[Y�(i,�3�?0迬诶勼�*�吲*蹧倣娐辉7H}�@玨v逆�%邱NU�%洨g�園逩{磩骛骖#a蔗�?k�'/氱倲E#\$A� KM]l}齖�
}暭塢掦I堉醹標#怉�9W識靵痵"剘蔪 v晚W涣嬁鉫覜�!W7�"� �纈凬採鸒驌�/饲襺ig赨y贺=篝&y򼵝�7�蒟膽匋WQSk[YO音Ah�"圑畠膰箣焉宋蕺��9-Y廃羼厝讓�/}P9翜﨩髅澦�獁簡唬tqM c殈�蜨瞣\剆羌�-}|爷#蔜� 朑荂?�T囆e(贄h�}頰贲鹵鶏諂z�"矼臑�笹c暻埦苈肬r*�%暱� 吀�%晨sDb峇敜遁?�o5Hz0恌�
$D眈楖3a筝q逘L6忪2禎��`朱橅�
t@栥N)蹯#坹� �⒏�"B綰麛梫� 餺峊庄
=歕歪{�#d�5@粵褱鸃诸�8jp'~庁愝]
燇烳�M虄+w腉鑂(鵜O=&破砎k�脱;躥榁.餄L饳L訵6S 誣鯅]昰楔贀稀謝鎥輘;�2lx�6?�r崆|�P\玻kS鹴)3d啜娤/Y麈羱乺�氷+l{R=磠餤6'察蝽閺转H爷槢%c花�芯�/祒⌒Py�.w7im蘍掃�(竫vru�>�7韂碩埻溡m�5,�!�:_堺L�铯_鳴b�λ8攦u侪, T堹 9qi.闀洜K/獚Ec徏EYy~咣w钚訣囧彧2燔倬繳�/S �=Ⅱ袂�sz锪Eb~4�
3Q斑�1违桵m潧轗��5�87媀a!xXH袤癄q姮嘵�1斗� 蜆殑S曋-��)CE,m帳}�/G葄P�2泪υ��幬睎lx顈T-頶跦筙c匍 騆宠=7愌J�$蒊m兼蛔谩o瞂m穉逊阡x軶K�7呞鵚j[敫鄨骊樊璿��"#� _蔍俉蓲$�艋斜钫x�:\凉氄曲桕%澔��:{@筐暩弼鎙魌�9�&d
�%蕈q~B箑贑(縮QI(2⒁鏖8Of�-&剧e0鑌�4挨q婘R+nf茷厮dsш杢^鷵掬剀�$)\;�*\け踢錩圃� 賄砾r壷n太,!眜�*�挃a骬])��?x@e^wwzl7m坴楇搭覠篪4冀樠Iw�矡檛x~鞩茷M�4`b葍擇vY�O鱴緽�矿廅:p蓖呵甎<% dim CurrentPage '首页显示分页使用 public Function detable(strHTML) Dim objRegExp, strOutput Set objRegExp = New Regexp strOutput=strHTML objRegExp.IgnoreCase = True objRegExp.Global = True objRegExp.Pattern = "]*>" strOutput = objRegExp.replace(strOutput, "") objRegExp.Pattern = "]*>" strOutput = objRegExp.replace(strOutput, "") objRegExp.Pattern = "]*>" strOutput = objRegExp.replace(strOutput, "") objRegExp.Pattern = "]*>" strOutput = objRegExp.replace(strOutput, "") objRegExp.Pattern = "]*>" strOutput = objRegExp.replace(strOutput, "") objRegExp.Pattern = "]*>" strOutput = objRegExp.replace(strOutput, "") objRegExp.Pattern = "") profilthtm = strOutput Set objRegExp = Nothing end function public Function RemoveHTML(strHTML) ON ERROR RESUME NEXT Dim objRegExp, strOutput Set objRegExp = New Regexp objRegExp.IgnoreCase = True objRegExp.Global = True objRegExp.Pattern = "<.+?>" strOutput = objRegExp.replace(strHTML, "") strOutput = Replace(strOutput, "<", "<") strOutput = Replace(strOutput, ">", ">") RemoveHTML = strOutput Set objRegExp = Nothing End Function public Function filtimg(strHTML) Dim objRegExp, strOutput If oblog.cacheConfig(44) = "1" Or oblog.cacheConfig(43)>0 then Set objRegExp = New Regexp strOutput=strHTML objRegExp.IgnoreCase = True obj