Thread: cron job activation automation

I'm trying to automate the process in which members profiles are automatically reactivated via the following SQL (auto_active.sql):

Code:

UPDATE `amp`.`RayMp3Files` SET `Approved` = 'true' WHERE `RayMp3Files`.`ID` > 0;
UPDATE `amp`.`RayMusicFiles` SET `Approved` = 'true' WHERE `RayMusicFiles`.`ID` > 0;
UPDATE `amp`.`Profiles` SET `Status` = 'Active' WHERE `Profiles`.`ID` > 0 ;
UPDATE `amp`.`ProfilesSettings` SET `Status` = 'Active' WHERE `ProfilesSettings`.`Status` = 'Approval';

the script cron calls (auto_active.sh) :

Code:

mysql -ppassword -u root -D databasenamehere < auto_active.sql

and the crontab:

Code:

*/1 * * * * /home/mcstaff/auto_active.sh

as you can guess im trying to allow this to run on every minute. the script works if i just execute ./auto_activate.sh and works as desired however the cron job fails without error. any ideas?

Ubuntu Linux 7.40, no major mods, dolphin 6.005.

Do it as a php file.... not .sh file..... you can call the .php file as a cron
and you need a database connection - include your header.inc.php and db.inc.php - and use the Dolphin database calls to do the database work.

Smoge

better yet - update the ray .php code - and make it so it is set to approved right on the media changes/uploads...