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

Users of RSS a Blog

Discussion in 'Sitebuilder 4.2 for Linux' started by FERNANDO_AR07, Jul 29, 2008.

  1. FERNANDO_AR07

    FERNANDO_AR07 Guest

    0
     
    Hello, a query:

    How can we know the users of RSS a Blog?

    Thank you
     
  2. abezborodova

    abezborodova Guest

    0
     
    If you mean to know sites that uses RSS News Feeds you may do that using the SQL queries below.

    1. Get identification of module RssReader:

    mysql> select id, code from module where code='RssReader';
    +----+-----------+
    | id | code |
    +----+-----------+
    | 10 | RssReader |
    +----+-----------+
    1 row in set (0.00 sec)

    mysql>

    2. Get aliases of all sites and their owners that use the module:

    mysql> select distinct site.alias as site, user.user_name from site, user, module_instance where module_instance.site_id=site.id and module_instance.module_id=10 and site.user_id=user.id;
    +-----------+-----------+
    | site | user_name |
    +-----------+-----------+
    | test site | user |
    +-----------+-----------+
    1 row in set (0.00 sec)

    mysql>
     
Loading...