Search for transactions

gaga

Member
Hi to all,
I would like to search for all user upgrade transactions.
WHERE this information is stored (which table)?

Thanks
 

Jeremy P

Well-known member
You can find active and expired upgrade records in xf_user_upgrade_active and xf_user_upgrade_expired respectively.
 

gaga

Member
I need more help, please.

How to fatch() all records, if a value is 0

e.x
$myID = $this->filter('my_id', 'uint'); // select field
if ($myID == 0)
{
$finder = \XF::finder('XF:UserUpgradeActive');
$result = $finder
->fetchOne();
userTestId = $result['user_upgrade_id']
}
else{

$userTestId = $myID ;
}

$finder = \XF::finder('XF:UserUpgradeActive');
$results = $finder
->where('user_upgrade_id', '=', $userTestId)
->order('start_date', 'ASC')
->fetch();
if $MyID !=0 need show selected with dropdown (select), but if $MyID == 0 I need to show all data from table.
 
Top