Changeset 21048 for extensions/music_player
- Timestamp:
- Feb 26, 2013, 8:50:37 PM (11 years ago)
- Location:
- extensions/music_player
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/music_player/admin/admin.php
r14095 r21048 44 44 ///on vérife si ils n'existe pas déjà 45 45 $rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_PLAYLIST.' WHERE url IN (\''.$value.'\') ;'); 46 $res = mysql_fetch_array($rep);46 $res = pwg_db_fetch_array($rep); 47 47 if ($res['result']!=0) 48 48 { … … 111 111 /// v 1.2 on ne cree que pour les nouveaux 112 112 $rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_PLAYLIST.' WHERE url IN (\''.$value.'\') ;'); 113 $res = mysql_fetch_array($rep);113 $res = pwg_db_fetch_array($rep); 114 114 if ($res['result']!=0) 115 115 { … … 148 148 ////[ maj de la bdd 149 149 $result = pwg_query('SELECT id FROM '.MP_PLAYLIST.' WHERE url IN (\''.$value.'\') ;'); 150 $data = mysql_fetch_array($result);150 $data = pwg_db_fetch_array($result); 151 151 $query = ' 152 152 UPDATE '.MP_PLAYLIST.' … … 241 241 242 242 $result = pwg_query('SELECT id FROM '.MP_PLAYLIST.' WHERE url IN (\''.$_POST['url_'.$n.''].'\') ;'); 243 $data_pl = mysql_fetch_assoc($result);243 $data_pl = pwg_db_fetch_assoc($result); 244 244 $rang=1; 245 245 … … 283 283 284 284 $result = pwg_query('SELECT id FROM '.MP_PLAYLIST.' WHERE url=\''.$url.'\' ;'); 285 $data_pl = mysql_fetch_assoc($result);285 $data_pl = pwg_db_fetch_assoc($result); 286 286 287 287 $filename="./plugins/music_player/music/externe/".$data_pl['id'].".php"; … … 312 312 $query = 'SELECT id, url, texte FROM '.MP_PLAYLIST.' WHERE type IN (\'local\') ORDER BY id ;'; 313 313 $result = pwg_query($query); 314 while ($row = mysql_fetch_assoc($result)) {314 while ($row = pwg_db_fetch_assoc($result)) { 315 315 array_push($playlist, $row); 316 316 } … … 333 333 $query = 'SELECT id, url, texte FROM '.MP_PLAYLIST.' WHERE type IN (\'externe\') ORDER BY id ;'; 334 334 $result = pwg_query($query); 335 while ($row = mysql_fetch_assoc($result)) {335 while ($row = pwg_db_fetch_assoc($result)) { 336 336 array_push($playlist, $row); 337 337 } … … 437 437 { 438 438 $rep = pwg_query('SELECT texte FROM '.MP_PLAYLIST.' WHERE id IN (\''.$conf_lecteur[7].'\') ;'); 439 $pl = mysql_fetch_array($rep);439 $pl = pwg_db_fetch_array($rep); 440 440 $txt=$pl['texte']; 441 441 } -
extensions/music_player/admin/admin_edit.php
r10294 r21048 32 32 $query = 'SELECT texte FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_GET['id'].'\') ;'; 33 33 $result = pwg_query($query); 34 $data = mysql_fetch_assoc($result);34 $data = pwg_db_fetch_assoc($result); 35 35 $txt = stripslashes($data['texte']); 36 36 $template->append('edit_txt', … … 80 80 $query = 'SELECT url, texte FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_GET['ex_id'].'\') ;'; 81 81 $result = pwg_query($query); 82 $data = mysql_fetch_assoc($result);82 $data = pwg_db_fetch_assoc($result); 83 83 $txt = stripslashes($data['texte']); 84 84 $url = stripslashes($data['url']); … … 111 111 $query = 'SELECT pl_id, nom, url FROM '.MP_MUSIC.' WHERE id IN (\''.$_GET['music_id'].'\') ;'; 112 112 $result = pwg_query($query); 113 $data = mysql_fetch_assoc($result);113 $data = pwg_db_fetch_assoc($result); 114 114 $nom = stripslashes($data['nom']); 115 115 $url = stripslashes($data['url']); … … 131 131 $query = 'SELECT pl_id, url, rang FROM '.MP_MUSIC.' WHERE id IN (\''.$_POST['id'].'\') ;'; 132 132 $result = pwg_query($query); 133 $suppr = mysql_fetch_assoc($result);133 $suppr = pwg_db_fetch_assoc($result); 134 134 $url = stripslashes($suppr['url']); 135 135 … … 142 142 143 143 $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$suppr['pl_id'].';'); 144 $rang = mysql_fetch_assoc($rep);144 $rang = pwg_db_fetch_assoc($rep); 145 145 146 146 $i = $suppr['rang'] + 1; 147 147 while ($i<=$rang['max']) { 148 148 $rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_MUSIC.' WHERE rang IN (\''.$i.'\') AND pl_id IN (\''.$suppr['pl_id'].'\') ;'); 149 $res = mysql_fetch_array($rep);149 $res = pwg_db_fetch_array($rep); 150 150 if ($res['result'] != 0) 151 151 { 152 152 $query = 'SELECT id FROM '.MP_MUSIC.' WHERE rang IN (\''.$i.'\') AND pl_id IN (\''.$suppr['pl_id'].'\') ;'; 153 153 $result = pwg_query($query); 154 $meme = mysql_fetch_assoc($result);154 $meme = pwg_db_fetch_assoc($result); 155 155 $i_inf = $i - 1 ; 156 156 $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'].'\') ;'; 167 167 $result = pwg_query($query); 168 $data = mysql_fetch_assoc($result);168 $data = pwg_db_fetch_assoc($result); 169 169 $template->append('suppr', 170 170 array('ID'=>$_GET['suppr'], … … 237 237 { 238 238 $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].';'); 239 $rg = mysql_fetch_assoc($rep);239 $rg = pwg_db_fetch_assoc($rep); 240 240 for($i=1; $i <= $_POST['nbr'] ; $i++) 241 241 { … … 252 252 $query = 'SELECT id, rang FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' AND rang>='.$rang.' ORDER BY rang ;'; 253 253 $result = pwg_query($query); 254 while ($sup = mysql_fetch_assoc($result)){254 while ($sup = pwg_db_fetch_assoc($result)){ 255 255 256 256 $n_rang = $sup['rang'] + 1 ; … … 284 284 $query = 'SELECT url FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_POST['id_playlist'].'\') ;'; 285 285 $result = pwg_query($query); 286 $dt = mysql_fetch_assoc($result);286 $dt = pwg_db_fetch_assoc($result); 287 287 288 288 /////[ 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."%'" 314 314 $rep = pwg_query('SELECT COUNT(*) AS result FROM '.MP_MUSIC.' WHERE pl_id='.$_POST['id_playlist'].' AND url LIKE \'%'.$nom_fichier.'%\' ;'); 315 $res = mysql_fetch_array($rep);315 $res = pwg_db_fetch_array($rep); 316 316 if ($res['result']==0) 317 317 { … … 324 324 325 325 $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$_POST['id_playlist'].';'); 326 $rang = mysql_fetch_assoc($rep);326 $rang = pwg_db_fetch_assoc($rep); 327 327 $n=$rang['max']+1; 328 328 … … 350 350 $query = 'SELECT * FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' ORDER BY rang ;'; 351 351 $result = pwg_query($query); 352 while ($music = mysql_fetch_assoc($result)){352 while ($music = pwg_db_fetch_assoc($result)){ 353 353 $url = stripslashes($music['url']); 354 354 … … 371 371 $query = 'SELECT url FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_POST['id_playlist'].'\') ;'; 372 372 $result = pwg_query($query); 373 $dt = mysql_fetch_assoc($result);373 $dt = pwg_db_fetch_assoc($result); 374 374 375 375 $query = 'SELECT * FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' ORDER BY rang ;'; … … 383 383 $_xml .="\t<trackList>\r\n"; 384 384 385 while ($music = mysql_fetch_assoc($result)){385 while ($music = pwg_db_fetch_assoc($result)){ 386 386 $nom_fichier=stripslashes($music['nom']); 387 387 $url=stripslashes($music['url']); … … 408 408 $query = 'SELECT texte FROM '.MP_PLAYLIST.' WHERE id='.$_GET['music'].' ;'; 409 409 $result = pwg_query($query); 410 $playlist = mysql_fetch_assoc($result);410 $playlist = pwg_db_fetch_assoc($result); 411 411 412 412 $txt = stripslashes($playlist['texte']); … … 418 418 419 419 $rep = pwg_query('SELECT MAX(rang) AS max FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].';'); 420 $rang = mysql_fetch_assoc($rep);420 $rang = pwg_db_fetch_assoc($rep); 421 421 422 422 $query = 'SELECT * FROM '.MP_MUSIC.' WHERE pl_id='.$_GET['music'].' ORDER BY rang ;'; 423 423 $result = pwg_query($query); 424 424 $num=0; 425 while ($music = mysql_fetch_assoc($result)){425 while ($music = pwg_db_fetch_assoc($result)){ 426 426 $music_url = stripslashes($music['url']); 427 427 $music_nom = stripslashes($music['nom']); -
extensions/music_player/admin/admin_img.php
r3329 r21048 11 11 $query = 'SELECT url, texte FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_GET['id'].'\') ;'; 12 12 $result = pwg_query($query); 13 $data = mysql_fetch_assoc($result);13 $data = pwg_db_fetch_assoc($result); 14 14 15 15 -
extensions/music_player/admin/admin_suppr.php
r3329 r21048 26 26 $query = 'SELECT type FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_POST['id'].'\') ;'; 27 27 $result = pwg_query($query); 28 $typ = mysql_fetch_assoc($result);28 $typ = pwg_db_fetch_assoc($result); 29 29 if ($typ['type']=="local") 30 30 { 31 31 $query = 'SELECT url FROM '.MP_PLAYLIST.' WHERE id IN (\''.$_POST['id'].'\') ;'; 32 32 $result = pwg_query($query); 33 $dt = mysql_fetch_assoc($result);33 $dt = pwg_db_fetch_assoc($result); 34 34 $filename="./plugins/music_player/music/".$dt['url']."/"; 35 35 if (file_exists($filename)) -
extensions/music_player/lecteur.php
r9590 r21048 18 18 SELECT COUNT(*) AS result FROM '.GROUPS_TABLE.' 19 19 WHERE name IN (\'music_group\') ;'; 20 $data_grp = mysql_fetch_array(pwg_query($query));20 $data_grp = pwg_db_fetch_array(pwg_query($query)); 21 21 $exist_group = $data_grp['result']; 22 22 if ( $exist_group == 1 ) … … 26 26 $result = pwg_query($query); 27 27 $grp_id = array(); 28 while ($row = mysql_fetch_assoc($result)) {28 while ($row = pwg_db_fetch_assoc($result)) { 29 29 array_push($grp_id, $row); 30 30 } … … 33 33 { 34 34 $query = 'SELECT id FROM '.GROUPS_TABLE.' WHERE name IN (\'music_group\') ;'; 35 $rep = mysql_fetch_array(pwg_query($query));35 $rep = pwg_db_fetch_array(pwg_query($query)); 36 36 if ($rep['id']==$grp['group_id'] ) 37 37 { … … 96 96 $query = 'SELECT url, texte FROM '.MP_PLAYLIST.' WHERE type IN (\'local\') ORDER BY id ;'; 97 97 $result = pwg_query($query); 98 while ($row = mysql_fetch_assoc($result)) {98 while ($row = pwg_db_fetch_assoc($result)) { 99 99 array_push($playlist, $row); 100 100 } … … 112 112 $query = 'SELECT id, texte FROM '.MP_PLAYLIST.' WHERE type IN (\'externe\') ORDER BY id ;'; 113 113 $result = pwg_query($query); 114 while ($row = mysql_fetch_assoc($result)) {114 while ($row = pwg_db_fetch_assoc($result)) { 115 115 array_push($pl_ex, $row); 116 116 } … … 175 175 { 176 176 $rep = pwg_query('SELECT url FROM '.MP_PLAYLIST.' WHERE id IN (\''.$conf_lecteur[7].'\') ;'); 177 $pl = mysql_fetch_array($rep);177 $pl = pwg_db_fetch_array($rep); 178 178 $url=$pl['url']; 179 179 $url='music/'.$url.'/'.$url.'.xml'; -
extensions/music_player/maintain.inc.php
r12583 r21048 58 58 WHERE type="" 59 59 ;'; 60 $data_table = mysql_fetch_array(pwg_query($query));60 $data_table = pwg_db_fetch_array(pwg_query($query)); 61 61 $exist = $data_table['result']; 62 62 if ( $exist != 0 ) … … 67 67 ;'; 68 68 $result = pwg_query($query); 69 while ($data = mysql_fetch_assoc($result))69 while ($data = pwg_db_fetch_assoc($result)) 70 70 { 71 71 $query = ' … … 83 83 WHERE param IN (\'mp_lecteur\') 84 84 ;'; 85 $data_table = mysql_fetch_array(pwg_query($query));85 $data_table = pwg_db_fetch_array(pwg_query($query)); 86 86 $exist = $data_table['result']; 87 87 if ( $exist == 0 ) … … 98 98 WHERE param IN (\'mp_lecteur\') 99 99 ;'; 100 $data_conf = mysql_fetch_array(pwg_query($query));100 $data_conf = pwg_db_fetch_array(pwg_query($query)); 101 101 $conf=explode(',', $data_conf['value']); 102 102 $nbr=count($conf); … … 119 119 WHERE param IN (\'mp_plugin\') 120 120 ;'; 121 $data_table = mysql_fetch_array(pwg_query($query));121 $data_table = pwg_db_fetch_array(pwg_query($query)); 122 122 $exist = $data_table['result']; 123 123 if ( $exist == 0 ) … … 134 134 WHERE param IN (\'mp_plugin\') 135 135 ;'; 136 $data_conf = mysql_fetch_array(pwg_query($query));136 $data_conf = pwg_db_fetch_array(pwg_query($query)); 137 137 $conf=explode(',', $data_conf['value']); 138 138 $nbr=count($conf);
Note: See TracChangeset
for help on using the changeset viewer.