<?php

$db = pg_connect("dbname=mairlist user=mairlist password=XX hostaddr=192.168.2.30");
$query = "SELECT * FROM items";

mysql_connect("radiosonar.co.uk", "radiosonar.co.uk", "ja#l3awyu") or die(mysql_error());
mysql_select_db("radiosonar_cms") or die(mysql_error());

$result = pg_query($query);
if(!$result){
        echo "Problem with query " . $query . "<br/>";
        echo pg_last_error();
        exit();
}

mysql_query("TRUNCATE TABLE audio_library");

while($row = pg_fetch_assoc($result)){
        $id = $row['idx'];
        $title = addslashes($row['title']);
        $artist = addslashes($row['artists']);
        $type = addslashes($row['type']);
        $duration = $row['duration'];
        $totalduration = $row['totalduration'];
        $created = $row['created'];
        mysql_query("INSERT INTO audio_library(id, title, artists, type, duration, total_duration, created) VALUES('$id', '$title', '$artist', '$type', '$du$
}

$query = "SELECT * FROM folders";

$result = pg_query($query);
if(!$result){
        echo "Problem with query " . $query . "<br/>";
        echo pg_last_error();
        exit();
}

mysql_query("TRUNCATE TABLE audio_folders");

while($row = pg_fetch_assoc($result)){
        $id = $row['idx'];
        $station = $row['station'];
        $parent = $row['parent'];
        $name = addslashes($row['name']);
        $description = addslashes($row['description']);
        mysql_query("INSERT into audio_folders(id,station,parent,name,description) VALUES ('$id', '$station', '$parent', '$name', '$description') ") or die($
}

$query = "SELECT * FROM item_folders";

$result = pg_query($query);
if(!$result){
        echo "Problem with query " . $query . "<br/>";
        echo pg_last_error();
        exit();
}



mysql_query("TRUNCATE TABLE audio_folder_items");

while($row = pg_fetch_assoc($result)){
        $item = $row['item'];
        $station = $row['station'];
        $folder = $row['folder'];
        mysql_query("INSERT into audio_folder_items(item,station,folder) VALUES ('$item', '$station', '$folder') ") or die(mysql_error());
}


pg_freeresult($result);
pg_close($db);

?>