5 <p style="margin-top: 5px; margin-bottom: 4px; text-align: center;">
6 <button onclick="return passwd_delete()">Passwort löschen</button>
7 <button onclick="return passwd_set()">Passwort setzen</button>
12 function passwd_delete_callback(data)
15 info('Preis gespeichert');
18 function passwd_delete()
20 var eid = document.getElementById('edit_id');
21 if (!eid || !eid.value.length) return false;
23 var source = document.getElementById('source');
24 if (!source) return false;
26 var parms = 'source=' + source.innerHTML + '&callback=delete&';
27 parms += 'id=' + eid.value;
29 ajax_request('function', parms, passwd_delete_callback);
34 var passwd_popup = false;
35 function passwd_setpw_callback(data)
38 info('Neues Passwort gespeichert');
41 function passwd_setpw()
43 passwd_popup.closePopup();
45 var pw1 = document.getElementById('pw_pass1');
46 var pw2 = document.getElementById('pw_pass2');
48 if (!pw1.value.length || !pw2.value.length || pw1.value != pw2.value) {
49 alert("Die Passwörter stimmen nicht überein!");
53 var source = document.getElementById('source');
54 var pw_id = document.getElementById('pw_id');
55 var pw_pass = document.getElementById('pw_pass1');
57 var parms = 'source=' + source.innerHTML + '&callback=setpw';
58 parms += '&id=' + pw_id.value;
59 parms += '&passwd=' + pw_pass.value;
61 ajax_request('function', parms, passwd_setpw_callback);
68 var edit_id = document.getElementById('edit_id');
70 if (!edit_id.value.length) return false;
76 var options = {hideOnClick: false, canDragFunc: true };
77 passwd_popup = new Rico.Popup(options);
78 passwd_popup.createWindow('<b>Neues Passwort setzen</b>','',height+'px',width+'px');
79 passwd_popup.contentDiv.style.backgroundColor='#e0e0e0';
80 passwd_popup.contentDiv.innerHTML = [
81 '<div class="form" style="margin-left: 10px; margin-right: 12px; padding-left: 10px; padding-bottom: 7px;">',
82 '<input type="hidden" name="pw_id" id="pw_id">',
83 '<label for="pw_email">E-Mail Adresse:</label><br>',
84 '<input type="text" name="pw_email" id="pw_email" size="23" readonly>',
85 '<div style="height: 5px;"></div>',
86 '<label for="pw_pass1">Neues Passwort:</label><br>',
87 '<input type="password" name="pw_pass1" id="pw_pass1" size="23">',
88 '<div style="height: 5px;"></div>',
89 '<label for="pw_pass2">erneut eingeben:</label><br>',
90 '<input type="password" name="pw_pass2" id="pw_pass2" size="23">',
91 '<div style="height: 5px;"></div>',
92 '<button onclick="return passwd_setpw()">Passwort setzen</button>',
97 var edit_username = document.getElementById('edit_username');
98 var edit_vmail_domain_id = document.getElementById('edit_vmail_domain_id');
100 var pw_id = document.getElementById('pw_id');
101 var pw_email = document.getElementById('pw_email');
103 pw_id.value = edit_id.value;
104 pw_email.value = edit_username.value + '@' + edit_vmail_domain_id.options[edit_vmail_domain_id.selectedIndex].innerHTML;
106 var x = Math.floor((RicoUtil.windowWidth()-width)/2);
107 var y = Math.floor((RicoUtil.windowHeight()-height)/2);
108 passwd_popup.openPopup(x,y);
110 var pw_pass1 = document.getElementById('pw_pass1');
112 var pw_pass1 = document.getElementById('pw_pass2');
121 'table' => 'vmail_user',
122 'title' => 'Mailboxen und Weiterleitungen',
123 'join' => array('vmail_domain ON vmail_domain_id = vmail_domain.id'),
128 'sql' => 'vmail_user.id',
134 'sql' => "username || '@' || name",
135 'specs' => "filterUI: 't'",
140 'specs' => "filterUI: 't'",
145 'specs' => "ClassName: 'aligncenter'",
146 'control' => "new Rico.TableColumn.checkbox('t', 'f',0,1)",
147 'sql' => 'password IS NOT NULL AND length(password) > 0',
152 'specs' => "ClassName: 'aligncenter'",
153 'control' => "new Rico.TableColumn.checkbox(1, 0,0,1)",
163 'vmail_domain_id' => array(
166 'options' => 'SELECT id,name AS text FROM vmail_domain ORDER BY name',
167 'option_empty' => '-- select --',
178 'name' => 'Passwort',
182 'func' => 'passwd_encrypt',
186 'name' => 'aktiviert',
195 'callbacks' => array(
196 'delete' => 'cb_delete',
197 'setpw' => 'cb_setpw',
201 function passwd_encrypt($pw)
210 $sql = sprintf("UPDATE vmail_user SET password = NULL WHERE id = %d", $_POST['id']);
212 $sth = $db->query($sql);
221 $sql = sprintf("UPDATE vmail_user SET password = '%s' WHERE id = %d",
222 passwd_encrypt($_POST['passwd']),
225 $sth = $db->query($sql);