Re: Users link to LBF

[Aaron Turner <aturner@linuxkb.org>]

On Wed, 18 Aug 1999, Jason Pincin wrote:

[snip]

> You'll need a CompanyKBUserRef table... and in there you'll have two
> columns only which combined will be your primary key, as well as an index
> on each column.  One will be CompnayID and the other will be KBObjectID.  

Dude, next time try speaking in Latin, German, French, or Russian.  I
don't know any of those languages, but at least I can buy a dictionary to
convert it back into English. :-)  Seriously, I have no clue what the
heck you're talking about.  Hence if you could find the time to create the
table, that would be great.  Then tell me what the hell do I do with it.
:-)
 
> That will track what users belong to what company eventually... We'll have
> to figure out how you want to handle that in the long run since I don't
> think ya wanna code the KB portion in Perl - since all the objects are in
> PHP... and if I change the DB structure everything would be fine 'cpet the
> LBF.

Hmmm... dunno.  It is a quandry.  I don't want to create a great deal of
work for others, but I'm in no position to learn PHP right now to do it
myself.  How hard would it be for someone who knows PHP (Micah?) to:

Create a web page in php that accepts a list of UserID's.  (I'd get them
via a modperl query from the LBF table you just mentioned).  From this
list, you'd return a HTML page that lists:

[handle_of_user]:[email_of_user]:[Vaild_URL_to_article]

for each article written by each User.  So, if I send 5 UserID's and each
wrote 5 articles, I'd get back 25 records.  I would read these records
into an array of hashes in Perl and I'm happy as a clam.

-Aaron, who's fighting every step along the treacherous path of learning
SQL. 

--
Aaron Turner, Core Developer       http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization  http://linuxkb.org/
Because world domination requires quality open documentation.