perilin / plugin.image.mypicsdb Goto Github PK
View Code? Open in Web Editor NEWThis project forked from xycl/plugin.image.mypicsdb
MyPicsDB addon for XBMC
License: GNU General Public License v2.0
This project forked from xycl/plugin.image.mypicsdb
MyPicsDB addon for XBMC
License: GNU General Public License v2.0
1) How to include picture paths ================================================================================== Don't change the plugin configuration unless you know what you do! a) You must add picture sources to XBMC b) Within MyPicsDB (not in the configuration) select menu "Paths of pictures folders" to add these paths to the database. Excluding paths a) Add the exclude path(s) via menu "Paths of pictures folders". b) Rescan the paths which contain these added exclude paths to remove the pictures from MyPicsDB Excluding files a) This can be done in the plugin settings under "Files" b) You only need to enter a unique part of the complete path name. All files which contain this entered part of the path name will be excluded. c) Rescan all paths. d) To concatenate different file/path name parts use the | sign. Cleanup a) After renaming a directory you must do a full rescan! 2) MySql ================================================================================== a) You must create a database: CREATE DATABASE MyPicsDB CHARACTER SET utf8 COLLATE utf8_bin; b) Create a user (if not already done for music and movies): CREATE USER 'xbmc'@'%' IDENTIFIED BY 'xbmc'; c) give him rights GRANT ALL ON *.* TO 'xbmc'@'%'; d) Go to plugin settings and enable MySql. Set the correct user and password (they are case sensitive)! 3) Tag translation and combination of tags ================================================================================== Menu "translate your tags" lets you suppress tags (leave translation empty) or combine tags like 'Country/primary location name', 'Photoshop:Country' and 'Iptc4xmpExt:CountryName' to one 'Country' tag. 4) General problems with MyPicsDB ================================================================================== If you have unexplainable problems like pictures don't get included into database and you're a long time user of MyPicsDB then it will be a good decision to delete the database and start with a new one. To do this select "Pictures->Add-ons", press "C" and select "Add-on settings". Activate "Initialze the database at next startup" on tab "General" and press "OK". Then start MyPicsDB. All tables (except table rootpaths which includes your entered picture paths) are dropped and recreated. This means that the already entered paths are still available and that you can start a rescan with "Paths of picture folders"->"Scan all paths". 5) Auto-update MyPicsDB ================================================================================== Idea from Fungify To auto update the database you can use the following XBMC command: RunScript("C:\Users\Name\AppData\Roaming\XBMC\addons\plugin.image.mypicsdb\scanpath.py",--database) (Name is your Windows user!) Frodo: Use the service "The Scheduler" (http://forum.xbmc.org/showthread.php?tid=144378) and create a custom built-in script with the above command. Eden: Update MyPicsDB via HTTP API with a cron job. wget --directory-prefix=tmp --http-user=<xbmc username> --http-passwd=<xbmc password> "http://Servername:Portnumber/xbmcCmds/xbmcHttp?command=ExecBuiltIn¶meter=XBMC.RunScript("<full path to plugin>\plugin.image.mypicsdb\scanpath.py",--database) 6) For skinners ================================================================================== Done by MikeBZH44 a) For skinners, MyPicsDB can be called with following parameters to populate window properties : XBMC.RunScript(plugin.image.mypicsdb,0,?action='setproperties'&method ='Latest|Random'&sort ='Shooted|Added'&limit=10) Parameters are : - action='setproperties' to store in main window properties and in CommonCache DB - method='Lastest' to get Latest pictures from DB - method='Random' to get random pictures from DB - sort='Shooted' to get latest pictures sorted by Shooted date (EXIF DateTimeOriginal) - sort='Added' to get latest pictures sorted by Added in DB date (DateAdded) - limit=10 to get only 10 pictures Properties set to main window (ID=10000) : MyPicsDB<Method>.Count = Number of pictures returned (max=limit) MyPicsDB<Method>.1.Path = Path to picture #1 MyPicsDB<Method>.1.Name = Name of picture #1 MyPicsDB<Method>.1.Folder = Name of picture folder #1 MyPicsDB<Method>.1.Date = Shooted date of picture #1 MyPicsDB<Method>.2.Path = Path to picture #2 MyPicsDB<Method>.2.Name = Name of picture #2 MyPicsDB<Method>.2.Folder = = Name of picture folder #2 MyPicsDB<Method>.2.Date = Shooted date of picture #2 ... ... ... MyPicsDB<Method>.10.Path = Path to picture #10 MyPicsDB<Method>.10.Name = Name of picture #10 MyPicsDB<Method>.10.Folder = = Name of picture folder #10 MyPicsDB<Method>.10.Date = Shooted date of picture #10 b) To run a slideshow when user clicks on a picture : <onclick>XBMC.RunScript(plugin.image.mypicsdb,0,?action='slideshow'&method='Random'¤t=1)</onclick> Parameters : - action='slideshow' to run slide show - method='Lastest' to get Latest pictures from DB - method='Random' to get Random pictures from DB - current=1 to start slideshow with Picture #1 c) Statistic properties MyPicsDB<Method>.Categories = number of categories in DB MyPicsDB<Method>.Collections = number of collections in DB MyPicsDB<Method>.Folders = number of folders containing pictures in DB MyPicsDBRandom.Categories = MyPicsDBLatest.Categories (same for Count, Collections, Folders) but we don't know wich method each skinner will use so I make the job twice ;)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.