Re: [mv] Using MiniVend as a catalog of businesses and SQL Config

[Roger Arnold <rbarnold@a-dream.com.au>]

******    message to minivend-users from Roger Arnold <rbarnold@a-dream.com.au>     ******

Roger Arnold wrote:

Thanks for the help Barney, but I think I may need a bit more, if you don't mind that is.

What I need is a copy of a  a catalog.cfg (working version) without database names and
confidential information of course, so that I can compare it to mine and see where I have
gone wrong.

The problem seems to be that minivend refuses to work with anything other than it's own
database and won't allow the setting up of tables in MySQL.

Again thanks for the help so far, it has been like a light being turned on :-)

Thanks in advance
Roger

Barney Treadway wrote:

> ******    message to minivend-users from Barney Treadway <barney@wttech.com>     ******
>
> Hi Roger,
>
> Oh my, I get to answer a question rather than plead for help! Too bad the
> answer will probably be wrong.
>
> The site I'm building has a list of members of which I use Minivend to
> present and search. I decided NOT to use the productsdb at all but use a new
> mysql db called clients. This is possibly more in depth than you care but as
> a newbie, I love getting details so here they are. merchantcat is the
> category, merchanturl is their website,and comment is a place where they can
> describe their business, rest should be intuitive. The Mysql table is
> configured thusly: (yeah I suppose username should be unique too, hmmmm)
> ________
>
> CREATE TABLE clients (
>    id mediumint(9) DEFAULT '0' NOT NULL auto_increment,
>    accounttype varchar(128),
>    merchant varchar(128),
>    merchantcat varchar(128),
>    merchanturl varchar(128),
>    logo varchar(128),
>    address1 varchar(128),
>    address2 varchar(128),
>    city varchar(128),
>    state varchar(128),
>    country varchar(128),
>    zip varchar(128),
>    phone varchar(128),
>    fax varchar(128),
>    tollfree varchar(128),
>    contact varchar(128),
>    contactemail varchar(128),
>    comment longtext,
>    username tinytext NOT NULL,
>    password tinytext NOT NULL,
>    UNIQUE id (id),
>    KEY id_2 (id)
> );
>
> _____________
>
> Then my catalog.cfg file has this line:
> Database            clients      clients.asc
> dbi:mysql:databasename:localhost:3306
> also:
> Database            clients DELIMITER    TAB
> Database            clients LongReadLen  128
> (which I don't have any idea what it does)
> and finally:
> # Not needed unless your database requires a login
> Database            products USER   username
> Database            products PASS   mypassword
> ______________
>
> Then I can hit the db with links like this:
> <A HREF="[area scan
> fi=clients
> se=accommodation
> ml=6
> st=sql
> sp=members
> sf=merchantcat]"><B>Accomodations</B></A>
> to list all merchants with merchantcat of accomodation and display using a
> special members results page. This page shows merchants with link and
> comment like so:
> inside my [search list] doodad.....
>  <TD VALIGN="top" COLSPAN="2"><FONT SIZE="3">
>   Website: <A HREF="[item-data clients merchanturl]">[item-data clients
> merchanturl]</A></TD>
> <tr><tr>
> <TD VALIGN="top" COLSPAN="2">
> Email: <a href="mailto:[item-data clients contactemail]">
> [item-data clients contactemail]</a></TD>
> </TR><TR>
> <td><FONT SIZE="2">phone: [item-data clients phone]</font></td>
> <td><FONT SIZE="2">fax: [item-data clients fax]</font></td>
> </TR><TR>
> <td colspan=2><FONT SIZE="2">[item-data clients address1]</font></td>
> </TR><TR>
> <td colspan="2">[item-data clients city], [item-data clients state]
> [item-data clients zip]</td>
> </TR><TR>
> <TD COLSPAN="2"><hr>
>  [item-data clients comment]
>  </TD>
> etc etc....
> ________________
>
> Hope this helps........
>
> Barney Treadway
> WT Technologies
> barney@wttech.com
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list