Ms-Analysis Cron Job

spasticdonkey · Posted: Tue Feb 10, 2009 3:20 pm

This Ms-Analysis Cron Job script broke under RN2.3, was working under RN until then. Probably something simple with the include path but after a few attempts no luck, so here I am Smile

modules/MS_Analysis/include/cronmaintenance.php

Code:

global $prefix, $db;

// Set time limit and ignore user abort
if( !get_cfg_var('safe_mode') )
{
@set_time_limit( 300 );
@ignore_user_abort( 1 );
}

// Next setting ($forum_admin) is needed so that PHP-Nuke finds the required files in the correct path
define('FORUM_ADMIN', true);
require_once("../../../config.php");
require_once("../../../db/db.php");
// END: Next setting ($forum_admin) is needed so that PHP-Nuke finds the required files in the correct path

// Load Admin Settings
$result = $db->sql_query( "select curdate, staticupdate, GMT_offset, allow_pruning from $prefix"._msanalysis_admin." where id='1'" );
$MSArow = $db->sql_fetchrow( $result );

// Compose LOCAL Timestamp
$MSAdata[current] = -1 * ( date( "Z" ) / 3600 );
$MSAdata[zonedate] = mktime(date('H'), date('i'), date('s'), date('n'), date('j'), date('Y'), -1) + ( ( $MSAdata[current] + $MSArow[GMT_offset] ) * 3600 );
$MSAdata[logdate] = date( "Y-m-d H:i:s", $MSAdata[zonedate] );
$MSAdata[slogdate] = date( "Y-m-d", $MSAdata[zonedate] );

// Set last update time
$db->sql_query( "update $prefix"._msanalysis_admin." set lastupdate = '$MSAdata[logdate]' where id='1'" );

// Carry out maintenance every hour (by cron deamon)
if( $MSArow[staticupdate] ) {
require_once( "class.maintenance.php" ); // Routine Classes for tracker
$msamainteneance = new msa_maintenance();
$msamainteneance->hourly_maintenance( $MSAdata[slogdate] );
}

// Every day default clear the hits for this day. If set, also prune MS-Tables
if( $MSAdata[slogdate] != $MSArow[curdate] ) {
if( $MSArow[staticupdate] ) {
// Set new logdate in Admin Table
$db->sql_query( "update $prefix"._msanalysis_admin." set curdate='$MSAdata[slogdate]' where id = '1'" );
require_once( "class.maintenance.php" ); // Routine Classes for tracker
$msamainteneance = new msa_maintenance( );
$msamainteneance->daily_maintenance( );
if( $MSArow[allow_pruning] ) $msamainteneance->pruning_maintenance( );
}
}

unset( $MSAdata );

Heres the full download if needed

Only registered users can see links on this board!
Get registered or login to the forums!

kguske · Site Admin Joined: Jun 04, 2004 Posts: 5997

Forum files moved, and your error log will most likely tell you the exact problem, which might be outside this script.

spasticdonkey · Posted: Tue Feb 10, 2009 11:58 pm

thanks, that gives me a place to start Smile

spasticdonkey · Posted: Thu Feb 12, 2009 7:23 am

well it ended up being that the script is calling config.php directly without calling mainfile, so it wasnt loading rnconfig, as per this post:

Only registered users can see links on this board!
Get registered or login to the forums!

changing line 95 in config.php to
if(!defined('INCLUDE_PATH')) define('INCLUDE_PATH', '');
got it working again

kguske · Site Admin Joined: Jun 04, 2004 Posts: 5997

I'm wondering if that might affect your other functions. Maybe you could add that line to the msanalysis script before it includes config.php?

spasticdonkey · Posted: Thu Feb 12, 2009 8:30 am

yes that worked and is a much better solution Smile

draxx · Worker Joined: Nov 19, 2003 Posts: 186

I loved it but MS Analysis is soooooooo insecure you do know that right?