I think for the time being you can ignore expavg_credit. It will adjust itself with the next wus.
Kunsheng Chen wrote: > 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. >> >> > > -- > Rate Me <http://boinc.ssl.berkeley.edu/help_vol.php?volid=29>, > MySkype (yoyo_rkn)Skype Me™! <skype:yoyo_rkn?chat> , myICQ > 139003243 , myIRC > ------------------------------------------------------------------------ > Rechenkraft.net e.V. <http://www.rechenkraft.net> - Verein zur > Förderung von Bildung, Forschung und Wissenschaft durch Einsatz > vernetzter Computer > weitere interessante Projekte > <http://www.rechenkraft.net/wiki/index.php?title=Projekt%C3%BCbersicht>und > Hilfe <http://www.rechenkraft.net/phpBB/viewforum.php?f=19>auf > unserer Webseite www.Rechenkraft.net <http://www.rechenkraft.net> > und im Chat > ------------------------------------------------------------------------ > Rechenkraft.net - Germany's largest distributed computing > community. We make those things possible that supercomputers don't. > > -- Rate Me <http://boinc.ssl.berkeley.edu/help_vol.php?volid=29>, MySkype (yoyo_rkn)Skype Me™! <skype:yoyo_rkn?chat> , myICQ 139003243 , myIRC <irc://irc.euirc.net/rechenkraft> ------------------------------------------------------------------------ Rechenkraft.net e.V. <http://www.rechenkraft.net> - Verein zur Förderung von Bildung, Forschung und Wissenschaft durch Einsatz vernetzter Computer weitere interessante Projekte <http://www.rechenkraft.net/wiki/index.php?title=Projekt%C3%BCbersicht>und Hilfe <http://www.rechenkraft.net/phpBB/viewforum.php?f=19>auf unserer Webseite www.Rechenkraft.net <http://www.rechenkraft.net> und im Chat <irc://irc.euirc.net/rechenkraft> ------------------------------------------------------------------------ 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.
