Jump to content
Sign in to follow this  
MoisesZaragoza

Credit Class & Gift Voucher

Recommended Posts

Ok I just addes http://www.oscommerce.com/community/contributions,282 (Credit Class & Gift Voucher) it was not the latest version it was CCGV 5.15a (Full Package) but 4 some rason i dont have the fille name "filename.php" or database_table.php

 

can some one tell me were to get those files

 

Thaks


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

Ok my error for now are :

 

1) 1146 - Table 'coolbug.TABLE_COUPON_GV_CUSTOMER' doesn't exist

 

2) select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '3'

 

I need to know what the value of TABLE_COUPON_GV_CUSTOMER should be


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

Thanks

I was looking for the one for the catalog. not the admin

 

but thanks


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

ok another error i have

when I send a Gift E-mail to a custumer they get this message when they press on the link

 

 

 

1146 - Table 'coolbug.COUPONS' doesn't exist

 

select c.coupon_id, c.coupon_amount from COUPONS c, TABLE_COUPON_EMAIL_TRACK et where coupon_code = 'c2ff75' and c.coupon_id = et.coupon_id

 

[TEP STOP]


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

if you have an early version of oscommerce then the filenames and database tables would be defined in the application_top.php

 

your errors are all related to not having the database tables defined

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Share this post


Link to post
Share on other sites

I was looking were those thigs were declared on the contreibution

sorry If I was not clear


at the end of the day the code will be good

Share this post


Link to post
Share on other sites
Ok my error for now are :

 

1) 1146 - Table 'coolbug.TABLE_COUPON_GV_CUSTOMER' doesn't exist

 

2) select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '3'

 

I need to know what the value of TABLE_COUPON_GV_CUSTOMER should be

 

 

ok on the Cat/includes/database_tables.php

 

I added

 

////////////# GV

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPONS', 'COUPONS');

 

define('TABLE_coupon_email_track', 'coupon_email_track');

define('TABLE_coupon_gv_queue', 'coupon_gv_queue');

define('TABLE_coupon_redeem_track', 'coupon_redeem_track');

define('TABLE_coupons_description', 'coupons_description');

 

 

and that took care of those erros


at the end of the day the code will be good

Share this post


Link to post
Share on other sites
ok another error i have

when I send a Gift E-mail to a custumer they get this message when they press on the link

1146 - Table 'coolbug.COUPONS' doesn't exist

 

select c.coupon_id, c.coupon_amount from COUPONS c, TABLE_COUPON_EMAIL_TRACK et where coupon_code = 'c2ff75' and c.coupon_id = et.coupon_id

 

[TEP STOP]

 

 

This is the e-mail link that takes me there

 

https://coolbugstuff.com/gv_redeem.php?gv_no=c2ff75


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

I know I am posting alot in my own thing but I just keep seeing new thing

 

i was going threw my admin area and i have a new payment mod that is called "Credit Class Error"

 

is that supose to be that way?

in any case it dose not show on the checkout page


at the end of the day the code will be good

Share this post


Link to post
Share on other sites
ok on the Cat/includes/database_tables.php

 

I added

 

////////////# GV

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPONS', 'COUPONS');

 

define('TABLE_coupon_email_track', 'coupon_email_track');

define('TABLE_coupon_gv_queue', 'coupon_gv_queue');

define('TABLE_coupon_redeem_track', 'coupon_redeem_track');

define('TABLE_coupons_description', 'coupons_description');

 

 

and that took care of those erros

 

 

That is wrong because the the name of the constants shoud be all CAPS

 

this is the right way

 

 

////////////# GV

define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer');

define('TABLE_COUPONS', 'coupons');

 

define('TABLE_COUPON_EMAIL_TRACK', 'coupon_email_track');

define('TABLE_COUPON_GV_QUEUE', 'coupon_gv_queue');

define('TABLE_COUPON_REDEEM_TRACK', 'coupon_redeem_track');

define('TABLE_COUPONS_DESCRIPTION', 'coupons_description');


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

I was able to fix everything. but now I was testing but i do not know how i pay with the certificate that I have


at the end of the day the code will be good

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×