SEO Test

Today I signed up for two pharmacy affiliate programs: Rx Partners and Stimul Cash (former known as Stimul Media). As you know, signing up for these two is quite hard these days and you are required to have invitation code plus webmaster approval to start making money with them. Here is a conversation with the approval guy (Mark from Rx-Partners):
Coversation log with Rx-Partners support that shows the affiliate program

You want to rename your Drupal tables by adding a prefix to them? There are about 57 tables in my MySQL database . Here’s the SQL code that will save you a couple of minutes. To add your own prefix just open up a text editor and use Find and Replace from drupal_ to your_prefix_. Because of additional modules, more tables may exist in your drupal database, just add those manually.
View the SQL code for bulk renaming with prefix

After the mirroring process is finished, I strongly advise you to download Ubuntu 7.10 from the mirrors close to your location, because the ubuntu.com servers will be under heavy stress today. But right now you can download Ubuntu 7.10 CD and Ubuntu 7.10 DVD from the main Ubuntu server. Find out how to Download Ubuntu 7.10 Gusty Gibbon torrent in your browser

Installation

Because I didn’t have any blank media to write on, I chose to install OpenSUSE from the ISO image stored on my laptop’s harddisk. To install OpenSUSE from the harddisk I first had to copy linux and initrd from the 10.3 repository to the /boot folder, and then point to them with GRUB by appending the following lines to /boot/grub/menu.lst:

title Install OpenSUSE 10.3 from the local HDD
root (hd0,2)
kernel /boot/linux
initrd /boot/initrd

Read the OpenSUSE 10.3 Review

Today I decided to overclock my ATI Radeon x300 in order to see the performance gain in benchmarks.

My computer is a FUJITSU SIEMENS - AMILO Pro V2045 laptop (notebook) with the following specifications:

• CPU Intel Pentium M 1729 MHz (Centrino 740)
• FSB 533 MHz
• Memory 510 MB
• Graphics Chipset ATI MOBILITY RADEON X300
  • Video Memory 64 MB
  • Core Clock 297 MHz
  • Memory Clock 230 MHz
• On AC power
• The rest is not relevant in the tests.

I used
3DMark03 Revision 6 Build 0.
Read the whole laptop overclocking article

I’ve been a Linux admirer for quite some time now and flirted with many distros in my life. But I never completely switched to Linux as my main Operating System. Why?
Right now all your base are belong to Windows XP:

• Opera passwords/mail/bookmarks/cookies
• Perfect ACPI compatibility with my Laptop
• Yahoo Instant Messaging file transfer (all your messages are belong to Yahoo Messenger too )
• Direct Connect P2P file sharing with StrongDC++ (and many many other good DC clients)
• Small, pretty, out of the box fonts and comfortable interface
• Game compatibility

Anyway, tomorrow OpenSuSE 10.3 comes out and I was thinking this makes a great time to change. We’ll see…

Last night I was so pissed off I wanted to throw the laptop out the window and see if the apache feathers can make it fly.

Simultaneous MySQL server connections in WordPress don’t seem to work. The autolink plugin hooks to the core functions, opens the external link database with $open_link_db = mysql_connect(), performs table operations and then closes the connection with mysql_close($open_link_db);. Everything is fine until some (maybe not all) other functions need access to the wordpress database again. Like the sidebar for example:
Warning: mysql_error(): 6 is not a valid MySQL-Link resource in /home/wordpress/public_html/autolink/blog/wp-includes/wp-db.php on line 189
Theoretically this is unacceptable, but in practice the sidebar can be disabled and you get error-free output. I’ll get back to finish this plugin after I receive response from the WordPress support forum. I tell you, the automatic interlinking plugin is MONEY.

Google Gadgets attract quite a lot of traffic, and developers all around the globe rush to get their hands on valuable niche realestate. Browsing trough the gadget directory, I saw many useless ”quote of the day” widgets that are simple to write and generate revenue from ads contained within. Great, so I chose my niche: quote gadgets. Wow, wait a minute! There are 1 - 24 of 200 results for quote. Fuck me! I’m not going to invest my time into writing complex gadgets, at least not right now, so I have to stick to the quotes niche. Maybe the quote topic I’m going to be in is not that crowded: Family Guy Quotes Gadget. Whell shit, 6 results 3 of wich are exacly my topic.
Read Full Entry

Today I have been working on the distant interlinking plugin for wordpress. Decided to call it AutoLink. Though it works, it’s just a sketch right now. The following functions have been implemented:

• On the fly generation of links from words
• Condition so that links are used only once in posts.
• Usage of remote database
• Condition that the matching keywords are not already linking ( <a href="">keyword</a> )

Excerpt from the automatic inter linking plugin header:

Read Full Entry

I found this e-mail today from a guy who disaprooves with my seo research results:
Note: Some information has been modified to protect the anonymity of this person. I haven’t notified him yet that I’m going to publicize this conversation.

Hi X,

I got your email from the WHOIS record of the domain bubub.org ( http://whois.domaintools.com/bubub.org ).
I hope this email address works - Note to self: Set domain privacy protection. 

I have a comment regarding your REL=NOFOLLOW test at http://www.bubub.org/rel_nofollow_test.html
Read Full Entry