You are here:  » New Version Released


New Version Released

Submitted by support on Sun, 2006-03-26 11:27 in
Submitted by searley on Sun, 2006-03-26 12:05

Yes been watching it develop for a few days

Front Page

Is it possible to selct the number of items to show, 4 in your example, but select say 10 featured products, and them randomly show??

Index pages

i think it should be the A B C running downwards in colum 1, then D E F in colum 2 etc, i have had another site similar to the layout you have created, when there are lots of records, it no longer looks like an alphabetical list

Submitted by support on Sun, 2006-03-26 12:12

hehe I wondered if anybody would have a guess at the URL :)

Re: Front Page
The number of featured products is not fixed. Within the admin section there is a textarea where you simply list the products you wish to display on the front page; so it's just however many there are in your list.

Re: Index pages
Here's the plan. Once this version of Price Tapestry is released and been through a burn-in phase that should get any lil' bugs out of the way I intend to freeze the feature set; pretty much permanently. I'll then create a new area of the site from where you can download patches and mods; for example an alternative atoz.php file that will display the index in the way you describe.

At the same time, I will remove the "Feature Requests" forum and replace it with a "Customisation Help" forum; where people can post what they'd like to change and get help with the PHP code required to make the mod. New users would then be able to browse that forum post-install and incorporate any changes that they like.

Submitted by searley on Sun, 2006-03-26 12:14

On the products and search page page, apply ALT text to the images of the product name

On the search results page hyperlink the product image to the product info page with border=0

is the widths of tables etc easily set?

Submitted by searley on Sun, 2006-03-26 12:17

Wasnt much of a guess, as its the same as you used previouly

re front page,

I have seen the select boc in admin...
say i put 10 products in that list, but onlt want 4 at a time on the front page, will it randomly show the 10?

Submitted by support on Sun, 2006-03-26 12:20

Re: alt text and image links:
Will include that before release.

Re: table widths:
All configurable within CSS now rather than being hard coded

Re: random featured products
That's the sort of requirement that I would see as a customisation mod. In this case, it would be an easy hack in index.php - you'd just need to add "ORDER BY RAND() LIMIT 4" to the SQL statement that selects the featured products for display.

Submitted by support on Sun, 2006-03-26 12:25

please note everybody that i'm deleting reviews rather than accepting them so that the visual appearance is consistent for everybody browsing the beta site - it's nothing personal ;)

Submitted by searley on Sun, 2006-03-26 12:28

Well i have to say, all looks pretty good..

difficult to tell too much more until installed and played with

during setup, will we have to delete the existing sqlDB and start again, or will there be and update script?

Submitted by support on Sun, 2006-03-26 12:34

Re: update SQL script
I think this should be feasable as there have only been additions to the products table rather than fundamental changes. The feeds and filters tables are unchanged, and there are a couple of new tables. If it's going to be straight forward i'll create an "upgrade.php" and associated "upgrade.sql" script to use instead of setup.php and database.sql.

Submitted by dflsports on Mon, 2006-03-27 17:43

The new script is looking good though a bit of a tease since we cannot use it yet :)

Submitted by support on Mon, 2006-03-27 17:45

Hehe, sorry about that. I'm actually just about ready to release it; i'm working on the distribution right now, and will have it available later this evening (Monday).

Submitted by support on Mon, 2006-03-27 20:41

New version is now the current distribution.

There will be a lag whilst online documentation, screenshots etc. catch up and the demo admin site will be back up shortly. Unfortunately it is not practical to upgrade an existing database. This is because it would be necessary to insert new fields into every product record which would leave the database seriously fragmented and greatly reduce performance if you have any more than a few hundred products.

Submitted by henk on Mon, 2006-03-27 22:28

quick one sql tekst is not correct
is
CREATE TABLE reviews (
id int(11) NOT NULL auto_increment,
created int(11) NOT NULL default '0',
approved int(11) NOT NULL default '0',
product_name varchar(255) NOT NULL default '',
rating int(11) NOT NULL default '0',
comments text NOT NULL,
PRIMARY KEY (id),
KEY product_name (product_name),
) TYPE=MyISAM;

must be

CREATE TABLE reviews (
id int(11) NOT NULL auto_increment,
created int(11) NOT NULL default '0',
approved int(11) NOT NULL default '0',
product_name varchar(255) NOT NULL default '',
rating int(11) NOT NULL default '0',
comments text NOT NULL,
PRIMARY KEY (id),
KEY product_name (product_name)
) TYPE=MyISAM;

i think

HEnk

Submitted by support on Mon, 2006-03-27 22:34

Yes - it should! Didn't get overwritten by the database dump for some reason! Sorted now...