| commit | author | age | ||
| 532ae5 | 1 | <?php |
| L | 2 | |
| 3 | /* | |
| 4 | Copyright (c) 2007, Till Brehm, projektfarm Gmbh | |
| 5 | All rights reserved. | |
| 6 | ||
| 7 | Redistribution and use in source and binary forms, with or without modification, | |
| 8 | are permitted provided that the following conditions are met: | |
| 9 | ||
| 10 | * Redistributions of source code must retain the above copyright notice, | |
| 11 | this list of conditions and the following disclaimer. | |
| 12 | * Redistributions in binary form must reproduce the above copyright notice, | |
| 13 | this list of conditions and the following disclaimer in the documentation | |
| 14 | and/or other materials provided with the distribution. | |
| 15 | * Neither the name of ISPConfig nor the names of its contributors | |
| 16 | may be used to endorse or promote products derived from this software without | |
| 17 | specific prior written permission. | |
| 18 | ||
| 19 | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND | |
| 20 | ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | |
| 21 | WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. | |
| 22 | IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, | |
| 23 | INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, | |
| 24 | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, | |
| 25 | DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY | |
| 26 | OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING | |
| 27 | NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, | |
| 28 | EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
| 29 | */ | |
| 30 | ||
| 31 | class plugin_dbhistory extends plugin_base { | |
| 32 | ||
| b1a6a5 | 33 | var $module; |
| MC | 34 | var $form; |
| 35 | var $tab; | |
| 36 | var $record_id; | |
| 37 | var $formdef; | |
| 38 | var $options; | |
| 532ae5 | 39 | |
| b1a6a5 | 40 | function onShow() { |
| 532ae5 | 41 | |
| b1a6a5 | 42 | global $app, $conf; |
| MC | 43 | |
| 44 | $content = ''; | |
| 45 | ||
| 46 | $db_table = $app->tform->formDef["db_table"]; | |
| 47 | $db_table_idx = $app->tform->formDef["db_table_idx"]; | |
| 48 | $primary_id = $this->form->id; | |
| 49 | if($_SESSION["s"]["user"]["typ"] == 'admin') { | |
| 2af58c | 50 | $sql = "SELECT action, tstamp, user, data FROM sys_datalog WHERE dbtable = ? AND dbidx = ?"; |
| MC | 51 | $records = $app->db->queryAllRecords($sql, $db_table, $db_table_idx.":".$primary_id); |
| b1a6a5 | 52 | } else { |
| 2af58c | 53 | $sql = "SELECT action, tstamp, user, data FROM sys_datalog WHERE user = ? AND dbtable = ? AND dbidx = ?"; |
| MC | 54 | $records = $app->db->queryAllRecords($sql, $_SESSION["s"]["user"]["username"], $db_table, $db_table_idx.":".$primary_id); |
| b1a6a5 | 55 | } |
| MC | 56 | |
| 57 | if(is_array($records)) { | |
| 58 | $content .= '<table>'; | |
| 59 | foreach($records as $rec) { | |
| 60 | $content .= "<tr><td>".date("d.m.Y", $rec["tstamp"])."</td><td>".$rec["user"]."</td></tr>"; | |
| 61 | } | |
| 62 | $content .= '</table>'; | |
| 63 | } | |
| 64 | ||
| 65 | return $content; | |
| 66 | ||
| 67 | } | |
| 68 | ||
| 532ae5 | 69 | } |
| L | 70 | |
| b1a6a5 | 71 | ?> |
