| T O P I C R E V I E W |
| ternot |
Posted - 26 Oct 2009 : 09:03:41
Hi all,
in the last release, Alessio added my new plugin called onex.
It's a tool for importing the XMM database into a mysql db and view its content online.
You can download the current version at
http://ternot.jke.ch/XMM_OnEx_V0.2d.zip
onex consists of three components:
- PHP script for displaying the movie collection in a web browser
Displaying the collection is done by a single script („index.php“), which is creating the layout based on HTML templates.
- PHP script for the import of the collection out of a XMM XML file into a MySQL database
The script („import.php“) is looking for XML files in its directory on the web server and offers these files for importing the movies.
- a Windows tool to convert, scale and rename covers and actor pictures.
Covers don’t have to be processed with this tool, but it is recommended to decrease the file size before the upload to a web server is done. Furthermore special characters can cause problems on some web servers. The built-in rename functionality simply removes these characters and spaces.
Actor pictures should be processed with this tool anyway, because the PHP script is searching for pictures with the same naming scheme (and in “.png” format).
Features
- multilanguage GUI
- template-based
- extensive search capabilities
- supports several filter and sorting criteria’s:
- title
- insert date
- genre
- rating
- marked
- database driven
- movies can be browsed and played directly on NMTs like the Popcorn Hour (up to 8 movie files per movie)
- scaling of covers and actor pictures BEFORE uploading to a web server
- optional second cover size (e.g. a bigger cover for movie details)
- support for back covers
- optional mirror effect for movie covers, configurable in height and transparency
- all settings can be passed via command line parameters
System requirements
- Web server with:
- PHP Version 4.x or newer, SafeMode = Off
- MySQL database (Version 5.x)
- sufficient web space (1 MB for the scripts + x MB for pictures)
- for picture processing: Windows XP or newer
Screenshots
As onex templates are using a modular design principle, the supplied themes can display the movies in different ways.
For more information some documentation is enclosed... Or ask in the forum...
As this was my project to learn php, I would be happy if someone has some suggestion in optimizing the code or the templates 
Have fun
ternot
--------------------------------------
Change history:
--------------------------------------
onex V0.1b
----------
Initial release
onex V0.2b
----------
Added: "Play" button for all 8 Movie files
Added: "BackCover" can be processed with the windows tool and is now part of the standard templatesonex V0.2b
onex V0.2c
----------
Fixed: Import.php - Error when missing the file "XML-Export.xml"
Fixed: Displaying movies without files was buggy
onex V0.2d
----------
Fixed: Import.php - Somestims not all movies were imported
Fixed: Index.php - Minor corrections
|
| 20 L A T E S T R E P L I E S (Newest First) |
| JDommi |
Posted - 30 May 2012 : 10:52:01
Ale, what about the import from file?
With that function you would be able to import from .nfo as well as from .xml. |
| Alessio Viti |
Posted - 30 May 2012 : 09:01:13
Hello,
No, I am sorry, actually only the Export works for XML, there isn't any Import of this XML function yet.
Ale |
| klint01 |
Posted - 26 May 2012 : 03:00:35
Is there a way to import the XML-Export file into a new XMM database? I tried a couple of the Import XML but they are looking for a specific layout, so it does not work. |
| klint01 |
Posted - 24 May 2012 : 05:40:49
quote:
Originally posted by klint01
quote:
Originally posted by klint01
Error: Unknown column 'MOVIE3D' in 'field list'
I found the issue. The XML creation includes four additional fields that are not created by the Import.php file while building the tables.
The fields are <Movie3D>, <CharacterInfo>, <SerieStatus>, and <Original>.
I could add the fields to the table, but I am not sure what the expected character value should be for these fields. Any feedback would be great.
In looking at the code and the database I was able to uncover three of the four field lengths. The one I could not find was CharacterInfo, so I set it to VARCHAR(250). Now all is good with the world.
Great application, but you may want to look at updating the import.php file. |
| klint01 |
Posted - 24 May 2012 : 05:14:25
quote:
Originally posted by klint01
Error: Unknown column 'MOVIE3D' in 'field list'
I found the issue. The XML creation includes four additional fields that are not created by the Import.php file while building the tables.
The fields are <Movie3D>, <CharacterInfo>, <SerieStatus>, and <Original>.
I could add the fields to the table, but I am not sure what the expected character value should be for these fields. Any feedback would be great. |
| klint01 |
Posted - 24 May 2012 : 01:47:50
Trenot, I am experiencing some identical issues to others I have seen on this board. Essentially, everything is exported correctly and moved to my webserver (hosted), but when I run the import.php the movies are not writing to the database. The genre is populated and so is the roles table but movies is blank. Upon looking at the logfile, I found the following error:
Error: Unknown column 'MOVIE3D' in 'field list'
I have not found an occurrence of MOVIE3D in the import.php script yet, so find this very odd. I am assuming, it is meant to be MOVIEID but looking for some guidance to resolve the issue so the movies import correctly.
Thanks! |
| yehudili |
Posted - 27 Apr 2011 : 05:19:30
I may be silly but i cannot for the life of me see what I am doing wrong. Any ideas as this is very frustrating not evn being able to get past stage 1. I run Windoes 7 and Xmm has admin permmisions set.This look briliant and exactly what I want. |
| babutsa |
Posted - 21 Apr 2011 : 18:56:38
Hi trenot,
I have exactly same problem with mouh_stach007 and i don't use directories also.
But i dont get what is your solution, what can i do for this problem?
my database is working and import creates directories also.
roles and genres tables is ok but movies table is 0..
when i enter index.php 0/0 movies appear.
by the way which version is your script coming with new XMM? isnt that 0.2d?? |
| Salomons |
Posted - 02 Apr 2011 : 09:05:07
I had the same problem. Only with Polish characters. Errors "bushes"appear in the list of movies when exported to an XML file. Therefore, prior to export office opened database access. search for all the regional trade and turned more to them universal. For example, "ó"to "o ". Stalked. I think that such a solution is good. Mainly related to changes in the field "plot". Only the names of the actors did not change. The change resulted in the identification of bad photos. I hope that helped. Sorry for my english |
| Relax |
Posted - 01 Apr 2011 : 21:13:18
Hello all,
your onex tool is very nice and I did install it on my own mini webserver. This is an Qnap NAS TS-459.
With this installation I dont want to play movies via the server. With the XMM I only manage my DVD-Collection and I would be able to publish these collection with friends over the internet.
After the installation I have following problem:
After modifying of the files like ternot wrote befor the export of my XMM movie-database to an XML-file works fine. But when I look at the correspondent Web-Site I see only a few words from the field of the description of my movies. The most of the text is not imported.
If I look at my mysql-database the text of the field "Plot" is also cropped. But every time the text is cropped at the first letter of german umlaut.
So I tried to change the setting of the "ReplaceCharacters". If I do this my movie-description-text shows letters like "ä" or similar letters.
Now I dont know what I can do for changing this and I hope for your help.
Best regards
Klaus
|
| Salomons |
Posted - 01 Apr 2011 : 08:18:23
Hello, Onex is working perfectly. Even on the PDA.
Quite strongly aligned to the Polish conditions. To be completely happy I only slimbox option to enlarge the cover (detail). Ultimately, displays it halved, to mobile devices to fit, but I would be able to grow them. Sorry for my English.
Onex in my performance: filmy.salomonik.eu |
| ternot |
Posted - 21 Mar 2011 : 09:46:15
Hi there,
I know this error ;-)
The solution is described in another thread:
quote:
Currently the script will always hang, if a new field is added to the XMM DB. The DBId is the rest of a test I did with something like a real primary key, but I stopped that test...
Although your code should work, the correct text in line 372 in the import.php script should :-) be
`Movie3D` bit(1) DEFAULT NULL,
Additionally I would recommend to rename the config.inc to config.php and to change the import.php (line 5) and index.php (line 9) to point to this file...
Best regards
ternot |
| mouh_stach007 |
Posted - 18 Mar 2011 : 18:03:00
Hi I'm actually experiencing problems with your plugin.
I want to put a html version of my XMM database on my webserver which is a NAS synology.
I've installed phpmyadmin and activated mysql, and configurated mysql to create a database and a special username and password that can acces only this database and have all privilege acces.
I've also modified the config.inc before uploading it to my webserver.
I've exported my XML from xmm and then upload it to my server.
But when I run the import.php that seems to run properly (showing xx films imported and after a while 'done') I can't see anything when loading index.php.
The number of films is still 0/0.
I've first tried the included version of onex inside XMM and then downloaded on this thread the 0.2d and restarted the procedure.
I can see while import.php run that there is error whith movie3d field that doesn't exist for every film, but the script keep running until DONE.
No improvement still a empty index.php.
I've look to the database itself and I've remarked that only the "genres" and "roles" tables have values. Movie is empty.That means that onex succeed in accessing database.
Do you have similar problem or do you see what can be the one in my case?
Directories in config.inc are untouched because my films aren't on a permanent directory and I don't plan to run film directly from browser.
It's only a way to access my database for consultation wherever I am.
Could that be going from this point?
Thanks ;) |
| elvio@emarinho.com |
Posted - 24 Jan 2011 : 15:53:13
Hi,
This tool is great.
Amazing work Ternot.
Are there any online version that I can see?, instead of screen shots?
thanks |
| Kebyh |
Posted - 09 Sep 2010 : 19:18:42
Wow,
I just found out about this thread ternot, and honestly it looks gorgeous!!!!
Actually i know nothing about programation, mysql and that kind of things so i guess i can't do anything with it but i just wanted to say that you did a great work as this is how i d like my database to look if it was on internet.
cheers. |
| Alessio Viti |
Posted - 25 Aug 2010 : 04:50:03
Yes, I confirm it too,
Now everything is working.
Thank you!
Ale |
| wakamoto |
Posted - 25 Aug 2010 : 04:27:04
Thanks all for the help, it works great now. |
| Alessio Viti |
Posted - 20 Aug 2010 : 21:57:07
OK Ternot...
sorry for not-sending you my files, I was really busy these days.
I will try to make tests tomorrow. Thank you for the files!
Alessio |
| wakamoto |
Posted - 20 Aug 2010 : 17:27:52
Thanks for more input Ternot. I think we have a progress after changing the php.ini short_opentag to "On".
I was able to look at the status display for the first time while it's importing or doing something other than just a gif file that show the animation.
I included a link to a documented errors msg that I received to your email for further analysis.
Thank you all for helping.
|
| ternot |
Posted - 20 Aug 2010 : 13:45:15
Hi Alessio,
it's currently not something like a release, it's more a "test"...
Can you also give it a try?
If an error occurs, change logging=0 to logging=1 in the ini file... Then a log file is created...
ternot |
