Thread: [Device Plugin] Kobo Touch Extended Driver
View Single Post
Old 11-08-2013, 06:44 PM   #799
jgoguen
Generally Awesome Person
jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.jgoguen ought to be getting tired of karma fortunes by now.
 
Posts: 1,061
Karma: 2178845
Join Date: Jan 2013
Location: /dev/kmem
Device: Kobo Clara HD, Kindle Oasis
As soon as I get a chance. I never committed it, and then the whole repo got corrupted (it's on a Copy.com share) so I lost my stash I'll have to recreate the code I fear. But here is the delta I worked from (generated from before and after wirelessly syncing books with Kobo) and my note of the order of the fields:
Code:
(ContentID, ContentType, MimeType, BookID, BookTitle, ImageId, Title, " + \
                "Attribution, Description, DateCreated, ShortCoverKey, adobe_location, Publisher, IsEncrypted, " + \
                "DateLastRead, FirstTimeReading, ChapterIDBookmarked, ParagraphBookmarked, BookmarkWordOffset, NumShortcovers, VolumeIndex, " + \
                "___NumPages, ReadStatus, ___SyncTime, ___UserID, PublicationId, ___FileOffset, ___FileSize, " + \
                "___PercentRead, ___ExpirationStatus, FavouritesIndex, Accessibility, ContentURL, Language, BookshelfTags, " + \
                "IsDownloaded, FeedbackType, AverageRating, Depth, PageProgressDirection, InWishlist, ISBN, " + \
                "WishlistedDate, FeedbackTypeSynced, IsSocialEnabled, EpubType, Monetization, ExternalId, Series, " + \
                "SeriesNumber, Subtitle, WordCount, Fallback, RestOfBookEstimate, CurrentChapterEstimate, CurrentChapterProgress, " + \
                "PocketStatus, UnsyncedPocketChanges, ImageUrl, DateAdded, WorkId)
+INSERT INTO "content" VALUES(
	'4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!01_Cover.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'01_Cover.html',
	'',NULL,NULL,NULL,NULL,NULL,'false',
	NULL,'true',NULL,0,0,NULL,0,
	0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,1,
	0,NULL,-1,-1,NULL,NULL,NULL,
	1,0,0,0,NULL,'false',NULL,
	NULL,0,'true',-1,2,NULL,NULL,
	NULL,NULL,-1,NULL,NULL,NULL,NULL,
	0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!02_Halftitle.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'02_Halftitle.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,1,1,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,1,1,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!03_Fm.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'03_Fm.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,2,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,3,5,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!04_Title.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'04_Title.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,3,1720713428,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,8,2,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!05_Copyright.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'05_Copyright.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,4,1722898696,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,10,9,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!06_Dedication.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'06_Dedication.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,5,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,20,1,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!07_Fm1.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'07_Fm1.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,6,575131113,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,22,1,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!08_Chapter01.html','9','application/xhtml+xml','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'08_Chapter01.html','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,7,64208192,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,24,75,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');

+INSERT INTO "content" VALUES(
	'4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!01_Cover.html-1','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'Cover',
	'',NULL,NULL,NULL,NULL,NULL,'false',
	NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!01_Cover.html',0,0,NULL,0,
	16777215,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,
	0,NULL,-1,-1,NULL,NULL,NULL,
	1,0,0,1,NULL,'false',NULL,
	NULL,0,'true',-1,2,NULL,NULL,
	NULL,NULL,-1,NULL,NULL,NULL,NULL,
	0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!02_Halftitle.html-2','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'A Delicate Truth','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!02_Halftitle.html',0,0,NULL,1,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,2,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!03_Fm.html-2','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'By the same author','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!03_Fm.html',0,0,NULL,2,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,2,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!04_Title.html-1','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'Title Page','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!04_Title.html',0,0,NULL,3,36,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!05_Copyright.html-1','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'Copyright','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!05_Copyright.html',0,0,NULL,4,-1,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!06_Dedication.html-2','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'For VJC','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!06_Dedication.html',0,0,NULL,5,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,2,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!07_Fm1.html-2','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'If one tells the truth,','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!07_Fm1.html',0,0,NULL,6,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,2,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!08_Chapter01.html-1','899','application/x-kobo-epub+zip','4bec20b3-1f30-4d1b-9ace-71140494d024','A Delicate Truth',NULL,'Chapter 1.','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!08_Chapter01.html',0,0,NULL,7,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');

+INSERT INTO "content" VALUES(
	'4bec20b3-1f30-4d1b-9ace-71140494d024','6','application/x-kobo-epub+zip',NULL,NULL,'D2MYEBatOUWAcHIylUYE3A','A Delicate Truth',
	'John le Carre','DESCRIPTION','0001-01-01T00:00:00.100',NULL,'4bec20b3-1f30-4d1b-9ace-71140494d024','Penguin Canada','true',
	'2013-06-14T23:41:54Z','true',NULL,1,0,8,0,
	2122866472,0,'2013-11-05T21:57:13Z','8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,NULL,0,
	0,0,-1,6,'http://www.kobobooks.com/ebook/A-Delicate-Truth/book-syDsSzAfG02aznEUBJTQJA/page1.html','en','',
	'true',0,0,0,NULL,'false','9780143188919',
	NULL,1,'false',3,2,'',NULL,
	NULL,NULL,-1,NULL,0,0,0.0,
	0,X'7B20207D',NULL,'2013-06-14T23:41:54Z','');

+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!01_Cover.html',0);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!02_Halftitle.html',1);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!03_Fm.html',2);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!04_Title.html',3);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!05_Copyright.html',4);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!06_Dedication.html',5);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!07_Fm1.html',6);
+INSERT INTO "volume_shortcovers" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','4bec20b3-1f30-4d1b-9ace-71140494d024!OEBPS!08_Chapter01.html',7);

+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_cvi_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_cvi_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,0,3211311,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,1,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_tp_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_tp_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,1,3604527,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,1,3,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_ded_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_ded_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,2,3604572,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,4,3,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_toc_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_toc_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,3,2122866472,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,8,10,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c01_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_c01_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,4,2122866472,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,18,4,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c02_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_c02_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,5,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,22,29,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c03_r1.htm','9','application/xhtml+xml','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'OEBPS/9781443419116_epub_c03_r1.htm','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true',NULL,0,0,NULL,6,575450721,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,52,47,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');

+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_cvi_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'Cover','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_cvi_r1.htm',0,0,NULL,0,132120820,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_tp_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'Title Page','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_tp_r1.htm',0,0,NULL,1,1,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_ded_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'Dedication','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_ded_r1.htm',0,0,NULL,2,0,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_toc_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'Contents','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_toc_r1.htm',0,0,NULL,3,13857656,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c01_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'ONE','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c01_r1.htm',0,0,NULL,4,575040256,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c02_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'TWO','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c02_r1.htm',0,0,NULL,5,7864432,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');
+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c03_r1.htm-1','899','application/x-kobo-epub+zip','bf26b172-c685-43f4-87cb-8c64d3f58a99','The 100-Year-Old Man Who Climbed Out the Window and Disappeared',NULL,'THREE','',NULL,NULL,NULL,NULL,NULL,'false',NULL,'true','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c03_r1.htm',0,0,NULL,6,575694365,0,NULL,'8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,1,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,X'7B20207D',NULL,NULL,'');

+INSERT INTO "content" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','6','application/x-kobo-epub+zip',NULL,NULL,'shwo2Qnkl0qeKbZOrGjJhQ','The 100-Year-Old Man Who Climbed Out the Window and Disappeared','Jonas Jonasson','<p>After a long and eventful life, Allan Karlsson ends up in a nursing home, believing it to be his last stop. The only problem is that he’s still in good health, and one day, he turns 100. A big celebration is in the works, but Allan really isn’t interested (and he’d like a bit more control over his alcohol consumption). So he decides to escape. He climbs out the window in his slippers and embarks on a hilarious and entirely unexpected journey.</p> <p>It would be the adventure of a lifetime for anyone else, but Allan has a larger-than-life backstory: Not only has he witnessed some of the most important events of the twentieth century, he has actually played a key role in them. Quirky and utterly unique, <em>The 100-Year-Old Man Who Climbed Out the Window and Disappeared</em> has charmed readers across the world.</p>','0001-01-01T00:00:00.100',NULL,'bf26b172-c685-43f4-87cb-8c64d3f58a99','HarperCollins Publishers','true','2013-06-14T23:41:54Z','true',NULL,1,0,7,0,2122866472,0,'2013-11-05T21:57:13Z','8b6c4381-0e07-4aec-b5e3-e65e1d3fac78',NULL,NULL,0,0,0,-1,6,'http://www.kobobooks.com/ebook/The-100-Year-Old-Man/book-crEmv4XG9EOHy4xk0_WKmQ/page1.html','en-US','','true',0,0,0,NULL,'false','9781443419116',NULL,1,'false',3,2,'',NULL,NULL,NULL,-1,NULL,0,0,0.0,0,X'7B20207D',NULL,'2013-06-14T23:41:54Z','');

+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_cvi_r1.htm',0);
+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_tp_r1.htm',1);
+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_ded_r1.htm',2);
+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_toc_r1.htm',3);
+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c01_r1.htm',4);
+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c02_r1.htm',5);
+INSERT INTO "volume_shortcovers" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','bf26b172-c685-43f4-87cb-8c64d3f58a99!!OEBPS/9781443419116_epub_c03_r1.htm',6);

+INSERT INTO "Activity" VALUES('4bec20b3-1f30-4d1b-9ace-71140494d024','false','RecentBook',2,'2013-11-05T17:57:22',X'00000000');
+INSERT INTO "Activity" VALUES('bf26b172-c685-43f4-87cb-8c64d3f58a99','false','RecentBook',2,'2013-11-05T17:57:25',X'00000000');
jgoguen is offline   Reply With Quote