Micke
-
Posts
193 -
Joined
-
Last visited
Posts posted by Micke
-
-
I haven't looked at that because my feeling is the form will take up a lot of space when you have to add room for displaying 11 checkboxes for those customers groups.
However, as long as you haven't added customers to that group you could do an update of the table products. Say you want to hide the same products from customer group 3 as you hide from customer group 1. Then this query (should) add customer group 3 to those products for hiding:
update products set products_hide_from_groups = concat(products_hide_from_groups, ',3') where find_in_set('1', products_hide_from_groups) > 0;
You could do that in phpMyAdmin. As usual make a backup of your table products and your whole database before testing this out. It worked for me but my test database is very small
This worked fine for me too.
Now I'll be adding a few customer groups who will only see 20 or 30 different products of the total of approximately 1500.
I would really want to start with a customer group where all products (and maybe categories too) are hidden and then manually "unhide" them at product level.
Having a checkbox for "Hide all products" when adding a new customer group would be ulitmate for me but I'm sure there must be a neat query for that too.
How would a query for that look?
//Micke
-
I haven't looked at that because my feeling is the form will take up a lot of space when you have to add room for displaying 11 checkboxes for those customers groups.
However, as long as you haven't added customers to that group you could do an update of the table products. Say you want to hide the same products from customer group 3 as you hide from customer group 1. Then this query (should) add customer group 3 to those products for hiding:
update products set products_hide_from_groups = concat(products_hide_from_groups, ',3') where find_in_set('1', products_hide_from_groups) > 0;
You could do that in phpMyAdmin. As usual make a backup of your table products and your whole database before testing this out. It worked for me but my test database is very small :)
Hi Jan!
You are right. I don't want a checkbox for each customer group. Only one checkbox per product in the selected customer group. Just like the price field.
The SQL-trick works just fine, but that's not what I need. Thats more like a "hide product by default" function(which of course is quite nice)...
//Micke
-
Hi all!
I've got 11 customer groups and more than 1000 procucts. Everytime I create a new customer group I select it and type in the prices in Quick Updates (for SPPC).
Then I have to hide a couple of hundred of products for that customer group. Can Quick Updates be modified so that it can handle hiding of products too? That would save a lot of hours...
//Micke
-
Hi All!
Trying to contol currency from customer group I have put the following in my includes/languages/english.php
$aresult = tep_db_query("select customers_group_name from " . TABLE_CUSTOMERS_GROUPS . " where customers_group_id = '" . (int)$customer_group_id . " '"); $aresult_array = tep_db_fetch_array($aresult); if ($aresult_array['customers_group_name'] != "Some Group") { define('LANGUAGE_CURRENCY', 'GBP'); } else { define('LANGUAGE_CURRENCY', 'SEK'); }
Does'nt work. Is it possible to pull this off somehow?
//Micke
-
Hi All!
I'd like to take away the language and currency box from the store front and put it in admin/customers_groups.php.
A logged in customer will then have the right price, currency and language (besides the other features like tax, payment and shipping modules).
It's not "the taking away from store front"-part that is difficult. It's the adding to the admin/customers_groups.php that I don't know how to solve - if at all possible... or would it be easier to do it in admin/customers.php?
//Micke
-
Got it working! :)
The problem was I had another contribution installed called FWR Security Pro. I disabled it and the installation worked like a charm!
I have turned FWR Security Pro on again and now I'll see what happens. I hope these two contributions can interact in a good way.
If you think I'm wrong - please tell me.
-
Please check without doing any modifications to our file. DB table gets created automatically during the first test call if all the files are in place.
I have done the installation procedure from the beginning - not changing any files.
The database is not created and I can not see any messages after setting:
$show_result = 'true';
and "attacking" with the URL parameters in the installation instructions.
Would it do any good to create the database table manually in phpMyAdmin?
-
Did you make any change to osc_phpids.php? If so, please download this contribution once again and copy this file to your server without making any modification to this file.
If you still get the same error, then please go through each of the step carefully once again. As such there should not be any problem if you have uploaded the PHPIDS directory correctly apart from the files in this contribution.
I changed PHP version to PHP 5.2.6 and now the page loads.
Must have done something wrong though - I have set:
$show_result = 'true';
but no message is showing when I add to the url:
and when I look at the admin log report it says:?id=1&test=">XXX1146 - Table 'databasename_2.phpids_intrusions' doesn't existselect id, ip, name, impact, value, page, created from phpids_intrusions order by id
[TEP STOP]
I'll go through the steps all over again.
-
Hi All.
I get this after installing:
Parse error: syntax error, unexpected '{' in /a/path/to/shop/here/includes/modules/osc_phpids.php on line 80
Any idea whats wrong?
//Micke
-
Version 1.08 released, all known issues have been resolved. Thanks for your support and enjoy. http://addons.oscommerce.com/info/6646
Hi All!
How do I update from the last version? Is there a few files I should upload to the server or do I need to change core files / edit database?
Micke
-
Hi All!
Sorry to barge in like this here... Just wondered if anyone has made an attempt at a "separate template per customer"...
//Micke
-
Thank you!
It looks great! The links to the products don't work right now but I'm sure it's fairly easy to fix.
-
Hey Mat!
You've got the same SQL problem too?
If not I can rule that out...
(Maybe we'll find the answer in one of the featured products threads in this forum?)
//Micke
-
Did it all over again (exept that last line in the SQL that wont work).
Still the same problem. No data in the xml-file and no movie.
Maybe I should roll back to 2.0?
Or maybe I need to install featured products somehow?
-
The SQL import went fine but the module still will not show the movie...
The XML-file in the images directory is still empty. This happened after upgrading to 2.0a.
I think I will install 2.0 all over again just to see if I have made a mistake.
(Maybe the xml-file will come to life again...)
-
I think it's something else, Phil.
What's in your kampanya.xml?
emmetje: Nothing we should add in application_top.php or something?
-
You may be right. I can´t run the sql for featured products either...
I have another site that runs on the same host using featured products but I thing thats version 1.5.9.
The SQL in that is:
wich apparently works on my host.create table featured (featured_id int(11) not null auto_increment,
products_id int(11) default '0' not null ,
featured_date_added datetime ,
featured_last_modified datetime ,
expires_date datetime ,
date_status_change datetime ,
status int(1) default '1' ,
PRIMARY KEY (featured_id)
);
-
Here's an export of my rotator table:
CREATE TABLE IF NOT EXISTS `rotator` (`rotator_id` int(11) NOT NULL auto_increment,
`products_id` int(11) NOT NULL default '0',
`rotator_date_added` datetime default NULL,
`rotator_last_modified` datetime default NULL,
`expires_date` datetime default NULL,
`date_status_change` datetime default NULL,
`status` int(1) default '1',
PRIMARY KEY (`rotator_id`),
KEY `idx_products_id` (`products_id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
--
-- Data i tabell `rotator`
--
INSERT INTO `rotator` (`rotator_id`, `products_id`, `rotator_date_added`, `rotator_last_modified`, `expires_date`, `date_status_change`, `status`) VALUES
(9, 38, '2008-10-07 09:21:12', NULL, NULL, NULL, 1),
(8, 33, '2008-10-07 09:21:06', NULL, '0000-00-00 00:00:00', NULL, 1),
(10, 32, '2008-10-07 09:25:56', NULL, '2008-10-21 00:00:00', NULL, 1);
... and it's included in both database_tables.php
-
The first version I tried to install was your 2.0.
I liked it because you had developed the admin feature and that it did not seam to be tangeled up with other contributions.
1. I was never able to import the last line in the SQL statement - See earlier post.
2. The structure of my 2.0a update is copied over the 2.0 install.
Should i do it all over again according to the 2.0a install instructions?
-
Yes. It's 777.
-
Hi
Upgraded to 2.0a. Still not working.
Now the XML-file in the image directory is empty and the movie is not loaded.
I borrowed Dive Right In Scubas kampanya.xml and edited it to reflect my site with a few products - uploaded it and downloaded it again.
Now it reads:
<?xml version="1.0" encoding="iso-8859-1"?> <products> </products>
The system wipes the file clean it seams...
Too bad! This would be such a nice feature!
-
i dont know what im doing wrong.i just get a white empty space.
the xml i image is empty.
You are not doing anything wrong. I get a "movie not loaded" too...
We'll have to find out why the movie does not load.
Moreover, looking in the xml-file - the prices are all 0.00
Does not matter that you chmod kampanya.xml to 777
Somehow the system sets all prices to 0...
//Micke
-
Hi!
Very promising!
However, I get this while trying to run the SQL in phpMyAdmin:
Anyone got a clue what's wrong?#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci' at line 11//Micke
-
Hi All!
I'm trying to use a nice multilevel menu from dynamic drive (and have been trying the Sothink DHTML menu package too...) for the development of a shop using STS 4.5.3.
Problem: When using the links in the menues (with url:s like index.php, specials.php) the cart seams to be emptied. Maybe the session is lost or something?
Clue: When I disable STS and put the nice menues in header.php it works as expected.
Is it possible to have both working somehow? Do I have to edit sts_user_code.php or something?
//Micke
Seperate Pricing Per Customer v3.5
in General Add-Ons Support
Posted
Is it as simple as this - if the ID of the group is 13?
...or am I missing something?