I’m using Wordpress Mu and Drupal in some of my sites.

But when you want to use wordress mu and use drupal as a service for multiple subdomains you need to do some changes on configurations of server. ( In here i must thank to one of my friend )

Here’s how you do it on a plesk powered server :

1. There’s a folder in named conf in the domain you want to configure. The path will be like this : /var/www/vhosts/domain.com/conf. Create a file with a name vhost.conf to there (using pico vhost.conf for ex). Write a line ServerAlias *.domain.com in it. And save it.

2. Open plesk. Go to domain’s DNS settings. Add an A record *.domain.com

After all run this command : /usr/local/psa/admin/sbin/websrvmng -v -a

That’ll help.

Last day i need to extract one of my site’s plesk backup. I tried the “open it with your email client” solution but it can’t help me. (I’m using The Bat! as email client). So i searched and find an effective solution.

There are two same programs to do it. One is ripmime. But in my debian server i’ve mpack tools. So i’ve extract with second way using mpack tools ( Document mirror on focusoncode.com )

It works fine except mySQL unicode problem. I want a world that has no character encoding problems like two or more years ago…

net stop mysql
rar a -ag+YYYYMMDDHHMMSS- -rr -r -k -s -m0
      C:\\BACKUPS\\MYSQL-BACKUP.RAR C:\\MYSQL\\data
net start mysql

Save three lines as something.bat or autoexec.bat and then use it by Cron Jobs. Output file names like this :


20060808120000-MYSQL-BACKUP.RAR
20060808120001-MYSQL-BACKUP.RAR
20060808120002-MYSQL-BACKUP.RAR


( Before this you can update you path configuration. You can add a line at the end of PATH variable like this : C:\Program Files\WinRAR\ etc.)

Mostly Delphi you have always chance to manage your executable. You can re-pack it, crypt it ( you know that we can see most of the strings or code strings in an executable compiled with delphi. Remember DeDe ) or compress the executable.

There’re many programs doing this job. You can look most of them at protools.

I tested most of them for my personal use. At last i choose pelock.

Pelock is a packer, crypter and compressor for your delphi programs. It has very simple and easy to use interface. Additionally you can make demo check by this program.

But not most of these are pelock’s good side. The good with pelock is the producer. If you encounter some problems he always help you on your job. He wants you to send the files, extra libs, etc. Solve the problem and recompile his program and then send it to you. So pelock is my first choice because of the very very nice producer.

While using pelock you always now that the producer is at the other side waiting there to solve the problem related to his software!

If you’ve written an application using Advantage Local Server and want your application to run on another machine you have to distribute some files with your application. These files are Advantage’s API dlls, charset configs, and configuration file.

Lets check which files to be copied :

Read the rest of this entry »

As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

Read the rest of this entry »

If you make a tag system and want to make a tag cloud page which will writes tags in different sizes accoring to use time refer to Tag Cloud document. That’s an easy and practical way for you. (Document Mirror on Focus on Code (186KB))

If you want to learn CSS Positioning or need a manual in your pocket you can refer to Learn CSS Positioning in Ten Steps article. That’s a very good and simple article including most of positioning styles. (Document Mirror on Focus on Code (88KB))

If you want to read and write to TWebBrowser component on Delphi you can refer to How to read and write form elements article. Article contains most wishes while using TWebBrowser. Before using these just insert Microsoft HTML Object Library to your project and add MSHTML_TLB class to your uses block.(Document Mirror on Focus on Code (52KB))

I’ve searched for if there was a good solution for database driven application which uses tags. Finally i found a blog entry discussing tags and database schemas.

In that entry “Toxi Solution” is the best solution. Simply the schema is like this :

I liked this schema and using it for 4 months in my projects. I’m not only using this for tags on my projects that most of table “references” are done like this. This is an old and good system for referencing tables.

For future references you can download a copy from Focus on Code : Tags_ Database schemas.mht (204KB)

If you’re searching for a database solution for your Delphi/Builder applications Advantage Database can be a good option.

I’ve using advantage local server for two years. It’s a very stable local server. It has most of the modern SQL features. It has a good table based encryption. ( With advantage local server you cannot only encrypt the table’s connection, you can encrypt datas that table has. So we can say it’s secure if our application is also secure ). The performance is supreme whether you’re running long, loooong, loooooooooong queries using multiple tables, lots of SQL functions, etc.

And two good points with Advantage. The producer of Advantage, Sybase iAnywhere distributes a program for doing all the of the operations over local tables (creating,manipulating,running queries, etc) with a user friendly gui. Additionally they distribute Delphi/Kylic/Bc++ components for doing all of the operations on tables.

Lets write some advantages of the advantage local server :

Read the rest of this entry »

I searched a lot for a good working ajax upload script with simultaneous progress bar. At last i found one. File Chucker is the best i think.

If you need to save binary files to a mySQL database you must see this article first : Binary Data + MySQL + PHP. Thanks to writer for good article.

You know that Wordpress has a very well menu on blog entry pages. In fact that is not only a menu, that is a couple of blocks than can include lots of menus. The blocks are not static, you can drag and drop them. Don’t worry, the script will remember where you move and drop them! I searched for the script if it’s a lib. And at last i found that this is a script created by Brothercake.com. The name of the script is Docking Boxes. It has a lot of features than we can’t mention in here. ( And of course you can view all of the pages at brothercake. Very very nice site with very nice code! )