Sql Script for Horde

[bixa]

Here is my SQL Script for setting default values to Webmail Identity in Horde (if the user hasn't logged in jet)
Have Fun.

INSERT IGNORE INTO horde.horde_prefs (pref_uid,pref_scope,pref_name,pref_value)
SELECT user_username,'horde','identities',
CONCAT( 'a:1:{i:0;a:4:{s:2:"id";s:',LENGTH(user_name),':"',user_name,
'";s:8:"fullname";s:',LENGTH(user_name),':"',user_name,
'";s:9:"from_addr";s:',LENGTH(CONCAT(user_email,'@',web_domain)),':"',CONCAT(user_email,'@',web_domain),
'";s:16:"default_identity";s:1:"0";}}'
) AS pref_new

FROM ispconfigdb.isp_nodes, ispconfigdb.isp_dep, ispconfigdb.isp_isp_user, ispconfigdb.isp_isp_web
WHERE isp_dep.parent_doctype_id = '1013'
AND isp_dep.child_doc_id = isp_isp_user.doc_id
AND isp_dep.child_doctype_id = '1014'
AND isp_nodes.doc_id = isp_isp_user.doc_id
AND isp_nodes.doctype_id = '1014'
AND isp_nodes.status = '1'
AND isp_dep.parent_doc_id = isp_isp_web.doc_id