[buro9]

There's a pretty serious problem with your memberlist pages if you have installed this hack.

The hack changed the PRIMARY KEY on the customprofilepic table, and this causes a massive degradation in the speed of the query that memberlist.php uses.

What happens is documented in this thread along with the fix:
https://vborg.vbsupport.ru/showthread.php?t=66765

Note that the fix merely adds an index to restore it more closely to the vBulletin defaults by adding an index back to the table in place of the removed PRIMARY KEY.

I'm pretty furious about it though. IMO no hack should ever touch the vBulletin indexes and schema... they should only extend it. This hack broke that, and in turn created a hundred fold drop in performance of the regular vBulletin memberlist.php

This isn't the first time hacks have done dumb things, but this one was painful because of the 6+ seconds lock on the database table and the resulting performance drop elsewhere on the board.

Add the index back if you run this hack.