BinaryWorks.it Official Forum
BinaryWorks.it Official Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 eXtreme Movie Manager (Rel. 7), No More Updates
 Information
 XMM Online database: onex
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 5 Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ternot
Junior Member

126 Posts

Posted - 26 Oct 2009 :  09:03:41  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello

could you post some further info or screenshot, this looks interresting !

Regards
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 26 Oct 2009 :  15:10:34  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
1st post updated

Edited by - ternot on 18 Dec 2009 10:37:20
Go to Top of Page

Alessio Viti
Forum Admin

Italy
9171 Posts

Posted - 27 Oct 2009 :  07:35:28  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Ternot!

I will include the new folder in next release.

Thank you!!

Ale

http://www.facebook.com/pages/eXtreme-Movie-Manager/47220214342?ref=mf
Go to Top of Page

llv007
Starting Member

15 Posts

Posted - 27 Oct 2009 :  17:07:18  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 28 Oct 2009 :  08:48:39  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

jalarab
Starting Member

14 Posts

Posted - 01 Dec 2009 :  20:18:11  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 08 Dec 2009 :  09:42:40  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Do you get an error message or what happens exactly?
Go to Top of Page

WildvsMan
Starting Member

United Kingdom
6 Posts

Posted - 13 Dec 2009 :  03:26:43  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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!
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 14 Dec 2009 :  12:54:52  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,
can you try to call the script using http://www.mydomain.com/movies/index.php?rs=full once?
Go to Top of Page

WildvsMan
Starting Member

United Kingdom
6 Posts

Posted - 15 Dec 2009 :  18:53:33  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 16 Dec 2009 :  08:54:42  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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)?
Go to Top of Page

WildvsMan
Starting Member

United Kingdom
6 Posts

Posted - 17 Dec 2009 :  02:35:57  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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!



Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 17 Dec 2009 :  09:33:01  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

WildvsMan
Starting Member

United Kingdom
6 Posts

Posted - 18 Dec 2009 :  00:32:17  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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!
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 18 Dec 2009 :  10:31:08  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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...
Go to Top of Page

WildvsMan
Starting Member

United Kingdom
6 Posts

Posted - 18 Dec 2009 :  16:06:17  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

McYoda
Starting Member

Switzerland
12 Posts

Posted - 18 Dec 2009 :  22:17:23  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

jalarab
Starting Member

14 Posts

Posted - 19 Dec 2009 :  00:33:01  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page

skaman
Starting Member

Switzerland
8 Posts

Posted - 19 Dec 2009 :  17:20:36  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply

I have the same problem as jalarab and McYoda.

http://dvd.kopfsalatmitei.ch/dvd2/

@ternot you speak German?
thanks 4 help
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 21 Dec 2009 :  10:43:00  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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?
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic   Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
BinaryWorks.it Official Forum © Binaryworks.it Go To Top Of Page
Generated in 0.14 sec. Powered By: Snitz Forums 2000 Version 3.4.07