Rev 11 | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
2 | daniel-mar | 1 | <?php |
2 | |||
14 | daniel-mar | 3 | if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
2 | daniel-mar | 4 | |
5 | if (($konfiguration[$m2]['enable_gast'] == '1') && ($konfiguration[$m2]['wipe_gastkonto'])) |
||
6 | { |
||
11 | daniel-mar | 7 | $rs = db_query("SELECT `id` FROM `".$mysql_zugangsdaten['praefix']."users` WHERE `username` = '".$konfiguration[$m2]['gast_username']."' AND MD5('".$konfiguration[$m2]['gast_passwort']."') = `passwort`");// TODO: use sha3 hash, salted and peppered |
2 | daniel-mar | 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 `".$mysql_zugangsdaten['praefix']."konfig` WHERE `name` = 'last_wipe' AND CONCAT(`wert`, ' ', '".$konfiguration[$m2]['wipe_uhrzeit']."') <= DATE_SUB(NOW(), INTERVAL 1 DAY) AND `modul` = '".db_escape($m2)."'"); |
||
15 | if (db_num($res) > 0) |
||
16 | { |
||
17 | // Für was den ganzen Fetz? Wenn PHP und MySQL Zeit verschieden sind (z.B. auf unterschiedliche Server verteilt), gäbe es Probleme! |
||
18 | $rs = db_query("SELECT NOW()"); |
||
19 | $rw = db_fetch($rs); |
||
20 | $ary = explode(' ', $rw[0]); |
||
21 | $dat = $ary[0]; |
||
22 | |||
23 | ib_change_config('last_wipe', $dat, $m2); |
||
24 | |||
25 | foreach($tabellen as $m1 => $m2) |
||
26 | { |
||
27 | if (isset($datenbanktabellen[$mysql_zugangsdaten['praefix'].$m2]['user'])) |
||
28 | db_query("DELETE FROM `".$mysql_zugangsdaten['praefix']."$m2` WHERE `user` = '$my_id'"); |
||
29 | } |
||
30 | |||
31 | unset($m1); |
||
32 | unset($m2); |
||
33 | } |
||
34 | } |
||
35 | } |
||
36 | |||
3 | daniel-mar | 37 | ?> |