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.
