vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Cron Job Broken (https://vborg.vbsupport.ru/showthread.php?t=213541)

OcR Envy 05-12-2009 11:45 PM
Cron Job Broken
 
I've written a custom cron job to interact with a mod I am working on. However the cron job doesn't work every time. If I run it manually it works without any problem, however it doesn't seem to run automatically despite the scheduled task manager showing it ran.

Is there some kind of error in my coding that would cause this? I'm reluctant to post the code but will if needed.

Lynne 05-13-2009 04:06 AM
I've written cron jobs before that only run manually because I didn't have the code correct. Find a similar one that vbulletin wrote and compare it to yours and see if there are things missing (I seem to recall I forgot to make something global in mine).

Dismounted 05-13-2009 05:53 AM
Some variables do not exist when scheduled tasks are not run from the Admin CP. Also, keep in mind that the task has a possibility of running as a guest.

OcR Envy 05-13-2009 09:20 AM
Thank you for both of your responses. I've PMed you the code if you have the chance to review it that would be swell.

Lynne, I've globalized only $vbulletin and a few vars I want to hold the string outside of functions. I'm unsure what else would need to be done.

Dismounted, How would this make a difference? I'm stating that the task works when run manually by clicking on "Run Now" not from outside the Admin CP. I don't think you can even run it stand alone as it calls the db defined by vbulletin. There isn't any code in it that would matter as for member vs guest.

--------------- Added [DATE]1242226401[/DATE] at [TIME]1242226401[/TIME] ---------------

After getting a response from Lynne I've decided to post the code. Anyone who see's an issue please help!

For reference I am not currently giving permission to reuse the code.

PHP Code:
<?php
/*======================================================================*\
|| #################################################################### ||
|| # Who's on XBL By OcR Envy v 2.8                                    ||
|| #################################################################### ||
\*======================================================================*/

// ---------------------------------------------------
// Start Set PHP Environment
// ---------------------------------------------------

error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
    echo "No vBulletin Found!";
    exit;
}

// ---------------------------------------------------
// Start Cronjob
// ---------------------------------------------------

global $vbulletin;
global $db;

@set_time_limit(0);
@ignore_user_abort(true);

$updatetime=time(); 
putenv("TZ=US/Eastern");
$checktime=date("h:i A", time());
$checkdate=date("m/d/y", time());

function DownloadUrl($Url){
 
    $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $Url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); 
        curl_setopt($ch, CURLOPT_TIMEOUT, 5); 
        curl_setopt($ch, CURLOPT_USERAGENT, 'vBulletin via cURL/PHP');
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
        curl_setopt($ch, CURLOPT_ENCODING, 'gzip');
        $output = curl_exec($ch);
    curl_close($ch);

    $online = strstr($output, 'Server');

    if($online) { 
        $online = "false";
    } else {
        if($output == "") {
            $online = "false";
        } else {                
            global $xml;
            $xml = simplexml_load_string($output);
            $account=$xml->AccountStatus;
            if($account == "Gold") {
                $online = "true";
            } else {
                $online = "false";
            }
        }
    }
    return $online;
}

$duncanonline = Downloadurl('http://xboxapi.duncanmackenzie.net/gamertag.ashx?GamerTag=outcast%20reborn');
$vbulletin->db->query("UPDATE xblusers SET time='$checktime', date='$checkdate' WHERE title='checked'");

if($duncanonline=="true") {
    $updater="true";
} else {

    $grabchecked = $vbulletin->db->query("SELECT time, date FROM xblusers WHERE title='crashed'");
    $gchecked=$vbulletin->db->fetch_array($grabchecked);
    $checkedt=$gchecked['time'];
    
    
    if($checkedt=="00:00PM") {
        $vbulletin->db->query("UPDATE xblusers SET time='$checktime', date='$checkdate' WHERE title='crashed'");
    }
    die;
}


$gamertaggrab=$vbulletin->db->query("SELECT userfield.field5, userfield.field11, userfield.userid FROM userfield INNER JOIN user ON user.userid = userfield.userid AND userfield.field5 > '' WHERE usergroupid IN (6,48,52,50,51,26,58,60,55,46,25)");
while($userrow = $vbulletin->db->fetch_array($gamertaggrab)) {    
    $gamertag=$userrow['field5'];
        
    if ($gamertag) {
        $duncanonline = Downloadurl('http://xboxapi.duncanmackenzie.net/gamertag.ashx?GamerTag='. urlencode($gamertag));

        if($duncanonline=="true") {
            $coretag=$xml->Gamertag;                
            $tagvalid=$xml->PresenceInfo->Valid;        
            $onlinestatus=$xml->PresenceInfo->Online;        
            $statustext=$xml->PresenceInfo->StatusText;        
            $title=$xml->PresenceInfo->Title;        
            $info=$xml->PresenceInfo->Info;        
            $info2=$xml->PresenceInfo->Info2;        
            $lastseen=$xml->PresenceInfo->LastSeen;                
                    
            $statustext=addslashes($statustext);        
            $title=addslashes($title);        
            $info=addslashes($info);        
            $info2=addslashes($info2);
            
            if ($onlinestatus=="true") {            
                $online=1;        
            } else {            
                $online=0;            
            }                    
                        
            foreach ($xml->xpath('//Game') as $gameset) {  
                $gamename=$gameset->Name;            
                $gametile=$gameset->Image32url;                        
                $gamename=addslashes($gamename);

                $vbulletin->db->query("INSERT IGNORE INTO xblgames (name,tile) VALUES ('".$gamename."','".$gametile."')");                                        
            }
    
            if ($tagvalid=="true")    {
                $logmsg = $logmsg . $userrow['userid'] . ": " . $gamertag . "-" . $statustext . "<br />";
                $vbulletin->db->query("INSERT INTO xblstatus (userid,gamertag,online,statustext,title,info,info2,lastseen,updatetime)             
                VALUES ('".$userrow['userid']."','$coretag','$online','$statustext','$title','$info','$info2','$lastseen',FROM_UNIXTIME($updatetime)) ON DUPLICATE KEY             
                UPDATE userid='".$userrow['userid']."',gamertag='$coretag',online='$online',statustext='$statustext',title='$title',info='$info',info2='$info2',
                lastseen='$lastseen',updatetime=FROM_UNIXTIME($updatetime)");                                    
                    
                $vbulletin->db->query("UPDATE userfield SET field12='$statustext',field13='$title',field14='$info2' WHERE userid=".$userrow['userid']);
            }

        }
    }

    $gamertag=$userrow['field11'];    
        
    if ($gamertag) {
        $duncanonline = Downloadurl('http://xboxapi.duncanmackenzie.net/gamertag.ashx?GamerTag='. urlencode($gamertag));

        if($duncanonline=="true") {
            $coretag=$xml->Gamertag;                
            $tagvalid=$xml->PresenceInfo->Valid;        
            $onlinestatus=$xml->PresenceInfo->Online;        
            $statustext=$xml->PresenceInfo->StatusText;        
            $title=$xml->PresenceInfo->Title;        
            $info=$xml->PresenceInfo->Info;        
            $info2=$xml->PresenceInfo->Info2;        
            $lastseen=$xml->PresenceInfo->LastSeen;    
                
            $statustext=addslashes($statustext);        
            $title=addslashes($title);        
            $info=addslashes($info);        
            $info2=addslashes($info2);                            
                    
            if ($onlinestatus=="true") {            
                $online=1;        
            } else {            
                $online=0;            
            }                
                        
            if ($tagvalid=="true")    {
                $logmsg = $logmsg . $userrow['userid'] . ": " . $gamertag . "-" . $statustext . "<br />";
                $vbulletin->db->query("INSERT INTO sxblstatus (userid,gamertag,online,statustext,title,info,info2,lastseen,updatetime)             
                VALUES ('".$userrow['userid']."','$coretag','$online','$statustext','$title','$info','$info2','$lastseen',FROM_UNIXTIME($updatetime)) ON DUPLICATE KEY             
                UPDATE userid='".$userrow['userid']."',gamertag='$coretag',online='$online',statustext='$statustext',title='$title',info='$info',info2='$info2',
                lastseen='$lastseen',updatetime=FROM_UNIXTIME($updatetime)");
                    
                $vbulletin->db->query("UPDATE userfield SET field15='$statustext',field16='$title',field17='$info2' WHERE userid=".$userrow['userid']);                                                            
            }    
        }                        
    }
}

if($updater=="true") {
    $vbulletin->db->query("UPDATE xblusers SET time='00:00PM', date='00/00/00' WHERE title='crashed'");
}
log_cron_action('Updated XBL Status', $nextitem, 1);

// ---------------------------------------------------
// End Cronjob
// ---------------------------------------------------
?>

Lynne 05-13-2009 02:48 PM
Do you see anything in your error_logs? And is any of that script getting done? Is see you have some update queries and I'm just wondering if some are happening before the script stops.

OcR Envy 05-13-2009 03:03 PM
I have nothing in my error logs.

This query appears to always take place:

$vbulletin->db->query("UPDATE xblusers SET time='$checktime', date='$checkdate' WHERE title='checked'");

And this one takes place when the if statement is true

$vbulletin->db->query("UPDATE xblusers SET time='$checktime', date='$checkdate' WHERE title='crashed'");

It appears the code inside my while is where the issue lays as when the cron job automatically runs the insert queries do not take place. Also my log_cron_action doesn't log ethier when run automatically or manually.

I haven't checked if the userfields update query is saving. I will keep an eye on that now.

Lynne 05-13-2009 03:16 PM
Well, if I were to debug this, I'd do things like take out functions and such to see if they are the problem. For instance, change this line to simple give the results (true or false) and see if the job continues to run:
PHP Code:
        $duncanonline = Downloadurl('http://xboxapi.duncanmackenzie.net/gamertag.ashx?GamerTag='. urlencode($gamertag)); 
I'd do things like that to whole bits of code to see exactly where the problem lies.

OcR Envy 05-13-2009 03:33 PM
Will do.

I also updated my Insert, Update statement to query_write function. Not sure if that matters.

The userfield queries where not taking place either.

--------------- Added [DATE]1242234837[/DATE] at [TIME]1242234837[/TIME] ---------------

Well that was easier than I was making it. It appears it is the function. Strange the function works flawless when I run it manually but not when it's automatic.

Thanks Lynne, anyone who can offer a reason as to why function doesn't work I'd appreciate it.

Lynne 05-13-2009 04:58 PM
I had problems with using a function in my cron job, too. You need to pass any variables it is going to need and you need to globalize everything also. And, any functions you want it to use, you need to make sure to include them in the functions. You have to treat the function like it lives in it's own little world and knows nothing of the outside world except what you pass it.

OcR Envy 05-13-2009 05:06 PM
Will do,

Thanks again Lynne +Rep if I could :)


All times are GMT. The time now is 11:42 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.02251 seconds
  • Memory Usage 1,849KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete