Access Skype SQLite Database

I was working for Online Radio Server setup with Icecast and Skype. This Radio Station was using Skype Group Calls with real listeners of station then I have to feed Live Skype Audio to Icecast Radio Server as Input.

Radio Setup Tools Online Radio Schedule with Skype & Icecast

– SAM Broadcaster
– Icecast Server
– Skype account as Radio Station
– Virtual Audio Cable to manage Icecast / Skype Patch

Radio Listeners normally connect to Radio Server Skype from Website. Listeners can send contact request to Skype then Radio Server Manager Schedule some calls based on Radio Schedule. Radio Server Skype Auto Connect new Skype requests

Radio Station with Icecast Skype Features

– Listeners can chat live on Skype
– Selected Listeners can participate in Live Talk

Now I need to show real status of Radio Server Skype on the Radio Station Website??

I know Skype use SQLite to save Database on computer here “C:/Users/[Radio-Server]/AppData/Roaming/Skype/[Radio-Skype]/main.db”

So, I just have query some tables to get REAL Status of Radio Server Skype

– Radio Server Skype is busy in any CALL?
– Radio Server Skype is Free for next CALL?
– Any Live Radio Schedule is running using Skype Calls?

Skype-SQLite

SQLite Tools

DB Browser for SQLite
Skyperious is a Skype database viewer and merger in Python

Skype-SQLite

PHP with SQLite extension to access Skype Database

PHP-PDO-SQLite

PHP-SQLite

<?php
$skype_path = "C:/Users/[Radio-Server]/AppData/Roaming/Skype/[Radio-Skype]/main.db";

// Path for skype main.db file
$db = new SQLite3($skype_path);

$query = "SELECT id, name FROM Calls where is_active='1';";

$stmt = $db->prepare($query);
$results = $stmt->execute();

$call 	= $results->fetchArray();


// Get all Mamabers for current Skype CALL
$query = "SELECT id, identity, guid FROM CallMembers where call_name='".$call['name']."';";

$stmt = $db->prepare($query);
$results = $stmt->execute();

echo "<pre>";

while($data = $results->fetchArray()){

// Print all records in current Skype CALL
print_r($data); 

}

echo "</pre>";

$db->close();

?>

SQLite-CMD