how to make limit showing

[ZiNgA BuRgA]

Look at how the rest of MyBB makes paging (in general, limits in select queries, take current page as an input variable).  Expect the complexity to go up a fair bit.