[include:'macros/preferences.lasso']
Water Works Wonders Sponsors Redirect
[inline:
-database=($dbName),
-sql='select id, clicks, publicContactURL from rbf_stakeholders where id = '+$id,
-clientusername=(Decode_Base64:(var:'clientName')),
-clientpassword=(Decode_Base64:(var:'clientPass'))]
[If: (Error_CurrentError) == (Error_NoError)]
[var:'clicks'=(integer:(field:'clicks')) + 1]
[if:var:'URL'=='']
[var:'URL'=(field:'PublicContactURL',encodenone)]
[/if]
[Else]Error: [Error_CurrentError][/If]
[/inline]
[inline:
-database=($dbName),
-table='rbf_stakeholders',
-keyfield='id',
-keyvalue=(var:'id'),
'clicks'=$clicks,
-clientusername=(Decode_Base64:(var:'clientName')),
-clientpassword=(Decode_Base64:(var:'clientPass')),
-update]
[If: (Error_CurrentError) == (Error_NoError)]
[Else]Error: [Error_CurrentError][/If]
[/inline]
[redirect_url:$URL]