[need php help to modify this piece of code]

problem solved please disregard :blush:

[need php help to modify this piece of code]

hi:

i need to modify the following code:

           <td align="right" class="main bg_input">
		<table><tr><td colspan="2">If you have read our <a href="conditions.php">Conditions of Use</a> and agree to them, then:</td></tr>
		<tr><td> </td><td align="center" width="100px">
<?php
 if (is_array($payment_modules->modules)) {
   echo $payment_modules->process_button();
 }

 echo tep_image_submit('button_confirm_order.gif', IMAGE_BUTTON_CONFIRM_ORDER) ."\n";
?><div style="color:#FF0000; font-size:0.8em; padding:4px;">-OTHERWISE-</div><a href="index.php"><img src="includes/languages/english/images/buttons/button_dont_confirm_order.gif" border="0" title="Cancel Order"></a>
           </td></tr></table></td>

 

right now the button_dont_confirm_order.gif is set to be the one in the english folder, my site is in two languages so i need it to load the button in the german folder if german was the chosen language. i'm no good at coding php, please help me to modify this, thanks in advance for all the help.

[Easy Populate & Products Attributes]

post #5984 is the one you should be looking at

 

Thx, I made the changes according to #5984, but it didn't solve my problems tho.

my previous issue was all prefix were set to "+"

my issue now is that all prefix were set to " "

I only have one attribute that needs to be actual price.

The other two attribute still need the "+"

Is there any way to have them both???

 

I figured in order to download and mass edit prefix in easy populate,

there should be columns like v_attribute_value_prefix, that would make a lot of sense.

 

Thank you.

[Easy Populate & Products Attributes]

I found this but having trouble understanding it, line numbers are way off.

I'll spend my tomorrow going through these, thanks for pointing me to this post.

 

Actual Attribute for Easy populate

If you are using easy populate this will allow you to add the actual attributes

I don't knowif everyone is using the same easy populat so I am going to add the whole sections I edited you will see //hadir where I edited

this is form line 336-397

  // If you have other modules that need to be available, put them here

 // VJ product attribs begin
//start hadir @phpmom.com show attrib only
   $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$row['v_products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
   $products_attributes = tep_db_fetch_array($products_attributes_query);
   if ($products_attributes['total'] > 0) { //end show attrib only
 if (isset($filelayout['v_attribute_options_id_1'])){
	 $languages = tep_get_languages();

	 $attribute_options_count = 1;
     foreach ($attribute_options_array as $attribute_options) {
   $row['v_attribute_options_id_' . $attribute_options_count]  = $attribute_options['products_options_id'];

   for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
  	 $lid = $languages[$i]['id'];

  	 $attribute_options_languages_query = "select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options['products_options_id'] . "' and language_id = '" . (int)$lid . "'";

  	 $attribute_options_languages_values = tep_db_query($attribute_options_languages_query);

  	 $attribute_options_languages = tep_db_fetch_array($attribute_options_languages_values);

  	 $row['v_attribute_options_name_' . $attribute_options_count . '_' . $lid] = $attribute_options_languages['products_options_name'];
   }

   $attribute_values_query = "select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options['products_options_id'] . "' order by products_options_values_id";

   $attribute_values_values = tep_db_query($attribute_values_query);

   $attribute_values_count = 1;
   while ($attribute_values = tep_db_fetch_array($attribute_values_values)) {
  	 $row['v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count]  = $attribute_values['products_options_values_id'];

  	 $attribute_values_price_query = "select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$row['v_products_id'] . "' and options_id = '" . (int)$attribute_options['products_options_id'] . "' and options_values_id = '" . (int)$attribute_values['products_options_values_id'] . "'";

  	 $attribute_values_price_values = tep_db_query($attribute_values_price_query);

  	 $attribute_values_price = tep_db_fetch_array($attribute_values_price_values);

//hadir AAP   	 $row['v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count]  = $attribute_values_price['price_prefix'] . $attribute_values_price['options_values_price'];

  	 $row['v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count]  = $attribute_values_price['options_values_price']; //hadir actual attribute
  	 $row['v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count.'_prefix']  = $attribute_values_price['price_prefix']; //hadir actual attribute

  	 for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
     $lid = $languages[$i]['id'];

     $attribute_values_languages_query = "select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$attribute_values['products_options_values_id'] . "' and language_id = '" . (int)$lid . "'";

     $attribute_values_languages_values = tep_db_query($attribute_values_languages_query);

     $attribute_values_languages = tep_db_fetch_array($attribute_values_languages_values);

     $row['v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $lid] = $attribute_values_languages['products_options_values_name'];
  	 }

  	 $attribute_values_count++;
   }

   $attribute_options_count++;
	 }
 } }//hadir phpmom.com
 // VJ product attribs end

 

line 1325 -1344

 	 $attribute_values_count = 1;
	 while ($attribute_values = tep_db_fetch_array($attribute_values_values)) {
   $key3 = 'v_attribute_values_id_' . $attribute_options_count . '_' . $attribute_values_count;
   $header_array[$key3] = $iii++;

   $key4 = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count.'_prefix'; //hadir AAP
   $header_array[$key4] = $iii++;

   $key5 = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count; //Hadir AAP
   $header_array[$key5] = $iii++; //Hadir AAP

   for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
  	 $l_id = $languages[$i]['id'];

  	 $key6 = 'v_attribute_values_name_' . $attribute_options_count . '_' . $attribute_values_count . '_' . $l_id; //Hadir AAP
  	 $header_array[$key6] = $iii++; //Hadir AAP
   }

   $attribute_values_count++;
	 }

 

line 2202-2218

   	 // options_values price update begin
     $v_attribute_values_price_var = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count;
     $v_attribute_values_prefix_var = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count.'_prefix';//hadir//actual attrib

  	 if (isset($$v_attribute_values_price_var) && ($$v_attribute_values_price_var != '')) {
     $attribute_prices_query = "select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id ='" . (int)$$v_attribute_options_id_var . "' and options_values_id = '" . (int)$$v_attribute_values_id_var . "'";

     $attribute_prices_values = tep_db_query($attribute_prices_query);
//hadir AAP      $attribute_values_price_prefix = ($$v_attribute_values_price_var < 0) ? '-' : '+';

//start hadir.net actual attrib price
if (($$v_attribute_values_prefix_var == '-') || ($$v_attribute_values_prefix_var == '+')||(!$$v_attribute_values_prefix_var)){
$attribute_values_price_prefix = $$v_attribute_values_prefix_var;}
else $attribute_values_price_prefix = '+';

//end hadir.net actual attrib

     // options_values_prices table update begin
     // insert into options_values_prices table if no price exists

[Easy Populate & Products Attributes]

Hi:

I just installed Actual Attribute Price V1.0 and found it to be quite nice.

I have one attribute that need to be actual price and another one needs to be add on price.

And it works awsome on both.

Example:

http://www.pacsonic.com/product_info.php?products_id=127&language=en

 

Everything looked cool until I started using Easy Populate

I noticed that the csv file downloaded thru Easy Populate does not have columns that allows edit to prefix of the attribute value

And if I edit all attributes in csv and upload in Easy Populate, since there's no columns to edit prefix i guess osc consider these attribute values all default to be "+"

And therefor after the upgraded upload all the product details page ended up looking like this:

http://www.pacsonic.com/product_info.php?products_id=69&language=en

 

That is no good, since I have 2000+ products that all contain these attribute, it would be painful to remove the prefix in the admin area manually for every single product.

Please help me, I really need these two to work together.

without Actual Attribute Price my customers won't be able to get discounts by amount.

and without Easy Populate it will take forever to add all my products in the store.

Please help.

[Easy Populate & Products Attributes]

why yes, lots of newbies have experienced this. :) It's pretty common for folks that overlook this in the docs:

Easy Populate uses the product_model field (model number) to identify the record to update. It won't work without the model number. Each row should have a unique model number. i.e. you can't give all your products a product_model of "test".

 

also make sure you have read the section specifically for Mac users.

 

Thx for the quick response, it all make sense now.

I fixed the model area and EP started working like a charm :)

[Easy Populate & Products Attributes]

Hello newbie here, i m not sure if other newbies have experienced the same problem but this is kind of weird:

 

OS: Mac OS X 10.6

CSV editor: OpenOffice 3.1.1

EP vers: EP_v2_76i_MS2

osCommerce Online Merchant v2.2 RC2a

HTTP: Apache 2.2.14

DB: MySQL 5.0.88

PHP: 5.2.11

My SQL: 5.0.87

 

This is the CSV file i downloaded and modified:

www.cloudywool.com/test.csv

 

And after I imported with EP, not only there's absolute no changes were made to my products,

all product images has turned into one same image, that's the only change happened and it's not desired.

site language english/mandarin, and i have two identical store set up to compare:

www.cloudywool.com (original)

www.pacsonic.com (made change)

 

Since I used a customized template for my store, so i tried installing original osCommerce Online Merchant v2.2 RC2a on another domain i have and tested EP, yet same thing happened.

 

STEP #1 - Upload the three files to your osCommerce Store Directory

STEP #2 - Setup the "temp" folder

STEP #3 - Add a link in the Admin Panel. Edit file

 

I did follow the install instruction step by step, wonder what i did wrong please help.

Thx