Sitebuilder modules usage statistics

[Dmitry Frantsev]

Hello, Everybody!

To all who interested in improving Sitebuilder product:

Sitebuilder developers collecting statistics for modules usage on Sitebuilder sites. If you have couple of minutes please provide your feedback here. What should be counted:

Developers need to know how frequently modules are used on the sites. For providing the feedback you need just run one query in Sitebuilder database:

mysql> select module.code, count(*) from module_instance inner join module on module_id=module.id group by module_id order by module.code;

For those who uses Plesk on the same server with Sitebuilder following script can be run:
############################
#!/bin/sh

SB_MYSQL_USER="admin"
SB_MYSQL_PASS=`cat /etc/psa/.psa.shadow`
MYSQL_BIN_D=`grep MYSQL_BIN_D /etc/psa/psa.conf | awk '{print $2}'`
DATABASE="sitebuilder3"

mysql="${MYSQL_BIN_D}/mysql -NB -u${SB_MYSQL_USER} -p${SB_MYSQL_PASS} ${DATABASE}"

query="select module.code, count(*) from module_instance inner join module on module_id=module.id group by module_id order by module.code"
echo $query | $mysql

############################
Just save it into sb_stat_module.sh file and run as:

# sh sb_stat_module.sh

Please provide your outputs into this thread or to me via private message. Your help is much appreciated. Thank you.