Jump to content

bored

Members
  • Content count

    18
  • Joined

  • Last visited

  1. bored

    [CONTRIBUTION] CCGV (trad)

    just curious if this would be possible. I noticed on several ecommerce sites, when you buy a gift voucher and send it to someone, it formats the information (To and From and the amount) into a nice looking printable html certificate. How could this be done? Would it be difficult to implement? I think it could be a nice feature to this already awsome contrib.
  2. bored

    ShowNewPrice

    So if you choose a value lets say adds 3 bucks to the price, if you switch back to the original option set, it wont take the 3 bucks back off?
  3. bored

    [CONTRIBUTION] CCGV (trad)

    ok it works now, strange thing is, it says to install yet, when i click the voucher line again, it brings me into the setup config. So it is working, thank you again for a great contrib!
  4. bored

    [CONTRIBUTION] CCGV (trad)

    dont know whats wrong then, i double checked the install, everything was edited and added to the server according to the install manual, the folder order_total is set for 755chmod and the 2 files are set at 644.
  5. bored

    [CONTRIBUTION] CCGV (trad)

    Also, the sql im using is the one that came with the new ccgv trad contrib. So I have no clue why it is not working.
  6. bored

    [CONTRIBUTION] CCGV (trad)

    Ok, I finally got the links correct and the sql correct. Now for some reason under modules, order total, the coupons are not installed and when i click to install, nothing happnes and they dont install. I reinstalled the tables but no luck.
  7. bored

    [CONTRIBUTION] CCGV (trad)

    Hi there, that did not work, I dropped the tables several times and reinstalled the sql file. The links are also still messed up. Any more suggestions? here is the conformation of the sql execution. # phpMyAdmin MySQL-Dump # Database : `ccgv_trad` # # Table structure for table `coupon_email_track` # CREATE TABLE coupon_email_track( unique_id int( 11 ) NOT NULL AUTO_INCREMENT , coupon_id int( 11 ) NOT NULL default '0', customer_id_sent int( 11 ) NOT NULL default '0', sent_firstname varchar( 32 ) default NULL , sent_lastname varchar( 32 ) default NULL , emailed_to varchar( 32 ) default NULL , date_sent datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( unique_id ) ) TYPE = MYISAM;# MySQL returned an empty result set (i.e. zero rows). # # Table structure for table `coupon_gv_customer` # CREATE TABLE coupon_gv_customer( customer_id int( 5 ) NOT NULL default '0', amount decimal( 8, 4 ) NOT NULL default '0.0000', PRIMARY KEY ( customer_id ) , KEY customer_id( customer_id ) ) TYPE = MYISAM;# MySQL returned an empty result set (i.e. zero rows). # # Table structure for table `coupon_gv_queue` # CREATE TABLE coupon_gv_queue( unique_id int( 5 ) NOT NULL AUTO_INCREMENT , customer_id int( 5 ) NOT NULL default '0', order_id int( 5 ) NOT NULL default '0', amount decimal( 8, 4 ) NOT NULL default '0.0000', date_created datetime NOT NULL default '0000-00-00 00:00:00', ipaddr varchar( 32 ) NOT NULL default '', release_flag char( 1 ) NOT NULL default 'N', PRIMARY KEY ( unique_id ) , KEY uid( unique_id, customer_id, order_id ) ) TYPE = MYISAM;# MySQL returned an empty result set (i.e. zero rows). # # Table structure for table `coupon_redeem_track` # CREATE TABLE coupon_redeem_track( unique_id int( 11 ) NOT NULL AUTO_INCREMENT , coupon_id int( 11 ) NOT NULL default '0', customer_id int( 11 ) NOT NULL default '0', redeem_date datetime NOT NULL default '0000-00-00 00:00:00', redeem_ip varchar( 32 ) NOT NULL default '', order_id int( 11 ) NOT NULL default '0', PRIMARY KEY ( unique_id ) ) TYPE = MYISAM;# MySQL returned an empty result set (i.e. zero rows). # # Table structure for table `coupons` # CREATE TABLE coupons( coupon_id int( 11 ) NOT NULL AUTO_INCREMENT , coupon_type char( 1 ) NOT NULL default 'F', coupon_code varchar( 32 ) NOT NULL default '', coupon_amount decimal( 8, 4 ) NOT NULL default '0.0000', coupon_minimum_order decimal( 8, 4 ) NOT NULL default '0.0000', coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00', coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00', uses_per_coupon int( 5 ) NOT NULL default '1', uses_per_user int( 5 ) NOT NULL default '0', restrict_to_products varchar( 255 ) default NULL , restrict_to_categories varchar( 255 ) default NULL , restrict_to_customers text, coupon_active char( 1 ) NOT NULL default 'Y', date_created datetime NOT NULL default '0000-00-00 00:00:00', date_modified datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( coupon_id ) ) TYPE = MYISAM;# MySQL returned an empty result set (i.e. zero rows). # # Table structure for table `coupons_description` # CREATE TABLE coupons_description( coupon_id int( 11 ) NOT NULL default '0', language_id int( 11 ) NOT NULL default '0', coupon_name varchar( 32 ) NOT NULL default '', coupon_description text, KEY coupon_id( coupon_id ) ) TYPE = MYISAM;# MySQL returned an empty result set (i.e. zero rows). INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function ) VALUES ( 'Welcome Gift Voucher Amount', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Welcome Gift Voucher Amount: If you do not wish to send a Gift Voucher in your create account email put 0 for no amount else if you do place the amount here i.e. 10.00 or 50.00 no currency signs', 1, 31, NULL , '2003-12-05 05:01:41', NULL , NULL );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function ) VALUES ( 'Welcome Discount Coupon Code', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'Welcome Discount Coupon Code: if you do not want to send a coupon in your create account email leave blank else place the coupon code you wish to use', 1, 32, NULL , '2003-12-05 05:01:41', NULL , NULL );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Display Total', 'MODULE_ORDER_TOTAL_COUPON_STATUS', 'true', 'Do you want to display the Discount Coupon value?', '6', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added ) VALUES ( 'Sort Order', 'MODULE_ORDER_TOTAL_COUPON_SORT_ORDER', '9', 'Sort order of display.', '6', '2', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Include Shipping', 'MODULE_ORDER_TOTAL_COUPON_INC_SHIPPING', 'true', 'Include Shipping in calculation', '6', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Include Tax', 'MODULE_ORDER_TOTAL_COUPON_INC_TAX', 'true', 'Include Tax in calculation.', '6', '6', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Re-calculate Tax', 'MODULE_ORDER_TOTAL_COUPON_CALC_TAX', 'None', 'Re-Calculate Tax', '6', '7', 'tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) VALUES ( 'Tax Class', 'MODULE_ORDER_TOTAL_COUPON_TAX_CLASS', '0', 'Use the following tax class when treating Discount Coupon as Credit Note.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Display Total', 'MODULE_ORDER_TOTAL_GV_STATUS', 'true', 'Do you want to display the Gift Voucher value?', '6', '1', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added ) VALUES ( 'Sort Order', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', '740', 'Sort order of display.', '6', '2', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Queue Purchases', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'true', 'Do you want to queue purchases of the Gift Voucher?', '6', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Include Shipping', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'true', 'Include Shipping in calculation', '6', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Include Tax', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'true', 'Include Tax in calculation.', '6', '6', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Re-calculate Tax', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'None', 'Re-Calculate Tax', '6', '7', 'tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'), ', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added ) VALUES ( 'Tax Class', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', '0', 'Use the following tax class when treating Gift Voucher as Credit Note.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now( ) );# Affected rows: 1 INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added ) VALUES ( 'Credit including Tax', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Add tax to purchased Gift Voucher when crediting to Account', '6', '8', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) );# Affected rows: 1
  8. bored

    [CONTRIBUTION] CCGV (trad)

    cool mod, but im having 2 main problems right now. in admin, when I choose the Vouchers/Discounts, i get an error 404. The link though does not look right as it shows: mysite.com/shop/admin/FILENAME_COUPON_ADMIN?status=N When I type in the url manually as: mysite.com/shop/admin/coupon_admin.php, i get an error of: Discount Coupons 1146 - Table 'mediade_shop.TABLE_COUPONS' doesn't exist select count(*) as total from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G' [TEP STOP] Weird thing is, I installed the included sql file into my db using the phpmyadmin console. the sql I installed came with the app: # phpMyAdmin MySQL-Dump # Database : `ccgv_trad` # # Table structure for table `coupon_email_track` # CREATE TABLE coupon_email_track ( unique_id int(11) NOT NULL auto_increment, coupon_id int(11) NOT NULL default '0', customer_id_sent int(11) NOT NULL default '0', sent_firstname varchar(32) default NULL, sent_lastname varchar(32) default NULL, emailed_to varchar(32) default NULL, date_sent datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (unique_id) ) TYPE=MyISAM; # # Table structure for table `coupon_gv_customer` # CREATE TABLE coupon_gv_customer ( customer_id int(5) NOT NULL default '0', amount decimal(8,4) NOT NULL default '0.0000', PRIMARY KEY (customer_id), KEY customer_id (customer_id) ) TYPE=MyISAM; # # Table structure for table `coupon_gv_queue` # CREATE TABLE coupon_gv_queue ( unique_id int(5) NOT NULL auto_increment, customer_id int(5) NOT NULL default '0', order_id int(5) NOT NULL default '0', amount decimal(8,4) NOT NULL default '0.0000', date_created datetime NOT NULL default '0000-00-00 00:00:00', ipaddr varchar(32) NOT NULL default '', release_flag char(1) NOT NULL default 'N', PRIMARY KEY (unique_id), KEY uid (unique_id,customer_id,order_id) ) TYPE=MyISAM; # # Table structure for table `coupon_redeem_track` # CREATE TABLE coupon_redeem_track ( unique_id int(11) NOT NULL auto_increment, coupon_id int(11) NOT NULL default '0', customer_id int(11) NOT NULL default '0', redeem_date datetime NOT NULL default '0000-00-00 00:00:00', redeem_ip varchar(32) NOT NULL default '', order_id int(11) NOT NULL default '0', PRIMARY KEY (unique_id) ) TYPE=MyISAM; # # Table structure for table `coupons` # CREATE TABLE coupons ( coupon_id int(11) NOT NULL auto_increment, coupon_type char(1) NOT NULL default 'F', coupon_code varchar(32) NOT NULL default '', coupon_amount decimal(8,4) NOT NULL default '0.0000', coupon_minimum_order decimal(8,4) NOT NULL default '0.0000', coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00', coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00', uses_per_coupon int(5) NOT NULL default '1', uses_per_user int(5) NOT NULL default '0', restrict_to_products varchar(255) default NULL, restrict_to_categories varchar(255) default NULL, restrict_to_customers text, coupon_active char(1) NOT NULL default 'Y', date_created datetime NOT NULL default '0000-00-00 00:00:00', date_modified datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (coupon_id) ) TYPE=MyISAM; # # Table structure for table `coupons_description` # CREATE TABLE coupons_description ( coupon_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', coupon_name varchar(32) NOT NULL default '', coupon_description text, KEY coupon_id (coupon_id) ) TYPE=MyISAM; INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Welcome Gift Voucher Amount', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Welcome Gift Voucher Amount: If you do not wish to send a Gift Voucher in your create account email put 0 for no amount else if you do place the amount here i.e. 10.00 or 50.00 no currency signs', 1, 31, NULL, '2003-12-05 05:01:41', NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Welcome Discount Coupon Code', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'Welcome Discount Coupon Code: if you do not want to send a coupon in your create account email leave blank else place the coupon code you wish to use', 1, 32, NULL, '2003-12-05 05:01:41', NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Display Total', 'MODULE_ORDER_TOTAL_COUPON_STATUS', 'true', 'Do you want to display the Discount Coupon value?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_ORDER_TOTAL_COUPON_SORT_ORDER', '9', 'Sort order of display.', '6', '2', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Shipping', 'MODULE_ORDER_TOTAL_COUPON_INC_SHIPPING', 'true', 'Include Shipping in calculation', '6', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Tax', 'MODULE_ORDER_TOTAL_COUPON_INC_TAX', 'true', 'Include Tax in calculation.', '6', '6','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Re-calculate Tax', 'MODULE_ORDER_TOTAL_COUPON_CALC_TAX', 'None', 'Re-Calculate Tax', '6', '7','tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_ORDER_TOTAL_COUPON_TAX_CLASS', '0', 'Use the following tax class when treating Discount Coupon as Credit Note.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Display Total', 'MODULE_ORDER_TOTAL_GV_STATUS', 'true', 'Do you want to display the Gift Voucher value?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', '740', 'Sort order of display.', '6', '2', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Queue Purchases', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'true', 'Do you want to queue purchases of the Gift Voucher?', '6', '3','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Shipping', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'true', 'Include Shipping in calculation', '6', '5', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Include Tax', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'true', 'Include Tax in calculation.', '6', '6','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Re-calculate Tax', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'None', 'Re-Calculate Tax', '6', '7','tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'), ', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', '0', 'Use the following tax class when treating Gift Voucher as Credit Note.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function ,date_added) values ('Credit including Tax', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Add tax to purchased Gift Voucher when crediting to Account', '6', '8','tep_cfg_select_option(array(\'true\', \'false\'), ', now()); If anyone can help, I would really appreciate it!
×