Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Wolfen Featured Sets SUPPORT


241

Recommended Posts

Hello Steve and everyone

 

I had installed this contribution but now I would like to uninstall it. The files part is no problem for me but the database in quite daunting. How can I remove the database entries created by this contribution from my store database?

 

If I was asked to guess, this is what I will do.

1) From my cPanel, start phpMyAdmin.

2) Looking at the .sql file provided by the contribution, I will have to delete the following entries.

- products_featured

- products_featured_until

- categories_featured_until

- categories_featured

- manufacturer_featured_until

- manufacturers_featured_until

- manufacturers_featured

- manufacturer_featured

- products_short

- Featured Sets

 

Will this be enough? Or have I missed anything?

 

All help is greatly appreciated.

 

Thanks

 

This is what all will need to be removed, however be aware of the warning

 

-- WARNING Be careful with this next bit as your id numbers may be different

 

ALTER TABLE categories
DROP categories_featured,
DROP categories_featured_until;

ALTER TABLE manufacturers
DROP manufacturer_featured,
DROP manufacturers_featured,
DROP manufacturers_featured_until,
DROP manufacturer_featured_until;

ALTER TABLE products
DROP products_featured_until,
DROP products_featured;

ALTER TABLE products_description
DROP products_short;

-- WARNING Be careful with this next bit as your id numbers may be different

DELETE FROM configuration_group WHERE configuration_group_id = '99' LIMIT 1;

DELETE FROM configuration WHERE configuration_id = '143' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '144' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '145' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '146' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '147' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '148' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '149' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '150' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '151' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '152' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '153' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '154' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '155' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '156' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '157' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '158' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '159' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '160' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '161' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '162' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '163' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '164' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '165' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '166' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '167' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '168' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '169' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '170' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '171' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '172' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '173' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '174' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '175' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '176' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '177' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '178' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '179' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '180' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '181' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '182' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '183' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '184' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '185' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '186' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '187' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '188' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '189' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '190' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '191' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '192' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '193' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '194' LIMIT 1;

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

  • Replies 398
  • Created
  • Last Reply

Top Posters In This Topic

This is what all will need to be removed, however be aware of the warning

 

-- WARNING Be careful with this next bit as your id numbers may be different

 

ALTER TABLE categories
DROP categories_featured,
DROP categories_featured_until;

ALTER TABLE manufacturers
DROP manufacturer_featured,
DROP manufacturers_featured,
DROP manufacturers_featured_until,
DROP manufacturer_featured_until;

ALTER TABLE products
DROP products_featured_until,
DROP products_featured;

ALTER TABLE products_description
DROP products_short;

-- WARNING Be careful with this next bit as your id numbers may be different

DELETE FROM configuration_group WHERE configuration_group_id = '99' LIMIT 1;

DELETE FROM configuration WHERE configuration_id = '143' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '144' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '145' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '146' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '147' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '148' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '149' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '150' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '151' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '152' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '153' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '154' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '155' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '156' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '157' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '158' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '159' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '160' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '161' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '162' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '163' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '164' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '165' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '166' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '167' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '168' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '169' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '170' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '171' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '172' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '173' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '174' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '175' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '176' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '177' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '178' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '179' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '180' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '181' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '182' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '183' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '184' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '185' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '186' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '187' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '188' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '189' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '190' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '191' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '192' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '193' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '194' LIMIT 1;

Hello Steve

 

Once again, thank you for the lightning fast reply. I have a test store which I am using to execute the abovementioned. I will run some test to see that everything is fine before executing it on my live store. This has really spared me some headache.

 

This is off-topic but I had to get it off my chest. Thank God for people like Steve and the open source community who are willing to help others knowing that they will not be paid for it. It is amazing how some people still bug hpdl and the others about how slow the development of osCommerce is. If only they knew the amount of work involved.

 

Thanks

Edited by 241
Link to comment
Share on other sites

Hello Steve

 

Luckily I ran the abovementioned queries on my test store only. There was an error but I found where it is.

 

ALTER TABLE categories
DROP categories_featured,
DROP categories_featured_until;

ALTER TABLE manufacturers
DROP manufacturer_featured,
DROP manufacturers_featured,
DROP manufacturers_featured_until,
DROP manufacturer_featured_until;

ALTER TABLE products
DROP products_featured_until,
DROP products_featured;

ALTER TABLE products_description
DROP products_short;

DELETE FROM configuration_group WHERE configuration_group_id = '99' LIMIT 1;

DELETE FROM configuration WHERE configuration_id = '334' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '335' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '336' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '337' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '338' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '339' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '340' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '341' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '342' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '343' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '344' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '345' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '346' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '347' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '348' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '349' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '350' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '351' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '352' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '353' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '354' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '355' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '356' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '357' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '358' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '359' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '360' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '361' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '362' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '363' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '364' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '365' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '366' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '367' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '368' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '369' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '370' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '371' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '372' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '373' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '374' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '375' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '376' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '377' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '378' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '379' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '380' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '381' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '382' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '383' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '384' LIMIT 1;
DELETE FROM configuration WHERE configuration_id = '385' LIMIT 1;

 

The line should read ALTER TABLE products_description DROP products_short; and not ALTER TABLE products_description DROP products_description;. Notice that I have also changed the DELETE FROM configuration WHERE configuration_id to reflect the id found in my database.

 

I have posted this here for anyone who is interested. All credit goes to Steve.

 

Thanks

Link to comment
Share on other sites

Hi Steve,

 

Remember me, I didnt totally give up on your contrib, it is a really good and almost necessary contrib for my shop.

 

Anyway i have been mulling it over and as i have learned more i think i have figured out why it wasnt working for me.

 

I am using sts, and i didnt include the code in the sts_user_code and then the sts_template so although it was installed it wasnt showing in my shop. However i am not sure if this applies to the admin area, where only the manufacturers featured sets was appearing. So i will give this some more thought.

 

I am going to try install the contrib again after i have installed a few others im working on and learned a bit more.

 

Just a quick update. Someone may find it useful. :rolleyes:

 

cheers

Link to comment
Share on other sites

Please URGENT!

 

I have installed everything and it works perfectly! I have even modified styles - layout, great! BUT!

 

FEATURED PRODUCTS PERIOD cannot be set for more than 2 DAYS!! After that period expires my shop doesn't show anything ELSE!- since I have only featured sets in front page!

After period of 2 days expire there is nothing on the page.... Is there a way to set featured products to NEVER EXPIRE so I can set them in Admin ADD/REMOVE ?

 

Please HELP!

Link to comment
Share on other sites

Please URGENT!

 

I have installed everything and it works perfectly! I have even modified styles - layout, great! BUT!

 

FEATURED PRODUCTS PERIOD cannot be set for more than 2 DAYS!! After that period expires my shop doesn't show anything ELSE!- since I have only featured sets in front page!

After period of 2 days expire there is nothing on the page.... Is there a way to set featured products to NEVER EXPIRE so I can set them in Admin ADD/REMOVE ?

 

Please HELP!

 

clear the featured date in the admin by highlighting it and pressing delete, this will set date to 00-00-00

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

clear the featured date in the admin by highlighting it and pressing delete, this will set date to 00-00-00

 

THANKS THANKS THANKS THANKS THANKS THANKS

THANKS THANKS THANKS THANKS THANKS THANKS

 

How stupid of me, I forgot to try that - since it's commonly used

thing in admin settings for other options he he...

 

If you have time I would like to ask one more question, is there possibility to rotate featured products display on main page (their default display order to be random) ? If I set 9 product to be present on main page in 3x3 layout I would appreciate if 'the engine' would rotate them for example two weeks untill I change them to some other set of featured products ?

 

Thank You for Your prompt reply - I really appreciate that.

Thanks again! Wonderfull contribution !!!!!

 

:) Igor

Link to comment
Share on other sites

THANKS THANKS THANKS THANKS THANKS THANKS

THANKS THANKS THANKS THANKS THANKS THANKS

 

How stupid of me, I forgot to try that - since it's commonly used

thing in admin settings for other options he he...

 

If you have time I would like to ask one more question, is there possibility to rotate featured products display on main page (their default display order to be random) ? If I set 9 product to be present on main page in 3x3 layout I would appreciate if 'the engine' would rotate them for example two weeks untill I change them to some other set of featured products ?

 

Thank You for Your prompt reply - I really appreciate that.

Thanks again! Wonderfull contribution !!!!!

 

:) Igor

 

Just set the sort order to rand()

 

 

Set the sort order for the feature products. p.products_id

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Thanks again - works perfectly.

I guess soon I'll be publishing shop from localhost to web so...

I really do not know how I overlooked that option :)

 

You have produced - maybe - one of the greatest contribs here!!

 

Thank You one more time.

Link to comment
Share on other sites

  • 2 weeks later...

I installed this contribution a few months ago and its great untill I broke it with a much needed contribution.

http://www.oscommerce.com/community/contri...l/search,vendor

 

Im not sure if im capable of merging the two together. I think its the admin category file thats going to give me trouble. For now could you tell me the code I need to put in to get the on/off status lights back? I never used the featured untill dates yet so its not that big a deal for now but I would really like to be able to turn things off and on.

 

Thats basically what I broke was the way to turn features on and off and the dates but like I said the dates dont mean much to me... :-"

Link to comment
Share on other sites

  • 2 weeks later...

Hello Steve,

 

Thanks for the contribution, it really is excellent!

 

I only have two simple questions:

 

1) Is it possible to have my home page showing X amount of catagory images (such as Wroughtec's site: * Link to project fork, but does not show the products from that catagory - just a pictorial link to it as such, but still showing my selected featured froduct from various catagories underneath? When I set the catagories to be featured currently, it show it's products as featured below along with those already selected from other catagories .

 

2) Re: Thumb nail ads: Sorry to be a complete ignoramus, but what exactly does this feature do? I have changed various settings, but it makes no difference whatsoever to my site.

 

Many thanks,

Donhinio.

Edited by 241
Link to comment
Share on other sites

Hello Steve,

 

Thanks for the contribution, it really is excellent!

 

I only have two simple questions:

 

1) Is it possible to have my home page showing X amount of catagory images.

They are not using Wolfen Featured Sets and that was a project fork you linked to ( not the best way to ask for help) see the forum rules on project forks.

 

Anything is possible if you apply yourself.

 

2) Re: Thumb nail ads: Sorry to be a complete ignoramus, but what exactly does this feature do? I have changed various settings, but it makes no difference whatsoever to my site.

 

I don't know what you mean by thumbnail ads as this is not a feature of the contribution.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

(donhinio @ Nov 5 2005, 08:57 AM)

 

Hello Steve,

 

Thanks for the contribution, it really is excellent!

 

I only have two simple questions:

 

1) Is it possible to have my home page showing X amount of catagory images.

 

 

They are not using Wolfen Featured Sets and that was a project fork you linked to ( not the best way to ask for help) see the forum rules on project forks.

 

Anything is possible if you apply yourself.

 

 

 

Steve,

 

When you say anything is possible, does that mean that it is not a controllable option of this contribution? If not, do you know of another contribution or way to do it?

 

Regards,

Donhinio.

Link to comment
Share on other sites

  • 2 weeks later...

I got these answers on nonclean install OSC when I query featuredset.sql on DB . The featured product on default mod I have preinstalled.

 

 

#1060 - Duplicate column name 'products_featured' or
#1062 - Duplicate entry '99' for key 1  or
#1264 - Out of range value adjusted for column 'configuration_id' at row 1

 

Any ideas?

Edited by lojze
Link to comment
Share on other sites

I got these answers on nonclean install OSC when I query featuredset.sql on DB . The featured product on default mod I have preinstalled.

 

 

#1060 - Duplicate column name 'products_featured' or
#1062 - Duplicate entry '99' for key 1  or
#1264 - Out of range value adjusted for column 'configuration_id' at row 1

 

Any ideas?

 

You will need to either uninstall your previous mod or make alterations to the database and codes as the other mod is using the same settings as this one and therefore they will conflict.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

I installed this contribution today and think its wicked!

 

Ive got one small problem though....

 

Instead of the description it reads.....' TEXT_MORE_INFO '

and instead of the price ive got...'TABLE_HEADING_PRICE'

 

Can anyone help me get it to display the text and price correctly please....

 

Many Thanks

 

Rik

Link to comment
Share on other sites

I installed this contribution today and think its wicked!

 

Ive got one small problem though....

 

Instead of the description it reads.....' TEXT_MORE_INFO '

and instead of the price ive got...'TABLE_HEADING_PRICE'

 

Can anyone help me get it to display the text and price correctly please....

 

Many Thanks

 

Rik

 

looks like you are missing the language defines for the languages index.php

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

I uploaded a new osc ms2.2 installation.

 

The first contribution installed was Wolfen Featured Sets (http://www.oscommerce.com/community/contributions,2283), in accordance with the installation instructions.

 

(1) All I see on the home page of the website are two boxes with graphic placeholders.

One for /index.php?manufacturers_id=

One for /product_info.php?categories_id=

 

(2) I see nothing in the Admin. Not in Configuration. Not in Catalog.

 

 

What am I missing here?

 

Thanks,

Bruce Senator

 

This is a follow up reply from the above.

 

In looking at the files to upload there are three folders:

admin

images

includes

 

Are these to be uploaded to:

catalog/admin

catalog/images

catalog/includes

 

 

Are these to be uploaded to:

catalog/admin

catalog/admin/images

catalog/admin/includes

 

 

I ask because after uploading, doing the sql run, and the index.php change, I am not seeing the features in this contribution.

 

Something is awry.

 

Thanks,

Bruce Senator

Link to comment
Share on other sites

Hi Steve,

 

Your contrtibution is fantastic. Thank you so much for taking the time to share this with everyone!

 

I'm trying to accomplish a couple of things with the contribution, but I'm having a hard time because I know nothing about PHP.

 

Since the contribution is working perfect as described, you may not be interested in helping me out, but if you happen to come across my post and find some time, it would be most appreciated.

 

I'd rather use the default description rather than the having to enter a shortdescription - problem is that because I have an html text editor installed, all my descriptions have different font styles, sizes, line breaks, etc. And when displayed under featured products, it looks like crap. How can I strip the html tags from the html output? From my limited knowledge of PHP, I've learned that i need to use strip_tags, but cannot find out where I should put it. I figure it would be here somewhere in the code below, but not sure how to do it:

 

 if ($featured_products_array[$i]['shortdescription'] != '') { 
  echo $featured_products_array[$i]['shortdescription']; 
 } else { 
  $bah = explode(" ", $featured_products_array[$i]['description']); 
  for($desc=0; $desc<MAX_FEATURED_WORD_DESCRIPTION; $desc++) 
  { 
  echo "$bah[$desc] "; 
  }  
 }

 

Secondly, because of the limitations of my site design and long product names, I need to truncate the characters for my product names, how do I do that?

 

Finally, I'd like to place a vertical divider between the collumns, like a vertical line. I tried that by adding a <td>, but then realized that it adds a <td> to the last column as well. From looking at the code, I have a feeling I need to add some code somewhere here...

 

 if (($col / FEATURED_PRODUCTS_COLUMNS) == floor($col / FEATURED_PRODUCTS_COLUMNS)) { 
 if (((FEATURED_SET == '1') && (FEATURED_SET_STYLE == '3')) or ((FEATURED_SET == '2') && (FEATURED_SET_STYLE == '3')) or ((FEATURED_SET == '3') && (FEATURED_SET_STYLE == '3')) or ((FEATURED_SET == '4') && (FEATURED_SET_STYLE == '3'))){
echo '</td></tr><tr><td colspan="' . FEATURED_PRODUCTS_COLUMNS . '" align="center" valign="top" class="main" width="50%"><hr color=#' . HORIZONTAL_LINE_COLOUR . '></td></tr><tr>'; 
 }else{
echo '</td></tr><tr><td colspan="' . FEATURED_PRODUCTS_COLUMNS . '" class="main"></td></tr><tr>'; 
 }
 }
if (($i+1) != sizeof($featured_products_array)) { 
  } 
} 
 }

 

But not sure how to do this.

 

If you would just help me out with any of the above I would be most greatful as I have a very active live site and the featured products section is looking a bit disorganized right now.

 

Hope to hear from you soon.

 

Megan

Link to comment
Share on other sites

Hello Steve.

 

I have a simple question.

I have "Featured Products" (contrib. 651) already installed. Can I install also this contribution? Or I have to uninstall that before adding Wolfen sets?

 

Many Thanks

gersio

Link to comment
Share on other sites

Hello Steve.

 

I have a simple question.

I have "Featured Products" (contrib. 651) already installed. Can I install also this contribution? Or I have to uninstall that before adding Wolfen sets?

 

Many Thanks

 

I believe that you should be able to have both installed as they use different file names and different sql

 

You should allways backup your database and files prior to making changes as this then allows you to step back if there are any issues.

 

I uploaded a new osc ms2.2 installation.

 

The first contribution installed was Wolfen Featured Sets (http://www.oscommerce.com/community/contributions,2283), in accordance with the installation instructions.

 

catalog/admin

catalog/images

catalog/includes

 

the files are in the correct tree structure for osCommerce therefore they are uploaded to

catalog/admin

catalog/images

catalog/includes

 

if your sql query was successful then there should be an entry under configuration in the left hand sidebox.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Hi Steve,

 

This is a great contribution! Amazing design and maximum functionality at very little installation effort!

 

I still installed the "Featured Products" separately as I wanted to replace the "New Products..."-box also for the category pages. One comment regarding this:

Both contributions are using (and are trying to declare) functions named tep_expire_featured() and tep_set_featured_status() (in file \includes\functions\featured_sets.php). So whoever wants to have both contributions running side by side has to rename the functions of one contribution. The functions are pretty much the same, but they're using different database tables.

 

Thanks for the great work!

Michael

Link to comment
Share on other sites

This contribution is wonderful, but the only thing that has been a problem with is the page parse time. I have it displayed on the store front and whenever I turn off the featured sets (using the other featured products contribution), I get approx 1.372s whereas with Featured Sets I get 3.847s on the store front. This is a BIG difference in load times, I also noticed that the number of database queries are sometimes pretty high. I have had 'max_questions' limit reached a few times since applying this contribution. Although, I have noticed that the number of queries is less than the other featured products. Now to limit the amount of queries and parse times, I have enabled page cache by chemo. Also, I've implemented the new get_tax_rate method, which has helped a little. I'm wondering there is some opportunities for optimization here? And, if anybody has any ideas.

 

Thank You,

 

PsiliPharm

Link to comment
Share on other sites

This contribution is wonderful, but the only thing that has been a problem with is the page parse time. I have it displayed on the store front and whenever I turn off the featured sets (using the other featured products contribution), I get approx 1.372s whereas with Featured Sets I get 3.847s on the store front. This is a BIG difference in load times, I also noticed that the number of database queries are sometimes pretty high. I have had 'max_questions' limit reached a few times since applying this contribution. Although, I have noticed that the number of queries is less than the other featured products. Now to limit the amount of queries and parse times, I have enabled page cache by chemo. Also, I've implemented the new get_tax_rate method, which has helped a little. I'm wondering there is some opportunities for optimization here? And, if anybody has any ideas.

 

Thank You,

 

PsiliPharm

 

Although I have never had parse times this high it may be due to the extra information that is being pulled from the query such as products description and products short description.

 

I have 20 featured products shown giving a Parse Time: 0.790s and even with 9 manufacturers showing and 20 products showing as well as 20 products from categories the parse time only goes to Parse Time: 1.084s

 

other sites that I have this installed on are running with parse times of 0.201s with the heaviest running at 1.382s

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...