xbmcjsonlib.php

<?php
require_once "config.php";

$COMM_ERROR = "\n<p><strong>XBMC could not be reached.</strong></p>\n<p>Check your <a href='settings.php#XBMC'>XBMC Settings</a> are correct.</p>\n";
$JSON_ERROR = "\n<p><strong>XBMC could not be reached.</strong></p>\n<p>Check your <a href='settings.php#XBMC'>XBMC Settings</a> are correct.</p>\n";
$videodetailfields = '"genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album"';

$xbmcJsonMethods = array(
		// Methods not requiring parameters
		'JSONRPC.Version'               => array('call' => '{"jsonrpc": "2.0", "method": "JSONRPC.Version", "id": 1}'),
		'JSONRPC.Introspect'            => array('call' => '{"jsonrpc": "2.0", "method": "JSONRPC.Introspect", "id": 1}'),
		'JSONRPC.Permission'            => array('call' => '{"jsonrpc": "2.0", "method": "JSONRPC.Permission", "id": 1}'),
		'JSONRPC.Ping'                  => array('call' => '{"jsonrpc": "2.0", "method": "JSONRPC.Ping", "id": 1}'),
		
		'AudioPlayer.State'             => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.State", "id": 1}'),
		'AudioPlayer.PlayPause'         => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.PlayPause", "id": 1}'),
		'AudioPlayer.Stop'              => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.Stop", "id": 1}'),
		'AudioPlayer.SkipPrevious'      => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.SkipPrevious", "id": 1}'),
		'AudioPlayer.SkipNext'          => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.SkipNext", "id": 1}'),
		'AudioPlayer.BigSkipBackward'   => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.BigSkipBackward", "id": 1}'),
		'AudioPlayer.BigSkipForward'    => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.BigSkipForward", "id": 1}'),
		'AudioPlayer.SmallSkipBackward' => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.SmallSkipBackward", "id": 1}'),
		'AudioPlayer.SmallSkipForward'  => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.SmallSkipForward", "id": 1}'),
		'AudioPlayer.Rewind'            => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.Rewind", "id": 1}'),
		'AudioPlayer.Forward'           => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.Forward", "id": 1}'),
		'AudioPlayer.GetPercentage'     => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.GetPercentage", "id": 1}'),
		'AudioPlayer.GetTime'           => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlayer.GetTime", "id": 1}'),

		'AudioPlaylist.SkipPrevious'    => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlaylist.SkipPrevious", "id": 1}'),
		'AudioPlaylist.SkipNext'        => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlaylist.SkipNext", "id": 1}'),
		'AudioPlaylist.Shuffle'         => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlaylist.Shuffle", "id": 1}'),
		'AudioPlaylist.UnShuffle'       => array('call' => '{"jsonrpc": "2.0", "method": "AudioPlaylist.UnShuffle", "id": 1}'),

		'AudioLibrary.ScanForContent'   => array('call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.ScanForContent", "id" : 1 }'),

		'PicturePlayer.PlayPause'       => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.PlayPause", "id": 1}'),
		'PicturePlayer.Stop'            => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.Stop", "id": 1}'),
		'PicturePlayer.SkipPrevious'    => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.SkipPrevious", "id": 1}'),
		'PicturePlayer.SkipNext'        => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.SkipNext", "id": 1}'),
		'PicturePlayer.MoveLeft'        => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.MoveLeft", "id": 1}'),
		'PicturePlayer.MoveRight'       => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.MoveRight", "id": 1}'),
		'PicturePlayer.MoveDown'        => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.MoveDown", "id": 1}'),
		'PicturePlayer.MoveUp'          => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.MoveUp", "id": 1}'),
		'PicturePlayer.ZoomOut'         => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.ZoomOut", "id": 1}'),
		'PicturePlayer.ZoomIn'          => array('call' => '{"jsonrpc": "2.0", "method": "PicturePlayer.ZoomIn", "id": 1}'),
		
		'VideoPlayer.State'             => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.State", "id": 1}'),
		'VideoPlayer.PlayPause'         => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.PlayPause", "id": 1}'),
		'VideoPlayer.Stop'              => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.Stop", "id": 1}'),
		'VideoPlayer.SkipPrevious'      => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.SkipPrevious", "id": 1}'),
		'VideoPlayer.SkipNext'          => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.SkipNext", "id": 1}'),
		'VideoPlayer.BigSkipBackward'   => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.BigSkipBackward", "id": 1}'),
		'VideoPlayer.BigSkipForward'    => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.BigSkipForward", "id": 1}'),
		'VideoPlayer.SmallSkipBackward' => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.SmallSkipBackward", "id": 1}'),
		'VideoPlayer.SmallSkipForward'  => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.SmallSkipForward", "id": 1}'),
		'VideoPlayer.Rewind'            => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.Rewind", "id": 1}'),
		'VideoPlayer.Forward'           => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.Forward", "id": 1}'),
		'VideoPlayer.GetPercentage'     => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.GetPercentage", "id": 1}'),
		'VideoPlayer.GetTime'           => array('call' => '{"jsonrpc": "2.0", "method": "VideoPlayer.GetTime", "id": 1}'),
		'Player.PlayPause' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Player.PlayPause", "params": { "playerid": %d}, "id": 1}',
			'args' => array(
				'playerid' => ''
			)
		),
		'Player.GoPrevious' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Player.GoPrevious", "params": { "playerid": %d}, "id": 1}',
			'args' => array(
				'playerid' => ''
			)
		),
		'Player.GoNext'				=> array('call' => '{"jsonrpc": "2.0", "method": "Player.GoNext", "params": { "playerid": %d}, "id": 1}',
		'args' => array(
				'playerid' => ''
			)
		),
		'Player.Stop'				=> array('call' => '{"jsonrpc": "2.0", "method": "Player.Stop", "params": { "playerid": %d}, "id": 1}',
		'args' => array(
				'playerid' => ''
			)
		),
		'VideoLibrary.ScanForContent'   => array('call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.ScanForContent", "id" : 1 }'),

		'System.Shutdown'               => array('call' => '{"jsonrpc": "2.0", "method": "System.Shutdown", "id" : 1 }'),
		'System.Suspend'                => array('call' => '{"jsonrpc": "2.0", "method": "System.Suspend", "id" : 1 }'),
		'System.Hibernate'              => array('call' => '{"jsonrpc": "2.0", "method": "System.Hibernate", "id" : 1 }'),
		'System.Reboot'                 => array('call' => '{"jsonrpc": "2.0", "method": "System.Reboot", "id" : 1 }'),

		'XBMC.ToggleMute'               => array('call' => '{"jsonrpc": "2.0", "method": "XBMC.ToggleMute", "id" : 1 }'),
		'XBMC.Quit'                     => array('call' => '{"jsonrpc": "2.0", "method": "XBMC.Quit", "id" : 1 }'),

		// Methods requiring parameters
		'AudioLibrary.GetArtists' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetArtists", "params": { "sortmethod": "artist", "sortorder" : "ascending" , "fields": [ "artist", "year" ]}, "id": 1}',
			'sql' => array(
				'db' => 'music',
				'query' => 'select * from artist where (idArtist IN (select song.idArtist from song) or idArtist IN (select exartistsong.idArtist from exartistsong) or idArtist IN (select album.idArtist from album) or idArtist IN (select exartistalbum.idArtist from exartistalbum ))  and artist.strArtist != "" and artist.idArtist<>1',
				'resultwrapper' => 'artists'
			)
		),
		'AudioLibraryV3.GetArtists' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetArtists", "params": { "properties" : ["instrument", "style", "mood", "born", "formed", "description", "genre", "died", "disbanded", "yearsactive", "musicbrainzartistid", "fanart", "thumbnail" ]}, "id": 1}',
			'sql' => array(
				'db' => 'music',
				'query' => 'select * from artist where (idArtist IN (select song.idArtist from song) or idArtist IN (select exartistsong.idArtist from exartistsong) or idArtist IN (select album.idArtist from album) or idArtist IN (select exartistalbum.idArtist from exartistalbum ))  and artist.strArtist != "" and artist.idArtist<>1',
				'resultwrapper' => 'artists'
			)
		),
		'AudioLibrary.GetAlbums' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetAlbums", "params": { %s "sortmethod": "artist", "sortorder" : "ascending", "fields": [ "artist", "year" ] },"id": 1}',
			'args' => array(
				'artistid' => ''
			),
			'optional' => array(
				'artistid' => '"artistid": 1,'
			)
		),
		'AudioLibraryV3.GetAlbums' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetAlbums", "params": { "artistid" : %d, "properties" : [ "title", "description", "artist", "genre", "theme", "mood", "style", "type", "albumlabel", "rating", "year", "musicbrainzalbumid", "musicbrainzalbumartistid", "fanart", "thumbnail", "artistid" ] },"id": 1}',
			'args' => array(
				'artistid' => ''
			),
		),
		'AudioLibraryV3NoArtist.GetAlbums' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetAlbums", "params": { "properties" : [ "title", "description", "artist", "genre", "theme", "mood", "style", "type", "albumlabel", "rating", "year", "musicbrainzalbumid", "musicbrainzalbumartistid", "fanart", "thumbnail", "artistid" ] },"id": 1}',
			'args' => array(
				'artistid' => ''
			),
		),
		'AudioLibrary.GetSongs' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetSongs", "params": { %s %s "fields": [ "artist", "year" ] },"id": 1}',
			'args' => array(
				'artistid' => '',
				'albumid' => ''
			)
		),
		'AudioLibraryV3.GetSongs' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetSongs", "params": { "albumid" : %d, "properties" : ["title", "artist", "albumartist", "genre", "year", "rating", "album", "track", "duration", "comment", "lyrics", "musicbrainztrackid", "musicbrainzartistid", "musicbrainzalbumid", "musicbrainzalbumartistid", "playcount", "fanart", "thumbnail", "file", "artistid", "albumid"] },"id": 1}',
			'args' => array(
				'albumid' => ''
			)
		),
		'AudioLibraryV3NoAlbumID.GetSongs' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioLibrary.GetSongs", "params": { "properties" : ["title", "artist", "albumartist", "genre", "year", "rating", "album", "track", "duration", "comment", "lyrics", "musicbrainztrackid", "musicbrainzartistid", "musicbrainzalbumid", "musicbrainzalbumartistid", "playcount", "fanart", "thumbnail", "file", "artistid", "albumid"] },"id": 1}',
		),
		'AudioPlaylist.Add' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioPlaylist.Add", "params": { "songid" : %d }, "id": 1}',
			'args' => '0'
		),
		'AudioPlaylist.GetItems' => array(
			'call' => '{"jsonrpc": "2.0", "method": "AudioPlaylist.GetItems", "params": { "fields": ["title", "album", "artist", "duration"] }, "id": 1}'
		),
		'Files.GetSources' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Files.GetSources", "params" : { "media" : "%s" }, "id": 1}',
			'args' => 'music'
		),
		'Files.Download' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Files.Download", "params": %s, "id": 1}',
			'args' => '""'
		),
		'Files.GetDirectory' => array(
			'call' => '{"jsonrpc" : "2.0", "method" : "Files.GetDirectory", "params":{ "directory": "%s" }, "id": 1}',
			'args' => ''
		),
		'Player.GetActivePlayers' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Player.GetActivePlayers", "id": 1}'
		),
		'Player.GetProperties' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Player.GetProperties", "params": { "playerid": %d, "properties" : ["type", "partymode", "speed", "time", "percentage", "totaltime", "playlistid", "position", "repeat", "shuffled", "canseek", "canchangespeed", "canmove", "canzoom", "canrotate", "canshuffle", "canrepeat", "currentaudiostream", "audiostreams", "subtitleenabled", "currentsubtitle", "subtitles"]}, "id": 1}',
			'args' => array(
				'playerid' => ''
			)
		),
		'Player.GetItem' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Player.GetItem", "params": { "playerid": %d, "properties" : [ "title", "artist", "albumartist", "genre", "year", "rating", "album", "track", "duration", "comment", "lyrics", "musicbrainztrackid", "musicbrainzartistid", "musicbrainzalbumid", "musicbrainzalbumartistid", "playcount", "fanart", "director", "trailer", "tagline", "plot", "plotoutline", "originaltitle", "lastplayed", "writer", "studio", "mpaa", "cast", "country", "imdbnumber", "premiered", "productioncode", "runtime", "set", "showlink", "streamdetails", "top250", "votes", "firstaired", "season", "episode", "showtitle", "thumbnail", "file", "resume", "artistid", "albumid", "tvshowid", "setid" ]}, "id": 1}',
			'args' => array(
				'playerid' => ''
			)
		),
		'Playlist.GetItems' => array(
			'call' => '{"jsonrpc": "2.0", "method": "Playlist.GetItems", "params": { "playlistid": %d}, "id": 1}',
			'args' => array(
				'playlistid' => ''
			)
		),
		'VideoLibrary.GetRecentlyAddedMovies' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetRecentlyAddedMovies", "params" : { "start" : 0 , "end" : %d , "fields": [ "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" ] }, "id" : 1 }',
			'sql' => array(
				'db' => 'video',
				'query' => 'select * from movieview order by idMovie desc limit %d',
				'resultwrapper' => 'movies'
			),
			'args' => 50
		),
		'VideoLibraryV3.GetRecentlyAddedMovies' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetRecentlyAddedMovies", "params" : { "properties" : ["title", "genre", "year", "rating", "director", "trailer", "tagline", "plot", "plotoutline", "originaltitle", "lastplayed", "playcount", "writer", "studio", "mpaa", "cast", "country", "imdbnumber", "premiered", "productioncode", "runtime", "set", "showlink", "streamdetails", "top250", "votes", "fanart", "thumbnail", "file", "sorttitle", "resume", "setid"] }, "id" : 1 }',
			'sql' => array(
				'db' => 'video',
				'query' => 'select * from movieview order by idMovie desc limit %d',
				'resultwrapper' => 'movies'
			),
			'args' => 50
		),
		'VideoLibrary.GetMovies' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetMovies", "params": { "sortorder" : "ascending", "fields" : [ "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" ] }, "id": 1}'
		),
		'VideoLibraryV3.GetMovies' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetMovies", "params": { "properties" : ["title", "genre", "year", "rating", "director", "trailer", "tagline", "plot", "plotoutline", "originaltitle", "lastplayed", "playcount", "writer", "studio", "mpaa", "cast", "country", "imdbnumber", "premiered", "productioncode", "runtime", "set", "showlink", "streamdetails", "top250", "votes", "fanart", "thumbnail", "file", "sorttitle", "resume", "setid"] }, "id": 1}'
		),
		'VideoLibrary.GetRecentlyAddedEpisodes' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetRecentlyAddedEpisodes", "params" : { "start" : 0 , "end" : %d , "fields": [ "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" ] }, "id" : 1 }',
			'sql' => array(
				'db' => 'video',
				'query' => 'select c13 as episode, idEpisode as episodeid, c05 as firstaired, c00 as label, mpaa, c01 as plot, premiered, strTitle as showtitle, strStudio as studio, c00 as title, * from episodeview order by idEpisode desc limit %d',
				'resultwrapper' => 'episodes'
			),
			'args' => 50
		),
		'VideoLibraryV3.GetRecentlyAddedEpisodes' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetRecentlyAddedEpisodes", "params" : { "properties" : ["title", "plot", "votes", "rating", "writer", "firstaired", "playcount", "runtime", "director", "productioncode", "season", "episode", "originaltitle", "showtitle", "cast", "streamdetails", "lastplayed", "fanart", "thumbnail", "file", "resume", "tvshowid" ] }, "id" : 1 }',
			'sql' => array(
				'db' => 'video',
				'query' => 'select c13 as episode, idEpisode as episodeid, c05 as firstaired, c00 as label, mpaa, c01 as plot, premiered, strTitle as showtitle, strStudio as studio, c00 as title, * from episodeview order by idEpisode desc limit %d',
				'resultwrapper' => 'episodes'
			),
			'args' => 50
		),
		'VideoLibrary.GetTVShows' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetTVShows", "id" : 1 }'
		),
		'VideoLibrary.GetEpisodes' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetEpisodes", "params" : { "tvshowid" : %d, "season" : %d, "fields": [ "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" ] }, "id" : 1 }',
			'args' => array(
				'tvshowid' => 1,
				'season' => 1
			)
		),
		'VideoLibraryV3.GetEpisodes' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetEpisodes", "params" : { "tvshowid" : %d, "season" : %d, "properties" : [ "title", "plot", "votes", "rating", "writer", "firstaired", "playcount", "runtime", "director", "productioncode", "season", "episode", "originaltitle", "showtitle", "cast", "streamdetails", "lastplayed", "fanart", "thumbnail", "file", "resume", "tvshowid" ] }, "id" : 1 }',
			'args' => array(
				'tvshowid' => 1,
				'season' => 1
			)
		),
		'VideoLibrary.GetEpisodeDetails' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetEpisodeDetails", "params" : { "tvshowid" : %d, "season" : %d, "fields": [ "title", "plot", "votes", "rating", "writingcredits", "firstaired", "playcount", "runtime", "director", "productioncode", "season", "episode", "originaltitle", "showtitle", "cast", "streamDetails", "lastplayed", "fanart", "thumbnail", "file" ] }, "id" : 1 }',
			'args' => array(
				'tvshowid' => 1,
				'season' => 1
			)
		),
		'VideoLibrary.GetEpisodeDetailsV3' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetEpisodeDetails", "params": { "episodeid": %d, "properties" : ["title", "plot", "votes", "rating", "writer", "firstaired", "playcount", "runtime", "director", "productioncode", "season", "episode", "originaltitle", "showtitle", "cast", "streamdetails", "lastplayed", "fanart", "thumbnail", "file", "resume", "tvshowid" ]}, "id": 1}',
			'args' => array(
				'episodeid' => 1
			)
		),
		'VideoLibrary.GetMovieDetailsV3' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetMovieDetails", "params": { "movieid": %d, "properties" : ["title", "genre", "year", "rating", "director", "trailer", "tagline", "plot", "plotoutline", "originaltitle", "lastplayed", "playcount", "writer", "studio", "mpaa", "cast", "country", "imdbnumber", "premiered", "productioncode", "runtime", "set", "showlink", "streamdetails", "top250", "votes", "fanart", "thumbnail", "file", "sorttitle", "resume", "setid" ]}, "id": 1}',
			'args' => array(
				'movieid' => 1
			)
		),
		'VideoLibrary.GetSeasons' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetSeasons", "params" : { "tvshowid" : %d, "fields": [ "genre", "title", "showtitle", "duration", "season", "episode", "year", "playcount", "rating", "studio", "mpaa" ] }, "id" : 1 }',
			'sql' => array(
				'db' => 'video',
				'query' => 'select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow = %d group by episode.c12 LIMIT 0, 30',
				'resultwrapper' => 'seasons'
			),
			'args' => array(
				'tvshowid' => 1
			)
		),
		'VideoLibraryV3.GetSeasons' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoLibrary.GetSeasons", "params" : { "tvshowid" : %d, "properties" : [ "season", "showtitle", "playcount", "episode", "fanart", "thumbnail", "tvshowid" ] }, "id" : 1 }',
			'sql' => array(
				'db' => 'video',
				'query' => 'select episode.c12,path.strPath,tvshow.c00,tvshow.c08,tvshow.c14,tvshow.c13,count(1),count(files.playCount) from episode join tvshowlinkepisode on tvshowlinkepisode.idEpisode=episode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow join files on files.idFile=episode.idFile join tvshowlinkpath on tvshowlinkpath.idShow = tvshow.idShow join path on path.idPath = tvshowlinkpath.idPath where tvshow.idShow = %d group by episode.c12 LIMIT 0, 30',
				'resultwrapper' => 'seasons'
			),
			'args' => array(
				'tvshowid' => 1
			)
		),
		'VideoPlaylist.GetItems' => array(
			'call' => '{"jsonrpc": "2.0", "method": "VideoPlaylist.GetItems", "params": { "fields": ["tagline", "director", "title", "year", "season", "episode", "plot", "duration", "showtitle"] }, "id": 1}'
		),
		'System.GetInfoLabels' => array(
			'call' => '{"jsonrpc": "2.0", "method": "System.GetInfoLabels", "params": ["%s"], "id": 1}',
			'args' => 'System.ProfileName'
		),
		'XBMC.Play' => array(
			'call' => '{"jsonrpc": "2.0", "method": "XBMC.Play", "params": { %s }, "id": 1}',
			'optional' => array(
				'songid' => '"songid": 1',
				'file' => '"file": "path_to_file"'
			)
		)
	);
	
function msprintf($format, $args) {
	if(is_array($args)) {
		return vsprintf($format, $args);
	} else {
		return sprintf($format, $args);
	}
}

function jsonstring($method, $args = array()) {
	global $xbmcJsonMethods;
	
	if(!empty($xbmcJsonMethods[$method])) {
		if(!empty($args)) {
			return msprintf($xbmcJsonMethods[$method]['call'], $args);
		} else {
			if(!empty($xbmcJsonMethods[$method]['args'])) {
				return msprintf($xbmcJsonMethods[$method]['call'], $xbmcJsonMethods[$method]['args']);
			} else {
				return $xbmcJsonMethods[$method]['call'];
			}
		}
	} else {
		return false;
	}
}
function jsonmethodcall($method, $args = array(), $service_uri = "") {
	$request = jsonstring($method, $args);
	return jsoncall($request, $service_uri);
}
function jsoncall($request, $service_uri = "") {
	global $xbmcjsonservice;
	global $DEBUG;
	global $JSON_ERROR;
	global $COMM_ERROR;
	global $FORCE_UTF8;
	
	if($service_uri == "") {
		$service_uri = $xbmcjsonservice;
	}

	//json rpc call procedure
	$ch = curl_init();
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
	curl_setopt($ch, CURLOPT_POST, 1);
	curl_setopt($ch, CURLOPT_URL, $service_uri);

	curl_setopt($ch, CURLOPT_POSTFIELDS, $request);
	$response = curl_exec($ch);
	curl_close($ch);

	if(!empty($FORCE_UTF8) && $FORCE_UTF8) {
		$response = jsonFixEncoding($response);
	}
	
	$arrResult = json_decode($response, true);
	if((!empty($arrResult['error'])) && (!empty($DEBUG) && $DEBUG)) {
		echo $JSON_ERROR;
		echo "<p><strong>Last JSON Error: ".json_last_error()."</strong></p>\n";
		echo "<p><strong>Request:</strong><pre>$request</pre></p>\n";
		echo "<p><strong>Response:</strong><pre>$response</pre></p>\n";
	}
	if((empty($arrResult)) && (!empty($DEBUG) && $DEBUG)) {
		echo $COMM_ERROR;
		echo "<p><strong>".jsonerrorstring(json_last_error())."</strong></p>\n";
		echo "<p><strong>Request:</strong><pre>$request</pre></p>\n";
		echo "<p><strong>Response:</strong><pre>$response</pre></p>\n";
	}
	return $arrResult;
}
function jsonerrorstring($err) {
	switch($err) {
		case JSON_ERROR_DEPTH:
			$error =  ' - Maximum stack depth exceeded';
			break;
		case JSON_ERROR_CTRL_CHAR:
			$error = ' - Unexpected control character found';
			break;
		case JSON_ERROR_SYNTAX:
			$error = ' - Syntax error, malformed JSON';
			break;
		case JSON_ERROR_STATE_MISMATCH:
			$error = ' - Syntax error, Invalid or malformed JSON';
			break;
		//case JSON_ERROR_UTF8:
		//	$error = ' - Malformed UTF-8 characters, possibly incorrectly encoded';
		//	break;
		case JSON_ERROR_NONE:
			$error = '';                    
		default:
			$error = ' Error #'.$err;                    
	}
	if (!empty($error)) {
	//	throw new Exception('JSON Error: '.$error);        
		return "JSON Error: ".$error;
    }
}

function jsonFixEncoding($s){ 
    if(empty($s)) {
		return $s; 
	} else {
		$s = preg_match_all("#[\x09\x0A\x0D\x20-\x7E]|[\xC2-\xDF][\x80-\xBF]|\xE0[\xA0-\xBF][\x80-\xBF]|[\xE1-\xEC\xEE\xEF][\x80-\xBF]{2}|\xED[\x80-\x9F][\x80-\xBF]#x", $s, $m );
		return implode("",$m[0]); 
	}
}

function sqlquerystring($method, $args = array()) {
	global $xbmcJsonMethods;
	
	if(!empty($xbmcJsonMethods[$method]['sql'])) {
		if(!empty($args)) {
			return msprintf($xbmcJsonMethods[$method]['sql']['query'], $args);
		} else {
			if(!empty($xbmcJsonMethods[$method]['args'])) {
				return msprintf($xbmcJsonMethods[$method]['sql']['query'], $xbmcJsonMethods[$method]['args']);
			} else {
				return $xbmcJsonMethods[$method]['sql']['query'];
			}
		}
	} else {
		return false;
	}
}
function sqlitetoarray($sql, $dbname, $resultwrapper) {
	global $xbmcdbconn;

	if(!empty($xbmcdbconn[$dbname]['dns'])) {
		if ($dbhandle = new PDO($xbmcdbconn[$dbname]['dns'], $xbmcdbconn[$dbname]['username'], $xbmcdbconn[$dbname]['password'], $xbmcdbconn[$dbname]['options'])) { 
			$dbquery = @$dbhandle->query($sql);
			if ($dbquery === false) {
				$dbhandle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
				$error = $dbhandle->errorInfo();
				if($error[0] != "") {
					$errCode = (-1 * $error[1]) - 41000;
					$errMsg = 'Datbase Query Error:'.$error[2];
				} else {
					$errCode = -41000;
					$errMsg = 'Datbase Query Error';
				}
				$return = array('error' => array('code' => $errCode, 'message' => $errMsg), 'id' => 0, 'jsonrpc' => '2.0');
			} else {
				$results = $dbquery->fetchAll();
				$return = array('id' => 1, 'jsonrpc' => '2.0', 'result' => array('start' => 0, 'end' => sizeof($results), $resultwrapper => $results ), 'total' => sizeof($results));
			}
		} else {
			$dbhandle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$error = $dbhandle->errorInfo();
			if($error[0] != "") {
				$errCode = (-1 * $error[1]) - 40000;
				$errMsg = 'Datbase Connection Error:'.$error[2].' ('.$xbmcdbpath.$dbname.')';
			} else {
				$errCode = -40000;
				$errMsg = 'Datbase Connection Error: ('.$xbmcdbpath.$dbname.')';
			}
			$return = array('error' => array('code' => $errCode, 'message' => $errMsg), 'id' => 0, 'jsonrpc' => '2.0');
		}
	} else {
		$errCode = -50000;
		$errMsg = 'Configuration Error: Check your config.php file.';
		$return = array('error' => array('code' => $errCode, 'message' => $errMsg), 'id' => 0, 'jsonrpc' => '2.0');
	}
	return $return;
}
?>
<?php
if(!empty($_REQUEST['tester']) && $_REQUEST['tester']='y') {
	if(!empty($_POST['request'])) {
		$request = str_replace('\"', '"', $_POST['request']);
	} else {
		$request = "";
	}
	if(!empty($_POST['query'])) {
		$query = str_replace('\"', '"', $_POST['query']);
	} else {
		$query = "";
	}
	if(!empty($_POST['dbname'])) {
		$dbname = $_POST['dbname'];
	} else {
		$dbname = "";
	}
	if(!empty($_POST['resultwrapper'])) {
		$resultwrapper = $_POST['resultwrapper'];
	} else {
		$resultwrapper = "";
	}
	
?>
<html>
	<head>
		<title>XBMC JSON Tester</title>
		<script type="text/javascript" language="javascript">
		<!--
			function setRequest(lstCalls) {
				var txtRequest = document.getElementById("txtRequest");
				txtRequest.value = lstCalls.value;
			}
			function setQuery(lstCalls) {
				var txtQuery = document.getElementById("txtQuery");
				txtQuery.value = lstCalls.value;
				var txtDB = document.getElementById("txtDB");
				txtDB.value = lstCalls.options[lstCalls.selectedIndex].label;
				var txtRW = document.getElementById("txtRW");
				txtRW.value = lstCalls.options[lstCalls.selectedIndex].lang;
			}
		-->
		</script>
	</head>
	<body>
		<div id="form">
			<form action="" method="post">
				<input type="hidden" name="tester" value="yes"/>
				<select onchange="setRequest(this);">
					<option value="">[Predefined Queries]</option>
					<!--
					// Video Details: 
					// "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" 

					// Music Details:
					// "title", "album", "artist", "albumartist", "genre", "tracknumber", "discnumber", "trackanddiscnumber", "duration", "year", "musicbrainztrackid", "musicbrainzartistid", "musicbrainzalbumid", "musicbrainzalbumartistid", "musicbrainztrmidid", "comment", "lyrics", "rating"
					-->
<?php
					foreach($xbmcJsonMethods as $method => $arrmethod) {
						echo "<option value='".jsonstring($method)."'>".$method."</option>\n";
						if(!empty($arrmethod['optional'])) {
							foreach($arrmethod['optional'] as $key => $option) {
								echo "<option value='".jsonstring($method, $option)."'>".$method." (".$key.")</option>\n";
							}
						}
					}
?>
				</select>
				<input id="txtRequest" name="request" type="text" size="100" value='<?php echo $request; ?>' />
				<input type="submit" value="Submit" /><br/><br/>
				<select onchange="setQuery(this);">
					<option value="">[Predefined Queries]</option>
					<!--
					// Video Details: 
					// "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" 

					// Music Details:
					// "title", "album", "artist", "albumartist", "genre", "tracknumber", "discnumber", "trackanddiscnumber", "duration", "year", "musicbrainztrackid", "musicbrainzartistid", "musicbrainzalbumid", "musicbrainzalbumartistid", "musicbrainztrmidid", "comment", "lyrics", "rating"
					-->
<?php
					foreach($xbmcJsonMethods as $method => $arrmethod) {
						if(!empty($arrmethod['sql'])) {
							echo "<option value='".sqlquerystring($method)."' lang='".$arrmethod['sql']['resultwrapper']."' label='".$arrmethod['sql']['db']."'>".$method."</option>\n";
						}
					}
?>
				</select>
				<input id="txtDB" name="dbname" type="text" size="15" value='<?php echo $dbname; ?>' />
				<input id="txtRW" name="resultwrapper" type="text" size="10" value='<?php echo $resultwrapper; ?>' />
				<input id="txtQuery" name="query" type="text" size="100" value='<?php echo $query; ?>' />
			</form>
		</div>
		<div id="query">
<?php
			if(!empty($_POST['request'])) {
				$result = jsoncall($request);

				echo "<br/>Call: <pre>";
				echo print_r($request,1);   // debugging
				echo "</pre><br/>";
				echo "<br/>Result: <pre>";
				echo print_r($result,1); // debugging
				echo "</pre><br/>";
			}
			if(!empty($_POST['query']) && !empty($_POST['dbname'])) {
				//$method = 'VideoLibrary.GetRecentlyAddedMovies';
				//$result = sqlitetoarray(sqlquerystring($method , 25), $xbmcJsonMethods[$method]['sql']['db']);
				$result = sqlitetoarray($query, $dbname, $resultwrapper);

				echo "<br/>Call: <pre>";
				echo print_r($query,1);   // debugging
				echo "</pre><br/>";
				echo "<br/>Result: <pre>";
				echo print_r($result,1); // debugging
				echo "</pre><br/>";
			}
?>
		</div>
	</body>
</html>
<?php
}
?>