Welcome Panel [Final]

Well, with over 200 downloads and 32 problem free install's, I though it time to take this out of the beta hacks forum (note, there are no changes to the file in the beta forum, so no need to re-download if you already have the hack installed).

I put this together originally as a walkthrough for an admin friend, and thought someone might find it useful. Althouth technically, my contribution is a couple of simple template edits, it does contain hacks posted previously.

Like I said, it's a combination of 2 previously relesed hacks (both credited fully). One by Firefly (avatar hack) and one by MrLister (since your last visit). It combines both of these hacks into a welcome panel at the top of the BB, just like the one here and on a few other sites. I'm pretty much a newbie to vB hacking, and struggled to put this together myself (couldn't find any instructions/hacks etc), but I think I've done an OK job. Maybe this will save a few headaches to others like myself

Anyway, here's a pic to illustrate the hack/edit (or whatever it is )





You can see a working verion of this hack here:

The Genome Collective

Thanks to Firefly and MrLister for providing the PHP hacks in this err, whatever

(BTW, if this is in the wrong forum, please (mods) feel free to move it)

Happy Christmas everyone.

here it is:

edit: updated version number to 2.2.6 because it works There are no changes to the files - it's not a new release. Thanks. /edit

[eoc_Jason]

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

[eoc_Jason]

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).

[Cicada]

my avatars dont display, any help?

[KimG]

[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).

[eoc_Jason]

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.

[Bulleh]

i see

[Mike11212]

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

[eoc_Jason]

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...

[atomic fireball]

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.

[saj]

will this work on vb2.3.0????