trying to pull time_worked in pipe_functions.inc.php

[dr_patso]

why doesn't this work? $tmpvar['time_worked'] is staying blank. I have this added around line 255, inside the if is_reply code.

Code: Select all

$tmpvar['time_worked'] = hesk_dbQuery("SELECT `time_worked` FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `trackid`='".hesk_dbEscape($ticket['trackid'])."' LIMIT 1");

[Klemen]

This step just executes the query, you still need to fetch row data afterwards:

Code: Select all

// Execute query
$res = hesk_dbQuery("SELECT `time_worked` FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `trackid`='".hesk_dbEscape($ticket['trackid'])."' LIMIT 1");

// Fetch results from $res query
$row = hesk_dbFetchAssoc($res);

// Set time worked
$tmpvar['time_worked'] =$row['time_worked'];

[dr_patso]

thanks klemen!!!! I GOT IT TO WORK!



This is what I have now

Code: Select all

$timeres = hesk_dbQuery("SELECT * FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `trackid`='".hesk_dbEscape($ticket['trackid'])."' LIMIT 1");
		if (hesk_dbNumRows($timeres))
		{	
			$ticket = hesk_dbFetchAssoc($timeres);
			$tmpvar['time_worked'] = $ticket['time_worked'];
		}

Code: Select all

if ($tmpvar['time_worked'] < "04:00:00") 
{
hesk_dbQuery("UPDATE `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` SET `time_worked`='40000' WHERE `id`='".intval($ticket['id'])."' LIMIT 1");
}