Happy Halloween from Chameleon Web Services
We get asked many times “Is there a way in wordpress to delete all comments using sql”?
Well the answer is yes, rather than having to delete around 50 comments a time using the backend of WordPress you can login to the database using a SQL program such as PHPMyAdmin or Navicat and run the following command:-
DELETE FROM wp_comments WHERE comment_approved = 0
This will query the database and find in the table wp_comments an entry that has not been approved yet and delete the entire entry.
An example on clients website there was 10,872 spam comments waiting to be approved. We ran this command to delete all the WordPress comments and the result:-
[SQL] DELETE FROM wp_comments WHERE comment_approved = 0
Affected rows: 10872
Time: 0.422ms
So it took 0.422 milliseconds to remove all 10,872 spam comments.
Getting in touch with your audience is a huge way to a success for a brand.
We love what Coke did her to help advertise the Launch of the 007 film “Skyfall”.
They setup a Coke machine at a train station in London and random people at the station who wanted to by a coke got a suprise.
They were offered a chance to win tickets for the screening of Skyfall film if they could be bond for 70 seconds.
If you have a WordPress website then you need to make sure you backup the website data just incase something goes wrong.
WordPress is made up of the core files and a database. So you need to backup everything. To Backup the WordPress Core Installation you will need an FTP client. If you take a copy of everything you will be copying:-
1. WordPress Core Installation Files
2. WordPress Plugins Files
3. WordPress Themes Files
4. Images and additional Files.
5. Coding fiels such as Javascript, PHP, etc
6. .htaccess file
7. Robots file
8. Sitemap.xml file
Taking a full backup ensures you have everything you need to rebuild WordPress and once you have these files safe you can also use them if you get hacked to quickly erase what the hackers changed.
You now need to backup the complete database using something like phpMyAdmin. WordPress provide an export facility to export the content of the website but this is not a complete backup of the data.
August 2012 and Apple’s market value exceeds that of Microsoft’s during 1999 growth and Apple announced on Monday 20th August 2012 that the market value climbed to a value more than $623 billion making Apple the most valuable company of all time.
But Google now own Motorola and they have unleashed an attack on Apple in the courts using asking the U.S. International Trade Commission (ITC) to ban the import of all iPhones, iPads, and Macs and this at a time when Apple are celebrating success.
Motorola Mobility has commented that “We would like to have settled these patent matters, but Apple is unwilling to work out a license and this leaves us little choice but to defend ourselves and our engineers’ innovations,” .
Apple has already been in this argument regarding Motorola’s licensing and they have said that the fees are disproportionally too high.
The ITC have also said Apple had infringed one of Motorola’s patents and this could mean that there is a ban on iPhone imports as soon as early as next week.
Apple has been asking for it, and it looks like Google are giving it to them. Larry Page, Google’s chief executive said: “Our acquisition of Motorola will increase competition by strengthening Google’s patent portfolio, which will enable us to better protect Android from anti-competitive threats from Microsoft, Apple and other companies.”
If Google wins and the ITC agree, there might not be any iPhones, iPads or Macs in stores in the near future.
Apple might be regretting ever getting into this patent war with both Motorola and Samsung.
