vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - Amazon Store Integration (https://vborg.vbsupport.ru/showthread.php?t=161576)

mikelbeck 10-31-2007 07:41 PM

Quote:

Originally Posted by nosherwan9 (Post 1372974)
hello,
i installed this hack and i am getting this error ,

Fatal error: Call to undefined function: simplexml_load_file() in /home/xyz/public_html/Forums/amazon_store.php on line 55

Can u please help me
Thanks

This mod required PHP 5. Do you have that installed?

Khalid-B 10-31-2007 07:45 PM

yes i am using php 5 .........Thanks

mikelbeck 10-31-2007 07:53 PM

Quote:

Originally Posted by nosherwan9 (Post 1372983)
yes i am using php 5 .........Thanks

Looks like it needs libxml 2.6 or higher as well.

Khalid-B 10-31-2007 07:55 PM

libxml 2.6 << what is this and how can i fix it?

Thanks

yoyoyoyo 10-31-2007 08:36 PM

I appreciate all of your hard work and support. It appears that the links are now showing up properly :)

https://vborg.vbsupport.ru/

nominated for MOTM!

mikelbeck 10-31-2007 08:44 PM

Quote:

Originally Posted by yoyoyoyo (Post 1373005)
I appreciate all of your hard work and support. It appears that the links are now showing up properly :)

http://img144.imageshack.us/img144/4777/335213fl9.jpg

nominated for MOTM!

Excellent, thanks. ;-)

And thanks for the Lemmy!

mikelbeck 10-31-2007 08:46 PM

Quote:

Originally Posted by nosherwan9 (Post 1372990)
libxml 2.6 << what is this and how can i fix it?

Thanks

libxml is an XML parsing library. See this page for more information: http://xmlsoft.org/

Depending on your server (os, front end, etc) it's installed differently. If you're using a shared server, ask your host to install it. If it's your own server, you can read through the install instructions on that site to get an idea of what you need to do.

mikelbeck 10-31-2007 09:40 PM

Quote:

Originally Posted by RichieBoy67 (Post 1372959)
I really would like to incorporate more into this though such as a cache and a search. At the very least a conditional link to take people back to the main page of the store after they are done looking at a product...

I've got a caching version working now... but I can't promise that I'll get it out tonight. There's a few other things I'd like to do with it (mostly the things you've suggested), and I've got to take my kid out trick-or-treating. So tomorrow night looks better for another version.

If anybody has any other suggestions, let's hear them.

Kihon Kata 11-01-2007 02:20 AM

Uhm....this is what I got when I tried to import the product:




Database error in vBulletin 3.6.8:

Invalid SQL:
DELETE FROM phrase WHERE product = 'ecs_amazon_store' AND languageid = -1;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Wednesday, October 31st 2007 @ 07:17:42 PM
Script : http://www.XXX.com/forums/admincp/pl...=productimport
Referrer : http://www.XXX.com/forums/admincp/pl...?do=productadd
IP Address : XXXXXXXXX
Username : XXXXXXXXXX
Classname : vB_Database

Running Dedicated Dual Processor Linux Server
PHP5
Mysql 4.1.20
btw.

yoyoyoyo 11-01-2007 03:19 AM

since you are aking for suggestions:

I like the idea of having more than one category to choose from, and also multiple search options, So, for example - you could have a navigation menu somewhere that lists all of the types of items, such as Books, DVDs, CDs, etc., and have a separate search term attached to each category. I also like the idea of having more than one search term for each category - for example - you could have 2 or 3 different settings for each category: Books could have "cat grooming" and "cat breeding" and then the results would be compiled in to one overall "Books" category. I know that this would require a lot of coding, but I can see it as being very helpful. As it stands now, if I want to search for the term "Cats" then it will bring back the Cats broadway cast recording, as well as books about cats, and movies with Cat in the title - I would like to narrow down those searches, but if I put "cat grooming" then it will ignore books about "cat breeding," etc.. I hope I made myself clear enough - sorry for the rambling explanation...

trancetopia 11-01-2007 01:36 PM

I'd really like to get this working for amazon.co.uk

Has anyone any tips on how I can do this using this promising mod?

Thanks.

mikelbeck 11-01-2007 07:24 PM

Quote:

Originally Posted by trancetopia (Post 1373450)
I'd really like to get this working for amazon.co.uk

Has anyone any tips on how I can do this using this promising mod?

Thanks.

The next release will have support for choosing your locale. I'll get it out in another day or two.

In the mean time, I think what you can do is open amazon_store.php and amazon_store_detail.php, search for this:

http://webservices.amazon.com/onca/xml

and replace it with this:

http://ecs.amazonaws.co.uk/onca/xml

I haven't tested that, so I'm not positive it will work. But the docs say it should... Give it a try, let me know if that does it for you.

mikelbeck 11-01-2007 07:26 PM

Quote:

Originally Posted by Kihon Kata (Post 1373169)
Uhm....this is what I got when I tried to import the product:




Database error in vBulletin 3.6.8:

Invalid SQL:
DELETE FROM phrase WHERE product = 'ecs_amazon_store' AND languageid = -1;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Wednesday, October 31st 2007 @ 07:17:42 PM
Script : http://www.XXX.com/forums/admincp/pl...=productimport
Referrer : http://www.XXX.com/forums/admincp/pl...?do=productadd
IP Address : XXXXXXXXX
Username : XXXXXXXXXX
Classname : vB_Database

Running Dedicated Dual Processor Linux Server
PHP5
Mysql 4.1.20
btw.

I really have no idea where that error would come from... this mod does not do anything with the database, that looks to me like something is wrong with your vBulletin itself.

I *think* that error means one of your tables is corrupted or crashed. Try doing a repair and see if that corrects it.

yoyoyoyo 11-01-2007 08:31 PM

Quote:

Originally Posted by yoyoyoyo (Post 1373181)
since you are aking for suggestions:

I like the idea of having more than one category to choose from, and also multiple search options, So, for example - you could have a navigation menu somewhere that lists all of the types of items, such as Books, DVDs, CDs, etc., and have a separate search term attached to each category. I also like the idea of having more than one search term for each category - for example - you could have 2 or 3 different settings for each category: Books could have "cat grooming" and "cat breeding" and then the results would be compiled in to one overall "Books" category. I know that this would require a lot of coding, but I can see it as being very helpful. As it stands now, if I want to search for the term "Cats" then it will bring back the Cats broadway cast recording, as well as books about cats, and movies with Cat in the title - I would like to narrow down those searches, but if I put "cat grooming" then it will ignore books about "cat breeding," etc.. I hope I made myself clear enough - sorry for the rambling explanation...

Even if you don't have the categories listed - I think the multiple search terms would bve really helpful - so you could enter "cat grooming" "cat breeding" "cat history" etc. and allow all of those search terms compile the results for the store. If I put all of those in at once: "cat grooming breeding history" it narrows down the searches too much, but having the three of them separate and then combined in to one overall search would be really helpful.

Kihon Kata 11-02-2007 01:10 PM

Quote:

Originally Posted by mikelbeck (Post 1373702)
I really have no idea where that error would come from... this mod does not do anything with the database, that looks to me like something is wrong with your vBulletin itself.

I *think* that error means one of your tables is corrupted or crashed. Try doing a repair and see if that corrects it.

Yep, that fixed it. Thanks! Installs.

scottct1 11-02-2007 03:58 PM

I installed it, but its not doing what I want.

I want it to only display HDDVD and BluRay Movies only.

Its there any way to make it search for two keywords?

Also any way to add a Amazon Search Box which is tied to my associate ID?

Kihon Kata 11-02-2007 04:38 PM

Mine's working good, except there is "Page 1 of 5365". How can I split this up better?

mikelbeck 11-02-2007 09:59 PM

@scottct1 - The next version will allow you to do multiple searches, and they'll be a search box so your users can type in anything they want.

@Kihon - what would you prefer? Also, I had a look at your site, check to make sure your Associate Tag is entered correctly, your links don't look quite right.

mikelbeck 11-02-2007 10:59 PM

Where would you like to see the search box? Right now I've got it up on top of the page, I'm not sure if I'm happy with it there.

Also, would you like your users to a) only search the search index you've selected or b) select the search index to search through?

mikelbeck 11-03-2007 11:29 PM

Version B4 is now available.

In this version, I've added results caching, cleaned up the templates, added additional search options and added support for locales.

There are many more options in the ACP, so if you upgrade please immediately go to the ACP and check to make sure that you've got your settings correct.

Also - VERY IMPORTANT - you'll need to create a "cache" directory for the cached results to be stored in. Make sure this directory is chmod'd to 777! Read the included text file for more information.

scottct1 11-03-2007 11:58 PM

Nice upgrade, but it still needs a search box for users to search for what they are looking for. :)

On the top left of the screen would be great! I personally would like them to be able to search all of Amazon from my store, this way if they buy anything I still get credit for the sale. :D

mikelbeck 11-04-2007 12:02 AM

Quote:

Originally Posted by scottct1 (Post 1375256)
Nice upgrade, but it still needs a search box for users to search for what they are looking for. :)

On the top left of the screen would be great! I personally would like them to be able to search all of Amazon from my store, this way if they buy anything I still get credit for the sale. :D

Right, I'm with ya. ;-)

I asked in this thread what people wanted to see: https://vborg.vbsupport.ru/showpost....0&postcount=59 but didn't get any response. I finished up the changes I had in mind for this version (aside from the search box) and wanted to get it out. So there it is.

I'll take your idea into consideration, let's see what everybody else has to say. The next version will have a way for users to search for their own stuff.

I'm also considering adding the functionality to allow the users to add items to a local shopping cart and continue searching, then when they're done cliking a link to go off to Amazon to make the purchase. What does everybody think about that?

FWIW, I've got a similar project in the works... but one that works with eBay instead of Amazon.

yoyoyoyo 11-04-2007 12:43 AM

Quote:

Originally Posted by mikelbeck (Post 1375259)
Right, I'm with ya. ;-)

I asked in this thread what people wanted to see: https://vborg.vbsupport.ru/showpost....0&postcount=59 but didn't get any response. I finished up the changes I had in mind for this version (aside from the search box) and wanted to get it out. So there it is.

I'll take your idea into consideration, let's see what everybody else has to say. The next version will have a way for users to search for their own stuff.

I'm also considering adding the functionality to allow the users to add items to a local shopping cart and continue searching, then when they're done cliking a link to go off to Amazon to make the purchase. What does everybody think about that?

FWIW, I've got a similar project in the works... but one that works with eBay instead of Amazon.

Great update and I look forward to the future updates as well :)

mikelbeck 11-04-2007 12:51 AM

Quote:

Originally Posted by yoyoyoyo (Post 1375280)
Great update and I look forward to the future updates as well :)

Do you have it installed? If so, got a URL?

BadgerDog 11-04-2007 09:43 AM

Quote:

Originally Posted by scottct1 (Post 1375256)
Nice upgrade, but it still needs a search box for users to search for what they are looking for. :)

On the top left of the screen would be great! I personally would like them to be able to search all of Amazon from my store, this way if they buy anything I still get credit for the sale. :D

Yes... thank you ... :up:

Regards,
Badger

yoyoyoyo 11-04-2007 10:51 AM

Quote:

Originally Posted by yoyoyoyo (Post 1375280)
Great update and I look forward to the future updates as well :)

Quote:

Originally Posted by mikelbeck (Post 1375282)
Do you have it installed? If so, got a URL?

Yes, it is installed, but on a completely private forum. It is working great! I loe the multiple searches - my only request is to add even more :)

mikelbeck 11-04-2007 11:02 AM

Quote:

Originally Posted by yoyoyoyo (Post 1375482)
Yes, it is installed, but on a completely private forum. It is working great! I loe the multiple searches - my only request is to add even more :)

Ya, I'm working on that. At this point, it looks like the Amazon API only allows 2 searches to be performed at once. I'm looking for a way around that, though.

yoyoyoyo 11-05-2007 10:28 AM

Cool - thanks much.

One thing though, maybe it is just me, but for some reason, when viewing the amazon store page, the dhtml drop-down links in the navbar do not appear, and the links show up as just links with no drop-down function.

hddstudio 11-05-2007 12:43 PM

Just an idea : optional search in NavBar....is it possible ? so user can search in forum and got input also from amazon at the same time (make it default : checked option)

mikelbeck 11-05-2007 09:45 PM

Quote:

Originally Posted by yoyoyoyo (Post 1376170)
Cool - thanks much.

One thing though, maybe it is just me, but for some reason, when viewing the amazon store page, the dhtml drop-down links in the navbar do not appear, and the links show up as just links with no drop-down function.

I can't make that happen, not on my demo site or my dev site. Is anybody else seeing this?

@hddstudio - I'm not sure if I could do that... but I'll look into it.

mikelbeck 11-06-2007 12:26 AM

Ok people... you asked for it, now you've got it.

There's a new option in the ACP in version 1.00.00 B5 - "Allow users to perform their own searches". If you enable this option, a new box & dropdown list will be displayed on the main page, your users can put in their own keywords and select the index they'd like to search.

Let me know what you think.

yoyoyoyo 11-06-2007 12:55 AM

thanks much - I will check it out and let you know how it works for me

yoyoyoyo 11-06-2007 01:02 AM

well, the search option works, but it does not insert my Amazon associate ID in the URL. It shows up in the URL in the store, but when I actually click on the item the associate ID is not in the URL.

in the store I see this:
Code:

http://www.amazon.com/gp/redirect.html%3FASIN=B0001YNLLK%26tag=myamazonID-20%26lcode=xm2%26cID=2025%26ccmID=165953%26location=/o/ASIN/B0001YNLLK%253FSubscriptionId=0Z5J0DYKEA7V6Y1BH1H2
but when I click on the URL this is the link that displays in the browser:

Code:

http://www.amazon.com/o/ASIN/B0001YNLLK/105-5046536-9646804?SubscriptionId=0Z5J0DYKEA7V6Y1BH1H2

mikelbeck 11-06-2007 01:39 AM

Quote:

Originally Posted by yoyoyoyo (Post 1376703)
well, the search option works, but it does not insert my Amazon associate ID in the URL. It shows up in the URL in the store, but when I actually click on the item the associate ID is not in the URL.

in the store I see this:
Code:

http://www.amazon.com/gp/redirect.html%3FASIN=B0001YNLLK%26tag=myamazonID-20%26lcode=xm2%26cID=2025%26ccmID=165953%26location=/o/ASIN/B0001YNLLK%253FSubscriptionId=0Z5J0DYKEA7V6Y1BH1H2
but when I click on the URL this is the link that displays in the browser:

Code:

http://www.amazon.com/o/ASIN/B0001YNLLK/105-5046536-9646804?SubscriptionId=0Z5J0DYKEA7V6Y1BH1H2

Right, that's how it works. If you notice, in the first URL there's "redirect.html". Amazon takes the inbound link, pulls out the data needed for your associates tag (plus whatever else it wants, I guess) and then sends the user to an Amazon page.

yoyoyoyo 11-06-2007 01:55 AM

ok thanks for the explanation - in that case I guess it is working just fine :)

mikelbeck 11-06-2007 02:05 AM

Quote:

Originally Posted by yoyoyoyo (Post 1376715)
ok thanks for the explanation - in that case I guess it is working just fine :)

Ok, good.

You're happy with it? It's exactly what you've always wanted? ;-)

yoyoyoyo 11-06-2007 02:13 AM

Quote:

Originally Posted by mikelbeck (Post 1376721)
Ok, good.

You're happy with it? It's exactly what you've always wanted? ;-)

well... if you can arrange for a dozen or so nubile nympomaniac girlies to stop by my house then I would say yes... lol

seriously - I like it a lot. I can envision a few more additions I would like to see, such as random (or pre-designated) items from the amazon store in cmps sideblocks, or on the "what's going on" area that link to the description of the item in the store, or a shopping cart system as mentioned earlier by you. As far as layout is concerned - I am wondering why the descriptions are all centered on the page instead of a normal layout with the text flush left, etc.. Right now if this mod was a dancer on dancing with the stars, and I were a judge I would give it a 7 or an 8 ;)

BadgerDog 11-06-2007 11:56 AM

Updated with latest feature to permit custom searching ... :)

We've now released this mod "live" to our members....

Working well.... :up:

One recommendation. Since we are a site for "registered" users only, it would be good to be able to restrict usergroups who can access this mod. ie: no guests etc....

Regards,
Badger

mikelbeck 11-06-2007 10:45 PM

Quote:

Originally Posted by yoyoyoyo (Post 1376725)
well... if you can arrange for a dozen or so nubile nympomaniac girlies to stop by my house then I would say yes... lol

seriously - I like it a lot. I can envision a few more additions I would like to see, such as random (or pre-designated) items from the amazon store in cmps sideblocks, or on the "what's going on" area that link to the description of the item in the store, or a shopping cart system as mentioned earlier by you. As far as layout is concerned - I am wondering why the descriptions are all centered on the page instead of a normal layout with the text flush left, etc.. Right now if this mod was a dancer on dancing with the stars, and I were a judge I would give it a 7 or an 8 ;)

Which descriptions? On the main page or the detail page? I'll see what I can do about the other stuff you've mentioned.

Thanks for the high rating. ;-) Did you nominate it for MOTM yet?

@BadgerDog - I was thinking about doing that, but I'm not all that sure how to do it yet... when I figure it out I'll add it.

FYI... here's what's on the list for the next release:

1. Fix the "powered by amazon.com" and similar texts when the search actually goes to a different locale.
2. Add an option to integrate YPN or Adsense in the results, or maybe on the side. Or somewhere.
3. Sometimes the page numbers don't make sense... I've got to figure out why and fix it properly.
4. When the "blended" index is used, it returns more than 10 results per page, so the page numbers are off. Again, figure out why and fix it properly.
5. Maybe add a local shopping cart so users can add items on your site instead of being sent to Amazon for each purchase. Then when they're done they can click "checkout" and THEN go to Amazon.
6. Random items displayed somewhere else on the site... maybe in CMPS or "what's going on" like yoyoyoyo suggested.
7. Improve the doc that's distributed with the archive... man does that thing look like crap, totally unprofessional.

Any other suggestions?

yoyoyoyo 11-06-2007 11:08 PM

Quote:

Originally Posted by mikelbeck (Post 1377367)
Which descriptions? On the main page or the detail page? I'll see what I can do about the other stuff you've mentioned.

on the detail page.


All times are GMT. The time now is 10:59 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01433 seconds
  • Memory Usage 1,863KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (22)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete