[HELP] Script linked to webservice

[anis79]

Hi and thanks a lot for this great software!!

First, i want to let you know that your soft works as a charm with wine (linux).

My problem: I am tired to export my movies to SQL and then upload all the pictures and update my database manually.

I've created a website driven by a database (based on the SQL export of AMC). I can do some kind of a webservice : everything works with post :
- login with post => a session number is displayed on the page so i can catch it with the script.
- post movie information => need to provide the session number and send the movie information and post the picture.

All this is made with PHP.

I need someone who knows how to do scripting with AMC and knows how to do, from a script, to read all the movies list and post the information to the page.

Is that possible or am i dreaming?

What i will provide in return to all the community is of course the website, the webservice and the database schema with a setup manual. I'll also make the website templatable to let everyone have his website looks the way he wants.

This is very serious, so if somebody is interested, please reply!

Thanks and keep going this is a great great job !

[antp]

It would be possible with current AMC to post info, but not post the picture.
If you use a ".amc" catalog you could upload the whole file on a site with a FTP client and make PHP scripts that use this catalog directly, I think. It should be possible.
Another solution is to use a ".xml" catalog, I think that some PHP scripts for that already exist, but then you have to also upload all the pictures with your FTP client since they are not stored in the XML file.

[anis79]

Thanks for your answer!

Do you have a sample script that processes all the movies database? (because i tried to have a look at the scripts and all of them takes 1 param, parse web pages, and then update 1 movie...)

Yes i thought about the amc file (or the xml), the fact is that, while in amc, the data are already parsed so the best is just to send them in the right form. So SQL would be a better solution then, and i'm back to the startup point...

[antp]

Movies are processed one by one by the script, so the script would have to update movies 1 by 1, by specifying its number to a PHP script that would update the database with specified parameters for example.

[anis79]

So you mean I have no solution than to process each movie separately (and manually)?

[antp]

Manually no, Shift+F6 and check that "All" in "Movies to include" is checked.
But the script will have to process movies one by one.

[anis79]

Ok that's what i thought.

But if i don't get help from you guys, i'll end up parsing the amc file which will be easier for me (even if i think it's the worst solution...).

So if somebody is interested in working with me on the script please feel free to contact me. Again, this is very serious !