Verzeichnisstruktur phpBB-3.1.0
- Veröffentlicht
- 27.10.2014
So funktioniert es
|
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
profilefield_field_validation_length.php
01 <?php
02 /**
03 *
04 * This file is part of the phpBB Forum Software package.
05 *
06 * @copyright (c) phpBB Limited <https://www.phpbb.com>
07 * @license GNU General Public License, version 2 (GPL-2.0)
08 *
09 * For full copyright and license information, please see
10 * the docs/CREDITS.txt file.
11 *
12 */
13
14 namespace phpbb\db\migration\data\v310;
15
16 class profilefield_field_validation_length extends \phpbb\db\migration\migration
17 {
18 protected $validation_options_old = array(
19 'ALPHA_SPACERS' => '[\w_\+\. \-\[\]]+',
20 );
21
22 protected $validation_options_new = array(
23 'ALPHA_SPACERS' => '[\w\x20_+\-\[\]]+',
24 );
25
26 static public function depends_on()
27 {
28 return array(
29 '\phpbb\db\migration\data\v310\rc3',
30 );
31 }
32
33 public function update_schema()
34 {
35 return array(
36 'change_columns' => array(
37 $this->table_prefix . 'profile_fields' => array(
38 'field_validation' => array('VCHAR_UNI:64', ''),
39 ),
40 ),
41 );
42 }
43
44 public function revert_schema()
45 {
46 return array(
47 'change_columns' => array(
48 $this->table_prefix . 'profile_fields' => array(
49 'field_validation' => array('VCHAR_UNI:20', ''),
50 ),
51 ),
52 );
53 }
54
55 public function update_data()
56 {
57 return array(
58 array('custom', array(array($this, 'update_profile_fields_validation'))),
59 );
60 }
61
62 public function revert_data()
63 {
64 return array(
65 array('custom', array(array($this, 'revert_profile_fields_validation'))),
66 );
67 }
68
69 public function update_profile_fields_validation()
70 {
71 foreach ($this->validation_options_new as $validation_type => $regex)
72 {
73 $sql = 'UPDATE ' . $this->table_prefix . "profile_fields
74 SET field_validation = '" . $this->db->sql_escape($this->validation_options_new[$validation_type]) . "'
75 WHERE field_validation = '" . $this->db->sql_escape($this->validation_options_old[$validation_type]) . "'";
76 $this->sql_query($sql);
77 }
78 }
79
80 public function revert_profile_fields_validation()
81 {
82 foreach ($this->validation_options_new as $validation_type => $regex)
83 {
84 $sql = 'UPDATE ' . $this->table_prefix . "profile_fields
85 SET field_validation = '" . $this->db->sql_escape($this->validation_options_old[$validation_type]) . "'
86 WHERE field_validation = '" . $this->db->sql_escape($this->validation_options_new[$validation_type]) . "'";
87 $this->sql_query($sql);
88 }
89 }
90 }
91