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.
