1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Sitebuilder modules usage statistics

Discussion in 'Sitebuilder 4.2 for Linux' started by Dmitry Frantsev, Jun 30, 2008.

  1. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    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.
     
Loading...