vb.org Archive

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 :(

MindTrix 09-03-2005 07:03 PM

If i delete cookies everything goes ok, but i cant actually log in with my admin account anymore since installing this :s Odd.

Capricia 09-29-2005 12:47 PM

I've installed this hack and really checked it over (read it over 6 times) to make sure I dind't do anything wrong, it doesn't show up for me and I'm all grrr about it.

Question if I put my back up back and then turn the hack back will it work if I install Cloudrunner's version?

*is bummed out about this*

EDIT

Ok so it's showing up but I have red x's instead of the images.. let me try and fix that.

Joshua5692 10-23-2005 06:14 AM

I am sorry I am so new to VB, I uploaded the images as directed, then uploaded the xml file via the ACP, as it was loading my browser froze. I shut down the browser after a few minutes, and tried to load our site, nothing.

It drew so much resources that it eventually killed our HTTP. I disabled Hooks with the config file, when the server rebooted the site was fine, but all hooks were disabled. I tried to find the plug-in to remove it, but it is not in my list!

So I tried to put the original config file back, and it crashed the server again after overloading it. I mean no disrespect to the coder, it looks great for the people it works for but how do I remove it?? It is not in my plug-in list.

Joshua5692 10-27-2005 01:02 PM

Please somebody, I am not asking for step by step instructions. A link would even suffice. Please, we are running our forum with all hooks disabled for 8 days now. We're just waiting on a reply as to how we remove this completely from our system.

Snozzlefeet 10-28-2005 02:37 PM

This hack should just be removed.

This has completely ruined the servers that the forums I tried to install this onto was on, completely locked them up and put them under ENORMOUS load, Megatekno should be hung for writing such a stupid query.

piXelatedEmpire 10-29-2005 06:38 AM

settle down Snozzle..

although I do agree this extension should be removed, or in the very least some sort of warning put in the fist post

akanevsky 10-29-2005 11:19 AM

Why don't you make full use of phrases? Other than that, nice hack :)

teedizz 11-23-2005 01:27 AM

everything works fine except for quick statistics...why is that?

Wifey 06-21-2006 02:25 PM

I got a technical database error when i uploaded this. I deleted the XML file but now my board is still down. I uploaded the XML file first and did it exactly as I was directed to. Any ideas?

Wifey 06-21-2006 02:46 PM

Okay, forget it -- I reverted the functions_user.php file and that worked.

I still would like to install this but I need to know -- if I install this must I first do the phrases and template edits in order for it to work? Is that what I did wrong?

Wifey 06-21-2006 03:00 PM

Quote:

Originally Posted by Snozzlefeet
This hack should just be removed.

This has completely ruined the servers that the forums I tried to install this onto was on, completely locked them up and put them under ENORMOUS load, Megatekno should be hung for writing such a stupid query.

I agree that it should be removed! It's totally locked down my forum right now and my hosting is trying to fix it. I wish I had read through this thread first. Megatekno I don't think you should be hung but you're giving my hosting a run for its money right now and overloading the SQL servers, LOL.

amkge 04-14-2007 01:22 PM

This shouldnt be allowed !

Ive just installed this and it has ++++ed up pretty much everything. Ive removed it and my server is still shit slow.

Way to ++++ up a site.

amkge 04-14-2007 01:29 PM

Can someone tell me step by step how to remove this completely show i get my old nav bar back etc.

Any help would be much appreciated, ive got alot of pissed off members on my board right now and its really hitting the fan.

amkge 04-14-2007 01:37 PM

Thankfully I have removed it and the board is back up to speed.

DO NOT WASTE YOUR TIME OR JEOPORDIZE YOUR BOARD BY ATTEMPTING TO INSTALL THIS HACK.


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01130 seconds
  • Memory Usage 1,778KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)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