If you look in html/ops, I believe there is a "grant_credit.php" script that you can edit to do what you want. It will handle all of the fields. Just change the query in the "grant_credit_for_cancelled()" function.
Eric On Thu, Nov 5, 2009 at 12:03 PM, Kunsheng Chen <[email protected]> wrote: > Or is there some other way to do that besides Mysql. > > Basically what I want is to give credits for tasks with 'workunit error' in > validate_state, on OPS page there are statistics chart for that. I am > wondering if I could do it through GUI ? > > --- On Thu, 11/5/09, Kunsheng Chen <[email protected]> wrote: > >> From: Kunsheng Chen <[email protected]> >> Subject: Re: [boinc_dev] About grant credits in Mysql >> To: "yoyo" <[email protected]> >> Cc: [email protected] >> Date: Thursday, November 5, 2009, 8:01 PM >> How could I take care of the >> expavg_credit in user table? >> >> >> For total_credit , I can do something like that: >> >> update user set total_credit = 10*(select count(*) from >> result where validate_state = 3 where userid = user.id), >> >> but that expavg_credit is equals to credits/num of tasks... >> most of which might be deleted by the database already ? >> >> --- On Wed, 11/4/09, yoyo <[email protected]> >> wrote: >> >> From: yoyo <[email protected]> >> Subject: Re: [boinc_dev] About grant credits in Mysql >> To: "Kunsheng Chen" <[email protected]> >> Cc: [email protected] >> Date: Wednesday, November 4, 2009, 6:15 PM >> >> >> >> >> >> >> You must also add these credits in the user- and team >> table. >> >> >> >> Kunsheng Chen wrote: >> >> I am thinking of granting credits for users >> mannually in mysql. am wondering if it is enough if I just >> update 'granted_credit' inside table result ? Or some other >> consistency have to be made too ? >> >> >> Thanks, >> >> -Kun >> >> >> >> _______________________________________________ >> boinc_dev mailing list >> [email protected] >> http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev >> To unsubscribe, visit the above URL and >> (near bottom of page) enter your email address. >> >> >> >> >> >> -- >> >> >> sig >> Rate >> Me, MySkype (yoyo_rkn) >> , myICQ 139003243 , myIRC >> Rechenkraft.net e.V. - >> Verein >> zur Förderung von Bildung, Forschung und >> Wissenschaft durch Einsatz vernetzter Computer >> >> >> weitere interessante Projekte >> und Hilfe >> auf unserer Webseite www.Rechenkraft.net >> und im Chat >> >> Rechenkraft.net >> - Germany's >> largest distributed computing community. We make those >> things possible >> that supercomputers don't. >> >> >> >> >> >> >> >> >> >> _______________________________________________ >> boinc_dev mailing list >> [email protected] >> http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev >> To unsubscribe, visit the above URL and >> (near bottom of page) enter your email address. > > > > _______________________________________________ > boinc_dev mailing list > [email protected] > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. > _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
