[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] phpgwapi/setup/default_records.inc.php, 1.4.2.6.2.10.
From: |
nomail |
Subject: |
[Phpgroupware-cvs] phpgwapi/setup/default_records.inc.php, 1.4.2.6.2.10.2.1 |
Date: |
Thu, 30 Dec 2004 05:51:48 +0100 |
Update of /phpgwapi/setup
Modified Files:
Branch: proposed-0_9_18-branch
default_records.inc.php
date: 2004/12/30 04:51:48; author: skwashd; state: Exp; lines: +58 -51
Log Message:
switch to ADOdb
=====================================================================
Index: phpgwapi/setup/default_records.inc.php
diff -u phpgwapi/setup/default_records.inc.php:1.4.2.6.2.10
phpgwapi/setup/default_records.inc.php:1.4.2.6.2.10.2.1
--- phpgwapi/setup/default_records.inc.php:1.4.2.6.2.10 Tue Feb 24 22:10:57 2004
+++ phpgwapi/setup/default_records.inc.php Thu Dec 30 04:51:48 2004
@@ -179,112 +179,119 @@
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_note_type (description) VALUES ('vcard')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_note_type (description) VALUES ('system')");
- $db1 = $oProc;
- $GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='email'");
- while ($GLOBALS['phpgw_setup']->oProc->next_record())
+ $GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='email'");
+ $comm_type_ids =
$GLOBALS['phpgw_setup']->oProc->m_odb->resultSet->getArray();
+ for($i = 0; $i < count($comm_type_ids); $i++)
{
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'home email'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'work email'"
. ")");
}
+
$GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='phone'");
- while ($GLOBALS['phpgw_setup']->oProc->next_record())
+ $comm_type_ids =
$GLOBALS['phpgw_setup']->oProc->m_odb->resultSet->getArray();
+ for($i = 0; $i < count($comm_type_ids); $i++)
{
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'home phone'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'work phone'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'voice phone'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'msg phone'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'pager'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'bbs'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'modem'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'isdn'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'video'"
. ")");
}
$GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='fax'");
- while ($GLOBALS['phpgw_setup']->oProc->next_record())
+ $comm_type_ids =
$GLOBALS['phpgw_setup']->oProc->m_odb->resultSet->getArray();
+ for($i = 0; $i < count($comm_type_ids); $i++)
{
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'home fax'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'work fax'"
. ")");
}
$GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='mobile phone'");
- while ($GLOBALS['phpgw_setup']->oProc->next_record())
+ $comm_type_ids =
$GLOBALS['phpgw_setup']->oProc->m_odb->resultSet->getArray();
+ for($i = 0; $i < count($comm_type_ids); $i++)
{
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'mobile (cell) phone'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'car phone'"
. ")");
}
$GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='instant messaging'");
- while ($GLOBALS['phpgw_setup']->oProc->next_record())
+ $comm_type_ids =
$GLOBALS['phpgw_setup']->oProc->m_odb->resultSet->getArray();
+ for($i = 0; $i < count($comm_type_ids); $i++)
{
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'msn'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'aim'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'yahoo'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'icq'"
. ")");
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'jabber'"
. ")");
}
$GLOBALS['phpgw_setup']->oProc->query("SELECT comm_type_id FROM
phpgw_contact_comm_type WHERE type='url'");
- while ($GLOBALS['phpgw_setup']->oProc->next_record())
+ $comm_type_ids =
$GLOBALS['phpgw_setup']->oProc->m_odb->resultSet->getArray();
+ for($i = 0; $i < count($comm_type_ids); $i++)
{
- $db1->query("INSERT INTO phpgw_contact_comm_descr
(comm_type_id,descr) VALUES ("
- . $GLOBALS['phpgw_setup']->oProc->f('comm_type_id')
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_contact_comm_descr (comm_type_id,descr) VALUES ("
+ . $comm_type_ids[$i]['comm_type_id']
. ",'website'"
. ")");
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] phpgwapi/setup/default_records.inc.php, 1.4.2.6.2.10.2.1,
nomail <=