DokuWiki

It's better when it's simple

User Tools

Site Tools


user:grosse:pluginrepo

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
user:grosse:pluginrepo [2015-05-16 18:44]
82.66.247.92 created
user:grosse:pluginrepo [2015-05-18 09:56] (current)
79.198.219.23
Line 1: Line 1:
-xzcat b.xz | mysql+[[plugin:​popularity]] 
 +[[plugin:​repository]] 
 +[[:​popularity]] 
 + 
 +<code bash>xzcat b.xz | mysql</​code>​ 
 + 
 +<code bash>​mysql pluginrepo</​code>​ 
 + 
 +<code sql>​select uid,​dt,​value,​count(*)  
 +from popularity  
 +where `key` = '​php_version'​ and `value` like '​5.3.%'​  
 +group by value;</​code>​ 
 + 
 +<code sql>​select uid 
 +from popularity  
 +where `key` = '​php_version'​ 
 +and `value` like '​5.3.%'​  
 +and `dt` between 1429205349 and 1431797350;</​code>​ 
 + 
 + 
 +<code sql> 
 +select value,​count(*) 
 +from popularity 
 +where `key`='​version'​ 
 +and `dt` between 1429205349 and 1431797350 
 +and `uid` in ( 
 +select uid 
 +from popularity  
 +where `key` = '​php_version'​ 
 +and `value` like '​5.3.%'​  
 +and `dt` between 1429205349 and 1431797350) 
 +group by value;</​code>​ 
 + 
 +https://​github.com/​splitbrain/​dokuwiki-plugin-pluginrepo/​blob/​master/​helper/​popularity.php#​L26
user/grosse/pluginrepo.1431794648.txt.gz · Last modified: 2015-05-16 18:44 by 82.66.247.92