Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Cool Flash Carousel Menu


Guest

Recommended Posts

Great contribution. Works out of the box.

 

Suggestion: make the products shown in the carousel selectable via the admin interface! perhaps this contribution can help, cause much of the code can be reused for the selection: http://addons.oscommerce.com/info/651

 

 

greets

 

Hi, I tried to make Cool Flash Carousel work with Featured Prod 1.5.9 with this code in kampanya.php file:

 

"$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_FEATURED . " f where p.products_status = '1' and f.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and f.status = '1' order by rand() DESC LIMIT $limit_product_number";

$specials_query = tep_db_query($specials_query_raw);

"

It seems something else has to be changed because featured products are displayed instead of specials but displayed prices on the carousel are all "0.00"; thanks in advance.

Link to comment
Share on other sites

  • Replies 641
  • Created
  • Last Reply

Top Posters In This Topic

Hi, I tried to make Cool Flash Carousel work with Featured Prod 1.5.9 with this code in kampanya.php file:

 

"$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_FEATURED . " f where p.products_status = '1' and f.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and f.status = '1' order by rand() DESC LIMIT $limit_product_number";

$specials_query = tep_db_query($specials_query_raw);

"

It seems something else has to be changed because featured products are displayed instead of specials but displayed prices on the carousel are all "0.00"; thanks in advance.

 

Hi, there is an error in your code, :P

here the correction, Carousel for features contrib in kampanya.php file:

	$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_FEATURED . " f where p.products_status = '1' and f.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and f.status = '1' order by rand() DESC LIMIT $limit_product_number";
$specials_query = tep_db_query($specials_query_raw);

 

See the exemple here

Link to comment
Share on other sites

Hi, there is an error in your code, :P

here the correction, Carousel for features contrib in kampanya.php file:

	$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_FEATURED . " f where p.products_status = '1' and f.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and f.status = '1' order by rand() DESC LIMIT $limit_product_number";
$specials_query = tep_db_query($specials_query_raw);

 

See the exemple here

 

Hi,

 

I've visited your website: a very nice one!

 

In fact what I want to display is the correct price of each item, not items without their price at all; I tried by inserting your code but the problem remains.

But it's kind of you to have searched a solution.

 

---------------------

Salut Michael,

 

trés abouti ton site, vraiment.

 

Ce que je cherche à obtenir en fait c'est l'affichage dans le carousel des images avec les prix corrects, et non pas comme sur ton site (le carousel dans le header) des articles sans prix. J'ai testé ton code mais le problème persiste. Mais c'est sympa d'avoir cherché une solution, d'ailleurs pas simple à trouver apparemment puisque j'ai aussi posté sur le forum francophone; en vain.

Merci encore

Link to comment
Share on other sites

I have uploaded every thing correctly for Flash Carousel Menu also changed the index codes but:

 

on the Index page, When I right click I can see the Flash, but no products are coming, no Animation, Nothing...

 

I tired many things, installed 1.0 and 1.3 but I m facing the same problem:

 

Please have a look: www.agmedworld.com

 

I hope any of you guys can help me.... I really need to finish this site ASAP...

 

 

--

Shabbir

425-906-4935

Link to comment
Share on other sites

I have uploaded every thing correctly for Flash Carousel Menu also changed the index codes but:

 

on the Index page, When I right click I can see the Flash, but no products are coming, no Animation, Nothing...

 

I tired many things, installed 1.0 and 1.3 but I m facing the same problem:

 

Please have a look: www.agmedworld.com

 

I hope any of you guys can help me.... I really need to finish this site ASAP...

 

 

--

Shabbir

 

RESOLVED! After 16 hours.....

 

Problem was: Flash Carousel was not showing any products or animation or anything..... just i could see the flash file when I right click.... I tried doing many things.... Reinstalling my shop twice... and finally when i lost my hopes..... I found the solution:

 

Products name was in BOLD Letters, : Some how Cool Flash Carousel does not show the products which named in bold letters.

 

When I Edited the product names and removed BOLD , Everything is working now!!

 

I hope this help some people facing same kind of problem...

Link to comment
Share on other sites

Hello,

 

All my images in my shop are the same size; 140 x 140.

After the installation of the flash carousel, I changed this:

 

$image_need_resize = 1;		  // 1 on, 0 off - 1 acik, 0 kapali
$width = 100;								 // image width - resim genisligi
$height = 80;								 // image height - resim yuksekligi
$limit_product_number = 12;

 

into this:

 

$image_need_resize = 0;		  // 1 on, 0 off - 1 acik, 0 kapali
$width = 140;								 // image width - resim genisligi
$height = 140;								 // image height - resim yuksekligi
$limit_product_number = 12;

 

But after that, the shadows are in the middle of the images.. <_< How can I solve this?

I already tried to install version 1.2, but that doesn't work either. (now I've version 1.3)

Another question: how can I put the text a little lower? The text is behind the images now!

 

Thank you in advance,

 

Joshua

Link to comment
Share on other sites

In addition to my previous post;

 

The shadows stay in the middle no matter what I do.. So can somebody tell me how I can fix this?!?

And is it even possible too turn the shadows off???

How can I do that?

 

Thank you in advance,

 

Joshua

Link to comment
Share on other sites

Version 2.0 posted!

 

What's new:

 

- Products selectable in admin (based on Featured Products as requested ;) )

- Removed AC_RunActiveContent and added the W3C valid swfObject javascript

- Moved all the files to appropriate directories

- Made special prices show up

 

That's about it. Thanks to all the other authors of this contribution and the Featured Products contribution. It's possible to use Featured Products and Flash Carousel Menu v2.0 together.

 

Have fun!

Link to comment
Share on other sites

Hi!

Very promising!

However, I get this while trying to run the SQL in phpMyAdmin:

#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
Anyone got a clue what's wrong?

//Micke

Link to comment
Share on other sites

Alrighty....so we are back up and running thanks to some great advice getting it secured :)

 

Now my question is, on the dress website, he has an image in the middle of the Carousel.....How do I add an Image or such in the middle so everything spins around it....any ideas? I want to put a FREE SHIPPING image inside so the items are spinning around it....

 

Any help, as always, is greatly appreciated ;)

 

http://www.diverightinscuba.com/catalog/

 

Feel free to send me some feedback too

Link to comment
Share on other sites

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

Link to comment
Share on other sites

I was a little to quick posting version 2.0 as you've discovered there were some bugs, use version 2.0a instead.

 

Sadly I could'nt get the special prices to work, some help would be great. Right now it shows the regular price.

 

Excuse me for the previous post I'll test it better next time. :rolleyes:

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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!

 

Did you chmod it 777?

Link to comment
Share on other sites

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?

Edited by Micke
Link to comment
Share on other sites

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?

 

Just take note of steps 10 and 11, is there a table rotator at all in your database?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Here's an export of my rotator table:

... and it's included in both database_tables.php

 

This is mine

 

DROP TABLE IF EXISTS `rotator`;
CREATE TABLE `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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4;

--
-- Gegevens worden uitgevoerd voor tabel `rotator`
--

INSERT INTO `rotator` VALUES(1, 177, '2008-10-06 15:11:22', NULL, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `rotator` VALUES(2, 176, '2008-10-06 15:11:38', NULL, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `rotator` VALUES(3, 178, '2008-10-07 10:07:21', NULL, '0000-00-00 00:00:00', NULL, 1);

 

As you can see the last line is different this might be the problem, sadly I'm a sql noob, I just copied it from the featured products. I've no idea how to fix this. I will look into it but some help would be great.

Link to comment
Share on other sites

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:

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)

);

wich apparently works on my host. Edited by Micke
Link to comment
Share on other sites

CREATE TABLE `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`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

 

--

-- Dumping data for table `rotator`

--

 

INSERT INTO `rotator` (`rotator_id`, `products_id`, `rotator_date_added`, `rotator_last_modified`, `expires_date`, `date_status_change`, `status`) VALUES

(1, 35, '2008-10-07 01:18:10', NULL, '0000-00-00 00:00:00', NULL, 1),

(2, 64, '2008-10-07 01:18:21', NULL, '0000-00-00 00:00:00', NULL, 1),

(3, 28, '2008-10-07 01:53:08', NULL, '0000-00-00 00:00:00', NULL, 1),

(4, 30, '2008-10-07 01:53:28', NULL, '0000-00-00 00:00:00', NULL, 1),

(5, 31, '2008-10-07 01:54:17', NULL, '2008-10-29 00:00:00', NULL, 1),

(6, 137, '2008-10-07 02:55:00', NULL, '0000-00-00 00:00:00', NULL, 1);

 

 

 

This is my data all I get is movie not loaded any thoughts

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...