function recount() { # Delete old attached (temp) files ldb_query('DELETE FROM `site_attach_post` WHERE `id_2`<0 AND `tms_added`<' . (time() - 86400)); # Recount link's count # ldb_query ('UPDATE `site_attach_files` SET `links_count`=(SELECT COUNT(*) FROM `site_attach_post` WHERE `site_attach_post`.`file_id`=`site_attach_files`.`id`) WHERE `id` IN ('.implode($ids).')'); ldb_query('UPDATE `site_attach_files` SET `links_count`=(SELECT COUNT(*) FROM `site_attach_post` WHERE `site_attach_post`.`file_id`=`site_attach_files`.`id`) WHERE `att_type`=\'ATTACH\''); # Delete attaches without parents $data = ldb_select('site_attach_files', '*', '`links_count`<=0'); if ($data) { for ($x = 0; $x < count($data); $x++) { @unlink(ROOT_PATH . '/uploads/att-' . $data[$x]['id'] . '.dat'); @unlink(ROOT_PATH . '/uploads/att-' . $data[$x]['id'] . '.inf'); } ldb_query('DELETE FROM `site_attach_files` WHERE `id` IN (' . implode(',', array_ids($data)) . ')'); } }
function get_admins() { $data = ldb_select('user', array('id'), '`is_admin`=\'Y\' ORDER BY `id`'); return array_ids($data); }