Go to most recent revision | Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | daniel-mar | 1 | <?php |
| 2 | |||
| 3 | if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
||
| 4 | |||
| 5 | if (($configuration[$m2]['enable_gast'] == '1') && ($configuration[$m2]['wipe_gastkonto'])) |
||
| 6 | { |
||
| 7 | $rs = db_query("SELECT `id` FROM `".$WBConfig->getMySQLPrefix()."users` WHERE `username` = '".$configuration[$m2]['gast_username']."' AND MD5('".$configuration[$m2]['gast_password']."') = `password`"); |
||
| 8 | |||
| 9 | if (db_num($rs) == 1) |
||
| 10 | { |
||
| 11 | $rw = db_fetch($rs); |
||
| 12 | $my_id = $rw['id']; |
||
| 13 | |||
| 14 | $res = db_query("SELECT * FROM `".$WBConfig->getMySQLPrefix()."configuration` WHERE `name` = 'last_wipe' AND CONCAT(`value`, ' ', '".$configuration[$m2]['wipe_uhrzeit']."') <= DATE_SUB(NOW(), INTERVAL 1 DAY) AND `module` = '".db_escape($m2)."'"); |
||
| 15 | if (db_num($res) > 0) |
||
| 16 | { |
||
| 17 | $ary = explode(' ', db_time()); |
||
| 18 | $dat = $ary[0]; |
||
| 19 | |||
| 20 | wb_change_config('last_wipe', $dat, $m2); |
||
| 21 | |||
| 22 | foreach($tables_modules as $m1 => $m2) |
||
| 23 | { |
||
| 24 | if (isset($tables_database[$m1]['user_cnid'])) |
||
| 25 | { |
||
| 26 | db_query("DELETE FROM `$m1` WHERE `user_cnid` = '$my_id'"); |
||
| 27 | if (db_affected_rows() > 0) |
||
| 28 | { |
||
| 29 | db_query("OPTIMIZE TABLE `$m1`"); |
||
| 30 | } |
||
| 31 | } |
||
| 32 | } |
||
| 33 | |||
| 34 | unset($m1); |
||
| 35 | unset($m2); |
||
| 36 | } |
||
| 37 | } |
||
| 38 | } |
||
| 39 | |||
| 40 | ?> |