• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Sitebuilder modules usage statistics

Dmitry Frantsev

Golden Pleskian
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.
 
Back
Top