PHP Link Directory Plugin Etc

[kickoff3pm]

Tweet

Anyone any experience of pulling in AF links into the directory software Phplinkdirectory ?

I want to pull a few products based on the category into the header of each category for a shopping directory I'm currently working on.

[jamie07051975]

Anyone any experience of pulling in AF links into the directory software Phplinkdirectory ?

I want to pull a few products based on the category into the header of each category for a shopping directory I'm currently working on.

Not had any previous experience with PHPLinkDiretcory but I'm sure it would be pretty easy to do. I'm presuming you're using a feed of some sort and the directory uses a database of some sort. If that's the case it should be quite easy to do - let me know and I'll give you some pointers.

[kickoff3pm]

Not had any previous experience with PHPLinkDiretcory but I'm sure it would be pretty easy to do. I'm presuming you're using a feed of some sort and the directory uses a database of some sort. If that's the case it should be quite easy to do - let me know and I'll give you some pointers.

Well yes to both, here the category table for the directory;

CREATE TABLE IF NOT EXISTS `PLD_CATEGORY` (
`ID` int(11) NOT NULL auto_increment,
`TITLE` varchar(255) NOT NULL default '',
`CACHE_TITLE` text,
`TITLE_URL` varchar(255) default NULL,
`CACHE_URL` text,
`DESCRIPTION` longtext,
`TDESCRIPTION` longtext,
`CATCONTENT` longtext,
`PARENT_ID` int(11) NOT NULL default '0',
`STATUS` int(11) NOT NULL default '1',
`DATE_ADDED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`HITS` int(11) NOT NULL default '0',
`SYMBOLIC` int(11) NOT NULL default '0',
`SYMBOLIC_ID` int(11) NOT NULL default '0',
`META_KEYWORDS` text,
`META_DESCRIPTION` text,
`CLOSED_TO_LINKS` int(11) NOT NULL default '0',
`CLOSED_TO_ARTICLES` int(11) NOT NULL default '0',
`SORT_ORDER` int(11) NOT NULL default '1000',
`RSS_URL` text,
PRIMARY KEY (`ID`),
KEY `PLD_CATEGORY_TITLE_IDX` (`TITLE`),
KEY `PLD_CATEGORY_TITLE_URL_IDX` (`TITLE_URL`),
KEY `PLD_CATEGORY_PARENT_ID_IDX` (`PARENT_ID`),
KEY `PLD_CATEGORY_STATUS_IDX` (`STATUS`),
KEY `PLD_CATEGORY_HITS_IDX` (`HITS`),
FULLTEXT KEY `PLD_CATEGORY_DESCRIPTION_IDX` (`DESCRIPTION`),
FULLTEXT KEY `PLD_CATEGORY_META_KEYWORDS_IDX` (`META_KEYWORDS`),
FULLTEXT KEY `PLD_CATEGORY_META_DESCRIPTION_IDX` (`META_DESCRIPTION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores all the categories with informations' AUTO_INCREMENT=408 ;

And I suppose I would start with one affiliate, lets try AFW's datafeed, the table for that would include theres;

merchant_id
merchant_name
aw_product_id
merchant_product_id
upc
ean
mpn
isbn
model_number
product_name
description
specifications
promotional_text
merchant_category
category_id
category_name
language
brand_name
merchant_deep_link
merchant_thumb_url
merchant_image_url
aw_deep_link
aw_thumb_url
aw_image_url
delivery_time
valid_from
valid_to
currency
search_price
store_price
rrp_price
display_price
delivery_cost
web_offer
pre_order
in_stock
stock_quantity
is_for_sale
warranty
condition
product_type
parent_product_id
commission_group

I would then want to match my categories to those of the feed and show say 3 items at the top of each category.