Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mujina

Pioneers
  • Posts

    172
  • Joined

  • Last visited

Everything posted by mujina

  1. Hi again, Is there a way to generate a seod url from the admin. I installed a product notification in categories.php The email is sent to the customer with the basic url : product_info.php?products_id=298, I would like the mail to be sent with the rewrited url : my-product-p-298.html I tried to create the function tep_href_link_seod in categories.php : ##################################### require_once('../includes/configure.php'); require_once('../includes/filenames.php'); require_once('../includes/database_tables.php'); //// // Ultimate SEO URLs v2.1 // The HTML href link wrapper function /** * ULTIMATE Seo Urls 5 PRO by FWR Media * Replacement for osCommerce href link wrapper function */ include_once('../'.DIR_WS_MODULES.'ultimate_seo_urls5/main/usu5.php'); function tep_href_link_seod( $page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true ) { return Usu_Main::i()->hrefLink( $page, $parameters, $connection, $add_session_id, $search_engine_safe ); } ########################################### I thought it would work, the path is right but the page displays the following error : Warning: require_once(includes/modules/ultimate_seo_urls5/includes/usu_general_functions.php) [function.require-once]: failed to open stream: No such file or directory in /xxx/includes/modules/ultimate_seo_urls5/main/usu5.php on line 22 Maybe it is possible to create and add such a function in admin/includes/functions/htmloutput.php file so that we be able to call this function wherever we want to from the admin? Thank you in advance.
  2. It works! thank you very much for your help and for your precious work on this contribution.
  3. Is there a way to have url with underscores (www.estore.com/my_product-p-57.html) redirected to www.estore.com/my-product-p-57.html My old urls have underscores (_) and I didn't find out how to fix that. So if a visitor comes from one of the old urls, there is a 404 not found page. Thank you for your help.
  4. not sure I posted on the right forum... Hello, I upgraded from Chemos Ultimate Seo Urls version 2 (from which I made a slight modification as I replaced '-' by '_' in the urls). My old products url read : product_number_one-p-125.html Now, with Seo Urls Pro, I have an issue because of the underscore in the url. product_number_one-p-125.html won't redirect to product-number-one/manufacturer/model-p-125.html Is there a way not to loose our referencing and so to have the redirection works? Sorry for my bad English. Thank you.
  5. Hello, I upgraded from Chemos Ultimate Seo Urls version 2 (from which I made a slight modification as I replaced '-' by '_' in the urls). My old products url read : product_number_one-p-125.html Now, with Seo Urls Pro, I have an issue because of the underscore in the url. product_number_one-p-125.html won't redirect to product-number-one/manufacturer/model-p-125.html Is there a way not to loose our referencing and so to have the redirection works? Sorry for my bad English. Thank you.
  6. Hi ! We need our visitors to be able to insert new events. I've tried to modify the admin file but the preview (and thus"insert") doesn't work. Can anyone help with the following code ?
  7. HI! I've just installed this great contrib and it works fine!!! I've tried to create a file ticket_create.php in the admin section because I would like to use the ticket system to send mail to our customers. It is very usefull as the customer will be able to reply to it without having to send us emails. Moreover it stores mails into database. Could anyone bring me some help. I've tried to modify both files (ticket_create.php from catalogue section & ticket_reply.php from admin section) but I've failed! Thanks in advance for your help.
  8. Hi Mark! I've just discovered your contribution and it's great work!!! Is there a way to have it merged with another contribution called Visitors web stats ? Now I use both and I fear it slowdowns the page loading (3 tables : visitors_trace, visitors and now supertracker thus too many queries)?! The file admin/visitors.php offers the ability to sort information, has a Search Engine Ranking + identify bots. Regards!! and thanks for this contribution.
  9. HI Jan! Thanks a lot. It is a really efficient tool and I'm happy to hear you'll work on it as I know you'll succeed in having it work with SPPC. I was a bit lost in the code >_< . Well, ready to test anything. Kind regards!
  10. Hi Jan, I found a contribution called ADMIN SPECIALS BY CATEGORIES, Carine Bruyndoncx did a great job on it!!!!! Easy to install and it works. I was wondering if you could have a look at the code as it would be great to replace the specials.file with this one in SPPC contribution. Actually, it's quite laborious for people who have more than 2 groups to edit specials on specials.php file even if it has been improved. Would you mind to have a look at it? <!----------------------- Actual code for Specials Admin starts here -------------------------> <?php //Fetch all variables $fullprice = (isset($_GET['fullprice']) ? $_GET['fullprice'] : ''); $productid = (isset($_GET['productid']) ? (int)$_GET['productid'] : '0'); $inputupdate = (isset($_GET['inputupdate']) ? $_GET['inputupdate'] : ''); $categories = (isset($_GET['categories']) ? (int)$_GET['categories'] : '0'); if (array_key_exists('discount',$_GET)) { if (is_numeric($_GET['discount'])) { $discount = (float)$_GET['discount']; } else { $discount = -1; } } else { $discount = -1; } if ($fullprice == 'yes') tep_db_query("DELETE FROM " . TABLE_SPECIALS . " WHERE products_id=$productid;"); else if($inputupdate == "yes"){ $inputspecialprice = (isset($_GET['inputspecialprice']) ? $_GET['inputspecialprice'] : ''); if (substr($inputspecialprice, -1) == '%') { $productprice = (isset($_GET['productprice']) ? (float)$_GET['productprice'] : ''); $specialprice = ($productprice - (($inputspecialprice / 100) * $productprice)); } else if (substr($inputspecialprice, -1) == 'i') { $taxrate = (isset($_GET['taxrate']) ? (float)$_GET['taxrate'] : '1'); $productprice = (isset($_GET['productprice']) ? (float)$_GET['productprice'] : ''); $specialprice = ($inputspecialprice /(($taxrate/100)+1)); } else { $specialprice = $inputspecialprice; } $alreadyspecial = tep_db_query ("SELECT * FROM " . TABLE_SPECIALS . " WHERE products_id=$productid"); $specialproduct= tep_db_fetch_array($alreadyspecial); if ($specialproduct["specials_id"]){ //print ("Database updated. Status:".$specialproduct["status"]); tep_db_query ("UPDATE " . TABLE_SPECIALS . " SET specials_new_products_price='$specialprice' where products_id=$productid "); } else{ //print("New product added to specials table"); $today = date("Y-m-d H:i:s"); tep_db_query ("INSERT INTO " . TABLE_SPECIALS . " VALUES ('','$productid','$specialprice','$today','','','','1')"); } } ?> <form action="<?php echo $current_page; ?>" method="get"> <table><tr class="dataTableHeadingRow"><td class="dataTableHeadingContent" colspan="6"> <?php echo TEXT_SELECT_CAT .' ' . tep_draw_pull_down_menu('categories', tep_get_category_tree(), $categories); echo TEXT_ENTER_DISCOUNT . ': '; ?> <input type="text" size="4" name="discount" value="<?php if ($discount > 0) { echo $discount; } echo '">' . TEXT_PCT_AND . ' '; ?> <input type="submit" value="<?php echo TEXT_BUTTON_SUBMIT; ?>"> </form></td></tr> <tr class="dataTableContent"><td class="dataTableContent" colspan="6"> <ul><li><?php echo TEXT_INSTRUCT_1; ?></li> <li><?php echo TEXT_INSTRUCT_2; ?></li> </ul> </td></tr> <? if ($discount == -1) { //echo 'do nothing'; } else if ($discount == 0) { $result2 = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc where p.products_id=ptc.products_id and ptc.categories_id=$categories"); while ( $row = tep_db_fetch_array($result2) ){ $allrows[] = $row["products_id"]; } tep_db_query("DELETE FROM " . TABLE_SPECIALS . " WHERE products_id in ('".implode("','",$allrows)."')"); } else if ($discount > 0) { $specialprice = $discount / 100; $result2 = tep_db_query("select p.products_id, p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc where p.products_id=ptc.products_id and ptc.categories_id=$categories"); while ( $row = tep_db_fetch_array($result2) ){ $hello2 = $row["products_price"]; $hello3 = $hello2 * $specialprice; $hello4 = $hello2 - $hello3; $number = $row["products_id"]; $result3 = tep_db_query("select * from " . TABLE_SPECIALS . " where products_id = $number"); $num_rows = tep_db_num_rows($result3); if ($num_rows == 0){ //echo "Insert into specials (products_id, specials_new_products_price) values ($number, '$hello4')"; tep_db_query("Insert into " . TABLE_SPECIALS . " (products_id, specials_new_products_price) values ($number, '$hello4')"); } else { //echo "Update specials set specials_new_products_price='$hello4' where products_id=$number"; tep_db_query ("Update " . TABLE_SPECIALS . " set specials_new_products_price='$hello4' where products_id=$number"); } } } print (" <tr class=\"dataTableHeadingRow\"> <td class=\"dataTableHeadingContent\">". TABLE_HEADING_PRODUCTS ."</td> <td class=\"dataTableHeadingContent\">" . TABLE_HEADING_PRODUCTS_PRICE ."</td> <td class=\"dataTableHeadingContent\">" . TABLE_HEADING_SPECIAL_PRICE ."</td> <td class=\"dataTableHeadingContent\">" . TABLE_HEADING_PCT_OFF ."</td> <td class=\"dataTableHeadingContent\">" . TABLE_HEADING_FULL_PRICE . "</td> </tr>"); $result2 = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc, " . TABLE_PRODUCTS . " p where pd.products_id=ptc.products_id and p.products_id=ptc.products_id and ptc.categories_id = $categories and pd.language_id = " .(int)$languages_id . " order by pd.products_name asc "); while ( $row = tep_db_fetch_array($result2) ) { $number = $row["products_id"]; $result3 = tep_db_query("SELECT * FROM " . TABLE_SPECIALS . " where products_id=$number"); $num_rows = tep_db_num_rows($result3); if ($num_rows == 0) { $specialprice = "none"; $implieddiscount = ''; } else { while ( $row2 = tep_db_fetch_array($result3) ) { $specialprice = $row2["specials_new_products_price"]; if ($row["products_price"] > 0) { $implieddiscount = '-'.(int)(100-(($specialprice / $row["products_price"])*100)).'%'; } else { $implieddiscount = ''; } } } $tax_rate = tep_get_tax_rate($row['products_tax_class_id']); print("<form action=\"$current_page\" method=\"get\">"); print(" <tr class=\"dataTableRow\" onmouseover=\"rowOverEffect(this)\" onmouseout=\"rowOutEffect(this)\" > <td class=\"dataTableContent\">" . $row["products_name"] . "</td> <td class=\"dataTableContent\">" . $row["products_price"] . "</td> <td class=\"dataTableContent\"><input name=\"inputspecialprice\" type=\"text\" value=\"$specialprice\"></td> <td class=\"dataTableContent\">$implieddiscount </td> <td class=\"dataTableContent\"><input type=\"checkbox\" name=\"fullprice\" value=\"yes\"></td> <td class=\"dataTableContent\"><input type=\"hidden\" name=\"categories\" value=\"" . $categories ."\"> <input type=\"hidden\" name=\"productprice\" value=\"" . $row["products_price"] . "\"> <input type=\"hidden\" name=\"taxrate\" value=\"" . $tax_rate . "\"> <input type=\"hidden\" name=\"productid\" value=\"" . $row["products_id"] . "\"> <input type=\"hidden\" name=\"inputupdate\" value=\"yes\"> <input type=\"submit\" value=\"" . TEXT_BUTTON_UPDATE . "\"></td></tr></form>"); } print ("</table>"); ?> <!------------------------ Code for Specials Admin ends here ---------------------------> Thanks again and again and again!!!! ;)
  11. Hi! Don't know where my post was misleading... Feel sorry! I've just posted my piece of code to share it with people that would meet the same pb as me as I know CCGV is the 1st contribution downloaded. Regards.
  12. Hi Jan, It seems that on advanced_search_result.php page there's a little bug when you try to list by price. I did not really modify this file, so I was wondering if you meet the same pb? Thanks in advance!!!!
  13. Actually, without this modification a customer can complete the order even if he hasn't choosed a payment method. It is a pb that I encountered... not sure it is the same for people out there.
  14. Great job, great contribution!!!! Thanks a lot!!! I have a store with more than 170 contributions installed now and it works fine. I wanted to let you know that as I use CCGV I've made a mere modification in checkout_confirmation.php. Here's my piece of code : ///##### Points/Rewards Module v1.00 check for errors BOF ####### //force customers to select other payment method if the points total not enough to cover the cost. //ICW includes for CREDIT CLASS //if ( ( is_array($payment_modules->modules) && (sizeof($payment_modules->modules) > 1) && !is_object($$payment) ) || (is_object($$payment) && ($$payment->enabled == false)) ) { if ( (is_array($payment_modules->modules)) && (sizeof($payment_modules->modules) > 1) && (!is_object($$payment)) && (!$credit_covers) && ($customer_shopping_points_spending * REDEEM_POINT_VALUE < $order->info['total'] ) || (is_object($$payment) && ($$payment->enabled == false)) ) { // if ( (is_array($payment_modules->modules)) && (sizeof($payment_modules->modules) > 1) && (!is_object($$payment)) && (!$credit_covers) && ($order->info['total'] > $customer_shopping_points_spending )) { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_PAYMENT_MODULE_SELECTED), 'SSL')); } // customer can't use points over the order total if ($customer_shopping_points_spending * REDEEM_POINT_VALUE > $order->info['total']) { $customer_shopping_points_spending = 0; tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(REDEEM_SYSTEM_ERROR_POINTS_OVER), 'SSL')); } ///######## Points/Rewards Module v1.00 EOF ################# I'm really gratefull for the help you bring to us! Best regards!!!!! ;)
  15. Very kind of you!! :rolleyes: The customer has to spend 100 points no more no less.
  16. Big thanks for Chemo and for his hard work!!!! Another usefull contribution!!!!! I had no problem to install Google XML Sitemap Feed but I was wondering if putting a chmod 777 on XML files won't be dangerous for the server (security pbs??). How to have this contribution run even if we put a chmod=775 or 755 on XML files?
  17. Thanks for your reply. Actually the point/reward module meet my needs. But I would like to limit points to exactly 100 points before redemptions. The customers could only redeem when he reaches 100 points & only for 100 points. Thus, if the customer has earned 105 points, he can only redeem 100 points. Then he'll have to wait for 95 points more to redeem again his points. With the contribution, the limit before redemption only works if the amount of points < the POINT_LIMIT_VALUE. Is it a little bit clearer?? Could you help me on this ...if you're not too overflowed. PS : I've already remove the points value from my_points page.
  18. We share the same point of vue ;) Give me your feedback on this : I want customers to see (realize) rewards points as points and not as money. It's a way to put forward the shop and its products and not the amount of money. As a consequence, I would like customers to be able to use their points when they reach 100 points. Thus, each time they reach 100 points, they can use them to pay their order. 100 points have a fixed value that can be memorized by the customers. This is of course a sales incentive but I don't think it could be misleading. Most of shop owners in France act this way. Tell me what you think about this. Hope my english is not too bad to have me understood. :blush:
  19. Hi everybody! I've installed the contribution yesterday and IT WORKS!!!! I have it run with CCGV contribution!! It's a great and very usefull contribution!!!! BIG THANKS PS : I don't think we should exclude products with specials... points reward system is a way to reward customers according to the amount they spent in our stores... :huh:
  20. Deep Silver, I did appreciate the precious help you brought to me even if my pb wasn't really related to the points and rewards module. It's really nice to meet people like you in this community who offer good support for free. Big thanks!!!!
  21. HI, When you have this kind of error you just have to remove from add_ccgvdc_application_top.php the function called in the error message. In your example, search for the "create_coupon_code" function in add_ccgvdc_application_top.php as this function already exists in general.php. Hope it helps...
  22. Maddie, Here's a translation... sorry my english is not fluent... Offrir un ch?que cadeau (Send/offer a gift voucher) Offrir un ch?que cadeau (Send/offer a gift voucher) Veuillez indiquer le montant du ch?que cadeau que vous voulez offrir ? un nouveau client. (Please, put the amount of the Gift Voucher you want to send/offer to a new customer) Mettre 0 si vous ne voulez pas offrir de ch?que cadeau (Put 0 if you don't want to send/offer gift vouchers) Offrir un coupon de r?duction (Send/offer a discount coupon) Pour offrir un coupon de r?duction a un nouveau client veuillez entrer le code du coupon de r?duction. (To send/offer a discount coupon to a new customer please enter the coupon code) Laisser vide si vous ne voulez pas offrir de coupon de r?duction (Leave empty if you don't want to send/offer discount coupons.
  23. I've installed the very new version of this contribution and so far it seems to work. I'm gonna test it another times... Jennifer, thanks a lot for your work! ;)
  24. THanks for your reply Bobby! Well I'm gonna try another time to install the redirect script but I'm not confident at all! Regards!
  25. Bobby, Chris, could you advice me? Is this modification possible or should I give it up. I'm not skilled in php but I'm trying to have it worked. Thanks!
×
×
  • Create New...