I have a "webscript" that requires an Mysql database and configuration file.
I'm looking for a script or module that when a user submits a webform it will have a system to make the form pending. Once approved the script creates a new directory, moves "webscript" files, configures the configuration file, and makes a new mysql database.
The difficult part I believe is getting the webform submission information into the configuration file.
The end product is the script will produce a weblink of the webscript "[url removed, login to view]"
first if I need to provide ftp username or database user name or even cpanel username just let me know. I have included the webscript files and can provide an exmaple of what the config file looks like setup if needed just let me know
I have a website [url removed, login to view] This site has a webform on it that allows data to be submitted. Right now its running drupal but I like joomla a lot more and this script should be used on joomla.
I want for it to be able to be installed without having to modify joomla base scripts
The site can use any free module/component that inputs forms, it can even use joomlas built in one if it has one.
the web form will have the following information
* First Name
* Last Name
* Eve Online User Name
* Eve Online Corporation Name
* Eve Online Alliance Name
* How Did you hear about us?
* **Domain name** (example: [url removed, login to view]
* Active/Non Active (admin control)
When user submits his information once logged into the site the form will input this into a table.
Somewhere inside joomla inside a component have an area that all forms go to pending waiting for approval, once approved the script starts its process. little start button. This area should include the form information and a status area saying pending/completed
Once started the script will configure the configuration file [url removed, login to view] and that will be placed inside the folder (etc) of the new directory.
All the webscript files will be moved from a clean temp directlry to a newly created directory that the user has chosen in the webform. So the user can choose demo1 and the script would of created a new directory for [url removed, login to view]
So in Final this project will allow a user to browse my site, fill a form out in joomla. It will fall into que marked as pending, once approved. That form will be used by the script to configure a configuration file. It will add that file along with the remaing files and copy to a new folder that was specified by script. It will create a new database and database user name which will be configured into the config file. And database user name has to be setup with permissions. And a mysql database needs to be imported into the newly created mysql database. Overall the form information needs to be displayed inside and area where it can be configured and qued up waiting for approval.
Once this has been done the script should be working, waiting for user input. The site should display correctly with no errors.
The output from the script can be rather a pop up saying task completed or I would prefer on the page that is displaying the pending information have it switch to completed maybe in green.
lastly a safety system should be built into script so that by me clicking pending/complete it wont mess up anybody's database and reset anything. so if something already exist it never overwrites and always cancels the task
This is just the first part of maybe a expanding script. For now I want it to be able to automate setup and quickly process order and have site online in seconds
* * *
I would like to see that when I click run script and the site is setup, that it sends a email saying a predetermined message, but this part is not required
* * *possible features in future
Making the Run script button send an email to the user that their site is now running
Setting form to Non Active inside control panel shuts off database
Delete forms = move database to a backup folder
Allowing for paypal payments, integrating with shopping cart to allow same form to work after payment was processed.
A form checker to make sure the information being submitted dosent already exist
Advanced (python) : Using an eve online api to pull wallet information exporting to an xml file. The script would then look for a specific payment of isk with a specific description from specific eve username and then it would match that back up with the form user name and then match that up with site and if customer makes payment inside game the script would know. If customer didnt pay the script would disable site after so forth days.
email system saying your site is disabled