slackbladder
Archived-
Posts
24 -
Joined
-
Last visited
Profile Information
-
Real Name
Tony
slackbladder's Achievements
-
Hi, As the original Attributes Sorter and copier is now an integral part of Shoppe Enhancement Controller and very difficult to pull out of that MOD - is there another attributes sorter available with similar facilities? i.e. checkboxes, sort order, etc. Any help would be much appreciated. Thx
-
BIG Image (Big Image Mod) on Product Info Page possible?
slackbladder replied to a topic in General Add-Ons Support
If you did then try this: Find this in /product_info.php <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="javascript:popupWindow('' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> </td> </tr> And replace it with this: <tr> <td align="center" class="smallText"> <?php echo tep_image(DIR_WS_IMAGES . $product_info_values['products_bimage'], $product_info_values['products_name'], 'hspace="5" vspace="5"'); ?> </td> </tr> Tony Haven't tested it - might be OK. My product_info.php is too heavily modified to be able to test :shock: -
BIG Image (Big Image Mod) on Product Info Page possible?
slackbladder replied to a topic in General Add-Ons Support
Hi, Do you mean like on my site? Tony -
Hi, I'm looking for a way to have on each product a list of prefixed images (already uploaded to server via ftp if necessary) I am creating a clothing store using OSC and each product comes in a variety of colours. Example: JUMPER Size: Large Material: Wool Colours: Red, Blue, Yellow, Black Instead of just the dropdown list for the colours I would like to have a small 'swatch' appear in the actual colour. I guess this would be best done via admin/attributes. Currently I am hardcoding the img tag in to the description (<img src="......>) which isn't really the best solution. I looked at 'addtional images' MODs - but theres probably only 20 colours and I don't want to upload each colour each time there is a new product added. Is there an easy way to get the attributes system to allow for 'img calls' as well as a dropdown list? Any help or direction would be much appreciated Tony
-
:oops: Sorry - general.php is in /admin/includes/functions/general.php
-
Hi Adam, OK figured it out! :D I also use the 'Big Images' mod - so its a help to me too although my turnaround in images isnt too big! In /admin/functions/general.php, look for this: function tep_remove_product($product_id) { $product_image_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($product_id) . "'"); $product_image = tep_db_fetch_array($product_image_query); $duplicate_image_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " where products_image = '" . tep_db_input($product_image['products_image']) . "'"); $duplicate_image = tep_db_fetch_array($duplicate_image_query); if ($duplicate_image['total'] < 2) { if (file_exists(DIR_FS_CATALOG_IMAGES . $product_image['products_image'])) { @unlink(DIR_FS_CATALOG_IMAGES . $product_image['products_image']); } } And replace it with this: function tep_remove_product($product_id) { $product_image_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($product_id) . "'"); $product_image = tep_db_fetch_array($product_image_query); $duplicate_image_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " where products_image = '" . tep_db_input($product_image['products_image']) . "'"); $duplicate_image = tep_db_fetch_array($duplicate_image_query); if ($duplicate_image['total'] < 2) { if (file_exists(DIR_FS_CATALOG_IMAGES . $product_image['products_image'])) { @unlink(DIR_FS_CATALOG_IMAGES . $product_image['products_image']); } } $product_bimage_query = tep_db_query("select products_bimage from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($product_id) . "'"); $product_image = tep_db_fetch_array($product_bimage_query); $duplicate_bimage_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " where products_bimage = '" . tep_db_input($product_image['products_bimage']) . "'"); $duplicate_image = tep_db_fetch_array($duplicate_bimage_query); if ($duplicate_bimage['total'] < 2) { if (file_exists(DIR_FS_CATALOG_IMAGES . $product_image['products_bimage'])) { @unlink(DIR_FS_CATALOG_IMAGES . $product_image['products_bimage']); } } I haven't tested it fully, so BACKUP!!!!! Let me know how you get on. Cheers Tony
-
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
Yep :D This is the admin script for cross sell. The modification I have made to the file will allow for the model number to be shown and sorted. I have a lot of products that are the same name or similar - so not seeing the model number was a real pain. Let me know how you get on. :) -
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
Hi, Sry the CODE TAG is what I should have used to sumbit the 'code' in the this forum - like this: $run_once=0; if ($_POST) foreach ($_POST as $key_a => $value_a) { tep_db_connect(); The code above is the entire code from /admin/xsell_products.php I guess you can just cut'n'paste it in to a new document - remember BACKUP your version of xsell_products.php There are only a couple of changes to the orginal code but they are placed around the whole script - so I thought it would be easier to paste the whole thing. Cheers -
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
:( OOPS sorry - forgot the code tags! I can't edit the post above -
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
OK - I've figured it out :D This will sort by and display the model number/code: Tony :) <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License cross.sale.php created By Isaac Mualem [email protected] <mailto:[email protected]> Modified by Andrew Edmond ([email protected]) Sept 16th, 2002 add: Multi Languages Fix, 02/28/2003 ([email protected]) */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <title><? echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="JavaScript1.2"> function cOn(td) { if(document.getElementById||(document.all && !(document.getElementById))) { td.style.backgroundColor="#CCCCCC"; } } function cOnA(td) { if(document.getElementById||(document.all && !(document.getElementById))) { td.style.backgroundColor="#CCFFFF"; } } function cOut(td) { if(document.getElementById||(document.all && !(document.getElementById))) { td.style.backgroundColor="DFE4F4"; } } </script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <? include(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </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 "Cross-Sell (X-Sell) Admin"; ?></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> <!-- body_text //--> <td width="100%" valign="top"> <!-- Start of cross sale //--> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr><td align=center> <?php /* general_db_conct($query) function */ /* calling the function: list ($test_a, $test_B) = general_db_conct($query); */ function general_db_conct($query_1) { $result_1 = tep_db_query($query_1); $num_of_rows = mysql_num_rows($result_1); for ($i=0;$i<$num_of_rows;$i++) { $fields = mysql_fetch_row($result_1); $a_to_pass[$i]= $fields[$y=0]; $b_to_pass[$i]= $fields[++$y]; $c_to_pass[$i]= $fields[++$y]; $d_to_pass[$i]= $fields[++$y]; $e_to_pass[$i]= $fields[++$y]; $f_to_pass[$i]= $fields[++$y]; $g_to_pass[$i]= $fields[++$y]; $h_to_pass[$i]= $fields[++$y]; $i_to_pass[$i]= $fields[++$y]; $j_to_pass[$i]= $fields[++$y]; $k_to_pass[$i]= $fields[++$y]; $l_to_pass[$i]= $fields[++$y]; $m_to_pass[$i]= $fields[++$y]; $n_to_pass[$i]= $fields[++$y]; $o_to_pass[$i]= $fields[++$y]; } return array($a_to_pass,$b_to_pass,$c_to_pass,$d_to_pass,$e_to_pass,$f_to_pass,$g_to_pa ss,$h_to_pass,$i_to_pass,$j_to_pass,$k_to_pass,$l_to_pass,$m_to_pass,$n_to_pass,$ o_to_pass); }//end of function // first major piece of the program // we have no instructions, so just dump a full list of products and their status for cross selling if (!$add_related_product_ID ) { /* Multiple Language fix --- [email protected] <mailto:[email protected]> */ $query = "SELECT b.language_id,a.products_id, b.products_name, b.products_description,a.products_quantity, a.products_model, a.products_image,b.products_url, a.products_price FROM products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1 ORDER BY a.products_model;"; list ($LANGUAGE_id,$PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description , $PRODUCTS_quantity , $PRODUCTS_model , $PRODUCTS_image , $PRODUCTS_url , $PRODUCTS_price ) = general_db_conct($query); ?> <table border="0" cellspacing="1" cellpadding="2" bgcolor="#999999"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" nowrap>ID</td> <td class="dataTableHeadingContent">Model</td> <td class="dataTableHeadingContent">Product Name</td> <td class="dataTableHeadingContent" nowrap>Cross Items</td> <td class="dataTableHeadingContent" colspan=3 nowrap>Cross Sell Actions</td> </tr> <?php $num_of_products = sizeof($PRODUCTS_id); for ($i=0; $i < $num_of_products; $i++) { /* now we will query the DB for existing related items */ $query = "select b.language_id, b.products_name, a.xsell_id from " . TABLE_PRODUCTS_XSELL . " a, products_description b WHERE b.products_id = a.xsell_id and b.language_id = 1 and a.products_id ='".$PRODUCTS_id[$i]."' ORDER BY sort_order"; list ($Language_id, $Related_items, $xsell_ids) = general_db_conct($query); echo "<tr onMouseOver="cOn(this);" onMouseOut="cOut(this);" bgcolor='#DFE4F4'>"; echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_id[$i]." </td>n"; echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_model[$i]." </td>n"; echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_name[$i]." </td>n"; if ($Related_items) { echo "<td class="dataTableContent"><ol>"; foreach ($Related_items as $display) echo '<li>'. $display .' '; echo"</ol></td>n"; } else echo "<td class="dataTableContent">--</td>n"; echo '<td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Add</a> </td><td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Remove</a> </td>'; if (count($Related_items)>1) { echo '<td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Sort</a> </td>'; } else { echo "<td class="dataTableContent" valign=top align=center>--</td>"; } echo "</tr>n"; unset($Related_items); } ?> </table> <? } // the end of -> if (!$add_related_product_ID) if ($_POST && !$sort) { if ($_POST[run_update]==true) { $query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$_POST[add_related_product_ID]."'"; if (!tep_db_query($query)) exit('could not delete'); } if ($_POST[xsell_id]) foreach ($_POST[xsell_id] as $temp) { $query = "INSERT INTO " . TABLE_PRODUCTS_XSELL . " VALUES ('',$_POST[add_related_product_ID],$temp,1)"; if (!tep_db_query($query)) exit('could not insert to DB'); } echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click Here to add a new cross sale</a><br>' . "n"; if ($_POST[xsell_id]) echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $_POST[add_related_product_ID], 'NONSSL') . '">Click here to sort (top to bottom) the added cross sale</a>' . "n"; } if ($add_related_product_ID && ! $_POST && !$sort) { ?> <table border="0" cellpadding="2" cellspacing="1" bgcolor="#999999"> <form action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?>" method="post"> <tr class="dataTableHeadingRow"> <?php $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . "a.products_quantity, a.products_model, a.products_image, " . "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and b.language_id = 1 and a.products_id = '".$add_related_product_ID."'"; list ($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description , $PRODUCTS_quantity , $PRODUCTS_model , $PRODUCTS_image , $PRODUCTS_url , $PRODUCTS_price ) = general_db_conct($query); ?> <td class="dataTableHeadingContent"> </td> <td class="dataTableHeadingContent" nowrap>Item #</td> <td class="dataTableHeadingContent">Model</td> <td class="dataTableHeadingContent">Item Name</td> <td class="dataTableHeadingContent">$Price</td> </tr> <? $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . "a.products_quantity, a.products_model, a.products_image, " . "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and b.language_id = 1 and a.products_id != '".$add_related_product_ID."' order by a.products_model"; list ($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description , $PRODUCTS_quantity , $PRODUCTS_model , $PRODUCTS_image , $PRODUCTS_url , $PRODUCTS_price ) = general_db_conct($query); $num_of_products = sizeof($PRODUCTS_id); $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$add_related_product_ID."'"; list ($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR) = general_db_conct($query); for ($i=0; $i < $num_of_products; $i++) { ?><tr bgcolor='#DFE4F4'> <td class="dataTableContent"> <input <?php /* this is to see it it is in the DB */ $run_update=false; // set to false to insert new entry in the DB if ($xsell_id_PR) foreach ($xsell_id_PR as $compare_checked)if ($PRODUCTS_id[$i]===$compare_checked) {echo "checked"; $run_update=true;} ?> size="20" size="20" name="xsell_id[]" type="checkbox" value="<?php echo $PRODUCTS_id[$i]; ?>"></td> <? echo "<td class="dataTableContent" align=center>".$PRODUCTS_id[$i]."</td>n" ."<td class="dataTableContent">".$PRODUCTS_model[$i]."</td>n" ."<td class="dataTableContent">".$PRODUCTS_name[$i]."</td>n" ."<td class="dataTableContent">".$currencies->display_price($PRODUCTS_price[$i], tep_get_tax_rate($product_info_values['products_tax_class_id']))."</td></tr>n"; }?> <tr> <td colspan="4"> <input type="hidden" name="run_update" value="<?php if ($run_update==true) echo "true"; else echo "false" ?>"> <input type="hidden" name="add_related_product_ID" value="<?php echo $add_related_product_ID; ?>"> <input type="submit" name="Submit" value="Submit"></td> </tr> </form> </table> <? } // sort routines if ($sort==1) { // first lets take care of the DB update. $run_once=0; if ($_POST) foreach ($_POST as $key_a => $value_a) { tep_db_connect(); $query = "UPDATE " . TABLE_PRODUCTS_XSELL . " SET sort_order = '".$value_a."' WHERE xsell_id= '$key_a' "; //$query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$key_a."'"; if ($value_a != 'Update') if (!tep_db_query($query)) exit('could not UPDATE DB'); else if ($run_once==0) { echo '<b>The Database was updated <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click here to back to the main page</a></b><br>' . "n"; $run_once++; } }// end of foreach. ?> <form method="post" action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $add_related_product_ID, 'NONSSL'); ?>"> <table cellpadding="2" cellspacing="1" bgcolor=999999 border="0"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="75">Product ID</td> <td class="dataTableHeadingContent">Model</td> <td class="dataTableHeadingContent">Name</td> <td class="dataTableHeadingContent" width="150">Price</td> <td class="dataTableHeadingContent" width="150">Order (1=Top)</td> </tr> <? $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$add_related_product_ID."'"; list ($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR, $order_PR) = general_db_conct($query); $ordering_size =sizeof($ID_PR); for ($i=0;$i<$ordering_size;$i++) { $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . "a.products_quantity, a.products_model, a.products_image, " . "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and b.language_id = 1 and a.products_id = ".$xsell_id_PR[$i]." order by a.products_model"; list ($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description , $PRODUCTS_quantity , $PRODUCTS_model , $PRODUCTS_image , $PRODUCTS_url , $PRODUCTS_price ) = general_db_conct($query); ?> <tr class="dataTableContentRow" bgcolor='#DFE4F4'> <td class="dataTableContent"><?php echo $PRODUCTS_id[0]; ?></td> <td class="dataTableContent"><?php echo $PRODUCTS_model[0]; ?></td> <td class="dataTableContent"><?php echo $PRODUCTS_name[0]; ?></td> <td class="dataTableContent"><?php echo $currencies->display_price($PRODUCTS_price[0], tep_get_tax_rate($product_info_values['products_tax_class_id'])); ?></td> <td class="dataTableContent"><select name="<?php echo $PRODUCTS_id[0]; ?>"> <? for ($y=1;$y<=$ordering_size;$y++) { echo "<option value="$y""; if (!(strcmp($y, "$order_PR[$i]"))) {echo "SELECTED";} echo ">$y</option>"; } ?> </select></td> </tr> <? } // the end of foreach ?> <tr> <td colspan="4" bgcolor='#DFE4F4'><input name="runing_update" type="submit" id="runing_update" value="Update"></td> </tr> </table> </form> <?php }?> </td> </tr> </table> <!-- End of cross sale //--> </td> <!-- products_attributes_eof //--> </tr></table> <!-- body_text_eof //--> <!-- footer //--> <? include(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <? include(DIR_WS_INCLUDES . 'application_bottom.php');?> -
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
Having the entire listing broken down into their individual categories would work for me :D And also being able to show the model number in the listing. Tony -
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
I did the following from the xsell_readme.txt file: STEP 8 If you have problems, try flushin the table with this DROP TABLE IF EXISTS products_xsell; CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id int(10) unsigned NOT NULL default '1', xsell_id int(10) unsigned NOT NULL default '1', sort_order int(10) unsigned NOT NULL default '1', PRIMARY KEY (ID) ) TYPE=MyISAM; Worked for me! :D -
[Contribution] Cross Sell (X-Sell) Admin
slackbladder replied to dreamscape's topic in General Add-Ons Support
Firstly, A GREAT MOD :D :D Secondly, within admin is it possible to show the model field as well as or instead of the product description? I have a lot of products that have the same description/title and its difficult to tell which one is which! :shock: Any help would be much appreciated. Thx Tony -
As Matti said try sending a PM to him for a revised application_top and product_info :)
-
Hi, The instructions that came with the MOD are no good for MS1. Matti's MOD helps but as he says there are still many faults. He is working on a revised MOD for MS1 - so probably best to wait, like me! :) Cheers If you really need to use the current mod, then don't just cut and paste - look at the txt files and only alter the changes/additions, not the whole code! :?