function get_document_mime_type($id) { global $cdg_sql; $query = "SELECT documentmimetype_extension FROM Document JOIN DocumentMimeType ON document_mimetype_id = documentmimetype_id WHERE document_id = '$id'"; display_debug_msg($query, $cdg_sql); $obm_q = new DB_OBM; $obm_q->query($query); if ($obm_q->num_rows() == 1){ $obm_q->next_record(); return $obm_q->f("documentmimetype_extension"); } else return ""; }
function check_insert_admin0() { global $cdg_sql; $obm_q = new DB_OBM; // Check if adomain 0 admin is present $q = "Select userobm_id FROM UserObm WHERE userobm_domain_id=0"; $obm_q->query($q); if ($obm_q->num_rows() > 0) { echo "\nDomain 0 admin : yes\n"; } else { echo "\nDomain 0 admin : no : insertion..."; $q = "INSERT INTO UserObm ( userobm_domain_id, userobm_login, userobm_password, userobm_password_type, userobm_perms, userobm_lastname, userobm_firstname, userobm_uid, userobm_gid) VALUES ( 0, 'admin0', 'admin', 'PLAIN', 'admin', 'Admin Lastname', 'Firstname', '1000', '512')"; $obm_q->query($q); echo "OK\n"; } }