im not sure if you did, if you copied the header from header and copied it into index_header

it would display your header :P

and take that awful music off your page :\


if you dont want that white stripe, find

and replace it with
that is on your index_header

white stripe is still their. If I remove the logo the stripe goes away. But once a logo is inserted, it creates that table with the white background it.

I tried what you guys said but nothing has helped yet. I put the code back to the way it was so that is what you are seeing now.

If you'll add 'index_rotm' and 'index_buddy_none' to the templatesused section at the top of the file, that will remove 2 of the queries. Apparently 4 others are coming from your vBstats hack in your global.php file...


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

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

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



As for the polls, make sure that you have the poll templates and that you have "RAND" entered for the polls forum id.
The threads from you private forums will only be visible to those who have permission to view them, assuming you have your forum permissions set correctly. ;)

this should get rid of your white line problem. altho if you like it on your forums it will cause a problem

where is the templates used section? Is it in the global.php file also under start templates

$templatesused.='gobutton,timezone,username_logged out,username_loggedin,phpinclu de,headinclude,header,footer,forumjumpbit,forumjum p,nav_linkoff,nav_linkon,navba r,nav_joiner';
$templatesused.=',pagenav,pagenav_curpage,pagenav_ firstlink,pagenav_lastlink,pag enav_nextlink,pagenav_pagelink,pagenav_prevlink,mi crostats';

what are you trying to take out?

I figured out the templates thing was in myvbindex.

As far as the polls random thing I am confused. I only want the polls picked at random from the polls forum only. Dont I have to change some code in the myvbindex file for this?

no idea on my part, as far as i know its not a built in thing :\

Also here is the explain thing for my forums, can you show me how to get rid of some queries their?

Query: SELECT template FROM template WHERE title='options'
Time before: 0.07497501373291
Time after: 0.07695198059082

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>1059168462 AND sessionhash='91adba9914cb16019f205696dda10b35' 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.09148097038269
Time after: 0.092326998710632

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.093616008758545
Time after: 0.095041990280151

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.097440004348755
Time after: 0.098170042037964

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 ('forumhome_birthdaybit','error_nopermission','for umhome_pmloggedin','forumhome_ welcometext','forumhome_logoutcode','forumhome_new posts','forumhome_todayposts', 'forumhome_logincode','forumhome_loggedinuser','fo rumhome_loggedinusers','forumh ome_lastpostby','forumhome_moderator','forumhome_f orumbit_level1_nopost','forumh ome_forumbit_level1_post','forumhome_forumbit_leve l2_nopost','forumhome_forumbit _level2_post','forumhome','forumhome_unregmessage' ,'index_rotm','index_buddy_non e','gobutton','timezone','username_loggedout','use rname_loggedin','phpinclude',' headinclude','header','footer','forumjumpbit','for umjump','nav_linkoff','nav_lin kon','navbar','nav_joiner','pagenav','pagenav_curp age','pagenav_firstlink','page nav_lastlink','pagenav_nextlink','pagenav_pagelink ','pagenav_prevlink','microsta ts')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.099313974380493
Time after: 0.11214196681976

table type possible_keys key key_len ref rows Extra
template range title title 32 87 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.1307510137558
Time after: 0.13244700431824

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

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

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

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

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.13570702075958
Time after: 0.13771498203278

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

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.14379394054413
Time after: 0.14503705501556

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

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

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
Time before: 0.14890003204346
Time after: 0.14967596530914

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

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

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND dateline>1059165043 AND folderid=0
Time before: 0.15060794353485
Time after: 0.15190196037292

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

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

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

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

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

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
Time before: 0.15628504753113
Time after: 0.15683901309967

table type possible_keys key key_len ref rows Extra


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

Query: SELECT COUNT(*) AS posts FROM post
Time before: 0.15768694877625
Time after: 0.15807497501373

table type possible_keys key key_len ref rows Extra


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

Query: SELECT COUNT(*) AS threads FROM thread
Time before: 0.15872097015381
Time after: 0.15909194946289

table type possible_keys key key_len ref rows Extra


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

Query: SELECT userid,username FROM user WHERE userid=390
Time before: 0.15973997116089
Time after: 0.16027796268463

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

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

Query: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
Time before: 0.16230797767639
Time after: 0.16545104980469

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

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

Query: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='6'
Time before: 0.17623496055603
Time after: 0.17706000804901

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

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

Query: SELECT forumid,accessmask FROM access WHERE userid='1'
Time before: 0.17811703681946
Time after: 0.17866396903992

table type possible_keys key key_len ref rows Extra
access ref userid userid 4 const 1 Using where

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

Query: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
Time before: 0.17950904369354
Time after: 0.18144702911377

table type possible_keys key key_len ref rows Extra
moderator index userid 6 42 Using index; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 moderator.userid 1

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

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059168462
Time before: 0.18493902683258
Time after: 0.18557298183441

table type possible_keys key key_len ref rows Extra
session ALL 4 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>1059168462
ORDER BY invisible ASC, username ASC
Time before: 0.29781603813171
Time after: 0.29889500141144

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

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

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

Time before: 0.42030394077301
Time after: 0.42234098911285

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

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

Page generated in 0.40744400024414 seconds with 24 queries,
spending 0.039765119552612 doing MySQL queries and 0.36767888069153 doing PHP things.
Query: UPDATE session SET lastactivity=1059169362,location='/forums/index.php?explain=1' WHERE sessionhash='91adba9914cb16019f205696dda10b35' Time before: 0.47847700119019 Time after: 0.47915899753571
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059169362,inforum='0' WHERE userid='1' Time before: 0.47937405109406 Time after: 0.48000800609589

if you red the install it would tell you what options add querrys. and unless your server is under super high load, i wouldnt worry so much about your querie count