Bernhard Riedl

has been resolved by the wp 2.8 widget api and the WP_Widget class.

berny

hi didier,

thanks for your reply. today i worked out the necessary code and tested it within generalstats. it counts all users in the sabre table with status ‘ok’ and adds the cardinality of the residual set of all users in the wp users’ table which are not stored in the sabre_table. imho that should do the job, until someone forgets to import the users into sabre as mentioned in your faq’s. 😉

$q="SELECT COUNT(u.ID) FROM $wpdb->users as u, ".SABRE_TABLE." as s WHERE u.ID=s.user_id AND s.status in ('ok') UNION SELECT COUNT(u.ID) FROM $wpdb->users as u LEFT JOIN ".SABRE_TABLE." as s ON u.ID=s.user_id WHERE s.user_id IS NULL";

$results = $wpdb->get_col($q);
$userCount=$results[0]+$results[1];

in addition we could use the function has_cap(), but that shouldn’t be necessary. – what do you think?

btw. from a oo point of view i really like your suggestion, that you provide a global function within sabre. if you like to, you could use the code above…

anyway, after realization of the count function either in my or your plugin, i also plan to link sabre in my readme.txt file and also make a small remark within the php code. which link do you prefer – your page or the wordpress plugin page?

greetz,
berny

hi sergio,

the xhtml-issues are due to the fact that the name attribute isn’t allowed to start with a number. – nevertheless, in my example, i used the original ieee-bibtex-key of this paper. inbetween, i solved it by changing the bibtex keys and the bib2html template. maybe you want to include a prefix in your std-template in future versions.

imho another important feature would be to sort the entries by date, as also mentioned in your webpage comments.

cheers,
berny

here is the full example:

<li><a name="10.1109/HICSS.2008.366"></a>
<div>B. Riedl, V. Grascher, S. Fenz, and T. Neubauer, &quot;Pseudonymization for improving the Privacy in e-Health Applications,&quot; in <em>Proceedings of the Forty-First Hawai’i International Conference on System Sciences</em>, Los Alamitos, CA, USA,  2008, p. 255.</div>
<div class="bibtex" id="10.1109/HICSS.2008.366">
         <code>@INPROCEEDINGS{10.1109/HICSS.2008.366, <br />
 &nbsp;&nbsp;author = {Bernhard Riedl AND Veronika Grascher AND Stefan Fenz AND Thomas Neubauer}, <br />
 &nbsp; title = {Pseudonymization for improving the Privacy in e-Health Applications}, <br />

 &nbsp; booktitle = {Proceedings of the Forty-First Hawai’i International Conference on System Sciences}, <br />
 &nbsp; year = {2008}, <br />
 &nbsp; pages = {p. 255}, <br />
 &nbsp; address = {Los Alamitos, CA, USA}, <br />

 &nbsp; publisher = {IEEE Computer Society}, <br />
 &nbsp; doi = {http://doi.ieeecomputersociety.org/10.1109/HICSS.2008.366}, <br />
 &nbsp; issn = {1530-1605}, <br />
 &nbsp; url = {http://www.neotrinity.at/publications/2008/pseudonymization-for-improving-the-privacy-in-e-health-applications/}<br />

}</code>
    </div>
<div><a href="#10.1109/HICSS.2008.366" class="toggle">bibtex</a>  <a href='http://www.neotrinity.at/publications/2008/pseudonymization-for-improving-the-privacy-in-e-health-applications/' title='Go to document'><img src='http://www.neotrinity.at/wp-content/plugins/bib2html/external.png' width='10' height='10' alt='Go to document' /></a> </div>
</li>