Page 1 of 1
trying to pull time_worked in pipe_functions.inc.php
Posted: Mon Feb 16, 2015 11:10 pm
by 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");
Re: trying to pull time_worked in pipe_functions.inc.php
Posted: Tue Feb 17, 2015 8:35 am
by 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'];
Re: trying to pull time_worked in pipe_functions.inc.php
Posted: Tue Feb 17, 2015 5:55 pm
by 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");
}