public function base() { $submit = isset($_GET['submit']) ? true : false; $link = isset($_GET['link']) ? $_GET['link'] : false; $message = 'Add the link below'; if ($submit && $link) { $link_explode = explode('/', $link); $file = new files($this->getDb()); $added = $file->select('*', 'WHERE link="' . $link . '"'); if (!isset($added[0]['id'])) { $file->insert(array('name' => urldecode($link_explode[count($link_explode) - 1]), 'approved' => 0, 'downloaded' => 0, 'created' => time(), 'link' => $link)); $message = 'Successfully Added! You can add another link below'; } else { $message = 'This link is already in the index. You can add another link below'; } } $this->set('message', $message); }
private function getFileId($file_name) { if ($file_name == '') { return; } $file = new files($this->getDb()); $file_id = false; $files = $file->select('*', 'WHERE name="' . $file_name . '" OR name="' . $file_name . '.pdf" '); if (!isset($files[0]['id'])) { $id_array = $file->insert(array('name' => $file_name, 'approved' => 1, 'downloaded' => 1, 'created' => time())); $file_id = $id_array[0][1]; } else { $file_id = $files[0]['id']; } return $file_id; }