The Elite Membership Manager Step-By-Step Users Guide Part 2
In part one of this tutorial we set up a new MySQL database, set up a user for that database
and gave that user permissions to access that database.
In part two, we're going to import the database table information, set up a configuration
file in the script itself, and upload the membership script and get it operating.
Setting Up The Database Tables
OK, now I want you to head back to the databases list again, only this time I want you to
scroll all the way to the bottom of that page, and find a link that says: phpMyAdmin.
Now click that link, and a new window should open up so we can access and update any databases
we have in our system.
To the left you should see a menu window or frame with a drop-down selection menu. Open that
menu and find the database you created for this script, and choose that database name.
After choosing the database name, a new screen should appear in the right hand window or frame
on your screen. Look to the top of that window and find the tab above that says "SQL". Click on
that link and you will see a window that says "Run SQL query/queries on database username_members"
or whatever you named your database.
There will be another area below that says "Or Location of the text file:". This is the
section we will use to set up your tables in this database.
Make sure to put a dot in the box that says: "gzipped", then click the browse button, and
find the "database.sql.gz" that was supplied with this membership script in the "docs" folder.
Select the "database.sql.gz" file, then click the "Go" button on the bottom right hand corner,
and it will be added to our database we created earlier. One it is finished, it should show you that
it was successful in adding your tables to the database. There will be a bunch of code show up, don't
worry about that, all we care about is that you DO NOT see an error message anywhere on that screen.
OK, now that your tables have been added to your MySQL database, we're all finished with this part of
the installation, and you can now log out of your hosting account and relax for a few minutes. You Did
Great!.. See, there was nothing to it was there? :)
Getting The Script Ready For Upload
OK, now before we can upload your script to your server, there is one thing that we need to do first,
and that is to edit the configuration file first, and add in our MySQL database information from earlier.
Locate the file "conn.php" located in the inc folder that came with your membership script.
Now open that file in a plain text editor such as Windows NotePad, and change the information in it to
the information we saved earlier to the text file... Remember? The one that you saved your MySQL username,
password, and database name in? You did do that part, right?
Locate the line that looks like this: $db_host = "localhost";
If your hosting provider supplies you with something other than this for connecting to your database
server, enter that there now in between the quotes. Make sure there is no whitespace between the quotes
as this will create errors when trying to access your site later.
In 98% of the cases, you will NOT have to change this line, so if you're not sure if your hosting provider
is using something other than localhost, just leave that line there for now.
Next, locate the lines that look like this:
$db_username = "USERNAME";
$db_password = "PASSWORD";
$db_name = "DATABASE_NAME";
Replace each line between the quotes with the information we saved to our text file earlier, so you
should end up with something that now looks like this when finished:
$db_username = "username_mradmin";
$db_password = "admin123";
$db_name = "username_members";
...again where username is the username you use to login to your hosting account with. Also, make
that there is no whitespace left between the quotes or this will cause errors when trying to access your
site.
OK, now save that file and we're now ready to upload your script to your server...
Uploading Your Script And CHMODing
OK, now using your favorite FTP program, upload the script to your server. The easiest way to do this
is to simply select the "msm" folder, and upload it including all contents in the folder.
There are many different FTP programs on the market, my favorite one is WS_FTP, and you can download
a free trial copy of it by click here.
I cannot go into a tutorial on using an FTP program here, there are to many, and it would be outside the scope
of this tutorial on installing the membership script. Please read the documentation provided with your FTP
program to be sure you know how to use it properly.
Make sure that you upload your script to your public folder, some hosting providers name these folders
differently, if in doubt, please contact your hosting provider for details regarding which folder is your
public folder.
You may also upload this script into a folder on your server if you do not want it in your root directory.
Remember that it is already contained in a folder named msm as to not interfere with any documents
you may have in your root directory.
Once you have uploaded the script to your server, we need to CHMOD a few files to get everything ready
and so it will operate successfully for you.
Open the folder "manager" and find the file hack.log, and CHMOD this file to 777. Next,
navigate to the "members" folder, and CHMOD the hack.log to 777 there as well. Finally,
navigate to the "registration" folder, and CHMOD the file named purchase.php to 777.
I highly recommend that when you're happy with your purchase.php file, and it fits your business
model to CHMOD this file back to 644. We will get into this discussion a little later...
Click Here To Continue To Page 3
|