Changeset 20202 for extensions/Piwecard/install

Timestamp:

Jan 17, 2013, 12:06:49 AM (11 years ago)

Author:

julien1311

Message:

[piwecard] several changes (almost 2.4.a.b4)

Location:

extensions/Piwecard/install

Files:

• default_values.inc.php (modified) (1 diff)
• functions.inc.php (modified) (5 diffs)

extensions/Piwecard/install/default_values.inc.php

@@ -12 +12 @@
 $ecard_default_values['validity_default'] = '10';                                       //Default number of days a card is available
 $ecard_default_values['validity_choice'] = true;                                        //Add function for a user to choose the valid duration of an ecard
+$ecard_default_values['image_border'] = array(                                          //Add a border to the image in the ecard page
+                                                        'display'       => false,
+                                                        'style'         => 'solid',
+                                                        'width'         => '10px',
+                                                        'color'         => '#FFFFFF',
+);
 $ecard_default_values['sender_copy'] = false;                                           //Send a copy to sender
 $ecard_default_values['image_size'] = 'small';                                          //Size of the image in the ecard

extensions/Piwecard/install/functions.inc.php

@@ -2 +2 @@
 function piwecard_db_create($table) {
         $query = 'CREATE TABLE ' . $table . ' (
-                                                id CHAR(64) NOT NULL,
+                                                unique_id INT NOT NULL AUTO_INCREMENT,
+                                                ecard_id CHAR(64) NOT NULL,
                                                 sender_name CHAR(100) NOT NULL,
                                                 sender_email CHAR(100) NOT NULL,
@@ -12 +13 @@
                                                 date_creation DATETIME NOT NULL,
                                                 date_validity DATETIME DEFAULT NULL,
-                                                PRIMARY KEY (id)
+                                                PRIMARY KEY (unique_id)
                                         ) DEFAULT CHARSET=utf8;';
         pwg_query($query);
@@ -22 +23 @@
 }
 
-function piwecard_db_populate($old_table, $new_table) {
+function piwecard_db_update_from_2_3($old_table, $new_table) {
         $query = 'SELECT * FROM '.$old_table.';';
         $result = pwg_query($query);
@@ -28 +29 @@
         while($data = pwg_db_fetch_assoc($result)) {
                 $insert = array(
-                                        'id' => $data['numero'],
+                                        'ecard_id' => $data['numero'],
                                         'sender_name' => $data['nomexp'],
                                         'sender_email' => $data['adrexp'],
@@ -48 +49 @@
 }
 
+function piwecard_db_update_from_2_4a_b3($table) {
+        $query = 'ALTER TABLE '.$table.' DROP PRIMARY KEY;';
+        $result = pwg_query($query);
+        $query = 'ALTER TABLE '.$table.' ADD unique_id INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (unique_id);';
+        $result = pwg_query($query);
+        $query = 'ALTER TABLE '.$table.' CHANGE id ecard_id CHAR(64) NOT NULL;';
+        $result = pwg_query($query);
+}
+
 function piwecard_conf_create($name) {
         $query = 'INSERT INTO '.CONFIG_TABLE.' (param,value,comment) VALUES ("'.$name.'","","'.ucfirst($name).' configuration");';