Welcome Panel

Staff Warning: Before installing this hack, please read through the the thread and install on a testboard first. Do not install this on a forum with a lot of posts.

Hello,

I May in paratage my welcome panel which I translated into US since I do not speak this language.


This hack allow you to add a welcome panel on home page of your forum.
It displays the avatar, quick statistics of the forum and informations on your privates messages.

Full plugins


This hack can be not distributed on other sites only vbulletin-fr.org and vbulletin.org.

Thank you

[Loki12]

Originally Posted by Snatch

If i enable the plugin, the complett Server becomes a very high load.

14:00:31 up 1 day, 13:09, 1 user, load average: 30.80, 29.73, 21.92

And a MYSQL Prozess with very high mem and CPU usage.

hmmm....

The same happened with me yesterday when I tried to install this ... so much so, that my host suspended my account!! I had to make phonecalls to sort it out. I think I won't risk this again, and give it a miss ... :ermm:

[Andreas]

Jeez!

PHP Code:

$welcomestatss = $db->query("
                SELECT post.dateline, thread.lastpost, user.joindate
                FROM " . TABLE_PREFIX . "post AS post
                LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON(thread.firstpostid = post.postid)
                LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
                WHERE 1=1
"); 


This query selects ALL posts ... every time you visit Forumhome.
Doesn't surprise me that this causes HEAVY load.
This query must be optimized to process only thos posts that are newer then today midnight or last visit (whatever is older).

Furthermore the "Template-Caching" isn't good:

PHP Code:

$globaltemplates = array_merge($globaltemplates, array('welcome_panel'));
cache_templates($globaltemplates, $style['templatelist']);
unset($globaltemplates); 


This code should be removed.

And the following put in Hook cache_templates:

PHP Code:

$globaltemplates = array_merge($globaltemplates, array('welcome_panel')); 


[Snatch]

Can anybody fix this ?

[Cloudrunner]

Originally Posted by Snatch

Can anybody fix this ?

After this hack CRASHED my server and my host yelled at me for an hour today, I've decided to fix this damned thing from scratch. I'm letting the author know here that I'm using his concept, but will be redoing it from step 1, it is not a copyright infringement issue since I will be rewriting this without anything to go on other than the images supplied. I'm asking the author of this to PM me if there is a problem with me doing this, but since it's loading 90% of the servers that it's installed on (if not crashing them completely), I'm starting on this tonight.

If there is a problem with this, let me know and I will halt production, if not then the author will get credit on my posting as the concept inspiration.

[Andreas]

Originally Posted by Snatch

Can anybody fix this ?

I could ... but it's not my hack so I can't.

[Cloudrunner]

Originally Posted by Snatch

Can anybody fix this ?

I'm in final testing of this redo, and it's taken up alot less resources, all in all it only adds one major query, and four COUNT(*) queries to the system (I'm not sure what the overhead on that is, I'm trying to compress those four into one, but haven't succeeded thus far).

Anyway, I'll give the author of this thread until 12 PM, EST, 4 July 2005 to PM me with a cease and decist order, if I haven't gotten one by then I will release my version with credit for the idea to this thread's author.

[Otikeu]

this modification looks great! I'm wondering, do you have a vB3 edition? So I could use this for my vBulletin v3.0.7 board?

thanks in advance.

[Loki12]

Originally Posted by Otikeu

this modification looks great! I'm wondering, do you have a vB3 edition? So I could use this for my vBulletin v3.0.7 board?

thanks in advance.

Wait for an update before you install, and save your server and hosting account !! I narrowly escaped permanent suspension because of this hack.

[Cloudrunner]

Since this modification was killing servers, and almost got me booted off of my LIFETIME account (REALLY pissed off about that), I redid this mod from scratch using Megatekno's conceptual idea as basis. I have not received a "Cease and Decist" order from the author since posting my intentions last night, so I have released my version here: https://vborg.vbsupport.ru/showthread.php?t=91624

If my posting this here is not acceptable feel free to remove it, but I do think that since the hack was killing servers people need to know that it will prolly kill theirs too if they install this one.

[MindTrix]

I installed this without reading every page and now i cant anything on my site :s Every page wont load not even the admincp