[Vicious]

Hello XBMC Forum!

I've seen a few threads regarding a standalone solution for managing the XBMC database. None of them however suits my needs, or if they do the project has been discontinued.

I have a headless LAMP server hosting the XBMC database (MySQL), files and thumbnails. Of course I want to have the database manager running on the same machine!

I wanted a simple solution for managing the database: removing movies/episodes, changing titles, change fan art, etc. Also I wanted the tool to be easily adapted to different setups.
The goal is that the application shall be OS (and webserver) independent, work without internet connection, easy to setup and adapt.

I am currently reworking this but progress is slow since my time is limited.

Updated 2012-07-26 13:10, version 0.22

Project exist on github: https://github.com/Farfar/XBMC-Database-Manager

Changelog: https://github.com/Farfar/XBMC-Database-...ngelog.txt

Features:

• View TV-Shows/Episodes/Movies with cast, fan art, posters, and banners
  
• Simple installer/setup script (basic config, database and user)
  
• Change movie posters
  
• Edit movie/tv-show/episode details (somewhat broken)
  
• Filter what to list based on watched status, date added, year, title, season (TV-shows)
  

To do:

• Option to change fanart/banners (posters can be changed, TMDB API)
  
• More sorting options
  
• More filtering options
  
• Search
  
• Adding functions: delete object (fixed for movies), etc
  
• Support for different kinds of databases (needs testing and error handling)
  
• Security checks and error handling
  
• General code cleanup
  
• ?
  

Download
Installation guide (OUTDATED!)

Is there anyone out there that would like to contribute? Almost all help is appreciated!
I don't have much spare time myself but put in an hour here and there.

Screenshots

TV-Show info


Episode info


Movie info with list collapsed

[connors]

Are you using any frameworks or version control for this?

[Vicious]

Not yet, no.
I am going to finish the base first and then perhaps upload to github.
I want it to be able to switch views between movies/tv-shows/music before I mark it as v0.1

As of this afternoon I have finished the function for fetching movie information and displaying it.

[ajayrockrock]

I would love to help with a project like this. I'm a linux user and hate having to reboot into windows just to run Ember. Let us know when you have it uploaded to github.

[Vicious]

Update!

• Project now exist on github.
  
• Some changes in the code, minor and major.
  
• Added listing for TV-shows (no episode view yet)
  
• Surely something more
  

[Mar2zz]

Only mysql-db right now I assume?

[Vicious]

For the time being it is mysql. However I believe it is rather easy to implement other dbs. As long as they are supporter in php pdo.

[Haze]

hi, it's a very good idea, i was looking for a solution like this one.

I tested and it works apart for non-ascii characters that display "�"

What can i do for have characters like é/à/ê... ?

[Vicious]

hi, it's a very good idea, i was looking for a solution like this one.

I tested and it works apart for non-ascii characters that display "�"

What can i do for have characters like é/à/ê... ?

I'm not sure if it's the cause but I have changed the charset from utf-8 to iso-8859-1 in index.php.
See if that helps

If not you can try changing the charset to something else in this line in index.php:

Code:

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />

[Haze]

I was already in utf-8, i changed to iso-8859-1 and it's work fine now.

Thank you and I look forward to test the new features.

[Vicious]

Update!
Added:

• Alphanumeric sorting (thanks to Espen)
  
• Function to mark movies as watched (thanks to Espen)
  

The functions are currently written for XBMC Dharma database, I will start working on a function to determine the version of the database (eden/dharma) so both work correctly.

[sodapopdad]

how do you actually install this? Can you just drop it into one of my xbmc web interface folders and call it from there in a web browser? I tried that and it was just a black screen.

I go to http://myipaddress:8182/ to reach the AWX Web Interface just fine.

I I downloaded your scripted and extracted it to the folder

C:\Users\me\AppData\Roaming\XBMC\addons\frolick-AWX-Eden-a46c57c\dbmanager

so when I call http://myipaddress:8182/dbmanager

the url resolves to this

http://myipaddress/dbmanager//////////////////////

with the error of a redirect loop?

if I go to

http://myipaddress:8182/dbmanager/index.php

I get a black screen

[Vicious]

how do you actually install this? Can you just drop it into one of my xbmc web interface folders and call it from there in a web browser? I tried that and it was just a black screen.

I go to http://myipaddress:8182/ to reach the AWX Web Interface just fine.

I I downloaded your scripted and extracted it to the folder

C:\Users\me\AppData\Roaming\XBMC\addons\frolick-AWX-Eden-a46c57c\dbmanager

so when I call http://myipaddress:8182/dbmanager

the url resolves to this

http://myipaddress/dbmanager//////////////////////

with the error of a redirect loop?

if I go to

http://myipaddress:8182/dbmanager/index.php

I get a black screen

The thought of this project is to have a standalone web page without the need for the actual xbmc machine running.

You install it by moving the folder with all the files to a folder being served by a web server. In my case I have it setup with apache in /var/www/xbmcdm/, then I can access the page via: serveraddress/xbmcdm/index.php

I also have setup apache so only local adresses can access the page, don't wan't the whole world to be able to access the page before it is ready with auth or such

[N3MIS15]

great start and having the project on github=win

[Vicious]

great start and having the project on github=win

Thank you

Update!:

• Different sort options in list (alpha/year in movies, alpha/first aired in tv-shows)
  
• Added jquery to handle refreshing of content (won't reload whole page)
  

I will continue to work on the functions this week, will see how much I time I can spare.

I would appreciate it if someone would be so kind as to fix the general design of the page. It's a little bit boring in black and white

Also if anyone knows how to pair a specific movie/show id to a thumbnail, please share!