Backup-man Posted September 26, 2008 Share Posted September 26, 2008 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 29, 2008 Share Posted September 29, 2008 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 Quote Link to comment Share on other sites More sharing options...
Backup-man Posted September 29, 2008 Share Posted September 29, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2008 Share Posted October 2, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 2, 2008 Share Posted October 2, 2008 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... Quote Link to comment Share on other sites More sharing options...
Bobster Posted October 2, 2008 Share Posted October 2, 2008 TY for letting us know the solution too often this doesnt happen :) Quote Link to comment Share on other sites More sharing options...
acdt Posted October 3, 2008 Share Posted October 3, 2008 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 Quote Link to comment Share on other sites More sharing options...
acdt Posted October 5, 2008 Share Posted October 5, 2008 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 Quote Link to comment Share on other sites More sharing options...
emmetje Posted October 6, 2008 Share Posted October 6, 2008 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! Quote Link to comment Share on other sites More sharing options...
bfspinto Posted October 6, 2008 Share Posted October 6, 2008 where put im index.php carrocel menu for version 2.0??? Quote Link to comment Share on other sites More sharing options...
Micke Posted October 6, 2008 Share Posted October 6, 2008 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 Quote Link to comment Share on other sites More sharing options...
Dive Right In Scuba Posted October 6, 2008 Share Posted October 6, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 6, 2008 Share Posted October 6, 2008 i dont know what im doing wrong.i just get a white empty space. the xml i image is empty. Quote Link to comment Share on other sites More sharing options...
Micke Posted October 7, 2008 Share Posted October 7, 2008 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 Quote Link to comment Share on other sites More sharing options...
emmetje Posted October 7, 2008 Share Posted October 7, 2008 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: Quote Link to comment Share on other sites More sharing options...
Micke Posted October 7, 2008 Share Posted October 7, 2008 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! Quote Link to comment Share on other sites More sharing options...
emmetje Posted October 7, 2008 Share Posted October 7, 2008 HiUpgraded 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? Quote Link to comment Share on other sites More sharing options...
Micke Posted October 7, 2008 Share Posted October 7, 2008 Yes. It's 777. Quote Link to comment Share on other sites More sharing options...
emmetje Posted October 7, 2008 Share Posted October 7, 2008 Yes. It's 777. Ok, did you use the new directory structure and install instructions? Just eliminating things here Quote Link to comment Share on other sites More sharing options...
Micke Posted October 7, 2008 Share Posted October 7, 2008 (edited) 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 October 7, 2008 by Micke Quote Link to comment Share on other sites More sharing options...
emmetje Posted October 7, 2008 Share Posted October 7, 2008 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? Quote Link to comment Share on other sites More sharing options...
Micke Posted October 7, 2008 Share Posted October 7, 2008 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 Quote Link to comment Share on other sites More sharing options...
emmetje Posted October 7, 2008 Share Posted October 7, 2008 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. Quote Link to comment Share on other sites More sharing options...
Micke Posted October 7, 2008 Share Posted October 7, 2008 (edited) 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 October 7, 2008 by Micke Quote Link to comment Share on other sites More sharing options...
applej Posted October 7, 2008 Share Posted October 7, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.