CAcert Code Development list.

[dirk astrath <dastrath AT gmx.de>]

hiya mario,

i don't think, that it is a good idea to copy the database out of the 
security area to run sql-queries to it ...

we should think about a query telling us how many members are affected by the 
revocation of thawte-points ...

something like

select userid,sum(points),sum(granted) from notary where userid != notaryid 
... ... ...

should then help ... (but while laying in my bed and tyiping this message on 
my g1 i don't think i get a valid sql-syntax for a not-so-easy query ... ;-)  
 )

but maybe you (or somebody else) may be able to put these thoughts to a 
sql-query before i can finish it ... ;-)

have a nice day ...

Mario Lipinski 
<mario AT cacert.org>
 schrieb:

>Hi,
>
>> What would be really useful would be an Arbitration that identified
>> which Tverify people are at risk of losing their Assurance Status on
>> November 16.  Effectively, some SQL to select the group who still have
>> less than 100 points when the TVerify points are set to 0.
>> 
>> Who's a whizz at SQL and understands the nature of the tables?
>
>Would it be possible to set up a read-only access to the database of a
>test system?
>Maybe a public phpMyAdmin would fit this needs.
>
>-- 
>Mit freundlichen Grüßen / Best regards
>
>Mario Lipinski
>Board member,                       E-Mail: 
>mario AT cacert.org
>Organisation Assurer (Germany),     Internet: http://www.cacert.org
>Wiki/Issue admin
>CAcert
>
>Support CAcert: http://www.cacert.org/index.php?id=13
>                http://wiki.cacert.org/wiki/HelpingCAcert
>