Well I am willing to pay what a fair salary is for a web designer. This is if he wanted to be hired that is. Tigga email me about this, instead of replying here if you are interested.

arracing - The query count does sound high since you don't have some of the more intensive options turned on. Once you have the templates re-installed though it should fix that.
Right now I'm working full time for a web design company, plus I also run a club/rave promotion company. I haven't had that much time to take on extra projects lately, but if you'd like to email me with some more details about the site, what you'd like done, and a timeframe of when/how fast the work needs to be done, then I can let you know if it's something I would be able to do and give you an estimate if so. :)

OMG Tigga I can't wait till it's released.. It's gonna be the first hack I install.. HURRRRRY. Your site looks great too.

i assume you mean for vb3?

where is that white background coming from that is behind the main logo at the top left. I want it to be that baby blue color. I cannot find which template is calling that white background. Do u know?

Also I re-installed the templates but the query count still remained high.

two ways to fix this, go to your templates find header. open it and copy it, then go to myvbindex > index_header i think and open that, and paste it in there, that should work

i belive the other is to change the gettemplate function at the top, instead of index_header, change it to header

try the top one first however

Arracing - You should modify your index_header template as Faranth suggested, but if you copy your normal header be sure to add $bburl in front of each of the links, otherwise they'll be broken. ;)
As far as the queries, if you'd like to put your server in debug mode (Add $debug=1; somewhere in your admin/config.php file), then go to the url http://yoursite.com/index.php?explain=1
If you'll do that and post the results here I'll see what is causing the extra queries.

im getting rather good with this one :D

I did what you guys said with the headers and it didnt remove the white stripe. The stripe shows up in my forums header anyways, I just dont want it to show on myvbindex page.

Query: SELECT template FROM template WHERE title='options'
Time before: 0.067090034484863
Time after: 0.069048047065735

table type possible_keys key key_len ref rows Extra
template ref title title 30 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1059162995 AND sessionhash='dc0592577954f6fe5d940af59f88d8c3' AND (host='68.41.47.235' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;'
Time before: 0.081784009933472
Time after: 0.082612991333008

table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1

--------------------------------------------------------------------------------

Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.083825945854187
Time after: 0.085193991661072

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
Time before: 0.087414979934692
Time after: 0.088251948356628

table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT template,title
FROM template
WHERE (title IN ('index','index_header','index_footer','headinclud e','index_welcometext','index_ logincode','index_buddy','index_buddylist','index_ buddypmlink','forumhome_logged inuser','index_online','index_search','index_welco metext_avatar','index_calendar ','index_calendar_todaysevents','index_weather','i ndex_custom1','index_custom2', 'index_stats','index_birthdaybits','index_threadbi t','index_newsbits','index_new s_adminopts','index_news_comments','index_news_com mentnull','index_news_readmore ','index_newsbits_rating','index_newsbits_signatur e','index_newsbits_avatar','in dex_newsbits_sendtofriend','index_newsbits_printab le','showthread_ratingdisplay' ,'index_pollresult','index_polloption_multiple','i ndex_polloption','index_pollop tions','index_pollresults_voted','index_pollresult s_closed','index_pollreview',' index_pollresults','index_polldiscuss','index_poll edit','','gobutton','timezone' ,'username_loggedout','username_loggedin','phpincl ude','headinclude','header','f ooter','forumjumpbit','forumjump','nav_linkoff','n av_linkon','navbar','nav_joine r','pagenav','pagenav_curpage','pagenav_firstlink' ,'pagenav_lastlink','pagenav_n extlink','pagenav_pagelink','pagenav_prevlink','mi crostats')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.089380025863647
Time after: 0.10731399059296

table type possible_keys key key_len ref rows Extra
template range title title 32 131 Using where; Using filesort

--------------------------------------------------------------------------------

Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1263689994812
Time after: 0.12737095355988

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.12776899337769
Time after: 0.12833797931671

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.12861597537994
Time after: 0.12964296340942

table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where

--------------------------------------------------------------------------------

Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13033998012543
Time after: 0.13225495815277

--------------------------------------------------------------------------------

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.13749396800995
Time after: 0.13856601715088

table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT count(*) AS count FROM post WHERE dateline>='1059152592'
Time before: 0.14228403568268
Time after: 0.35819399356842

table type possible_keys key key_len ref rows Extra
post ALL 26582 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid='1' AND messageread='0' AND folderid='0'
Time before: 0.35933005809784
Time after: 0.36073505878448

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT userid,username,invisible,lastactivity,lastvisit FROM user WHERE (user.userid='143' OR user.userid='134' OR user.userid='160' OR user.userid='121' OR user.userid='118') AND lastactivity > 1059162995 AND lastvisit!=lastactivity ORDER BY username
Time before: 0.36296999454498
Time after: 0.36397504806519

table type possible_keys key key_len ref rows Extra
user range PRIMARY PRIMARY 4 5 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT template FROM template WHERE title='index_buddy_none' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
Time before: 0.36498701572418
Time after: 0.36581897735596

table type possible_keys key key_len ref rows Extra
template range title title 32 2 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059162995
Time before: 0.36761403083801
Time after: 0.36813902854919

table type possible_keys key key_len ref rows Extra
session ALL 3 Using where

--------------------------------------------------------------------------------

Query: SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0 AND session.lastactivity>1059162995
ORDER BY invisible ASC, username ASC
Time before: 0.36893403530121
Time after: 0.36982703208923

table type possible_keys key key_len ref rows Extra
session ALL 3 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1

--------------------------------------------------------------------------------

Query: SELECT forumid,canview FROM forumpermission WHERE usergroupid='6'
Time before: 0.37197494506836
Time after: 0.37254595756531

table type possible_keys key key_len ref rows Extra
forumpermission ref ugid_fid ugid_fid 2 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT forumid,parentid,displayorder FROM forum WHERE displayorder<>0 ORDER BY parentid,displayorder
Time before: 0.37338399887085
Time after: 0.37498998641968

table type possible_keys key key_len ref rows Extra
forum ALL 51 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT thread.pollid, open, threadid, replycount, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters
FROM thread
LEFT JOIN poll ON (thread.pollid=poll.pollid)
WHERE forumid='71' AND thread.pollid!='0' ORDER BY poll.pollid DESC LIMIT 1
Time before: 0.37878203392029
Time after: 0.38135600090027

table type possible_keys key key_len ref rows Extra
thread ref forumid forumid 2 const 12 Using where; Using temporary; Using filesort
poll eq_ref PRIMARY PRIMARY 4 thread.pollid 1

--------------------------------------------------------------------------------

Query: SELECT smilietext,smiliepath FROM smilie
Time before: 0.38301599025726
Time after: 0.38529205322266

table type possible_keys key key_len ref rows Extra
smilie ALL 193

--------------------------------------------------------------------------------

Query: SELECT pollvoteid FROM pollvote WHERE userid='1' AND pollid='92'
Time before: 0.4006199836731
Time after: 0.40136098861694

table type possible_keys key key_len ref rows Extra
pollvote ref userid userid 8 const,const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT
threadid,thread.title,replycount,postusername,post userid,dateline,views,lastpost er,lastpost,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE open<>10 ORDER BY lastpost DESC LIMIT 10
Time before: 0.43457794189453
Time after: 0.45274901390076

table type possible_keys key key_len ref rows Extra
thread ALL 2639 Using where; Using filesort
icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1

--------------------------------------------------------------------------------

Query: SELECT thread.threadid,thread.title,replycount,postuserna me,postuserid,thread.dateline, views,thread.iconid,votenum,votetotal,postid,paget ext,allowsmilie,showsignature, signature ,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN post ON (thread.threadid=post.threadid)
LEFT JOIN user ON (user.userid=post.userid)

LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE forumid='66' AND isnews='Y' AND open<>10
GROUP BY thread.threadid
ORDER BY thread.threadid DESC LIMIT 10
Time before: 0.46166598796844
Time after: 0.46672296524048

table type possible_keys key key_len ref rows Extra
thread ref forumid forumid 2 const 8 Using where; Using temporary; Using filesort
post ref threadid threadid 4 thread.threadid 11 Using where
user eq_ref PRIMARY PRIMARY 4 post.userid 1
icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1

--------------------------------------------------------------------------------

Query: SELECT bbcodetag,bbcodereplacement,twoparams FROM bbcode
Time before: 0.48248398303986
Time after: 0.48327898979187

table type possible_keys key key_len ref rows Extra
bbcode ALL 9

--------------------------------------------------------------------------------

Query: SELECT eventdate,subject,eventid,public FROM calendar_events WHERE eventdate LIKE '2003-07-%' AND ((userid='1' AND public='0') OR (public='1'))
Time before: 0.76708197593689
Time after: 0.76792299747467

table type possible_keys key key_len ref rows Extra
calendar_events ALL userid 12 Using where

--------------------------------------------------------------------------------

Query: SELECT template FROM template WHERE title='index_rotm' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
Time before: 0.77690303325653
Time after: 0.77811396121979

table type possible_keys key key_len ref rows Extra
template range title title 32 2 Using where

--------------------------------------------------------------------------------

Query:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '1')
ORDER BY replacementsetid, replacementid DESC

Time before: 0.79495394229889
Time after: 0.79683399200439

table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 56 Using where; Using filesort

--------------------------------------------------------------------------------

Page generated in 0.78423702716827 seconds with 27 queries,
spending 0.28480398654938 doing MySQL queries and 0.4994330406189 doing PHP things.
Query: UPDATE session SET lastactivity=1059163895,location='/index.php?explain=1' WHERE sessionhash='dc0592577954f6fe5d940af59f88d8c3' Time before: 0.82737004756927 Time after: 0.8279869556427
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059163895,inforum='0' WHERE userid='1' Time before: 0.82818400859833 Time after: 0.82877898216248

I also noticed that my poll is not picking random polls from the poll menu. And Also in my latest threads, they are taking threads from private forums.