Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 2nd October 2007, 18:16
mccharlet mccharlet is offline
Senior Member
 
Join Date: Feb 2007
Posts: 261
Thanks: 60
Thanked 11 Times in 7 Posts
Default sql request for list client

Hi,

I want create a list of the client by reseller.
But i don't find wich table use.

Tanks for your help
__________________
Thanks
Cédric

Sorry for my english

Hosting : http://www.jheberge.ch
Reply With Quote
Sponsored Links
  #2  
Old 3rd October 2007, 13:40
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

Resellers: isp_isp_reseller
Clients: isp_isp_kunde

The relations for reseller > client is stored in the table isp_dep
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 3rd October 2007, 14:54
mccharlet mccharlet is offline
Senior Member
 
Join Date: Feb 2007
Posts: 261
Thanks: 60
Thanked 11 Times in 7 Posts
Default

Tanks Till,

But, I do not find logic in the isp_dep database ant client and reseller.

Wich fields corresponds doc_id from client and reseller

Thanks
__________________
Thanks
Cédric

Sorry for my english

Hosting : http://www.jheberge.ch
Reply With Quote
  #4  
Old 3rd October 2007, 17:49
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

It is a classic parent => child record relation. In this case, the reseller is the parent and the client is the child.

isp_dep.parent_doc_id = isp_isp_reseller.doc_id
isp_dep.parent_doctype_id = isp_isp_reseller.doctype_id
isp_dep.child_doc_id = isp_isp_kunde.doc_id
isp_dep.child_doctype_id = isp_isp_kunde.doctype_id
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 3rd October 2007, 21:58
mccharlet mccharlet is offline
Senior Member
 
Join Date: Feb 2007
Posts: 261
Thanks: 60
Thanked 11 Times in 7 Posts
Default

i don't understand any more

I have a reseller with the doc_id 4. This reseller have five client

If i make a select on the isp_dep database, with the field isp_dep.parent_doc_id with the value 4. i have four recording.
Three with the parent_doctype_id egal 1013 and one with 1012

But nothing with the value 1022 (isp_reseller)

__________________
Thanks
Cédric

Sorry for my english

Hosting : http://www.jheberge.ch
Reply With Quote
  #6  
Old 12th October 2007, 10:30
mccharlet mccharlet is offline
Senior Member
 
Join Date: Feb 2007
Posts: 261
Thanks: 60
Thanked 11 Times in 7 Posts
 
Default

up

Help me
__________________
Thanks
Cédric

Sorry for my english

Hosting : http://www.jheberge.ch
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
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
WG311v2 almost working with Edgy (w/o ndiswrapper) need help with the rest caudata Server Operation 11 13th November 2006 20:02
vsftp - 550 Failed to change directory latcarf Server Operation 8 14th May 2006 02:05
from http to https after installation? Mahir Installation/Configuration 25 7th December 2005 20:40


All times are GMT +2. The time now is 22:26.


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