Jump to content

mujina

Members
  • Content count

    172
  • Joined

  • Last visited

  1. mujina

    ULTIMATE Seo Urls 5 - by FWR Media

    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. mujina

    ULTIMATE Seo Urls 5 - by FWR Media

    It works! thank you very much for your help and for your precious work on this contribution.
  3. mujina

    ULTIMATE Seo Urls 5 - by FWR Media

    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. mujina

    ULTIMATE Seo Urls 5 - by FWR Media

    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. mujina

    Ultimate Seo Urls 5 Pro

    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. mujina

    Event Calender

    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. mujina

    Seperate Pricing Per Customer v3.5

    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. mujina

    Seperate Pricing Per Customer v3.5

    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. mujina

    ### POINTS AND REWARDS MODULE V1.00 ###

    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. mujina

    Seperate Pricing Per Customer v3.5

    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. mujina

    ### POINTS AND REWARDS MODULE V1.00 ###

    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. mujina

    ### POINTS AND REWARDS MODULE V1.00 ###

    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. mujina

    ### POINTS AND REWARDS MODULE V1.00 ###

    Very kind of you!! :rolleyes: The customer has to spend 100 points no more no less.
×