[TECK]

first of all, you are using vb224, in other words you expose yourself (security issues).

second, all those queries (example):
"SELECT template FROM template WHERE title='P_themeheader' "
are just template names that you forgot to cache into $templateused. for each title you forgot, you add a query.

third, you have few hacks that you van spare them... ex member of the day, etc. you have a busy board, so think server wise...

if i would be you i would upgrade asap, to 227 and start hacking slowly again the new board, checking aways the queries.
you could also install in your pc vbulletin so you can do your home work there first.
read this tutorial i made:
https://vborg.vbsupport.ru/showthrea...threadid=39482

let me know if you have any questions...