View Single Post
  #1  
Old 07-10-2006, 07:23 AM
vb_guru vb_guru is offline
 
Join Date: Aug 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Scheduled Task is not running

I have added a custom Scheduled Task. When I try to run it by clicking Run Now to just goes to the next page and shows the name of the cron job. There is no "Done" on the page. Here is the code:

Code:
<?php

error_reporting(E_ALL & ~E_NOTICE);

if (!is_object($DB_site))
{
	exit;
}

$users = $DB_site->query("
	SELECT username, email, usergroupid, membergroupids, languageid, retaileremailaccept
	FROM " . TABLE_PREFIX . "user
	WHERE usergroupid ='9' OR membergroupids ='9'
	AND retaileremailaccept = '0'
");

vbmail_start();

$row = $DB_site->num_rows($users);
if($row > 0)
{
	while ($user = $DB_site->fetch_array($users))
	{
		$username = unhtmlspecialchars($user['username']);
		$useremail = $user['email'];
		eval(fetch_email_phrases('retaileremail_accept', $user['languageid']));
		vbmail($useremail, $subject, $message);
	}

	vbmail_end();

	$DB_site->query("
		UPDATE " . TABLE_PREFIX . "user
		SET retaileremailaccept = '1'
		WHERE username = '" . addslashes($username) . "'
	");

	log_cron_action('Notification Email sent to: ' . $username, $nextitem);
}

?>
Any ideas why this is happening? I can run other standard vBulletin scheduled tasks.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01097 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete