Old 23rd March 2006, 11: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.

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


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 14:19
SQL Users nok Installation/Configuration 2 26th February 2006 12:17
Suggestion: Use mySQL script for installation Dee General 1 17th February 2006 11:02
Internal Server Error 500 cgi script mphayesuk General 6 8th February 2006 23:53
DNS - call script to created named.conf entries on secondaries cstone Installation/Configuration 4 15th September 2005 02:16

All times are GMT +2. The time now is 22:07.

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