sheepiedog

Members
  • Content count

    203
  • Joined

  • Last visited

Community Reputation

0 Neutral

About sheepiedog

Profile Information

  • Real Name
    Deb Humeniuk
  1. 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. @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.
  3. 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'); ?>
  4. 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 ?
  5. 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 ?
  6. 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. 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. I went to install this, but the Country has moved above the State ? Is this the way its supposed to be ?
  9. 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)
  10. 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.
  11. 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....
  12. 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. 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. 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. 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)