Database Connection

It's now time to change the config files to reflect the database connection
info you saved to notepad after creating the database and database user/pass.
Load Up FileZilla!
Start up Filezilla and connect to your hosted website, then find your Article Friendly Pro Files. Next, double click on the "system" folder and you should see a list of files in that folder. Right click on the config.inc.php file, and choose "View/Edit" from the popup menu in filezilla. The contents of that file should automatically load in PsPad and you will see the following from the image below. If you get an error message, please Click Here for how to setup PsPad to work with filezilla.
Line 1 - The highlighted yellow parts are the places you will make changes. See where it says "database name"? This is where you will paste the database name you created in cpanel earlier. Be sure to paste the information in between the quote marks like this - define("DB_NAME","accountname_databasename"). Note that the red line numbers in the image above won't actually be in the config.inc.php file.
Of course, you will overwrite "database name" with the actual database name you created previously.
Line 2 - Next line lists the
mysql server. You can usually leave this to "Localhost". but if your database connection ends up not working,
ask your host if you should put something else in between the quotes of that line. Lets leave it as is for our example.
Line 3 - Next line is for your database user name. Again, paste it between the quotes so it looks something like this - define("USER_NAME","accountname_username") ... Make sure you didn't copy any spaces in front or behind any of the info you've pasted in!
Line 4 - Last is the database password. Enter this in between the quotes so it looks something like this - define("PASSWORD","mypassword").
After you've completed entering all the information, copy the entire 4 lines of database connection info you entered to your computer's memory, close the PsPad editor, and filezilla will ask if you wish to upload the page back to your website. Click on yes, and the changed file will be loaded back to your site!
Next Folder & File
Now, double click on the "admin" folder (or whatever you renamed it to), and after filezilla moves into that folder, find the system folder and double click on it. Again, right click on the config.inc.php file in that folder, and when it loads in PsPad, paste the info you copied previously over the same four lines. You should now see the same 4 lines of database connection info that you entered in the first config.inc.php file has overwritten the matching lines in this second config.inc.php!
After you've completed copying all the information, close the PsPad editor, and filezilla will ask if you wish to upload the page back to your website. Click on yes, and the changed file will be loaded back to your site as before!
License Key
The last thing is to look in your admin folder for either a file called configuration.php or license.php. Open that in PsPad and you will need to copy/paste your license key in between the Quotes. Your license key is in your client area where you originally downloaded Article Friendly!
As examples, if you have the configuration.php, you'll see this line in the page - $license="Paste your license code here"; - Simply paste your license key in between the quotes (Overwriting the text), making sure you don't have any whitespace at the front or end of the quotes.
If you have license.php, the line will be:
$license_key = 'USER LICENSE KEY'; // Paste License key in between the quotes like so '523-11567-89-5313-4546-4'
Watch The Movie!
All Done!
Now it's time to setup your new Article Friendly site's admin settings. If you want to celebrate alittle bit after a great job, go right ahead and do the victory dance! After you are done, click on the next button below to learn about your admin settings.
