file upload for new moduals

[John Ireland]

Hi I have access to files on an oscommerce site thats settings are set to include the ccv2 security code for visa transactions and removes these at a click of a button. I recentley got a new site that does not have this option but needs it. Could some one tell me what files I would need to copy from the old site and place in the new site so it includes the ccv2. example cc.php cc-validation.php etc.

 

Thanks alot I have tried this

 

Files included (2) to replace:

cc.php - replaces catalog/includes/modules/payment/cc.php This was based on the originally CVV2 modded cc.php

 

cc_validation.php -replaces catalog/includes/classes/cc_validation.php - this does the error checking this mod was designed for

 

 

 

Then you will need to do the following. (the following info new to this revision)

 

To add the CVV2 code to the DB, use phpmyadmin to do the following query...

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR(4) AFTER `cc_number`; --->>>>this I dont get?????

 

Next, for the display of the CVV code... I actually added that to the orders.php file under admin (i.e. admin/orders.php). Here's what you need to add.

 

Go down about line 196 (look for this block)

<tr>

<td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>

<td class="main"><?php echo $order->info['cc_number']; ?></td>

</tr>

 

add this block after it...

<tr>

<td class="main"><?php echo ENTRY_CREDIT_CARD_CVV2; ?></td>

<td class="main"><?php echo $order->info['cc_cvv2']; ?></td>

</tr>

 

 

save the file.

 

Next, go to the file admin/includes/languages/english/orders.php

 

and add this line (you can add it where the CC stuff is, or at the end )

 

define('ENTRY_CREDIT_CARD_CVV2', 'CVV2:');

 

and then save the file.

 

I think that will do it. Pull up an order and see if the code displays.

 

~It did not work for me as Im doing some thing wrong. Could i just not copy all the php files from the old configured site and replace but i know the data base then needs to be edited.

Hope some one can take the time to help me out.

 

Thank you.

[♥geoffreywalton]

you need to use the phpmyadmin program to run it.

 

That program is already installed by most hosts nowadays. There should be a link to it in your hosts control panel. If you can't find it, ask your host about it.

 

Once it is started, you select the database name on the left, the sql tab on the right and then paste the line and go.

 

You can also import files containing loads of sql commands from this area.

[John Ireland]

you need to use the phpmyadmin program to run it.

 

That program is already installed by most hosts nowadays. There should be a link to it in your hosts control panel. If you can't find it, ask your host about it.

 

Once it is started, you select the database name on the left, the sql tab on the right and then paste the line and go.

 

You can also import files containing loads of sql commands from this area.

 

Thank you for the reply much appreciated! Yes I can access it from my host but once im in there Im not sure what im doing

. I have to run a command I think I can do that. But then what? What I have done is taking the files from a site that is configured to run ccv2 and uploaded them to the new site. Just to be sure could you tell me what those files should be to make sure I am uploading and replacing the correct ones. Thanks again for the reply.

[John Ireland]

This is what I see on the left a big menu with alot of files

Browse: InnoDB free: 10240 kB (2 Rows) address_book

Browse: InnoDB free: 10240 kB (5 Rows) address_format

Browse: InnoDB free: 10240 kB (1 Rows) banners

Browse: InnoDB free: 10240 kB (4 Rows) banners_history

Browse: InnoDB free: 10240 kB (20 Rows) categories

Browse: InnoDB free: 10240 kB (60 Rows) categories_description

Browse: InnoDB free: 10240 kB (121 Rows) configuration

Browse: InnoDB free: 10240 kB (15 Rows) configuration_group

Browse: InnoDB free: 10240 kB (1 Rows) counter

Browse: InnoDB free: 10240 kB (0 Rows) counter_history

Browse: InnoDB free: 10240 kB (239 Rows) countries

Browse: InnoDB free: 10240 kB (2 Rows) currencies

Browse: InnoDB free: 10240 kB (2 Rows) customers

 

 

 

 

This to the right ...... MySQL

Create new database Create new database: Documentation

No Privileges

Show processes Show processes Documentation

Character Sets and Collations Character Sets and Collations

Storage Engines Storage Engines

Databases Databases

Export Export

Log out Log out

 

phpMyAdmin

Language

Language Info:

MySQL charset MySQL charset: UTF-8 Unicode (utf8)

MySQL connection collation

MySQL connection collation: armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cib

inarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1251_bincp1251

_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp125

6_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general

_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cide

c8_bindec8_swedish_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingb

k_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebre

w_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_gene

ral_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_

general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilat

in2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin

5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general

_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_

ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish

_ciucs2_estonian_ciucs2_general_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian

_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_s

lovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unic

ode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_estonian_ci

utf8_general_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciu

tf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spa

nish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci Documentation

Theme / Style

Theme / Style:

phpMyAdmin documentation phpMyAdmin documentation

Official phpMyAdmin Homepage Official phpMyAdmin Homepage

[ChangeLog] [CVS] [Lists]

[John Ireland]

This is what I see on the left a big menu with alot of files

Browse: InnoDB free: 10240 kB (2 Rows) address_book

Browse: InnoDB free: 10240 kB (5 Rows) address_format

Browse: InnoDB free: 10240 kB (1 Rows) banners

Browse: InnoDB free: 10240 kB (4 Rows) banners_history

Browse: InnoDB free: 10240 kB (20 Rows) categories

Browse: InnoDB free: 10240 kB (60 Rows) categories_description

Browse: InnoDB free: 10240 kB (121 Rows) configuration

Browse: InnoDB free: 10240 kB (15 Rows) configuration_group

Browse: InnoDB free: 10240 kB (1 Rows) counter

Browse: InnoDB free: 10240 kB (0 Rows) counter_history

Browse: InnoDB free: 10240 kB (239 Rows) countries

Browse: InnoDB free: 10240 kB (2 Rows) currencies

Browse: InnoDB free: 10240 kB (2 Rows) customers

This to the right ...... MySQL

Create new database Create new database: Documentation

No Privileges

 

 

The i see the button to Run SQL query/queries on database

Show processes Show processes Documentation

Character Sets and Collations Character Sets and Collations

Storage Engines Storage Engines

Databases Databases

Export Export

Log out Log out

 

phpMyAdmin

Language

Language Info:

MySQL charset MySQL charset: UTF-8 Unicode (utf8)

MySQL connection collation

MySQL connection collation: armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cib

inarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1251_bincp1251

_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp125

6_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general

_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cide

c8_bindec8_swedish_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingb

k_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebre

w_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_gene

ral_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_

general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilat

in2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin

5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general

_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_

ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish

_ciucs2_estonian_ciucs2_general_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian

_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_s

lovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unic

ode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_estonian_ci

utf8_general_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciu

tf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spa

nish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci Documentation

Theme / Style

Theme / Style:

phpMyAdmin documentation phpMyAdmin documentation

Official phpMyAdmin Homepage Official phpMyAdmin Homepage

[ChangeLog] [CVS] [Lists]

 

 

The i find the run sql query I enter the line thats high lighted and run it. I get this error

 

Error

 

SQL query:

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 ) AFTER `cc_number`

 

MySQL said: Documentation

#1060 - Duplicate column name 'cc_cvv2'

[John Ireland]

The i find the run sql query I enter the line thats high lighted and run it. I get this error

 

Error

 

SQL query:

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 ) AFTER `cc_number`

 

MySQL said: Documentation

#1060 - Duplicate column name 'cc_cvv2'

 

Obviously i ran the query twice, i think, but after that what would be the next step?

[John Ireland]

Obviously i ran the query twice, i think, but after that what would be the next step?

 

 

Could any one explain? Please Thanks

[♥geoffreywalton]

From the messages you have posted the "alter" command has worked as the second run gave an error message as would be expected.

 

So if it doesn't work now, you need to double check you have followed all of the other installation instruction.

 

Also check if there is a support thread mentioned in the contribution download area, there might be some posts that relate to your problem.

[John Ireland]

From the messages you have posted the "alter" command has worked as the second run gave an error message as would be expected.

 

So if it doesn't work now, you need to double check you have followed all of the other installation instruction.

 

Also check if there is a support thread mentioned in the contribution download area, there might be some posts that relate to your problem.

 

Thanks very much for you reply. New to data basing so im glad I could follow and run the query. Could you tell me would it be wise to copy the needed files which are??? from a previous site that has ccv2 set up on the check out and in the admin area to remove the ccv2 after purchase is cleared and the return date has passed. to copy those files which are --------??? and load them into the new site and the run the query. Replace the ones I have and use the ones I need. files such as cc.php cc_validation.php cc_popup.php etc??

 

Thanks alot and merry christmas

[♥geoffreywalton]

You could o that but could never be 100% sure that the files you are copying over wont have some code in them that is not compatible with the new site.

 

So all I can do is repeat my previous advice.

[John Ireland]

You could o that but could never be 100% sure that the files you are copying over wont have some code in them that is not compatible with the new site.

 

So all I can do is repeat my previous advice.

 

 

Thanks, so would you happen to know which all those files would be?

[♥geoffreywalton]

No you would have to check each one.

 

Not something anyone in there right mind would want to do so.....

 

 

 

So if it doesn't work now, you need to double check you have followed all of the other installation instruction.

 

Also check if there is a support thread mentioned in the contribution download area, there might be some posts that relate to your problem.