1 | <?php |
---|
2 | function piwecard_db_create($table) { |
---|
3 | $query = 'CREATE TABLE ' . $table . ' ( |
---|
4 | id CHAR(64) NOT NULL, |
---|
5 | sender_name CHAR(100) NOT NULL, |
---|
6 | sender_email CHAR(100) NOT NULL, |
---|
7 | recipient_name CHAR(100) NOT NULL, |
---|
8 | recipient_email CHAR(100) NOT NULL, |
---|
9 | subject CHAR(100) NOT NULL, |
---|
10 | message TEXT NOT NULL, |
---|
11 | image MEDIUMINT(8) NOT NULL, |
---|
12 | date_creation DATETIME NOT NULL, |
---|
13 | date_validity DATETIME DEFAULT NULL, |
---|
14 | PRIMARY KEY (id) |
---|
15 | ) DEFAULT CHARSET=utf8;'; |
---|
16 | pwg_query($query); |
---|
17 | } |
---|
18 | |
---|
19 | function piwecard_db_delete($table) { |
---|
20 | $query = 'DROP TABLE ' . $table . ';'; |
---|
21 | pwg_query($query); |
---|
22 | } |
---|
23 | |
---|
24 | function piwecard_db_populate($old_table, $new_table) { |
---|
25 | $query = 'SELECT * FROM '.$old_table.';'; |
---|
26 | $result = pwg_query($query); |
---|
27 | |
---|
28 | while($data = mysql_fetch_assoc($result)) { |
---|
29 | $insert = array( |
---|
30 | 'id' => $data['numero'], |
---|
31 | 'sender_name' => $data['nomexp'], |
---|
32 | 'sender_email' => $data['adrexp'], |
---|
33 | 'recipient_name' => $data['nomdest'], |
---|
34 | 'recipient_email' => $data['adrdest'], |
---|
35 | 'subject' => $data['sujet'], |
---|
36 | 'message' => $data['message'], |
---|
37 | 'image' => $data['image'], |
---|
38 | 'date_creation' => $data['date'], |
---|
39 | ); |
---|
40 | if ($data['duration'] != '0') { |
---|
41 | $date = new DateTime($data['date']); |
---|
42 | $date->modify("+".$data['duration']." day"); |
---|
43 | $insert['date_validity'] = $date->format('Y-m-d H:i:s'); |
---|
44 | } |
---|
45 | |
---|
46 | single_insert($new_table, $insert); |
---|
47 | } |
---|
48 | } |
---|
49 | |
---|
50 | function piwecard_conf_create($name) { |
---|
51 | $query = 'INSERT INTO '.CONFIG_TABLE.' (param,value,comment) VALUES (."'.$name.'","","'.ucfirst($name).' configuration");'; |
---|
52 | pwg_query($query); |
---|
53 | } |
---|
54 | |
---|
55 | function piwecard_conf_delete($name){ |
---|
56 | $query = 'DELETE FROM '.CONFIG_TABLE.' WHERE param="'.$name.'";'; |
---|
57 | pwg_query($query); |
---|
58 | } |
---|
59 | |
---|
60 | function piwecard_conf_rename($old_name, $new_name){ |
---|
61 | $query = 'UPDATE '.CONFIG_TABLE.' SET param="'.$new_name.'" WHERE param="'.$old_name.'";'; |
---|
62 | pwg_query($query); |
---|
63 | } |
---|
64 | ?> |
---|