Hello!
Each member has a "reaction score."
I have created a custom field called "Gold" in the Personal Details section of the profile.
I would like to have the reaction score auto-fill in to the Gold field ONE TIME (like, I run a cron job?) and then I would like to be able to manually edit that field as Admin, but NOT have it ever auto-update again.
Possible?
Reason: Am telling this because others might find it useful or funny. Am awarding each member "gold" based on their reaction scores. They will be able to use this gold to gamble on writing competitions at our website. There will be no monetary value to the gold, no money exchanged, etc. However, let's say one member has 1,000 gold and he bets on Member 247 to win, bets 100 gold. To start, I need him to have the 1,000 gold in his account (the reason for the one-time auto-fill above), and then if he wins, I will manually edit and add 100 gold. What I don't want to happen is for the auto-fill to reset him back to 1,000 or thereabouts.
If this cannot be done, I can handle it manually, but as you can imagine, that will take a bunch of extra effort.
IF THERE IS AN SQL solution, and someone can provide the SQL statement, as best they can, I have a programmer who could assist me in running this. Just a thought.
Thank you in advance, and, GO HUSKIES! (UConn girls basketball team)
Rob
Each member has a "reaction score."
I have created a custom field called "Gold" in the Personal Details section of the profile.
I would like to have the reaction score auto-fill in to the Gold field ONE TIME (like, I run a cron job?) and then I would like to be able to manually edit that field as Admin, but NOT have it ever auto-update again.
Possible?
Reason: Am telling this because others might find it useful or funny. Am awarding each member "gold" based on their reaction scores. They will be able to use this gold to gamble on writing competitions at our website. There will be no monetary value to the gold, no money exchanged, etc. However, let's say one member has 1,000 gold and he bets on Member 247 to win, bets 100 gold. To start, I need him to have the 1,000 gold in his account (the reason for the one-time auto-fill above), and then if he wins, I will manually edit and add 100 gold. What I don't want to happen is for the auto-fill to reset him back to 1,000 or thereabouts.
If this cannot be done, I can handle it manually, but as you can imagine, that will take a bunch of extra effort.
IF THERE IS AN SQL solution, and someone can provide the SQL statement, as best they can, I have a programmer who could assist me in running this. Just a thought.
Thank you in advance, and, GO HUSKIES! (UConn girls basketball team)
Rob
