Jump to content

leisuret

Members
  • Content count

    95
  • Joined

  • Last visited

1 Follower

About leisuret

  • Birthday 09/03/1981

Profile Information

  1. leisuret

    Counter Reset V1.0

    osCommerce Counter Reset v1.0 Re-work By osWebDesigns http://www.osWebDesigns.com Contributing Author: Ben Allen Email: ben.allen@btinternet.com Site: http://www.ballen.bytehost.com Based On Original Contribution By osCommerce Counter reset Author: Richard Nero Email: richard@rlnero.com Site: http://www.rlnero.com This is the support forum topic for the Counter Reset V1.0 contribution. Please post any questions/comments about the contribution here. This version integrates the previous scripting into your store's administration panel under the Tools infobox. It also formats the file to be presented as a page similar to all other admin pages. You also have the option to specify a start date using the familiar SpiffyCal JavaScript. If you leave the date as is, it will reset with a start date of today. There's also a little JavaScript to confirm the reset.
  2. Anyone know what would cause the rewrite to look like this if you're in a category? /catalog/index.php?catalog=index.php It's also not prepending the cId if depth is pId. Any ideas?
  3. I need to know if there's anyone out there who has a functional iTransact module. The one I have in place now redirects back to the login page after iTransact processes the card. The order is not inserted into the database either. The module available on their website does the same thing. Any ideas?
  4. Be sure that the line containing the order number looks like this. <?php echo TEXT_YOUR_ORDER_NUMBER .' ' .$orders['orders_id'];?> Also, in catalog/includes/languages/english/checkout_success.php, make sure you have defined the variable... define(TEXT_YOUR_ORDER_NUMBER, 'Your order number is'); hope this helps
  5. Hello all. I am having a problem with adding images using the viewer for HTML Area. Any link I click in the viewer is dead, and comes back with the following error: "An error has occurred in the script on this page: Line: 35 Char: 4 Error: Access is denied Code: 0 URL: http://MY DOMAIN/catalog/admin/htmlarea/popups/lister.php?DPI=96 Do you want to continue running scripts on this page? Yes/No" The images folder permission is set at 777. Anyone else have this problem? Also, I tried to go to the link provided for the netpbm, but it's dead. Where can I download this?
  6. Hello all. I am having a problem with adding images using the viewer for HTML Area. Any link I click in the viewer is dead, and comes back with the following error: "An error has occurred in the script on this page: Line: 35 Char: 4 Error: Access is denied Code: 0 URL: http://MY DOMAIN/catalog/admin/htmlarea/popups/lister.php?DPI=96 Do you want to continue running scripts on this page? Yes/No" The images folder permission is set at 777. Anyone else have this problem? Also, I tried to go to the link provided for the netpbm, but it's dead. Where can I download this?
  7. Hello again all. I am currently reworking a currently published ontribution that automatically back's up the database when you're working in the admin area. It doesn't use a cron, but rather a timer since last backup. Any time you click a link, or refresh, it evaluates it enough time has passed to backup the database. The length of time is customizable. What I am using it for is the same situation, only for the catalog area. Everything is working beautifully so far. However, I have two questions. 1. Would using this in the catalog area create a security threat? 2. I would like to have the previous backup deleted once the new one is saved. Is there any script capable of doing this? Any suggestions would be greatly appreciated.
  8. Hey all. I was browsing the gv_redeem.php fiel and I noticed a lot of code. It almost seems to me that it's from the readme, but somewhere along the way it was inserted into this file. I searched my files to see if this code was in the files it's talking about, but none of this code seems to be present. This is a lot of stuff here that's already commented out. My question is if this code should be deleted, moved to the right file, or just left where it is. Here's the code... /* GV_REDEEM_EXPLOIT_FIX (GVREF) --------------------------------------------- * case: guest accounts can exploit gift voucher sent using "Mail Gift Voucher" (admin area), * by sharing the code until somebody logs with a valid account * or successfully created new account. * * obv: the session remains on user while served as a guest. * The gift voucher can now be reused to all guest users until * gift voucher is redeemed * soln: before releasing the gift voucher, the user must login first * or asked to create an account. * * * -- Frederick Ricaforte */ /* * connected files: * /catalog/gv_redeem.php * /catalog/login.php * /catalog/create_account.php * /catalog/includes/languages/english/gv_redeem.php * */ /******************************************************* **** gv_redeem.php ************************************ *******************************************************/ //before: $redeem_query = tep_db_query("select coupon_id from ". TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $coupon['coupon_id'] . "'"); //---- // add:GVREF if ((tep_session_is_registered('customer_id')) && $voucher_not_redeemed) { $gv_id = $coupon['coupon_id']; $gv_query = tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $coupon['coupon_id'] . "', '" . $customer_id . "', now(),'" . $REMOTE_ADDR . "')"); $gv_update = tep_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $coupon['coupon_id'] . "'"); tep_gv_account_update($customer_id, $gv_id); $error = false; } elseif($voucher_not_redeemed) { // endof_add:GVREF // replace: GVREF /* if (tep_db_num_rows($redeem_query) == 0 ) { // check for required session variables if (!tep_session_is_registered('gv_id')) { tep_session_register('gv_id'); } $gv_id = $coupon['coupon_id']; $error = false; } else { $error = true; } */ // with: GVREF if (!tep_session_is_registered('floating_gv_code')) { tep_session_register('floating_gv_code'); //} $floating_gv_code = $HTTP_GET_VARS['gv_no']; $gv_error_message = TEXT_NEEDS_TO_LOGIN; } else { $gv_error_message = TEXT_INVALID_GV; } } else { $gv_error_message = TEXT_INVALID_GV; } // endof_replace: GVREF // remove: GVREF /* if ((!$error) && (tep_session_is_registered('customer_id'))) { // Update redeem status $gv_query = tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $coupon['coupon_id'] . "', '" . $customer_id . "', now(),'" . $REMOTE_ADDR . "')"); $gv_update = tep_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $coupon['coupon_id'] . "'"); tep_gv_account_update($customer_id, $gv_id); tep_session_unregister('gv_id'); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_GV_REDEEM); */ // endof_remove: GVREF // replace: GVREF // $message = TEXT_INVALID_GV; // with: $message = $gv_error_message; // endof_replace /******************************************************* **** login.php ****************************************** *******************************************************/ //before: $cart->restore_contents(); //--------- //add these new codes: if (tep_session_is_registered('floating_gv_code')) { $gv_query = tep_db_query("SELECT c.coupon_id, c.coupon_amount, IF(rt.coupon_id>0, 'true', 'false') AS redeemed FROM ". TABLE_COUPONS ." c LEFT JOIN ". TABLE_COUPON_REDEEM_TRACK." rt USING(coupon_id), ". TABLE_COUPON_EMAIL_TRACK ." et WHERE c.coupon_code = '". $floating_gv_code ."' AND c.coupon_id = et.coupon_id"); // check if coupon exist if (tep_db_num_rows($gv_query) >0) { $coupon = tep_db_fetch_array($gv_query); // check if coupon_id exist and coupon not redeemed if($coupon['coupon_id']>0 && $coupon['redeemed'] == 'false') { tep_session_unregister('floating_gv_code'); $gv_query = tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $coupon['coupon_id'] . "', '" . $customer_id . "', now(),'" . $REMOTE_ADDR . "')"); $gv_update = tep_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $coupon['coupon_id'] . "'"); tep_gv_account_update($customer_id, $coupon['coupon_id']); } } } //********** /******************************************************* **** create_account.php *********************************** *******************************************************/ //before: tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); //--------- //add these: if (tep_session_is_registered('floating_gv_code')) { $gv_query = tep_db_query("SELECT c.coupon_id, c.coupon_amount, IF(rt.coupon_id>0, 'true', 'false') AS redeemed FROM ". TABLE_COUPONS ." c LEFT JOIN ". TABLE_COUPON_REDEEM_TRACK." rt USING(coupon_id), ". TABLE_COUPON_EMAIL_TRACK ." et WHERE c.coupon_code = '". $floating_gv_code ."' AND c.coupon_id = et.coupon_id"); // check if coupon exist if (tep_db_num_rows($gv_query) >0) { $coupon = tep_db_fetch_array($gv_query); // check if coupon_id exist and coupon not redeemed if($coupon['coupon_id']>0 && $coupon['redeemed'] == 'false') { tep_session_unregister('floating_gv_code'); $gv_query = tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, customer_id, redeem_date, redeem_ip) values ('" . $coupon['coupon_id'] . "', '" . $customer_id . "', now(),'" . $REMOTE_ADDR . "')"); $gv_update = tep_db_query("update " . TABLE_COUPONS . " set coupon_active = 'N' where coupon_id = '" . $coupon['coupon_id'] . "'"); tep_gv_account_update($customer_id, $coupon['coupon_id']); } } } /******************************************************* **** /includes/languages/english/gv_redeem.php ****************** *******************************************************/ // add: define('TEXT_NEEDS_TO_LOGIN', 'We are sorry but we are unable to process your Gift Voucher claim at this time. You need to login first or create an account with us, if you don\'t already have one, before you can claim your Gift Voucher. Please <a href="' . tep_href_link(FILENAME_LOGIN,'','SSL').'">click here to login or create an account.</a> ');
  9. Hello. I just installed that contribution a couple of days ago. Maybe I can shed some light on the situation for you all. the instructions were difficult to follow. 1. In each file it's referring to, you'll need to add the defines where you would like them. Ex. Add the following line to catalog/includes/languages/'YOUR_LANGUAGE'.php(from the unzipped folder, it is written under the respective files) //all products define ('ALL_PRODUCTS_LINK', 'All products'); 2. For the catalog/includes/filenames.php I had to write my own code, as the unzipped folder contained no filenames.php file. The code I wrote is below. define('FILENAME_ALL_PRODUCTS', 'all_products.php'); 3. The "new pages" are actually all pages you want to display the link. Without the filenames.php alteration, this link would be inoperable. Wherever you want to display the link to the new All Products page, insert the code below. I chose to use it only in the footer, as most people will not use this link. However, it's a good idea to have it somewhere as bots use it to search your page. <?php echo '<a href="' . tep_href_link(FILENAME_ALL_PRODUCTS) . '">' . ALL_PRODUCTS_LINK . '</a>'; ?> I hope this helps. If you have any questions, I have subscribed to this topic.
  10. leisuret

    confirm order button does nothing randomly

    It could be a problem in the form the php is drawing at the top of the body. Check the placements of your php's and make sure that none are overlapping the longform, or the </form> at the bottom. Hope this helps!
  11. leisuret

    PROBLEM with Credit Class & Gift Voucher

    Yeah, some help with what errors you are having would help. If you are using CCGV 5.14, you actually need to use some things from 5.10, and 5.13. Refer to Madie's instructions in the support topic below. CCGV 5.14 Support
  12. I believe you need to separate the echo from the query. Leave the query in the defines at the top, but move the echo to the body. When I am in doubt about where the echo needs to be, I always put it in its own table row. Hope this helps.
  13. Thanks for the suggestions, Maddie! Everything appears to be working, especially after the unistall-reinstall. There's still one problem I'm having in relation to the My Store page in Configuration. Here's what I'm getting at the bottom of the list... I have poured over the code and SQL looking for something that is causing the duplication and the always-annoying French. I haven't seen anyone address this particular issue, but I bet I am not the only one to whom this is happening. If I've missed a piece of code or SQL, or even a previous post that addresses this, let me know. Thanks in advance!
  14. Nevermind. I figured out what it was. However, I do have a problem with the admin->config->my store. It shows some things in english then others in french. Is anyone aware of a fix for this becuase I cannot read french! Thanks
×