MYSQL Site Automation Scripts

Main Goal Summary: Automate user activity on the site. There is a lot of traffic hitting the site, but its mostly to watch adult videos. I want to encourage people to create accounts and shift the focus of the site to be more of a Social Network for adults. It would mean creating accounts on the site that would then act as regular users by uploading pictures and videos, sending friends requests and other actions that simulate users to encourage the real users to do the same. (all described in details below) Proposed Method: I’d like to do this via scheduled automations. Where it would self run at set times of the day. The scripts themselves can be in the form of php based web form pages with textboxes that inject the data into the DB. There are several pages in the ADMIN section of Rayzz that are capable of doing just that already, they can used as your guidelines. Im open for suggestions as to whats the best way to do this. If we use PHP or Perl webforms, I’d have to use an Automation program to parse the data from the spreadsheets into the webform. There might be a better more sophisticated way to do this. What I have to work with: I’ve already created excel spreadsheets with the data I’d like to use. These spreadsheets also contain paths to pictures where applicable. Spreadsheets are my preferred method since its easy for me to put those together. Details of the automations: - Each script would read data from an excel spreadsheet. The spreadsheet would contain the email, password, location and details of each account to be created separated by row. So I would just have to create the spreadsheets for each script and select some options within the script. - The scripts can be web-based and capable of automating with Cronjobs or another self-run method (So i can set it and it will run by itself for many days). Details of the individual scripts: Daily account creation: Account creator would create accounts daily (promotional members) , upload photos to each, and insert profile layout in the account. Daily Friend requests: The promo members will be sending friend requests to other members (members who have been active within X weeks and other selectable options, selectable) Friend request Acceptor: Will accept the friend requests sent to the promo users throughout the day. Manually this is done by selecting (ACCEPT) in a mail in the inbox, I’d like to figure a way to do it directly in the DB. Mark mail as read: Will mark all mail received by the "promo accounts" as read, so senders believe real people are logging in daily and checking the internal mails they are sending to them. (Senders can tell in their "sent mailbox" if the message is read or unread) Profile Comments poster: Promo members Will post comments on other members profiles randomly throughout the day. (must never post the same comment on the same persons profile) Video Comments Poster: Promo members would leave random comments on new videos uploaded within x amount of days (must never post the same comment on the same video) Girls and guys leave different comments so they would each read from a different excel spreadsheet. Video Uploaded Randomizer: I already have an automation in place to upload videos as certain promo members. I just need a way to change the ID number of a few rows to random promo members ID’s so its not the same members uploading everyday like it is now.