Birdfeed
Delete nodes programatically through Drupal
This little bit of code is helpful. Note, this code would delete all events, but you can modify the query as needed.
<?php
$aquery = db_query("SELECT n.nid FROM {node} n WHERE n.type = 'event'");
if(db_num_rows($aquery) && user_access('administer nodes')) {
while ($n = db_fetch_object($aquery)) {
set_time_limit(5); // keep it from timing out
node_delete($n->nid);
}
}
else {
echo "No nodes found or you do not have permission to modify nodes.";
}
?>Submitted by canary on Fri, 06/27/2008 - 1:15pm
Recent Posts
Tags in Tags
Archive
October 2014
July 2014
June 2014
- Philly arts and culture reporters share tips on how to get great press coverage
- Blog post: Outside(r) Art
May 2014
- Philly arts organizations take on social media fads: A short history
- Entrepreneurship and Risk-Taking in Arts Organizations
- A Look Ahead This Month
April 2014
March 2014
February 2014
January 2014
- Philly's Top Broadcasters Weigh In: What Makes the Evening News?
- Top 10 Philadelphia Arts and Culture Orgs on Pinterest
- Be a Belieber in marketing your arts organization to teenagers
- Top Arts Marketing Resources for 2014
December 2013
- The Constant Grammarian: Three Grammar Resolutions You'll Want to Keep in 2014
- 2014: The Year Ahead
- ICYMI: Getting meta on social media, and other November reading
- Making Spirits Bright: Canary’s Holiday Favorites
- Canary Promotion Wins Two Awards from the PRSA!
November 2013
- ICYMI: What would you do if you were banned from Twitter?
- FB embed test
- Messaging in a Bottle: How to Tell a Compelling “Story of Us”
- The Hot Topic of Crowdfunding for Conservation
October 2013
- ICYMI: Where we've been this fall, and where we're going
- Canary Guest Blogs for Americans for the Arts: A Holistic Approach to Communications
- PR in the Age of Shortening: Should we join ’em if we can’t beat ’em?
September 2013
- Megan Wendell on Keystone Edge: Growth, inspiration and putting the arts first
- Canary in Harrisburg for the Launch of Pennsylvania’s Top 10 Endangered Artifacts
- Canary News: Fall Arts Bounty, Winning at the Geek Awards, Social Media Tips
August 2013
- Playing Favorites: Where to find the Canary staff at the 2013 Fringe Festival
- Weekend Wrap Up: Great Press for Mauckingbird and Puppet Festival (r)Evolution
- More Than Words: Bringing Audiences Into the Moment with Instagram
July 2013
- ICYMI: What We're Reading This Summer
- 6 Ways Twitter Can Help Sell Tickets (Part 2)
- 6 Ways Twitter Can Help Sell Tickets (Part 1)
June 2013
- Adventures in Pittsburgh: How cultural storytelling can invigorate a city
- ICYMI: What Caught Our Attention in May
May 2013
- The Constant Grammarian, Part 3: Thou Art Banished
- Spring 2013 Newsletter: What Kind of Leader Are You?
- Crowdsourcing: How Honesty Moves Us Forward
- So You’ve Hired a Communications Team – Now What?
- ICYMI: What Caught Our Attention in April
- Third Time’s the Charm: Congratulations to the 43 winners of the 2013 Knight Arts Challenge!
April 2013
- Five Signs It’s Time to Hire a Communications Firm
- Stop Wasting Money: How to Stretch Your Facebook Ad Dollars
- ICYMI: What Caught Our Attention in March
March 2013
- Take readers behind the scenes — even while you're setting the stage: A content marketing strategy for arts organizations
- Faces of PRSA Philly: The Canary edition
- Connecting Organically: How PR drives SEO results
- The Future of Cultural Journalism: Inspiration, Innovation and Proactivity
February 2013
- What’s the future of cultural journalism? How can art connect communities?
- Canary Goes Global: World-class culture in the City of Brotherly Love
January 2013
- Cultural Moments of 2012: Megan's Picks
- Cultural Moments of 2012: Rose's Picks
- Cultural Moments of 2012: Carolyn's Picks
December 2012
November 2012
October 2012
- A Better Barrymore? Theatre Philadelphia: A Celebration! gave the arts community a much-needed boost at just the right moment.
- Internship Alert: Canary Promotion is hiring PR/Marketing interns this fall!
September 2012
August 2012
July 2012
- Philly 101 Wrap Party @ Frankford Hall: What You Wish You Knew, Now You Know
- The Constant Grammarian, Part 1: Seven Words and Phrases You Didn’t Know You Didn’t Know
- Canary Promotion Newsletter: Summer 2012
June 2012
- Insight into Insights: Reach Your Goals With the Right Facebook Campaign
- Insight into Insights: Reach Your Goals With the Right Facebook Campaign
May 2012
April 2012
- Congratulations to the 2012 Knight Arts Challenge Philadelphia winners!
- Rediscover Public Art with Fairmount Park Art Association
March 2012
January 2012
December 2011
- 5 Things You Can Do For Your Small Business Right Now
- Canary Promotion Welcomes Carolyn Huckabay of Philadelphia City Paper as Public Relations Associate
- 10 years, a bounty of art, and a job that still thrills me
- Young Voices Were On the Minds of TEDxPhilly Speakers
November 2011
October 2011
- Festivals, Public Art, Drama & Dracula: What We're Working On This Season
- Plenty to see this weekend as DesignPhiladelphia winds down. Stop by Not A Vacant Lot!
- 6 Tips for Getting Press-Perfect Photos
August 2011
July 2011
- Knight Foundation and NEA Seek New Models for Arts Journalism
- Live Arts Festival Tickets On Sale Now!
June 2011
- With Facebook Ads, It's All About the Timing.
- We're hiring: PR & Marketing Coordinator position available
- The Value of Intangible Goods. How Donating Your Knowledge Makes a Difference.
May 2011
- The Cultural Engagement Index, Why Audience Participation Matters
- Congratulations to all of the Knight Arts Challenge Philadelphia 2011 Winners!
April 2011
- A mural party at the Rosenbach, a frank conversation with Maurice Sendak & the musically inspired “Grace Notes”
- Canary Promotion Newsletter: Spring 2011
- Spring is in the air! The Canary office gets spruced up for Spring.
- Our PIFA Picks: A Cultural Playground in April
- 6 Essentials for Successfully Working with the Media
- Woodmere Art Museum Opens Five New Exhibitions
March 2011
- Spring Break at Live Arts Brewery - A Laboratory for Research and Development
- Connecting With Your Community Through Facebook Ads
- Ars Nova Workshop presents Fieldwork, “A jazz power trio for the new century” (NPR)
- Put A Bird On It!
- Final Days to See John Folinsbee and American Modernism at the Woodmere
February 2011
- 7 Ways to Improve Your PR Writing
- Sometimes these Canaries need their creative-beauty sleep
- Young Voices High School Monologue Festival On Stage at The Adrienne Theater This Week
- The Associated Press, NPR, Philadelphia Inquirer & New York Times are all talking about the Rosenbach's Sendak Mural
- John Folinsbee and American Modernism Lecture Series at Woodmere Art Museum
January 2011
- Our Favorite Cultural Moments of 2010: Megans' Picks
- Our Favorite Cultural Moments of 2010: TEDxPhilly
- Our favorite cultural moments of 2010: Flash Opera, The Return of the Cultural Flash Mob to Philadelphia
- Our 2010 Year in Review
December 2010
- We're taking a holiday break!
- Rescue Your Blog with an Editorial Calendar
- Philadelphia’s got talent, United States Artists Knight Fellows announced
- Holiday Shop at Woodmere Art Museum
- Holiday Shop at Woodmere Art Museum
November 2010
- Ladies Rock Camp - the perfect gift for the ladies in your life
- Museum Without Walls: AUDIO the subject of national Associated Press story
- Chester County Historical Society Launches Social Media Campaign
- The Rosenbach Museum & Library announced today news of stunning new portraiture acquisitions
- Woodmere Art Museum Upcoming Community Events
October 2010
- Theater showcase by & for youth in Philadelphia touches on big issues at the right time
- TEDxPhilly, November 18, 2010 at the Kimmel Center.
September 2010
August 2010
- Two thumbs up for Mauckingbird's revamped queer "A Midsummer Night's Dream"
- How creative PR & marketing work together to draw in new audiences
July 2010
- Museum Without Walls™: AUDIO wins Philadelphia Magazine BEST of PHILLY 2010 Award!
- The Rosenbach's new 'Dreadful Things Happen' exhibition reviewed in today's Inquirer
- Philadelphia Weekly “Picks for Best Theater This Year” Includes Five Canary Client Mentions!
- Canary News: Announcing some changes & new opportunities
June 2010
- We're Looking for PR/Marketing Interns for the Fall!
- Fringe Fest Sideshow: Opportunity for Philly Fringe Artists & Fans
- Today, Celebrate Bloomsday with the Rosenbach Museum & Library at Trinity Center for Urban Life
- Museum Without Walls™: AUDIO Program Officially Launches at LOVE Park
- Thursday, June 10th, Fairmount Park Art Association launches the groundbreaking Museum Without Walls™: AUDIO program in LOVE Park!
May 2010
- The Wilma Theater's U.S. Premiere of "Leaving" Opens TONIGHT!
- Drupaldelphia Wrap-Up
- Canary client Swim Pony Performing Arts will host Philadelphia's next large-scale improv event!
- The 2010 Philadelphia Live Arts Festival + Philly Fringe Line-up is Announced!
April 2010
March 2010
February 2010
- Google Chrome - Search Any Site from the Address Bar
- The New York Times reviews Philagrafika 2010, a Canary PR client!
December 2009
November 2009
October 2009
- displaying location fields in a view
- Happy 200th Birthday, Edgar!: Brat Productions Celebrates with One-of-a-kind Theatrical Haunted House
- safari clips div when using anchor tags
- Philadelphia: Where the Wild Things Are + Sendak Mania at the Rosenbach
- string parsing code to get url from image tag
September 2009
- Philadelphia Live Arts Festival & Philly Fringe Opens Today!
- Pig Iron Theatre Company's Welcome to Yuba City
August 2009
- Drupaldelphia
- We're hiring! FT Publicity & Marketing Assistant
- Replace Taxonomy pages w/ Embed Views
- Embed Views
- creating a style for every n-th item in a list
- incremental classes when grouping multiple cck values in views
- Custom CCK Formats
July 2009
- Blueprint Grid Overlay in the Browser
- Grid Nirvana - How to Easily Incorporate Blueprint into Photoshop
- Theming a page by arbitrary content types
- Bloomsday Gives Joyceans a Reason to Love Philadelphia
June 2009
- Get the path to a Drupal module or theme
- Canary attached files
- IE doesn't load stylesheets / IE doesn't load conditional comment stylesheets
- IE6 PNG Fix
May 2009
- Watch nEW Festival Artist Interviews on StreetTalkin.com
- Add a custom ID to menu items based on the text in the link
- Even out different date fields across content types
- Embed Views2 blocks w/ PHP
- Views2: Find the first NID from another view to use as an argument
- Watch WHYY: Experience Philadelphia Young Playwrights
April 2009
- When Logos Attack!
- April-June Canary Client Events
- new_dancehouse
- PDF: April-June events from Canary Promotion
March 2009
- Blueprint Grid toggler D6 module
- delete .svn folders from the cli
- Convert string to CSS friendly text
- Display taxonomy terms from one vocabulary id
- site setup bash script
- Web Design and Drupal Internship Available
- DrupalCon DC as a mind map
- custom php.ini on site5
- Canary at DrupalCon DC
- Canary Promotion + Design seeks Web Designer/Developer
February 2009
- PR/Marketing Internship Opening
- custom jQuery accordion menu function for drupal primary menu
- South Street offers empty storefronts to artists
January 2009
December 2008
November 2008
- Client Testimonial: Neil Baldwin
- DrupalCamp Philly
- Complaint Choir on CBS 3!
- The 6 Dangerous Fallacies of Social Media
October 2008
- Inaugural BarCamp Philly to be held November 8
- Treehouse of Horror: Canary Pumpkins Rule the Night
- First Person Festival
- calibrate your monitor
September 2008
- Val Emmich, Little Daggers
- Ben Franklin persists
- Rock 'n' Roll at The Wilma Theater
- Sarah Palin and Hillary Clinton on SNL
- Help Elect Barack Obama. We can't afford to lose this.
- Connecting to MYSQL via terminal
- Live Arts Festival & Philly Fringe: in print, online & on the air
August 2008
- Live Arts Festival’s Kate Watson-Wallace talks Car in PW cover story
- Take the A List Apart Survey for People Who Make Websites
- White Screen of Death [WSOD] on form Submit
- grp_camp3bybrookebocast-small
- find and delete files in ssh
- Mauckingbird's R&J in the Inquirer
- Girls Rock Camp on MTV
July 2008
- Classic Towns of Greater Philadelphia
- Classic Towns - Home Page
- Classic Towns - Map
- Philly's New Culture Chief
- First Person Impressions
- First Person Impressions
- Mayor Nutter announces Arts & Culture Office
- split arrays into two for multiple columns
- Placing the contents of a block in any location
- Free your content of PHP: Moving PHP code out of blocks, views and nodes
- How to Call Attention to Yourself
- Ben Franklin & Betsy Ross Wedding
June 2008
- Delete nodes programatically through Drupal
- Backup/Restore MySQL via SSH if you can't access phpmyadmin
- Why good design matters
- When Logos Attack!
- Bloomsday at the Rosenbach today!
May 2008
- ffmpeg, the flashvideo module and testing locally on Windows
- Imagecache issues after inserting presets via query
- Browser detection in PHP
- Drupal Meetup at Canary Recap
- Sendak on Sendak on Video
- votebarack
- adding the servername to site5 nameservers
- clean urls on site5 before the domain is active
April 2008
- Creating email addresses on Site5
- Vote Early, Vote Obama
- Vote Obama Today
- Views Theming Wizard output incorrect
- remotely connect to mysql server - Site5
- File permissions
- wait for full page to load (not just the DOM) when resizing elements with jquery
March 2008
- Emulate word-wrap in Mozilla Firefox
- 500 Internal Server Error upon uploading site to Site5
- Lost Weekend: SXSWi 2008
- MYSQL ERROR: "MySQL server has gone away"
- Day One at SXSW
- SXSW Marathon, or, Will We Really Get to All 30 Panels?
- John Refano is Awesome
February 2008
January 2008
- My loony bun is fine, Benny Lava.
- Dispatches from Google chat: Jon Stewart strikebuster edition.
- The Museum of Baby Heads
- All the baby heads
December 2007
- WING TIPS: Canary's Favorite Things - Cool Gifts for the Holidays
- Best Potential Client Inquiry Ever
- President George W. Bush looks at a bronze bust of himself
October 2007
September 2007
August 2007
July 2007
June 2007
May 2007
April 2007
March 2007
- How to talk to the media
- Cold Rock The Auction Block
- Where the Wild Things Are
- Take the Chekhov Lizardbrain Challenge
- I leave for SXSW this week
- Anton Chekhov is Taking Over Philadelphia
February 2007
- Snow Days
- Snowing Like Hell
- The Hoohah Monologues
- It's the Arts, stupid
- Little Fat Man Who Sold His Soul
- Wing Tip - Tour the UK
November 2006
October 2006
- Barrymore Awards Announced!
- Megan with Aaron Immediato and James Haskins from The Wilma Theater
- Rotunda ceiling
- Benergy!
- Franklin Memorial
- PhawkerBen
- Automn Wissahickon
- Fall
- Promotional timelines, advance planning
September 2006
- Live Arts/Philly Fringe recap, Sept. 9-16
- Live Arts/Philly Fringe recap, Sept. 5-8
- Amnesia Curiosa
- Proper Manners and Haunting Houses
- Still Unknown
- Still Unknown
- Dark times in trucks and the old west
- Cheerleaders, strippers and puppets, oh my!
August 2006
- Launching ColbertNation.com
- Colbert Cal 07-23
- Colbert Cal 07-22
- Colbert Cal 07-21
- Colbert Cal 07-20
- Colbert Cal 07-19
- Colbert Cal 07-18
- Bruce Banner
- Suburban Love Songs
- Bash Photos
- Anniversary Bash Success!
- Canary in the news!
- I'll Bash the Bash before it Bashes Me!
- Is this a nude event?
- Colbert Report taping