Seduce YourSelf

本博客含有成人内容!Here Is adult Sections

2009年1月28日 星期三

Do you use the blogger New feature: Scheduled Posts

We’ve often heard that sometimes you’d like to write a post now and have it automatically published at some time in the future. We listened, and are pleased to say that this feature is ready for you to try out on Blogger in draft.

Publishing a post in the future is pretty simple: in the post editor, reveal the Date and Time fields using the “Post Options” toggle and enter a post date and time that is in the future. When you then click the “Publish” button, your post will become “scheduled.” When the date and time of the post arrive, your post will be automatically published to your blog.

Your scheduled posts appear in your Edit Posts list alongside your drafts and published posts. To un-schedule a post, simply save it as a draft any time before it gets published.

Remember: Like all features described on this blog, Scheduled Posts only work when you’ve logged in to http://draft.blogger.com/.

Leave your feedback in the comments!

Additional Notes:
  • We know that some bloggers currently use future post dates in order to keep one post at the top of their blog for a while. Though we recommend that you use a Text page element for this, you can still get this old behavior with just one additional step. First, publish your post with the current date and time. This will publish it to your blog. Then, once it’s published, edit the post to change the date to the future and publish it again. We don’t re-schedule posts that are already published, so the post will stay on your blog but sort to the very top.
  • As with published posts, the post editor does not autosave scheduled posts if you go back and edit them. You wouldn’t want the post to publish while you’re in the middle of editing it! You can save the scheduled post as a draft to remove the scheduling and this will turn autosave back on.
  • In some testing we’ve found that schedule posting is not working for some FTP blogs. If you run across this, please let us know in the comments so we can try to track it down.

标签:

Scheduled Posts in Blogger

Good news for all users of Blogger. According to the Blogger in Draft blog, Blogger is now testing a cool new feature that will enable you to write scheduled blog posts. With the help of this feature, you can write a blog post now and have it automatically published at some time in the future. Scheduled blog post is one of the important features of the popular WordPress blogging platform. It helps you to maintain the regular update of your blog by managing your time.
Scheduled Posts in Blogger
Writing scheduled posts is very simple. Just follow these simple steps:
  • Write your blog post in the post editor.
  • Click the “Post Options” button below the post editor. It will reveal the Date and Time fields.
  • Enter a post date and time that is in the future.
  • Then click the “Publish” button. Now your post will become “scheduled.”
  • When the date and time of the post arrive, your post will be automatically published to your blog.
All your scheduled posts will appear in your Edit Posts list, alongside your drafts and published posts. To un-schedule a post, simply save it as a draft any time before it gets published.
What scheduled posts can do for you? Imagine you are going to a remote area for a long vacation. How you are going to continue posting to your blog? Simply write some scheduled posts before you start your journey and gift your readers regular blog updates!
Right now, this scheduled posts feature is not available in the common Blogger platform. You can use it when you are logged in to Blogger in Draft.

标签:

AdSense for Search and Custom Search

AdSense for search is now powered by Custom Search. The Custom Search offers some advanced customization options to improve the accuracy of search results. This means that from now on AdSense publishers will be able to customize and take advantage of the popular features of Custom Search Engines. That’s too, without leaving the AdSense account.

Creative Commons License photo credit: _Circa_
By using some new features of Custom Search Engine, you will be able to provide more relevant search results to your visitors. You can choose to provide just site search and host the search results on your own pages. It will ensure that your visitors will find all the information they’re looking for without leaving your site. Even you can allow your users to search across multiple sites that you own or that are related to your sites.
To provide the best search results, Google has improved their crawl and indexing technology. From now on, AdSense for Search will index more pages of your site. More indexing means more search results from your site. And if you want to increase your earnings, you can go for tuning of your search results and ads with important keywords.
What’s more? Now, it allows you to choose the location of ads on the search result pages. Choose your favorite location and start showing custom search results. You can easily modify and save your settings at any time, right from your AdSense account. So, you won’t need to generate new AdSense for Search code for each change.
How to use the power of Custom Search? If you have migrated your AdSense account to Google, you will be able to use these advanced features. Open the AdSense Setup tab on your AdSense account and select ‘AdSense for Search’ as your product. Set up your search box and add more advanced features such as site exclusion, labels, and collaboration. Add the code to your site and start showing exciting search results to your visitors. I am sure that it will help you in improving your earnings.

标签:

Finding a Freelance Writer to Make Money Online

If you want to make money online with your blog or website, then you must produce some quality contents, that really sales and feeds the knowledge hungry traffic. Where a good article can give you tons of targeted visitors and good search engine ranking, a poor article hardly adds value to your site, besides adding a number to your totals pages. If you are not receiving good traffic and good search engine rankings, already you are loosing the battle! So, it is very important to write quality, informative and useful articles.
Find the Right Freelance Writer
Find the Right Freelance Writer
But due to various reason you may be unable to produce quality contents. In that case, what you are going do? In my view, the best decision in that situation will be hiring someone to write on behalf of you. And here comes the freelancers into the scene.
Finding quality freelance writers may take a bit of time. But, you must not forget that if you find one that can write revenue generating unique articles and that easily converts a regular visitor into a client, then that one difficult search will turn into a profitable investment of time.
So, let’s start searching for a good freelance writer. For this, you can look at various freelancing websites or services such that will allow you to post ads the specification of your project and your budget. Popular services are always good to start, but never underestimate the less popular services. Spend some time and try hard to find the best.
When you start your search, it is important to keep in mind that there are different types of writing such as news writing, medical writing, copy writing, technical writing, creative writing or general writing. One writer might be highly skilled in one area, yet may lack in another. And in order to earn some more money, many freelance writers spread themselves out into others areas where they don’t have good skills. So, it is very critical that the writer you choose can produce the type of content that you need.
Let’s go back to your ads on freelancing websites. Once your ad is up, writers will make bids on your project along with their writing samples. The more you are willing to pay per article, the more bids you will get from writers. But, mind it, all of those bidders are not excellent writers and there may be some scrappers also! Properly go through the articles submitted by the bidders. Use the private message service provided by freelancing websites and whenever possible want some more sample of their previous works. Also don’t ignore the ratings and feedback provided by previous buyers.
Make Money Online
Make Money Online with Articles
After reading all those articles and considering previous works and feedback, choose a suitable freelancer for your project. Some freelancers may ask very high amount per article. If your budget permits, try to avoid the money factor till end. Because, over time you will be amazed to see how much you will eventually earn from your killer articles. Just for your own benefit, check the probable options twice and make sure that you choose a writer who can write the type of articles that you are looking for to make money online.
So, in this way after spending a good amount of time in searching, you can easily find a suitable freelance writer to produce content on behalf of you. You just need some patience and some money to spend. After the articles are ready, use them as per your own technique to make money online. Soon you will see the results and you will eventually make a ton of money off of each article. The time you spent for searching a freelancer may also help in your future projects. As, you may already have some direct contacts who can write articles that really sales!

标签:

2009年1月21日 星期三

Icon : Vista Icon pack

Vista Icon pack

标签:

2009年1月19日 星期一

Fate Back:60MB/Free Unlimited Bandwidth

FREE WEB HOSTING
FateBack Free Web Hosting Service

60 MB Free Web Hosting 60 MB Free Hosting
Free Domain Name Hosting Free Domain Name Hosting
Free Sub-Domain Hosting Free Sub-Domain Hosting
Free FTP Hosting/Account Free FTP Hosting/Account
Free Unlimited Bandwidth Free Unlimited Bandwidth
Free POP3 Email Account Free POP3 Email Account
Free Account Set up Free Account Set up
Free Host of Your Pictures Free Host of Your Pictures
Free Host of Your WebSite Free Host of Your WebSite
Free Host of Your Files Free Host of Your Files
Free Web Page Hosting Free Web Page Hosting
Free Domain Name Server Free Domain Name Server
Host Unlimited Web Sites Host Unlimited Web Sites
Web Based File Manager Web Based File Manager
Advanced Control Panel Advanced Control Panel
Fast Linux Servers Fast Linux Servers
24/7 Network Monitoring 24/7 Network Monitoring
Reliable Data Center Reliable Data Center
Ultra Fast Network Ultra Fast Network
Small Banners - 20 Pixels Small Banners - 20 Pixels
Stable Hosting Software Stable Hosting Software
99.5% Uptime Guarantee 99.5% Uptime Guarantee
Service Online Since 2001 Service Online Since 2001
Totaly Free Web Hosting Totaly Free Web Hosting
Direct OC12 Connection Currently hosted sites:
186553
click here to open your
free web hosting account

标签:

2009年1月16日 星期五

Using fonts as graphic elements

For Photoshop users, they have plenty of brushes that can be used in their design. Some brushes are just plain image/drawing/illustration - so they can use it without having to draw them separately. But for those who are not using Photoshop - like myself, a Fireworks user - we don’t have much options, except for vectors or by creating it ourselves.
Another alternative is to use fonts. Yes, font. Fonts are not just for text anymore since there are a lot of fonts consist of graphic illustrations or drawing or even scanned pictures. Fonts can be resized to be very huge or small - so it works much like vectors. Here are some useful and nice fonts that you can use as your graphic elements:
culinary-art

flames
geobat
trucks for judy
flower ornaments
in my garden
wmtrees1
butterflies
fishing
split splat splodge
cafeina dig
skull
ckas
dead letter office
soundfx
azudings
marioluigi
ihminen
raise your flag
illustrate it
symbolix
There are a lot more out there. Why don’t you share any of your favourite with the rest of the readers? Have fun!

标签:

Make Your Cash Stack | Money Making System

This is The Top Selling "Work At Home" Product in 2008! - Full Unlimited V.I.P Access to "Make Your Cash Stack" Money Making System by The Rich Boy
I don't care if you make $10/hour or $50/hour...
It's all CHUMP CHANGE compared to what I make...
And I don't even have a job!
It doesn't matter if you barely know how to write an email, or if you are a professional business owner... This system is designed
to take all the Guesswork out, and if you can follow
simple "Do this, Do that" instructions...
You can start earning cash VERY QUICKLY.

Buy

标签:

2009年1月14日 星期三

ZangZhiYi with Boyfriend at the sea

ZangZhiYi with Boyfriend at the sea
ZangZhiYi with Boyfriend at the sea | 39MB
90 Pics | 1600x1200 | JPG | Scandal
Hot Scandal Sex at the sea


download link :
Uploading.com_For_USA/EU/RU
Download Now
Megaupload for ALL
Download Now
RapidShare_For_ALL
Download Now
Letitbit
Download now
Plz help me download from Megaupload or Uploading. Thanks.

标签: ,

2009年1月9日 星期五

Free Cpanel Hosting manager


cP Creator is a totally Free script which provides an all in one management system for the budgeting free, paid host. It’s a totally robust script which has been developed from the ground up to provide hosts an all in one system without monthly price tag dragged along. cP Creator is an system with packs some groundbreaking features into one free box. Some of these include:
Post 2 Host signup, monthly checking. Supports all leading BB boards (phpBB, myBB, SMF, vB, IPB)
Flexible package options. Custom descriptions, multi server choice, hidden.
Monthly/Annual billing options via paypal. Invoice or subscriptions. Users choice.
Fully featured client area with features like upgrade/downgrade, delete account.
Complete support system which includes tickets, knowledge base.
Fully customisable module system. Create your own custom modules, determine how cP Creator works.
Complete Feature List
Order Form
The order form is a 4 page system which contains the package select and 3 steps. These steps are on a each page and are clearly instructed and easy to follow. The steps consist of:
Subdomain/Domain choice. TOS Agree.
User details form. Fully AJAX and helps the user with format and checks if exists. Package change also featured.
3rd Additional step. Checkout (if Paid) validate (if Post 2 Host).
Depending on how the package is set up, the user will have to validate and then either wait for admin validation or sent to payment etc. Security is a big priority in running a host, the order form is totally secured and SQL Injection prevented. If javascript checks fail, there is still hardcoded PHP checks for email validatility and repeated details.
Admin Control Panel
The admin control panel is the main hub for the webmaster to configure cP Creator into how he likes it to work. cP Creator has total flexibility in what you tell it to can and can’t do. Here’s the overall feature list in the ACP:
Home - Check up on the latest cP Creator News
Servers - Create your servers. Used for hosting accounts.
Main Settings - Configure cP Creator. Includes variables like sitename, theme etc.
Packages - Create and define your packages. Re-order them on the order form. Choose the module, server and enter descriptions.
Subdomains - Add subdomains which can be shown on the order form.
Manage Users - Manage the users. Terminate, suspend, upgrade, check invoices.
Import WHM Accounts - Import accounts from WHM into cP Creator
Templates - All the emails are located in here. Edit them to the hosts needs.
TOS Edit - Edit the TOS which is shown and agreed to on the order form.
Staff Accounts - Create custom staff accounts. Define they’re privlegas.
Modules - Install and delete custom modules.
Details Filter - Ban certain words from being used as usernames etc.
Tools - Variety set of tools used to perform certain tasks.
Style Edit - Edit the TPL files and CSS in the theme your in.
Change Password - Change your staff account password.
Server Status Config - Edit what is and what isnt shown on the server status page.
Tickets - Check up on tickets and reply/close/hold them accordingly.
Knowledge Base - Create articles and categories in the knowledgebase.
Mass Email - Mass email every user on the cP Creator DB.
IP Bans - Ban IP’s from signup.
Module Sidemenu
Validate Users - Validate users which await admin validation.
P2H Forums - Create and edit your Post 2 Host forums.
Paid Invoices/Settings - Edit settings like paypal email, suspension days. In addition, pay invoices, create invoices, delete.
As you can see from the list above there is a huge mammoth of features included in the box in cP Creator. There is even more features located on subpages of those pages.
Client Control Panel
The client control panel in cP Creator is the main hub where the client can check on their package; update invoices if they’re paying; check up on their post 2 host requirements. The client can even upgrade/downgrade their account or delete it via client cp. When I was developing this, one of the key features which came to mind was simplicity and ease. A client doesn’t want to spend time in an ultra complicated panel which gets nothing done. The client needs to select and click. That’s it. You can see this when inside the client cp. Some of the key features are:
View Package - Check up on the package name/description. Post 2 Host users can also check up on post requirements.
Upgrade/Downgrade Account - This is where a client can change the package they’re on. Requires to be on the same module.
Login to cPanel - This is where a user can login into their cPanel.
Delete Account - A client can delete their account from here. This will also send email confirmation to admin and the client.
Support Area - A user can create tickets and check on knowledge base articles in here.
Invoices - If a user is on a paid package, they can check up and pay invoices in here.
As you can see from the list of features there’s some great features you’re provided straight out the box for free.
Lots of Free Skins / Templates also !!!
Try it out for yourself!
Demo here
Download Here

标签: ,

Top_10_Beautifull_Windows_Vista_Themes.rar (49.1 MB) Download

Image
It includes the best Windows Vista themes out there, such as M11, Vista Elegance, Vista Ultimate 2nd generation,
Aero Dynamic, etc.
Image
This pack has the following visual styles included:
Aero Dynamic v3
Chocolate Vista
Clear Vista
LongVista
M11 Final V1
NV2 Final Theme
Ultimate Dark
Vista Elegance
Vista Summer
Vista Ultimate 2nd Generation
Unpack rar file then copy both parts inside the folder to
CWindowsResourcesthemes
Then right click on desktop then goto personalizetheme then select from there.
Download top10 vista themes here

Top_10_Beautifull_Windows_Vista_Themes.rar (49.1 MB) Download

标签: , ,

ComiCraft Fonts


230 Fonts | TTF | 8 MB


Download:
 
comcft_dl4all.com.rar (7.7 MB) Download

标签:

Playboy 01 2009

Playboy 01 2009
11:14


                    Playboy_01_2009_HQ.pdf (93.3 MB) Download

标签:

2009年1月8日 星期四

DDL-Music.org Script

DDL-Music.org Script

DDL-Music.org Script

Demo: http://ddl-music.org/



Download


http://www.megaupload.com/?d=K7O1UNBC
http://rapidshare.com/files/165525730/DDL-Music_-_allnull.net.rar.html
http://www.zshare.net/download/5157384938419a40/
http://www.badongo.com/file/12161115

标签: , , ,

Mihalism Multi Host 4.0.2

Mihalism Multi Host 4.0.2

Mihalism Multi Host 4.0.2


Demo: http://image.stcgroup.org/


Download

标签: ,

MP3Street Music Sharing Community Script

MP3Street Music Sharing Community Script

MP3Street Music Sharing Community Script

Demo: http://mp3street.fitce.hu


Download


http://www.zshare.net/download/199079282f03d1cc/
http://rapidshare.com/files/150708353/mp3street_-_vhxm.net.rar.html
http://www.badongo.com/file/11599311
http://www.megaupload.com/?d=J0G47YPB

标签: ,

PlusPHP.Advanced.Short.URL.[x-MoBiLe].Nulled

PlusPHP.Advanced.Short.URL.[x-MoBiLe].Nulled

PlusPHP.Advanced.Short.URL.[x-MoBiLe].Nulled



Download


http://www.badongo.com/file/12340651
http://www.megaupload.com/?d=KPS81VL3
http://rapidshare.com/files/170041063/PlusPHP_-_allnull.net.rar.html

标签: ,

PlusPHP.Image.Host.REPACK.[x-MoBiLe].Nulled

PlusPHP.Image.Host.REPACK.[x-MoBiLe].Nulled

PlusPHP.Image.Host.REPACK.[x-MoBiLe].Nulled


Download


http://www.zshare.net/download/52052393f6985cfb/
http://www.megaupload.com/?d=NGIHLMUL
http://rapidshare.com/files/168778553/PlusPHP.Image.Host_-_allnull.net.rar.html
http://www.badongo.com/file/12294788

标签: ,

PlusPHP.File.Host.[x-MoBiLe].Nulled

PlusPHP.File.Host.[x-MoBiLe].Nulled


Download


http://rapidshare.com/files/168778121/PlusPHP.File.Host_-_allnull.net.rar.html
http://www.badongo.com/file/12294768
http://www.zshare.net/download/5205234712fc71ab/

标签: ,

Image Host Community - GejoSoft

Demo: http://www.gejosoft.com/demo.php

GejoSoft Benefits

Here's what GejoSoft image hosting community software has to offer:



Run your photo sharing social network like Flickr

100% PHP source codes

Software Rebranding Included

Professional Installation

Customization Service

Instant Download

Hosting Discounts

Includes Support and Software updates

 more:http://www.gejosoft.com/features.php
Download


http://www.megaupload.com/?d=07TFUA4R
http://www.badongo.com/file/12204525
http://www.zshare.net/download/51728906b2c85015/
http://rapidshare.com/files/166483063/GejoSoft_1.01_-_allnull.net.rar.html

标签: , ,

Brown Magazine - Wordpress theme

Brown Magazine - Wordpress

Brown Magazine - Wordpress


Download


http://depositfiles.com/files/f5frz5b37
http://rapidshare.com/files/180242234/brownmagazine_-_allnull.net.rar.html
http://www.badongo.com/file/12773922
http://www.zshare.net/download/537468303406d93b/
http://www.megaupload.com/?d=PUEAIA70

标签: , , ,

food363 - wordpress themes

food363 - wp



Download


http://rapidshare.com/files/178887046/food363_-_allnull.net.rar.html
http://www.megaupload.com/?d=VAZ1EDYY
http://www.zshare.net/download/5357669212d85496/
http://www.badongo.com/file/12722297

标签: , ,

2009年1月7日 星期三

8 Useful WordPress SQL Hacks

Over the past 10 years, the MySQL database has become incredibly popular on the Web. Every WordPress blog is driven by a MySQL database, which contains the blog’s posts, settings, comments and much more.
While plug-ins and even coding hacks can solve some problems and achieve some tasks, sometimes you don’t have any other choice than to execute SQL commands in phpMyAdmin or directly to the database via SSH. Let’s take a look at 8 useful SQL hacks for WordPress. Each section of this post presents a problem, suggests a solution and provides an explanation to help you understand the solution.

1. Creating a Backup of Your Database

8 Useful Wordpress SQL Hacks
The problem. While the tips in the rest of this post have been tested, you should definitely not try any of them without first having a proper backup of your MySQL database.
The solution. To create a manual backup of your WordPress database, follow these simple steps:
  1. Log in to phpMyAdmin and select your WordPress database.
  2. Once done, click the “Export” button located in the horizontal menu.
  3. Choose a compression method (personally, I use gzip), and click the “Execute” button.
  4. Your browser will ask you if you want to download the backup. Of course, select “Yes,” and then store it on your hard drive.
Explanation. Note that creating a backup of your WordPress database can be more easily executed with the WP-DB-Backup plug-in. WordPress users should install this plug-in if they have not yet done so and create regular backups of their data.

2. Batch Delete Post Revisions

8 Useful Wordpress SQL Hacks
The problem. Post revisions, a new WordPress 2.6 feature, can be very useful, but they also increase the size of your MySQL database. Sure, you can manually delete posts revisions, but that’s very long and boring work.
The solution. The solution to this problem is simple: we batch delete post revisions by using a simple SQL query. The result can be almost unbelievable if you have a lot of posts: Your database size will be reduced by half!
  1. Log in to phpMyAdmin and select your WordPress database.
  2. Click the “SQL” button. Paste the following code in the SQL command window:
    1. DELETE FROM wp_posts WHERE post_type = "revision";  
  3. You’re done. Depending on how many posts you had in your WordPress database, you may have saved lots of precious space!
Code explanation. The wp_posts table has a field named post_type. This field can have one of many values, such as “post,” “page” or “revision.” When we want to get rid of post revisions, we simply run a command to delete any entry in the wp_posts table in which the post_type field is equal to “revision.”
Source:

3. Erase 5000 Spam Comments in a Second

8 Useful Wordpress SQL Hacks
The problem. True story: a friend of mine recently created his own blog and started to promote it everywhere on the Internet. After some weeks of intensive work, he spent some days on vacation without Internet access.
When he came back home, he looked at his blog and saw… 5000+ comments awaiting moderation! Of course, most of them were spam, but he was actually about to check them all to make sure he did not delete a valid comment made by one of his regular readers.
The solution. Happily, my friend told me about his spam problem. He had already spent 45 minute manually deleting spam when I showed him this useful SQL tip.
  1. Log in to phpMyAdmin and select your WordPress database.
  2. Click the “SQL” button. Paste the following code in the SQL command window:
    1. DELETE from wp_comments WHERE comment_approved = '0';  
  3. Goodbye bad comments! Enjoy your spam-free database!
Explanation. The wp_comments table contains a field named comment_approved, which is a boolean value (1 or 0). Approved comments have a value of 1, and comments awaiting moderation have a value of 0. By running the above command, we simply delete any comments that haven’t been approved yet.
Be careful. While this solution can be pretty useful if you have millions of spam comments to delete, it will also erase valid unapproved comments. If you don’t already use Akismet, install it now to prevent spamming.
Source:

4. Change the Post Attribution

8 Useful Wordpress SQL Hacks
The problem. When you installed WordPress, an “admin” account was created. Some bloggers make the mistake of using that account to write their posts, until they realize that it’s not personal at all.
The solution. Modifying author attribution on each post takes a lot of time. Happily, SQL can help you get things done:
  1. Log in to your phpMyAdmin and select your WordPress database.
  2. First, we have to get the right user IDs. To do so, open the SQL command window and execute the following command:
    1. SELECT ID, display_name FROM wp_users;  
  3. phpMyAdmin will display a list of user IDs associated with WordPress users. Let’s say that NEW_AUTHOR_ID is the ID of the more recently created author, and OLD_AUTHOR_ID is the original admin account ID.
  4. After you swap the NEW_AUTHOR_ID and OLD_AUTHOR_ID IDs, run the following command:
    1. UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;  
  5. That’s all. All posts previously attributed to admin are now attributed to whichever valid user you have selected.
Source:

5. Manually Reset Your Password

8 Useful Wordpress SQL Hacks
The problem. In order to protect their blogs, people often pick strong passwords, such as u7*KoF5i8_. Of course, this is a good thing, but I have heard many stories of forgotten admin passwords.
The solution. When you lose your password, WordPress can email you a link to reset it. But if you don’t have access to the email address recorded in the WordPress database anymore, or if you prefer just running a simple command instead, here is the hack.
  1. Log in to your phpMyAdmin, select your WordPress database and open the SQL window.
  2. Insert the following command (assuming your username is “admin”):
    1. UPDATE `wp_users` SET `user_pass` = MD5('PASSWORD'WHERE `wp_users`.`user_login` =`admin` LIMIT 1;  
  3. You’re done. Your password has been successfully replaced by whatever you inserted in space above marked “PASSWORD.”
Explanation. User passwords are stored in the wp_users table. Of course, an MD5 hash is used to secure the password.
We have to set up an “UPDATE” SQL request and use the built-in MD5() MySQL function to convert our password to MD5 and then update it. The “WHERE” clause ensures that we’re updating only the admin’s password. The same request without the “WHERE” clause would result in all passwords being updated!
Source:

6. Change Your WordPress Domain Name

8 Useful Wordpress SQL Hacks
The problem. Although it is not recommended, you may want at some point to change your domain name while keeping your blog and its data. Because WordPress records your domain name in the database, you have to change the database in order to connect your new domain name to your WordPress blog.
The solution.
  1. You guessed it: the first thing to do is log in to your phpMyAdmin and select your WordPress database.
  2. Click the “SQL” button to open the SQL command window. In order to change your WordPress URL, execute this first command:
    1. UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsite.com''http://www.newsite.com'WHERE option_name = 'home' OR option_name = 'siteurl';  
  3. Then, we have to replace the relative URL (guid) of each post. The following command will do that job:
    1. UPDATE wp_posts SET guid = replace(guid, 'http://www.oldsite.com','http://www.newsite.com');  
  4. We’re almost done. The last thing to do is a search and replace in the wp_posts table to make sure that no absolute URL is still here:
    1. UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldsite.com''http://www.newsite.com');  
  5. You’re done. You should be able to log in to your WordPress dashboard using your new URL.
Explanation. To easily change our WordPress domain name, I took advantage of the super-useful MySQL function “replace,” which allows you to replace one term by another.
Source:

7. Display the Number of SQL Queries on Your blog

8 Useful Wordpress SQL Hacks
The problem. When trying to optimize your blog’s loading time, knowing the number of queries made to the database is important. In order to reduce queries, the first thing to know is how many queries are made on a single page.
The solution.
  1. This time, no need to log in to phpMyAdmin. Simply open the footer.php file in your theme and append the following lines of code:
    1. if (is_user_logged_in()) { ?>  
    2.     echo get_num_queries(); ?> queries in  seconds.  
    3.   
  2. Save the file and visit your blog. In the footer, you’ll see the number of queries made to the WordPress database as well as the time it took to make them.
Explanation. Seems that many WordPress users aren’t aware of this useful function. The get_num_queries() function returns the number of executed queries during a page load.
Note that the above code will only display the number of queries to logged-in users, because regular visitors and search engine bots don’t need to know about it. But, if you’d like to make it public, simply remove the if (is_user_logged_in()) conditional instruction.
Source:

8. Restore Your WordPress Database

8 Useful Wordpress SQL Hacks
The problem. Let’s say, for some reason, such as a hacking or upgrade problem, you have lost your blog data or it has become corrupted. If you have a backup (and I hope you do!) you will have to import it to your WordPress database.
The solution.
  1. Log in to phpMyAdmin and select your WordPress database.
  2. Click the “Import” button in the horizontal menu.
  3. Click the “Browse” button and select the most recent database backup on your hard disk.
  4. Click the “Execute” button. If everything went well, your WordPress database is fully functional again.

标签: