Sanjiyan - if you want those to be different widths, easiest way would be to make each section its own table...

Oh yeah, btw.... I was experienceing forum slowdown's, especially during peak time, and it was the worst on the forumhome... well I ran the sql explain stuff and found out that the line:

was causing a major slowdown because there was no index on post.dateline, if you add an index on it (and thread.lastpost for good measure since it has a similar query) you should see a nice speed improvement, especially if you have a good number of posts (my forum is approaching 400,000).

my avatars dont display, any help?

[QUOTE]05-01-03 at 07:18 PM eoc_Jason said this in Post #402
Oh yeah, btw.... I was experienceing forum slowdown's, especially during peak time, and it was the worst on the forumhome... well I ran the sql explain stuff and found out that the line:

PHP Code:

---

$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'"); 


---

was causing a major slowdown because there was no index on post.dateline, if you add an index on it (and thread.lastpost for good measure since it has a similar query) you should see a nice speed improvement, especially if you have a good number of posts (my forum is approaching 400,000).

easiest way would be to use phpmyadmin, you can just click the index button on the dateline column in the post table. Or, if you know how to use MySQL from the command line, let me know and I can tell you how to do the Alter Table command.

i see

I need help I must of done something wrong.

The hack works great when your loged in but when your a guest its all out of wack.

http://www.hardwaregeeks.com/board see what I mean

anyone know how to help I tried editing templates but it just made me angry I couldn't figure it out

It looks like you are missing (or have an extra) table column somewhere....

I would go through the templates and count them up to make sure they all match...

Ah.....this hack is simply the gift that keeps on giving. I love it, thanks!

We just installed it over on our brand new forum, it looks great:
http://www.thedigitalreview.com/forum/

Jason, thanks for the heads up about adding an index to post.dateline and thread.lastpost as well. We did that too.

Awesome hack, I really like it.

will this work on vb2.3.0????