function insertCompany($company_name)
{
$q = new DBQuery();
$q->addTable("companies");
$q->addInsert('company_name', $company_name);
db_exec($q->prepareInsert());
return db_insert_id();
}
function testInsertBD()
{
$q = new DBQuery();
$q->addTable('eap');
$q->addQuery("id,nome,linha,coluna");
$q->addInsert(nome, 'Build Teste');
$q->addInsert(linha, 2);
$q->addInsert(coluna, 3);
$q->prepareInsert();
$this->assertEqual($q->exec(), true);
$q->clear();
}
<?php
if (!defined('DP_BASE_DIR')) {
die('You should not access this file directly. Instead, run the Installer in install/index.php.');
}
dPmsg('Converting users to contacts');
$q = new DBQuery();
$q->addTable("users");
$q->addQuery("*");
$users = db_loadList($q->prepare(true));
$flds = array('contact_first_name', 'contact_last_name', 'contact_birthday', 'contact_company', 'contact_department', 'contact_email', 'contact_phone', 'contact_phone2', 'contact_mobile', 'contact_address1', 'contact_address2', 'contact_city', 'contact_state', 'contact_zip', 'contact_country', 'contact_icq', 'contact_icon', 'contact_owner');
foreach ($users as $user) {
$vals = array($user['user_first_name'], $user['user_last_name'], $user['user_birthday'], (int) dPgetParam($user, 'user_company', 0), (int) dPgetParam($user, 'user_department', 0), $user['user_email'], $user['user_phone'], $user['user_home_phone'], $user['user_mobile'], $user['user_address1'], $user['user_address2'], $user['user_city'], $user['user_state'], $user['user_zip'], $user['user_country'], $user['user_icq'], $user['user_pic'], $user['user_owner']);
$q->addTable('contacts');
$q->addInsert($flds, $vals, true);
db_exec($q->prepareInsert());
$q->clear();
$msg = db_error();
$vals = array($user['user_id'], 'USERFORMAT', 'user');
$q->addTable('user_preferences');
db_exec($q->addInsert($flds, $vals, true));
$q->clear();
$msg = db_error();
if ($msg) {
dPmsg($msg);
}
$q->addTable('users');
$q->addUpdate('user_contact=LAST_INSERT_ID()');
$q->addWhere('user_id = ' . $user['user_id']);
db_exec($q->prepare(true));
$msg = db_error();
