[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetrade
Subject:    SV: SV: [FreeTrade] Buy items from departmentlisting?
From:       "Tom Jakobsen" <tomjako () sporty ! no>
Date:       2000-02-29 19:54:03
[Download RAW message or body]

THANK YOU VERY MUCH ! :)

Worked perfectly. 


----- Original Message ----- 
From: Marek <marek@webplusplus.com>
To: FreeTrade <freetrade@list.working-dogs.com>
Sent: Tuesday, February 29, 2000 3:03 PM
Subject: Re: SV: [FreeTrade] Buy items from departmentlisting?


> Tom Jakobsen wrote:
> > 
> > Thank you for your help:)
> > 
> > Could you send me your "department" file, so i could have a look at it.
> > I get the error message "This item is unavailable at this time."
> > 
> > Thanks
> > 
> > Tom
> 
> Yes, you are right I missed two things.
> 1) function showRelationship(...
> 2) $item = $DatabaseRow->ID;
> 
> 
> 
> "department" file:
> ==================
> <?php
> /*
> ** File: department
> ** Description: show departments and items contained in them
> ** Version: $Revision: 1.11 $
> ** Created: 04/22/1999
> ** Author: Leon Atkinson
> ** Email: leon@clearink.com
> ** CVS Author: $Author: leon $
> ** Last Revised: $Date: 2000/02/02 18:59:48 $
> ** Log : $Log: department,v $
> ** Log : Revision 1.11  2000/02/02 18:59:48  leon
> ** Log : Fixing bugs reported by Ted Henigson.
> ** Log :
> ** Log : Revision 1.10  1999/11/04 21:35:40  leon
> ** Log : Cleaned up the use of paths.  Paths are now all set in
> index.php3 as
> ** Log : constants.  Example settings for Apache/Unix, Apache/Win32,
> and IIS.
> ** Log :
> ** Log : Revision 1.9  1999/10/30 22:07:15  leon
> ** Log : Fixed some problems with images associated with items and
> departments.
> ** Log : Defined the directories for items and departments inside
> global_settings.
> ** Log :
> ** Log : Revision 1.8  1999/10/12 00:39:10  chris
> ** Log : Moving text into constants in preparation of localization
> support.
> ** Log :
> ** Log : Revision 1.7  1999/10/11 23:04:08  leon
> ** Log : Removed all require()'s, added block to stop double
> include()'s
> ** Log :
> ** Log : Require wasn't giving any performance advantage because it was
> always
> ** Log : being called with a variable.  Futhermore, using return inside
> a
> ** Log : require()'d file does not work in PHP4.
> ** Log :
> ** Log : Revision 1.6  1999/08/18 22:32:14  leon
> ** Log : Returning opening PHP tag to XML-friendly tag
> ** Log :
> ** Log : Revision 1.5  1999/07/28 19:27:30  leon
> ** Log : Mass update based on code donation from a live project
> ** Log :
> **
> ** Copyright (c) 1999 Working Dogs.  All rights reserved.
> */
> 
> function showRelationship($Item, $relationship, $description)
> {
> //
> file://** Related items
> //
> $CrossSellCount=0;
> if(isset($Item['Relationship'][$relationship]))
> {
> $CrossSellCount = count($Item['Relationship'][$relationship]);
> }
> 
> if($CrossSellCount > 0)
> {
> print("<BR>\n");
> print("$description\n");
> print("<UL>\n");
> 
> for($n=0; $n<$CrossSellCount; $n++)
> {
> $RelatedItem =
> GetItemInfo($Item['Relationship'][$relationship][$n]);
> 
> print("<LI><A HREF=\"".ScreenURL('item', FALSE,
> array('item'=>$RelatedItem['ID']))."\">");
> 
> print($RelatedItem['Name']);
> 
> print("</A>");
> } 
> 
> print("</UL>\n");
> } 
> 
> 
> }
> $department = intval($department);
> 
> file://show sub-departments
> $Query = "SELECT ID, Name, Graphic, Description ";
> $Query .= "FROM department ";
> $Query .= "WHERE Parent=$department ";
> $Query .= "ORDER BY DisplayPrecedence, Name ";
> $DatabaseResult = mysql_query($Query, $DatabaseLink);
> while($DatabaseRow = mysql_fetch_object($DatabaseResult))
> {
> print("<A HREF=\"" . ScreenURL("department") .
> "&department=$DatabaseRow->ID\">");
> 
> if(($DatabaseRow->Graphic) AND file_exists(DEPARTMENT_IMAGES_DIR . '/'
> . $DatabaseRow->Graphic))
> {
> $department_Graphic_size = getimagesize(DEPARTMENT_IMAGES_DIR . '/' .
> $DatabaseRow->Graphic);
> 
> print("<IMG SRC=\"" . DEPARTMENT_IMAGES_DIR . '/' .
> $DatabaseRow->Graphic . "\"");
> print(" $department_Graphic_size[3] BORDER=\"0\" ALIGN=\"left\">\n");
> }
> 
> print("<B>$DatabaseRow->Name</B>");
> 
> print("</A>");
> print("<BR>\n");
> 
> print($DatabaseRow->Description);
> print("<BR CLEAR=\"all\">\n");
> print("<BR>\n");
> 
> 
> }
> 
> 
> file://show items in this department
> $Query = "SELECT i.ID, i.Name, i.Thumbnail ";
> $Query .= "FROM item i, department_item di ";
> $Query .= "WHERE di.Department = $department ";
> $Query .= "AND i.ID = di.Item ";
> $Query .= "ORDER BY i.DisplayPrecedence, i.Name ";
> $DatabaseResult = mysql_query($Query, $DatabaseLink);
> while($DatabaseRow = mysql_fetch_object($DatabaseResult))
> {
> print("<A HREF=\"".ScreenURL("item")."&item=$DatabaseRow->ID\">");
> if(($DatabaseRow->Thumbnail) AND 
> file_exists(ITEM_IMAGES_DIR . "/" . $DatabaseRow->Thumbnail))
> {
> $Thumbnail_Graphic_size = getimagesize(ITEM_IMAGES_DIR . "/" .
> $DatabaseRow->Thumbnail);
> print("<IMG SRC=\"" . ITEM_IMAGES_DIR . "/" . $DatabaseRow->Thumbnail
> . "\"");
> print(" $Thumbnail_Graphic_size[3] BORDER=\"0\" ALIGN=\"left\">\n");
> }
> print("<B>$DatabaseRow->Name</B>");
> print("</A>");
> print("<BR CLEAR=\"all\">\n");
> print("<BR>\n");
> $item = $DatabaseRow->ID; 
> include(APPLICATION_ROOT . "modules/screens/item_dep");
> }
> 
> ?>
> 
> 
> ------------------------------------------------------------
> To subscribe:    freetrade-on@list.working-dogs.com
> To unsubscribe:  freetrade-off@list.working-dogs.com
> Site:            http://www.working-dogs.com/freetrade/
> Problems?:       jon@working-dogs.com
> 



------------------------------------------------------------
To subscribe:    freetrade-on@list.working-dogs.com
To unsubscribe:  freetrade-off@list.working-dogs.com
Site:            http://www.working-dogs.com/freetrade/
Problems?:       jon@working-dogs.com

[prev in list] [next in list] [prev in thread] [next in thread]