sanoma

он не работает после включения нечего не вводит в базу данных....

Здравствуйте....

у меня проблема с одним таском...

я пытаюсь вытащить с 3х таиблов результаты а потом их умножыть и прибавить друг другу...

но у меня проблема с sql-ом, никак не смог исправить...

так помогите люди добрые поделитесь знанием...

вот скрип

<?php



if ( ! defined( 'IN_IPB' ) )

{

print "<h1>Incorrect access</h1>You cannot access this file directly. If you have recently upgraded, make sure you upgraded all the relevant files.";

exit();

}


/**

*

* @class task_item

* @brief Task to update the profile views from the temporary table

*

*/

class task_item

{

/**

* Object that stores the parent task manager class

*

* @var $class

*/

protected $class;


/**

* Array that stores the task data

*

* @var $task

*/

protected $task = array();


/**

* Registry Object Shortcuts

*

* @var $registry

* @var $DB

* @var $lang

*/

protected $registry;

protected $DB;

protected $lang;


/**

* Constructor

*

* @param object $registry Registry object

* @param object $class Task manager class object

* @param array $task Array with the task data

* @return @e void

*/

public function __construct( ipsRegistry $registry, $class, $task )

{

/* Make registry objects */

$this->registry = $registry;

$this->DB = $this->registry->DB();

$this->lang = $this->registry->getClass('class_localization');


$this->class = $class;

$this->task = $task;

}


/**

* Run this task

*

* @return @e void

*/

public function runTask()

{

$this->registry->getClass('class_localization')->loadLanguageFile( array( 'public_global' ), 'core' );


/*

$this->DB->build( array( 'select' => 'posts, COUNT(*) as posts', 'eco_points, COUNT(*) as eco_points',

'from'   => 'members', 'pfields_content',

'group'  => 'member_id'

) );

*/

// And finally, a complex build query showing all available parameters

$this->DB->build( array(

												'select'		=> 't.*',

												'from'		  => array( 'members' => 't' ),

												'group'		 => 't.member_id',

												'add_join'	  => array(

																						array(

																								'select'		=> 'm.*',

																								'from'		  => array( 'pfields_content' => 'm' ),

																								'where'		 => 'm.member_id=t.member_id',

																								'type'		  => 'left',

																								),

																						array(

'select'		=> 'o.*',

																								'from'		  => array( 'profile_portal' => 'o' ),

																								'where'		 => 'o.pp_member_id=m.member_id',

																								'type'		  => 'left',

																								),

																						)


)				);









//$z =

$this->DB->execute();

//while( $this->DB->fetch( $z ) )

// {



$sanoma = $o['time_spent'] + 80 * $m['eco_points'] / 4 + $t['posts'] * 100;



//----------------------------------------

// Update...

//-----------------------------------------


$this->DB->update( 'pfields_content', "bounty=" .$sanoma, "member_id=" .$t['member_id'], FALSE, TRUE );

// $this->DB->update( 'pfields_content', 'bounty='. $sanoma, 'member_id=1', true, true );


// }

//-----------------------------------------

// Delete from table

//-----------------------------------------


//$this->DB->delete( 'bounty' );


//-----------------------------------------

// Log to log table - modify but dont delete

//-----------------------------------------


$this->class->appendTaskLog( $this->task, $this->lang->words['task_bounty'] );


//-----------------------------------------

// Unlock Task: DO NOT MODIFY!

//-----------------------------------------


$this->class->unlockTask( $this->task );

}

}

спасибо заранее...