Closed

form driven Module that interacts with external databases

I will be developing a joomla website in the near future that will need help from a joomla frelancer... I can handle the design, layout, graphics pieces, but there's a piece of the site that I would like to freelance out. It should be a module, not a component and therefore minimize the design effort. Here is the general design of the page, and the requirements of the system.

Essentially, I want a form where a user inputs the following fields

1. db external server ip or dns reachable name

2. db user

3. db password

4. db table where content (articles for instance) is stored

5. fields of table that operation is desired upon

6. conditional field values (only do this if approved = 1, etc..)

7. a Text Area box where the user calls out a certain set of critera of things to change in those tables of the database (i will get more specific when I pick a developer). This text box will have to be large, and allow for multiline input, each line serving as a separate operation on the database content.

8. Content date range boxes to specify a date range of the articles in the database that are wished to be changed.

9. Agree to terms and condition check box (which i will write)

10. Button to execute

11. Button to save off project

12. Button to test db connection - does nothing but ensure that a connection can be made to the database that has been specified, and that the user/pass combination works, and that the table specified and fields are all there.

Requirement1: the module must check if the user currently has enough funds allocated to their account to fund the operation at hand. (each operation on their database will incur a specific set price fee). Sufficient funds must be in the account prior to fullfilling the operation.

Requirement2: The modifications to the external database table must only touch the tables/fields indicated, must not store any passwords, and must not touch anything other than text (i.e. must know if something is a html tag, link, etc..)

Requirement3: Storage of Projects: The user must be able to set up projects in their user profile for each database they are touching, so that if they'd like to run the same project again (for lets say, a different timeline) they can.

Requirement4: Before any changes are made to database, a summary of changes, and a price quote is displayed, user must then click “yes” to commence the change. It would be here that Requirement1 comes into play.

Requirement5: Before changes are made, a backup must be made and stored locally of the database table being modified. After modification, a link to this backed up table is stored for the user to download for a certain period of time.

Requirement6: It must be possible for the user to schedule projects to run at specific times. This would require them to electronically sign a document indicating that it is ok to debit their paypal accounts for any funds incurred by the scheduled run.

Requirement7: There must be a settings file that the administrator can modify that has settings in it for such things as "price per db operation". I cant think of any other "configuration type settings" but in time there may be more and this will be the file that holds them.

Skills: Joomla, MySQL, PHP

See more: write website content freelance, website need freelance, website freelance profile, website freelance price, website design frelancer, website design freelance price, up frelancer, type design freelance, think freelance, things freelance, the frelancer, tag profile, system developer freelance, summary frelancer, site write anything, site frelancer design, sign design freelance, require html website developer, project developer freelance, profile summary php developer, profile summary freelance developer, profile freelance website, profile freelance, price website freelance, php html developer freelance

About the Employer:
( 12 reviews ) North Grafton, United States

Project ID: #1267131

6 freelancers are bidding on average $186 for this job

onenonly

Consider it done ;)

$200 USD in 4 days
(85 Reviews)
6.6
mdjalal123

Hi, I am expert Joomla.

$200 USD in 15 days
(0 Reviews)
0.0
martinrocky

PLEASE CHECK PMB

$250 USD in 6 days
(0 Reviews)
0.0
rickzos

PLEASE CHECK PMB

$200 USD in 6 days
(0 Reviews)
0.0
steveEarna

HELLO SIR PLEASE CHECK PMB

$190 USD in 4 days
(0 Reviews)
0.0
phpredindia

I can do this job efficiently.

$75 USD in 7 days
(0 Reviews)
0.0