public function updateCar($car)
{
$Id = $car->getId();
$SiteId = toNull($car->getSiteId(), false);
$CarBrandId = toNull($car->getCarBrandId(), false);
$Type = toNull(escape($car->getType()), true);
$TypeShort = toNull(escape($car->getTypeShort()), true);
$PreviewLink = toNull(escape($car->getPreviewLink()), true);
$DateAdded = toNull(toYYYYMMDD($car->getDateAdded()), true);
$State = toNull(escape($car->getState()), true);
$DateApproved = toNull(toYYYYMMDD($car->getDateApproved()), true);
$FolderName = toNull(escape($car->getFolderName()), true);
$PressContactId = toNull($car->getPressContactId(), false);
$UserIdAdded = toNull($car->getUserIdAdded(), false);
$UserIdApproved = toNull($car->getUserIdApproved(), false);
$DetailTypeId = toNull($car->getDetailTypeId(), false);
$DefaultPictureId = toNull($car->getDefaultPictureId(), false);
$LRClicks = toNull($car->getLRClicks(), false);
$HRClicks = toNull($car->getHRClicks(), false);
$Views = toNull($car->getViews(), false);
$ReleaseDate = toNull(escape($car->getReleaseDate()), true);
$MovieFolder = toNull(escape($car->getMovieFolder()), true);
$sql = "UPDATE car\n\t\t\tSET SiteId = {$SiteId},\n\t\t\tCarBrandId = {$CarBrandId},\n\t\t\tType = {$Type},\n\t\t\tTypeShort = {$TypeShort},\n\t\t\tPreviewLink = {$PreviewLink},\n\t\t\tDateAdded = {$DateAdded},\n\t\t\tState = {$State},\n\t\t\tDateApproved = {$DateApproved},\n\t\t\tFolderName = {$FolderName},\n\t\t\tPressContactId = {$PressContactId},\n\t\t\tUserIdAdded = {$UserIdAdded},\n\t\t\tUserIdApproved = {$UserIdApproved},\n\t\t\tDetailTypeId = {$DetailTypeId},\n\t\t\tDefaultPictureId = {$DefaultPictureId},\n\t\t\tLRClicks = {$LRClicks},\n\t\t\tHRClicks = {$HRClicks},\n\t\t\tViews = {$Views},\n\t\t\tReleaseDate = {$ReleaseDate},\n MovieFolder = {$MovieFolder}\n\t\t\tWHERE Id = {$Id}";
if (!mysql_query($sql, $this->connectie)) {
die('Error: ' . mysql_error());
}
}
public function updateUser($user)
{
$Id = $user->getId();
$Name = toNull(escape($user->getName()), true);
$Account = toNull(escape($user->getAccount()), true);
$Password = toNull(escape($user->getPassword()), true);
$Role = toNull(escape($user->getRole()), true);
$Email = toNull(escape($user->getEmail()), true);
$DateAdded = toNull(toYYYYMMDD($user->getDateAdded()), true);
$sql = "UPDATE user\n\t\t\tSET Name = {$Name},\n\t\t\tAccount = {$Account},\n\t\t\tPassword = {$Password},\n\t\t\tRole = {$Role},\n\t\t\tEmail = {$Email},\n\t\t\tDateAdded = {$DateAdded}\n\t\t\tWHERE Id = {$Id}";
if (!mysql_query($sql, $this->connectie)) {
die('Error: ' . mysql_error());
}
}
