37 $res = $ilDB->query(
'SELECT * FROM payment_currencies');
40 while(
$row = $ilDB->fetchObject(
$res))
42 $currencies[
$row->currency_id][
'currency_id'] =
$row->currency_id;
43 $currencies[
$row->currency_id][
'unit'] =
$row->unit;
44 $currencies[
$row->currency_id][
'subunit'] =
$row->subunit;
46 return $currencies ? $currencies : array();
52 $res = $ilDB->queryf(
'
53 SELECT * FROM payment_currencies WHERE currency_id = %s',
54 array(
'integer'), array($a_currency_id));
57 while(
$row = $ilDB->fetchObject(
$res))
59 $currencies[
'currency_id'] =
$row->currency_id;
60 $currencies[
'unit'] =
$row->unit;
61 $currencies[
'sub_unit'] =
$row->subunit;
69 $res = $ilDB->queryf(
'
70 SELECT unit FROM payment_currencies WHERE currency_id = %s',
71 array(
'integer'), array($a_currency_id));
73 while(
$row = $ilDB->fetchObject(
$res))
83 $statement = $ilDB->queryf(
'
84 SELECT subunit FROM payment_currencies WHERE currency_id = %s',
85 array(
'integer'), array($a_currency_id));
87 while(
$row = $ilDB->fetchObject(
$res))