Modern file hosting services (eg rapidshare or megaupload) have more than often utilized various methods to secure and promote their services annoying the regular non-premium user with the most prominent method of limiting downloads per user through IP logging, and then waiting for an upsurd amount of time for the next download.

Now, now not all of you have the time to spend in front of a pc monitor, do ya, and NO don’t start suggesting paying for premium services for EVERY file hosting service out there.

Therefore today i will share with you a nifty trick to use with your favourite download manager jDownloader, to renew your IP directly from Cytanet NetRunner service, and get your downloads as fast as possible.

As only a few of you know, the Cytanet NetRunner service leases the IP for 1 week, BUT it is possible to renew the IP by logging-in the NetRunner service, disconnecting and then reconnecting. This will achieve you a brand new, just out of the box IP.

You can streamline the process by using the direct below, replace the red bold username and password references below with your NetRunner Service credentials, and you will instantly acquire a new IP.
https://netrunner.cytanet.com.cy/cgi-bin/netrunnerlogin.cgi?username=username&password=password&action=initial&Login=Login

Now, in order to use this in your favourite download manager or in a script, you will need to procure a small open-source application called cURL that will execute the above URL and achieve the same result without even opening an Internet Browser.

Execute the following command in the command prompt, et viola, a brand new IP coming right up:
curl -k "https://netrunner.cytanet.com.cy/cgi-bin/netrunnerlogin.cgi?username=username&password=password&action=initial&Login=Login"

Then you can have jDownloader execute this batch command every time it requires a new IP to continue downloading.

PS: make sure to get a flavor of cURL supporting HTTPS and SSL in order to be able to process the link.

That’s all folks.

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

SQLite is the most widely deployed SQL database engine in the world. It is used in countless desktop computer applications as well as consumer electronic devices including cellphones, PDAs, and MP3 players. The source code for SQLite is in the public domain.

Please, rest assured that SQLite does indeed have UNICODE (UTF-8, UTF-16) support, but…

If you have searched and resulted in reading this post, then you have probably realized the true facts of life; the limitations of SQLite in regards to native non case-sensitive UNICODE text comparison and especially the use of the LIKE operator which has been crippled.

Read the rest of this entry »