XProfan

'prf_ides' ('id', 'nam', 'fid', 'tid', 'removed', 'removed-tme', 'removed-by', 'removed-why') VALUES
(1,'XProfEd',113,0,0,0,0,0),
(2,'LemonEd',0,23008,0,0,0,0),
(3,'XProfed32a',0,8141,0,0,0,0),
(4,'TextPad',0,0,0,0,0,0),
(5,'PRFellow',0,8146,0,0,0,0);

'prf_xprofans' ('id', 'nam', 'ver') VALUES
(1,'XProfan 8',8),
(2,'XProfan 9',9),
(3,'XProfan 10',10),
(4,'XProfan 11',11),
(5,'XProfan X2',12),
(6,'FreeProfan',13),
(7,'XProfan X3',14);

'prf_users_devenvs' ('uid', 'xprf', 'ide') VALUES
(1,5,4),
(11,5,4),
(1598,5,3),
(916,5,3),
(355,5,2),
(285,5,1),
(2435,4,1),
(5,5,1),
(20,5,1),
(417,5,1),
(682,5,3),
(1494,1,4),
(2387,4,1),
(121,5,5),
(1031,5,1),
(87,5,1),
(2850,2,1),
(2960,4,1),
(3067,4,1),
(421,3,1),
(649,4,1),
(3162,5,2),
(2274,5,1),
(416,5,1),
(3446,2,2),
(1509,5,2),
(240,5,2),
(950,1,1),
(1930,4,1),
(3604,4,1),
(156,4,1),
(3635,5,1),
(103,5,2),
(3700,5,1),
(26,4,1),
(868,5,2),
(3477,4,2),
(280,5,2),
(2208,2,1),
(897,4,1),
(19,5,3),
(47,5,3),
(3928,3,1),
(3942,2,1),
(260,4,2),
(246,5,2),
(3941,5,2),
(3994,5,1),
(4022,2,3),
(3933,5,1),
(4045,5,3),
(4056,5,1),
(4057,5,1),
(910,5,1),
(177,5,2),
(4100,5,2),
(4126,2,2),
(500,5,3),
(4211,2,1),
(4146,5,1),
(4226,5,1),
(4159,6,3),
(4009,5,1),
(571,5,1),
(4430,4,1),
(1604,5,2),
(744,5,1),
(992,3,1),
(4469,5,1),
(1325,4,1),
(4094,5,2),
(4527,4,1),
(8,5,1),
(1486,4,1),
(4582,5,2),
(935,4,1),
(4707,5,1),
(127,7,3),
(4762,4,1);

;function genIdesUsageStatsHtmlTable(){

    ;foreach (dbgetlistcached("prf_users_devenvs") as $id => $env)
     $apps["i".$env["ide"]]++ | $apps["x".$env["xprf"]]++
    ;arsort($apps)
    ;foreach ($apps as $id => $c)
     $outp.="<td class=d>".dbgetcached(($id[0]=="i"?"prf_ides":"prf_xprofans"),"id",substr($id,1,9),"nam")."</td><td class=d style='text-align:right'>".$c."</td></tr>"
    ;return "<table class=h><tr><td class=h>APP</td><td class=h style='text-align:center'><small>x</small></td></tr>".$outp."</table>"

;}