Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th October 2010, 16:36
ivomendonca ivomendonca is offline
Banned
 
Join Date: Sep 2009
Posts: 132
Thanks: 10
Thanked 13 Times in 7 Posts
Default Add some Sql to web_sites_get _domain

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.
Reply With Quote
Sponsored Links
  #2  
Old 26th October 2010, 20:07
ivomendonca ivomendonca is offline
Banned
 
Join Date: Sep 2009
Posts: 132
Thanks: 10
Thanked 13 Times in 7 Posts
Question

Directions ? anywone ?
Reply With Quote
  #3  
Old 26th October 2010, 22:23
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
freebsd 7, samba 3, domain controller alexdimarco Suggest HOWTO 6 5th November 2010 16:54
[hardy heron] freeradius-mysql-daloradius kdclaver Installation/Configuration 1 12th August 2009 17:31
Chilispot on dd-wrt + freeradius / phpmyprepaid on Centos 5 wrong user password treeman HOWTO-Related Questions 0 31st May 2009 06:49
radiusd.conf[14]: sql: Module instantiation failed. euslemoc Installation/Configuration 8 6th November 2007 07:16
postfix-tls sasl2 mysql courier-authmysql gabrix Server Operation 4 12th January 2007 22:09


All times are GMT +2. The time now is 15:13.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.