public function watch($id)
 {
     $video = DB::table('katalog')->leftjoin('publisher', 'katalog.publisher', '=', 'publisher.id')->where('katalog.id', '=', $id)->get(array('katalog.id', 'katalog.title', 'katalog.release', 'katalog.numpage', 'publisher.publishername', 'katalog.file', 'katalog.ISBN'));
     $authors = AuthorKatalog::get_author_katalog($id);
     $katalog = Katalog::find($id);
     $katalog->view++;
     $katalog->save();
     return View::make('front.watch', compact('video', 'authors'));
 }
 public function delPublisher($id)
 {
     $katalog = Katalog::where('publisher', '=', $id)->get();
     foreach ($katalog as $value) {
         $k = Katalog::find($value->id);
         $k->publisher = NULL;
         $k->save();
     }
     $publisher = Publisher::find($id);
     $publisher->delete();
     return Redirect::to('admin/publisher');
 }