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.
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.