public function snip($id) { $db = Database::instance(); $id = mysql_real_escape_string($id); $sql = 'SELECT `snip_id`, `user_id`, `language`, `snippet`, `title`, `date_added`, `private`, `description` FROM `snips` WHERE `snip_id` = ' . $id . ' LIMIT 0, 30 '; $result = $db->query($sql); if ($result and $result->count() > 0) { foreach ($result as $row) { $user_id = $row->user_id; $language = $row->language; $snippet = $row->snippet; $title = $row->title; $date_added = $row->date_added; $private = $row->private; $description = $row->description; } if ($private == '1') { // Redirect if no one is logged in and tries to view private snippet if (!is_object($this->user)) { url::redirect('/home/login?loginRequired=1&return_to=home~snip~' . $id); } // Redirect User if they are not the owner of the snippet if ($this->user->id != $user_id) { url::redirect('/home/?forbiddenSnip=1¤tUser='******' <script type="text/javascript" src="/files/syntax/scripts/shCore.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushBash.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushCpp.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushCSharp.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushCss.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushDelphi.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushDiff.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushGroovy.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushJava.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushJScript.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushPhp.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushPlain.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushPowerShell.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushPython.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushRuby.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushScala.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushSql.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushVb.js"></script> <script type="text/javascript" src="/files/syntax/scripts/shBrushXml.js"></script> <link type="text/css" rel="stylesheet" href="/files/syntax/styles/shCore.css"/> <link type="text/css" rel="stylesheet" href="/files/syntax/styles/shThemeDefault.css"/> <script type="text/javascript"> SyntaxHighlighter.config.clipboardSwf = "/files/syntax/scripts/clipboard.swf"; SyntaxHighlighter.all(); jQuery(function($) { $("#dialog").hide(); }); </script>'; $home_nav = new view('home_nav'); $home_nav->highlight = 'none'; $this->template->page_nav = $home_nav; $result = $db->query("SELECT username FROM users WHERE id = " . $user_id . " LIMIT 0, 1"); foreach ($result as $row) { $username = $row->username; } $content = View::factory('snip/snip'); if (is_object($this->user)) { if ($this->user->id != $user_id) { $is_logged_in = "0"; } else { $is_logged_in = "1"; } } else { $is_logged_in = "0"; } $snips_model = new Snip_Model(); $content->username = $username; $content->snipID = $id; $content->is_logged_in = $is_logged_in; $content->user_id = $user_id; $content->brush = $snips_model->lang_to_brush($language); $content->language = $language; $content->title = $title; $content->snippet = $snippet; $content->date_added = $date_added; $content->private = $private; $content->description = $description; $this->template->page_content = $content; } else { throw new Kohana_404_Exception('home/snip/' . $id); } }