X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=WEB-INF%2Flib%2FttNotificationHelper.class.php;h=af1bcd3c8314eea211b3ff64ae8be5db3494f734;hb=a711e76851f29c7e0ac290a279eb4dd984ea7167;hp=35a96970eb351ce4db39cd797b1f025e3fb10560;hpb=de05f61301a897661c702f03c1b45dd3ab5c0e8a;p=timetracker.git diff --git a/WEB-INF/lib/ttNotificationHelper.class.php b/WEB-INF/lib/ttNotificationHelper.class.php index 35a96970..af1bcd3c 100644 --- a/WEB-INF/lib/ttNotificationHelper.class.php +++ b/WEB-INF/lib/ttNotificationHelper.class.php @@ -38,7 +38,7 @@ class ttNotificationHelper { $sql = "select c.id, c.cron_spec, c.report_id, c.email, c.cc, c.subject, c.report_condition, c.status, fr.name from tt_cron c left join tt_fav_reports fr on (fr.id = c.report_id) - where c.id = $id and c.group_id = $user->group_id"; + where c.id = $id and c.group_id = ".$user->getActiveGroup(); $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); @@ -54,7 +54,7 @@ class ttNotificationHelper { $mdb2 = getConnection(); - $sql = "delete from tt_cron where id = $id and group_id = $user->group_id"; + $sql = "delete from tt_cron where id = $id and group_id = ".$user->getActiveGroup(); $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) return false;