Hi, I am looking for a simple PHP maintenance script. Script will query mysql, delete certain records and then delete files from the file system. (PLEASE KNOW, MY DEPOSIT IN TO SL HAS NOT GONE THROUGH YET, PAYMENT MAY BE AS LATE AS FRIDAY 1/8/10.. THANKS )
Here is my psueo code.
query database playcount, gameid, type, category
WHERE playcount < x << a number I will pick and category = y << I cat i pick
on match
thefile = [login to view URL] <<< type should only be .swf, .dcr or .wmv
(IF TYPE OTHER, SKIP )
delete the actual file /path/swf/thefile
delete image file /path/images/[login to view URL]
delete the record
I think thats it. I have yahoo messenger. Thanks