vb.org Archive - How to automate database query?

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - How to automate database query? (https://vborg.vbsupport.ru/showthread.php?t=319172)

viper357

06-22-2015 10:12 AM

How to automate database query?

Hi all

The "Execute SQL Query" option, Is it possible to automate this?

I need to execute this query once a week, every week.
UPDATE rbs_banners SET m_expired=0

Thanks.

kh99	06-22-2015 10:37 AM

You could make a plugin using hook cron_script_cleanup_daily and code like this:

PHP Code:


		
			
if (date("N") == '1') // 1 = Monday, 7=Sunday

{

   $vbulletin->db->query_write("UPDATE rbs_banners SET m_expired=0");

}

It's not perfect. For one thing if, for example, you set it up to run on Monday and for some reason the cleanup script doesn't run (like your forum is down or something), it wouldn't run until the next week. BUt it might be good enough for your purposes.

viper357

06-22-2015 10:50 AM

That seems great, thank you. :)

All times are GMT. The time now is 07:02 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02213 seconds Memory Usage 1,707KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: