Jump to content
Latest News: (loading..)

sheepiedog

Members
  • Content count

    203
  • Joined

  • Last visited

Everything posted by sheepiedog

  1. sheepiedog

    Convert old ms2.2 addon for 2.3.4 admin

    Yes i have easypopulate, and I use it, but this is an even quicker way to update prices within seconds and I really like it and would like to continue using it. The add on didnt need to be updated for ms2.2 as it worked perfectly.
  2. I am working on a 234bs test store to replace my old ms2.2 store. I am trying to convert some old addons that I cant live without and I have been successful for the most part but I have run into an issue I am not sure how to correctly solve it. Running php 5.3 and mysql 5.5 Add on Update Price with search - http://addons.oscommerce.com/info/1204- absolutely love this addon and use it all the time. I know there are other similarish add ons - but this one does by search and is so simple and I would like to stay with this one. When I tried to convert it to 2.3.4 admin and run it - I receive this error : Warning: mysqli_query() expects at least 2 parameters, 1 given in /home/sales/public_html/234bs/admin/price_update.php on line 26 This is line 26 : $sql3 = mysqli_query("SELECT categories_id, categories_name FROM categories_description ORDER BY categories_name"); I changed the original mysql to mysqli - but it looks like I also need to reformat the line into 2 sections and I am not sure how to go about that..... Would someone would be able to tell me how to solve this ?
  3. sheepiedog

    Convert old ms2.2 addon for 2.3.4 admin

    @Mention Thanks - yes, I tried replacing with tep_db and also mysqli in different combinations and it then resulted in errors. The way I have it above, there are no errors being reported, but it doesnt give any results either. I have also tried to change one of the 'post' to 'get', no luck. I obviously dont know enough about the proper coding, but I have been trying to research and learn, thinking it is just a little file, it must be able to be fixed for 2.3.4.
  4. sheepiedog

    Convert old ms2.2 addon for 2.3.4 admin

    Thanks ! I tried different combinations in the file I need to convert, the errors are now gone, but the file doesnt work. Its a standalone file, no changes to core files. It does a search by either product or model code and the resulting screen allows you to change the price for the search items. I am not even getting the resulting screen. The report works great on my old ms2.2 store so I wouldnt think it is a php/mysql issue. Below is the complete file price_update.php - can anyone spot what I need to change to have the report/tool work with 2.3.4 ? <?php /* $Id: aumento_search.php,v 1.29 2003/04/28 15:32:22 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Author: michele gobbi email: michele.gobbi@inwind.it Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_INCLUDES . 'template_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); // category drop down $sql3 = tep_db_query("SELECT categories_id, categories_name FROM categories_description ORDER BY categories_name"); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <style type="text/css"> <!-- th { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: x-small; background-color: #eeeeee} /*table { border: #666666; border-style: dashed; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px}*/ /*td { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: xx-small; padding-top: 3px; padding-bottom: 3px; padding-left: 5px}*/ td.left { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: xx-small; padding-top: 3px; padding-bottom: 3px; padding-left: 5px; text-align: right; padding-right: 16px} --> </style> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo "Quick Price Update" ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td align="left"> <? if ($action == "search") { echo "<form name=\"update\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."?action=update_prices\">"; echo "<table>"; echo "<tr><th>Product ID</th><th>Title</th><th>Price</th></tr><tr>"; $result = mysql_query("SELECT * FROM products, products_description WHERE (products.products_model like '%$search%' OR products_description.products_name like '%$search%') AND products.products_id = products_description.products_id"); if ($row = mysql_fetch_array($result)) { do { $prezzo=round($row['products_price'],2); echo "<td align=\"center\">".$row["products_model"]."</td>\n"; echo "<td>".$row["products_name"]."</td>\n"; echo "<td align=\"center\"><input type=\"text\" name=\"product_new_price[".$row['products_id']."]\" value=\"$prezzo\"></td>\n"; echo "</tr>\n"; } while($row = mysql_fetch_array($result)); } echo "</table>\n"; echo "<br><input type=\"submit\" value=\"Update the prices\">"; echo "</form><br><hr><br>"; } if ($action == "update_prices") { foreach($HTTP_POST_VARS['product_new_price'] as $id => $new_price) { mysql_query("UPDATE products SET products_price=$new_price WHERE products_id=$id"); } $random = date("U"); echo "<p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><b>Prezzi aggiornati!!</b></font></p>"; } ?> <form name="update" method="post" action="<?=$_SERVER["PHP_SELF"]?>?action=search"> <table> <tr> <th colspan="2">Which product do you want to search for?</td> </tr> <tr> <td colspan="2"><br></td> </tr> <tr> <td> Product or Model Number: </td> <td> <input type="text" name="search"> </td> </tr> <tr> <td> </td> <td> <input type="submit" value="Search"> </td> </tr> </table> </form> </td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  5. sheepiedog

    Convert old ms2.2 addon for 2.3.4 admin

    I'm sorry, I dont know what you mean. I am just learning how to convert these. Could you explain exactly what it should be or what information I need to find ?
  6. sheepiedog

    State Selector for BS

    Thank you so much ! I was able to change 2 of the files and they are perfect. I had trouble with checkout_new_address as it seemed to affect the radio buttons for choosing existing addresses - so I just chose to go with your original contribution file for this. I am grateful for your help with this, and hopefully it will help others who would like to do the same as I did.
  7. sheepiedog

    State Selector for BS

    Thanks raiwa I have tried and tried different scenarios. I only use United States and so my customers will not be changing countries. I really need the state selector to prevent misspellings and to make the address forms more user friendly. I am trying to put it in this order: city, state, zip code and then country. When I try to move the country down to the bottom after the zip codes </div></div> , the state is no longer a drop down menu. I am obviously doing something incorrectly - would you be able to point me in the right direction ? <div class="form-group has-feedback"> <label for="inputCity" class="control-label col-sm-3"><?php echo ENTRY_CITY; ?></label> <div class="col-sm-9"> <?php echo tep_draw_input_field('city', (isset($entry['entry_city']) ? $entry['entry_city'] : ''), 'required aria-required="true" id="inputCity" placeholder="' . ENTRY_CITY. '"'); echo FORM_REQUIRED_INPUT; if (tep_not_null(ENTRY_CITY_TEXT)) echo '<span class="help-block">' . ENTRY_CITY_TEXT . '</span>'; ?> </div> </div> <?php if (ACCOUNT_STATE == 'true') { ?> <div class="form-group"> <label for="inputState" class="control-label col-sm-3"><?php echo ENTRY_STATE; ?></label> <div class="col-sm-9"> <?php $zone_id = 0; $check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . $country . "'"); $check = tep_db_fetch_array($check_query); $entry_state_has_zones = ($check['total'] > 0); if ($entry_state_has_zones == true) { $zones_array = array(); $zones_array[0] = array('id' => '0', 'text' => PULL_DOWN_DEFAULT); $zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . $country . "' order by zone_name"); while ($zones_values = tep_db_fetch_array($zones_query)) { $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']); } echo '<span id="results">'; echo tep_draw_pull_down_menu('state', $zones_array, (isset($entry['entry_country_id']) ? tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']) : ''), 'id="inputState"'); echo '</span>'; echo FORM_REQUIRED_INPUT; } else { echo '<span id="results">'; echo tep_draw_input_field('state', NULL, 'id="inputState" placeholder="' . ENTRY_STATE . '"'); echo '</span>'; echo FORM_REQUIRED_INPUT; } if (tep_not_null(ENTRY_STATE_TEXT)) echo '<span class="help-block">' . ENTRY_STATE_TEXT . '</span>'; ?> </div> </div> <div class="form-group has-feedback"> <label for="inputZip" class="control-label col-sm-3"><?php echo ENTRY_POST_CODE; ?></label> <div class="col-sm-9"> <?php echo tep_draw_input_field('postcode', (isset($entry['entry_postcode']) ? $entry['entry_postcode'] : ''), 'required aria-required="true" id="inputZip" placeholder="' . ENTRY_POST_CODE . '"'); echo FORM_REQUIRED_INPUT; if (tep_not_null(ENTRY_POST_CODE_TEXT)) echo '<span class="help-block">' . ENTRY_POST_CODE_TEXT . '</span>'; ?> </div> </div> <div class="form-group has-feedback"> <label for="inputCountry" class="control-label col-sm-3"><?php echo ENTRY_COUNTRY; ?></label> <div class="col-sm-9"> <?php $country = 0; if ( isset($entry['entry_country_id']) ) { $country = $entry['entry_country_id']; } elseif (MODULE_HEADER_TAGS_GET_STATES_DEFAULT_COUNTRY == 'True') { $country = STORE_COUNTRY; } echo tep_get_country_list('country', $country, 'onChange="getState(this.value)" required aria-required="true" id="inputCountry"'); echo FORM_REQUIRED_INPUT; if (tep_not_null(ENTRY_COUNTRY_TEXT)) echo '<span class="help-block">' . ENTRY_COUNTRY_TEXT . '</span>'; ?> </div> </div> <?php } ?>
  8. sheepiedog

    State Selector for BS

    I went to install this, but the Country has moved above the State ? Is this the way its supposed to be ?
  9. I need to add description text to the top of the manufacturer pages. I have been looking for hours and hours through contributions and through the forums. I have found loads of contributions to add description text to Category pages, but not Manufacturer. I have found contributions where the manufacturer description text is a tiny part of a larger contribution (such as the meta tag contribution, but I already have my meta tags all done). I have found contributions that add the manufacturer text to each product page - but not the top of the manufacturer page I have found tons of other posts of people looking for the same thing :-) - but I cant find an answer. I am looking for something simple like: Unique Category Descriptions -- made simple 1.0 but for the manufacturer page instead. Have i missed something ? It seems that this would be an important feature, but cant locate anything suitable....
  10. sheepiedog

    Add This Contribution 6884

    I have changed my mind - I would like to add the Add This button to column right and have it sit at the bottom right after the info boxes. I have been able to get the button appear but only at the top of the column and I fear that I havent done it correctly. If someone could please help and advise me on where in the code in column right would be the correct place to add this button and code and any code I need to make this addition correctly. (so I dont break something else)
  11. hi, I would like to install the Add This Contribution 6884 to the bottom of the Tell A Friend Box which is in my right column. I have attempted a few times and it just ends up as text at the top of the right column and I dont know enough where to add it. According to the contribution I need to add /*BOF Add This Contribution*/ include (DIR_WS_MODULES . FILENAME_ADD_THIS); /*EOF Add This Contribution*/ I would like to add this to the bottom of my Tell A Friend Box - this is my existing tell_a_friend.php code : <?php /* $Id: tell_a_friend.php,v 1.16 2003/06/10 18:26:33 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- tell_a_friend //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_TELL_A_FRIEND); new infoBoxHeading($info_box_contents, false, false, false, $column_location); $info_box_contents = array(); $info_box_contents[] = array('form' => tep_draw_form('tell_a_friend', tep_href_link(FILENAME_TELL_A_FRIEND, '', 'NONSSL', false), 'get'), 'align' => 'center', 'text' => tep_draw_input_field('to_email_address', '', 'size="10"') . ' ' . tep_image_submit('button_tell_a_friend.gif', BOX_HEADING_TELL_A_FRIEND) . tep_draw_hidden_field('products_id', $HTTP_GET_VARS['products_id']) . tep_hide_session_id() . '<br>' . BOX_TELL_A_FRIEND_TEXT); new infoBox($info_box_contents, $column_location); ?> </td> </tr> <!-- tell_a_friend_eof //--> If someone could advise how I would be able to add this code, or if perhaps it is not possible - would really appreciate it.
  12. sheepiedog

    Who's Online Enhancement 1.4

    Thanks Glen, To tell you the truth, I dont know why I use Force Cookie Use - True other than I was told it was a must for security issues with my customers information - I dont really know if I need this set to true or not ? Can you help and advise the pros and cons of Force Cookie Use ?
  13. sheepiedog

    Who's Online Enhancement 1.4

    Thanks for the speedy response. The bot detection is working in that it detects Googlebot and is shown on my jpg (hidden as qty 1 bot) My spiders.txt is the current version from Dec 2008. I suppose my issue is the Force Cookie Use which is set to True. The user agent strings are as follows: User Agent: Mozilla/5.0 (compatible; Yahoo! Slurp/3.0; http://help.yahoo.com/help/us/ysearch/slurp) User Agent: RedCarpet/1.4 (http://www.pronto.com/robots.html) User Agent: YahooSeeker/1.2 (compatible; Mozilla 4.0; MSIE 5.5; yahooseeker at yahoo-inc dot com ; http://help.yahoo.com/help/us/shop/merchant/) I guess my request is the solution being developed, but I am wondering if it is close because it has been mentioned as being developed for a few years now, which led me to think that perhaps the problem is just my whos online.
  14. sheepiedog

    Who's Online Enhancement 1.4

    I guess this message is for SteveDallas as its more about the base whos online enhancement 3.5.4. I would be thrilled if someone could look into any possibles fixes for the bot issues or advise how I could adjust my report so that it only shows real people. Below is screen shot of my whos online - out of 13 lines - only 6 of them are actual real people - the rest are bots/search engines. Is there something wrong with my whos online ? - or can a workaround maybe be developed where the report searches for the term search or crawl or perhaps an ip in the ip address field and is able to recognize and list that entry as a bot so it doesnt show in the general list..... ? Just throwing an idea out there, or perhaps there is a problem with just my whos online enhancement report, not sure
  15. sheepiedog

    Who's Online Enhancement 1.4

    Thanks SteveDallas ! I took the plunge and upgraded to the latest version on my store. Have been absolutely enjoying it and been having lots of fun customizing icons and colors which wasn't possible in my old version 1.5. I have been testing it out over the past week and getting accustomed to the new features. You were totally correct in your previous post about when clicking on a logged in customer that it opens the customer info and the ip - my version being installed on a 'test store' originally had limited testing abilities as no outside people were visiting 1. I am wondering - my previous version - when the page would refresh, the 'latest click' (top) line would be selected - this really helped me when I was just casually monitoring my store as I worked. The latest version 3.5.4 - always remains on the last line clicked. I was wondering, is it possible for me to change something so that the whos online screen behaves as before, with jumping to the latest click line on auto refresh ? 2. Also, wondering if it is possible to have the manufacturers last url and also the popup image url to show the name display as it is with the category and product. (love being able to see the category and product instead of just a url)
  16. sheepiedog

    Remove Unused Images

    I just installed the latest version (June 27th upload #2) When I click on the image link in the report, it adds 'admin' in the url for the images and so all the image links are broken. What do I need to change so that when I click on the image urls in the report, it works ?
  17. sheepiedog

    Paypal not passing address

    If anyone else has this problem I found my answer in a Paypal forum - Paypal changed their paramenters last May which resulted in the addresses being thrown out. To solve this in catalog/includes/modules/payment/paypal.php around line 290 it reads ('no_shipping', '1' ); change this to : ('no_shipping', '2' ); and your paypal transactions will now have the address and the payments will again be Seller Protection Eligible.
  18. sheepiedog

    Paypal not passing address

    Hi, I am using MS2.2 For months, during checkout the billing address is not being passed to Paypal and my customers are having to enter their address info again. This feature used to work fine. I am using a Paypal Contribution from 2004 http://www.oscommerce.com/community/contributions,1753 and had it installed by the contributor Greg Baboolal, but he does not seem to be active on this forum for a few years now. I have scoured the Paypal site forums and all the instructions to fix this involve new Paypal contributions and I cant seem to apply it to the Paypal contribution that I have installed. Can anyone help me please
  19. sheepiedog

    how to get the orderid before the checkout process?

    I was also wondering if it was possible to pass the Order id. The 2checkout receipt email doesnt show the oscommerce order id and neither do the 2checkout.com screens - which means manually matching orders with receipt emails. Do I perhaps have the wrong contribution installed (http://www.oscommerce.com/community/contributions,904) or is this not possible?
  20. sheepiedog

    Country-State Selector

    I have made the changes to remove the state zone code as per my post above. I hope I havent messed up something else.... I changed one line of code in three files create_account.php includes/modules/address_book_details.php includes/modules/checkout_new_address.php I changed this line $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name'] . ' (' . $zones_values['zone_code'] . ')'); TO THIS $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']); and it seems to have removed the 2 digit state code in parantheses after the State name in the drop down boxes. If anyone can see that this would cause some other problem or if I should have changed this in other places, please say. (hoping I did this right)
  21. sheepiedog

    Country-State Selector

    Thanks Steve, I think you may have misunderstood....In vers 1.4.1 - the file you reference (includes/functions/general.php) is not touched by this contribution. This is what I am looking for : In the dropdown list of States (on all customers pages) - I would like just the State name listed (as it was previously in ver 1.0.5 - you added this functionality in ver 1.4.0 according to your 'Change History') not the State name AND the two digit State abbreviation (zone code) in parantheses. I have looked through the forum and all through the files, but I dont feel comfortable attempting a change without a bit of direction. If you get a moment to look at your sources, if you could give me a hint please. Thanks
  22. sheepiedog

    Country-State Selector

    thanks Stevel for a wonderful contibution ! I just upgraded your contribution on one of my stores from version 1.0.5 to 1.4.1.- Its great ! - but, I much prefer the zone code (AL) not being shown along with the zone name (Alabama (AL) ) in the dropdown (as it was on previous versions.) Would it be possible to advise what code and files I would need to change to remove the additional 2 letter abbreviation to the drop down ? (I am imagining it is just a small part of code in a couple of files) I have gone through all 50 + pages in the forum here and couldn't locate the info
  23. sheepiedog

    One Page Checkout Support

    It seems that there are many problems/issues with this contribution. Can anyone advise that they have it working on a live store successfully with no issues ?
  24. sheepiedog

    One Page Checkout Support

    Can someone please confirm - it can be turned on and off. Meaning, while I work on it adjusting it (minor wording changes, etc) to what my store needs, I can have my existing checkout pages working as before. This contribution can be turned off and everything reverts back to what you had before - is that correct ? I am nervous to try this contribution, but this would make me feel a bit safer if I understand it correctly
×