function detailsof() { $id = $_GET["detailsof"]; $sql = "SELECT * FROM dar_index where filekey='{$id}'"; $q = new mysql(); $ligne = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup')); //print_r($ligne); $html = "<H1>" . basename($ligne["filepath"]) . "</h1>\n<table style='width:100%'>\n<tr>\n\t<td valign='top'><img src='img/128-view-file.png'></td>\n<td valign='top'>\n<table style='width:100%' class=table_form>\n<tr>\n\t<td valign='top' class=legend>{filedate}:</td>\n\t<td valing='top' ><strong>{$ligne["filedate"]}</strong></td>\t\n</tr>\n<tr>\n\t<td valign='top' class=legend>{filesize}:</td>\n\t<td valing='top' ><strong>{$ligne["filesize"]}</strong></td>\t\n</tr>\n<tr>\n\t<td valign='top' class=legend>{database_name}:</td>\n\t<td valing='top'><strong>{$ligne["database_name"]}</strong></td>\t\n</tr>\n<tr>\n\t<td valign='top' class=legend>{source_path}:</td>\n\t<td valing='top'><strong>{$ligne["source_path"]}</strong></td>\t\n</tr>\n<tr>\n\t<td valign='top' class=legend>{resource}:</td>\n\t<td valing='top'><strong>" . hide_ressources($ligne["mount_md5"]) . "</strong></td>\t\n</tr>\t\t\t\n<tr>\n\t<td valign='top' class=legend>{server}:</td>\n\t<td valing='top'><strong>{$ligne["servername"]}</strong></td>\t\n</tr>\t\n<tr>\n<td colspan=2 align='right'>\n\t<input type='button' value='{restore} »»' OnClick=\"javascript:Loadjs('dar.restore.php?fileid={$id}')\">\n</td>\n</tr>\n\n\n</table>\n</td>\n</tr>\n</table>"; $tpl = new templates(); echo $tpl->_ENGINE_parse_body($html); }
function find_mailbox_ressources_from_uid($uid) { $firstletter = substr($uid, 0, 1); $uidp = $uid; $uidp = str_replace(".", "^", $uidp); $pattern = "{$firstletter}/user/{$uidp}/cyrus.index"; $sql = "SELECT filekey,filedate,filepath,mount_md5 FROM dar_index WHERE filepath='{$pattern}' AND filesize>0 AND database_name='cyrus_imap_mail'"; $q = new mysql(); $html = "\n\t<p class=caption>{external_resource_choose_text}</p>\n\t<table style='width:100%'>\n\t<tr>\n\t\t<th width=1%> </th>\n\t\t<th>{date}</th>\n\t\t<th>{external_resource}</th>\n\t</tr>"; $resultats = $q->QUERY_SQL($sql, 'artica_backup'); while ($ligne = mysql_fetch_array($resultats, MYSQL_ASSOC)) { $filedate = $ligne["filedate"]; $mount_md5 = $ligne["mount_md5"]; $filekey = $ligne["filekey"]; $filepath = $ligne["filepath"]; $filedate = texttooltip($filedate, $filepath); $js = "RestoreMBXID('{$filekey}');"; $html = $html . "\n\t\t\t<tr " . CellRollOver($js) . ">\n\t\t\t\t<td valign='top' width=1%><img src='img/fw_bold.gif'></td>\n\t\t\t\t<td valign='top' nowrap>{$filedate}</td>\n\t\t\t\t<td valign='top' width=99%>" . hide_ressources($mount_md5) . "</td>\n\t\t\t</tr>\t\t\t\t\t\n\t\t\t"; } $tpl = new templates(); return $tpl->_ENGINE_parse_body($html); }