Add some Sql to web_sites_get _domain

Discussion in 'Developers' Forum' started by ivomendonca, Oct 26, 2010.

  1. ivomendonca

    ivomendonca Banned

    Hello, i need to return current_traffic and Current quota from API (web_sites_get _domain).

    The Api is using :
    function getDataRecord($primary_id) { and the sql is dynamic.

    How can i add the two left joins to the current Query ?

    Do i need to use other function or write the full query in somewere else ?

  2. ivomendonca

    ivomendonca Banned

    Directions ? anywone ?
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    I recommend that you add a new function for querying the monitor_data table which holds the quota information and the web_traffic table which holds the website traffic. The current function shall only return the record from web_domain table so that this record can be used to pass it back directly for updates.

Share This Page