Changeset 21793 for extensions
- Timestamp:
- Mar 22, 2013, 10:17:32 PM (12 years ago)
- Location:
- extensions/WiredForSound
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/WiredForSound/admin/add_page_on_index.php
r3609 r21793 34 34 35 35 $q = 'SELECT id FROM ' . WFS_SOUNDS_TABLE . ' WHERE file = "' . $_POST['mp3_select'] . '";'; 36 $result = mysql_fetch_assoc(pwg_query($q));36 $result = pwg_db_fetch_assoc(pwg_query($q)); 37 37 38 38 if (empty($result)) 39 39 { 40 40 $q = 'SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_element_id FROM ' . WFS_SOUNDS_TABLE . ' ;'; 41 list($next_element_id) = mysql_fetch_array(pwg_query($q));41 list($next_element_id) = pwg_db_fetch_row(pwg_query($q)); 42 42 $q = 'INSERT INTO ' . WFS_SOUNDS_TABLE . ' ( id , file ) VALUES ( ' . $next_element_id . ' , "' . $_POST['mp3_select'] . '");'; 43 43 pwg_query($q); … … 56 56 ON sound.id = ic.sound_id 57 57 WHERE ic.cat_id = ' . $cat_id . ' AND ic.image_id IS NULL;'; 58 $result = mysql_fetch_assoc(pwg_query($q));58 $result = pwg_db_fetch_assoc(pwg_query($q)); 59 59 60 60 // Bouton de suppression -
extensions/WiredForSound/admin/add_page_on_picture.php
r3609 r21793 29 29 WHERE ic.image_id = ' . $img_id . ' AND ' . $clause . ' 30 30 ORDER BY ic.cat_id DESC;'; 31 return mysql_fetch_assoc(pwg_query($q));31 return pwg_db_fetch_assoc(pwg_query($q)); 32 32 } 33 33 … … 78 78 // Ecriture dans la table 79 79 $q = 'SELECT id FROM ' . WFS_SOUNDS_TABLE . ' WHERE file = "' . $_POST['mp3_select'] . '";'; 80 $result = mysql_fetch_assoc(pwg_query($q));80 $result = pwg_db_fetch_assoc(pwg_query($q)); 81 81 if (empty($result)) 82 82 { 83 83 $q = 'SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_element_id FROM ' . WFS_SOUNDS_TABLE . ' ;'; 84 list($next_element_id) = mysql_fetch_array(pwg_query($q));84 list($next_element_id) = pwg_db_fetch_row(pwg_query($q)); 85 85 $q = 'INSERT INTO ' . WFS_SOUNDS_TABLE . ' ( id , file ) VALUES ( ' . $next_element_id . ' , "' . $_POST['mp3_select'] . '");'; 86 86 pwg_query($q); -
extensions/WiredForSound/maintain.inc.php
r3609 r21793 9 9 $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'wfs_%"'; 10 10 $result = pwg_query($query); 11 if (! mysql_fetch_row($result))11 if (!pwg_db_fetch_assoc($result)) 12 12 { 13 13 $q = 'CREATE TABLE ' . $prefixeTable . 'wfs_img_cat_sound( -
extensions/WiredForSound/wfs_on_index.php
r3609 r21793 54 54 WHERE ic.cat_id = ' . $cat_id . ' AND ic.image_id IS NULL;'; 55 55 56 $result = mysql_fetch_assoc(pwg_query($q));56 $result = pwg_db_fetch_assoc(pwg_query($q)); 57 57 58 58 if (is_admin()) -
extensions/WiredForSound/wfs_on_picture.php
r3609 r21793 24 24 ORDER BY ic.cat_id DESC;'; 25 25 26 $result = mysql_fetch_assoc(pwg_query($q));26 $result = pwg_db_fetch_assoc(pwg_query($q)); 27 27 28 28 if (is_admin())
Note: See TracChangeset
for help on using the changeset viewer.