vb.org Archive - Welcome Panel

Page 5 of 7

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Welcome Panel (https://vborg.vbsupport.ru/showthread.php?t=83205)

Loki12

06-29-2005 07:48 PM

Quote:

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

06-29-2005 07:59 PM

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

06-29-2005 09:58 PM

Can anybody fix this ?

Cloudrunner

07-03-2005 11:27 PM

Quote:

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

07-04-2005 12:02 AM

Quote:

Originally Posted by Snatch

Can anybody fix this ?

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

Cloudrunner

07-04-2005 05:56 AM

Quote:

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

07-04-2005 10:00 AM

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

07-04-2005 06:30 PM

Quote:

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

07-04-2005 07:35 PM

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

09-03-2005 06:46 PM

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

All times are GMT. The time now is 04:58 AM.

Page 5 of 7

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01160 seconds Memory Usage 1,749KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: