1. open the create_mysql_db.php and change the variables at the top for your mySQL server.

    $DBName = "quikstore";
    $host = "localhost";
    $user = "";
    $password = "";

2. Use/Run the create_mysql_db.php in a browser from your website to create the tables.

3. Open the save_mysql.pl file and change the variables for your mySQL server:

        # Connection configuration:

    my($database) = "quikstore";
    my($hostname) = "localhost";
    my($db_username) = "";
    my($db_password) = "";

        # Encryption info for card fields

        # EncryptCardFields is either 1 (on) 0 (off)

    my $encryptCardFields = 1;
    my $cardField = "Card_Number";
    my $cvv2Field = "Verification_Number";

        # Be sure to change this one...

    my $cryptPhrase = "mary had a little lamb";

        # Note: if mysql server version is greater than 4.0.02,
        # AES Encryption will be used for card fields.

    my $mySQLserverVersion = "4.0.21";

4. replace your cgi-bin/plug-ins/order_logs.pl file with the attached order_logs.pl file

5. Set this variable to yes in the qs_main.cgi file:

    create_custom_log=yes

Once the database is there, it should now store the orders into the tables.

# -------------------------------------------------------------------
If you are using a php program to display the orders, you need to do this to decrypt
the card fields:

In PHP, you will have to do this in your program to decrypt the fields:


@list($serverVersion,$os) = split("-",mysql_get_server_info());
$serverVersion = intval(ereg_replace(".","",$serverVersion));

if($serverVersion >= 4002){
    $ordersql = "SELECT *,
                        AES_DECRYPT(orders.card_number,'$crypt_key') as card_number,
                        AES_DECRYPT(orders.verification_number,'$crypt_key') as verification_number
                 FROM orders WHERE ordernumber = '$orderNum' LIMIT 1";
}
else{
    $ordersql = "SELECT *,
                        DECODE(orders.card_number,'$crypt_key') as card_number,
                        DECODE(orders.verification_number,'$crypt_key') as verification_number
                 FROM orders WHERE ordernumber = '$orderNum' LIMIT 1";
}


The $crypt_key variable should be set at the top of your php program to match the phrase
in the top of save.mysql.pl