Changeset 22762 for extensions/music_player/maintain.inc.php

Timestamp:

May 20, 2013, 5:46:44 PM (11 years ago)

Author:

flop25

Message:

adding IF NOT EXISTS
changing a remaining mysql* fucntion

File:

• extensions/music_player/maintain.inc.php (modified) (3 diffs)

extensions/music_player/maintain.inc.php

@@ -4 +4 @@
 {
   global $prefixeTable;
-  $q = 'CREATE TABLE ' . $prefixeTable . 'mp_playlist (
+  $q = 'CREATE TABLE IF NOT EXISTS ' . $prefixeTable . 'mp_playlist (
         id BIGINT NOT NULL AUTO_INCREMENT ,
         type VARCHAR( 50 ) NOT NULL ,
@@ -13 +13 @@
   ';
   pwg_query($q);
-  $q = 'CREATE TABLE ' . $prefixeTable . 'mp_music (
+  $q = 'CREATE TABLE IF NOT EXISTS ' . $prefixeTable . 'mp_music (
         id BIGINT NOT NULL AUTO_INCREMENT ,
         pl_id BIGINT NOT NULL ,
@@ -45 +45 @@
   $q = pwg_query('SHOW COLUMNS FROM '.$prefixeTable.'mp_playlist');
   $champ = array();
-  while ($rep = mysql_fetch_row($q))
+  while ($rep = pwg_db_fetch_row($q))
   {
     array_push($champ, $rep[0]);