Looking for a script to run on our server (Centos 5, PHP 5.1, MySQL 5.0) to upload photos to Facebook user accounts.
We have a User table with the FB UserID as part of the user registration with our application.
The script would run every ~ 1 min via CRONTAB, check the MySQL database that holds reference to the photos on our server and upload any photos that have not been marked as previously uploaded.
The photos would be uploaded to a specified Album in the User Record. If the Album doesn't exist, it first gets created. If the album has more pictures than the FB limit (Currently 60?), another Album is created with a sequence number appended.
If the photo is uploaded successfully, the row in the database is marked as uploaded (date/time).
MySQL table structure can be provided upon request.