Changeset 21793


Ignore:
Timestamp:
Mar 22, 2013, 10:17:32 PM (11 years ago)
Author:
ddtddt
Message:

[extensions] - WiredForSound - change to 2.5

Location:
extensions/WiredForSound
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • extensions/WiredForSound/admin/add_page_on_index.php

    r3609 r21793  
    3434
    3535  $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));
    3737
    3838  if (empty($result))
    3939  {
    4040    $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));
    4242    $q = 'INSERT INTO ' . WFS_SOUNDS_TABLE . ' ( id , file ) VALUES ( ' . $next_element_id . ' , "' . $_POST['mp3_select'] . '");';
    4343    pwg_query($q);
    … …  
    5656ON sound.id = ic.sound_id
    5757WHERE 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));
    5959
    6060// Bouton de suppression

  • extensions/WiredForSound/admin/add_page_on_picture.php

    r3609 r21793  
    2929WHERE ic.image_id = ' . $img_id . '  AND ' . $clause . '
    3030ORDER BY ic.cat_id DESC;';
    31     return mysql_fetch_assoc(pwg_query($q));
     31    return pwg_db_fetch_assoc(pwg_query($q));
    3232}
    3333
    … …  
    7878  // Ecriture dans la table
    7979  $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));
    8181  if (empty($result))
    8282  {
    8383    $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));
    8585    $q = 'INSERT INTO ' . WFS_SOUNDS_TABLE . ' ( id , file ) VALUES ( ' . $next_element_id . ' , "' . $_POST['mp3_select'] . '");';
    8686    pwg_query($q);

  • extensions/WiredForSound/maintain.inc.php

    r3609 r21793  
    99  $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'wfs_%"';
    1010  $result = pwg_query($query);
    11   if (!mysql_fetch_row($result))
     11  if (!pwg_db_fetch_assoc($result))
    1212  {
    1313    $q = 'CREATE TABLE ' . $prefixeTable . 'wfs_img_cat_sound(

  • extensions/WiredForSound/wfs_on_index.php

    r3609 r21793  
    5454WHERE ic.cat_id = ' . $cat_id . ' AND ic.image_id IS NULL;';
    5555
    56 $result = mysql_fetch_assoc(pwg_query($q));
     56$result = pwg_db_fetch_assoc(pwg_query($q));
    5757
    5858if (is_admin())

  • extensions/WiredForSound/wfs_on_picture.php

    r3609 r21793  
    2424ORDER BY ic.cat_id DESC;';
    2525
    26 $result = mysql_fetch_assoc(pwg_query($q));
     26$result = pwg_db_fetch_assoc(pwg_query($q));
    2727
    2828if (is_admin())
Note: See TracChangeset for help on using the changeset viewer.