View Single Post
  #10  
Old 29th April 2008, 23:57
AllanJ AllanJ is offline
Junior Member
 
Join Date: Mar 2007
Posts: 16
Thanks: 5
Thanked 6 Times in 2 Posts
Default

The start of the mysql log for a remoting "user_add" looks like this:

68251 Query INSERT INTO isp_isp_user (doctype_id,user_name,user_email,user_username,use r_passwort,user_speicher,user_mailquota,user_admin ) VALUES ('1014','Uwe Mer','uwe','web33_uwe','sagichnicht','0','1
68251 Init DB db_ispconfig
68251 Query INSERT INTO isp_nodes ( userid, groupid, parent, type, doctype_id, status, icon, modul, doc_id, titleM
) VALUES (M
4,M
1,M
'',M
'a',M
'1014',M
'1',M
'',M
'',M
68,M
''M
)
68251 Init DB db_ispconfig
68251 Query INSERT INTO isp_dep (userid, groupid, parent_doc_id, parent_doctype_id, parent_tree_id, child_doc_id, child_doctype_id, child_tree_id, status)M
VALUES (M
4,M
1,M
4,M
'1013',M
17,M
68,M
'1014',M
200,M
1)
68251 Init DB db_ispconfig
68251 Query SELECT * from doctype where doctype_id = '1014'
68251 Init DB db_ispconfig
68251 Query SELECT * from isp_server
68251 Init DB db_ispconfig
68251 Query select * from isp_isp_user where doc_id = '68'
68251 Init DB db_ispconfig
68251 Query SELECT count(doc_id) as doc_count from isp_isp_user where user_username = 'web33_uwe'
68251 Init DB db_ispconfig
68251 Query UPDATE isp_isp_user SET user_passwort = '||||:Xjd7M41I4c/eo' where doc_id = '68'


If I make a user with the webinterface the start of the mysql log is a bit different:

68245 Query INSERT INTO isp_isp_user (user_name, user_passwort, user_speicher, user_admin, user_shell) VALUES ('Jens Meier', 'test1234', '0', '0', '0')
68245 Init DB db_ispconfig
68245 Query INSERT INTO isp_nodes (title, doctype_id, doc_id, type, icon, userid, groupid, status) VALUES ('', '1014', '67', 'a', '', '1', '0', '1')
68245 Init DB db_ispconfig
68245 Query Select userid, groupid from isp_nodes where tree_id = '79'
68245 Init DB db_ispconfig
68245 Query select * from user_groups where groupid = '2' and userid = '1'
68245 Init DB db_ispconfig
68245 Query SELECT * from isp_nodes where tree_id = '79'
68245 Init DB db_ispconfig
68245 Query INSERT INTO isp_dep (userid,groupid,parent_doc_id,parent_doctype_id,pa rent_tree_id,child_doc_id,child_doctype_id,child_t ree_id) VALUES
('0','2','26','1013','79','67','1014','199')
68245 Init DB db_ispconfig
68245 Query SELECT * from sys_config
68245 Init DB db_ispconfig
68245 Query UPDATE isp_isp_user SET user_username = 'web33_jens', user_email = 'jens' where doc_id = 67
68245 Init DB db_ispconfig
68245 Query SELECT * from isp_server
68245 Init DB db_ispconfig
68245 Query select * from isp_isp_user where doc_id = '67'
68245 Init DB db_ispconfig
68245 Query SELECT count(doc_id) as doc_count from isp_isp_user where user_username = 'web33_jens'
68245 Init DB db_ispconfig
68245 Query UPDATE isp_isp_user SET user_passwort = '||||:]{AMOnrho.08c' where doc_id = '67'

so it would seem that the 2 operations take different paths in the code, but I have not dug that deep into ispconfig yet.

Best regards
Allan Jacobsen
Reply With Quote