Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Chronoz

Archived
  • Posts

    107
  • Joined

  • Last visited

Everything posted by Chronoz

  1. I understand, but if you really read my posts you could see that my real problem was with the rows not with SQL, because I didnt get any errors anywhere so it wasnt as important. It's funny how easy it is to notice when someone is talking with there gut. Oh I will enjoy my new add-on ;) Thanks! Steven
  2. It's fine I found another add-on! Nope, no more unanswered questions! thanks for your time! Noticed! Thanks for your time Steven
  3. Bump I've searched and still noone has ever asked this question! How unlucky! Steven
  4. No one has the answer? I've looked everywhere! =..(
  5. Hello again, I dont have any errors, but I still cant figure out that above part. And I started to browse the first few pages to see if I can find an answer to this following question: How can I make a row of 3 items because I only want to feature 6 items in 2 rows of 3 and 3. If I set a 6 item only in the admin I get a row of 4 then 2. I saw someone in the begining asking my question but the other way around! haha! How to add 4 products in one row, and I also saw a person asking how can he make 1 product in 1 row and for it to go downwards, etc. Any help is much appreciated! Thanks! :D
  6. I was browsing some new parts of this forum and I found it! Perfect! Thanks for the help!
  7. Ok, so I finished installing everything, no error messages anywhere, just that when I try to add something to Featured items they do not appear, I guess it's because of the above post I made.
  8. Hello! I'm looking threw this forum and I cant find that someone has asked a question about this I'm doing the SQL part and it says to Ive done SQLs before but what do I put in each field? Like in: Field: idx_products_id Type: what do I put here? Length/Values: if necesary etc... I'm sorry to ask such a question but I'm just missing it, and if I just put in idx_products_id and leave everything as default it gives me a popup message saying that "this is not a number" because I have VARCHAR selected in Type Thanks for your help! Steven
  9. Ok, I have question on how to use this add-on: I have a policy where if they have 120 points then can redeem 6$ and if they have 400 points they can redeem 20$ but how can I set it up where as if they had 400 points and they only wanted to spend 120 points? Also how can I only make them choose between 120 and 400? Is that even posible with this add on? thanks Steven
  10. I got it! When i check out, it appears the option now, what it was was the following: The Auto expire points and reminder HAVE to be in blank if you dont want to use them, I had them set to 0 duh!
  11. Ok I found a flaw, I thought I had it down, but it was too good to be true, heres a SS Even though under Configuration/Points/RewardsV2.00 in my admin panel I have the Enable customers to Redeem points at checkout? selected at True it still doesnt appear when I check out an item, any help?
  12. Ok, I just did it in www.mysite.com... works fine, but it was the very first thing i did! Made a new database Uploaded the Oscommerce RC2 Installed it Went straight to my phpadmin and follwed the SQL steps Then I went to the ADMIN part and made sure that under Modules I had the +install button was there! This is how I did it when I made it under www.mysite.com/catalog And when I had trouble it was when I had other add ons installed already
  13. Yeap thats the one im talking about Ill download the +french cuz Im using another one Thanks for the tips! But you did mention: What do you mean by that? Thanks! Appreciate your help! :D
  14. You cant used the modifed files. I tried replacing the files that I have now, I cant access my admin page. I remade a database and before I installed the oscommerce RC2 I replaced the files then installed, I cant acccess admin nor catalog, I get error messages No good
  15. Would it have to do with me making my website under: www.mysite.com instead of www.mysite.com/catalog? When I did it with www.mysite.com/catalog I was able to at least see the +install button under my Admin page And now that I make it www.mysite.com everything is fine besides the fact that I cant even see the +install button. I doubt but just to throw an idea that popped up
  16. What I'm goin to do is start a fresh website and add everything that is in the folder called modified files and then add the other files See how that goes!
  17. Yea, I've done a template for the site, Meta Tags, and Thumb images. I'm going to double check the catalog part, but I know for sure the admin part is perfect because I doubled checked that already. If you want David I can give you my info and you can hop on and check it out aswell, if you want to, if not no worries. I'll PM you the info. Let me know! :D Thanks for all your help! Steven
  18. When I tried to uninstall everything and my whole website got messed up and the database went to the garbage, so I redid everything and now my only problem is that under Modules/Order Total the Redemption Points is not even there as before I couldnt install it and now its not there. <_< I checked everything, I might be missing something but I have no idea what it is! Any ideas David?
  19. Ok, cool! Will do! I'll let you know! Thanks David!
  20. Bump, tried again today and I still cant install it, thats weird. I thought that problem could be that I was xfered to a SSL server but I was able to install it the first time I did it, then I removed everything and did it again and in the mean time I was xfering pages to the SSL server (includes/configure.php) but I dont think that has to do with anything. Any ideas what this could be?
  21. *sigh* <_< Im having a problem now In the my admin panel under Modules/Order Total Modules I cant install the Points Redeemptions, I click on the install and the page refreshes and it stays with the "+ install" icon and I check my shopping cart and it doesnt appear. I redid this step only thinking that this has to do with that part, I might be wrong. Any ideas? Thanks in advanced! ADMIN STEP = 1. open admin/orders.php This will add a quick pending points conformation check box. To be used when confirming order or updating order status. This option will only show up when there are pending points for that order and only if Auto Credit Pending Points is set to "false". **note that this step has 2 parts** Find... (start at aprox. line 54 to 55) $customer_notified = '1'; } ... and add after..... ######## Points/Rewards Module V2.00 BOF ################## if ((isset($HTTP_POST_VARS['confirm_points']) && ($HTTP_POST_VARS['confirm_points'] == 'on'))||(isset($HTTP_POST_VARS['delete_points']) && ($HTTP_POST_VARS['delete_points'] == 'on'))) { $comments = ENTRY_CONFIRMED_POINTS . $comments; $customer_query = tep_db_query("SELECT customer_id, points_pending from " . TABLE_CUSTOMERS_POINTS_PENDING . " WHERE points_status = 1 AND points_type = 'SP' AND orders_id = '" . $oID . "'"); $customer_points = tep_db_fetch_array($customer_query); if (tep_db_num_rows($customer_query)) { if (tep_not_null(POINTS_AUTO_EXPIRES)){ $expire = date('Y-m-d', strtotime('+ '. POINTS_AUTO_EXPIRES .' month')); tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_shopping_points = customers_shopping_points + '". $customer_points['points_pending'] ."', customers_points_expires = '". $expire ."' WHERE customers_id = '". (int)$customer_points['customer_id'] ."'"); } else { tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_shopping_points = customers_shopping_points + '". $customer_points['points_pending'] ."' WHERE customers_id = '". (int)$customer_points['customer_id'] ."'"); } if (isset($HTTP_POST_VARS['delete_points']) && ($HTTP_POST_VARS['delete_points'] == 'on')) { tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_POINTS_PENDING . " WHERE orders_id = '" . $oID . "' AND points_type = 'SP' LIMIT 1"); } if (isset($HTTP_POST_VARS['confirm_points']) && ($HTTP_POST_VARS['confirm_points'] == 'on')) { tep_db_query("UPDATE " . TABLE_CUSTOMERS_POINTS_PENDING . " SET points_status = 2 WHERE orders_id = '" . $oID . "' AND points_type = 'SP' LIMIT 1"); } } } ######## Points/Rewards Module V2.00 EOF ################## still at the same file . Find... (aprox. line 340) <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td> ... and add after..... <!-- // Points/Rewards Module V2.00 check_box_bof //--> <?php $p_status_query = tep_db_query("SELECT points_status FROM " . TABLE_CUSTOMERS_POINTS_PENDING . " WHERE points_status = 1 AND points_type = 'SP' AND orders_id = '" . $oID . "'"); if (tep_db_num_rows($p_status_query)) { echo '<tr><td class="main"><b>' . ENTRY_NOTIFY_POINTS . '</b> ' . ENTRY_QUE_POINTS . tep_draw_checkbox_field('confirm_points', '', false) . ' ' . ENTRY_QUE_DEL_POINTS . tep_draw_checkbox_field('delete_points', '', false) . ' </td></tr>'; } ?> <!-- // Points/Rewards Module V2.00 check_box_eof //-->
  22. Forget it! I did it! WOW! I cant believe it! Amazing and I'm new at this stuff! WOW!! Thanks for the help David! Appreciate it! =D
  23. Thanks David for the response! Ok, I tried to follow the steps for the SQL, its my first time and I dont have any training so I think I did it right, I browsed the Rows that were there just to get an idea and seems like everything is well. Looks good. But I only have one question how do I do this step: Thats the only part I havent been able to figure out <_< Thanks in advanced! Steve
  24. The file I downloaded was ## POINTS AND REWARDS MODULE V2.0d ## CORRECTED Phosky 19 Jul 2006
×
×
  • Create New...