/**
* create a core (create database and add core record in __casebox.cores table)
* @param array $p
* @return int | false
*/
public static function create($p)
{
$rez = false;
$dbName = Config::get('prefix') . '_' . $p['name'];
if (DB\dbQuery('CREATE DATABASE `' . $dbName . '` CHARACTER SET utf8 COLLATE utf8_general_ci')) {
$rez = parent::create($p);
}
return $rez;
}
/**
* add a record
* @param array $p associative array with table field values
* @return int created id
*/
public static function create($p)
{
parent::create($p);
if (empty($p['name'])) {
trigger_error(L\get('ErroneousInputData') . ' Empty name for GUID.', E_USER_ERROR);
}
//prepare params
//add database record
$sql = 'INSERT INTO ' . \CB\PREFIX . '_casebox.guids
(`name`)
VALUES ($1)';
DB\dbQuery($sql, $p['name']) or die(DB\dbQueryError());
$rez = DB\dbLastInsertId();
return $rez;
}
/**
* add a record
* @param array $p associative array with table field values
* @return int created id
*/
public static function create($p)
{
parent::create($p);
//prepare params
$params = array(empty($p['object_id']) ? null : $p['object_id'], empty($p['object_pid']) ? null : $p['object_pid'], empty($p['user_id']) ? null : $p['user_id'], empty($p['action_type']) ? null : $p['action_type'], empty($p['data']) ? null : $p['data'], empty($p['data']) ? null : $p['data'], empty($p['activity_data_db']) ? null : $p['activity_data_db'], empty($p['activity_data_solr']) ? null : $p['activity_data_solr']);
//add database record
$sql = 'INSERT INTO `' . static::$tableName . '` (
`object_id`
,`object_pid`
,`user_id`
,`action_type`
,`data`
,`activity_data_db`
,`activity_data_solr`
) VALUES ($1, $2, $3, $4, $5, $6, $7)';
DB\dbQuery($sql, $params) or die(DB\dbQueryError());
$rez = DB\dbLastInsertId();
return $rez;
}
/**
* add a record
* @param array $p associative array with table field values
* @return int created id
*/
public static function create($p)
{
parent::create($p);
$p = array_intersect_key($p, static::$tableFields);
$p['type'] = static::$type;
$fields = array_keys($p);
$values = array_values($p);
//prepare params
$params = array_keys($values);
$params[] = sizeof($params);
array_shift($params);
for ($i = 0; $i < sizeof($fields); $i++) {
$params[$i] = $fields[$i] == 'password' ? 'MD5(CONCAT(\'aero\', $' . $params[$i] . '))' : '$' . $params[$i];
}
//prepare sql
$sql = 'INSERT INTO `' . static::$tableName . '` (`' . implode('`,`', $fields) . '`) VALUES (' . implode(',', $params) . ')';
//add database record
DB\dbQuery($sql, $values) or die(DB\dbQueryError());
$rez = DB\dbLastInsertId();
return $rez;
}
/**
* add a record
* @param array $p associative array with table field values
* @return int created id
*/
public static function create($p)
{
\CB\raiseErrorIf(empty($p['name']), 'ErroneousInputData');
return parent::create($p);
}
/**
* add a record
* @param array $p associative array with table field values
* @return int created id
*/
public static function create($p)
{
$p['type'] = static::$type;
$rez = parent::create($p);
return $rez;
}
