Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Sep 14, 2006
  • Posts: 28

  Posted: May 13, 2006 - 05:54 AM

  Greetings, I am writing a module that needs the user's id from the pnuser table. I would like to create a foreign key for my tables but I would need to know the proper way to get the pnuser table name that accounts for changes in table prefix and so on. Essentially I need the pntables result for the user module. How do I get that ?
  
  I would look it up on the API reference but that seems to have VANISHED! :(
  
  TIA.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Sep 14, 2006
  • Posts: 28

  Posted: May 17, 2006 - 11:30 AM

  Wow ... no one cares to reply?

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: May 17, 2006 - 11:12 PM

  How about a simple JOIN SQL ?

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Sep 14, 2006
  • Posts: 28

  Posted: May 19, 2006 - 06:03 AM

  I could do that but then the prefix of the table and table name is hardcoded and that is bad. There should be some way to get thoese names from the API.

  • 
  •  
• **unknown user**
  

  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 1097

  Posted: May 20, 2006 - 01:41 AM

  In 762... using
  

  Code

  $pntable = pnDBGetTables();

  
  
  Will get you the user table information
  
  

  Code

  $usertbl = $pntable['users'];
  $usercol = $pntable['users_column'];

  
  
  In 0.8, you'll need a
  

  Code

  pnModDBInfoLoad('Users');

  
  
  The users table will then be available the same way.
  
  As you said, having your table name hardcoded is bad, if you are building a module, you should have a pntables.php.
  
  
  
  

  • 
  •  
•  
•  

Users on-line

• mesteele101

This list is based on users active over the last 60 minutes.