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

[nemesis01]

Hey, I installed this hack a while ago and it worked perfectly.I recently upgraded to 2.2.4, had a few problems but got it working in the end.Now I have another problem with it, it used to say something like 'There have been XX of new posts since your last visit' but now that part does not show up.I have checked the index.php file and the templates and they are all fine, can anybody help?

:disappointed:

[nemesis01]

Never mind, fixed it.

Think I am going mental, need more sleep.

[Airwaves]

@Frenck

One of the queries you said to run isnt valid - you had a ' where there shouldnt be one...

here they are correct

PHP Code:

ALTER TABLE `thread` ADD INDEX(`lastpost`); 
ALTER TABLE `post` ADD INDEX(`dateline`); 


[Frenck]

[QUOTE]Originally posted by Airwaves
@Frenck

One of the queries you said to run isnt valid - you had a ' where there shouldnt be one...

here they are correct

PHP Code:

ALTER TABLE `thread` ADD INDEX(`lastpost`); 
ALTER TABLE `post` ADD INDEX(`dateline`); 


[Jawelin]

Which kind of index table size increment should generate adding those two or three index upon dates ?
And how a search on could be measured faster ?

Thnx

[Frenck]

My "post" table size before creating the index:

Data 30,022 KB
Index 3,482 KB +
=============
Total 33,504 KB


After creating the index on dateline:

Data 30,022 KB
Index 4,276 KB +
=============
Total 34,298 KB


In my case the table has grown about 2.3698663%

[Jawelin]

Thank you very much for these numbers. What about speed increase performances ? Are they appreciable ?
(for example on lastpost searches or today's posts)

[Frenck]

If you took time to take a look @ a post of me... a little higer...

Ow well lets cut & paste...

before:

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1018738585'
Time before: 0.3487149477005
Time after: 1.9500440120697

as you can see, the query needs about 1.6 seconds to complete.
(about 100.000 posts in the forum)

after:

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1018738585'
Time before: 0.41155600547791
Time after: 0.41288495063782

Wel.. I really like the result... Just 0.001328 seconds for the query to complete.

I think this result is really worth the 2.3698663% growing :classic:

[Jawelin]

Very cool!
I added index on dateline fields in post, thread and user (join & lastvisit) ...
Now, with a small space occupied more, I have the fastest forumhome ever...

[Floris]

What is the URL to your forum? I want to have a looksy!