| Author |
 Topic  |
|
|
ternot
Junior Member
126 Posts |
 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
|
Edited by - ternot on 20 Jan 2010 09:01:36 |
|
|
llv007
Starting Member
15 Posts |
Posted - 26 Oct 2009 : 11:52:46
|
Hello
could you post some further info or screenshot, this looks interresting !
Regards |
 |
|
|
ternot
Junior Member
126 Posts |
Posted - 26 Oct 2009 : 15:10:34
|
1st post updated  |
Edited by - ternot on 18 Dec 2009 10:37:20 |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
llv007
Starting Member
15 Posts |
Posted - 27 Oct 2009 : 17:07:18
|
Hello
looks great. Would it be possible to have the possibility to have both front and back covers for movies ?
Or to chose the one to display ?
Thanks |
|
|
|
ternot
Junior Member
126 Posts |
Posted - 28 Oct 2009 : 08:48:39
|
Well,
you could upload your back covers (maybe scale it down in advance) and modify the template to display it... Just insert
<img src="covers/<?=$movie["BackCover"]?>"> into e.g. "detail.tpl" to display it...
As alternative I have updated the win onex to process the back covers. also the templates are updated now...
Download link please see above... |
Edited by - ternot on 18 Dec 2009 10:38:55 |
|
|
|
jalarab
Starting Member
14 Posts |
Posted - 01 Dec 2009 : 20:18:11
|
hello:
i tried to follow the documentation but when i tried to run the script to import the DB to MySQL didn't work. can you help me?
tx |
|
|
|
ternot
Junior Member
126 Posts |
Posted - 08 Dec 2009 : 09:42:40
|
| Do you get an error message or what happens exactly? |
|
|
|
WildvsMan
Starting Member
United Kingdom
6 Posts |
Posted - 13 Dec 2009 : 03:26:43
|
WOW! This looks great! I have been trying to get a good online movie DB for a long time but I am not a PHP, mysql, xml, database master. Thanks for the effort you have put into this. The screen shots look great!
Unfortunately I am unable to get the movies to display. I have believe I have setup the config.inc properly. I am able to use the import.php to import the xml file created by XMM. But when I go to www.mydomain.com/movies/index.php I am getting a search screen with the text "query returned no results" and 0/763.
Here is a screenshot of the page:
I am unable to get past this page and view any movie details. Any help would be appreciated. Thanks once again for this plugin! |
|
|
|
ternot
Junior Member
126 Posts |
|
|
WildvsMan
Starting Member
United Kingdom
6 Posts |
Posted - 15 Dec 2009 : 18:53:33
|
Hi ternot,
Thanks for the reply. I tried /index.php?rs=full. I am getting the same result as http://www.mydomain.com/movies/index.php or just http://www.mydomain.com/movies. "Query returned no results" I have imported several times and also performed an inkremental import and altered my CHMOD permissions but nothing seems to be changing.
Thanks once again for your efforts. |
|
|
|
ternot
Junior Member
126 Posts |
Posted - 16 Dec 2009 : 08:54:42
|
Hm...
what are your settings for
$setting["criteria"]
$setting["mode"]
$setting["value"]
in the file config.inc?
What happens, if you do a search query (like title contains 'a' or something else)? |
|
|
|
WildvsMan
Starting Member
United Kingdom
6 Posts |
Posted - 17 Dec 2009 : 02:35:57
|
Ternot,
$setting["criteria"] = "title";
$setting["mode"] = "begins";
$setting["value"] = "A";
The only things I changed in the config.inc were:
$host = "localhost";
$user = "myname";
$pass = "mypass";
$database = "my_sql";
and...
$setting["AdminPassword"] = "password";
Other than those settings I have changed nothing in the config.inc.
quote:
What happens, if you do a search query (like title contains 'a' or something else)?
For a search of 'a' I get the text:
"SELECT * FROM movies where Title like '%a%' AND moviefile1 not like '' ORDER BY Title"
For a search of 'batman' I get the text:
"SELECT * FROM movies where Title like '%batman%' AND moviefile1 not like '' ORDER BY Title"
Thanks again ternot!
|
|
|
|
ternot
Junior Member
126 Posts |
Posted - 17 Dec 2009 : 09:33:01
|
no problem :-)
the sql statements look ok to me... can you provide me your xml file? You could send an email via the forum. Then I reply and you have my email address...
Best regards
ternot |
|
|
|
WildvsMan
Starting Member
United Kingdom
6 Posts |
Posted - 18 Dec 2009 : 00:32:17
|
ternot,
I sent an email. I didn't attach the xml but I provided a direct link to the file in zip format.
Thanks again ternot! |
|
|
|
ternot
Junior Member
126 Posts |
Posted - 18 Dec 2009 : 10:31:08
|
Hi WildvsMan,
I found a little bug. You can find the link to the fixed version above...
Only the files "index.php" and "import.php" have changed.
But there is no need to re-import the xml file...
In your case I would recommend to change in the "config.inc" file
$setting["hdd"] = 1;
to
$setting["hdd"] = 0;
This should work... |
|
|
|
WildvsMan
Starting Member
United Kingdom
6 Posts |
Posted - 18 Dec 2009 : 16:06:17
|
That worked.
Great job finding whatever the issue was. Your solution worked. I have mine up and running if you want to take a look.
So, It looks exactly like the screenshots! (except your covers are higher resolution!)
Thanks again!
The plugin looks great. I will post some suggestions/ideas here soon.
WvM
|
Edited by - WildvsMan on 18 Dec 2009 16:13:53 |
|
|
|
McYoda
Starting Member
Switzerland
12 Posts |
Posted - 18 Dec 2009 : 22:17:23
|
Hi ternot
I have the same problem as jalarab. Followed documentation, loaded xml export to the webserver and called the import.php script.
Activated the xml file and gave the password. Clicking start, nothing really seems to happen.
After calling index.php I get your template with no movies including some errors, which I can hardly read because of the given colors.
You can see here: http://mcyoda.bplaced.net/index.php
Thanks for help
Regards
McYoda |
Edited by - McYoda on 19 Dec 2009 14:13:37 |
|
|
|
jalarab
Starting Member
14 Posts |
Posted - 19 Dec 2009 : 00:33:01
|
quote:
Originally posted by ternot
Do you get an error message or what happens exactly?
Hello ternot, thanks for your help. The problem is that nothing happens. i don't know what i am doing wrong.
 |
|
|
|
skaman
Starting Member
Switzerland
8 Posts |
|
|
ternot
Junior Member
126 Posts |
Posted - 21 Dec 2009 : 10:43:00
|
quote:
Originally posted by jalarab
quote:
Originally posted by ternot
Do you get an error message or what happens exactly?
Hello ternot, thanks for your help. The problem is that nothing happens. i don't know what i am doing wrong.
Hi jalarab,
as far as I can see, your local webserver does not handle the php script like mine...
Do you have other php scripts already running? |
|
|
|
Topic |
|
|
XMM Online database: 
