pastebin - XBMC ATV2 - post number 2107459

Advertising

XBMC ATV2
Sunday, January 29th, 2012 at 9:02:40am MST

120129 11:50:24    94 Connect    xbmc@Apple-TV.local on 
                   94 Query     SET NAMES utf8
                   94 Query     show databases like 'xbmc_video58'
                   94 Query     show tables
                   94 Init DB   xbmc_video58
                   94 Query     show databases like 'xbmc_video58'
                   94 Query     show tables
                   94 Query     SELECT idVersion FROM version
                   94 Query     select count(1) from movie
                   94 Quit      
                   95 Connect   xbmc@Apple-TV.local on 
                   95 Query     SET NAMES utf8
                   95 Query     show databases like 'xbmc_video58'
                   95 Query     show tables
                   95 Init DB   xbmc_video58
                   95 Query     show databases like 'xbmc_video58'
                   95 Query     show tables
                   95 Query     SELECT idVersion FROM version
                   95 Query     select count(1) from tvshow
                   95 Quit      
                   96 Connect   xbmc@Apple-TV.local on 
                   96 Query     SET NAMES utf8
                   96 Query     show databases like 'xbmc_music18'
                   96 Query     show tables
                   96 Init DB   xbmc_music18
                   96 Query     show databases like 'xbmc_music18'
                   96 Query     show tables
                   96 Query     SELECT idVersion FROM version
                   96 Query     select count(idSong) as NumSongs from songview
                   96 Quit      
120129 11:50:26    97 Connect    xbmc@Apple-TV.local on 
                   97 Query     SET NAMES utf8
                   97 Query     show databases like 'xbmc_video58'
                   97 Query     show tables
                   97 Init DB   xbmc_video58
                   97 Query     show databases like 'xbmc_video58'
                   97 Query     show tables
                   97 Query     SELECT idVersion FROM version
                   97 Query     select count(1) from musicvideo
                   97 Quit      
                   98 Connect   xbmc@Apple-TV.local on 
                   98 Query     SET NAMES utf8
                   98 Query     show databases like 'xbmc_music18'
                   98 Query     show tables
                   98 Init DB   xbmc_music18
                   98 Query     show databases like 'xbmc_music18'
                   98 Query     show tables
                   98 Query     SELECT idVersion FROM version
                   98 Query     SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
                   98 Query     select * from albumview order by idAlbum desc limit 10
                   98 Quit      
                   99 Connect   xbmc@Apple-TV.local on 
                   99 Query     SET NAMES utf8
                   99 Query     show databases like 'xbmc_video58'
                   99 Query     show tables
                   99 Init DB   xbmc_video58
                   99 Query     show databases like 'xbmc_video58'
                   99 Query     show tables
                   99 Query     SELECT idVersion FROM version
                   99 Query     select * from movieview  order by idMovie desc limit 10
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 85
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 84
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 83
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 82
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 81
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 80
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 79
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 78
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 77
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 76
                  100 Connect   xbmc@Apple-TV.local on 
                  100 Query     SET NAMES utf8
                  100 Query     show databases like 'xbmc_video58'
                  100 Query     show tables
                  100 Init DB   xbmc_video58
                  100 Query     show databases like 'xbmc_video58'
                  100 Query     show tables
                  100 Query     SELECT idVersion FROM version
                  100 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=85 and type=1 order by timeInSeconds
                  100 Quit      
                  101 Connect   xbmc@Apple-TV.local on 
120129 11:50:27   101 Query      SET NAMES utf8
                  101 Query     show databases like 'xbmc_video58'
                  101 Query     show tables
                  101 Init DB   xbmc_video58
                  101 Query     show databases like 'xbmc_video58'
                  101 Query     show tables
                  101 Query     SELECT idVersion FROM version
                  101 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=84 and type=1 order by timeInSeconds
                  101 Quit      
                  102 Connect   xbmc@Apple-TV.local on 
                  102 Query     SET NAMES utf8
                  102 Query     show databases like 'xbmc_video58'
                  102 Query     show tables
                  102 Init DB   xbmc_video58
                  102 Query     show databases like 'xbmc_video58'
                  102 Query     show tables
                  102 Query     SELECT idVersion FROM version
                  102 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=83 and type=1 order by timeInSeconds
                  102 Quit      
                  103 Connect   xbmc@Apple-TV.local on 
                  103 Query     SET NAMES utf8
                  103 Query     show databases like 'xbmc_video58'
                  103 Query     show tables
                  103 Init DB   xbmc_video58
                  103 Query     show databases like 'xbmc_video58'
                  103 Query     show tables
                  103 Query     SELECT idVersion FROM version
                  103 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=82 and type=1 order by timeInSeconds
                  103 Quit      
                  104 Connect   xbmc@Apple-TV.local on 
                  104 Query     SET NAMES utf8
                  104 Query     show databases like 'xbmc_video58'
                  104 Query     show tables
                  104 Init DB   xbmc_video58
                  104 Query     show databases like 'xbmc_video58'
                  104 Query     show tables
                  104 Query     SELECT idVersion FROM version
                  104 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=81 and type=1 order by timeInSeconds
                  104 Quit      
                  105 Connect   xbmc@Apple-TV.local on 
                  105 Query     SET NAMES utf8
                  105 Query     show databases like 'xbmc_video58'
                  105 Query     show tables
                  105 Init DB   xbmc_video58
                  105 Query     show databases like 'xbmc_video58'
                  105 Query     show tables
                  105 Query     SELECT idVersion FROM version
                  105 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=80 and type=1 order by timeInSeconds
                  105 Quit      
                  106 Connect   xbmc@Apple-TV.local on 
                  106 Query     SET NAMES utf8
                  106 Query     show databases like 'xbmc_video58'
                  106 Query     show tables
                  106 Init DB   xbmc_video58
                  106 Query     show databases like 'xbmc_video58'
                  106 Query     show tables
                  106 Query     SELECT idVersion FROM version
                  106 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=79 and type=1 order by timeInSeconds
                  106 Quit      
                  107 Connect   xbmc@Apple-TV.local on 
                  107 Query     SET NAMES utf8
                  107 Query     show databases like 'xbmc_video58'
                  107 Query     show tables
                  107 Init DB   xbmc_video58
                  107 Query     show databases like 'xbmc_video58'
                  107 Query     show tables
                  107 Query     SELECT idVersion FROM version
                  107 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=78 and type=1 order by timeInSeconds
                  107 Quit      
                  108 Connect   xbmc@Apple-TV.local on 
                  108 Query     SET NAMES utf8
                  108 Query     show databases like 'xbmc_video58'
                  108 Query     show tables
                  108 Init DB   xbmc_video58
                  108 Query     show databases like 'xbmc_video58'
                  108 Query     show tables
                  108 Query     SELECT idVersion FROM version
                  108 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=77 and type=1 order by timeInSeconds
                  108 Quit      
                  109 Connect   xbmc@Apple-TV.local on 
                  109 Query     SET NAMES utf8
                  109 Query     show databases like 'xbmc_video58'
                  109 Query     show tables
                  109 Init DB   xbmc_video58
                  109 Query     show databases like 'xbmc_video58'
                  109 Query     show tables
                  109 Query     SELECT idVersion FROM version
                  109 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=76 and type=1 order by timeInSeconds
                  109 Quit      
                   99 Query     select * from episodeview order by idEpisode desc limit 10
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 15
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 14
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 13
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 12
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 11
                   99 Query     SELECT * FROM streamdetails WHERE idFile = 10
120129 11:50:28   110 Connect    xbmc@Apple-TV.local on 
                  110 Query     SET NAMES utf8
                  110 Query     show databases like 'xbmc_video58'
                  110 Query     show tables
                  110 Init DB   xbmc_video58
                  110 Query     show databases like 'xbmc_video58'
                  110 Query     show tables
                  110 Query     SELECT idVersion FROM version
                  110 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=15 and type=1 order by timeInSeconds
                  110 Quit      
                  111 Connect   xbmc@Apple-TV.local on 
                  111 Query     SET NAMES utf8
                  111 Query     show databases like 'xbmc_video58'
                  111 Query     show tables
                  111 Init DB   xbmc_video58
                  111 Query     show databases like 'xbmc_video58'
                  111 Query     show tables
                  111 Query     SELECT idVersion FROM version
                  111 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=14 and type=1 order by timeInSeconds
                  111 Quit      
                  112 Connect   xbmc@Apple-TV.local on 
                  112 Query     SET NAMES utf8
                  112 Query     show databases like 'xbmc_video58'
                  112 Query     show tables
                  112 Init DB   xbmc_video58
                  112 Query     show databases like 'xbmc_video58'
                  112 Query     show tables
                  112 Query     SELECT idVersion FROM version
                  112 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=13 and type=1 order by timeInSeconds
                  112 Quit      
                  113 Connect   xbmc@Apple-TV.local on 
                  113 Query     SET NAMES utf8
                  113 Query     show databases like 'xbmc_video58'
                  113 Query     show tables
                  113 Init DB   xbmc_video58
                  113 Query     show databases like 'xbmc_video58'
                  113 Query     show tables
                  113 Query     SELECT idVersion FROM version
                  113 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=12 and type=1 order by timeInSeconds
                  113 Quit      
                  114 Connect   xbmc@Apple-TV.local on 
                  114 Query     SET NAMES utf8
                  114 Query     show databases like 'xbmc_video58'
                  114 Query     show tables
                  114 Init DB   xbmc_video58
                  114 Query     show databases like 'xbmc_video58'
                  114 Query     show tables
                  114 Query     SELECT idVersion FROM version
                  114 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=11 and type=1 order by timeInSeconds
                  114 Quit      
                  115 Connect   xbmc@Apple-TV.local on 
                  115 Query     SET NAMES utf8
                  115 Query     show databases like 'xbmc_video58'
                  115 Query     show tables
                  115 Init DB   xbmc_video58
                  115 Query     show databases like 'xbmc_video58'
                  115 Query     show tables
                  115 Query     SELECT idVersion FROM version
                  115 Query     select timeInSeconds, totalTimeInSeconds from bookmark where idFile=10 and type=1 order by timeInSeconds
                  115 Quit      
120129 11:50:29    99 Query      select * from musicvideoview order by idMVideo desc limit 10
                   99 Quit      
                  116 Connect   xbmc@Apple-TV.local on 
                  116 Query     SET NAMES utf8
                  116 Query     show databases like 'xbmc_music18'
                  116 Query     show tables
                  116 Init DB   xbmc_music18
                  116 Query     show databases like 'xbmc_music18'
                  116 Query     show tables
                  116 Query     SELECT idVersion FROM version
                  116 Query     SELECT count(1) FROM songview LIMIT 1
                  116 Query     SELECT count(distinct strAlbum) FROM songview LIMIT 1
                  116 Query     SELECT count(distinct strArtist) FROM songview LIMIT 1
                  116 Quit      
                  117 Connect   xbmc@Apple-TV.local on 
                  117 Query     SET NAMES utf8
                  117 Query     show databases like 'xbmc_video58'
                  117 Query     show tables
                  117 Init DB   xbmc_video58
                  117 Query     show databases like 'xbmc_video58'
                  117 Query     show tables
                  117 Query     SELECT idVersion FROM version
                  117 Query     SELECT count(1) FROM tvshowview LIMIT 1
                  117 Query     SELECT count(1) FROM movieview LIMIT 1
                  117 Query     SELECT count(playCount) FROM movieview LIMIT 1
                  117 Query     SELECT count(1) FROM musicvideoview LIMIT 1
                  117 Query     SELECT count(playCount) FROM musicvideoview LIMIT 1
                  117 Query     SELECT sum(watchedcount) FROM tvshowview LIMIT 1
                  117 Query     SELECT sum(totalcount) FROM tvshowview LIMIT 1
                  117 Query     SELECT sum(watchedcount = totalcount) FROM tvshowview LIMIT 1
                  117 Quit      

advertising

Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below

120129 11:50:24	   94 Connect	xbmc@Apple-TV.local on 
		   94 Query	SET NAMES utf8
		   94 Query	show databases like 'xbmc_video58'
		   94 Query	show tables
		   94 Init DB	xbmc_video58
		   94 Query	show databases like 'xbmc_video58'
		   94 Query	show tables
		   94 Query	SELECT idVersion FROM version
		   94 Query	select count(1) from movie
		   94 Quit	
		   95 Connect	xbmc@Apple-TV.local on 
		   95 Query	SET NAMES utf8
		   95 Query	show databases like 'xbmc_video58'
		   95 Query	show tables
		   95 Init DB	xbmc_video58
		   95 Query	show databases like 'xbmc_video58'
		   95 Query	show tables
		   95 Query	SELECT idVersion FROM version
		   95 Query	select count(1) from tvshow
		   95 Quit	
		   96 Connect	xbmc@Apple-TV.local on 
		   96 Query	SET NAMES utf8
		   96 Query	show databases like 'xbmc_music18'
		   96 Query	show tables
		   96 Init DB	xbmc_music18
		   96 Query	show databases like 'xbmc_music18'
		   96 Query	show tables
		   96 Query	SELECT idVersion FROM version
		   96 Query	select count(idSong) as NumSongs from songview
		   96 Quit	
120129 11:50:26	   97 Connect	xbmc@Apple-TV.local on 
		   97 Query	SET NAMES utf8
		   97 Query	show databases like 'xbmc_video58'
		   97 Query	show tables
		   97 Init DB	xbmc_video58
		   97 Query	show databases like 'xbmc_video58'
		   97 Query	show tables
		   97 Query	SELECT idVersion FROM version
		   97 Query	select count(1) from musicvideo
		   97 Quit	
		   98 Connect	xbmc@Apple-TV.local on 
		   98 Query	SET NAMES utf8
		   98 Query	show databases like 'xbmc_music18'
		   98 Query	show tables
		   98 Init DB	xbmc_music18
		   98 Query	show databases like 'xbmc_music18'
		   98 Query	show tables
		   98 Query	SELECT idVersion FROM version
		   98 Query	SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
		   98 Query	select * from albumview order by idAlbum desc limit 10
		   98 Quit	
		   99 Connect	xbmc@Apple-TV.local on 
		   99 Query	SET NAMES utf8
		   99 Query	show databases like 'xbmc_video58'
		   99 Query	show tables
		   99 Init DB	xbmc_video58
		   99 Query	show databases like 'xbmc_video58'
		   99 Query	show tables
		   99 Query	SELECT idVersion FROM version
		   99 Query	select * from movieview  order by idMovie desc limit 10
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 85
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 84
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 83
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 82
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 81
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 80
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 79
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 78
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 77
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 76
		  100 Connect	xbmc@Apple-TV.local on 
		  100 Query	SET NAMES utf8
		  100 Query	show databases like 'xbmc_video58'
		  100 Query	show tables
		  100 Init DB	xbmc_video58
		  100 Query	show databases like 'xbmc_video58'
		  100 Query	show tables
		  100 Query	SELECT idVersion FROM version
		  100 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=85 and type=1 order by timeInSeconds
		  100 Quit	
		  101 Connect	xbmc@Apple-TV.local on 
120129 11:50:27	  101 Query	SET NAMES utf8
		  101 Query	show databases like 'xbmc_video58'
		  101 Query	show tables
		  101 Init DB	xbmc_video58
		  101 Query	show databases like 'xbmc_video58'
		  101 Query	show tables
		  101 Query	SELECT idVersion FROM version
		  101 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=84 and type=1 order by timeInSeconds
		  101 Quit	
		  102 Connect	xbmc@Apple-TV.local on 
		  102 Query	SET NAMES utf8
		  102 Query	show databases like 'xbmc_video58'
		  102 Query	show tables
		  102 Init DB	xbmc_video58
		  102 Query	show databases like 'xbmc_video58'
		  102 Query	show tables
		  102 Query	SELECT idVersion FROM version
		  102 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=83 and type=1 order by timeInSeconds
		  102 Quit	
		  103 Connect	xbmc@Apple-TV.local on 
		  103 Query	SET NAMES utf8
		  103 Query	show databases like 'xbmc_video58'
		  103 Query	show tables
		  103 Init DB	xbmc_video58
		  103 Query	show databases like 'xbmc_video58'
		  103 Query	show tables
		  103 Query	SELECT idVersion FROM version
		  103 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=82 and type=1 order by timeInSeconds
		  103 Quit	
		  104 Connect	xbmc@Apple-TV.local on 
		  104 Query	SET NAMES utf8
		  104 Query	show databases like 'xbmc_video58'
		  104 Query	show tables
		  104 Init DB	xbmc_video58
		  104 Query	show databases like 'xbmc_video58'
		  104 Query	show tables
		  104 Query	SELECT idVersion FROM version
		  104 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=81 and type=1 order by timeInSeconds
		  104 Quit	
		  105 Connect	xbmc@Apple-TV.local on 
		  105 Query	SET NAMES utf8
		  105 Query	show databases like 'xbmc_video58'
		  105 Query	show tables
		  105 Init DB	xbmc_video58
		  105 Query	show databases like 'xbmc_video58'
		  105 Query	show tables
		  105 Query	SELECT idVersion FROM version
		  105 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=80 and type=1 order by timeInSeconds
		  105 Quit	
		  106 Connect	xbmc@Apple-TV.local on 
		  106 Query	SET NAMES utf8
		  106 Query	show databases like 'xbmc_video58'
		  106 Query	show tables
		  106 Init DB	xbmc_video58
		  106 Query	show databases like 'xbmc_video58'
		  106 Query	show tables
		  106 Query	SELECT idVersion FROM version
		  106 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=79 and type=1 order by timeInSeconds
		  106 Quit	
		  107 Connect	xbmc@Apple-TV.local on 
		  107 Query	SET NAMES utf8
		  107 Query	show databases like 'xbmc_video58'
		  107 Query	show tables
		  107 Init DB	xbmc_video58
		  107 Query	show databases like 'xbmc_video58'
		  107 Query	show tables
		  107 Query	SELECT idVersion FROM version
		  107 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=78 and type=1 order by timeInSeconds
		  107 Quit	
		  108 Connect	xbmc@Apple-TV.local on 
		  108 Query	SET NAMES utf8
		  108 Query	show databases like 'xbmc_video58'
		  108 Query	show tables
		  108 Init DB	xbmc_video58
		  108 Query	show databases like 'xbmc_video58'
		  108 Query	show tables
		  108 Query	SELECT idVersion FROM version
		  108 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=77 and type=1 order by timeInSeconds
		  108 Quit	
		  109 Connect	xbmc@Apple-TV.local on 
		  109 Query	SET NAMES utf8
		  109 Query	show databases like 'xbmc_video58'
		  109 Query	show tables
		  109 Init DB	xbmc_video58
		  109 Query	show databases like 'xbmc_video58'
		  109 Query	show tables
		  109 Query	SELECT idVersion FROM version
		  109 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=76 and type=1 order by timeInSeconds
		  109 Quit	
		   99 Query	select * from episodeview order by idEpisode desc limit 10
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 15
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 14
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 13
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 12
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 11
		   99 Query	SELECT * FROM streamdetails WHERE idFile = 10
120129 11:50:28	  110 Connect	xbmc@Apple-TV.local on 
		  110 Query	SET NAMES utf8
		  110 Query	show databases like 'xbmc_video58'
		  110 Query	show tables
		  110 Init DB	xbmc_video58
		  110 Query	show databases like 'xbmc_video58'
		  110 Query	show tables
		  110 Query	SELECT idVersion FROM version
		  110 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=15 and type=1 order by timeInSeconds
		  110 Quit	
		  111 Connect	xbmc@Apple-TV.local on 
		  111 Query	SET NAMES utf8
		  111 Query	show databases like 'xbmc_video58'
		  111 Query	show tables
		  111 Init DB	xbmc_video58
		  111 Query	show databases like 'xbmc_video58'
		  111 Query	show tables
		  111 Query	SELECT idVersion FROM version
		  111 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=14 and type=1 order by timeInSeconds
		  111 Quit	
		  112 Connect	xbmc@Apple-TV.local on 
		  112 Query	SET NAMES utf8
		  112 Query	show databases like 'xbmc_video58'
		  112 Query	show tables
		  112 Init DB	xbmc_video58
		  112 Query	show databases like 'xbmc_video58'
		  112 Query	show tables
		  112 Query	SELECT idVersion FROM version
		  112 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=13 and type=1 order by timeInSeconds
		  112 Quit	
		  113 Connect	xbmc@Apple-TV.local on 
		  113 Query	SET NAMES utf8
		  113 Query	show databases like 'xbmc_video58'
		  113 Query	show tables
		  113 Init DB	xbmc_video58
		  113 Query	show databases like 'xbmc_video58'
		  113 Query	show tables
		  113 Query	SELECT idVersion FROM version
		  113 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=12 and type=1 order by timeInSeconds
		  113 Quit	
		  114 Connect	xbmc@Apple-TV.local on 
		  114 Query	SET NAMES utf8
		  114 Query	show databases like 'xbmc_video58'
		  114 Query	show tables
		  114 Init DB	xbmc_video58
		  114 Query	show databases like 'xbmc_video58'
		  114 Query	show tables
		  114 Query	SELECT idVersion FROM version
		  114 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=11 and type=1 order by timeInSeconds
		  114 Quit	
		  115 Connect	xbmc@Apple-TV.local on 
		  115 Query	SET NAMES utf8
		  115 Query	show databases like 'xbmc_video58'
		  115 Query	show tables
		  115 Init DB	xbmc_video58
		  115 Query	show databases like 'xbmc_video58'
		  115 Query	show tables
		  115 Query	SELECT idVersion FROM version
		  115 Query	select timeInSeconds, totalTimeInSeconds from bookmark where idFile=10 and type=1 order by timeInSeconds
		  115 Quit	
120129 11:50:29	   99 Query	select * from musicvideoview order by idMVideo desc limit 10
		   99 Quit	
		  116 Connect	xbmc@Apple-TV.local on 
		  116 Query	SET NAMES utf8
		  116 Query	show databases like 'xbmc_music18'
		  116 Query	show tables
		  116 Init DB	xbmc_music18
		  116 Query	show databases like 'xbmc_music18'
		  116 Query	show tables
		  116 Query	SELECT idVersion FROM version
		  116 Query	SELECT count(1) FROM songview LIMIT 1
		  116 Query	SELECT count(distinct strAlbum) FROM songview LIMIT 1
		  116 Query	SELECT count(distinct strArtist) FROM songview LIMIT 1
		  116 Quit	
		  117 Connect	xbmc@Apple-TV.local on 
		  117 Query	SET NAMES utf8
		  117 Query	show databases like 'xbmc_video58'
		  117 Query	show tables
		  117 Init DB	xbmc_video58
		  117 Query	show databases like 'xbmc_video58'
		  117 Query	show tables
		  117 Query	SELECT idVersion FROM version
		  117 Query	SELECT count(1) FROM tvshowview LIMIT 1
		  117 Query	SELECT count(1) FROM movieview LIMIT 1
		  117 Query	SELECT count(playCount) FROM movieview LIMIT 1
		  117 Query	SELECT count(1) FROM musicvideoview LIMIT 1
		  117 Query	SELECT count(playCount) FROM musicvideoview LIMIT 1
		  117 Query	SELECT sum(watchedcount) FROM tvshowview LIMIT 1
		  117 Query	SELECT sum(totalcount) FROM tvshowview LIMIT 1
		  117 Query	SELECT sum(watchedcount = totalcount) FROM tvshowview LIMIT 1
		  117 Quit

details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Name / Title: Save name / title?
Description / Question:
Tags: (space separated, optional)
Content Type:
Expire this post in:
Encrypt this paste. Password:

Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

worth-right

fantasy-obligation

pastebin - XBMC ATV2 - post number 2107459

Stuff to Do

Paste Actions

Information

Paste Details

Quick Search

Recent Posts

Advertising

XBMC ATV2
Sunday, January 29th, 2012 at 9:02:40am MST

advertising

Update the Post

pastebin - XBMC ATV2 - post number 2107459

Stuff to Do

Paste Actions

Information

Paste Details

Quick Search

Recent Posts

Advertising

XBMC ATV2Sunday, January 29th, 2012 at 9:02:40am MST

advertising

Update the Post

XBMC ATV2
Sunday, January 29th, 2012 at 9:02:40am MST