Seperate Pricing Per Customer v3.1 Bug

[ocularmagic]

Well, the bugs just keep popping up in my contribution here. :? Apparently if you assign pricing to one group, then create another group after all of the pricing is entered, it erases all of the prices for the old group. :shock: I'm going to fix this asap and will release a new version when done. Sorry to all for the inconvenience.

[domino]

Will this work with the newest cvs snapshot (12/03/2002) ?

[ocularmagic]

Will this work with the newest cvs snapshot (12/03/2002) ?

It should, but I make no guarantees. :wink:

[ocularmagic]

Released version 3.2. It's a pretty simple fix so I'll add the upgrade from 3.1a to 3.2 here.

 

In file admin/customers.php

 

Around line 25

 

Replace:

$multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " order by customers_group_id");

while ($group_ids = tep_db_fetch_array($multiple_groups_query)) {

 $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " ");

 $multiple_customers = tep_db_fetch_array($multiple_customers_query);

 tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = " . $multiple_customers['customers_group_id'] . " ");

}

 

With:

 

$multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " ");

while ($group_ids = tep_db_fetch_array($multiple_groups_query)) {

 $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " ");

 if (!($multiple_groups = tep_db_fetch_array($multiple_customers_query))) {

   tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $group_ids['customers_group_id'] . "'");

 }

}

 

Around line 141

 

Replace:

 

$multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " order by customers_group_id");

while ($group_ids = tep_db_fetch_array($multiple_groups_query)) {

 $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " ");

 $multiple_customers = tep_db_fetch_array($multiple_customers_query);

 tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = " . $multiple_customers['customers_group_id'] . " ");

}

 

With:

 

$multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " ");

while ($group_ids = tep_db_fetch_array($multiple_groups_query)) {

 $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " ");

 if (!($multiple_groups = tep_db_fetch_array($multiple_customers_query))) {

   tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $group_ids['customers_group_id'] . "'");

 }

}

[CC]

Does anybody know why I would not have this in categories.php, the line I have to replace, it doesnt exist.

Anyone know why it wouldnt ?

 

Around line 690



Replace:



[b]if (!is_array($HTTP_POST_VARS[$key])) {[/b]

With:



if (is_array($value)) {

 while (list($k, $v) = each($value)) {

 echo tep_draw_hidden_field($key . '[' . $k . ']', htmlspecialchars(stripslashes($v)));

 }

} else {



A few lines after, delete:



}

$languages = tep_get_languages();

for ($i=0; $i<sizeof($languages); $i++) {

 echo tep_draw_hidden_field('products_name[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_name[$languages[$i]['id']])));

 echo tep_draw_hidden_field('products_description[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description[$languages[$i]['id']])));

 echo tep_draw_hidden_field('products_url[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_url[$languages[$i]['id']])));

 

It seems to work ok, but it doesnt remember my setting swhen I update a product. Also I have no option to create another pricing category.

 

My snapshot is April time, and I'm using 3.2 just released.

 

Cheers

 

CC.

[CC]

Ok, never mind I sorted that.

 

But I have another issue I believe is a bug.

 

When you run this hack along side the product attributes mod, they effect each other.

Mainly when you chose a pricing group and tick the box and enter the price, it doesnt alter the price, but it ticks the box of the first item in the product attributes box instead.

 

So the price group doesnt exist, all you get is a new attribute to the product in question.

Have you got any ideas as to what might cause this ocularmagic?

 

Or has anyone else experienced this?

 

CC.

[ocularmagic]

Sorry, I don't use the product attribute mod so I can't say for sure. I'll see if I can install the product attributes mod this weekend and see if I can duplicate it. Maybe they both use the same variable name for the checkbox?

[CC]

Argh good point.

 

I will check and come back to you on it as well if I find anything.

 

Cheers

 

CC.

[Guest]

I have same problems CC. Will you post solution if you'll find a problem please?

 

Thanks

[Guest]

Ok sorted that out but theres another bug i guess. I can't delete existing users or new users. I get this when i try to delete

1054 - Unknown column 'customer_id' in 'where clause'

 

select customers_group_id from customers where customer_id = '17'

[CC]

Do you want to share how you solved the problem??

 

I havent got round to looking yet.

 

I will look at the new one now.

But can you tell me how you solved the 1st problem, so I can recreate this new one?

 

CC.

[Guest]

I'd like to share, but I can't cause i had no time to solve that for real. I just removed product attribute mod cause at this time the seperate price mod is more important for me

 

Sorry :oops:

 

Tom

[CC]

Argh ok

 

Well in that case that is all i have done for now as well.

 

But I dont get the error you are getting at this point.

 

Could you tell me exactly what you do that causes you this problem?

I will see if I can replicate it.

 

CC.

[Guest]

I just deleted customer. It doesn't matter if i delete an old customer or i create new one and then delete, i always got same error

 

Tom

[Guest]

I have installed the 3.2 version, but no matter what price I add to a customer group and it always changes back to zero. Does anyone know how can I solve this problem? Thanks

 

 

cheng

[alanpace]

I'm getting the error mentioned in this thread whenever I attempt to delete a customer:

1054 - Unknown column 'customer_id' in 'where clause'

Other than this glitch, the seperate pricing contribution works great. I'm using version 3.2. Has anyone developed a solution to this issue?

[strictlypc]

Hi,

 

I was wondering if anyone has found a fix to the problems above (except for the deleting customer problem). I have installed version 3.3 and the problems related to this thread are still there. The price always stays at "0.0000" and it is affecting my Products Attributes Mod. Anyone have any ideas?

 

Thanks,

David