I have a script that I run for a Paid to Read Email site.
My current member settings allow for earning both points
and cash. I need a way to convert all cash to an equivalent number of points or add bonus points for converting to cash.
This is something I want to run against the entire database at one time, not on a user by user basis, there is already a script / mysql statement to that.
example: accounting table has field points and cash.
I want to take all cash and convert to points
at a ratio of 500 points per $ 1.00 and add
that to current points value.
member "A" has $ 23.68 cash and 150 points
23.68 x 500 = 11890 + 150 = 12040
member cash now = 0
member points now = 12040
Payment will be escrowed until script / statement is
confirmed to work.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Tuesday Jan 17, 2006 2:52:17 PM:
I am extending bid as I feel that bids are too high for script needed.
I would like anyone that is still interested to please rebid.
Thanks
* * *This broadcast message was sent to all bidders on Friday Jan 20, 2006 12:28:14 PM:
This is for clarification:
The actual table name being edited
is Accounting
The fields to be edited are named cash
and points.
This must be a php script or I preferr a MySql statement.
Final review and award will be made today, Friday Jan 20 by 12 noon central time US
## Platform
MySql