$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
- $sql = "select u.*, r.name as role_name, r.rank from tt_users u left join tt_roles r on (u.role_id = r.id) where u.team_id = $user->team_id and u.status = 1 order by upper(u.name)";
+ $sql = "select u.*, r.name as role_name, r.rank from tt_users u left join tt_roles r on (u.role_id = r.id) where u.group_id = $user->group_id and u.status = 1 order by upper(u.name)";
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error'))
return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error'))
return false;
$modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$mdb2->quote($user->id);
// Promote user.
$modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$mdb2->quote($user->id);
// Promote user.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Demote self.
$role_id = $val['role_id'];
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Demote self.
$role_id = $val['role_id'];
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
- $sql = "select u.id, u.name, r.rank, r.rights from tt_users u left join tt_roles r on (u.role_id = r.id) where u.team_id = $user->team_id and u.status = 1 and r.rank < $user->rank order by upper(u.name)";
+ $sql = "select u.id, u.name, r.rank, r.rights from tt_users u left join tt_roles r on (u.role_id = r.id) where u.group_id = $user->group_id and u.status = 1 and r.rank < $user->rank order by upper(u.name)";
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
{
$result = array();
$mdb2 = getConnection();
$sql = "select id, name, description, tasks from tt_projects
{
$result = array();
$mdb2 = getConnection();
$sql = "select id, name, description, tasks from tt_projects
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
{
$result = array();
$mdb2 = getConnection();
$sql = "select id, name, description, tasks from tt_projects
{
$result = array();
$mdb2 = getConnection();
$sql = "select id, name, description, tasks from tt_projects
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
- $sql = "select id, name, description from tt_tasks where team_id = $team_id and status = 1 order by upper(name)";
+ $sql = "select id, name, description from tt_tasks where group_id = $group_id and status = 1 order by upper(name)";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
- $sql = "select id, name, description, rank, rights from tt_roles where team_id = $user->team_id and rank < $user->rank and status = 1 order by rank";
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and rank < $user->rank and status = 1 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
- $sql = "select id, name, description, rank, rights from tt_roles where team_id = $team_id and status = 1 order by rank";
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $group_id and status = 1 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
{
$result = array();
$mdb2 = getConnection();
$sql = "select id, name, rank, description from tt_roles
{
$result = array();
$mdb2 = getConnection();
$sql = "select id, name, rank, description from tt_roles
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
- $sql = "select id, name, description, rank, rights from tt_roles where team_id = $user->team_id and rank < $user->rank and status = 0 order by rank";
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and rank < $user->rank and status = 0 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$sql = "select i.id, i.name, i.date, i.client_id, i.status, c.name as client_name from tt_invoices i
left join tt_clients c on (c.id = i.client_id)
$sql = "select i.id, i.name, i.date, i.client_id, i.status, c.name as client_name from tt_invoices i
left join tt_clients c on (c.id = i.client_id)
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$sql = "select i.id, i.name from tt_invoices i
left join tt_clients c on (c.id = i.client_id)
$sql = "select i.id, i.name from tt_invoices i
left join tt_clients c on (c.id = i.client_id)
- $sql = "select * from tt_user_project_binds where user_id in (select id from tt_users where team_id = $team_id) order by user_id, status, project_id";
+ $sql = "select * from tt_user_project_binds where user_id in (select id from tt_users where group_id = $group_id) order by user_id, status, project_id";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$mdb2 = getConnection();
$result = array();
$sql = "select c.id, c.cron_spec, c.email, c.report_condition, fr.name from tt_cron c
left join tt_fav_reports fr on (fr.id = c.report_id)
$mdb2 = getConnection();
$result = array();
$sql = "select c.id, c.cron_spec, c.email, c.report_condition, fr.name from tt_cron c
left join tt_fav_reports fr on (fr.id = c.report_id)
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Mark projects deleted.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Mark projects deleted.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Mark clients deleted.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Mark clients deleted.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Mark custom fields deleted.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Mark custom fields deleted.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$result = array();
$mdb2 = getConnection();
$sql = "select t.name as team_name, u.id as manager_id, u.name as manager_name, u.login as manager_login, u.email as manager_email
$result = array();
$mdb2 = getConnection();
$sql = "select t.name as team_name, u.id as manager_id, u.name as manager_name, u.login as manager_login, u.email as manager_email
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
$columns .= ', created, created_ip, created_by';
$values .= ', now(), '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', '.$mdb2->quote($user->id);
$columns .= ', created, created_ip, created_by';
$values .= ', now(), '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', '.$mdb2->quote($user->id);
$affected = $mdb2->exec($sql);
if (!is_a($affected, 'PEAR_Error')) {
$affected = $mdb2->exec($sql);
if (!is_a($affected, 'PEAR_Error')) {
if (isset($fields['tracking_mode'])) $tracking_mode_part = ', tracking_mode = '.(int) $fields['tracking_mode'];
if (isset($fields['record_type'])) $record_type_part = ', record_type = '.(int) $fields['record_type'];
if (isset($fields['bcc_email'])) $bcc_email_part = ', bcc_email = '.$mdb2->quote($fields['bcc_email']);
if (isset($fields['tracking_mode'])) $tracking_mode_part = ', tracking_mode = '.(int) $fields['tracking_mode'];
if (isset($fields['record_type'])) $record_type_part = ', record_type = '.(int) $fields['record_type'];
if (isset($fields['bcc_email'])) $bcc_email_part = ', bcc_email = '.$mdb2->quote($fields['bcc_email']);
if (isset($fields['plugins'])) $plugins_part = ', plugins = '.$mdb2->quote($fields['plugins']);
if (isset($fields['config'])) $config_part = ', config = '.$mdb2->quote($fields['config']);
if (isset($fields['lock_spec'])) $lock_spec_part = ', lock_spec = '.$mdb2->quote($fields['lock_spec']);
if (isset($fields['workday_minutes'])) $workday_minutes_part = ', workday_minutes = '.$mdb2->quote($fields['workday_minutes']);
$modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$mdb2->quote($user->id);
if (isset($fields['plugins'])) $plugins_part = ', plugins = '.$mdb2->quote($fields['plugins']);
if (isset($fields['config'])) $config_part = ', config = '.$mdb2->quote($fields['config']);
if (isset($fields['lock_spec'])) $lock_spec_part = ', lock_spec = '.$mdb2->quote($fields['lock_spec']);
if (isset($fields['workday_minutes'])) $workday_minutes_part = ', workday_minutes = '.$mdb2->quote($fields['workday_minutes']);
$modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$mdb2->quote($user->id);
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Get all team ids for teams created or modified more than 8 months ago.
// $ts = date('Y-m-d', strtotime('-1 year'));
$ts = $mdb2->quote(date('Y-m-d', strtotime('-8 month')));
// Get all team ids for teams created or modified more than 8 months ago.
// $ts = date('Y-m-d', strtotime('-1 year'));
$ts = $mdb2->quote(date('Y-m-d', strtotime('-8 month')));
$res = $mdb2->query($sql);
$count = 0;
if (!is_a($res, 'PEAR_Error')) {
while ($val = $res->fetchRow()) {
$res = $mdb2->query($sql);
$count = 0;
if (!is_a($res, 'PEAR_Error')) {
while ($val = $res->fetchRow()) {
// Limit the array size for perfomance by allowing this operation on small chunks only.
if ($count >= 100) break;
}
// Limit the array size for perfomance by allowing this operation on small chunks only.
if ($count >= 100) break;
}
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) die($res->getMessage());
while ($val = $res->fetchRow()) {
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) die($res->getMessage());
while ($val = $res->fetchRow()) {
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
while ($val = $res->fetchRow()) {
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
while ($val = $res->fetchRow()) {
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete projects.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete projects.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete clients.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete clients.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete invoices.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete invoices.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete custom fields.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
// Delete custom fields.
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) return false;
$plugins = implode(',', $plugin_array);
if ($plugins != $user->plugins) {
$plugins = implode(',', $plugin_array);
if ($plugins != $user->plugins) {