Micke
Pioneers-
Posts
193 -
Joined
-
Last visited
Everything posted by Micke
-
Is it as simple as this - if the ID of the group is 13? update products set products_hide_from_groups = concat(products_hide_from_groups, ',13') update categories set categories_hide_from_groups = concat(categories_hide_from_groups, ',13'); ...or am I missing something?
-
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
-
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
-
PHP Intrusion Detection System for osCommerce
Micke replied to celextel's topic in General Add-Ons Support
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. -
PHP Intrusion Detection System for osCommerce
Micke replied to celextel's topic in General Add-Ons Support
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? -
PHP Intrusion Detection System for osCommerce
Micke replied to celextel's topic in General Add-Ons Support
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: I'll go through the steps all over again. -
PHP Intrusion Detection System for osCommerce
Micke replied to celextel's topic in General Add-Ons Support
Hi All. I get this after installing: Any idea whats wrong? //Micke -
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.
-
Here's an export of my rotator table: ... 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!
-
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?//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