Forums / Setting Up Categories, Products, Attributes / Product Type Book (by moku)

Product Type Book (by moku)

Started by moku on 12 May 2006, 6:37 AM · Views: 203,732

Results 181 to 200 of 647
28 Mar 2007, 2:45 PM
#181
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Product Type Book (by moku)

Hi Colosimo,
We'll certainly publish it, first we need to create a nice package including a readme. Will be available next week.
I'll publish the URL where you can dowload it from as soon as it is available.
Thanks for your patience,
Biscayne

28 Mar 2007, 6:32 PM
#182
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi all
Well I can't get my own standard 'sidebox search' to fault with an sql error, the file concerned seems to be class.productBookSearch.php

Biscaynes version will hopefully fix this, .... I did not fix the file myself, because for some god-for-saken reason my own install of extended book add on does not give an sql error! -- even though the main sidebox search is definately using it.

The class.productBookSearch.php file I'm using on my hareslade site is moku's original un modified, (same as in the extended add on fileset)

?????weird

28 Mar 2007, 9:07 PM
#183
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Just uploaded a fresh 137 zencart, to test the 'basic' version of extended book product, I still can't get an sql error by using the standard search sidebox.

If you get it to go faulty (sql error) please let me know!

http://www.hareslade.com/zc137_t2/

I also had manufacturer and model columns active in the product listing, but it still worked ok. The book add on files are only those from EXTENDED_BOOK_MAIN_FILES folder, in the extended book add on for 137.

29 Mar 2007, 7:47 AM
#184
colosimo avatar

colosimo

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
0

Re: Product Type Book (by moku)

biscayne:

Thanks for your patience

Thank you, Biscayne!
Colosimo

31 Mar 2007, 12:54 AM
#185
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: Product Type Book (by moku)

moku:

"Product Type Book" add support for books with a new product type (just like the core music product type, but with much more features)
A thread has been started in the previous forum, now in read-only. You can check it for records here.

FEATURES

  1. Easy installation without touching a single core file (thanks to ZC Override System);
  1. Multi language friendly;
  1. Search books and authors with the standard search sidebox (and genre and/or types);
  1. Shows authors names and ISBN on product listing;
  1. Book attributes:
  • Author (can have more than one author by book)
  • Genre ("Fantastic", "SciFi", "Shonen", "Hentai", etc.) (many genres ok)
  • Type ("Artbook", "Novel", "Manga", "Postcards", etc.) (many types ok)
  • Color ("B&W", "Color", etc?)
  • Condition ("Brand new", "USED (good)", "USED (bad)", etc.)
  • Pages ("123")
  • Publication date ("2004", "31-12-1999", etc.)
  • 2 customs text fields
  • 2 customs boolean fields
  • Publisher and ISBN are reusing Manufacturers and Model core fields

DEMO
Demo of product book for ZenCart

DOWNLOAD
The last version is available here: Product Type Book (product_type_book-moku-v?.?-YYYY-MM-DD) (both Zip and Tar.bz2 should be available)

I am getting this error, the demo is not working and the download takes you to a directory where it is not clear which files are the ones to use.

Does it really work with 1.3.7 I have tried all the patches etc to get it to work but nothing seems to fix this problem.

1146 Table 'christia_zc1.TABLE_BOOKS_TO_BOOK_AUTHORS' doesn't exist
in:
[insert into TABLE_BOOKS_TO_BOOK_AUTHORS (products_id, book_authors_id) values ('32', '2')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thanks for the help.

C

31 Mar 2007, 12:56 AM
#186
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: Product Type Book (by moku)

biscayne:

Hi Colosimo,
We'll certainly publish it, first we need to create a nice package including a readme. Will be available next week.
I'll publish the URL where you can dowload it from as soon as it is available.
Thanks for your patience,
Biscayne

Did you get rid of this error in the new package???

1146 Table 'christia_zc1.TABLE_BOOKS_TO_BOOK_AUTHORS' doesn't exist
in:
[insert into TABLE_BOOKS_TO_BOOK_AUTHORS (products_id, book_authors_id) values ('32', '2')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thanks

C

31 Mar 2007, 11:56 AM
#187
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

cshart..
A bit of unravelling required here?


That TABLE_BOOKS_TO_BOOK_AUTHORS may mean the define is missing in the defines file, OR maybe should be TABLE_BOOKS_TO_AUTHORS

The files for moku's original book type are still on his url, but he stopped work on book last year, so that version might / might not work totally properly on 137, unless someone has specifically upgraded it 'as is' for zencart 137.

Coding of moku files were I think for zencart 135 version, and minor bits became altered in the zencart 'standard fileset for 136 and 137 . I am unsure if anyone has upgraded moku original to 137 status.

I did an 'extended' version of those moku files for 135/136, and was communicating with him, he then stopped work on it (dammit).

So I recently upgraded my extended version to 137 anyway 'cos I had no choice, and thats on my hareslade site as an add-on. This is how I know some moku code needed updating.

biscayne is doing a mod to the advanced search, can't say what else he might get up to....

Don't blame me... I'm just a messenger...

1 Apr 2007, 4:11 PM
#188
colosimo avatar

colosimo

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

biscayne is doing a mod to the advanced search, can't say what else he might get up to...

I hope that is ready soon!
I also will need a Book Authors page and a Publishers page... just displaying the list of them linked to the products list. Possibly splitted by first letter (Authors beginning with A... etc...).
But I really cannot understand how to do it... :huh:
I customized lots of scripts with no difficulty, but here in zen-cart I get lost!

I also asked in other threads... Hareslade or anyone can help?
Thanks a lot!

Colosimo

2 Apr 2007, 10:00 AM
#189
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

point made, moku never did do the 'list of authors, with books',
its an obvious thing to do. Depends how complex it needs to be..

4 Apr 2007, 3:16 AM
#190
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Product Type Book (by moku)

I'm having a problem with the products_url with this product type. The product info page is displaying the link text but it is not active. Below is the code from the tpl.....display.php file. What am I missing? I don't know enough php to know where to look. This is straight from the updated extended version for 1.3.7.

<!--bof Product URL -->
<?php
  if ($products_music_single_url != '') {
?>
    <p id="productInfoLink" class="productMusicSingle centeredContent">
	<?php echo sprintf($url_text, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_music_single_url), 'NONSSL', true, false)); ?></p>
<?php
    }
?>
<!--eof Product URL -->

Thanks

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

4 Apr 2007, 3:19 PM
#191
colosimo avatar

colosimo

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

point made, moku never did do the 'list of authors, with books',
its an obvious thing to do. Depends how complex it needs to be..

I found out on the forum that someone did a manufacturers page
http://www.isabelharris.co.nz/shop/index.php?main_page=brands
here's an explanation on how he did it.
http://www.zen-cart.com/forum/showthread.php?t=29085

I'd prefer it splitted in multiple pages, by first letter (All publishers with A..., with B..., etc).

Probably when you have the Publishers list done, it's easy to make the same with Authors.

I can't get to do it.
Can someone help, please? :lookaroun

4 Apr 2007, 8:06 PM
#192
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

hrm..
maybe I didn't explain properly in the extended version's readme files, this url field was a late addition, its not the same as the normal zencart one, this one appears within the book data list for the product in cart. (not below, as with the zencart 'normal' url)

The code you give, won't work, don't know why you found that...this is what should be there...```

<!--bof Product URL --> <?php if ($products_book_url != '') { ?>
<p id="productInfoLink" class="productBook centeredContent">
<?php echo sprintf($url_text, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_book_url), 'NONSSL', true, false)); ?></p>
<?php } ?> <!--eof Product URL -->

So the template you quote isn't the same as what it should be

(both of the book info display templates in classic and default template folders), should have the comment 'mar 2006 book url activated as misc 5  jph'
as the top line in the code.  Check that yours has that..)

In any case, go to the admin book info product page, look just below 'Private Notes' field, you should find the url field labelled as 'Product URL 
(without http) '

This field is actually 'misc_5', so if you haven't got the url field entry box showing in book product's collect info page, maybe it needs switching on in the book product type, 'edit layout' section

p.m me if you have continuing probs, unsure quite whats up..
7 Apr 2007, 12:34 AM
#193
catharina avatar

catharina

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
1

Re: Product Type Book (by moku)

I have successfully installed the Book Product Type to Zen Cart 1.3.7 and even have the Image Handler 2 working with it. This is an awesome addition!

I am able to add publishers, authors, genres, and types when adding books. However I am not able to add color or condition. As this is a used book site I would really like to add the book's condition. How would I do that or have I done something wrong in the installation?

My cart is under construction but can be viewed at:
http://books.denner.ca

Thanks,
Cat =^..^=

7 Apr 2007, 12:45 AM
#194
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,746
Plugin Contributions:
0

Re: Product Type Book (by moku)

Please add the updated files to the downloads section when you get it operational. Thanks!!

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

7 Apr 2007, 3:23 AM
#195
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Product Type Book (by moku)

Catharina:

types when adding books. However I am not able to add color or condition. As this is a used book site I would really like to add the book's condition. How would I do that or have I done something wrong in the installation?
Yes, a condition field is highly desirable. GoogleBase now requires it.

Woody

7 Apr 2007, 12:28 PM
#196
catharina avatar

catharina

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
1

Re: Product Type Book (by moku)

Is there a way to add stock numbers?

Thanks,
Cat =^..^=

7 Apr 2007, 12:34 PM
#197
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Catharina

I get confused myself... some of the original moku fields such as color appear on my own setups with different display labels.. 'genre' I label as 'type' for instance.

I probably relabelled colour as 'format'

There is a word doc EXTENDED_FIELD_COMPARISONS.doc in other_stuff folder that might help you if you need to assess or alter things (or it might not). You'll see book colour (format) and book condition both have dropdowns, ... so both need you to put some preset entries in the 'admin |extras | book condition' and 'admin |extras | book format' section....

[The book fields that are set up from a 'dropdown' in admin are still ordinary database fields.

Its just that some of the fields defined by dropdown value in admin are the ones that moku had set up as searchable, because one can create a 'search dropdown' in a sidebox ... which lists those same values. Hence the 'authors' sidebox search.]

Regarding specifically sorting out condition fields, first have a look in the admin book 'collect info' page, where you enter book details.

There are two fields for 'condition' in the database, both are text fields, but one of these is only ever populated from a dropdown. The other one is by pure text entry on the collect info page..

In admin book, there should be an entry line marked 'condition', with a dropdown by it.

Next to that is 'condition' again, with a text box, for inserting any manual condition descriptive text. (such as 'part eaten by mice')

If those two are not both there, look in 'admin | product types | book product | edit layout'

The admin entry boxes only appear if the fields are being used, they
should be already switched on in the above admin page.

The condition textual field is 'misc_2' so check that is switched on
. Also you'll see 'show book condition' which should be on.

The condition data display line in the cart book product is a switched one, it has some coding in the display template that concatenates several different fields into one line in the cart display. (I knew that one would be a pain...)

I think you need to have set up a 'used' book before the condition details will show. Obviously a new book condition is 'new' and is prest to show as such.

If I say much more it'll get even more confusing, if there are still probs p.m me maybe I can check out your admin settings.


Philosophy (if there is such a thing..) of this add on

Its designed to install with a number of book fields active, but its not too difficult to switch the spare fields on, alter the existing defines labels as needed, and therefore add working fields, which should be ready to run.

The book template is fairly straightforward to 'code modify' for special setups, one you see how it works codewise. But in most cases you would not need to touch it, as all the existing fields are switchable on/off in the book type's edit layout, and defines labels can be altered.

There are plenty of spare 'admin dropdowns fields' on extended book, these exist because the 'gallery' clone version uses more of them. The word doc mentioned above would help with that.

If anyone desperately needs a bespoke setup, let me know by a p.m

7 Apr 2007, 12:51 PM
#198
catharina avatar

catharina

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
1

Re: Product Type Book (by moku)

Catharina:

Is there a way to add stock numbers?

I've answered my own question by using the Misc 1 field. To display it I altered this line:

define('TEXT_PRODUCT_BOOK_MISC_1', 'Misc 1: ');

in the file includes/languages/english/product_book_info.php

Cat =^..^=

15 Apr 2007, 12:32 PM
#199
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi
For anyone installing fckeditor text editor add-on, for use in admin, the extended book product version 2 collect_info.php needs a replacement file.

This should also be useable on 136 extended book installs.

Here is the page, see the 'update fix' paragraph
http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482

24 Apr 2007, 7:48 AM
#200
neelam_gahlyan avatar

neelam_gahlyan

New Zenner

Join Date:
Apr 2007
Posts:
17
Plugin Contributions:
0

Re: Product Type Book (by moku)

hareslade:

Hi biscayne
sql a pain, isn't it, I'll pm you in a minute

Hi,
I want this book mod in my cart.But im not able to understand how could I do this.
It not clear to me.
1.What files I need to download.
2.In which folder those files should uploaded.
3.What sql querry are fired and how

Means i need a complete guide of this book mod.