Changeset 21048 for extensions/music_player/admin/admin_edit.php

Timestamp:

Feb 26, 2013, 8:50:37 PM (11 years ago)

Author:

flop25

Message:

-compatibility 2.5 (only)

File:

• extensions/music_player/admin/admin_edit.php (modified) (16 diffs)

extensions/music_player/admin/admin_edit.php

@@ -32 +32 @@
   $query = 'SELECT texte FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_GET['id'].'\') ;';
   $result = pwg_query($query);
-  $data = mysql_fetch_assoc($result);
+  $data = pwg_db_fetch_assoc($result);
   $txt = stripslashes($data['texte']);
   $template->append('edit_txt',
@@ -80 +80 @@
   $query = 'SELECT url, texte FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_GET['ex_id'].'\') ;';
   $result = pwg_query($query);
-  $data = mysql_fetch_assoc($result);
+  $data = pwg_db_fetch_assoc($result);
   $txt = stripslashes($data['texte']);
   $url = stripslashes($data['url']);
@@ -111 +111 @@
   $query = 'SELECT pl_id, nom, url FROM '.MP_MUSIC.' WHERE id IN (\''.$_GET['music_id'].'\') ;';
   $result = pwg_query($query);
-  $data = mysql_fetch_assoc($result);
+  $data = pwg_db_fetch_assoc($result);
   $nom = stripslashes($data['nom']);
   $url = stripslashes($data['url']);
@@ -131 +131 @@
   $query = 'SELECT pl_id, url, rang FROM '.MP_MUSIC.' WHERE id IN (\''.$_POST['id'].'\') ;';
   $result = pwg_query($query);
-  $suppr = mysql_fetch_assoc($result);
+  $suppr = pwg_db_fetch_assoc($result);
   $url = stripslashes($suppr['url']);
   
@@ -142 +142 @@
 
   $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$suppr['pl_id'].';');
-  $rang = mysql_fetch_assoc($rep);
+  $rang = pwg_db_fetch_assoc($rep);
 
   $i = $suppr['rang'] + 1;
   while ($i<=$rang['max']) {
     $rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_MUSIC.' WHERE rang IN (\''.$i.'\') AND pl_id IN (\''.$suppr['pl_id'].'\') ;');
-    $res = mysql_fetch_array($rep);
+    $res = pwg_db_fetch_array($rep);
     if ($res['result'] != 0)
     {
       $query = 'SELECT id FROM '.MP_MUSIC.' WHERE rang IN (\''.$i.'\') AND pl_id IN (\''.$suppr['pl_id'].'\') ;';
       $result = pwg_query($query);
-          $meme = mysql_fetch_assoc($result);
+          $meme = pwg_db_fetch_assoc($result);
           $i_inf = $i - 1 ;
           $query = 'UPDATE '.MP_MUSIC.' SET rang=\''.$i_inf.'\' WHERE id IN (\''.$meme['id'].'\') ;';
@@ -166 +166 @@
   $query = 'SELECT pl_id, nom FROM '.MP_MUSIC.' WHERE id IN (\''.$_GET['suppr'].'\') ;';
   $result = pwg_query($query);
-  $data = mysql_fetch_assoc($result);
+  $data = pwg_db_fetch_assoc($result);
   $template->append('suppr',
                                array('ID'=>$_GET['suppr'],
@@ -237 +237 @@
 {
  $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].';');
- $rg = mysql_fetch_assoc($rep);
+ $rg = pwg_db_fetch_assoc($rep);
  for($i=1; $i <= $_POST['nbr'] ; $i++)
  {
@@ -252 +252 @@
       $query = 'SELECT id, rang FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' AND rang>='.$rang.' ORDER BY rang ;';
       $result = pwg_query($query);
-      while ($sup = mysql_fetch_assoc($result)){
+      while ($sup = pwg_db_fetch_assoc($result)){
           
             $n_rang = $sup['rang'] + 1 ;
@@ -284 +284 @@
   $query = 'SELECT url FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_POST['id_playlist'].'\') ;';
   $result = pwg_query($query);
-  $dt = mysql_fetch_assoc($result);
+  $dt = pwg_db_fetch_assoc($result);
 
 /////[ recup music 
@@ -313 +313 @@
            //$rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_MUSIC.' WHERE pl_id='.$_POST['id_playlist'].' AND url REGEXP \''.$nom_fichier.'\' ;');like '%".$recherche."%'"
            $rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_MUSIC.' WHERE pl_id='.$_POST['id_playlist'].' AND url LIKE \'%'.$nom_fichier.'%\' ;');
-       $res = mysql_fetch_array($rep);
+       $res = pwg_db_fetch_array($rep);
            if ($res['result']==0)
            {
@@ -324 +324 @@
   
   $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$_POST['id_playlist'].';');
-  $rang = mysql_fetch_assoc($rep);
+  $rang = pwg_db_fetch_assoc($rep);
   $n=$rang['max']+1;
 
@@ -350 +350 @@
   $query = 'SELECT * FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' ORDER BY rang ;';
   $result = pwg_query($query);
-  while ($music = mysql_fetch_assoc($result)){
+  while ($music = pwg_db_fetch_assoc($result)){
   $url = stripslashes($music['url']);
   
@@ -371 +371 @@
   $query = 'SELECT url FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_POST['id_playlist'].'\') ;';
   $result = pwg_query($query);
-  $dt = mysql_fetch_assoc($result);
+  $dt = pwg_db_fetch_assoc($result);
 
   $query = 'SELECT * FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' ORDER BY rang ;';
@@ -383 +383 @@
       $_xml .="\t<trackList>\r\n";
 
-      while ($music = mysql_fetch_assoc($result)){
+      while ($music = pwg_db_fetch_assoc($result)){
             $nom_fichier=stripslashes($music['nom']);
             $url=stripslashes($music['url']);
@@ -408 +408 @@
   $query = 'SELECT texte FROM '.MP_PLAYLIST.' WHERE id='.$_GET['music'].' ;';
   $result = pwg_query($query);
-  $playlist = mysql_fetch_assoc($result);
+  $playlist = pwg_db_fetch_assoc($result);
   
   $txt = stripslashes($playlist['texte']);
@@ -418 +418 @@
 
   $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].';');
-  $rang = mysql_fetch_assoc($rep);
+  $rang = pwg_db_fetch_assoc($rep);
     
   $query = 'SELECT * FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' ORDER BY rang ;';
   $result = pwg_query($query);
   $num=0;
-   while ($music = mysql_fetch_assoc($result)){
+   while ($music = pwg_db_fetch_assoc($result)){
     $music_url = stripslashes($music['url']);
     $music_nom = stripslashes($music['nom']);