Re: Joining users to another table

Lukas Smith <[email protected]>
Newsgroups gmane.comp.php.pear.liveuser
Organization BackendMedia GbR
Message-ID <[email protected]>
Dan Rossi wrote:

> Uhh a little bit confusing but this is just global config settings ?  I 
> need to collect data from the customer directory once the customer is 
> logged in, would would have to either search for the record with their 
> userID or the customerID.

ok let me elborate a bit more.
the admin package has a sql query generator.
if you add new fields and tables (and add necessary join points to 
existing tables) you can magically use these fields/tables in your code.

one thing i forgot though. for performance reasons the liveuser_admin 
methods always try to limit the number of potential tables that are 
allowed to be joined in the given method call. therefore you would also 
need to add a config option stating the possible tables per method:

$this->selectable_tables['getUsers'][] = 'foobar';

alternatively you can also just pass a "selectable_tables" array in the 
permcontainer config array, because this data will then be merged with 
the defaults.

regards,
Lukas Smith
[email protected]
_______________________________
   BackendMedia
   www.backendmedia.com
   [email protected]

   Linn Zwoch Smith GbR
   Pariser Str. 44
   D-10707 Berlin

   Tel +49 30 83 22 50 00
   Fax +49 30 83 22 50 07
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.