You sure all know Google Alerts, helping you to stay up to date about certain keywords.
For a long time you could enter your keywords and choose an RSS export
for your alerts. But because the Google Reader doesn’t exist anymore,
Google doesn’t offer these customized RSS feeds. But with a little trick
you can still create and use them.
You just need the following URL:
https://news.google.de/news/feeds?pz=1&cf=all&ned=LANGUAGE&hl=COUNTRY&q=SEARCH_TERM&output=rss
And replace the words LANGUAGE, COUNTRY, and SEARCH_TERM
So if you want a german Feed about “Social Media” it looks like:
https://news.google.de/news/feeds?pz=1&cf=all&ned=de&hl=de&q=Social+Media&output=rss
And that´s it; your customized RSS feed. Just copy this URL and add it to your favorite RSS Reader.
Showing posts with label Bloging. Show all posts
Showing posts with label Bloging. Show all posts
Wednesday, March 30, 2016
Sunday, February 28, 2016
100 popular dofollow web directories that are completely free!
A list of a 100 dofollow web directories that are completely for free!
Dofollow Directory List
Tuesday, January 5, 2016
45+ Social Bookmarking/News Sites You Should Consider
- BibSonomy:BibSonomy is run by the Knowledge Data Engineering Group of the University of Kassel, Germany. It’s specifically designed for researchers to share bookmarks and bibliographies
- Blinklist: A social bookmarking site launched by Mindvalley. According to their site, they launch several web businesses a year and are focused in 3 areas. – Technology, media and Marketing. BlinkList does have a user-friendly interface indicating that its being run well and efficiently. They also quote “fully profitable” on their site. Furthermore, you can label and comment about any web page on the Internet.
- BlogBookMark: Designed specifically for Blog hunters, BlogBookmark.com claims to have the hottest news, gossip, and blog chatter from around the web. I highly sugggest that mainstream bloggers bookmark their entire sites here.
- blurpalicious: Get Blurped! Not too different from other social bookmarks, but I love the tagline.
- Clipclip: Clipclip allows you to save images and text, with a “bookmarklet”.
- Cloudytags: A unique word analyzer connects to your page, gets all the words and suggest you the real tags your site is showing to the world
- delicious: THE social bookmarking site. It allows you to easily add sites you like to your personal collection of links and to categorize those sites with keywords. Not to mention that if enough people save your site in a bookmark, it will make their popular page and send a lot of traffic. Delicious is owned by Yahoo and is a MUST for your social media and bookmarking strategy.
- Diigo: Social bookmarking on steroids.
- Digg: The social news site that changed the Internet, Digg is a high power authority and a listing in Digg for a site, even if it only has a couple of votes, will rank highly on Google and other search engines for certain terms. If your site is shared and voted upon on Digg, and makes the Digg homepage, you’ll get a lot of traffic and attention from other bloggers who read Digg.
- Bookmark-manager: Organizer for bookmarks, calendar, diary and knowledge.
- Bookmax: You can store your bookmarks and links to your favorite sites online and access them from wherever you are : basic Social Bookmarking.
- Buddymarks: The online personal, group and social bookmarks manager.
- lifelike: A free service to help academics to share, store, and organise the academic papers they are reading.
- Dropjack: DropJack.com is a social content website and owned by the ExactSeek company.
- Easybm: Allows users to bookmark their frequently visited sites on their private page, allowing 1-click access to their favorite web sites.
- ez4u: Social Bookmarking – Ez4u to Bookmark : “Ez4u to Organize Ez4u to Share with Others Ez4u to Remember”
- Favoor: Favoor is your personalized new start page. Collect your favorite internet addresses.
- Folkd: Folkd is a social web-service about pages, news, audios, videos and blogs.
- Freelink: Freelink.org provides free pages of links that you can access anywhere at anytime.
- Furl: Like Delicious, LookSmart’s Furl.net is one of the first social bookmarking sites and considered an authority by the major search engines. Listing your sites in Furl will lead to traffic from organic rankings and its popular page drives traffic.
- Gather: Gather is a place to contribute articles and content, blog, tag and connect with people who share your passions. (Plus you can link out from the articles in this authority site).
- Google: Allows users to save and create bookmarks in their Google toolbar that can be accessed anywhere online. Google is getting more social by the day, so take advantage of their Google bookmarks and citations, because one day they probably will have some kind of influence on external meta data considered by the Google ranking algorithm.
- Hyperlinkomatic: This is a bookmark list manager.
- i89.us: i89.us offers a free service which allows you to save your favorite website/links at one location that can be accessed from anywhere.
- Kaboodle: Kaboodle is a 2.0 shopping community where people recommend and discover new things.
- Kinja: Kinja is a blog guide, collecting news and commentary from some of the best sites on the web.
- Lilsto: Lilisto lets you store, manage and find your favorite links (or bookmarks) and removes the need to maintain them through your browser.
- Linkagogo: Favorites and Social Bookmarking Application, its unique dynamic toolbars automatically adapt themselves.
- Linkarena: German Social Bookmarking site.
- Markaboo: MarkaBoo is tool for saving websites, files, and notes from your browser, email or mobile phone.
- Memotoo: Lets users centralize and share your personal data.
- Mister Wong: Mister Wong is a social bookmarking site that originated in Germany, and has since become a popular and widespread tool.
- Murl: My URLs is a free online bookmarks manager, think of it as a bookmarks community.
- MyBookmarks: MyBookmarks – access your bookmarks anytime, anywhere. Free productivity tool for business, student or personal use. Another popular bookmarking site.
- Myhq: Store your bookmarks in one central location. Fast, text-based, banner free!
- MyLife: A social search engine where users can find others
- mySiteVote: mySiteVote is a community where you can vote your favorite site/s and view how popular a site is.
- MyWebDesktop: A collaboration and communication tool, designed to be as generic and easy to use as a telephone and email.
- Newsvine: The mission of Newsvine is to bring together big and little media in a way which respects established journalism.
- Icio: Danish bookmarking engine.
- Ikeepbookmarks: Popup feature allows you to add links while surfing the web
- Iloggo: Simple web-based bookmarking tool that you can use for attractively displaying your favorite websites on one page.
- Reddit: Timely and shocking news oriented, Reddit stories are instantly voted upon and if liked by the community as a whole, can drive incredible traffic and users.
- Segnalo: Italian Social bookmarking site.
- Sitebar: A solution for people who use multiple browsers or computers and want to have their bookmarks available from anywhere without need to synchronize them
- Sitejot: Free online bookmark manager. Like every other social bookmarking site, it allows users to manage all of their bookmarks online in one convenient place.
- Startaid: I’ve noticed that StartAid bookmark pages rank highly in Google and other search engines. This basic bookmarking service allows users to describe, tag and categorize sites.
- StumbleUpon: Owned by eBay, StumbleUpon is an amazing blend of social bookmarking, voting, networking, web surfing, search and blogging. Best of all, StumbleUpon can send major traffic with its userbase of around 3 million users.
- Stylehive: The Stylehive is a collection of all the best products, brands, designers and stores discovered and tagged by the Hive community
- Tagza: A very young Social Bookmarking site mostly being used by Indian and Pakistani web masters.
- Whitelinks: Securely store and quickly access favorite websites whenever connected to the Internet,:
- Slashdot : The godfather of social news, SlashDot bookmarks are still quite powerful .. keep in mind the site has a heavy slant towards Linux and Open Source issues.
- Squidoo: Kind of spammed out, Squidoo is a 2.0 property which lets people and businesses set up a ‘lens’ which lists links, tags and relevant RSS feeds to different subjects.
- Wirefan: Social bookmarking, news articles submission site.:
- Xilinus: Organize and manage bookmarks online.:
- Yahoo! Bookmarks: Easily one of the most popular social search and bookmarking service on the web. It’s similar to Delicious and something they launched before acquiring Delicious. Yahoo Bookmarks lets users store bookmarks using their Yahoo Toolbar and access them from any computer.
Tuesday, September 15, 2015
Adding Schema Markup to WordPress Theme
Adding Schema Markup to WordPress Theme for Better SEO
For those who doesn’t know. Schemas, i.e., html tags, that webmasters can use to markup their pages in ways recognized by major search providers. Search engines including Bing, Google, Yahoo! and Yandex rely on this markup to improve the display of search results, making it easier for people to find the right web pages.
Many sites are generated from structured data, which is often stored in databases. When this data is formatted into HTML, it becomes very difficult to recover the original structured data. Many applications, especially search engines, can benefit greatly from direct access to this structured data. On-page markup enables search engines to understand the information on web pages and provide richer search results in order to make it easier for users to find relevant information on the web. Markup can also enable new tools and applications that make use of the structure.
A shared markup vocabulary makes it easier for webmasters to decide on a markup schema and get the maximum benefit for their efforts. So, in the spirit of sitemaps.org, search engines have come together to provide a shared collection of schemas that webmasters can use. – description via schema.org
Using Google Tools to Check Your Page Schemas
First check if your site and inner page already schema-ready. Go to Structured Data Testing Tool and enter your website or webpage address. If everything went well, you should see a results similar to below screenshot.
if not then you should consider starting to add schema markup on your website for better search engine optimization results. Don’t worry here’s an easy step by step tutorial on How to Add Schema Markup to your WordPress Theme.
1. Register a Google Plus Account
For the schema to work, you need a Google Plus Profile URL so register a new plus account now. Skip this step if you already had one.2. Adding rel=’publisher’ to your WordPress Theme
Open header.php and just before closing of </head> add this code with your own google plus profile id for publisher profile.1 | <link rel="publisher" href="https://plus.google.com/xxxxxxxxxxxxxxxxxxxx" /> |
3. Create Schema Data Templates
Create a new php file and copy paste this code into it and name it to schema.php and moved to your theme root. wp-content/your-theme-name/schema.php1 | <div style="width:10px;height:10px;position:absolute;left:-9999em" class="post-schema"> |
2 |
3 | <article itemscope="" itemtype="http://schema.org/Article"> |
4 |
5 | <span class="entry-title" itemprop="name headline"><a itemprop="url" href="<?php the_permalink(); ?>" rel="bookmark" title="<?php the_title(); ?>"><?php the_title(); ?></a></span> |
6 |
7 | <!-- Insert data:Person schema --> |
8 | <span itemprop="author" itemscope="" itemtype="http://schema.org/Person"> |
9 |
10 | <!-- Insert data:rel:Author schema --> |
11 | <span itemprop="name"> |
12 | <a href="https://plus.google.com/xxxxx-your-id-xxxxxx?rel=author" itemprop="url">YOUR NAME</a> |
13 | </span> |
14 |
15 | <!-- Insert data:others schema *optional --> |
16 | <span itemprop="givenName">YOUR FIRST NAME</span> |
17 | <span itemprop="familyName">YOUR FAMILY/LAST NAME</span> |
18 | <span itemprop="email">YOUR EMAIL ADDRESS</span> |
19 | <span itemprop="jobTitle">YOUR TITLE</span> |
20 | <span itemprop="brand">YOUR BRAND</span> |
21 |
22 | </span> |
23 |
24 | <!-- Insert data:Published schema --> |
25 | <time datetime="<?php the_time('Y-m-d') ?>" itemprop="datePublished"></time> |
26 | <time class="entry-date updated" datetime="<?php the_modified_time('d F Y') ?>"><?php the_modified_time('d F Y') ?></time> |
27 |
28 | <!-- Insert data:Author schema --> |
29 | <span class="vcard author"><span class="fn"><?php the_author(); ?></span></span> |
30 |
31 | <!-- Insert data:ArticleSection schema --> |
32 | <?php |
33 | $categories = get_the_category(); |
34 | $separator = ', '; |
35 | $output = ''; |
36 | if($categories){ |
37 | foreach($categories as $category) { |
38 | echo '<span style="display:none;" itemprop="articleSection">' . $category->cat_name . '</span>'; |
39 | } |
40 | } |
41 | ?> |
42 |
43 | <!-- Insert data:Tag schema --> |
44 | <?php if( has_tag() ) { ?> |
45 | <span itemprop="keywords"><?php the_tags('', ','); ?></span> |
46 | <?php } ?> |
47 |
48 | <!-- Insert data:Content schema --> |
49 | <?php if( !is_singular() ): ?> |
50 | <div itemprop="description"><?php the_excerpt(); ?></div> |
51 | <?php else: ?> |
52 | <div itemprop="articleBody"><?php the_content(); ?></div> |
53 | <?php endif; ?> |
54 |
55 | </article> |
56 |
57 | </div> |
You might notice in previous copied code. i included a style=’display:none’ in class=’post-schema’. This is to prevent the data been showed in your site.
4. Adding created schema.php into post_loop()
Open any file with post_loop (index.php, home.php, archive.php or single.php) and add this code1 | <?php get_template_part('schema'); ?> |
1 | <?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?> |
2 | <!-- your own existed loop code --> |
3 | <!-- add this below --> |
4 | <?php get_template_part('schema'); ?> |
5 | <?php endwhile; else: ?> <?php endif; ?> |
5. Retest with Google Snippet Tools
Finally Clear your cache and retest your website with Structured Data Testing Tool. You should be able to see the schema markup properly generated and structured.Credit/Source: http://www.dezzain.com/wordpress-tutorials/adding-schema-markup-to-wordpress-theme-for-better-seo/
Tuesday, July 28, 2015
WordPress Optimization: Ultimate list of SQL Queries for database cleanup
For those who don’t know yet, SQL queries have to be executed within the MySQL command line interpreter or a web interface such as the popular PhpMyAdmin. Since we’re going to work on WordPress, you should note that the SQL Executionner plugin provides an easy-to-use interface that allows you to run SQL queries directly on your WordPress blog dashboard.
Although all the queries from this article have been tested, don’t forget that you shouldn’t test any of those on a production blog. Also, make sure that you always have a working database backup.
Delete Duplicate Posts
1
2
3
4
5
6
7
8
9
| DELETE bad_rows.*from wp_posts as bad_rowsinner join ( select post_title, MIN(id) as min_idfrom wp_postsgroup by post_titlehaving count(*) > 1) as good_rows on good_rows.post_title = bad_rows.post_titleand good_rows.min_id <> bad_rows.id; |
Clean WP-Options Table
1
2
3
4
| DELETE FROM `wp_options` WHERE `option_name` LIKE "_transient_timeout_rss%";DELETE FROM `wp_options` WHERE `option_name` LIKE "_transient_rss_%"; DELETE FROM `wp_options` WHERE `option_name` LIKE "_transient_timeout_feed_%";DELETE FROM `wp_options` WHERE `option_name` LIKE "_transient_feed_%"; |
Clean Comments Meta Table
1
| DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments); |
Remove Unused Tags
1
2
| DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy); |
Delete All Posts which are not in “Published” stsus
1
| DELETE FROM `wp_posts` WHERE `post_status` NOT LIKE 'publish'; |
Manually change your password
It may sound like the thing that only happens to others but forgetting a password can happen to any of us. In case you lost your blog admin password, the only solution is to create a new one directly in your MySQL database.The following query will do it. Notice that we use the MD5() MySQL function to turn our password into an MD5 hash.
1
| UPDATE 'wp_users' SET 'user_pass' = MD5('PASSWORD') WHERE 'user_login' ='admin' LIMIT 1; |
Transfer posts from one user to another
Most WordPress newcomers tend to use the good old “admin” account instead of creating an account with their real name. If you made that mistake and created another account later, you can easily transfer your old “admin” posts to your new account with the SQL query below.You’ll need the user id of both your old and new accounts.
1
| UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID; |
Delete post revisions and meta associated to those revisions
Post revisions are very useful, especially in the case of a multi author blog. However, the problem of post revisions is definitely the number of database records it creates. For exemple, if your blog has 100 posts, which has 10 revisions each, you’ll end up with 1000 records in the wp_posts tables, while only 100 of them are necessary.Executing this query will delete all post revisions as well as all meta info (custom fields, etc) associated to it. The whole process will result in a consequent gain of database space.
1
| DELETE a,b,c FROM wp_posts a WHERE a.post_type = 'revision' LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id); |
Batch delete spam comments
Imagine that you’re coming back from holidays, where you haven’t had any access to the Internet. If you haven’t installed Akismet and depending on your blog popularity, you may end up with 1000, 2000 or even 10,000 comments to moderate.You can spend a whole day to moderate the lot, or you can use this life-saving query to delete all unapproved comments. And for your next holidays, don’t forget to install Akismet!
1
| DELETE from wp_comments WHERE comment_approved = '0'; |
Find unused tags
Tags are recorded on the wp_terms table. If for some reason a tag has been created but is not used anymore, it stays in the table. This query will let you know which tags are on the wp_terms table without being used anywhere on your blog. You can delete those safely.
1
| SELECT * From wp_terms wt INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0; |
Find and replace data
This tip isn’t specific to WordPress and is a must know for anyone who’s working with MySQL databases. The MySQL function replace() lets you specify a field name, a string to find, and a replacement string. Once the query is executed, all occurrences of the string to replace will be replaced by the replacement string.In case of a WordPress blog, this can be useful to batch replace a typo (For example people who repeatedly call the software WordPress…) or an email address.
1
| UPDATE table_name SET field_name = replace( field_name, 'string_to_find', 'string_to_replace' ) ; |
Get a list of your commentators emails
Have you ever received unsolicited emails from blogs you previously commented? I’m sure you did, just like me. The fact is that getting a list of emails from your commentators is extremely easy using the following query. TheDISTINCT parameter will make sure that we’ll only get each email once, even if the user commented more than once.Please note that this is only a proof of concept: Don’t send your users unwanted emails.
1
| SELECT DISTINCT comment_author_email FROM wp_comments; |
Disable all your plugins at once
When things go wrong, especially on a production site, you have to be quick. Considering the fact that plugins are often the source of problems, disabling all your plugins in a second can prevent lots of problems.Just run the following query:
1
| UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins'; |
Delete all tags
In WordPress, tags are recorded in the wp_terms tables, along with categories and taxonomies. If you wish to remove all tags, you can’t simply empty or delete the wp_terms as you’ll destroy categories at the same time!If you want to get rid of your tags, run this query. It will remove all tags and relationships between tags and posts, while leaving categories and taxonomies intact.
1
2
3
4
5
6
7
8
9
| DELETE a,b,cFROM database.prefix_terms AS a LEFT JOIN database.prefix_term_taxonomy AS c ON a.term_id = c.term_id LEFT JOIN database.prefix_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_idWHERE ( c.taxonomy = 'post_tag' AND c.count = 0 ); |
List unused post meta
Post meta is created by plugins and custom fields. They are extremely useful, but they can quickly make your database grow in size. The following query will show you all the records in the postmeta table that doesn’t have corresponding records in the post table.
1
| SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL; |
Disable comments on older posts
Everyone who has been in blogging for more than one year will know: Even after some months, your old posts still receive interest from the public and lots of comments, mostly because they are indexed by search engines. This is a good thing of course, but the problem is for people like me who own technical blogs and have to answer lots of questions related to their old (and sometimes obsolete) posts.The solution to this problem is to automatically close comments on posts which are too old. This SQL query will close comments on all posts published before January 1, 2009.
1
| UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2009-01-01' AND post_status = 'publish'; |
Replace commentator url
Previously in this article, I talked about the very useful replace() MySQL function. Here is a good example of how useful it is : Let’s say you previously own a site and used its url in your comments to generate backlinks to this site.If you sell the site, you can easily replace the old url by your new site url. Simply run this query and you’ll be done!
1
| UPDATE wp_comments SET comment_author_url = REPLACE( comment_author_url, 'http://oldurl.com', 'http://newurl.com' ); |
Replace commentator email adress
Another good example of the replace() function. This query will replace the email adress provided in the comments field, by a new one.
1
2
3
| UPDATE wp_comments SET comment_author_email = REPLACE( comment_author_email, 'old-email@address.com<script cf-hash="f9e31" type="text/javascript">/* <![CDATA[ */!function(){try{var t="currentScript"in document?document.currentScript:function(){for(var t=document.getElementsByTagName("script"),e=t.length;e--;)if(t[e].getAttribute("cf-hash"))return t[e]}();if(t&&t.previousSibling){var e,r,n,i,c=t.previousSibling,a=c.getAttribute("data-cfemail");if(a){for(e="",r=parseInt(a.substr(0,2),16),n=2;a.length-n;n+=2)i=parseInt(a.substr(n,2),16)^r,e+=String.fromCharCode(i);e=document.createTextNode(e),c.parentNode.replaceChild(e,c)}}}catch(u){}}();/* ]]> */</script>', 'new-email@address.com<script cf-hash="f9e31" type="text/javascript">/* <![CDATA[ */!function(){try{var t="currentScript"in document?document.currentScript:function(){for(var t=document.getElementsByTagName("script"),e=t.length;e--;)if(t[e].getAttribute("cf-hash"))return t[e]}();if(t&&t.previousSibling){var e,r,n,i,c=t.previousSibling,a=c.getAttribute("data-cfemail");if(a){for(e="",r=parseInt(a.substr(0,2),16),n=2;a.length-n;n+=2)i=parseInt(a.substr(n,2),16)^r,e+=String.fromCharCode(i);e=document.createTextNode(e),c.parentNode.replaceChild(e,c)}}}catch(u){}}();/* ]]> */</script>' ); |
Delete all comments with a specific url
Lately, I’ve noticied that some clever spammers left some quite relevant comments, but with a link pointing to a viagra site. Unfortunely, when I noticied it the commentator already left lots of comments. The following query will delete all comments with a specific url. The “%” signs means that any url containing the string within the % signs will be deleted.
1
| DELETE from wp_comments WHERE comment_author_url LIKE "%wpbeginner%" ; |
Tuesday, July 14, 2015
Membuat text area di dalam postingan blog
Membuat text area di dalam postingan blog.
Text area adalah tempat untuk kita menuliskan teks, HTML/Javascript , Link dan lain lain . Berikut caranya :
1.Login Blogger
2.Ke Posting
3.Di bawah judul terlihat tulisan Edit HTML klik tulisan tersebut
4.Copy kan kode berikut ini:
KET : Ganti tulisan yang berwarna merah dengan tulisan anda , yang berwarna biru dengan ukuran yang anda inginkan dan yang berwarna hijau dengan posisi yang anda inginkan.
Membuat text area
Text area adalah tempat untuk kita menuliskan teks, HTML/Javascript , Link dan lain lain . Berikut caranya :
1.Login Blogger
2.Ke Posting
3.Di bawah judul terlihat tulisan Edit HTML klik tulisan tersebut
4.Copy kan kode berikut ini:
<p align="left"><textarea name="code" rows="6" cols="20"> Tulisan anda </textarea></p>
KET : Ganti tulisan yang berwarna merah dengan tulisan anda , yang berwarna biru dengan ukuran yang anda inginkan dan yang berwarna hijau dengan posisi yang anda inginkan.
Membuat text area
Subscribe to:
Posts (Atom)