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
  #11  
Old 31st October 2008, 19:01
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
Default

The SQL statement:

"SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = 1"

returns 0 rows, no matter how many clients I have in the database. It seems that:

SELECT client.client_id FROM sys_group, client WHERE sys_group.groupid = 1

returns all of the clients. So the statement needs to be something like:


"SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = $????client_id and sys_group.groupid = $client_group_id"
Reply With Quote
Sponsored Links
  #12  
Old 31st October 2008, 19:38
quentusrex quentusrex is offline
Senior Member
 
Join Date: May 2008
Posts: 174
Thanks: 6
Thanked 11 Times in 7 Posts
Default

I'm testing a fix. it's lines 267 and 227 that need to have a way to get the client_id when the template/form doesn't ask for it.

Last edited by quentusrex; 31st October 2008 at 19:42.
Reply With Quote
  #13  
Old 31st October 2008, 23:35
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,769
Thanks: 840
Thanked 5,608 Times in 4,419 Posts
 
Default

I posted a sql statement in the bugtracker that should work for this:

http://bugtracker.ispconfig.org/inde...=236&project=3
__________________
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


All times are GMT +2. The time now is 00:32.


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