public static function load_single_snippet($snippet_id, $blog_id = 0) { if (!filter_var($snippet_id, FILTER_VALIDATE_INT)) { throw new InvalidArgumentException(); } $db = self::get_db(); $query = sprintf('SELECT * FROM %s WHERE id = %%d', self::get_full_table_name($blog_id)); if ($blog_id > 0 && PhpCodeForPosts::$options->get_blog_id() != $blog_id) { $query .= ' AND shared = 1'; } $query = $db->prepare($query, $snippet_id); $snippet_row = $db->get_row($query); if (!$snippet_row) { $snippet_row = new StdClass(); } return PhpCodeForPosts_Snippet::create_from_database_object($snippet_row); }