#1  
Old 23rd March 2006, 10:40
bixa bixa is offline
Junior Member
 
Join Date: Mar 2006
Location: Sierndorf, Austria
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default Sql Script for Horde

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

Code:
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
Reply With Quote
Sponsored Links
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Script questions && Gentoo version hagel Feature Requests 4 7th May 2006 13:19
SQL Users nok Installation/Configuration 2 26th February 2006 11:17
Suggestion: Use mySQL script for installation Dee General 1 17th February 2006 10:02
Internal Server Error 500 cgi script mphayesuk General 6 8th February 2006 22:53
DNS - call script to created named.conf entries on secondaries cstone Installation/Configuration 4 15th September 2005 01:16


All times are GMT +2. The time now is 12:48.


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