New Zenner
- Join Date:
- Aug 2005
- Posts:
- 26
- Plugin Contributions:
- 0
Product Type Book (by moku)
Is this module not available anymore? The download site seems to be, well... down?
New Zenner
Is this module not available anymore? The download site seems to be, well... down?
New Zenner
dgcdesign:
Is this module not available anymore? The download site seems to be, well... down?
There is a lot of links to where the mod used to be. The latest is available here:
http://www.jphuk.co.uk/zc/index.php?main_page=document_general_info&cPath=54&products_id=490
Totally Zenned
Hi
The email advices are not working for me yet again, so I don't know what posts are solved without trekking back through the list.. I moved house recently so its a bit chaotic here. And I'm slightly out of touch with book product..
However
tHis is my test site for book product in single language
http://www.jphuk.co.uk/zc138a_t1/
I seem to remember probs with authors search were possibly originally due to not having a manufacturer in the book product item.. other than that, it works om my demo site?
The prob with the 'extra' data still showing with a disabled item, I agree, it shows the 'extra' data still, -if there isn't extra data the book item correctly disappears. I will look into this, but did anyone find the code solution?
Totally Zenned
Hi
It seems to me that the music product does the same thing, shows the extra data, rather than disappearing completely when the item is disabled in admin.
http://www.jphuk.co.uk/zc138a_t1/index.php?main_page=product_music_info&cPath=3&products_id=6
The above link is my demo site with a music product, the product you see is disabled (red) in my admin, note it has no title
Would someone check this out on a 1.3.8 zencart by putting a music product in and then disabling it, , see if I'm right
I'm not saying it isn't a book product bug, but music product seems to have the same thing?
Reason I checked out music product, is that I compared the book php files code with music product files code, they have similar code in terms of what the coding does.
Let me know..
btw of course, add the artist etc extra data into the music product, for the testing..
New Zenner
Hello hareslade,
this is from the header.php in includes/modules/pages/
I take it from product_info and it it to product_book_info
// if specified product_id is disabled or doesn't exist, ensure that metatags and breadcrumbs don't share inappropriate information
$sql = "select count(*) as total
from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_id = '" . (int)$_GET['products_id'] . "'
and pd.products_id = p.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
if ( $res->fields['total'] < 1 ) {
unset($_GET['products_id']);
unset($breadcrumb->_trail[sizeof($breadcrumb->_trail)-1]['title']);
header('HTTP/1.1 404 Not Found');
It seems not to work full, but the extras are not shown.
Totally Zenned
HI michaelhl
The code setup you used from the standard product header isn't the same as the code in the music product file..
It looks to me like the http 404 header has been added to zencart standard product, but not for music product,
which explains the posts about search engines not liking book product, which copies the music code.
The music code probably doesn't allow a 404 header to be written, (where the ordinary product does allow), because the 404 standard product code instructions are in the header, not in main_template_vars.php. You can't write a header after any html is output.
Technically the separate problem seen with extras data showing, is because the main_template_vars_product_type.php in both music and book product, is running when it shouldn't, i.e its getting 'extras' data.
main_template_vars.php switches to the 'noproduct' template when there is no product found to display (i.e when it detects the red 'disabled' setting for the product is present). But I don't yet understand why the extras data are apparently showing on the 'info' template - it should have switched to the noproduct template.
Has anyone tested the music product for the same extras data problem when disabled, yet, as I suggest?
If it turns out music product is faulty, then really a post should be put in a new main thread, asking for solutions for music product.
New Zenner
Hey Hareslade,
Have you had any difficulties with your Zen Cart or mod when a shop has upwards 2,000 products?
I'm in a bit of a bind, which is detailed here: http://www.zen-cart.com/forum/showthread.php?p=604865#post604865
You don't need to read my entire problem, but I am curious about where I can go for answers in fixing the Zen Cart.
Totally Zenned
the ocarina
There must be a processing time, or other limit somewhere on every sql request, you found it..
Either Hostgator has a type of sql processing limit which other hosts may not have,
or
the book sql might be proving too unwieldy because of the number of products
Or if you're showing 'product count' in categories menu links on the pages, turn that off it reduces sql requests.
Theres also a zencart global debug setting I think, that can show the sql process time period used, at bottom of each page, once you see it, if it says more than say 6 seconds its having trouble
I think all hosts limit the sql 'power' available per hosted site, as they are normally on servers with say 50 websites, and if one takes all the sql time up, the other sites will grind to a halt.
Totally Zenned
generally... is anyone going to test the music product to see if it behaves the same as book product regarding the 'extra data' see several posts back?
Without confirmation I'm unable to post in the main forum regarding music product..
(The book product still shows up on its original url, even if the product has been disabled in admin.. does music product do exactly the same ?)
Zen Follower
hi
the link to download doesn't work. is there any other place where we can find the zip file?
oops; in between I found it:
http://www.jphuk.co.uk/zc/index.php?main_page=document_general_info&cPath=54&products_id=490
Totally Zenned
Hi
Depends which version zip you need 1.3.8 or 1.3.7
See left hand 'zencart matters' menu, at
http://www.jphuk.co.uk/zc/index.php as in my signature below
If the download doesn't work (but it should) try a different browser
Zen Follower
how can I enable display or activation of url for authors, when I click on author in a product page, it does do the filter action than going to th eauthor url.
the same question for displaying the text of description of format, conditions, etc.
Totally Zenned
not sure quite what you mean in your post reza,
maybe p.m me with a page url as info, and description of the situation
there are a lot of display settings in the admin for book, in the 'product type' edit page
New Zenner
Can anyone out there help me make adjustments to the default product type please on a standard install of V1.3.8 for a bookshop?
What I'm hoping for is to eliminate the need to add a new product type by just rejigging the default one to suit my needs. I figure that if I can change music genre to subject and recording artist to author then I will have the main changes I need. I have worked out how to change the wording in the language file so that music genre appears as subject but I can't work out what language file I need to change so that recording artist appears on the product page as author.
Also I want to show format (std, trade etc) and new or used description of books on the main product page. How can I easily achieve this? By adding these fields to the database or by working through attributes?
Can't make sense of the bookshop mod. Downloaded it but couldn't work out what I needed to upload. I am sure it is excellent but to some one like me it is totally confusing.
Thanks. I'm a newbie by the way:smile:
Totally Zenned
Hi bookwise, maybe you need to get more zencartwise before attempting mods
i.e like what we have to do, work out slowly, where the files are that do various things
the book product isn't too bad, you may get through a few zencart test sites first if you're new to installing add-ons
Adding fields for new/used and so on is a programming chore, thats why book type exists!
In the book zip pack is a folder 1_BOOK_MAIN_FILES
Within that is folder 'catalogue', thats the one to upload the contents of, into the zencart main folder.
You also need to alter the database tables by using from folder RUN_THIS_FULL_INSTALL_SQL_PATCH_FOR_DATABASE
file ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE_V4.txt inside zencart in the admin 'sql patch' page
BUT i suggest first, you get the 'database backup' add on from the add ons list, make sure you have
a database backup BEFORE you apply the book sql patch. Just in case summat goes wrong..
All this is told in the readme file README_main_book_install.txt in folder 1_BOOK_MAIN_FILES.... thats where the info is..
Zen Follower
wel, when you see a product in product info display page, when you click on authors, it goes to show all bookd from this author (so, filter function), while in admin we can put a url (inetrnal, or external url) or this author, I don't find any place on the front page of site where I can find the url link to authors' url.
I hope this is now clear, the best example, see our demo site and click on the authors of a book.
Zen Follower
is thre any way to make or have more defined search functions: example:
http://roshanbh.com.np/2008/01/populate-triple-drop-down-list-change-options-value-from-database-using-ajax-and-php.html
in actual situation, when I click on authors filter, it gives me a long list of authors, so actually the customer remains within so much data even if for us we did a filter of many data.
summarized: we know that one author can have some subjects, and each subject can have some types, , then using the link above , I suppose we should have the possibility to define more specific search options for book products withou loading many times by filtering this options (authors, subjects, types, ) individually.
another intressant link here wich should be better for us due to use dirctly from mysql:
http://php-ajax-code.blogspot.com/2007/07/ajax-triple-dropdown-with-states-cities.html
(advantage: used mysal, so very good for us to use bok tables)
http://www.opencrypt.com/blog.php?a=22
also good, still in progress, but it used also mysql, )
Zen Follower
oops: also this one which is more flexible and more robotic
Zen Follower
I added this line to tpl_advanced_search_default.php
after manufacturer field:
//this is what I added after above lines bof: adding extra filed to search function: authors list
<fieldset class="floatingBox forward"> <legend><?php echo ENTRY_MANUFACTURERS; ?></legend> <?php echo zen_draw_pull_down_menu('book_authors_id', zen_get_book_authors(array(array('id' => '', 'text' => MAX_BOOK_AUTHORS_LIST))), $sData['book_authors_id']); ?> <br class="clearBoth" /> </fieldset> //eofbut the filed of authors doesn't been displayed.
Is this not a good way to get more search definitions for advanced search for book products?
for echo entry manufacturers, I didn't know where I should put definition to come from it to here. anayway, the important is that we get authors, and other options of a book in the search functiionality to decrease the number of results and more customer friendly result page.
a result page with more than 50 articles is never intressant for a customer.
Totally Zenned
Hi reza
Well I expect you'll find a way of altering the search function, under certain conditions there is a dropdown for products lists , an 'A B C D ' filter, it sounds like you need that sort of thing somewhere for authors..
I'm not able really to make specific suggestions, it'd take a long time for me to sort it out ..maybe on zencart 1.4 when we all have to totally rewrite our add-ons coding :)
Tell staff why this post should be reviewed.