dns management

[uwe]

popsikle Wrote:I have a DNS management mod almost finished. another week or two and ill post it.

YAY 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 , 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