I have downloaded the MySQL field plugin for CB which i believe is the solution to my problem, the only thing is im not sure how to make it do what i want.
I have a number of numeric fields in my profile which are entered in at registration, but i want to add 15% when people view my profile. I was able to a run basic SQL command from myphadmin that would create this total value and put it in another field which i displayed on the profile i.e.
UPDATE jos_comprofiler
SET cb_prim1s = cb_prim1 * 0.15 + cb_prim1,
cb_teen1s = cb_teen1 * 0.15 + cb_teen1,
cb_gcse1s = cb_gcse1 * 0.15 + cb_gcse1,
The problem is i have to manually run this command from myphadmin each time, but wondered if this is something the MySQL field can do dynamically on each page load.
If so could someone be able to guide me in how to setup the plugin, my SQL knowledge is very limited and i just cant seam to get my head round this basic thing.
