public static function setRolesFor($user_id, $roles)
{
Record::deleteWhere('UserRole', 'user_id = :user_id', array(':user_id' => (int) $user_id));
foreach ($roles as $role => $role_id) {
Record::insert('UserRole', array('user_id' => (int) $user_id, 'role_id' => (int) $role_id));
}
}
function redirector_log_404()
{
$redirect = Record::findAllFrom('Redirector404s', 'url = \'' . $_SERVER['REQUEST_URI'] . '\'');
if (sizeof($redirect) > 0) {
Record::update('Redirector404s', array('hits' => $redirect[0]->hits + 1), 'id = ' . $redirect[0]->id);
} else {
Record::insert('Redirector404s', array('url' => $_SERVER['REQUEST_URI']));
}
}
require_once 'Request.php';
require_once 'Users.php';
if (check_cookie($_SERVER['PHP_SELF'], 1)) {
if (!empty($_POST)) {
if (!empty($_POST['aid'])) {
$asn = new Assign();
$asn->id = $_POST['aid'];
$asn->find();
$rec = new Record();
$rec->aid = $_POST['aid'];
$rec->uid = $asn->rid;
$rec->date = parse_date($_POST);
$rec->hours = $_POST['hours'];
$rec->materials = $_POST['materials'];
$rec->cost = str_replace('$', '', $_POST['cost']);
$rec->insert();
} else {
if (!empty($_POST['id'])) {
$rec = new Record();
$date = parse_date($_POST);
$cost = str_replace('$', '', $_POST['cost']);
$query = 'UPDATE record ' . "SET date='{$date}', " . "hours={$_POST['hours']}, " . "materials='{$_POST['materials']}', " . "cost={$cost} " . "WHERE id={$_POST['id']}";
$rec->query($query);
}
}
}
// Initialize values!
$aid = isset($_GET['aid']) ? $_GET['aid'] : '';
$id = isset($_GET['id']) ? $_GET['id'] : '';
$requestor = '';
$requestor_phone = '';
/**
* Videos
*/
public function video_create()
{
$record = Record::insert('ecommerce_product_video', $_POST['product_video']);
echo Record::lastInsertId();
}
