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

[hareslade]

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

[hareslade]

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.

[colosimo]

Thanks for your patience

Thank you, Biscayne!
Colosimo

[cshart]

"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);
2. Multi language friendly;
3. Search books and authors with the standard search sidebox (and genre and/or types);
4. Shows authors names and ISBN on product listing;
5. Book attributes:
   
   • Author (can have more than one author by book)
   • Genre ("Fantastic", "SciFi", "Shonen", "############", etc.) (many genres ok)
   • Type ("Artbook", "Novel", "Manga", "Postcards", etc.) (many types ok)
   • Color ("B&W", "Color", etc?)
   • Language (many languages ok) (use another small contribution "Products Languages")
   • 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

[cshart]

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

[hareslade]

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

[colosimo]

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

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

[hrm]

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