bbs的树状算法的补充程序

80酷酷网    80kuku.com

  程序|算法ssql = "select gorders,glayer from bbs where gId=" & gId & " and goders> " & gorders & " order by goders "
rs1.Open sql, conn1, adOpenForwardOnly, adLockOptimistic '查询比父贴
‘order_value大的order_value
If (rs1.EOF And rs1.BOF) Then
If gLayer >= 8 Then '如果深度大于8,就设goerders,glayer跟回帖平行
gorders = rs1("gorders")
gLayer = rs1("glayer")
Else
gorders = gorders + 256
gLayer = gLayer + 1
End If
Else
nextvalue = rs1("gorders")
If (nextvalue - gorders) > 1 Then
gorders = Int((gorders + nextvalue) / 2)
gLayer = gLayer
Else '跟跟贴平行
gorders = rs1("gorders")
gLayer = rs1("glayer")
End If
End If

分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: