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)) . ')');
     }
 }
Beispiel #2
0
function get_admins()
{
    $data = ldb_select('user', array('id'), '`is_admin`=\'Y\' ORDER BY `id`');
    return array_ids($data);
}