Changeset 22762


Ignore:
Timestamp:
May 20, 2013, 5:46:44 PM (7 years ago)
Author:
flop25
Message:

adding IF NOT EXISTS
changing a remaining mysql* fucntion

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/music_player/maintain.inc.php

    r21048 r22762  
    44{
    55  global $prefixeTable;
    6   $q = 'CREATE TABLE ' . $prefixeTable . 'mp_playlist (
     6  $q = 'CREATE TABLE IF NOT EXISTS ' . $prefixeTable . 'mp_playlist (
    77        id BIGINT NOT NULL AUTO_INCREMENT ,
    88        type VARCHAR( 50 ) NOT NULL ,
     
    1313  ';
    1414  pwg_query($q);
    15   $q = 'CREATE TABLE ' . $prefixeTable . 'mp_music (
     15  $q = 'CREATE TABLE IF NOT EXISTS ' . $prefixeTable . 'mp_music (
    1616        id BIGINT NOT NULL AUTO_INCREMENT ,
    1717        pl_id BIGINT NOT NULL ,
     
    4545  $q = pwg_query('SHOW COLUMNS FROM '.$prefixeTable.'mp_playlist');
    4646  $champ = array();
    47   while ($rep = mysql_fetch_row($q))
     47  while ($rep = pwg_db_fetch_row($q))
    4848  {
    4949    array_push($champ, $rep[0]);
Note: See TracChangeset for help on using the changeset viewer.