Automate Wordpress Database Editing

This is a very straightforward project that involves reading information from a Wordpress database, extracting text and links, and replacing that data with new text and links. ## Deliverables This is a very straightforward project that involves reading information from a Wordpress database, extracting links, and replacing those links with new links. Part 1: There will be a dashboard that allows the user to define all of his wordpress blogs by url and login information: Ex: Blog Name URL Admin Password --------- --- ----- -------- myblog1 http.. admin1 pass2 myblog2 http.. admin2 pass2 ... ... The software must be able to access the actual MySQL database. I'm not sure if the user would need to enter the database name, user, and password or if once logged into the WP admin you have access to this. Part 2: The software must scan the posts in the blog for all links. The scan will bring up a window that shows the link anchor text and the actual link. Example: Anchor Text Actual Link Click Here! [login to view URL] ... ... ... Step 3: The software will then give the user a chance to replace the actual anchor text and link with new anchor text and link: Old Old New New Anchor Text Link Anchor Text Link This will be a table on the screen with a check box beside each row. Checked items will be changed, unchecked will not be changed. ADDITIONAL FUNCTIONS 1. Adding links to existing text. The user can type in a text string and the software will search the blog posts for this string. The user will have the option to replace the text AND and a link to the text. Example: Search: Dog training videos Replace: Click Here to Learn More About Training Your Dog Add Link: [login to view URL] 2. Global Search and Replace Hoplinks Software will scan entire blog for clickbank hoplinks and give use the option to replace hoplinks. Clickbank hoplink is in format: [login to view URL] where xxxxxxxx is affiliate id that will be replaced and yyyyyyyy is clickbank id of product being sold. 3. Software will store text/html paragraphs that can be inserted randomly in blog posts. Use will select frequency, i.e., every 4th post, etc. Example: Text Snippets ------------- 1. This is a really great article... 2. [editor's note: check out this link ...] ... ... etc. The text snippets can be paragraphs, not just single lines. The software shall be written in php, and the data stored in a MySQL database on a server.