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";
}
}
