Exactly same problem as me, I never did resolve it however felt the problem was with the DB.
I would like to try it although I have now created my own product types & search filters now.
If yuo sort it please report back
Printable View
Exactly same problem as me, I never did resolve it however felt the problem was with the DB.
I would like to try it although I have now created my own product types & search filters now.
If yuo sort it please report back
I'm having some luck working my way through a copy of collect_info transferring code into it bit by bit. So far I have a partial collect_info form displaying followed by the page footer.
I've reached as far as the 'for' statement around line 1025. It seems, to me, that the 'end for' may be missing or that the error is somewhere in the code following the 'for' statement. If it's a missing 'end for' I have no idea exactly where it should be, yet. It could even be a missing end of another statement.
I'll continuing working on it, but someone else may spot the real solution before me. I certainly wouldn't claim to be fluent in PHP.
I now have all form fields displaying as I believe was intended. IIRC it was just a missing '}'.
I'll do a comparison between the original and my new version of collect_info tomorrow and post the results here. :cool:
Here's my version of admin\includes\modules\product_book\collect_info. I'm not entirely sure why it's working, but it is for me.
I changed some instances of '<?' to '<?php' and I'm sure I added a '}' somewhere, but I can't find it now. :wacko:
Attachment 8010
Where can I find a current version of the software for product type book. :cool:
You will find it hear
http://www.jphuk.co.uk/zc/index.php?...roducts_id=490
HI guys!
Has anyone gotten the SEO URL's for this to work?
I've installed the latest Ultimate URL and then the book SEO. The problem however is that I receive a 404 Page not found error, but otherwise the URL's are correctly "changed".
Any advice on that?
I could not get this module to work without major issues. So, I had numinix do it for a fee. He got it to work, but I do not understand how to use it. I went through the files, but still at at a loss and looked thru this forum. Does anyone have an idea how to use these functions and if there is a file I may be missing explaining it?
Under Extras
What is Book DD2, DD3, DD4, DD5, DD6 stand for? How can I use them?
Under Catalog/product type/product - book/edit product book
Show Book Misc 1
Show Book Misc 2
Show Book Misc (bool) 1
Show Book Misc (bool) 2
Show Misc_3 on product Info
Show Misc_4 on product Info
Show Misc_5 on product Info
Show Misc_6 on product Info
Show Misc_7 on product Info
Show Misc_8 on product Info
Show Misc_9 on product Info
Show Misc_10 on product Info
Show Book Misc (bool) 3
Show Book Misc (bool) 4
Show Book Misc (bool) 5
Show Book Misc (bool) 6
Show misc_int_5_1 on product info
Show misc_int_5_2 on product info
Show misc_int_5_3 on product info
Show misc_int_11_1 on product info
Show misc_int_11_2 on product info
Show misc_int_11_3 on product info
Show misc_dd1 on product info (figured these go under extra's)
Show misc_dd2 on product info
Show misc_dd3 on product info
Show misc_dd4 on product info
Show misc_dd5 on product info
Show misc_dd6 on product info
Any help would be greatly appreciated! I have a Christian bookstore and have lots of things I need to show for Bibles and books. I need to add items like binding, cover, color, closure, UPC, EAN, ISBN13, reference, red letter, ribbon, etc.
Thanks, Kim
Has anyone been able to get MRSP pricing working with product book? I am able to see retail/you save/new price in admin area but it will show it when preview product or customer area. I think I may be missing a file to modify.
I changed these files to match instructions.
admin/includes/languages/english/product_book
admin/includes/modules/product_book/collect_info
includes/languges/english/product_book_info
I could not locate an equivlant file located for book files under:
admin/modules/update_product
admin/modules/product/collect_info
includes/functions/functions_prices
Thanks, Kim
I just installed the latest add on :ML_ZC1_3_8_EXTENDED_BOOK_TYPE_V_4_LANGS_ISS2 on zencart 1.3.8 version.
I added 2 books but I can not search book by ISBN or by title.
what is wrong ? can anybody help me?
My product pages show 17.99 , but the words Retail Price: in front of it are not there. How do I add Retail Price: to product pages?
http://www.burnerbooks.com/index.php...ducts_id=37684
Thanks,
Kim
well the link for the download is not working can you please fix the link ? or can u please attach a new file?
Hello every one, I have one question:
for the current product type book, in admin page there is only one field for inputing ISBN number, if I want to add another field there for another type of ISBN number like ISBN-13, which php file should I modify?
thank you!
This is still driving me nuts. :frusty::frusty:Quote:
Originally Posted by kburner
I used the developers tool and found retail price in these files. I went back through Product book module downloads and could not find where I am missing anything.
Can someone please check against their files to see what one I am missing or is wrong?
Regular products:
/includes/languages/temp file/english.php
Line #69 : define('TEXT_PRODUCT_MSRP', 'Retail Price: ');
includes/languages/english.php
Line #69 : define('TEXT_PRODUCT_MSRP', 'Retail Price: ');
Product Book module:
includes/languages/english/product_book_info.php
Line #50 : define('TEXT_PRODUCT_MSRP', 'Retail Price: ');
includes/languages/english/product_info.php
Line #20 : define('TEXT_PRODUCT_MSRP', 'Retail Price: ');
Thanks, Kim
Does anyone know how to get "Retail Price:" to show on the product page? All I have is dollar amount in the middle of nowhere with space all around it.Quote:
Originally Posted by kburner
http://www.burnerbooks.com/home-and-...your-kids-dont
The MSRP mod works by changing how the price is done in the function... make the edits to includes\functions\functions_prices.php from the mod and it should show up. I'd show you mine, but I've done it in a different way.Quote:
Originally Posted by kburner
What am I looking for the in the functions_prices file?
Thanks, Kim
Hi Everyone. I am having exactly the same problem as flashy275. Difference is that I am using latest version of ZenCart, i.e., v1.3.9hQuote:
Originally Posted by flashy275
Can anyone shed me/us some light on this? I don't even have an error message. Worth to say I am using latest XAMPP on Windows?
Tomorrow I'll give it a try with LAMPP and report here.
Thank you
Pedro Contente
Welcome to the club Pedro, hopefully someone will suggest an answer as I never did get this to work.
good luck
Hey Flashy!
It is working with latest LAMPP on UBUNTU 10.10. Latest Zencart either.
I followed exactly the same steps as I've followed with XAMPP on Windows and It worked! Even multi-language! I can insert books in English and some other language and it seems to work quite fine.
The only difference between windows and linux was that I replaced file owners and permissions in linux, i.e, the original owner of the files was pcontente (user with which I decompressed the zip file to my Downloads folder) and I changed it to root. In Windows I did nothing regarding permissions as you know in Windows we're all admins!! :)
I am going to play around with a bit!
Cheers,
Pedro Contente
Hey everyone, I've seen a few questions in this forum regarding custom pages that contain lists (and links) of book subjects/genres etc, and not many solutions.
With some tinkering, I've finally got something working, so figured I'd share. The code below is based off the manufacturer list sidebox by Kuroi. It displays the list of genres that are used in your products. It also displays the number of those books etc that contain that genre/subject.
I'm currently using v1.3.9g of Zen Cart and v4 (jph) of Moku's Book mod and it appears to work fine.
To make a list of something else (like Authors..which I might try next) all you have to do (i think) is point the SQL in the code to the relevant database fields.
Hope this helps some people.
Code:<?php
/**
* genre list page - displays a list of book genres/subjects so the customer can choose to filter on books with those genres only
* edited by Tim Ryan based on the manufacturer list sidebox by Kuroi
* @package templateSystem
* @copyright Portions Copyright 2007-2009 Kuroi Web Design
* @copyright Portions Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/
// set to true to display a count of the number of products for each genre
define('DISPLAY_GENRES_COUNTS', false);
// debug switch
define('DEBUG_GENRES_SIDEBOX', false);
// test if genres should show
$show_genres = true;
if (DEBUG_GENRES_SIDEBOX) {
echo "Entering genres module ...<br/>\n";
echo '- Images: ' . (DISPLAY_GENRES_IMAGES ? 'TRUE' : 'FALSE') . "<br/>\n";
echo '- Man. Status: ' . PRODUCTS_GENRES_STATUS . "<br/>\n";
echo '- Counts: ' . (DISPLAY_GENRES_COUNTS ? 'TRUE' : 'FALSE') . "<br/>\n";
echo '- Show: ' . ($show_genres ? 'TRUE' : 'FALSE') . "<br/><br/>\n";
}
if ($show_genres) {
// pull counts from the database
$genre_counts_query = "SELECT book_genre_id, COUNT( products_id ) AS number FROM " . TABLE_BOOKS_TO_GENRES . " WHERE book_genre_id IS NOT NULL AND book_genre_id > 0 GROUP BY book_genre_id";
$genre_counts_result = $db->Execute($genre_counts_query);
// prepare counts for use later
$genre_counts_list = array();
while (!$genre_counts_result->EOF) {
$genre_counts_list[$genre_counts_result->fields['book_genre_id']] = $genre_counts_result->fields['number'];
$genre_counts_result->MoveNext();
}
if (DEBUG_GENRES_SIDEBOX) {
echo '<h4>List of Counts</h4>';
echo '<pre>' . "\n";
var_dump($genre_counts_list);
echo '</pre>' . "\n";
}
// now let's get the genres
$genre_sidebox_query = "SELECT g.book_genre_id, gd.book_genre_name
FROM " . TABLE_BOOK_GENRE . " g, " . TABLE_BOOK_GENRE_DESCRIPTION . " gd
WHERE g.book_genre_id = gd.book_genre_id
ORDER BY gd.book_genre_name";
$genre_sidebox_result = $db->Execute($genre_sidebox_query);
if ($genre_sidebox_result->RecordCount() > 0) {
$genre_sidebox_list = array();
while (!$genre_sidebox_result->EOF) {
// prepare data
$genre_id = $genre_sidebox_result->fields['book_genre_id'];
$genre_name = $genre_sidebox_result->fields['book_genre_name'];
$genre_count = isset($genre_counts_list[$genre_id]) ? (int)$genre_counts_list[$genre_id] : 0;
if (DEBUG_GENRES_SIDEBOX) {
echo 'Processing ' . $genre_name . "<br/>\n";
}
// add to list only if we are showing all genres, or this one has products
if ($genre_count > 0) {
$genre_sidebox_list[] = array(
'id' => $genre_id,
'text' => $genre_name,
'count' => $genre_count);
}
// advance to next result
$genre_sidebox_result->MoveNext();
}
if (DEBUG_GENRES_SIDEBOX) {
echo '<br/><h4>Final List</h4>';
echo '<pre>' . "\n";
var_dump($genre_sidebox_list);
echo '</pre>' . "\n";
}
if (sizeof($genre_sidebox_list) > 0 ) {
$content = '';
$content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="">' . "\n";
$content .= '<ul>' . "\n";
foreach ($genre_sidebox_list as $genre) {
if ($genre['text']!=''){
$content .= '<li><a class="manufacturerName" href="' . zen_href_link(FILENAME_DEFAULT, 'typefilter=book_genre&book_genre_id=' . $genre['id']) . '">';
$content .= $genre['text'];
$content .= '</a>';
$content .= ' (' . $genre['count'] . ')';
$content .= '</li>' . "\n";
}
}
$content .= "</ul>\n</div>\n";
echo $content;
}
}
}
Hi Tim
Where should your code be inserted?
Thanks
I created a new custom page, following this guideQuote:
Originally Posted by dw08gm
http://www.zen-cart.com/wiki/index.p...ting_new_pages
The code pastes into the includes/templates/template_default/templates/tpl_myNewPage_default.php page
Cheers,
Tim
I have zencart v. 1.3.9h installed.
I am not sure if the current version of Product book type works properly on this version of zencart.
I did install product book type, however when adding a new product I choose "product-book" and click "new product" but I get a 404 page not found error.
I am not well versed in php and I am wondering if there is a problem with the way I installed the mod, or if it simply won't work on my zen cart version.
Any help would be appreciated as I don't even know where to start to trouble shoot this problem.
I am still using 1.3.8a (with all the security patches). I know I should migrate to 1.3.9h, but my site works fine with one exception: zc search on my site is a pain. But, please don't get me wrong. ZC search is excellent, but I think the problem is my host because search works perfectly on my desktop server( (MAMP).
So why am I writing this?
1. I think I will need to switch hosts (although I have been with the present guys for years) that works well with ZC. I would appreciate any recommendation. Even better, if there is one that will allow me to test my site on it for a short period before I commit.
2. Is there anyway I can limit ZC keyword search to book titles and authors only. Searching description only gives me a whole lot of results my customers don't need.
Now, a declaration. I am a geezer who learnt programming in the days of Fortran 4, which would give you an indication of my age. I am not totally out of touch with code; I can more or less make out what it is trying to say by looking at it. Still, it is only a hobby and I envy all the young energy at forums like this.
Enough self-pity.
So I will be happy if someone could respond or at least point me to threads or postings that can help me. (Oh, BTW, I have been searching ZC forums, FAQs and tutorials for answers for several weeks now. The closest I have got is this: http://www.zen-cart.com/forum/showthread.php?t=131747 -- Improving search results.)
I am suggesting we are who using this Product Type Book contribute together some money to hire a developer to make a clean module, or to improve the latest one. I am not sure how much is the cost, But I think we hire someone in this forum who can do this job.
Yes, good idea, I will support that.
Quote:
Originally Posted by pcontente
Hey Flashy / Pedro
I have the same error too (blank page when adding products).
syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in ***\admin\includes\modules\product_book\collect_info.php on line 1766
I'm using WAMP.
It seems us 'windows' users are having this issue.
Can any Windows users confirm they have this working?
Cheers,
Ian
Is there someone else want to join this?Quote:
Originally Posted by ikanperak
I am not sure if this allowed to discuss in this forum.
Hi all I am sure I am missing something but I downloaded book product from post above seem to have gotten only part of the files, the file book_main_file will not let me access it. also in the read me file it says to apply the patch RUN_THIS_FULL_INSTALL_SQL_PATCH_FOR_DATABASE. That file is not in the download. Any help would be great. thanks in advance.
Rick
I've been looking at this for some time, but had other things on my table. This mod was more of a lesson in creating product types then a working mod... it help point me in the right direction with product type auctions.Quote:
Originally Posted by yosemirza
Looking at the structure again, I have some questions... In order to create a product type book that would be more inline with the current version of Zen Cart and with the minimum amount of edits when upgrading your cart or when version 2 comes out... I would have to do a total rewrite of the mod.
The downside to this is you would have to do a fresh install... upgrading would not be impossible to do thus this would start a new fork for product type book.
Can anyone tell me how to change the number of characters that display in Authors search. It worked fine until I added latest upgrade, now I only get first 5 letters and 2 periods for names. Thanks in advance
Where can I get the latest upgrade for Zen 1.39h
Unfortunately there is no special PTB version for 1.3.9h.
The latest was PTB4 written for ZC 1.3.8
I've PTB2 running on 1.3.9h but have many issues.
Can somebody share a working link to download Book Product Type?
I would appreciate, cause I can't download it from jphuk.co.uk.
Thanks in advance.
PM me your email addressand I will send you PTB as mail attachment.
Also let me know which version of PTB.
Where do I send a PM . i cannoy find any link.
Can I have a working link for the "BOOK" product type please.
email is [email protected].
Thanks Allan
Hi AllanH,
I have been using Product Book Type for about 3 years now. I do not think Moku's site is coming back. But I do have a copy of the zip last upgraded zip file on my server.
Do be forwarned it doesn't work too well with 1.5.0 but I have been able to use it seemlessly with 1.3.9h and earlier. 1.5.0 has it's own version of product book but it is seriously lacking. Maybe the developers can take this and figure out what is missing with the new version of zen cart.
http://www.atmospherebooks.com/test/...LANGS_ISS2.zip
I am getting the following error in the backend, when i click on description:
1054 Unknown column 'pe.size' in 'field list'
in:
[select pe.book_color_id, pe.book_condition_id, pe.subtitle, pe.pub_date, pe.size, pe.pages, pe.misc_1, pe.misc_2, pe.misc_bool_1, pe.misc_bool_2, pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from products p, products_description pd, product_book_extra pe where p.products_id = '162' and p.products_id = pd.products_id and p.products_id = pe.products_id and pd.language_id = '1']
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.
What could be the solution.
zen cart version is 1.3.8
Sammirah,
I am looking for an addon that will give me more cat's for books. You suggested one for 1.5.0, can you elaborate on where to find the addon? Any additional info would be greatly appreciated.
Thanks,
Mike
Sammirah,
I am looking to add the PTB mod and I have 139h. Can you add your URL that uses this mod?
Thanks,
Mike
A modified PTB runs on 139h at one of my customers (Film and Theatre Books).
Best regards,
Perry
When I try to open your file it says the first file is locked and can't be opened, any suggestions?
I have started a new thread http://www.zen-cart.com/showthread.php?200560 for a new product type book add-on, which I am currently working on.
Here is a link to the original Product Type Book by Moku downloadable from my site: http://www.atmospherebooks.com/test/...LANGS_ISS2.zip
While there were a lot of problems when I upgraded to Zen Cart v1.5.0 a few years ago; it is working just fine with v1.5.1 or lets just say so far so good.
I have streamlined this product book package by Moku by shortening the titles and putting things in smaller folders so one can actually get straight to the main catalog files and Installation SQL. This plug-in definitely works with zc1.3.8 - zc1.5.5f, tried as I might I could not get it to work on zc1.5.6 but as it has been brought to my attentionQuote:
Originally Posted by RMsimp
unfortunately, I am not very code savvy when it comes to recognizing and making major changes. However perhaps someone with more experience can take this and re-work it so that it works with versions of zc1.5.6 and later. Or if Philou could perhaps pick it apart for things which could help enhance his ProdBookX project. Here are some pics of how it looks:Quote:
In zc156 product admin pages have changed on how they function requiring any older code to be updated...
Attachment 18274 Attachment 18275 Attachment 18276 Attachment 18277
This is the updated link, which should work now that the file is compressed:http://atmospherebooks.com/test/MokuProductBk.zip