Current time: 10-22-2020, 11:00 AM Hello There, Guest! (LoginRegister)


Post Reply 
dns management
Author Message
uwe Offline
Junior Member
*

Posts: 68
Joined: Feb 2008
Reputation: 0
Post: #17
RE: dns management
popsikle Wrote:I have a DNS management mod almost finished. another week or two and ill post it.

YAY Smile thats great! im also trying to get some kind of integration between ispcp and pdns-admin, so im trying to memic the users table of pdns-admin, i have actually no prior experience in sql or web based anything Smile, anyhow, this is so far how the query might look like (still some fields are missing, and field names are all incorrect but are equivilent:

select admin_id, admin_name, admin_pass ,admin_type_id , "default" AS user_skin,lang,email,domain_name,count(domain_name) from admin inner join admin_type_id on admin_type_id.admin_type = admin.admin_type inner join user_gui_props on admin.admin_id = user_gui_props.id left outer join domain on admin.admin_id = domain.domain_admin_id OR admin.admin_id = domain.domain_created_id OR admin_id=1 GROUP BY admin_id;

and table admin_type_id is:
+------------+---------------+
| admin_type | admin_type_id |
+------------+---------------+
| admin | 1 |
| reseller | 2 |
| user | 3 |
+------------+---------------+

also to integrate pdns-admin groups and ispcp admin_type
03-08-2008 12:13 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
dns management - kevin666 - 02-12-2008, 03:22 PM
RE: dns management - blocker - 02-12-2008, 03:38 PM
RE: dns management - kevin666 - 02-12-2008, 03:41 PM
RE: dns management - gOOvER - 02-12-2008, 04:19 PM
RE: dns management - kevin666 - 02-12-2008, 04:33 PM
RE: dns management - gOOvER - 02-12-2008, 04:40 PM
RE: dns management - kevin666 - 02-12-2008, 04:50 PM
RE: dns management - kevin666 - 02-12-2008, 04:56 PM
RE: dns management - MicCo - 02-12-2008, 07:17 PM
RE: dns management - kevin666 - 02-12-2008, 07:38 PM
RE: dns management - joximu - 02-12-2008, 07:45 PM
RE: dns management - MicCo - 02-12-2008, 11:03 PM
RE: dns management - RedBOX - 02-23-2008, 03:33 AM
RE: dns management - uwe - 03-01-2008, 09:21 PM
RE: dns management - joximu - 03-01-2008, 09:24 PM
RE: dns management - popsikle - 03-07-2008, 08:34 AM
RE: dns management - uwe - 03-08-2008 12:13 AM
RE: dns management - Kika - 03-12-2008, 12:42 AM
RE: dns management - uwe - 03-12-2008, 11:38 AM
RE: dns management - uwe - 03-13-2008, 11:03 PM
RE: dns management - joximu - 03-14-2008, 06:51 AM
RE: dns management - kevin666 - 03-14-2008, 06:26 PM
RE: dns management - vacancy - 03-14-2008, 06:41 PM
RE: dns management - kevin666 - 03-14-2008, 06:46 PM
RE: dns management - uwe - 03-23-2008, 11:25 PM
RE: dns management - uwe - 03-24-2008, 01:18 AM
RE: dns management - Aneu - 03-26-2008, 09:00 AM
RE: dns management - uwe - 04-03-2008, 10:21 PM
RE: dns management - TrippleEx - 05-28-2008, 12:50 AM
RE: dns management - uwe - 07-14-2008, 05:35 PM
RE: dns management - antencek - 07-15-2008, 03:26 AM
RE: dns management - MicCo - 07-15-2008, 03:54 AM
RE: dns management - antencek - 07-15-2008, 08:02 PM
RE: dns management - MicCo - 07-15-2008, 09:55 PM
RE: dns management - xister - 07-15-2008, 09:11 PM
RE: dns management - uwe - 08-03-2008, 10:12 PM
RE: dns management - antencek - 11-04-2009, 09:49 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)