Hello!

I am storing user ID in a DB table. I need a way to pull the user name based on this ID. I could do a join with this table and the users table... But is there a simpler way to do this?

If I retrieve the user ID from the table, is there a XOOPS class I can use to retrive the user name?

JMass

XoopsUser::getUnameFromId($uid);

Hmmmm... getUnameFromId.....

That almost makes sense!

Thanks again Mith!


JMass

Sorry to be dense, but is this correct?

$TicketUpdateUID = $ticket->getTicketUpdateUID( $TicketID );
$TicketUpdateUname = XoopsUser::getUnameFromId($TicketUpdateUID);

Do I need a particular include?

I know $TicketUpdateUID returns a valid user ID.

JMass

hmmm - your getTicketUpdateUID function requires the ticketID? Isn't a ticket object identified by the ticketID? (off topic, sorry)

You should not need a particular include, since the XoopsUser class is included in common.php

So yes, it looks correct

Off topic not a problem (work great by the way, THANKS!)

Function of ticket object:
--------------------------
function getTicketUpdateUID( $TicketID )
{
global $xoopsDB;
$ret = array();
$query_table = $xoopsDB->prefix('obsclient_tt_ticketdata');
$sql = "SELECT UpdateUID FROM $query_table WHERE TicketID = $TicketID";
$result = $xoopsDB->query($sql);
$myrow = $xoopsDB->fetchArray($result);
$ret = $myrow['UpdateUID'];
if( $ret == "" )
{
$ret = "Unknown";
}
return $ret;
}

Table:
------
#
# Table structure for table `obsclient_tt_ticketdata`
#
CREATE TABLE obsclient_tt_ticketdata (
TicketID int(10) NOT NULL auto_increment,
UID int(10) NOT NULL default '0',
StatusID int(10) NOT NULL default '0',
ClientID int(10) NOT NULL default '0',
CategoryID int(10) NOT NULL default '0',
EntryDate date NOT NULL default '0000-00-00',
TicketHours decimal(10,1) NOT NULL default '0',
TicketDetails text NOT NULL default '',
UpdateDate date NOT NULL default '0000-00-00',
UpdateUID int(10) NOT NULL default '0',
PRIMARY KEY (TicketID)
) TYPE=MyISAM;

As you can see, I am retrieving the ID of the last person to update a particular ticket. Therefore, the ticket ID is needed as it is the primary key of the ticket table, and the only unique identifier of the ticket object.

Make sense? Wrong way to do this?

JMass