vb.org Archive - Forum's Design

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

- vBulletin.org Site Feedback (https://vborg.vbsupport.ru/forumdisplay.php?f=7)

- - Forum's Design (https://vborg.vbsupport.ru/showthread.php?t=280863)

Quote:

Originally Posted by vbenhancer (Post 2315461)

actually, there is not a single code that would save processors or server resources... vBulletin is coded to do just that, use the best of the code and features to make server-safe transactions and processes... if you go further in trying to enhance it, you break the process...

so any suggestion to make the code better is just moronish grace... if there is a way to help, vBulletin is upgraded to fix that possibility already... no need to download a hack for that.

I think you misunderstood what I said.

Promotions.php contains this code (note the "save a bit of cpu time.")..

Code:

// $nextrun is the time difference between runs. Should be sent over from cron.php!!

// We only check the users that have been active since the lastrun to save a bit of cpu time.



$thisrun = TIMENOW;

$lastrun = $vbulletin->crondata['promotions_lastrun'] ? $vbulletin->crondata['promotions_lastrun'] : $thisrun - ($nextrun - $thisrun);



$promotions = $vbulletin->db->query_read("

        SELECT user.joindate, user.userid, user.membergroupids, user.posts, user.reputation,

                user.usergroupid, user.displaygroupid, user.customtitle, user.username, user.ipoints,

                userpromotion.joinusergroupid, userpromotion.reputation AS jumpreputation, userpromotion.posts AS jumpposts,

                userpromotion.date AS jumpdate, userpromotion.type, userpromotion.strategy,

                usergroup.title, usergroup.usertitle AS ug_usertitle,

                usertextfield.rank

        FROM " . TABLE_PREFIX . "user AS user

        INNER JOIN " . TABLE_PREFIX . "userpromotion AS userpromotion ON (user.usergroupid = userpromotion.usergroupid)

        LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (userpromotion.joinusergroupid = usergroup.usergroupid)

        LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid)

        " . iif(VB_AREA != 'AdminCP', "WHERE user.lastactivity >= $lastrun")

);

That code does not allow the promotions system to move users to a different usergroup if they have been inactive in 30 days. The only way to fix that is to remove the .iif at the end of the query.

And FYI, this is confirmed and in the product backlog in JIRA. http://tracker.vbulletin.com/browse/VBIV-12929

But we are so far off topic now that I think it's time to stop posting the good/bad of vB 4. :)

Quote:

Originally Posted by Max Taxable (Post 2315165)

I have tried it, I spend quite a bit of volunteer time helping people with their v4, and it sucks. Hard. I don't know anyone who has it that doesn't wish they could revert.

Is that your site in your sig? Look how slow it is. This is a hallmark of v4:

http://www.webpagetest.org/result/120330_SF_3SJ57/

And it's complete with a couple of 404 errors as well:

http://www.webpagetest.org/result/12...J57/1/details/

It ran faster than it did on vB3. I don't really trust webpagetest, it's said sites take 6 seconds to load and they've loaded in a few seconds in actuality.

You can rest assure this clown has misunderstood what you said 95% of his posts are misunderstandings..........lol

Quote:

Originally Posted by nhawk (Post 2315465)

I think you misunderstood what I said.

Promotions.php contains this code (note the "save a bit of cpu time.")..

Code:

// $nextrun is the time difference between runs. Should be sent over from cron.php!!

// We only check the users that have been active since the lastrun to save a bit of cpu time.



$thisrun = TIMENOW;

$lastrun = $vbulletin->crondata['promotions_lastrun'] ? $vbulletin->crondata['promotions_lastrun'] : $thisrun - ($nextrun - $thisrun);



$promotions = $vbulletin->db->query_read("

        SELECT user.joindate, user.userid, user.membergroupids, user.posts, user.reputation,

                user.usergroupid, user.displaygroupid, user.customtitle, user.username, user.ipoints,

                userpromotion.joinusergroupid, userpromotion.reputation AS jumpreputation, userpromotion.posts AS jumpposts,

                userpromotion.date AS jumpdate, userpromotion.type, userpromotion.strategy,

                usergroup.title, usergroup.usertitle AS ug_usertitle,

                usertextfield.rank

        FROM " . TABLE_PREFIX . "user AS user

        INNER JOIN " . TABLE_PREFIX . "userpromotion AS userpromotion ON (user.usergroupid = userpromotion.usergroupid)

        LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (userpromotion.joinusergroupid = usergroup.usergroupid)

        LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid)

        " . iif(VB_AREA != 'AdminCP', "WHERE user.lastactivity >= $lastrun")

);

Quote:

Originally Posted by RSNF (Post 2315570)

You can rest assure this clown has misunderstood what you said 95% of his posts are misunderstandings..........lol

clown ?!... thanks, i was not named a clown for a long time, it remembers me the old days !!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (4)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01204 seconds Memory Usage 1,738KB 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 (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (4)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: