/**
* sets pvausearchterms for user ID
*
*@throws MySQLConnectionException if a problem with MySQL happened
*/
function SetSearchterms($uid, $searchterms)
{
$searchterms = str_replace('"', '\'', $searchterms);
if (isset($uid)) {
if ($this->existsEntry("ID", $uid)) {
parent::alterEntry($uid, 'searchterms', sql_prev_inj($searchterms));
} else {
$this->addEntry("ID", $uid, "searchterms", sql_prev_inj($searchterms));
return false;
}
}
}
public function setColor($pc_ID, $color)
{
try {
$ids = TableManager::getTableData(sprintf("pc_ID=%s", $pc_ID));
foreach ($ids as &$id) {
TableManager::alterEntry($id['ID'], 'color', $color);
}
} catch (Exception $e) {
echo "Error getting priceclass: " . $e->getMessage();
die;
}
}
/**
* edit a book entry by given id
*/
function editBook($id, $subjectId, $class, $title, $author, $publisher, $isbn, $price, $bundle)
{
parent::alterEntry($id, 'subjectId', $subjectId, 'class', $class, 'title', $title, 'author', $author, 'publisher', $publisher, 'isbn', $isbn, 'price', $price, 'bundle', $bundle);
}
/**
* Alters the Userdata of a given User
* Enter description here ...
* @param unknown_type $old_id The "old" ID, the ID of the user he has before the change
* @param unknown_type $id The new ID
* @param unknown_type $name The new Name
* @param unknown_type $forename
* @param unknown_type $username
* @param unknown_type $passwd The (already hashed!) password
* @param unknown_type $birthday The birthday (format YYYY-MM-DD)
* @param unknown_type $credit
* @param unknown_type $GID
* @param unknown_type $locked
*/
function alterUser($old_id, $id, $name, $forename, $username, $passwd, $birthday, $credit, $GID, $locked, $soli, $class)
{
if (isset($passwd) && $passwd != "d41d8cd98f00b204e9800998ecf8427e") {
parent::alterEntry($old_id, 'ID', $id, 'forename', $forename, 'name', $name, 'username', $username, 'password', $passwd, 'birthday', $birthday, 'credit', $credit, 'GID', $GID, 'locked', $locked, 'soli', $soli, 'class', $class);
} else {
parent::alterEntry($old_id, 'ID', $id, 'forename', $forename, 'name', $name, 'username', $username, 'birthday', $birthday, 'credit', $credit, 'GID', $GID, 'locked', $locked, 'soli', $soli, 'class', $class);
}
}
/**
* If CardID was changed, this function adds 1 to changed_cardID on the MySQL-Server
* Enter description here ...
*
* @param $ID The ID of the object in the cards-table, which cardnumber was changed
*/
function addCardIdChange($ID)
{
$card = parent::getEntryData($ID);
if ($card != NULL) {
try {
parent::alterEntry($ID, 'changed_cardID', $card['changed_cardID'] + 1);
} catch (Exception $e) {
throw new Exception('could not alter the card-entry:' . $e->getMessage());
}
} else {
throw new Exception('could not get the card!');
}
}
/**
* sets fits
*
*@throws MySQLConnectionException if a problem with MySQL happened
*/
function SetFits($uid, $hasFits, $fitsYear)
{
if (isset($uid)) {
parent::alterEntry($uid, 'passedTest', $hasFits, 'schoolyear', $fitsYear);
}
}
function changePriceClass($old_ID, $name, $GID, $price, $ID)
{
TableManager::alterEntry($old_ID, 'name', $name, 'GID', $GID, 'price', $price, 'ID', $ID);
}
