Search for transactions

[gaga]

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

Thanks

 

[Jeremy P]

You can find active and expired upgrade records in xf_user_upgrade_active and xf_user_upgrade_expired respectively.

 

[gaga]

How to get a total amount of all purchases active and expired?

 

[Roka]

I think addon Payments it's what you need

 

[gaga]

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.