PDA

View Full Version : Add some Sql to web_sites_get _domain


ivomendonca
26th October 2010, 16:36
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 ?

Thanks.

ivomendonca
26th October 2010, 20:07
Directions ? anywone ?

till
26th October 2010, 22:23
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.