Skip to content

Instantly share code, notes, and snippets.

@pcdinh
Created January 9, 2010 05:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pcdinh/272742 to your computer and use it in GitHub Desktop.
Save pcdinh/272742 to your computer and use it in GitHub Desktop.
<?php
$link = mysqli_connect("localhost", "root", "123456", "spicacms");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* Select queries return a resultset */
$sql = 'SELECT post_id AS id,
post_title AS title,
post_abstract AS abstract
FROM posts
WHERE post_status = 1
ORDER BY post_created_dtime DESC LIMIT 0, 20';
if ($result = mysqli_query($link, $sql)) {
mysqli_fetch_assoc($result);
mysqli_free_result($result);
}
mysqli_close($link);
?>
/*
SQLyog Enterprise - MySQL GUI v8.2 RC2
MySQL - 5.1.38-community
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `posts` (
`post_id` double ,
`post_title` varchar (900),
`post_abstract` varchar (450),
`post_text` blob ,
`post_external_url` varchar (900),
`post_created_dtime` datetime ,
`post_mod_dtime` datetime ,
`post_effective_thru_dtime` datetime ,
`post_author_name` varchar (300),
`post_status` tinyint (4),
`user_id` double
);
insert into `posts` (`post_id`, `post_title`, `post_abstract`, `post_text`, `post_external_url`, `post_created_dtime`, `post_mod_dtime`, `post_effective_thru_dtime`, `post_author_name`, `post_status`, `user_id`) values('1','Microsoft arms half-wit developers with PHP handgun','PHP is legal. But it shouldn\'t be','<p><strong class=\"trailer\">Fail and You</strong> Terrible things are about to happen in Microsoft\'s web application hosting environment, Windows Azure. Redmond\'s Slugworth, desperate to keep up with Mountain View\'s Chocolate Factory, has introduced support for PHP on their web application platform. Microsoft\'s Windows Azure is a competitor to Google App Engine and is trying to gain popularity by supporting interoperability and standards. And don\'t fall asleep within four hours of reading that sentence or a blood vessel will burst in your brain as your subconscious tries to make sense of it. You\'ve been warned.</p> \r\n \r\n<p>Both App engine and Windows Azure boast a promise of automatic scalability to developers, in the same fashion that a traveling salesman in the early American 1800s with his straw hat, red and white pinstripe suit, and assistant midget boast that their secret-recipe tonic will cure all that ails you.</p> ',NULL,'2010-01-01 11:09:20',NULL,NULL,NULL,'1','1');
insert into `posts` (`post_id`, `post_title`, `post_abstract`, `post_text`, `post_external_url`, `post_created_dtime`, `post_mod_dtime`, `post_effective_thru_dtime`, `post_author_name`, `post_status`, `user_id`) values('2','Trying to Add Portability to Movie Files','Hollywood and its high-tech partners are trying to create a digital standard that would let consumers buy or rent a movie once and then play it on any','<p>It is easy to take a DVD to a friend&#8217;s house and watch it on his TV. But things are more complicated when digital video downloads are involved. A movie file bought from <a href=\"http://Blockbuster.com\" target=\"_\">Blockbuster.com</a> will not work on a <a href=\"http://topics.nytimes.com/top/news/business/companies/sony_corporation/index.html?inline=nyt-org\" title=\"More information about SONY Corporation\">Sony</a> HDTV, for example, and videos from iTunes work only on devices with <a href=\"http://topics.nytimes.com/top/news/business/companies/apple_computer_inc/index.html?inline=nyt-org\" title=\"More information about Apple Inc.\">Apple</a> software.</p><p>At the <a href=\"http://topics.nytimes.com/top/reference/timestopics/subjects/i/international_consumer_electronics_show_ces/index.html?inline=nyt-classifier\" title=\"More articles about the International Consumer Electronics Show.\">Consumer Electronics Show</a>, a big high-tech gathering that will begin Wednesday in Las Vegas, Hollywood studios and consumer electronics makers plan to lay out some steps they are taking to simplify this digital future &#151; and perhaps stem the worrying decline in home entertainment sales. </p><p> Hollywood and its high-tech partners are deeply concerned that their customers will rebel against some of the limitations taking shape as video moves away from physical discs.</p><p>Consumers, the industry believes, could balk at buying digital movies and TV shows until they can bring their collections with them wherever they go &#151; by and large the same freedom people have with DVDs. </p>\r\n<p>In the last year and a half, a broad alliance of high-tech companies and Hollywood studios has been trying to address this problem through an organization called the Digital Entertainment Content Ecosystem, or DECE. Five of the six major Hollywood studios (<a href=\"http://topics.nytimes.com/top/news/business/companies/warner_bros_entertainment_inc/index.html?inline=nyt-org\" title=\"More articles about Warner Brothers.\">Warner Brothers</a>, <a href=\"http://topics.nytimes.com/top/news/business/companies/nbc_universal/index.html?inline=nyt-org\" title=\"More articles about NBC Universal.\">NBC Universal</a>, Sony, Paramount and Fox, but not <a href=\"http://topics.nytimes.com/top/news/business/companies/disney_walt_company/index.html?inline=nyt-org\" title=\"More information about Disney, Walt, Co\">Walt Disney</a>) are involved, with <a href=\"http://topics.nytimes.com/top/news/business/companies/microsoft_corporation/index.html?inline=nyt-org\" title=\"More information about Microsoft Corp\">Microsoft</a>, <a href=\"http://topics.nytimes.com/top/news/business/companies/cisco_systems_inc/index.html?inline=nyt-org\" title=\"More information about Cisco Systems Inc\">Cisco Systems</a>, <a href=\"http://topics.nytimes.com/top/news/business/companies/comcast_corporation/index.html?inline=nyt-org\" title=\"More information about Comcast Corp\">Comcast</a>, <a href=\"http://topics.nytimes.com/top/news/business/companies/intel_corporation/index.html?inline=nyt-org\" title=\"More information about Intel Corporation\">Intel</a> and <a href=\"http://topics.nytimes.com/top/news/business/companies/best_buy_company/index.html?inline=nyt-org\" title=\"More information about Best Buy Company Incorporated\">Best Buy</a>.</p><p>The group is setting out to create a common digital standard that would let consumers buy or rent a digital video once and then play it on any device. It might sound technical, but it could be crucial to persuading consumers to buy all the splashy new Internet-connected gear that tech companies will demonstrate at C.E.S., like HDTVs and set-top boxes that can download TV shows and films.</p><p>Under the proposed system, proof of digital purchases would be stored online in a so-called rights locker, and consumers would be permitted to play the movies they bought or rented on any DECE-compatible device. </p><p>So, for example, business travelers might find that their hotel room television could tap into their personal movie collections. Consumers could buy Blu-ray discs and have digital copies of those films accessible from all of their devices, even their mobile phones. And a PC maker could customize a new laptop for buyers by loading it with all their movies and shows &#151; and eventually even their video games and e-books.</p><p>These advances may not be all that far off. On Monday, the digital content organization plans to announce several moves that signal it is ready for companies to start building devices and services with the technology this year. Industry observers expected such an announcement last year.</p><p>The group is announcing that it has adopted a new file format that, like the DVD, will allow any company to create a compatible device or digital video store. It is also selecting Neustar, a company based in Sterling, Va., to create the online hub that will store records of people&#8217;s digital purchases, with their permission.</p><p>The group is also announcing 21 new members, pushing the effort even further toward cross-industry unity. The new companies include consumer device makers like Samsung Electronics, <a href=\"http://topics.nytimes.com/top/news/business/companies/nokia_corporation/index.html?inline=nyt-org\" title=\"More information about Nokia Oyj\">Nokia</a> and <a href=\"http://topics.nytimes.com/top/news/business/companies/motorola_inc/index.html?inline=nyt-org\" title=\"More information about Motorola Inc\">Motorola</a>, entertainment retailers like <a href=\"http://topics.nytimes.com/top/news/business/companies/netflix-inc/index.html?inline=nyt-org\" title=\"More information about Netflix Inc\">Netflix</a> and the European chain Tesco, and the cable companies Cox Communications and <a href=\"http://topics.nytimes.com/top/news/business/companies/liberty-global-inc/index.html?inline=nyt-org\" title=\"More information about Liberty Global Inc\">Liberty Global</a>. </p><p>Disney is still a holdout. It is advocating a similar plan called KeyChest, which analysts say it may introduce working with Apple. A Disney spokesman said the company would give an early look at its rival technology at C.E.S.</p><p>The DECE says that it is further along and that the technical specifications of its system will be available to other companies in the next few months. Devices and services could be available to consumers as soon as early next year.</p><p>&#8220;There were many skeptics out there who believed that with so many companies, we could never achieve anything,&#8221; said Mitch Singer, the president of the DECE and chief technology officer of Sony Pictures Entertainment. &#8220;We&#8217;ve actually achieved almost everything.&#8221;</p><p>But the effort still has a long way to go before it can claim anything like success. The proof will be whether it revives home entertainment sales by getting consumers excited about the new freedoms of the digital world.</p><p>Hollywood needs consumers to buy more digital content. DVD and Blu-ray revenues contribute significantly to Hollywood&#8217;s bottom line, but spending on those discs is dropping sharply. It declined 3.2 percent to $4 billion in the third quarter of last year. Digital sales were up nearly 20 percent in the quarter, but amounted to a relatively paltry $420 million.</p><p>And movie studios can only guess how much revenue is lost to piracy, which they say tends to grow as the speed of Internet access increases.</p><p>Hollywood also wants to avoid having a single company like Apple enticing people to buy only from its own closed digital system, and ending up with an inordinate degree of control over matters like pricing. Movie executives shudder at the power Apple accumulated over the music labels with iTunes and the influence <a href=\"http://topics.nytimes.com/top/news/business/companies/amazon_inc/index.html?inline=nyt-org\" title=\"More information about Amazon.com Inc.\">Amazon</a> appears to be gathering over publishers with e-books. </p><p>&#8220;The possibility is there for a single player to completely dominate the economics,&#8221; said Bill Rosenblatt, president of GiantSteps Media Technology Strategies, a consulting firm.</p><p>Hollywood &#8220;runs the risk of being held up and surpassed by powerful entities going it alone,&#8221; he said, adding that Amazon showed signs of doing just that with its introduction last month of Disc+ On Demand. That service lets consumers who buy certain DVDs and Blu-ray discs view the same titles on demand at no additional cost.</p><p>There is also the possibility that the DECE is making a flawed bet on the direction of technology and emerging consumer habits. Its system is primarily aimed at getting people to buy and own digital copies of films, in the same way people collected VHS cassettes and DVDs.</p><p>But an increasing number of Web services allow people to more cheaply stream movies and shows without ever permanently storing a copy. The DECE says its technology can accommodate streaming &#151; allowing members of a family, for example, to watch the same movie at the same time in different locations. But it is not clear that such a rights scheme is necessary in a purely on-demand, watch-it-once world.</p><p>&#8220;The market desperately needs this, but in some senses it is already moving past it toward rental of content over ownership,&#8221; said Danielle Levitas, an analyst at IDC. Ms. Levitas also said DECE&#8217;s progress had been slower than she expected: &#8220;I wanted to see devices in the market already announced by C.E.S.&#8221;</p><p>Mr. Singer acknowledges that &#8220;every single company knows that time is not their friend right now.&#8221; But he says that to truly spark the digital media revolution, the industry must embed its technology so deeply into digital services and devices that customers will not even notice it &#151; so that getting access to their digital content is as easy as bringing a DVD to a friend&#8217;s house. </p><p>&#8220;Consumers shouldn&#8217;t have to know what&#8217;s inside,&#8221; he said. &#8220;They should just know it will play.&#8221;</p>',NULL,'2010-01-01 12:09:03',NULL,NULL,NULL,'1','1');
insert into `posts` (`post_id`, `post_title`, `post_abstract`, `post_text`, `post_external_url`, `post_created_dtime`, `post_mod_dtime`, `post_effective_thru_dtime`, `post_author_name`, `post_status`, `user_id`) values('3','News Sites Dabble With a Web Tool for Nudging Local Officials','On SeeClickFix or on newspaper Web sites, residents can flag problems like potholes to bring them to the attention of government officials.','<p>Doug Hardy, an associate editor and Internet supervisor for The Journal Inquirer in Manchester, Conn., wanted to increase page views on <a href=\"http://www.journalinquirer.com/\">its Web site</a>.</p>\r\n<p>Mr. Hardy had heard about <a href=\"http://SeeClickFix.com\" target=\"_\">SeeClickFix.com</a>, a local advocacy Web site that lets users write about issues to encourage communication between residents and local government. SeeClickFix users post a complaint about problems that occur within a set of boundaries on a <a href=\"http://topics.nytimes.com/top/news/business/companies/google_inc/index.html?inline=nyt-org\" title=\"More information about Google Inc\">Google</a> Map, like graffiti at a bus stop or potholes on a busy street, and the site communicates the problem to the appropriate government agency and marks the problem on the map. </p><p>Users can comment on the issue or label it resolved. Government agencies can post on the site to respond to residents, and journalists can use the site to communicate with readers and see which issues are most pressing to people.</p><p>Ben Berkowitz, the chief executive of SeeClickFix, said the tool went beyond government: &#8220;Anyone can be held accountable: a business, nonprofit, even a private citizen.&#8221;</p><p> The Journal Inquirer, which covers the area around Manchester, invested in its Web site, and then paid circulation plummeted. So the editors put online content behind a pay wall. </p><p>There seemed to be a trade-off. Once visitors could no longer read articles without paying, circulation stabilized &#151; but page views dropped by about 30 percent. It fell to Mr. Hardy, the associate editor, to attract more visitors. </p><p>&#8220;We needed new strategies,&#8221; Mr. Hardy said. &#8220;We needed new ways to draw traffic to our site and to improve our product and make it more compelling.&#8221; </p><p>He thought SeeClickFix could help. Mr. Hardy drew a SeeClickFix map of the paper&#8217;s coverage area last spring and posted some sample issues, but the map did not receive responses until an article about the site ran in The Hartford Courant. After the article, Mr. Hardy noticed new issues on his map and added a SeeClickFix widget to the Journal Inquirer site last August, where it drew many comments. </p><p>The basic service is free, but Mr. Hardy spends $38 a month for SeeClickFix Pro, which features The Journal Inquirer&#8217;s logo on issues the paper selects and allows access to an advanced management dashboard.</p><p>Mr. Hardy decided to write a column based on issues that arose on the SeeClickFix widget, using either his own posts or compelling ideas from other users. Topics include long-delayed repairs to a bridge, which were completed after the article ran, and roads where dangerous speeding seemed to go unrestrained. Mr. Hardy is working on a project involving articles and video on eyesores in the area, including a dilapidated structure in Windsor, Conn., that is visible from Interstate 91.</p><p>&#8220;You look back at some of the stuff you&#8217;ve done over the years as a journalist, and you go, &#8216;I&#8217;ve written some important stories; no one ever called or wrote,&#8217;&#160;&#8221; Mr. Hardy said. &#8220;I&#8217;ve just gotten tons and tons of response to some of the stories I&#8217;ve written&#8221; using SeeClickFix. </p><p>SeeClickFix is not unique in its hyperlocal focus. Other sites, like <a href=\"http://www.everyblock.com\" title=\"Link to site.\">EveryBlock.com</a> and <a href=\"http://CrimeReports.com\" target=\"_\">CrimeReports.com</a>, post data from government organizations and news outlets. <a href=\"http://FixMyStreet.com\" target=\"_\">FixMyStreet.com</a> features discussion between residents and government officials, but only in Britain. </p><p>Mr. Berkowitz says that what sets SeeClickFix apart from other hyperlocal sites is that, anywhere in the world, it can foster interaction among government, news media and residents.</p><p>Issues were first reported on SeeClickFix in March 2008, and the site was incorporated as a business in September of that year. The four founders paid for the start-up themselves and used any revenue to develop the site. The company received an undisclosed amount of money from a group of angel investors last September but remains privately owned. Last March, it won a $25,000 <a href=\"http://wemedia.com/2008/01/23/pitch-it-bring-your-new-biz-idea-to-miami/\">Pitch It prize</a> from We Media, a company that supports media entrepreneurship.</p><p>The site is used mostly in Philadelphia, New Haven and parts of New Jersey. But Mr. Berkowitz, who has ambitious plans, recently released an <a href=\"http://topics.nytimes.com/top/reference/timestopics/subjects/i/iphone/index.html?inline=nyt-classifier\" title=\"Recent and archival news about the iPhone.\">iPhone</a> application similar to two that serve <a href=\"http://www.thepittsburghchannel.com/news/20429408/detail.html\">Pittsburgh</a> and <a href=\"http://www.boston.com/news/local/massachusetts/articles/2009/07/06/boston_to_debut_8216killer_app8217_for_municipal_complaints/\">Boston</a>. He offers the site in 72 languages and is seeking volunteer translators. </p><p>&#8220;A few weeks ago we launched home pages for 25,000 cities and about 8,000 neighborhoods,&#8221; Mr. Berkowitz said. &#8220;If your neighborhood isn&#8217;t on there, you can add it. You can even create your own free-form geography.&#8221; An e-mail alert is sent to all users in the same neighborhood when an issue is posted about it. SeeClickFix has received posts from countries as distant as Australia. </p><p>Other newspapers, large and small, have also tried the site. The New York Times uses it on one of its blog, <a href=\"http://www.nytimes.com/marketing/thelocal/\">The Local</a>, that covers neighborhoods in New Jersey. </p><p>Mr. Hardy said SeeClickFix was invaluable because it provided a broader forum beyond just writing about an issue. </p><p>&#8220;We printed a paragraph from a woman&#8217;s complaint about a deteriorated mill building in Vernon,&#8221; Mr. Hardy wrote in an e-mail message. &#8220;I got responses from the mayor, town administrator and the architect who is redeveloping the building &#151; all within 24 hours.&#8221; The Journal Inquirer had written about the mill before but had never received such a response. </p><p>&#8220;It&#8217;s just such a natural thing for us to be doing as a local paper,&#8221; Mr. Hardy said. &#8220;The ideas are basically generated by readers.&#8221;</p><p>Mr. Hardy said he had rarely seen malicious or incorrect information on SeeClickFix, and Mr. Berkowitz concurred.</p><p>Mr. Hardy said he was convinced that SeeClickFix was an invaluable tool for struggling local journalists. </p><p>&#8220;The writing is on the wall,&#8221; Mr. Hardy said. &#8220;If we can&#8217;t remain competitive, you know, we&#8217;re not going to be around. That&#8217;s the way it is; that&#8217;s the way the economy is. So if local papers are looking for a way to add their brand to the conversations people are having, this is it.&#8221;</p>',NULL,'2010-01-01 12:15:09',NULL,NULL,NULL,'1','1');
insert into `posts` (`post_id`, `post_title`, `post_abstract`, `post_text`, `post_external_url`, `post_created_dtime`, `post_mod_dtime`, `post_effective_thru_dtime`, `post_author_name`, `post_status`, `user_id`) values('4','Last decade warmest on record - Niwa','The noughties were the warmest decade on record in New Zealand, although last year was cooler than average, latest Niwa figures show','<p>The noughties were the warmest decade on record in New Zealand, although last year was cooler than average, latest climate figures from the National Institute of Water and Atmospheric Research (Niwa) show.</p> <p> \r\n \r\nThe years 2000-2009 were slightly warmer than the 1980s, which were previously the warmest decade on record and now ranked second ahead of the 1970s and 1990s.</p> <p> \r\n \r\nData on temperature change across the decade was first collected in New Zealand in the 1960s.</p> <p> \r\n \r\nThe warmer climate was due to a combination of natural variability and a background warming trend, Niwa principal scientist James Renwick said.</p> <p> \r\n \r\nThe findings were in line with a World Meteorological Organisation (WMO) prediction that the 2000s would be the warmest decade on record for worldwide average temperatures, he said.</p> <p> \r\n \r\nHowever, a WMO prediction that 2009 would be the warmest year on record was not borne out in New Zealand, which saw slightly cooler than average temperatures.</p> <p>New Zealand also missed out on much of the extreme weather which last year caused devastating floods, severe droughts, and storms in many parts of the world.</p>\r\n<p> \r\n \r\nChina suffered its worst drought in 50 years, while tropical cyclones lashed the Pacific, causing floods which left 900 dead in the Philippines.</p> <p> \r\n \r\nNiwa\'s full summary of the New Zealand climate last year is due next week.</p> <p> ',NULL,'2010-02-01 01:23:00',NULL,NULL,NULL,'1','1');
insert into `posts` (`post_id`, `post_title`, `post_abstract`, `post_text`, `post_external_url`, `post_created_dtime`, `post_mod_dtime`, `post_effective_thru_dtime`, `post_author_name`, `post_status`, `user_id`) values('5','$2.6m for posh-school entry under fire as elitist','Private-school scholarships for poorer students have been attacked as an \"elitist\" use of taxpayers\' money.','<p>Private-school scholarships for poorer students have been attacked as an \"elitist\" use of taxpayers\' money.</p> <p> \r\n \r\nBut the Government says it is simply about giving choice to families who could not otherwise afford it.</p> <p> \r\n \r\nFrom this year, the Government is providing $2.6 million worth of scholarships to allow students from low-income families to attend a private school.</p> <p> \r\n \r\nThe Aspire Scholarships will provide up to $15,000 towards the fees for every year a student attends the school.</p> <p> \r\n \r\nUp to $1500 will also be provided for course-related costs.</p> <p> \r\n \r\nThe scholarships are part of a larger annual $10 million boost by the Government to \"support wider access to private schools\".</p> <p> \r\n \r\nLindsay Adams, a former principal of Glendowie College in Auckland, questioned why the taxpayer should be paying $2.6m for students to leave the state-funded education system.</p> <p>\"Has a proper evaluation of this apparent elitist policy been put in place, or is it a means of buying Act [Party] support?\"</p>\r\n<p> \r\n \r\nAssociate Education Minister Heather Roy, the Act MP who pushed for the scholarships, said providing \"more choice\" in education was part of her party\'s agreement with National.</p> <p> \r\n \r\nThe money for the Aspire Scholarships had already been allocated for private schools. Aiming it at students in poorer families was the \"exact opposite of elitist\", Ms Roy said.</p> <p> \r\n \r\n\"It\'s purely about increasing educational opportunities and choice for those students who wouldn\'t normally have the ability to go to a private school.</p> <p> \r\n \r\n\"I certainly don\'t believe that necessarily the best school for a student is the one that is just down the road from them,\" the minister said.</p> <p> \r\n \r\nThe country\'s largest education union, the NZ Educational Institute, said the scholarships were just another \"hare-brained scheme\" that failed to address the deficiencies in schooling.</p> <p> \r\n \r\n\"This [scholarship] money will be taken out of that pool of money that the public sector system desperately needs,\" said national secretary Paul Goulter.</p> <p> \r\n \r\n\"The people inside the [public] schooling system ... are all working damned hard to try to offer effective choice to people who principally have come from lower-decile areas.\"</p> <p> \r\n \r\nMs Roy said it had to be remembered that private schools saved the country money.</p> <p> \r\n \r\nAsked if she would like to see a greater proportion of New Zealand children in private schools, she said: \"It\'s not the role of politicians to comment on where students should be going to school.\"</p> <p> \r\n \r\n<b>A HAND UP</b></p> <p> \r\n \r\n<b>Aspire Scholarships</b></p> <p> \r\n \r\n* 150 scholarships will be handed out in the 2010 school year - 50 each in Years 9, 10 and 11. The total will increase to 200 in 2011 and 250 in 2012.<br>* To be eligible for the scholarship, a student\'s primary carer(s) must not be a beneficiary of a trust, and the carer(s) must have a yearly gross income of $65,000 or less and a net worth of $150,000 or less.<br>* Applications are chosen randomly from a ballot and successful applicants are required to enrol in a school independently.</p> ',NULL,'2010-02-01 02:12:16',NULL,NULL,NULL,'1','1');
insert into `posts` (`post_id`, `post_title`, `post_abstract`, `post_text`, `post_external_url`, `post_created_dtime`, `post_mod_dtime`, `post_effective_thru_dtime`, `post_author_name`, `post_status`, `user_id`) values('6','Dog-attack victim blames owner','Her eye had to be stitched open, her cheekbone was broken, several of her teeth were crushed and she has no feeling on the left side of her face.','<p>Her eye had to be stitched open, her cheekbone was broken, several of her teeth were crushed and she has no feeling on the left side of her face.</p> <p> \r\n \r\nBut Christine Breen says she has nothing against the dog that savaged her face - her anger is directed rather at the owner who made the animal that way - and she will continue to help get animals off the streets.</p> <p> \r\n \r\nThe Auckland woman, a trustee for the Chained Dog Awareness animal welfare group, has rescued hundreds of cats and dogs abandoned by their owners over the past eight years.</p> <p> \r\n \r\nWhile doing a routine round in Manurewa a week before Christmas, she stepped out of her car and immediately dropped something from her handbag.</p> <p> \r\n \r\nBending down to pick it up, she looked up to see a dog\'s mouth snapping at her before it ripped through her face.</p> <p>A couple who saw the attack ran to Mrs Breen\'s aid and yanked the dog off her, but it promptly ran back at her, attacking the back of her neck.</p> \r\n<p> \r\n \r\nShe was knocked out cold.</p> <p> \r\n \r\nMrs Breen was rushed to Middlemore Hospital, where she had extensive surgery to repair her face.</p> <p> \r\n \r\nShe will need to make further trips to the hospital in the coming weeks.</p> <p> \r\n \r\nBut she says she does not blame the dog - which has since been put down - but the hundreds of owners who continue to abandon and abuse dogs who in turn attack people.</p> <p> \r\n \r\n\"Some [owners] are disgusting. That dog was skeletal and it had been caged - you could tell by the fly-strike on its ears. It was vicious - and a person made him that way.\"</p> <p> \r\n \r\nMrs Breen said she had seen hundreds of cases where people had mistreated their pets, which turned them into aggressive animals.</p> <p> \r\n \r\n\"I had one dog who was chained out the back and never given any water just because [the owner] was lazy.</p> <p> \r\n \r\n\"The owner used to bite her ears to punish her.\"</p> <p> \r\n \r\nThat dog now regularly lies sound asleep in Mrs Breen\'s lounge, with several cats and other dogs she fosters before putting them into better homes.</p> <p> \r\n \r\nShe said more people - specifically local councils - needed to introduce greater punishments for people who abandoned and mistreated their animals because they were the real problem.</p> <p> \r\n \r\n\"I\'m an animal lover and I think it\'s a privilege to own an animal.</p> <p> \r\n \r\n\"A lot of these [owners] don\'t see animals as a living thing. They chain them up and keep them under the house for years, and that\'s how they end up like this.</p> <p> \r\n \r\n\"[An aggressive dog] could get a child next time and a child wouldn\'t have had a chance. We don\'t want these types of people with dogs.\"</p> ',NULL,'2010-03-01 10:32:21',NULL,NULL,NULL,'1','1');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment