public function InsertAndSendMail() { $quotedAuthor = trim($_POST['mail']); $quotedTitle = trim($_POST['title']); $isbn = Isbn::stringFromPost(); $year = (int) trim($_POST['year']); $price = (double) str_replace(',', '.', $_POST['price']); $quotedDescription = $_POST['desc']; $key = KeyGenerator::genKey(); $query = 'insert into books' . ' (author, title, year, price, isbn, description, mail, auth_key' . ', created,expires)' . ' values (' . '"' . $quotedAuthor . '"' . ', "' . $quotedTitle . '"' . ', "' . $year . '"' . ', "' . $price . '"' . ', "' . $isbn . '"' . ', "' . $quotedDescription . '"' . ', "' . $this->getMail() . '"' . ', "' . $key . '"' . ', now()' . ', date_add(now(), interval 45 day)' . ')'; mysql_query($query); $book_id = mysql_insert_id(); $this->selectableCategories->setBookId($book_id); $this->selectableCategories->update(); $subject = ''; $message = 'Mit deiner E-Mailadresse wurde das unten stehende Buch angeboten. Hebe diese E-Mail auf, um das Angebot später ändern und löschen zu können.'; Mailer::send($book_id, $subject, $message); $searches = new Searches(); if ($searches->areActivated()) { $author = stripslashes($quotedAuthor); $title = stripslashes($quotedTitle); $description = stripslashes($quotedDescription); $searches->bookAdded($book_id, $author, $title, $description); } header('Location: book.php?id=' . $book_id . '&key=' . $key . '&new=1'); exit; }
private function createSaveLink() { if (isset($_GET['searchSaved'])) { return; } $searches = new Searches(); if (!$searches->areActivated()) { return; } $this->tmpl->addSubtemplate('saveSearch'); }
* MySQL-Setup, Bücher betrachten, Kategorien verändern, Serveraustausch aktivieren, Mail verschicken. */ require 'header.php'; ?> <h2>uBook läuft</h2> <table align="center"> <tr><td>Buchangebote</td><td><?php echo $numberOfBooks; ?> </td><td><a href="admin_view.php">alle einsehen</a></td></tr> <tr><td>Kategorien</td><td><?php echo $numberOfCategories; ?> </td><td><a href="admin_categories.php">verwalten</a></td></tr> <?php if ($searches->areActivated()) { ?> <tr><td>Gespeicherte Suchen</td><td><?php echo $numberOfSearches; ?> </td><td><a href="admin_notification.php?deactivate=1">alle löschen</a></td></tr> <?php } else { ?> <tr><td colspan="3"><a href="admin_notification.php?activate=1">Suchbenachrichtigungen aktivieren</a></td></tr> <?php } if ($serverName->isEmpty()) { ?> <tr><td colspan="3"><a href="admin_servers.php">Suche an anderen Standorten aktivieren</a></td></tr> <?php