Many to many relation ship for pagemaster 1.1

Extension type: Plugin
Extension originally created by mumuri on Apr 05, 2009

Description

This plugin is a workaround to handle many-to-many relationship in pagemaster.

Requirement

It's not possible at the moment to create automatic many-to-many relationship with pagemaster, so first you will have to create 1 more pubtype to link 2 existing pubtype.

See schema for details

- Book is the main pubtype

- Author is an external pubtype

- LinkBookAuthor is the pubtype which link "Book" and "author"

LinkBookAuthor have only 2 "publication" fields (one for the "book", the other for the "author")

Sample use

With the above sample string tid_link id of the linked "type of publication"

 * @param       string    tid_link    id of the linked "type of publication"
 * @param        string    tid_link    id of the linked "type of publication"
 * @param         string    tid_pub        id of the pub "type of publication"
 * @param         string    fid_join    field of the linked table to join the linked and external table
 * @param         string    fid_look    field of the linked table to join the linked and current table
 * @param         string    fid_look_value    value of fid look


<!--[ getmanytomanypubs tid_link=9 tid_pub=3 fid_join=author fid_look=book fid_look_value=$core_pid assign=items ]-->
<pre>
<!--[ $items|@print_r ]-->
</pre>

Notes : in order to improve perfomances, you should add indexes on joined field
see http://code.zikula.org/pagemaster/ticket/100#comment:3 for details

Screenshots

TargetGroup

All

Status

Normal