Changeset 20202 for extensions/Piwecard/install
- Timestamp:
- Jan 17, 2013, 12:06:49 AM (11 years ago)
- Location:
- extensions/Piwecard/install
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/Piwecard/install/default_values.inc.php
r20180 r20202 12 12 $ecard_default_values['validity_default'] = '10'; //Default number of days a card is available 13 13 $ecard_default_values['validity_choice'] = true; //Add function for a user to choose the valid duration of an ecard 14 $ecard_default_values['image_border'] = array( //Add a border to the image in the ecard page 15 'display' => false, 16 'style' => 'solid', 17 'width' => '10px', 18 'color' => '#FFFFFF', 19 ); 14 20 $ecard_default_values['sender_copy'] = false; //Send a copy to sender 15 21 $ecard_default_values['image_size'] = 'small'; //Size of the image in the ecard -
extensions/Piwecard/install/functions.inc.php
r20104 r20202 2 2 function piwecard_db_create($table) { 3 3 $query = 'CREATE TABLE ' . $table . ' ( 4 id CHAR(64) NOT NULL, 4 unique_id INT NOT NULL AUTO_INCREMENT, 5 ecard_id CHAR(64) NOT NULL, 5 6 sender_name CHAR(100) NOT NULL, 6 7 sender_email CHAR(100) NOT NULL, … … 12 13 date_creation DATETIME NOT NULL, 13 14 date_validity DATETIME DEFAULT NULL, 14 PRIMARY KEY ( id)15 PRIMARY KEY (unique_id) 15 16 ) DEFAULT CHARSET=utf8;'; 16 17 pwg_query($query); … … 22 23 } 23 24 24 function piwecard_db_ populate($old_table, $new_table) {25 function piwecard_db_update_from_2_3($old_table, $new_table) { 25 26 $query = 'SELECT * FROM '.$old_table.';'; 26 27 $result = pwg_query($query); … … 28 29 while($data = pwg_db_fetch_assoc($result)) { 29 30 $insert = array( 30 ' id' => $data['numero'],31 'ecard_id' => $data['numero'], 31 32 'sender_name' => $data['nomexp'], 32 33 'sender_email' => $data['adrexp'], … … 48 49 } 49 50 51 function piwecard_db_update_from_2_4a_b3($table) { 52 $query = 'ALTER TABLE '.$table.' DROP PRIMARY KEY;'; 53 $result = pwg_query($query); 54 $query = 'ALTER TABLE '.$table.' ADD unique_id INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (unique_id);'; 55 $result = pwg_query($query); 56 $query = 'ALTER TABLE '.$table.' CHANGE id ecard_id CHAR(64) NOT NULL;'; 57 $result = pwg_query($query); 58 } 59 50 60 function piwecard_conf_create($name) { 51 61 $query = 'INSERT INTO '.CONFIG_TABLE.' (param,value,comment) VALUES ("'.$name.'","","'.ucfirst($name).' configuration");';
Note: See TracChangeset
for help on using the changeset viewer.