System information

Currency: paypal currency
Transactionid: unique id for all transactions
Stage: 0=unknown,1=started,2=notification received,4=verified and applied,5=failed, 6=need to be checked (no email match)
Comment: contains the reason of the failures and all patameters as received from paypal
Example query to list all transactions that need to be approved from the last week:
select top 1000 tb_users.Username, tb_users.credit as 'usercredit', tb_payprocessing.*
from tb_payprocessing with(nolock)
left join tb_users with(nolock) on (tb_users.id = tb_payprocessing.userid)
where
tb_payprocessing.stage = 6 and
tb_payprocessing.datum > GETDATE()-7
order by datum desc
The transactions can be viewed also from Mizu Manage -> Billing section -> Reports form (Transcations All/Success/Failed/etc)
Applied payments will be also stored in the tb_invoices table.
If you wish to automatically allow all transactions, set the paypal_checkemail and paypal_checktrusted settings to 0. Otherwise some transactions will have
to be applied manually.
For a custom paypal payment start page (pay now button) you have to store it’s html as “paypaltemplate.txt” in the server directory.
Otherwise the default options will be presented.
You can specify the following keywords (replaced runtime): [ACCOUNTID], [USERID], [BACKBTN]
To force the paypal payments to be accepted even from not trusted users, set the following settings:
-paypal_checktrusted: 0
-paypal_checkemail: false
-might increase paypal_checkabove_verified
-might increase paypal_checkabove_all
-might increase paypal_maxamount
-might decrease paypal_minamount
5.106. How to setup a registered SIP server
If the outbound route is on a dynamic IP or behind NAT, then it must register to the server so the server can learn its address.
For this you must create a usual SIP server account and also an enduser account. The server will register to the user account which is “linked” with the SIP
server account.
Use the “PRManager” field to link an enduser account to a sipserver (this have to be set for the enduser)