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;
 }